Fix column here means you have to define the table using SerDe in advance.
If you have new columns added to the json, the table has to be changed.
Create a table only have a column, such as value. Each row is line of json.
Then use the jason tuple UDF to parcer the json on the fly
On Fri, Jun 5, 2
What is the meaning of fix column...does it mean non-nested columns?
So I decided to use the UDF ...
But I am still struggling with a command to create a table Is it
necessary to use String datatype...even if I have integersand how do I
specify the nested data typeslike the following .
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
wrote:
> you can either pursuit the approaches from the others (reading the whole
> table with JSON Input Format) or you read the File
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
bes
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
Yes you will need to import the jar file. I don’t think it comes with the hive
by default.
From: Ayazur Rehman [mailto:rehman.ayazu...@gmail.com]
Sent: Friday, June 05, 2015 9:58 AM
To: user@hive.apache.org
Subject: Re: Reading Json files in hive
Hi Gary,
Thanks for the response.
I tried
x27;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: Readin
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
,
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 Jso
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 :
> Hi,
>
> Can someone tell me how to read Json file in hive
> My Hive
10 matches
Mail list logo
