; > UDF to cast it to an array, without any schema. But I don't think any
> good,
> > generic Json UDFs will support that for your case.
> >
> > Yong
> >
> >> Date: Mon, 7 Apr 2014 16:47:44 -0700
> >> Subject: Re: get_json_object for nested field
; generic Json UDFs will support that for your case.
>
> Yong
>
>> Date: Mon, 7 Apr 2014 16:47:44 -0700
>> Subject: Re: get_json_object for nested field returning a String instead
>> of an Array
>> From: knarayana...@gmail.com
>> To: user@hive.apache.org
>
>&g
for nested field returning a String instead of
> an Array
> From: knarayana...@gmail.com
> To: user@hive.apache.org
>
> Thanks Peyman.
>
> Actually the problem with Hive-Json-Serde is that we need to provide
> the entire schema upfront while creating the table.
>
> My requir
Thanks Peyman.
Actually the problem with Hive-Json-Serde is that we need to provide
the entire schema upfront while creating the table.
My requirement is that we just project/aggregate on the fields using
get_json_object after creating the external table without schema. This
way the external tabl
perhaps: https://github.com/rcongiu/Hive-JSON-Serde
On Mon, Apr 7, 2014 at 6:52 PM, Narayanan K wrote:
> Hi all
>
> I am using get_json_object to read a json text file. I have created
> the external table as below :
>
> CREATE EXTERNAL TABLE EXT_TABLE ( json string)
> PARTITIONED BY (dt string)
Hi all
I am using get_json_object to read a json text file. I have created
the external table as below :
CREATE EXTERNAL TABLE EXT_TABLE ( json string)
PARTITIONED BY (dt string)
LOCATION '/users/abc/';
The json data has some fields that are not simple fields but fields
which are nested fields
