Yes you will need to import the jar file. I don’t think it comes with the hive by default.
From: Ayazur Rehman [mailto:[email protected]] Sent: Friday, June 05, 2015 9:58 AM To: [email protected] Subject: Re: Reading Json files in hive Hi Gary, Thanks for the response. I tried creating a simple json table - create table jsonTable(id string, type string) row format serde 'org.apache.hadoop.hive.contrib.serde2.JsonSerde'; And I got the following error- Cannot validate serde: org.apache.hadoop.hive.contrib.serde2.JsonSerde Do I need to add an external library for this? My Hive version is - 0.14 On Fri, Jun 5, 2015 at 10:39 AM, Gary Clark <[email protected]<mailto:[email protected]>> wrote: CREATE EXTERNAL TABLE IF NOT EXISTS sampledata ( id string, type string, label string, realpoweroutput string, realpowerdemand string, reactivepoweroutput string, kvarpowerdemand string, averagesoc string, date string ) ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.JsonSerde' LOCATION '/user/hdfs/testdir/'; From: Wollert, Fabian [mailto:[email protected]<mailto:[email protected]>] Sent: Friday, June 05, 2015 9:38 AM To: [email protected]<mailto:[email protected]> Subject: Re: Reading Json files in hive 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 <[email protected]<mailto:[email protected]>>: 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<tel:%2B1%20720%20917%208540> -- Fabian Wollert Business Intelligence [Image removed by sender.] POSTAL ADDRESS Zalando SE 11501 Berlin OFFICE Zalando SE Mollstraße 1 10178 Berlin Germany Phone: +49 30 20968 1819<tel:%2B49%2030%2020968%201819> Fax: +49 30 27594 693<tel:%2B49%2030%2027594%20693> E-Mail: [email protected]<mailto:[email protected]> Web: www.zalando.de<http://www.zalando.de> Jobs: jobs.zalando.de<http://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
