Not Able To Run Column Based Select Hive Queries On Avro Formatted Data Set on CDH3

(Doc ID 1510846.1)

Last updated on MARCH 12, 2013

Applies to:

Big Data Appliance Integrated Software - Version 1.0.3 to 1.1.1 [Release 1.0 to 1.1]
Linux x86-64

Symptoms

Created a Hive table using Haivvreo Serde (com.linkedin.haivvreo) to read an Avro data file in CDH3 release. The table was created using the following DDL.

 The column based query such as "select transactionid  from avro_test limit 10;" fails through both hive command line and through Hue/Beeswax GUI interface.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms