Home | About | Sematext search-lucene.com search-hadoop.com
 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
Raj Hadoop 2014-01-07, 20:12
 
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]