bug如下:
Exception in thread "main" org.apache.flink.table.api.TableException:
toAppendStream doesn't support consuming update and delete changes which is produced by
node Join(joinType=[LeftOuterJoin], where=[(leftxxx = rightxxx)], select=[xxx, xxx, xxx, xxx, xxx, xxx, xxx], leftInputSpec=[NoUniqueKey], rightInputSpec=[NoUniqueKey])
代码是执行一个table join语句:
Table table = table2.leftOuterJoin(table3, "leftxxx = rightxxx")
.select("xxx,xxx,xxx,xxx,xxx,xxx");
最后输出结果到控制台:
tEnv.toAppendStream(table, Row.class).print("res");
这个结果table是由节点联接产生的,toAppendStream不支持消费更新和删除更改
故改成:
tEnv.toRetractStream(tableCTNR, Row.class).print("res");
他的结果是带有一个Boolean标志的的数组,true表示添加数据,false表示撤回