Transferring Exadata Data To Hive In BDA Fails on Creating External Table
(Doc ID 2310230.1)
Last updated on JANUARY 03, 2020
Applies to:
Oracle Loader for Hadoop - Version 3.1.0 and laterInformation 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
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 |