hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Felix.徐 <>
Subject How to change the separator of input reocrd in TRANSFORM of Hive
Date Fri, 24 May 2013 03:10:04 GMT
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'
AS (id,name)

I find that the separator of input is TAB instead of '\0' ,
does anyone know how to change it to '\0'? Thanks.

View raw message