sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "王斌" <496838...@qq.com>
Subject replicate data using Oraoop
Date Fri, 04 May 2018 09:07:43 GMT
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?
Mime
View raw message