My Oracle Support Banner

ODI-30038 Error Is Received When Attempting To Use LKM Hive to Oracle OLH-OSCH (Doc ID 2202268.1)

Last updated on AUGUST 17, 2020

Applies to:

Oracle Data Integrator - Version and later
Information in this document applies to any platform.


When attempting to load a simple Mapping from Hive to Oracle via LKM Hive to Oracle OLH-OSCH Direct.GLOBAL or LKM Hive to Oracle OLH-OSCH Direct, Oracle Data Integrator (ODI) is unable to create the proper code to use the Big Data connector.

For instance, when a Mapping is run in simulation mode, the reference to:

-libjars /opt/cloudera/parcels/CDH/lib/hive/lib/hive-exec.jar,/opt/cloudera/parcels/CDH/lib/hive/lib/hive-metastore.jar,/opt/cloudera/parcels/CDH/lib/hive/lib/libthrift-0.9.3.jar,/opt/cloudera/parcels/CDH/lib/hive/lib/libfb303-0.9.3.jar

... is missing, and the following error is received in execution mode:

ODI-1298: Serial task "SERIAL-MAP_MAIN- (40)" failed because child task "SERIAL-EU-Hive_STG_UNIT (50)" is in error.
ODI-1298: Serial task "SERIAL-EU-Hive_STG_UNIT (50)" failed because child task "Launch OLH-HiveOlhBaseLKM- (80)" is in error.
ODI-1590: The execution of the script failed.
Caused By: org.apache.bsf.BSFException: exception from Groovy: com.sunopsis.dwg.function.SnpsFunctionBaseException:
ODI-30038: OS command returned 1. Error details are [16/10/28 00:19:31 INFO loader.OraLoader: Oracle Loader for Hadoop Release 3.7.0 - Production





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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.