Re: Hive query result in sequence file

2012-02-01 Thread Mark Grover 
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

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 aniket...@gmail.comwrote:

 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.comwrote:

 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