update RE: hive map field question

2012-01-11 Thread Chalcy Raja
ys of keys and values respectively. Let me know if you have any questions. Thanks, Chalcy From: Chalcy Raja [mailto:chalcy.r...@careerbuilder.com] Sent: Wednesday, November 23, 2011 1:20 PM To: user@hive.apache.org; 'Bejoy Ks' Subject: RE: hive map field question Wow, this is great news

RE: hive map field question

2011-11-23 Thread Chalcy Raja
Wow, this is great news. I read about explode and wished map had that. Thanks so much, Chalcy From: Bejoy Ks [mailto:bejoy...@yahoo.com] Sent: Wednesday, November 23, 2011 1:05 PM To: user@hive.apache.org Subject: Re: hive map field question Hi Chalcy Support for splitting a column of

Re: hive map field question

2011-11-23 Thread Bejoy Ks
,clmnMap_value; Hope it helps!... Regards Bejoy.K.S From: Mark Grover To: user@hive.apache.org Sent: Wednesday, November 23, 2011 9:55 PM Subject: Re: hive map field question Chalcy, I don't know of an existing UDF that lists all keys and values of a map. You

Re: hive map field question

2011-11-23 Thread Mark Grover
- Original Message - From: "Chalcy Raja" To: "user@hive.apache.org" Sent: Wednesday, November 23, 2011 11:14:09 AM Subject: RE: hive map field question Thanks, Mark. I'll try that. Also, is there a way to list all the keys and values in a map field? Thanks, Chal

RE: hive map field question

2011-11-23 Thread Chalcy Raja
Thanks, Mark. I'll try that. Also, is there a way to list all the keys and values in a map field? Thanks, Chalcy -Original Message- From: Mark Grover [mailto:mgro...@oanda.com] Sent: Wednesday, November 23, 2011 11:01 AM To: user@hive.apache.org Subject: Re: hive map field que

Re: hive map field question

2011-11-23 Thread Mark Grover
Hi Chalcy, You could write a UDF that takes in a Map object and returns you the string you need. Alternatively, you could use Hive Transform. Details here:https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Transform When a map gets passed to your custom transform script, you could