Re: How to query UNION types in Hive with Avro

2014-08-11 Thread Sachin Goyal
gt; Reply-To: "user@hive.apache.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Date: Monday, August 11, 2014 at 12:14 PM To: "user@hive.apache.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Subject: Re: How to query UN

Re: How to query UNION types in Hive with Avro

2014-08-11 Thread hadoop hive
Hi Sachin, Here is the doc from hwk, this might help you. http://docs.hortonworks.com/HDPDocuments/HDP1/HDP-1.2.2/ds_Hive/language_manual/datatypes.html#LanguageManualTypes-UnionTypes Thanks Vikas Srivastava On Aug 12, 2014 12:31 AM, "Sachin Goyal" wrote: > Hi, > > I am using Hive and Avro wi

How to query UNION types in Hive with Avro

2014-08-11 Thread Sachin Goyal
Hi, I am using Hive and Avro with union types as follows: hive> desc tbl1; productid uniontype,struct> from deserializer hive> select productid from tbl1; {1:{"productid":"34","itemid":null}} hive> select productid.productid from tbl1 FAILED: SemanticException [Error 10042]: L