java.io.IOException: SQLException in nextKeyValue

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

Samebug tips

,
Expert tip

MySQL doesn't support some types of characters (such as emojis) with the utf8 encoding. You need to be on MySQL 5.5+ and force utf8mb4 (everywhere, client and server). You can do this sending the query "SET NAMES utf8mb4". Check this https://goo.gl/3E2qzg

Solutions on the web

via sqoop-user by Syed Akram, 4 months ago
SQLException in nextKeyValue
via sqoop-user by John Huang, 1 year ago
SQLException in nextKeyValue
via Stack Overflow by matmach
, 1 year ago
SQLException in nextKeyValue
via sqoop-user by John Huang, 1 year ago
SQLException in nextKeyValue
java.io.IOException: SQLException in nextKeyValue
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
at com.mysql.jdbc.ResultSetImpl.getLong(ResultSetImpl.java:3035)
at com.mysql.jdbc.ResultSetImpl.getLong(ResultSetImpl.java:2946)
at org.apache.sqoop.lib.JdbcWritableBridge.readLong(JdbcWritableBridge.java:62)
at com.cloudera.sqoop.lib.JdbcWritableBridge.readLong(JdbcWritableBridge.java:57)
at undefined.QueryResult.readFields(QueryResult.java:131)
at org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:244)
at org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.nextKeyValue(MapTask.java:533)
at org.apache.hadoop.mapreduce.task.MapContextImpl.nextKeyValue(MapContextImpl.java:80)
at org.apache.hadoop.mapreduce.lib.map.WrappedMapper$Context.nextKeyValue(WrappedMapper.java:91)
at org.apache.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:64)
at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:764)
at org.apache.hadoop.mapred.MapTask.run(MapTask.java:340)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:415)
at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1614)

Users with the same issue

3 times, 19 hours ago
16 times, 5 days ago
Once, 1 week ago
Once, 1 week ago
116 times, 1 week ago
164 more bugmates

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