[
https://issues.apache.org/jira/browse/FLINK-15395?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17003486#comment-17003486
]
Jark Wu commented on FLINK-15395:
---------------------------------
{{sqlUpdate}} is used for DDL and DML, {{sqlQuery}} is used for queries which
returns a {{Table}}, this is similar to JDBC
{{PreparedStatement#executeUpdate()/executeQuery()}}.
> 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
>
> IIUC, TableEnv#sqlUpdate is used for DDL while TableEnv#sqlQuery is used for
> DML. 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)
