You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Shuai Xu (Jira)" <ji...@apache.org> on 2023/04/27 07:32:00 UTC

[jira] [Comment Edited] (FLINK-31952) Support 'EXPLAIN' statement for CompiledPlan

    [ 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)