Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop >> mail # user >> JDBC4 Mysql data exception on unsigned BIGINT column


Copy link to this message
-
JDBC4 Mysql data exception on unsigned BIGINT column
I know this isn't pertaining only to sqoop, but it is what I use to
import data into hive and I keep getting this error because data is
out of range of a signed bigint.  Any help/pointer is appreciated

2013-08-02 12:45:38,028 ERROR
org.apache.sqoop.mapreduce.db.DBRecordReader: Top level exception:

com.mysql.jdbc.exceptions.jdbc4.MySQLDataException:
'18446744073709551615' in column '15' is outside valid range for the
datatype BIGINT.
                              at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
                              at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
                              at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
                              at
java.lang.reflect.Constructor.newInstance(Constructor.java:513)
                              at
com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
--
-- JChan
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB