hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From yogesh dhari <>
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.


A = load '/Pig/000000_0' using PigStorage() 
(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
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.
Bejoy KS

Sent from handheld, please excuse typos.From:  yogesh dhari <>
Date: Thu, 11 Oct 2012 23:18:35 +0530To: hive request<>ReplyTo:
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