Hi Udit
3 years ago I extended the hive-JSON-serde to support maps and arrays. I think
I am the only user of this code, ☺
It still work for me today with hive 13
You can find my code here:
https://github.com/guydou/hive-json-serde
Using this serde you can declare a unique field also called json
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,
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
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
--
> *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
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
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
day, September 17, 2012 7:31 PM
>
> *To:* Connell, Chuck
> *Cc:* user@hive.apache.org
> *Subject:* Re: hive json serde
>
> ** **
>
> Thanks Chuck.
>
> I tried both json_tuple & get_json_objects on top of the serde table and
> it works too. I have nested jsons a
nell, Chuck
Cc: user@hive.apache.org
Subject: Re: hive json serde
Thanks Chuck.
I tried both json_tuple & get_json_objects on top of the serde table and it
works too. I have nested jsons and some of the keys do not have a specific
schema (You can throw whatever you want there) so if I want
u want to use get_json_object, you don't need to load a SerDe.
>
> - With a SerDe, Hive understands JSON fields natively, so you can just use
> the plain field names, no special function call at all.
>
> - I'm not sure if auxpath accepts a relative path, but I know the full
> path works.
>
&g
5:58 PM
To: Connell, Chuck
Cc: user@hive.apache.org
Subject: Re: hive json serde
It works now. Looks like there is a bug in the code.
if you do hive --auxpath ./serde then I get an error but if I get the full path
as
hive --auxpath /var/lib/hdfs/serde/ then get_json_object() works.
Thanks for
--
>> *From:* Mark Golden [mark.golden1...@gmail.com]
>> *Sent:* Monday, September 17, 2012 5:32 PM
>> *To:* Connell, Chuck
>> *Subject:* Re: hive json serde
>>
>> Hey Chuck,
>>
>> Where did you download the prebuild jar from?
>>
>&
; *
>
> ** **
>
> Chuck
>
> ** **
>
> ** **
>
> ** **
>
> *From:* Connell, Chuck [mailto:chuck.conn...@nuance.com]
> *Sent:* Monday, September 17, 2012 3:06 PM
> *To:* user@hive.apache.org
> *Subject:* RE: hive json serde
>
> ** **
>
> I just finished testing this o
I used his pre-built jar. No need to compile anything.
Be sure to add " --auxpath /path/to/jar/dir " to the Hive command line.
Chuck
From: Connell, Chuck [mailto:chuck.conn...@nuance.com]
Sent: Monday, September 17, 2012 3:06 PM
To: user@hive.apache.org
Subject: RE: hive json ser
I just finished testing this one. No problems found. The developer is also
quite responsive to issues raised. I encouraged him to submit it to the Hive
dev team as core code.
https://github.com/rcongiu/Hive-JSON-Serde/
Chuck Connell
Nuance R&D Data Team
Burlington, MA
From: Mark Golden [mail
15 matches
Mail list logo
