Jefffrey commented on issue #4772:
URL: 
https://github.com/apache/arrow-datafusion/issues/4772#issuecomment-1401751195

   Could you elaborate on the expected behaviour here? From the original 
discussion, regarding this test:
   
   
https://github.com/apache/arrow-datafusion/blob/5d4038a8463a575328bedbc22b32456f5dcd562c/datafusion/core/tests/sql/union.rs#L84-L98
   
   I did an explain plan:
   
   ```
   
+------------------------------------------------------------+-----------------------------------------------------------------+
   | plan_type                                                  | plan          
                                                  |
   
+------------------------------------------------------------+-----------------------------------------------------------------+
   | initial_logical_plan                                       | Projection: 
COUNT(UInt8(1))                                     |
   |                                                            |   Aggregate: 
groupBy=[[]], aggr=[[COUNT(UInt8(1))]]             |
   |                                                            |     Union     
                                                  |
   |                                                            |       
Projection: t.a                                           |
   |                                                            |         
TableScan: t                                            |
   |                                                            |       
Projection: t.a                                           |
   |                                                            |         
TableScan: t                                            |
   | logical_plan after inline_table_scan                       | SAME TEXT AS 
ABOVE                                              |
   ...
   | logical_plan after common_sub_expression_eliminate         | SAME TEXT AS 
ABOVE                                              |
   | logical_plan after push_down_projection                    | Projection: 
COUNT(UInt8(1))                                     |
   |                                                            |   Aggregate: 
groupBy=[[]], aggr=[[COUNT(UInt8(1))]]             |
   |                                                            |     Union     
                                                  |
   |                                                            |       
TableScan: t projection=[a]                               |
   |                                                            |       
TableScan: t projection=[a]                               |
   | logical_plan after inline_table_scan                       | SAME TEXT AS 
ABOVE                                              |
   ...
   | logical_plan after push_down_projection                    | SAME TEXT AS 
ABOVE                                              |
   | logical_plan                                               | Projection: 
COUNT(UInt8(1))                                     |
   |                                                            |   Aggregate: 
groupBy=[[]], aggr=[[COUNT(UInt8(1))]]             |
   |                                                            |     Union     
                                                  |
   |                                                            |       
TableScan: t projection=[a]                               |
   |                                                            |       
TableScan: t projection=[a]                               |
   ```
   
   What would be the expected logical plan, if it's not this?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to