Transferring Exadata Data To Hive In BDA Fails on Creating External Table

(Doc ID 2310230.1)

Last updated on SEPTEMBER 22, 2017

Applies to:

Oracle Loader for Hadoop - Version 3.1.0 and later
Information in this document applies to any platform.

Symptoms

BDA version V5
CDH version 5.8.3

add jars /opt/cloudera/parcels/BIGDATASQL-3.1.0/lib/orahivedp.jar;
add jars /opt/cloudera/parcels/BIGDATASQL-3.1.0/lib/oraloader.jar;
add jars /opt/cloudera/parcels/BIGDATASQL-3.1.0/lib/ojdbc7.jar;
add jars /opt/cloudera/parcels/BIGDATASQL-3.1.0/lib/orai18n.jar;
add jars /opt/cloudera/parcels/BIGDATASQL-3.1.0/lib/ora-hadoop-common.jar;
add jars /opt/cloudera/parcels/BIGDATASQL-3.1.0/lib/oracle-hadoop-sql.jar;

then execute the command

CREATE EXTERNAL TABLE export_meter_300
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 '/user/oracle/mytest';

The error received is:
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. oracle.hadoop.loader.lib.DPMetadata.createDPMetadata(Ljava/lang/String;)Loracle/hadoop/loader/lib/DPMetadata;

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