Unable to create hive external table for the oracle .dmp files received from oracle team which they had generated in data pump format.
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/to/HDFS/directory';
FAILED: SemanticException Cannot find class 'oracle.hadoop.hive.datapump.DPInput
So, basically need an external table in hive for the oracle .dmp files provided which carries all the table related data and metadata along with it.
Oracle provides Big Data Appliance (BDA) softwares, if you install BDA on your hadoop environment, it will support the following Input format. Not sure BDA is available for free
Note: Unless you have proper knowledge on BDA, i will not recommend you to install it on your hadoop environment.
May be you can use Custom format from the below link (or) any other alternate
By default hive supports only the file formats available in the below link (depends upon your hive version)