Explanation/Reference:
Setting Up the Hive Data Source
The following steps in Oracle Data Integrator are required for connecting to a Hive system.
To set up a Hive data source (see step 6 and 8):
1. Place all required Hive JDBC jars into the Oracle Data Integrator user lib folder:
$ HIVE_HOME/lib/*.jar
$ HADOOP_HOME/hadoop-*-core*.jar,
$ HADOOP_HOME/Hadoop-*-tools*.jar
2. Create a DataServer object under Hive technology.
3. Set the following locations under JDBC:
JDBC Driver: org.apache.hadoop.hive.jdbc.HiveDriver
JDBC URL: for example, jdbc:hive://BDA:10000/default
4. Set the following under Flexfields:
Hive Metastore URIs: for example, thrift://BDA:10000
5. Create a Physical Default Schema.
As of Hive 0.7.0, no schemas or databases are supported. Only Default is supported. Enter defaultin both schema fields of the physical schema definition.
6. Ensure that the Hive server is up and running.
7. Test the connection to the DataServer.
8. Create a Logical Schema object.
9. Create at least one Model for the LogicalSchema.
10. Import RKM Hive as a global KM or into a project.
11. Create a new model for Hive Technology pointing to the logical schema.
12. Perform a custom reverse using RKM Hive.
References: https://docs.oracle.com/cd/E27101_01/doc.10/e27365/odi.htm