Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> JSON data to HIVE table


Copy link to this message
-
Re: JSON data to HIVE table
 
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]
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB