jayzhan211 commented on PR #15201: URL: https://github.com/apache/datafusion/pull/15201#issuecomment-2736240081
``` statement count 0 create table t(a int) as values (1), (2), (3); statement count 0 create view v as select a, count(a) from t group by a; query II rowsort select * from v; ---- 1 1 2 1 3 1 statement count 0 create view v2 as select "count(t.a)", a from v; query II select * from v2; ---- 1 3 1 1 1 2 query TT explain select * from v2; ---- logical_plan 01)SubqueryAlias: v2 02)--Projection: v.count(t.a), v.a 03)----SubqueryAlias: v 04)------Aggregate: groupBy=[[t.a]], aggr=[[count(t.a)]] 05)--------TableScan: t projection=[a] physical_plan 01)ProjectionExec: expr=[count(t.a)@1 as count(t.a), a@0 as a] 02)--AggregateExec: mode=FinalPartitioned, gby=[a@0 as a], aggr=[count(t.a)] 03)----CoalesceBatchesExec: target_batch_size=8192 04)------RepartitionExec: partitioning=Hash([a@0], 4), input_partitions=4 05)--------RepartitionExec: partitioning=RoundRobinBatch(4), input_partitions=1 06)----------AggregateExec: mode=Partial, gby=[a@0 as a], aggr=[count(t.a)] 07)------------DataSourceExec: partitions=1, partition_sizes=[1] query II rowsort select "count(t.a)", a from v; ---- 1 1 1 2 1 3 statement count 0 drop view v; statement count 0 drop view v2; statement count 0 drop table t; ``` -- 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: github-unsubscr...@datafusion.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org For additional commands, e-mail: github-h...@datafusion.apache.org
