hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From yogesh dhari <yogeshdh...@live.com>
Subject RE: Need Help in Hive storage format
Date Fri, 12 Oct 2012 09:27:07 GMT

Thanks Bejoy,

Now I want to store theses rows in Pig.

like 

A = load '/Pig/000000_0' using PigStorage() 
as 
(id:INT, name:chararray, ddate, prim, ignore, ignorecase, activat);

What should be in the delimiter into PigStorage( )?  
I have tried PigStorage('/001') but its showing errors.
What delimiter should we use.

Please help and Suggest.

Thanks & Regards
Yogesh Kumar





Subject: Re: Need Help in Hive storage format
To: user@hive.apache.org
From: bejoy_ks@yahoo.com
Date: Thu, 11 Oct 2012 17:53:12 +0000




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