Re: Reading Json files in hive

[Ayazur Rehman]

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 <gcl...@neces.com> 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:fabian.woll...@zalando.de]
> *Sent:* Friday, June 05, 2015 9:38 AM
> *To:* user@hive.apache.org
> *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 <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
>
>
> [image: Image removed by sender.]
>
> *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