java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

sqoop-user | Abraham Elmahrek | 1 year ago
  1. 0

    Re: sqoop export query error out..

    sqoop-user | 1 year ago | Abraham Elmahrek
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  2. 0

    Apache Hadoop user mailing list

    gmane.org | 1 year ago
    java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
  3. 0

    Can't import or eval from Oracle database

    sqoop-user | 2 years ago | Tony Burton
    java.sql.SQLSyntaxErrorException: ORA-00911: invalid character
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    RE: Oracle Import Error Using --direct Option

    sqoop-user | 1 year ago | David Robson
    java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  6. 0

    RE: Oracle Import Error Using --direct Option

    sqoop-user | 1 year ago | David Robson
    java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

  1. rafafviola 1 times, last 4 weeks ago
  2. wendellpereira 128 times, last 2 months ago
  3. balintn 4 times, last 2 months ago
  4. balintn 3 times, last 3 months ago
  5. pnaranja 2 times, last 4 months ago
1 more registered users
30 unregistered visitors
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.sql.SQLSyntaxErrorException

    ORA-00942: table or view does not exist

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeQuery
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886)
    9. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)
    12. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3657)
    13. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)
    13 frames
  3. org.apache.sqoop
    Sqoop.run
    1. org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:750)
    2. org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:759)
    3. org.apache.sqoop.manager.SqlManager.getColumnInfoForRawQuery(SqlManager.java:269)
    4. org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:240)
    5. org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:226)
    6. org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:295)
    7. org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1833)
    8. org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1645)
    9. org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:96)
    10. org.apache.sqoop.tool.ExportTool.exportTable(ExportTool.java:64)
    11. org.apache.sqoop.tool.ExportTool.run(ExportTool.java:100)
    12. org.apache.sqoop.Sqoop.run(Sqoop.java:143)
    12 frames
  4. Hadoop
    ToolRunner.run
    1. org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
    1 frame
  5. org.apache.sqoop
    Sqoop.main
    1. org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
    2. org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
    3. org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
    4. org.apache.sqoop.Sqoop.main(Sqoop.java:236)
    4 frames