hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Roberto Congiu <>
Subject Re: JsonSerde usage help
Date Fri, 29 Jul 2011 17:21:52 GMT
I think the struct for a struct is correct (you can see in
ObjectInspectorUtils.getStandardStructTypeName() how it is built).

If you're using this serde:,
it just doesn't support structs.

Try the one I wrote here (compiled binary under 'downloads'):

it does support structs, even nested like yours.

On Thu, Jul 28, 2011 at 11:59 PM, Ayon Sinha <> wrote:

> Hi All,
> I can't find any reasonable documentation about being able to use Serde's.
> I have a JSONSerde which I use to create an external table
> create external table scratch.json_serde_test (user_id bigint, details
> struct<request_type: int, more_details: struct<id :bigint> > ) row format
> serde 'org.apache.hadoop.hive.contrib.serde2.JsonSerde' location
> '/user/ayon/jsonserde_test';
> I can't get any select query to work. What is the syntax for select inside
> a struct?
> -Ayon
> See My Photos on Flickr <>
> Also check out my Blog for answers to commonly asked questions.<>

View raw message