mysqldatatruncation专题

坑惨了!flink执行sql语句时,出现com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE

出现错误! Data truncation: Truncated incorrect DOUBLE value: '2018-10-18 19:21:47' Flink操作mysql数据库对数据进行更新时。 原始sql语句: update t_lianlu_utilization_alarm set cancle_time=? and recevicetime=? where device

sqoop export时报错com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column

1.现象 sqoop导出到mysql时报错java.io.IOException: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column ‘goods_name’ at row 1 at Error: java.io.IOException: Can't export data, please