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