[jira] [Created] (CALCITE-7248) Support the ability to view the logical plan before it enters the Volcano Planner

["weihua zhang (Jira)" <ji...@apache.org>]

weihua zhang created CALCITE-7248:
-------------------------------------

             Summary: Support the ability to view the logical plan before it enters the Volcano Planner
                 Key: CALCITE-7248
                 URL: https://issues.apache.org/jira/browse/CALCITE-7248
             Project: Calcite
          Issue Type: Improvement
            Reporter: weihua zhang


Currently, in QuidemTest, only plans similar to the following can be viewed:
{code:java}
EnumerableUnion(all=[false])
  EnumerableCalc(expr#0..7=[{inputs}], expr#8=[CAST($t3):INTEGER], expr#9=[12], expr#10=[=($t8, $t9)], MGR=[$t3], COMM=[$t6], $condition=[$t10])
    EnumerableTableScan(table=[[scott, EMP]])
  EnumerableCalc(expr#0..7=[{inputs}], expr#8=[CAST($t6):DECIMAL(12, 2)], expr#9=[5.00:DECIMAL(12, 2)], expr#10=[>($t8, $t9)], MGR=[$t3], COMM=[$t6], $condition=[$t10])
    EnumerableTableScan(table=[[scott, EMP]])
!plan
{code}

This is very inconvenient for scenarios where one wants to verify the logical plan.It would be great if there was a mechanism that could display the logical plan after optimizations such as SubQueryRemoveRule, RelDecorrelator, and various RBO (Rule-Based Optimization) processes, with an effect similar to the following:

{code:java}
LogicalProject(DEPTNO=[$1], V=[OR(AND(IS TRUE(<($1, $3)), IS NOT TRUE(OR(IS NULL($6), =($4, 0)))), AND(IS TRUE(>($4, $5)), null, IS NOT TRUE(OR(IS NULL($6), =($4, 0))), IS NOT TRUE(<($1, $3))), AND(<($1, $3), IS NOT TRUE(OR(IS NULL($6), =($4, 0))), IS NOT TRUE(<($1, $3)), IS NOT TRUE(>($4, $5))))]), id = 1681
  LogicalJoin(condition=[IS NOT DISTINCT FROM($0, $2)], joinType=[left]), id = 1679
    LogicalProject(ename=[$1], deptno=[$8]), id = 1661
      LogicalTableScan(table=[[scott, emp]]), id = 1590
    LogicalProject(ename=[$0], m=[$2], c=[CASE(IS NOT NULL($3), $3, 0)], d=[CASE(IS NOT NULL($4), $4, 0)], trueLiteral=[$5]), id = 1677
      LogicalJoin(condition=[IS NOT DISTINCT FROM($0, $1)], joinType=[left]), id = 1675
        LogicalAggregate(group=[{0}]), id = 1666
          LogicalProject(ename=[$1]), id = 1664
            LogicalTableScan(table=[[scott, emp]]), id = 1590
        LogicalAggregate(group=[{0}], m=[MAX($1)], c=[COUNT()], d=[COUNT($1)], trueLiteral=[LITERAL_AGG(true)]), id = 1673
          LogicalProject(ename=[$1], DEPTNO=[$8]), id = 1671
            LogicalFilter(condition=[IS NOT NULL($1)]), id = 1669
              LogicalTableScan(table=[[scott, emp]]), id = 1590
!logicalPlan
{code}




--
This message was sent by Atlassian Jira
(v8.20.10#820010)