Hello,
I am using sqoop 1.4.6 and would like to replicate data from oracle by using
Oraoop however i encountered problems.
Here is my command.
sqoop import -Doraoop.import.partitions='date_insert' --direct --connect
$CONNSTR --username $USERNAME -password-file $PASSWD_FILE --table
APP.APPLICATION --hcatalog-database APP --hcatalog-table APPLICATION -m 5
--verbose
The error shows below.
ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.RuntimeException: The
table APPLICATION does not contain any data.
java.lang.RuntimeException: The table APPLICATION does not contain any data.
at
org.apache.sqoop.manager.oracle.OraOopDataDrivenDBInputFormat.getSplits(OraOopDataDrivenDBInputFormat.java:108)
at
org.apache.hadoop.mapreduce.JobSubmitter.writeNewSplits(JobSubmitter.java:305)
at
org.apache.hadoop.mapreduce.JobSubmitter.writeSplits(JobSubmitter.java:322)
at
org.apache.hadoop.mapreduce.JobSubmitter.submitJobInternal(JobSubmitter.java:200)
at org.apache.hadoop.mapreduce.Job$10.run(Job.java:1307)
at org.apache.hadoop.mapreduce.Job$10.run(Job.java:1304)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:415)
at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1920)
at org.apache.hadoop.mapreduce.Job.submit(Job.java:1304)
at org.apache.hadoop.mapreduce.Job.waitForCompletion(Job.java:1325)
at
org.apache.sqoop.mapreduce.ImportJobBase.doSubmitJob(ImportJobBase.java:203)
at
org.apache.sqoop.mapreduce.ImportJobBase.runJob(ImportJobBase.java:176)
at
org.apache.sqoop.mapreduce.ImportJobBase.runImport(ImportJobBase.java:273)
at org.apache.sqoop.manager.SqlManager.importTable(SqlManager.java:692)
at
org.apache.sqoop.manager.oracle.OraOopConnManager.importTable(OraOopConnManager.java:288)
at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:514)
at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:622)
at org.apache.sqoop.Sqoop.run(Sqoop.java:147)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:243)
at org.apache.sqoop.Sqoop.main(Sqoop.java:252)
If i remove parameter -Doraoop.import.partitions='date_insert' it worked fine,
or remove --direct it also worked.
The table is NOT clustered table which should be supported by oracle.
Do you know why this happens?
