Re: Hive Avro union data access

2014-06-03 Thread Fastupload
Sathish, Curent version Hive ONLY support union type has two primitive/struct types, i.e.. {“name”: “alias_host”, “type”: [ “string”, “null” ]} , or {“name”: “alias_host”, “type”: [{“type”: “array”, “items”: “string”]}, “null”}. You can consider JSON string as a column type when the column has s

RE: Hive Avro union data access

2014-05-30 Thread java8964
explode lateral view" of hive. Yong From: sathish.vall...@emc.com To: user@hive.apache.org Subject: Hive Avro union data access Date: Fri, 30 May 2014 06:21:19 + Hi, I have an Hive table created with 3 different union data types for alias_host column name as shown. (array,string,

Hive Avro union data access

2014-05-29 Thread Valluri, Sathish
Hi, I have an Hive table created with 3 different union data types for alias_host column name as shown. (array,string, null). CREATE EXTERNAL TABLE array_tests ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe' WITH SERDEPROPERTIES ('avro.schema.literal'='{"name":"sessions",

Hive Avro union data access

2014-05-29 Thread Valluri, Sathish
Hi, I have an Hive table created with 3 different union data types for alias_host column name as shown. (array,string, null). CREATE EXTERNAL TABLE array_tests ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe' WITH SERDEPROPERTIES ('avro.schema.literal'='{"name":"session

Hive Avro union data access

2014-05-29 Thread Valluri, Sathish
Hi, I have an Hive table created with 3 different union data types for alias_host column name as shown. (array,string, null). CREATE EXTERNAL TABLE array_tests ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe' WITH SERDEPROPERTIES ('avro.schema.literal'='{"name":"sessions",

Hive Avro union data access

2014-05-29 Thread Valluri, Sathish
Hi, I have an Hive table created with 3 different union data types for alias_host column name as shown. (array,string, null). CREATE EXTERNAL TABLE array_tests ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe' WITH SERDEPROPERTIES ('avro.schema.literal'='{"name":"sessions","t