原因是读取mysql中Timestamp类型字段时,如果数值为空值会以0000-00-00 00:00:00 格式填充,导致格式转换错误
解决方式:在jdbc后面添加?zeroDateTimeBehavior=convertToNull
String driverClass = "com.mysql.jdbc.Driver";
String dbUrl = "jdbc:mysql://localhost:3306/test?zeroDateTimeBehavior=convertToNull";
String userNmae = "xxxx";
String passWord = "xxxx";
String sql = "select * from test";
ExecutionEnvironment env = ExecutionEnvironment.getExecutionEnvironment();