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 <yogeshdh...@live.com> 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: 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 +0530 > To: 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 > >
