RE: read a Hive Map without knowing keys

2014-03-18 Thread Frank Luo
To: user@hive.apache.org Subject: Re: read a Hive Map without knowing keys You can try to check other string udf's for that case, here https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF , they will be in the section on string functions. Thanks Szehon On Mon, Mar 17, 2014

Re: read a Hive Map without knowing keys

2014-03-18 Thread Szehon Ho
t;> >>> More dumb questions. What is "select *?" ? >>> >>> >>> >>> Also, any hints on how to find whether the map_keys contains a >>> substring? For example, supposing the map_keys contains emails, I want to >>&

Re: read a Hive Map without knowing keys

2014-03-18 Thread Lefty Leverenz
emails contains "gmail.com". >> >> >> >> *From:* Szehon Ho [mailto:sze...@cloudera.com] >> *Sent:* Monday, March 17, 2014 5:14 PM >> *To:* user@hive.apache.org >> *Subject:* Re: read a Hive Map without knowing keys >> >> >> >

Re: read a Hive Map without knowing keys

2014-03-18 Thread Szehon Ho
*From:* Szehon Ho [mailto:sze...@cloudera.com] > *Sent:* Monday, March 17, 2014 5:14 PM > *To:* user@hive.apache.org > *Subject:* Re: read a Hive Map without knowing keys > > > > Select *? There are other built-in functions like map_keys and map_values > you can use in quer

RE: read a Hive Map without knowing keys

2014-03-17 Thread Frank Luo
:sze...@cloudera.com] Sent: Monday, March 17, 2014 5:14 PM To: user@hive.apache.org Subject: Re: read a Hive Map without knowing keys Select *? There are other built-in functions like map_keys and map_values you can use in queries on maps. Not sure if this addresses the question. Thanks Szehon

Re: read a Hive Map without knowing keys

2014-03-17 Thread Szehon Ho
Select *? There are other built-in functions like map_keys and map_values you can use in queries on maps. Not sure if this addresses the question. Thanks Szehon On Mon, Mar 17, 2014 at 3:05 PM, Frank Luo wrote: > Is there a way to read Hive Map datatype without knowing keys? > > > > Accordi