My Oracle Support Banner

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

Last updated on APRIL 08, 2020

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 a Hive table using the ExternalTable tool fails with below error:

oracle.hadoop.exttab.ExternalTableException: Hive error: default.<HIVE_TABLE> 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_TABLE> table does exist.

> hive
Logging initialized using configuration in file:/etc/hive/conf.dist/hive-log4j.properties
Hive history file= <PATH>/<HISTORY_FILE>
hive> desc <HIVE_TABLE>;
OK
<COL1>   int
<COL2>   string
<COL3>   timestamp
Time taken: 18.717 seconds

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.