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?