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

Reply via email to