Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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

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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB