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
> 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.