Error: Oracle SQL Connector for HDFS

[#1]

I am encountering an error while testing OSCH. I have the same hadoop version (2.7.3 which is HDP 2.6.0) installed on Oracle and my HDP boxes. Don't know if anyone has come across this issue...

Oracle SQL Connector for HDFS Release 3.6.0 - Production


Copyright (c) 2011, 2016, Oracle and/or its affiliates. All rights reserved.


[Enter Database Password:]
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/app/oracle/hadoop/hadoop-2.7.3/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/app/oracle/hive/apache-hive-2.1.1-bin/lib/log4j-slf4j-impl-2.4.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
17/10/04 08:21:52 INFO conf.HiveConf: Found configuration file file:/app/oracle/hadoop/hadoop-2.7.3/etc/hadoop/hive-site.xml
Exception in thread "main" java.lang.NoSuchMethodError: org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(Lorg/apache/hadoop/hive/conf/HiveConf;Lorg/apache/hadoop/hive/metastore/HiveMetaHookLoader;)V
        at oracle.hadoop.utils.HiveUtils.newHiveMetaStoreClient(HiveUtils.java:133)
        at oracle.hadoop.exttab.hive.HiveSource.initialize(HiveSource.java:201)
        at oracle.hadoop.exttab.hive.HiveSource.isPartitioned(HiveSource.java:310)
        at oracle.hadoop.exttab.ExternalTable.doCreateTable(ExternalTable.java:2318)
        at oracle.hadoop.exttab.ExternalTable.run(ExternalTable.java:3400)
        at oracle.hadoop.exttab.ExternalTable.run(ExternalTable.java:3481)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
        at oracle.hadoop.exttab.ExternalTable.main(ExternalTable.java:3594)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.apache.hadoop.util.RunJar.run(RunJar.java:221)
        at org.apache.hadoop.util.RunJar.main(RunJar.java:136)

[#2 · Accepted solution]

This error was resolved by re-copying the Hive folder to the node where Oracle was running and specifying the new path to Hive in the Hadoop Classpath.