One nice way to do this stuff is using a special SERDE, possible like the
JsonSerde:
A simpler scenario, where you have to load a multidelimiter CSV file, can
be addressed using the RegexSerde : which maps columns to each group
matching.
In your case, the JsonSerde could be used essentially to ma
: Tuesday, January 7, 2014 3:54 AM
Subject: Re: JSON data to HIVE table
Also, if you have large or dynamic schemas which are a pain to write by hand,
you can use this simple tool:
https://github.com/strelec/hive-serde-gen
2014/1/7 Roberto Congiu
Also https://github.com/rcongiu/Hive-JSON-Serde
Also, if you have large or dynamic schemas which are a pain to write by
hand, you can use this simple tool:
https://github.com/strelec/hive-serde-gen
2014/1/7 Roberto Congiu
> Also https://github.com/rcongiu/Hive-JSON-Serde ;)
>
>
> On Mon, Jan 6, 2014 at 12:00 PM, Russell Jurney
> wrote:
>
>
Also https://github.com/rcongiu/Hive-JSON-Serde ;)
On Mon, Jan 6, 2014 at 12:00 PM, Russell Jurney wrote:
> Check these out:
>
>
> http://hortonworks.com/blog/discovering-hive-schema-in-collections-of-json-documents/
>
> http://hortonworks.com/blog/howto-use-hive-to-sqlize-your-own-tweets-part-t
Check these out:
http://hortonworks.com/blog/discovering-hive-schema-in-collections-of-json-documents/
http://hortonworks.com/blog/howto-use-hive-to-sqlize-your-own-tweets-part-two-loading-hive-sql-queries/
https://github.com/kevinweil/elephant-bird
On Mon, Jan 6, 2014 at 9:36 AM, Raj Hadoop wr
