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 roberto.con...@openx.com
Also https://github.com/rcongiu/Hive-JSON-Serde ;)
On Mon, Jan 6, 2014 at 12:00 PM, Russell
All,
If I have to load JSON data to a Hive table (default record format while
creating the table) - is that a requirement to convert each JSON record into
one line.
How would I do this ?
Thanks,
Raj
From: Rok Kralj rok.kr...@gmail.com
To: user
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
Hi,
I am trying to load a data that is in JSON format to Hive table. Can any one
suggest what is the method I need to follow?
Thanks,
Raj
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
Also https://github.com/rcongiu/Hive-JSON-Serde ;)
On Mon, Jan 6, 2014 at 12:00 PM, Russell Jurney russell.jur...@gmail.comwrote:
Check these out:
http://hortonworks.com/blog/discovering-hive-schema-in-collections-of-json-documents/