Andrew, This might come in handy: http://www.congiu.com/node/7
Mark Grover, Business Intelligence Analyst OANDA Corporation www: oanda.com www: fxtrade.com e: mgro...@oanda.com "Best Trading Platform" - World Finance's Forex Awards 2009. "The One to Watch" - Treasury Today's Adam Smith Awards 2009. ----- Original Message ----- From: "jingjung Ng" <jingjun...@gmail.com> 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 archieving this ? -Andrew On Wed, Jan 25, 2012 at 12:12 AM, Aniket Mokashi < aniket...@gmail.com > wrote: 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 < jingjun...@gmail.com > wrote: 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, value: address and phone). Is this possible, if so how could I do this ? Thank you. JingJung -- "...:::Aniket:::... Quetzalco@tl"
