Oracle SQL Connector for Hadoop Distributed File System (HDFS) fails with Hive Error Table Not Found (Doc ID 1558053.1)

Last updated on OCTOBER 11, 2016

Applies to:

Oracle SQL Connector for Hadoop Distributed File System - Version 2.0 and later
Linux x86-64

Symptoms

Using Oracle SQL Connector for Hadoop Distributed File System (OSCH) while trying to create an Oracle external table from Hive table using the ExternalTable tool fails with below error:

oracle.hadoop.exttab.ExternalTableException: Hive error: default.hive_tab table not found
        at oracle.hadoop.exttab.hive.HiveSource.initialize(HiveSource.java:161)
        at oracle.hadoop.exttab.hive.HiveSource.getDataSet(HiveSource.java:329)
        at oracle.hadoop.exttab.ExternalTable.doCreateTable(ExternalTable.java:1261)
        at oracle.hadoop.exttab.ExternalTable.run(ExternalTable.java:1552)
        at oracle.hadoop.exttab.ExternalTable.run(ExternalTable.java:1621)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
        at oracle.hadoop.exttab.ExternalTable.main(ExternalTable.java:1719)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.hadoop.util.RunJar.main(RunJar.java:208)

 

Checking in Hive shows that the hive_tab tables does exist.

> hive
Logging initialized using configuration in file:/etc/hive/conf.dist/hive-log4j.properties
Hive history file=/tmp/oracle/hive_job_log_oracle_201305301429_1496092725.txt
hive> desc hive_tab;
OK
ncol1   int
scol2   string
dcol3   timestamp
Time taken: 18.717 seconds

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms