java.io.IOException: ORA-00936: missing expression

Cloudera Open Source | Peter Hall | 6 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 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
  2. 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

    Root Cause Analysis

    1. java.io.IOException

      ORA-00936: missing expression

      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:1115)
      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
      SqlManager.importTable
      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.importTable(SqlManager.java:386)
      3 frames
    8. com.quest.oraoop
      OraOopConnManager.importTable
      1. com.quest.oraoop.OraOopConnManager.importTable(OraOopConnManager.java:255)
      1 frame
    9. com.cloudera.sqoop
      Sqoop.run
      1. com.cloudera.sqoop.tool.ImportTool.importTable(ImportTool.java:350)
      2. com.cloudera.sqoop.tool.ImportTool.run(ImportTool.java:423)
      3. com.cloudera.sqoop.Sqoop.run(Sqoop.java:144)
      3 frames
    10. 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
    11. 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