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...@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
<yogeshdh...@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
