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

Cloudera Open Source | Peter Hall | 6 years ago
  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 | 5 years ago | bejoy ks
    java.io.IOException: ORA-00933: SQL command not properly ended
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    ChunkedInputStream in JRE 1.4.x

    Oracle Community | 1 decade ago | 843798
    java.io.IOException: missing CR
  5. 0

    java.io.IOException: missing CR

    Oracle Community | 1 decade ago | 843798
    java.io.IOException: missing CR

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    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