[ https://issues.apache.org/jira/browse/FLINK-15395?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17335429#comment-17335429 ]
Leonard Xu edited comment on FLINK-15395 at 4/29/21, 12:43 PM: --------------------------------------------------------------- After introduce `executeSql()` in FLINK-16366, it supports both DDL and DML and with more clear behavior. was (Author: leonard xu): After introduce `executeSql()` in FLINK-16366, it supports both DDL and DML and with more clear behaivor. > No API for execute insert into statement > ----------------------------------------- > > Key: FLINK-15395 > URL: https://issues.apache.org/jira/browse/FLINK-15395 > Project: Flink > Issue Type: Improvement > Components: Table SQL / API > Affects Versions: 1.10.0 > Reporter: Jeff Zhang > Priority: Major > Labels: stale-major > > IIUC, TableEnv#sqlUpdate is used for DDL & DML while TableEnv#sqlQuery is > used for select statement. Unfortunately, it seems `insert into` is a special > case that no simple api can be used for it. > The code of implementing `insert into` in sql-client is pretty complex, it > would be nice to have one simple api for executing `insert into` > https://github.com/apache/flink/blob/master/flink-table/flink-sql-client/src/main/java/org/apache/flink/table/client/gateway/local/LocalExecutor.java#L572 -- This message was sent by Atlassian Jira (v8.3.4#803005)