Error: java.io.IOException: Can't export data, please check failed map task logs


    at org.apache.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:112)


    at org.apache.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:1)


    at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:146)


    at org.apache.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:64)


    at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:793)


    at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341)


    at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:177)


    at java.security.AccessController.doPrivileged(Native Method)


    at javax.security.auth.Subject.doAs(Subject.java:422)


    at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1893)


    at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:171)


Caused by: java.io.IOException: java.sql.SQLException: Incorrect string value: '\xF0\xA0\x88\x8C\xEF\xBC...' for column 'title' at row 54


    at org.apache.sqoop.mapreduce.AsyncSqlRecordWriter.write(AsyncSqlRecordWriter.java:220)


    at org.apache.sqoop.mapreduce.AsyncSqlRecordWriter.write(AsyncSqlRecordWriter.java:1)


    at org.apache.hadoop.mapred.MapTask$NewDirectOutputCollector.write(MapTask.java:664)


    at org.apache.hadoop.mapreduce.task.TaskInputOutputContextImpl.write(TaskInputOutputContextImpl.java:89)


    at org.apache.hadoop.mapreduce.lib.map.WrappedMapper$Context.write(WrappedMapper.java:112)


    at org.apache.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:84)


    ... 10 more


Caused by: java.sql.SQLException: Incorrect string value: '\xF0\xA0\x88\x8C\xEF\xBC...' for column 'title' at row 54


    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1094)


    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4208)


    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4140)


    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2597)


    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2758)


    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2826)


    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082)


    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1302)


    at org.apache.sqoop.mapreduce.AsyncSqlOutputFormat$AsyncSqlExecThread.run(AsyncSqlOutputFormat.java:233)



20/04/18 05:38:15 INFO mapreduce.Job:  map 50% reduce 0%


20/04/18 05:38:21 INFO mapreduce.Job:  map 75% reduce 0%


20/04/18 05:38:25 INFO mapreduce.Job: Task Id : attempt_1586760035227_342851_m_000001_1, Status : FAILED


Error: java.io.IOException: Can't export data, please check failed map task logs