Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
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]

NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB