Steve Carlin created IMPALA-14423:
-------------------------------------

             Summary: Calcite Planner: Rule needed to make Union over multiple 
Values nodes more efficient
                 Key: IMPALA-14423
                 URL: https://issues.apache.org/jira/browse/IMPALA-14423
             Project: IMPALA
          Issue Type: Sub-task
            Reporter: Steve Carlin


With v1.40, when we have the query

select 1 union all select 5000;

...Calcite creates the following node structure:

LogicalUnion

  LogicalProject

    LogicalValues

  LogicalProject

    LogicalValues

The "1" and the "5000" are places in separate LogicalValues.  The resulting 
Impala plan is inefficient because it creates an Impala plan that looks like 
this:
Union

  Union (Value 1)

  Union (Value 5000)

...when it could be all placed within a single Union node with 2 tuples.



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

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to