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
+
yogesh dhari 2012-10-12, 09:27
Copy link to this message
-
Re: Need Help in Hive storage format
Hi Yogesh:

I think this may help.

https://pig.apache.org/docs/r0.10.0/api/org/apache/pig/builtin/PigStorage.html

Miao

On Fri, Oct 12, 2012 at 5:27 PM, yogesh dhari <[EMAIL PROTECTED]> wrote:
> 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 +0530
> To: 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
>
>
+
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