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.woll...@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.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 > -- Thanks, Will
