hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Grover <>
Subject Re: Hive query result in sequence file
Date Wed, 01 Feb 2012 15:54:00 GMT
This might come in handy:

Mark Grover, Business Intelligence Analyst
OANDA Corporation 

www: www: 

"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" <>
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 ? 


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. 


On Tue, Jan 24, 2012 at 11:41 PM, jingjung Ng < > wrote: 


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. 


"...:::Aniket:::... Quetzalco@tl" 

View raw message