[jira] [Comment Edited] (CALCITE-4197) Provide utility to visualize RelNode plans

["Liya Fan (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-4197?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17188307#comment-17188307 ] 

Liya Fan edited comment on CALCITE-4197 at 9/1/20, 9:38 AM:
------------------------------------------------------------

To make it easier to see the effects, I want to provide screen-shots of some simple plans.

This is the plan for {{testCorrelateQuery}}:

 !screenshot-1.png! 

This is the plan for {{testAggregateWithAlias}}

 !screenshot-2.png! 

Please check if they look good to you. 


was (Author: fan_li_ya):
To make it easier to see the effects, I want to provide snapshots of some simple plans.

This is the plan for {{testCorrelateQuery}}:

 !screenshot-1.png! 

This is the plan for {{testAggregateWithAlias}}

 !screenshot-2.png! 

> Provide utility to visualize RelNode plans
> ------------------------------------------
>
>                 Key: CALCITE-4197
>                 URL: https://issues.apache.org/jira/browse/CALCITE-4197
>             Project: Calcite
>          Issue Type: New Feature
>          Components: core
>            Reporter: Liya Fan
>            Assignee: Liya Fan
>            Priority: Major
>              Labels: pull-request-available
>         Attachments: screenshot-1.png, screenshot-2.png
>
>          Time Spent: 40m
>  Remaining Estimate: 0h
>
> From time to time, we want to visualize the plan generated the optimizer as a DAG (Directed Acyclic Graph). This gives us an overview of the plan, and helps us to find problems with the plan quickly.
> A common way to visualize a DAG is to dump it in the {{dot}} format, and then display the DAG through GraphViz. Currently, we already have a utility to dump the Volcano planner in dot format. In this issue, we want to dump a RelNode plan (a RelNode DAG) in the dot format, which will help users to see their plans more clearly. 
> The utility should have some options that allow users to specify the visuzalization details, for example:
> 1. the max length of a node description.
> 2. whether RelSubset/HepRelVertex should be displayed.
> 3. Nodes that should be highlighted. 
> Could you please give some feedback?



--
This message was sent by Atlassian Jira
(v8.3.4#803005)