My Oracle Support Banner

How To Setup Veridata Agent To Access Hive? (Doc ID 2447238.1)

Last updated on OCTOBER 03, 2018

Applies to:

Oracle GoldenGate Veridata - Version 12.2.1.2.0 and later
Information in this document applies to any platform.

Symptoms

After setting up Veridata agent to access hive Hadoop, we see the following errors captured here;

 


[VERIAGT-BOOT] INFO Looking for home directory.
[VERIAGT-BOOT] INFO Found bootstrap class in file:/data/veridata_agent/veridata/agent/JavaAgent.jar!/com/goldengate/veridata/agent/Bootstrap.class.
[VERIAGT-BOOT] INFO Home directory: /data/veridata_agent/veridata/agent
[VERIAGT-BOOT] INFO Preparing classpath.
[VERIAGT-BOOT] INFO Driver location: /data/ogg_agent/drivers
[VERIAGT-BOOT] INFO Drivers to load: /usr/lib/sqoop/lib/ojdbc6.jar /usr/lib/hive/lib/hive-jdbc-1.1.0-cdh5.13.1-standalone.jar /usr/lib/hive/lib/hive-jdbc-1.1.0-cdh5.13.1.jar /usr/lib/hive/lib/hive-jdbc-standalone.jar /usr/lib/hive/lib/hive-jdbc.jar
[VERIAGT-BOOT] WARN /usr/lib/sqoop/lib/ojdbc6.jar was not found. Skipping...
[VERIAGT-BOOT] WARN /usr/lib/hive/lib/hive-jdbc-1.1.0-cdh5.13.1-standalone.jar was not found. Skipping...
[VERIAGT-BOOT] WARN /usr/lib/hive/lib/hive-jdbc-1.1.0-cdh5.13.1.jar was not found. Skipping...
[VERIAGT-BOOT] WARN /usr/lib/hive/lib/hive-jdbc-standalone.jar was not found. Skipping...
[VERIAGT-BOOT] WARN /usr/lib/hive/lib/hive-jdbc.jar was not found. Skipping...
[VERIAGT-BOOT] INFO Classpath:
[VERIAGT-BOOT] INFO /data/veridata_agent/veridata/agent/JavaAgent.jar
[VERIAGT-BOOT] INFO /data/veridata_agent/veridata/agent/agent-manifest.jar
[VERIAGT-BOOT] INFO Initializing.
[VERIAGT-BOOT] INFO Invoking startup method: public static void com.goldengate.veridata.agent.VeridataAgent.main(java.lang.String[])
2018-06-28 19:05:28.457 INCIDENT_ERROR Exception stack trace


Asa you can see, we have read access to the respective jar.


[oggusr@ogg_agent]$ ls -ltr /usr/lib/hive/lib/hive-jdbc-1.1.0-cdh5.13.1-standalone.jar
-rw-r--r-- 1 root root 24079689 Nov 9 2017 /usr/lib/hive/lib/hive-jdbc-1.1.0-cdh5.13.1-standalone.jar

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


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