Re: Nested JSON Parsing

2016-11-12 Thread Ajay Tirpude
I got it. We can use Python and Jruby. On Sun, Nov 13, 2016 at 12:35 PM, Ajay Tirpude wrote: > Hi Satya, > > Thanks I have already started checking JSON Serde. Lets see if it works. > By the way can we write UDFs in Python/Ruby? > > Regards, > Ajay T > > On Sun, Nov 13, 2016 at 12:30 PM, Satya H

Re: Nested JSON Parsing

2016-11-12 Thread Ajay Tirpude
Hi Satya, Thanks I have already started checking JSON Serde. Lets see if it works. By the way can we write UDFs in Python/Ruby? Regards, Ajay T On Sun, Nov 13, 2016 at 12:30 PM, Satya Harish Appana < satyaharish.app...@gmail.com> wrote: > You can use these > > *Json Serde: *https://github.com/r

Re: Nested JSON Parsing

2016-11-12 Thread Satya Harish Appana
You can use these *Json Serde: *https://github.com/rcongiu/Hive-JSON-Serde or else you can write a hive udtf, (Eg: http://beekeeperdata.com/posts/hadoop/2015/07/26/Hive-UDTF-Tutorial.html) On Sun, Nov 13, 2016 at 12:22 PM, Ajay Tirpude wrote: > Hi Dudu, > > I want to parse my json file and g

Re: Nested JSON Parsing

2016-11-12 Thread Ajay Tirpude
Hi Dudu, I want to parse my json file and get the desired output in csv file that I pasted in the output section. Currently I am able to achieve this using bash(jq command) but that is not an answer for json files that are in TBs. So I am looking for a solution in PIG or HIVE. Regards, Ajay T On

RE: Nested JSON Parsing

2016-11-12 Thread Markovitz, Dudu
And your issue/question is? From: Ajay Tirpude [mailto:tirpudeaj...@gmail.com] Sent: Sunday, November 13, 2016 4:46 AM To: user@hive.apache.org Subject: Nested JSON Parsing Dear All, I am trying to parse this json file given below and my intention is to convert this json file into a csv. { "