[
https://issues.apache.org/jira/browse/FLINK-21465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jark Wu updated FLINK-21465:
----------------------------
Parent: (was: FLINK-21454)
Issue Type: Bug (was: Sub-task)
> Extend explain syntax
> ----------------------
>
> Key: FLINK-21465
> URL: https://issues.apache.org/jira/browse/FLINK-21465
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / API, Table SQL / Client
> 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)
