[
https://issues.apache.org/jira/browse/FLINK-21465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jark Wu updated FLINK-21465:
----------------------------
Description:
Allow users to specify the ExplainDetails in statement.
{code:sql}
EXPLAIN [ExplainDetail[, ExplainDetail]*] <statement>
ExplainDetail: {
ESTIMATED_COST,
CHANGELOG_MODE,
JSON_EXECUTION_PLAN
}
{code}
Print the plan for the statement with specified ExplainDetails.
ESTIMATED_COST
generates cost information on physical node estimated by optimizer, e.g.
TableSourceScan(..., cumulative cost = {1.0E8 rows, 1.0E8 cpu, 2.4E9 io, 0.0
network, 0.0 memory})
CHANGELOG_MODE
generates changelog mode for every physical rel node. e.g. GroupAggregate(...,
changelogMode=[I,UA,D])
JSON_EXECUTION_PLAN
generates the execution plan in json format of the program.
{code:sql}
Flink SQL> EXPLAIN ESTIMATED_COST, CHANGELOG SELECT * FROM MyTable;
...
{code}
was:Allow users to specify the ExplainDetails in statement.
> Extend explain syntax
> ----------------------
>
> Key: FLINK-21465
> URL: https://issues.apache.org/jira/browse/FLINK-21465
> Project: Flink
> Issue Type: Sub-task
> Components: Table SQL / API
> Reporter: Shengkai Fang
> Priority: Major
>
> Allow users to specify the ExplainDetails in statement.
> {code:sql}
> EXPLAIN [ExplainDetail[, ExplainDetail]*] <statement>
> ExplainDetail: {
> ESTIMATED_COST,
> CHANGELOG_MODE,
> JSON_EXECUTION_PLAN
> }
> {code}
> Print the plan for the statement with specified ExplainDetails.
> ESTIMATED_COST
> generates cost information on physical node estimated by optimizer, e.g.
> TableSourceScan(..., cumulative cost = {1.0E8 rows, 1.0E8 cpu, 2.4E9 io, 0.0
> network, 0.0 memory})
> CHANGELOG_MODE
> generates changelog mode for every physical rel node. e.g.
> GroupAggregate(..., changelogMode=[I,UA,D])
> JSON_EXECUTION_PLAN
> generates the execution plan in json format of the program.
> {code:sql}
> Flink SQL> EXPLAIN ESTIMATED_COST, CHANGELOG SELECT * FROM MyTable;
> ...
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
