Error in Metadata/Execution Error Raised Creating a Hive Table Backed by Avro Data Files on Oracle Big Data Appliance V1.1 (Doc ID 1503377.1)

Last updated on MARCH 12, 2013

Applies to:

Big Data Appliance Integrated Software - Version 1.0.3 and later
Linux x86-64

Symptoms

Creating a Hive table backed by Avro data files raises, "Error in metadata" and "Execution Error" in versions of CDH prior to CDH3u5/CDH4 as in the output below:

FAILED: Error in metadata: Cannot validate serde: org.apache.hadoop.hive.serde2.avro.AvroSerDe
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

 

The following sample code demonstrates the problem:

 

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