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 <[email protected]> To: [email protected] 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 <[email protected]> Also https://github.com/rcongiu/Hive-JSON-Serde ;) > > > >On Mon, Jan 6, 2014 at 12:00 PM, Russell Jurney <[email protected]> >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 <[email protected]> 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 [email protected] datasyndrome.com > > > >-- >---------------------------------------------------------- >Good judgement comes with experience. >Experience comes with bad judgement. > >---------------------------------------------------------- > >Roberto Congiu - Data Engineer - OpenX >tel: +1 626 466 1141 -- eMail: [email protected]
