Error: Oracle SQL Connector for HDFS

joshua_adeleke — Wed, 04 Oct 2017 13:27:26 GMT

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)

Re: Error: Oracle SQL Connector for HDFS

joshua_adeleke — Thu, 12 Oct 2017 14:03:17 GMT

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.

question Re: Error: Oracle SQL Connector for HDFS in Archives of Support Questions (Read Only)

Error: Oracle SQL Connector for HDFS

Re: Error: Oracle SQL Connector for HDFS