https://community.cloudera.com/t5/Archives-of-Support-Questions/Not-able-to-create-Oracle-table-using-Big-Data-Connector/m-p/219703#M69603 <P>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.</P><P>Has anyone successfully used the OSCH to create external tables?</P> Fri, 13 Oct 2017 17:20:43 GMT joshua_adeleke 2017-10-13T17:20:43Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Not-able-to-create-Oracle-table-using-Big-Data-Connector/m-p/219703#M69603 <P>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.</P><P>Has anyone successfully used the OSCH to create external tables?</P> Fri, 13 Oct 2017 17:20:43 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Not-able-to-create-Oracle-table-using-Big-Data-Connector/m-p/219703#M69603 joshua_adeleke 2017-10-13T17:20:43Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Not-able-to-create-Oracle-table-using-Big-Data-Connector/m-p/219704#M69604 <P>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.</P> Mon, 30 Oct 2017 14:05:40 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Not-able-to-create-Oracle-table-using-Big-Data-Connector/m-p/219704#M69604 joshua_adeleke 2017-10-30T14:05:40Z