Not able to create Oracle table using Big Data Connector

[#1]

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?

[#2 · Accepted solution]

was able to create external tables using the OSCH. Issue was that the hadoop distribution used was downloaded from apache. This was resolved by shipping the hdp distribution in "/usr" to the oracle node and issue was resolved.