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 >> Need Help in Hive storage format


Copy link to this message
-
Re: Need Help in Hive storage format
Hi Yogesh.

It should be a simple delimited file with ^A character as the field delimiter.

Regards
Bejoy KS

Sent from handheld, please excuse typos.

-----Original Message-----
From: yogesh dhari <[EMAIL PROTECTED]>
Date: Thu, 11 Oct 2012 23:18:35
To: hive request<[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Subject: Need Help in Hive storage format
Hi all,

If we run this query

insert overwrite local directory '/home/yogesh/Downloads/demoyy' select * from NYSE_LOCAL;

{
( describe NYSE_LOCAL ;

 exchange    string    
symbol    string    
ddate    string    
open    float    
high    float    
low    float    
) }

ls /home/yogesh/Downloads/demoyy/

it shows the file name 000000_0

my Question is:

1) In which format does file 000000_0 is?
2) what is the delimiter between columns?

Please help

Thanks & Regards
Yogesh Kumar
     
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