com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 13.00.00.07] [Error 3706] [SQLState 42000] Syntax error: expected something between ')' and ','. * at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDatabaseSQLException(ErrorFactory.java:288)

incubator-sqoop-user | SRINIVAS SURASANI | 5 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Re: [sqoop-user] Sqoop-with Terradata

    incubator-sqoop-user | 5 years ago | SRINIVAS SURASANI
    com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 13.00.00.07] [Error 3706] [SQLState 42000] Syntax error: expected something between ')' and ','. * at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDatabaseSQLException(ErrorFactory.java:288)
  2. 0

    error -00904 when trying to load from teradata ... | Oracle Community

    oracle.com | 1 year ago
    com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 12.00.00.110] [Error 3707] [SQLState 42000] Syntax error, expected something like an 'UDFCALLNAME' keyword between '.' and the 'Dec' keyword.
  3. 0

    error -00904 when trying to load from teradata into oracle

    Oracle Community | 6 years ago | 787752
    com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 12.00.00.110] [Error 3707] [SQLState 42000] Syntax error, expected something like an 'UDFCALLNAME' keyword between '.' and the 'Dec' keyword.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. com.teradata.jdbc.jdbc_4.util.JDBCException

      [Teradata Database] [TeraJDBC 13.00.00.07] [Error 3706] [SQLState 42000] Syntax error: expected something between ')' and ','. * at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDatabaseSQLException(ErrorFactory.java:288)

      at com.teradata.jdbc.jdbc_4.statemachine.ReceiveInitSubState.action()
    2. com.teradata.jdbc
      TeraLocalConnection.prepareStatement
      1. com.teradata.jdbc.jdbc_4.statemachine.ReceiveInitSubState.action(ReceiveInitSubState.java:102)
      2. com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.subStateMachine(StatementReceiveState.java:285)
      3. com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.action(StatementReceiveState.java:176)
      4. com.teradata.jdbc.jdbc_4.statemachine.StatementController.runBody(StatementController.java:108)
      5. com.teradata.jdbc.jdbc_4.statemachine.StatementController.run(StatementController.java:99)
      6. com.teradata.jdbc.jdbc_4.Statement.executeStatement(Statement.java:331)
      7. com.teradata.jdbc.jdbc_4.Statement.prepareRequest(Statement.java:491)
      8. com.teradata.jdbc.jdbc_4.PreparedStatement.<init>(PreparedStatement.java:56)
      9. com.teradata.jdbc.jdbc_4.TDSession.createPreparedStatement(TDSession.java:689)
      10. com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalPreparedStatement.<init>(TeraLocalPreparedStatement.java:84)
      11. com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalConnection.prepareStatement(TeraLocalConnection.java:327)
      12. com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalConnection.prepareStatement(TeraLocalConnection.java:148)
      12 frames
    3. com.cloudera.sqoop
      AsyncSqlRecordWriter.write
      1. com.cloudera.sqoop.mapreduce.ExportOutputFormat$ExportRecordWriter.getPreparedStatement(ExportOutputFormat.java:142)
      2. com.cloudera.sqoop.mapreduce.AsyncSqlRecordWriter.execUpdate(AsyncSqlRecordWriter.java:146)
      3. com.cloudera.sqoop.mapreduce.AsyncSqlRecordWriter.write(AsyncSqlRecordWriter.java:212)
      3 frames