My Oracle Support Banner

The External Table Created By Oracle SQL Connector for Hadoop Distributed File System (OSCH) Fails to Display Data. (Doc ID 1558334.1)

Last updated on JUNE 04, 2013

Applies to:

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

Symptoms


The HDFS data located in the path specified by value of the oracle.hadoop.exttab.dataPaths are not being attached to Oracle external table.. The message "/opt/oracle/orahdfs-2.1.0/jlib/orahdfs.jar is not a regular file" or "OSCH_HOME is not set" is being displayed when select is executed against the external table.

 

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
References


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