Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive, mail # user - Need Help in Hive storage format


+
yogesh dhari 2012-10-11, 17:48
+
Bejoy KS 2012-10-11, 17:53
Copy link to this message
-
RE: Need Help in Hive storage format
yogesh dhari 2012-10-12, 09:27

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: [EMAIL PROTECTED]
From: [EMAIL PROTECTED]
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 <[EMAIL PROTECTED]>
Date: Thu, 11 Oct 2012 23:18:35 +0530To: hive request<[EMAIL PROTECTED]>ReplyTo:  [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
         
+
MiaoMiao 2012-10-12, 09:50
+
Abhishek 2012-10-12, 12:47
+
yogesh dhari 2012-10-12, 13:02