[ https://issues.apache.org/jira/browse/FLINK-31952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17717031#comment-17717031 ]
Shuai Xu edited comment on FLINK-31952 at 4/27/23 7:31 AM: ----------------------------------------------------------- Hi Jane, I have some ideas for the task and this is how I consider it. Purpose of the task: Support explain [plan for | <explain_detail>] '/path-to-json.json' The steps I think could resolve the task : 1. Modify parserImpl.ftl template to add syntax support, which can be verified by FlinkSqlParserImplTest 2. Translate the sql to Operation. 3. TableEnv#explainPlan is a ready API, we just got the internal plan from the Operation and pass it to TableEnv#explainPlan. 4. Finally add the test in and SqlOperationConverterTest and TableEnvironmentTest for verification. Could I take the task? was (Author: JIRAUSER300096): Hi Jane, I have some ideas for the task and this is how I consider it. Purpose of the task: Support explain [plan for | <explain_detail>] '/path-to-json.json' The steps I think could resolve the task : 1. Modify parserImpl.ftl template to add syntax support, which can be verified by FlinkSqlParserImplTest 2. Translate the sql to Operation. 3. TableEnv#explainPlan is a ready API, we just got the internal plan from the Operation and pass it to TableEnv#explainPlan. 4. Finally add the test in and SqlOperationConverterTest and TableEnvironmentTest for verification. Could I take the task? > Support 'EXPLAIN' statement for CompiledPlan > -------------------------------------------- > > Key: FLINK-31952 > URL: https://issues.apache.org/jira/browse/FLINK-31952 > Project: Flink > Issue Type: Sub-task > Components: Table SQL / Planner > Affects Versions: 1.18.0 > Reporter: Jane Chan > Priority: Major > Fix For: 1.18.0 > > > Support the explain SQL syntax towards serialized CompiledPlan > {code:sql} > EXPLAIN [ <explain_details> | PLAN FOR] <compiled_plan_json> > {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)