My Oracle Support Banner

Creating a Hive External Table Using a Data Pump Format on HDP Fails with "FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. oracle/hadoop/utils/DBUtils" (Doc ID 2363126.1)

Last updated on FEBRUARY 28, 2018

Applies to:

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

Symptoms

After installing Big Data SQL (BDS) 3.2 on a Hortonworks Data Platform(HDP) environment and creating a Hive external table using a Data Pump format as described in the Big Data SQL User's Guide Appendix A.1 Generating the Data Pump Files an execution error is thrown as below:

hive> CREATE EXTERNAL TABLE tablename
> 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 'hdfs_directory'
> ;
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. oracle/hadoop/utils/DBUtils



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


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