java.io.IOException: SQLException in nextKeyValue

Stack Overflow | Holmes | 7 months 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

    Sqoop import without split by

    Stack Overflow | 7 months ago | Holmes
    java.io.IOException: SQLException in nextKeyValue

    2 unregistered visitors

    Root Cause Analysis

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

      [Teradata Database] [TeraJDBC 14.00.00.01] [Error 3707] [SQLState 42000] Syntax error, expected something like a name or a Unicode delimited identifier between the word 'Record' and the 'Start' keyword.

      at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDatabaseSQLException()
    2. com.teradata.jdbc
      TDSession.prepareStatement
      1. com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDatabaseSQLException(ErrorFactory.java:307)
      2. com.teradata.jdbc.jdbc_4.statemachine.ReceiveInitSubState.action(ReceiveInitSubState.java:102)
      3. com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.subStateMachine(StatementReceiveState.java:298)
      4. com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.action(StatementReceiveState.java:179)
      5. com.teradata.jdbc.jdbc_4.statemachine.StatementController.runBody(StatementController.java:120)
      6. com.teradata.jdbc.jdbc_4.statemachine.StatementController.run(StatementController.java:111)
      7. com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:372)
      8. com.teradata.jdbc.jdbc_4.TDStatement.prepareRequest(TDStatement.java:541)
      9. com.teradata.jdbc.jdbc_4.TDPreparedStatement.<init>(TDPreparedStatement.java:96)
      10. com.teradata.jdbc.jdk6.JDK6_SQL_PreparedStatement.<init>(JDK6_SQL_PreparedStatement.java:21)
      11. com.teradata.jdbc.jdk6.JDK6_SQL_Connection.constructPreparedStatement(JDK6_SQL_Connection.java:76)
      12. com.teradata.jdbc.jdbc_4.TDSession.prepareStatement(TDSession.java:1491)
      12 frames
    3. org.apache.sqoop
      DBRecordReader.executeQuery
      1. org.apache.sqoop.mapreduce.db.DBRecordReader.executeQuery(DBRecordReader.java:101)
      1 frame