Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Who agreed with this topic

Sqoop Error table does not contain any data, but table is populated with data


Hi All,


A week ago my Sqoop jobs randomly stopped working. They stopped pulling data and when I would run the job manually to debug I get the following result


16/08/25 18:11:31 INFO mapreduce.ImportJobBase: Transferred 48 bytes in 26.6693 seconds (1.7998 bytes/sec)
16/08/25 18:11:31 INFO mapreduce.ImportJobBase: Retrieved 0 records.


These tables are still populated. When I created a new table populated with data to see if I could pull that table in, I get the following error:


16/08/25 12:25:23 FATAL oracle.OraOopDataDrivenDBInputFormat: The table GV_OPEN_CURSOR_TEST does not contain any data. 16/08/25 12:25:23 INFO mapreduce.JobSubmitter: Cleaning up the staging area /user/mrice/.staging/job_1471956835422_0035 16/08/25 12:25:23 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.RuntimeException: The table GV_OPEN_CURSOR_TEST does not contain any data. java.lang.RuntimeException: The table GV_OPEN_CURSOR_TEST does not contain any data. at at org.apache.hadoop.mapreduce.JobSubmitter.writeNewSplits( at org.apache.hadoop.mapreduce.JobSubmitter.writeSplits( at org.apache.hadoop.mapreduce.JobSubmitter.submitJobInternal( at org.apache.hadoop.mapreduce.Job$ at org.apache.hadoop.mapreduce.Job$ at Method) at at at org.apache.hadoop.mapreduce.Job.submit( at org.apache.hadoop.mapreduce.Job.waitForCompletion( at org.apache.sqoop.mapreduce.ImportJobBase.doSubmitJob( at org.apache.sqoop.mapreduce.ImportJobBase.runJob( at org.apache.sqoop.mapreduce.ImportJobBase.runImport( at org.apache.sqoop.manager.SqlManager.importTable( at at org.apache.sqoop.tool.ImportTool.importTable( at at at at org.apache.sqoop.Sqoop.runSqoop( at org.apache.sqoop.Sqoop.runTool( at org.apache.sqoop.Sqoop.runTool( at org.apache.sqoop.Sqoop.main(


Does anybody have experience with this? Below is my sqoop command:


sqoop import --connect jdbc:oracle:thin:@server1:1521/serverprod --username HDP --password-file /user/mrice/audpw.txt --table OPEN_CURSOR --target-dir /data/audit/tempfiles/OPEN_CURSOR --fields-terminated-by '\t' --num-mappers 20 --compression-codec --delete-target-dir --compress --direct



Who agreed with this topic