RE: Hive JSON Serde question

2015-01-26 Thread Martin, Nick
Hi Ari, Please send an email to user-unsubscr...@hive.apache.org<mailto:user-unsubscr...@hive.apache.org> Thanks! Nick From: Ari Flink [mailto:flinks...@gmail.com] Sent: Monday, January 26, 2015 1:30 PM To: user@hive.apache.org Subject: Re: Hive JSON Serde question unsubscribe On Sun,

Re: Hive JSON Serde question

2015-01-26 Thread Ari Flink
Subramanian < > sanjaysubraman...@yahoo.com> > *Sent:* Sunday, January 25, 2015 4:45 PM > *Subject:* Re: Hive JSON Serde question > > Try get_json_object UDF. No iterations need. :) > > > > On Mon, Jan 26, 2015 at 12:25 AM, Sanjay Subramanian < > sanjaysubraman...@yahoo

Re: Hive JSON Serde question

2015-01-25 Thread Sanjay Subramanian
sure will try get_json_objectthank uregardssanjay   From: 丁桂涛(桂花) To: user@hive.apache.org; Sanjay Subramanian Sent: Sunday, January 25, 2015 4:45 PM Subject: Re: Hive JSON Serde question Try get_json_object UDF. No iterations need. :) On Mon, Jan 26, 2015 at 12:25 AM, Sanjay

Re: Hive JSON Serde question

2015-01-25 Thread 丁桂涛(桂花)
-- > *From:* Edward Capriolo > *To:* "user@hive.apache.org" ; Sanjay Subramanian < > sanjaysubraman...@yahoo.com> > *Sent:* Sunday, January 25, 2015 8:11 AM > *Subject:* Re: Hive JSON Serde question > > Nested lists require nested lateral vie

Re: Hive JSON Serde question

2015-01-25 Thread Sanjay Subramanian
Thanks Ed. Let me try a few more iterations. Somehow I am not doing this correctly :-)  regards sanjay From: Edward Capriolo To: "user@hive.apache.org" ; Sanjay Subramanian Sent: Sunday, January 25, 2015 8:11 AM Subject: Re: Hive JSON Serde question Nested lists requ

Re: Hive JSON Serde question

2015-01-25 Thread Edward Capriolo
Nested lists require nested lateral views. On Sun, Jan 25, 2015 at 11:02 AM, Sanjay Subramanian < sanjaysubraman...@yahoo.com> wrote: > hey guys > > This is the Hive table definition I have created based on the JSON > I am using this version of hive json serde > https://github.com/rcongiu/Hive-JS

Hive JSON Serde question

2015-01-25 Thread Sanjay Subramanian
hey guys  This is the Hive table definition I have created based on the JSON I am using this version of hive json serde https://github.com/rcongiu/Hive-JSON-Serde ADD JAR /home/sanjay/mycode/jar/jsonserde/json-serde-1.3.1-SNAPSHOT-jar-with-dependencies.jar;DROP TABLE IF EXISTS  datafeed_json;C