My Oracle Support Banner

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 APRIL 08, 2020

Applies to:

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


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


NOTE: In the examples that follow, user details, table name, company name, email, hostnames, etc. represent a fictitious sample (and are used to provide an illustrative example only). Any similarity to actual persons, or entities, living or dead, is purely coincidental and not intended in any manner.

The following sample code demonstrates the problem:



To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.