I have built an ODI mapping that uses an HDFS source table and is suppose to store this data (without transformation) in an Oracle database table. I am getting the following error when I try to run the mapping. The error occurs before the session will even start.
ODIKM-HIVE-10012: Unsupported source technology used! Only Hive and File are supported. at HiveOlhBaseLKM.setBinding(LKM_File_to_Oracle_OLHOSCH_create_class.groovy:1842)
Please check the Validation Results window for more information
Note: There is no other information in the Validation results window.
I have created Hadoop, HDFS, and Oracle data servers and all the necessary components to build the mapping. My test of the Hadoop and Oracle connection was successful. The mapping validation was successful with a warning, 'Dataset Default contains only one source.'
My system configurations are:
ODI Server: Linux 3.8.13-44.1.1.el6uek.x86_64
DB Server: Linux 4.1.12-61.1.22.el6uek.x86_64
Database: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
ODI: Data Integrator Version 12.2.1 Build ODI_12.2.1.2.6_GENERIC_161202.0826
The hadoop cluster is CDH5.7.0.
The ODI agent is Java EE, although the test of connections is successful with the agent or as Local (No Agent).
The following packages have been loaded and configured according to the documentation:
ohsh-1.1.0.zip
od4h-1.2.0.0.zip
oraosch-3.6.0.zip
oraloader-3.7.0.x86_64.zip
fmw_12.2.1.2.0_infrastructure_Disk1_1of1.zip
I have tried using LKM_File_to_Oracle_OLHOSCH_Direct and LKM_File_to_Oracle_OLH-OSCH . The documentation states that these are to be used with HDFS Files or Hives.
Any help would be appreciated.