hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bejoy KS" <>
Subject Re: Need Help in Hive storage format
Date Thu, 11 Oct 2012 17:53:12 GMT
Hi Yogesh. 

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

Bejoy KS

Sent from handheld, please excuse typos.

-----Original Message-----
From: yogesh dhari <>
Date: Thu, 11 Oct 2012 23:18:35 
To: hive request<>
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


View raw message