Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - Text file with ctrl chat as delimiter


Copy link to this message
-
Text file with ctrl chat as delimiter
Sam William 2012-06-19, 23:15
Hi,
  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 .  

Thanks
Sam William
[EMAIL PROTECTED]