[
https://issues.apache.org/jira/browse/FLINK-20562?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jark Wu updated FLINK-20562:
----------------------------
Description:
Currently, {{EXPLAIN}} syntax only supports to print the default AST, logical
plan, and physical plan. However, it doesn't support to print detailed
information such as CHANGELOG_MODE, ESTIMATED_COST, JSON_EXECUTION_PLAN which
are defined in {{ExplainDetail}}.
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:Currently, {{EXPLAIN}} syntax only supports to print the default AST,
logical plan, and physical plan. However, it doesn't support to print detailed
information such as CHANGELOG_MODE, ESTIMATED_COST, JSON_EXECUTION_PLAN which
are defined in {{ExplainDetail}}.
> Support ExplainDetails for EXPLAIN sytnax
> -----------------------------------------
>
> Key: FLINK-20562
> URL: https://issues.apache.org/jira/browse/FLINK-20562
> Project: Flink
> Issue Type: Sub-task
> Components: Table SQL / API
> Reporter: Jark Wu
> Priority: Major
> Labels: sprint
> Fix For: 1.13.0
>
>
> Currently, {{EXPLAIN}} syntax only supports to print the default AST, logical
> plan, and physical plan. However, it doesn't support to print detailed
> information such as CHANGELOG_MODE, ESTIMATED_COST, JSON_EXECUTION_PLAN which
> are defined in {{ExplainDetail}}.
> 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)
