java.io.IOException: ORA-00933: SQL command not properly ended

incubator-sqoop-user | bejoy ks | 6 years ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    Re: Fw: Fw: [sqoop-user] sqoop import shows ORA-00933: SQL command notproperlyended error

    incubator-sqoop-user | 6 years ago | bejoy ks
    java.io.IOException: ORA-00933: SQL command not properly ended
  2. 0

    Attempting to perform a HBase import using Quest® Data Connector for Oracle and Hadoop (formerly known as Oraoop) causes an IOException. Cause appears to be use of DataDrivenDBInputFormat.class in HBaseImportJob initialisation instead of importContext.getInputFormat(). Will submit a patch once I've confirmed the cause. Stack trace follows. 11/05/19 12:23:46 ERROR tool.ImportTool: Encountered IOException running import job: java.io.IOException: ORA-00936: missing expression at com.cloudera.sqoop.mapreduce.db.DataDrivenDBInputFormat.getSplits(DataDrivenDBInputFormat.java:201) at org.apache.hadoop.mapred.JobClient.writeNewSplits(JobClient.java:944) at org.apache.hadoop.mapred.JobClient.writeSplits(JobClient.java:961) at org.apache.hadoop.mapred.JobClient.access$500(JobClient.java:170) at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:880) at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:833) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:396) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1115) at org.apache.hadoop.mapred.JobClient.submitJobInternal(JobClient.java:833) at org.apache.hadoop.mapreduce.Job.submit(Job.java:476) at org.apache.hadoop.mapreduce.Job.waitForCompletion(Job.java:506) at com.cloudera.sqoop.mapreduce.ImportJobBase.runJob(ImportJobBase.java:107) at com.cloudera.sqoop.mapreduce.ImportJobBase.runImport(ImportJobBase.java:166) at com.cloudera.sqoop.manager.SqlManager.importTable(SqlManager.java:386) at com.quest.oraoop.OraOopConnManager.importTable(OraOopConnManager.java:255) at com.cloudera.sqoop.tool.ImportTool.importTable(ImportTool.java:350) at com.cloudera.sqoop.tool.ImportTool.run(ImportTool.java:423) at com.cloudera.sqoop.Sqoop.run(Sqoop.java:144) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:79) at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:180) at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:218) at com.cloudera.sqoop.Sqoop.main(Sqoop.java:228)

    Cloudera Open Source | 6 years ago | Peter Hall
    java.io.IOException: ORA-00936: missing expression

    Root Cause Analysis

    1. java.io.IOException

      ORA-00933: SQL command not properly ended

      at com.cloudera.sqoop.mapreduce.db.DataDrivenDBInputFormat.getSplits()
    2. com.cloudera.sqoop
      DataDrivenDBInputFormat.getSplits
      1. com.cloudera.sqoop.mapreduce.db.DataDrivenDBInputFormat.getSplits(DataDrivenDBInputFormat.java:201)
      1 frame
    3. Hadoop
      JobClient$2.run
      1. org.apache.hadoop.mapred.JobClient.writeNewSplits(JobClient.java:944)
      2. org.apache.hadoop.mapred.JobClient.writeSplits(JobClient.java:961)
      3. org.apache.hadoop.mapred.JobClient.access$500(JobClient.java:170)
      4. org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:880)
      5. org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:833)
      5 frames
    4. Java RT
      Subject.doAs
      1. java.security.AccessController.doPrivileged(Native Method)
      2. javax.security.auth.Subject.doAs(Subject.java:396)
      2 frames
    5. Hadoop
      UserGroupInformation.doAs
      1. org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1127)
      1 frame
    6. Hadoop
      Job.waitForCompletion
      1. org.apache.hadoop.mapred.JobClient.submitJobInternal(JobClient.java:833)
      2. org.apache.hadoop.mapreduce.Job.submit(Job.java:476)
      3. org.apache.hadoop.mapreduce.Job.waitForCompletion(Job.java:506)
      3 frames
    7. com.cloudera.sqoop
      Sqoop.run
      1. com.cloudera.sqoop.mapreduce.ImportJobBase.runJob(ImportJobBase.java:107)
      2. com.cloudera.sqoop.mapreduce.ImportJobBase.runImport(ImportJobBase.java:166)
      3. com.cloudera.sqoop.manager.SqlManager.importQuery(SqlManager.java:419)
      4. com.cloudera.sqoop.tool.ImportTool.importTable(ImportTool.java:352)
      5. com.cloudera.sqoop.tool.ImportTool.run(ImportTool.java:423)
      6. com.cloudera.sqoop.Sqoop.run(Sqoop.java:144)
      6 frames
    8. Hadoop
      ToolRunner.run
      1. org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
      2. org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:79)
      2 frames
    9. com.cloudera.sqoop
      Sqoop.main
      1. com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:180)
      2. com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:218)
      3. com.cloudera.sqoop.Sqoop.main(Sqoop.java:228)
      3 frames