godfrey he created FLINK-16367:
----------------------------------
Summary: Introduce createDmlBatch method in TableEnvironment
Key: FLINK-16367
URL:
https://issues.apache.org/jira/browse/FLINK-16367 Project: Flink
Issue Type: Sub-task
Components: Table SQL / API
Reporter: godfrey he
Fix For: 1.11.0
As we deprecates {{execute}} method and {{explain}} method because of buffering SQLs/Tables execution problem. This issue aims to introduce a new method named createDmlBatch to support executing and explaining the batching queries.
The method likes like:
{code:java}
interface TableEnvironment {
/**
* Create a DmlBatch instance which can add dml statements or Tables to the batch,
* the planner can optimize all added statements and Tables together for better performance.
*/
DmlBatch createDmlBatch();
}
interface DmlBatch {
/**
* add insert statement to the batch.
*/
void addInsert(String insert);
/**
* add Table with the given sink table name to the batch.
*/
void addInsert(String targetPath, Table table);
/**
* execute all statements and Tables as a batch.
*
* The added statements and Tables will be cleared when this method.
*/
ResultTable execute() throws Exception;
/**
* returns the AST and the execution plan to compute the result of the all statements and Tables.
*
* @param extended if the plan should contain additional properties. e.g. estimated cost, traits
*/
String explain(boolean extended);
}
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)