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.ayazu...@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.woll...@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
