Re: Hive query result in sequence file

2012-02-01 Thread Mark Grover
easury Today's Adam Smith Awards 2009. - Original Message - From: "jingjung Ng" To: user@hive.apache.org Sent: Wednesday, January 25, 2012 1:47:12 PM Subject: Re: Hive query result in sequence file Thanks Aniket. I am pretty new to hive, any java example (serde) for archiev

Re: Hive query result in sequence file

2012-01-25 Thread jingjung Ng
Thanks Aniket. I am pretty new to hive, any java example (serde) for archieving this ? -Andrew On Wed, Jan 25, 2012 at 12:12 AM, Aniket Mokashi wrote: > You will have to do your own serde.. > > Hive can write it sequencefile but it will be Text with NULL(bytewritable) > key. > > Thanks, > Anik

Re: Hive query result in sequence file

2012-01-25 Thread Aniket Mokashi
You will have to do your own serde.. Hive can write it sequencefile but it will be Text with NULL(bytewritable) key. Thanks, Aniket On Tue, Jan 24, 2012 at 11:41 PM, jingjung Ng wrote: > Hi, > > I have following hive query (pseudo hive query code) > > select name, address, phone from t1 join

Hive query result in sequence file

2012-01-24 Thread jingjung Ng
Hi, I have following hive query (pseudo hive query code) select name, address, phone from t1 join t2 Executing above query will end up file stored in the format of name, address, phone format on the fie system (hdfs or local). However I'd like to write to either to a sequence file (key: name,