hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Wollert, Fabian" <fabian.woll...@zalando.de>
Subject Re: Reading Json files in hive
Date Fri, 05 Jun 2015 14:38:27 GMT
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

Mime
View raw message