How to query UNION types in Hive with Avro

[Sachin Goyal]

Hi,

I am using Hive and Avro with union types as follows:


hive> desc tbl1;

productid         
uniontype<void,struct<productid:string,itemid:bigint>,struct<circularrefid:int>>
 from deserializer



hive> select productid from tbl1;

{1:{"productid":"34","itemid":null}}



hive> select productid.productid from tbl1

FAILED: SemanticException [Error 10042]: Line 1:7 . Operator is only supported 
on struct or list of struct types 'productid'



Does anyone know how to use the union-types inside a select query?


Thanks

Sachin