you can either pursuit the approaches from the others (reading the whole table with JSON Input Format) or you read the File with normal Input Format and STRING Datatype and then apply the function i mentioned afterwards. Both Approaches work, i usually use mine. I don't know though which one is best for performance.
Cheers Fabian 2015-06-05 17:03 GMT+02:00 Ayazur Rehman <rehman.ayazu...@gmail.com>: > Hi Fabian, > > The documentation only points to how to run some queries with json format > table and I could not find the documentation for creating a Json Table. Did > I miss something in the documentation? > I apologize if my question was not clear. > Thanks > > 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 >> > > > > -- > 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