[
https://issues.apache.org/jira/browse/FLINK-15395?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jeff Zhang updated FLINK-15395:
-------------------------------
Description:
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
was:
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
> 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 & 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)
