-Text file with ctrl chat as delimiter
Sam William 2012-06-19, 23:15
I have a data file that is exactly equivalent to a CSV , except that the field delimiter is a control character specifically '\u0001' . How can I create an external table in hive for this data ?
For instance .
create table ... blah .blah ...
row format delimited fields terminated by '\u0001' stored as textfile location '/tmp/myloc';
did not work .
Mapred Learn 2012-06-20, 00:34
Mark Grover 2012-06-20, 13:24
Sam William 2012-06-20, 22:57
Mapred Learn 2012-06-21, 00:01
Sam William 2012-06-21, 19:01