Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> How to change the separator of input reocrd in TRANSFORM of Hive


Copy link to this message
-
Re: How to change the separator of input reocrd in TRANSFORM of Hive
Oh sorry , I find the solution on wiki:
https://cwiki.apache.org/Hive/languagemanual-transform.html by specifying
the inrowformat and outrowformat .
2013/5/24 Felix.徐 <[EMAIL PROTECTED]>

> Hi all,
>
> I am trying to use Transform in Hive, but I do not find a way to change
> the separator between fields of input records in Transform.
>
> I create a table A by specify ROW FORMAT DELIMITED FIELDS TERMINATED BY
> '\0'
>
> However, while using
> SELECT TRANSFORM(id,name) USING 'python script.py'
> AS (id,name)
> FROM A
>
> I find that the separator of input is TAB instead of '\0' ,
> does anyone know how to change it to '\0'? Thanks.
>