具体情况没有复现出来,瞎改改好了,主要是太菜了。
具体情况为:关联维表时报的错,所以我就专门读取维表进行了打印
CREATE TABLE `dim_area` (" +
" `district_id` int," +
" `pid` int," +
" `district` string," +
" `level` int," +
" PRIMARY KEY (`district_id`) NOT ENFORCED" +
") with(" +
"'connector' = 'jdbc'," +
"'url' = 'jdbc:mysql://hadoop104:3306/xxx?useSSL=false'," +
"'table-name' = 'dim_area'," +
"'driver' = 'com.mysql.jdbc.Driver'," +
"'username' = 'root'," +
"'password' = '123456')
具体修改方式就是改了改mysql表中的数据类型就改好了,应该是mysql表中有tyint类型,这个应该是flink1.11的bug,flinksql 就算写tyint相同的类型也是有问题的