My Oracle Support Banner

Big Data SQL 3.0.1 "CREATE EXTERNAL TABLE" Raises: "FAILED: SemanticException Cannot find class 'oracle.hadoop.hive.datapump.DPInputFormat'" (Doc ID 2227983.1)

Last updated on JULY 26, 2021

Applies to:

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

Symptoms

Using Oracle BigData SQL 3.0.1 an Oracle Database 12.1.0.2.160719 (non-Exadata) can be used to access Hive tables on a non-BDA Hortonworks 2.4 cluster.  This can be done after configuring "Copy to Hadoop" using Big Data SQL 3.0: Installing and Configuring Copy to Hadoop on BDA 4.4 /Exadata (Doc ID 2115762.1).

After this "CREATE EXTERNAL TABLE" queries fails with an error like:

Error message :

$ hive
WARNING: Use "yarn jar" to launch YARN applications.

Logging initialized using configuration in file:/etc/hive/<PATH>/hive-log4j.properties
hive> CREATE EXTERNAL TABLE <TABLE_NAME>
> ROW FORMAT
> SERDE 'oracle.hadoop.hive.datapump.DPSerDe'
> STORED AS
> INPUTFORMAT 'oracle.hadoop.hive.datapump.DPInputFormat'
> OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
> LOCATION '<PATH>';
FAILED: SemanticException Cannot find class 'oracle.hadoop.hive.datapump.DPInputFormat'

 

Cause

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
Symptoms
Cause
Solution
References

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