I am able to run the -createTable command successfully using the Oracle SQL connector for HDFS (OSCH). However, the external table created in Oracle is empty as against the over 38M rows that exist in Hive. Not sure why this is happening and i've checked the few log files but there's really nothing meaningful in the logs. Has anyone successfully used the OSCH to create external tables? ... View more

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) ... View more