hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From DU DU <will...@gmail.com>
Subject Re: Reading Json files in hive
Date Fri, 05 Jun 2015 14:43:57 GMT
You can use json_tuple which has better performance as I remember as
follows. Your table should have single column to keep each line of Json
string.

select * from json_table
lateral view json_tuple(json_table_cloumn, 'columnA') val as columnA
...

On Fri, Jun 5, 2015 at 10:38 AM, Wollert, Fabian <fabian.wollert@zalando.de>
wrote:

> Hey Ayazur, please see here for doc's on how to read JSON in Hive:
>
>
> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-get_json_object
>
> Cheers
> Fabian
>
> 2015-06-05 16:30 GMT+02:00 Ayazur Rehman <rehman.ayazur90@gmail.com>:
>
>> Hi,
>>
>> Can someone tell me how to read Json file in hive
>> My Hive version is 0.14
>>
>> the schema is something like this-
>>
>> {"columnA": "some_string", "columnB": 227958.0, "columnC": [0.0, 0.0, 0.0, 0.0],
"columnD": {"some_string":10.0}}
>>
>> If there is documentation about it, please let me know as well
>>
>> --
>> Thanking You,
>> Ayazur Rehman
>> +1 720 917 8540
>>
>
>
>
> --
> *Fabian Wollert*
> Business Intelligence
>
>
>
> *POSTAL ADDRESS*
> Zalando SE
> 11501 Berlin
>
> *OFFICE*
> Zalando SE
> Mollstra├če 1
> 10178 Berlin
> Germany
>
> Phone: +49 30 20968 1819
> Fax:   +49 30 27594 693
> E-Mail: fabian.wollert@zalando.de
> Web: www.zalando.de
> Jobs: jobs.zalando.de
>
> Zalando SE, Tamara-Danz-Stra├če 1, 10243 Berlin
> Company registration: Amtsgericht Charlottenburg, HRB 158855 B
> Tax ID: 29/560/00596 * VAT registration number: DE 260543043
> Management Board: Robert Gentz, David Schneider, Rubin Ritter
> Chairperson of the Supervisory Board: Cristina Stenbeck
> Registered office: Berlinn
>



-- 
Thanks,
Will

Mime
View raw message