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

How to sqoop-export to a staging table with Data Connector for Oracle and Hadoop

Highlighted

How to sqoop-export to a staging table with Data Connector for Oracle and Hadoop

Explorer

I want to export data from a Hive (Hcatalog) Table to an Oracle database. For that purpose I am using sqoop with the Data Connector for Oracle and Hadoop (--direct Parameter). Since an export is not atomic in Sqoop I dont want to export the data into the target table directly. This is what the --staging-table Parameter in sqoop is for.

The Problem is, that you cannot use the --staging-table Parameter when using the Data connector for Oracle and Hadoop. Is there anothery way to do this in --direct mode?