Big Data SQL Access on Exadata to External Hive Tables Fails with: "KUP-11504: error from external driver: java.lang.NoSuchMethodError: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe.initSerdeParams" (Doc ID 2144189.1)

Last updated on JULY 08, 2016

Applies to:

Oracle Big Data SQL - Version 2.0 and later
Linux x86-64

Symptoms

On Exadata with Big Data SQL installed accessing a Hive external table fails with:

ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-11504: error from external driver: java.lang.NoSuchMethodError:
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe.initSerdeParams(Lorg/apache/h
adoop/conf/Configuration;Ljava/util/Properties;Ljava/lang/String;)Lorg/apache/ha
doop/hive/serde2/lazy/LazySimpleSerDe$SerDeParameters;

 

 Querying the underlying table from the Hive CLI succeeds on the BDA.

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