Dolphinscheduler调度sql任务建表时The query did not generate a result set异常解决

Dolphinscheduler调度sql任务建表时The query did not generate a result set异常解决 Dolphinscheduler调度sql任务建表时报execute sql error: The query did not generate a result set!异常

登录worker机器查询详细日志
execute sql error: The query did not generate a result set!
[ERROR] 2021-11-12 16:18:44.889 - [taskAppId=TASK-4-34-58]:[170] - sql task error: java.sql.SQLException: The query did not generate a result set!
[ERROR] 2021-11-12 16:18:44.890 org.apache.dolphinscheduler.server.worker.runner.TaskExecuteThread:[149] - task scheduler failure
java.sql.SQLException: The query did not generate a result set!
at org.apache.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:435)
看到DS调用的是executeQuery命令。立刻想到应该是没有设置“非查询”
回到任务节点设置，将sql类型修改为"非查询"