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@hive.apache.org Sent: 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 <roberto.con...@openx.com> Also https://github.com/rcongiu/Hive-JSON-Serde ;) > > > >On Mon, Jan 6, 2014 at 12:00 PM, Russell Jurney <russell.jur...@gmail.com> >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-two-loading-hive-sql-queries/ >> >>https://github.com/kevinweil/elephant-bird >> >> >> >> >>On Mon, Jan 6, 2014 at 9:36 AM, Raj Hadoop <hadoop...@yahoo.com> wrote: >> >>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 >> >> >> >>-- >>Russell Jurney twitter.com/rjurney russell.jur...@gmail.com datasyndrome.com > > > >-- >---------------------------------------------------------- >Good judgement comes with experience. >Experience comes with bad judgement. > >---------------------------------------------------------- > >Roberto Congiu - Data Engineer - OpenX >tel: +1 626 466 1141 -- eMail: rok.kr...@gmail.com
