com.mysql.jdbc.exceptions.jdbc4.MySQLDataException

'18385347166395843554' > in column '2' is outside valid range for the datatype BIGINT. at > org.apache.sqoop.mapreduce.db.DataDrivenDBInputFormat.getSplits(DataDrivenDBInputFormat.java:170) at > org.apache.hadoop.mapred.JobClient.writeNewSplits(JobClient.java:1024) at > org.apache.hadoop.mapred.JobClient.writeSplits(JobClient.java:1041)

Solutions on the web9

  • via sqoop-user by Jarek Jarcec Cecho, 9 months ago
    '18385347166395843554' > in column '2' is outside valid range for the datatype BIGINT. at > org.apache.sqoop.mapreduce.db.DataDrivenDBInputFormat.getSplits(DataDrivenDBInputFormat.java:170) at > org.apache.hadoop.mapred.JobClient.writeNewSplits(JobClient.java:1024) at > org.apache.hadoop.mapred.JobClient.writeSplits(JobClient.java:1041)
  • via sqoop-user by centerqi hu, 9 months ago
    '18385347166395843554' in column '2' is outside valid range for the datatype BIGINT.
  • '9223372036854776900' in column '10' is outside valid range for the datatype BIGINT.
  • Stack trace

    • com.mysql.jdbc.exceptions.jdbc4.MySQLDataException: '18385347166395843554' > in column '2' is outside valid range for the datatype BIGINT. at > org.apache.sqoop.mapreduce.db.DataDrivenDBInputFormat.getSplits(DataDrivenDBInputFormat.java:170) at > org.apache.hadoop.mapred.JobClient.writeNewSplits(JobClient.java:1024) at > org.apache.hadoop.mapred.JobClient.writeSplits(JobClient.java:1041) at org.apache.hadoop.mapred.JobClient.access$700(JobClient.java:179) at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:959) at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:912) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:396)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You are the first who have seen this exception. Write a tip to help other users and build your expert profile.