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)

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via sqoop-user by Jarek Jarcec Cecho, 1 year 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)
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 java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:396)

Users with the same issue

You are the first who have seen this exception.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.