Support Questions
Find answers, ask questions, and share your expertise

Error: Oracle SQL Connector for HDFS

Solved Go to solution

Error: Oracle SQL Connector for HDFS

Expert Contributor

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)


1 ACCEPTED SOLUTION

Accepted Solutions

Re: Error: Oracle SQL Connector for HDFS

Expert Contributor

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.

View solution in original post

1 REPLY 1

Re: Error: Oracle SQL Connector for HDFS

Expert Contributor

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.

View solution in original post