Support Questions
Find answers, ask questions, and share your expertise

Not able to create Oracle table using Big Data Connector

Solved Go to solution

Not able to create Oracle table using Big Data Connector

Expert Contributor

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?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Not able to create Oracle table using Big Data Connector

Expert Contributor

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.

View solution in original post

1 REPLY 1

Re: Not able to create Oracle table using Big Data Connector

Expert Contributor

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.

View solution in original post