I have a pig statement which works fine :
raw_data = LOAD '$input_path' USING PigStorage*('\u0002'*) AS ...And I am trying to use the corresponding hive QL : CREATE EXTERNAL TABLE tx_log(......) ROW FORMAT DELIMITED FIELDS TERMINATED BY *'\u0002'* STORED AS TEXTFILE LOCATION '/ip/data/tx_log_1'; This doesnt work. Any quick pointers on what should be the corresponding unicode representation ( for *'\u0002' ) * in hive ? -Prasen
