Hi Prasen,
this should work... (I use CTRL+A as delimiter)
hive> create table test_ea (col1 string) row format delimited fields terminated
by '\001' stored as textfile;
In your case, '\002' should work.
regards
Eric Arenas
________________________________
From: prasenjit mukherjee <pmukher...@quattrowireless.com>
To: hive-user <hive-user@hadoop.apache.org>
Sent: Tue, February 16, 2010 4:43:07 AM
Subject: Fields delimited by unicode chars
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
