Using Json serde requires you have fix column. In your case, you should consider using HIVE UDF mentioned above
On Fri, Jun 5, 2015 at 11:13 AM, Wollert, Fabian <fabian.woll...@zalando.de> wrote: > 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 > -- Thanks, Will
