hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bejoy KS" <bejoy...@yahoo.com>
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.

Regards
Bejoy KS

Sent from handheld, please excuse typos.

-----Original Message-----
From: yogesh dhari <yogeshdhari@live.com>
Date: Thu, 11 Oct 2012 23:18:35 
To: hive request<user@hive.apache.org>
Reply-To: user@hive.apache.org
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


 		 	   		  

Mime
View raw message