【Flink异常】No operators defined in streaming topology. Cannot generate StreamGraph

1. 异常详情

Exception in thread "main" java.lang.IllegalStateException: No operators defined in streaming topology. Cannot generate StreamGraph.
	at org.apache.flink.table.planner.utils.ExecutorUtils.generateStreamGraph(ExecutorUtils.java:47)
	at org.apache.flink.table.planner.delegation.StreamExecutor.createPipeline(StreamExecutor.java:47)
	at org.apache.flink.table.api.internal.TableEnvironmentImpl.execute(TableEnvironmentImpl.java:1197)

2. 报错代码（基于flink1.11版本）

EnvironmentSettings tableEnvSettings = EnvironmentSettings
            .newInstance()
            .useBlinkPlanner()
            .inBatchMode()
            .build();
            
TableEnvironment tableEnv = TableEnvironment.create(tableEnvSettings);

String sql = "……";
tableEnv.executeSql(sql);

tableEnv.execute(""); //该方法弃用

3. 原因及解决办法

Flink TableEnvironment 使用 executeSql() 方法已经执行了sql语句，不需要再使用execute()方法。运行execute()方法时，没有待执行的sql语句，因此会抛出此错误。

解决办法：删除tableEnv.execute();即可。

4. 同类型batch任务异常

异常详情：

Exception in thread "main" java.lang.RuntimeException: No new data sinks have been defined since the last execution. The last execution refers to the latest call to 'execute()', 'count()', 'collect()', or 'print()'.
	at org.apache.flink.api.java.ExecutionEnvironment.createProgramPlan(ExecutionEnvironment.java:1085)
	at org.apache.flink.api.java.ExecutionEnvironment.createProgramPlan(ExecutionEnvironment.java:1065)
	at org.apache.flink.api.java.ExecutionEnvironment.executeAsync(ExecutionEnvironment.java:962)
	at org.apache.flink.api.java.ExecutionEnvironment.execute(ExecutionEnvironment.java:889)
	at org.apache.flink.api.java.ExecutionEnvironment.execute(ExecutionEnvironment.java:873)

报错代码：

ExecutionEnvironment env = ExecutionEnvironment.getExecutionEnvironment();

List<Row> data = new ArrayList<>();
data.add(Row.of(1, "aaa"));
data.add(Row.of(2, "bbb"));
DataSet<Row> dataSet = env.fromCollection(data);

dataSet.print();
env.execute(); //这句删掉即可

报错原因：
Stream实时任务数据没有边界，需要env.execute()触发任务。而batch任务’execute()’, ‘count()’, ‘collect()’, or 'print()'都可以触发任务执行，因此当有print()时，不需要再加execute()了。