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)

sqoop-user | Jarek Jarcec Cecho | 3 years ago
  1. 0

    Re: sqoop mysql to hive's ---split-by bug

    sqoop-user | 3 years ago | Jarek Jarcec Cecho
    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)
  2. 0

    sqoop mysql to hive's ---split-by bug

    sqoop-user | 3 years ago | centerqi hu
    com.mysql.jdbc.exceptions.jdbc4.MySQLDataException: '18385347166395843554' in column '2' is outside valid range for the datatype BIGINT.
  3. 0

    Hibernate error from Projections.sum when sum too large for field's type

    Stack Overflow | 5 years ago | MillerM
    com.mysql.jdbc.exceptions.jdbc4.MySQLDataException: '12000010002048860160' in column '3' is outside valid range for the datatype BIGINT.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Tons of errors in console

    GitHub | 11 months ago | McLive
    com.mysql.jdbc.exceptions.jdbc4.MySQLDataException: '2.191519547E9' in column '1' is outside valid range for the datatype INTEGER.
  6. 0

    MySQLDataException

    GitHub | 3 years ago | mibby
    com.mysql.jdbc.exceptions.jdbc4.MySQLDataException: '330' in column '9' is outside valid range for the datatype TINYINT.

    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. 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()
    2. Hadoop
      JobClient$2.run
      1. org.apache.hadoop.mapred.JobClient.access$700(JobClient.java:179)
      2. org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:959)
      3. org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:912)
      3 frames
    3. Java RT
      Subject.doAs
      1. java.security.AccessController.doPrivileged(Native Method)
      2. javax.security.auth.Subject.doAs(Subject.java:396)
      2 frames