ORA-00933: SQL command not properly ended

incubator-sqoop-user | bejoy ks | 5 years ago
  1. 0

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

    incubator-sqoop-user | 5 years ago | bejoy ks 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: ORA-00936: missing expression at com.cloudera.sqoop.mapreduce.db.DataDrivenDBInputFormat.getSplits( at org.apache.hadoop.mapred.JobClient.writeNewSplits( at org.apache.hadoop.mapred.JobClient.writeSplits( at org.apache.hadoop.mapred.JobClient.access$500( at org.apache.hadoop.mapred.JobClient$ at org.apache.hadoop.mapred.JobClient$ at Method) at at at org.apache.hadoop.mapred.JobClient.submitJobInternal( at org.apache.hadoop.mapreduce.Job.submit( at org.apache.hadoop.mapreduce.Job.waitForCompletion( at com.cloudera.sqoop.mapreduce.ImportJobBase.runJob( at com.cloudera.sqoop.mapreduce.ImportJobBase.runImport( at com.cloudera.sqoop.manager.SqlManager.importTable( at at com.cloudera.sqoop.tool.ImportTool.importTable( at at at at at com.cloudera.sqoop.Sqoop.runSqoop( at com.cloudera.sqoop.Sqoop.runTool( at com.cloudera.sqoop.Sqoop.main(

    Cloudera Open Source | 6 years ago | Peter Hall ORA-00936: missing expression
  3. 0 Job failed! ORA-00933: sql command not properly ended , hadoop

    Stack Overflow | 2 years ago ORA-00933: sql command not properly ended
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    [~gagravarr] noticed that one of our old test files fails a Tika test now with PDFBox 1.8.7 and Java 1.6. I just tested the pure PDFBox app built with PDFBox 1.8.8-SNAPSHOT, and I'm getting the same exception with Java 1.6 and Java 1.7. Stacktrace: {noformat} ExtractText failed with the following exception: javax.crypto.BadPaddingException: Given final block not properly padded at javax.crypto.CipherInputStream.getMoreData( at at at org.apache.pdfbox.pdmodel.encryption.SecurityHandler.encryptData( at org.apache.pdfbox.pdmodel.encryption.SecurityHandler.decryptStream( at org.apache.pdfbox.pdmodel.encryption.SecurityHandler.decrypt( at org.apache.pdfbox.pdmodel.encryption.SecurityHandler.decryptObject( at org.apache.pdfbox.pdmodel.encryption.SecurityHandler.proceedDecryption( at org.apache.pdfbox.pdmodel.encryption.StandardSecurityHandler.decryptDocument( at org.apache.pdfbox.pdmodel.PDDocument.openProtection( at org.apache.pdfbox.ExtractText.startExtraction( at org.apache.pdfbox.ExtractText.main( at org.apache.pdfbox.PDFBox.main( Caused by: javax.crypto.BadPaddingException: Given final block not properly padded at com.sun.crypto.provider.CipherCore.doFinal( at com.sun.crypto.provider.CipherCore.doFinal( at com.sun.crypto.provider.AESCipher.engineDoFinal( at javax.crypto.Cipher.doFinal( at javax.crypto.CipherInputStream.getMoreData( ... 12 more {noformat} java version "1.7.0_71" OpenJDK Runtime Environment (rhel- u71-b14) OpenJDK 64-Bit Server VM (build 24.65-b04, mixed mode) and java version "1.6.0_33" OpenJDK Runtime Environment (IcedTea6 1.13.5) (rhel- OpenJDK 64-Bit Server VM (build 23.25-b01, mixed mode)

    Apache's JIRA Issue Tracker | 2 years ago | Tim Allison javax.crypto.BadPaddingException: Given final block not properly padded

    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


      ORA-00933: SQL command not properly ended

      at com.cloudera.sqoop.mapreduce.db.DataDrivenDBInputFormat.getSplits()
    2. com.cloudera.sqoop
      1. com.cloudera.sqoop.mapreduce.db.DataDrivenDBInputFormat.getSplits(
      1 frame
    3. Hadoop
      1. org.apache.hadoop.mapred.JobClient.writeNewSplits(
      2. org.apache.hadoop.mapred.JobClient.writeSplits(
      3. org.apache.hadoop.mapred.JobClient.access$500(
      4. org.apache.hadoop.mapred.JobClient$
      5. org.apache.hadoop.mapred.JobClient$
      5 frames
    4. Java RT
      1. Method)
      2 frames
    5. Hadoop
      1 frame
    6. Hadoop
      1. org.apache.hadoop.mapred.JobClient.submitJobInternal(
      2. org.apache.hadoop.mapreduce.Job.submit(
      3. org.apache.hadoop.mapreduce.Job.waitForCompletion(
      3 frames
    7. com.cloudera.sqoop
      1. com.cloudera.sqoop.mapreduce.ImportJobBase.runJob(
      2. com.cloudera.sqoop.mapreduce.ImportJobBase.runImport(
      3. com.cloudera.sqoop.manager.SqlManager.importQuery(
      4. com.cloudera.sqoop.tool.ImportTool.importTable(
      6 frames
    8. Hadoop
      2 frames
    9. com.cloudera.sqoop
      1. com.cloudera.sqoop.Sqoop.runSqoop(
      2. com.cloudera.sqoop.Sqoop.runTool(
      3. com.cloudera.sqoop.Sqoop.main(
      3 frames