@@ -137,20 +137,12 @@ query TT
137137EXPLAIN SELECT COUNT(DISTINCT "UserID") FROM hits;
138138----
139139logical_plan
140- 01)Projection: count(alias1) AS count(DISTINCT hits.UserID)
141- 02)--Aggregate: groupBy=[[]], aggr=[[count(alias1)]]
142- 03)----Aggregate: groupBy=[[hits.UserID AS alias1]], aggr=[[]]
143- 04)------SubqueryAlias: hits
144- 05)--------TableScan: hits_raw projection=[UserID]
140+ 01)Aggregate: groupBy=[[]], aggr=[[count(DISTINCT hits.UserID)]]
141+ 02)--SubqueryAlias: hits
142+ 03)----TableScan: hits_raw projection=[UserID]
145143physical_plan
146- 01)ProjectionExec: expr=[count(alias1)@0 as count(DISTINCT hits.UserID)]
147- 02)--AggregateExec: mode=Final, gby=[], aggr=[count(alias1)]
148- 03)----CoalescePartitionsExec
149- 04)------AggregateExec: mode=Partial, gby=[], aggr=[count(alias1)]
150- 05)--------AggregateExec: mode=FinalPartitioned, gby=[alias1@0 as alias1], aggr=[]
151- 06)----------RepartitionExec: partitioning=Hash([alias1@0], 4), input_partitions=1
152- 07)------------AggregateExec: mode=Partial, gby=[UserID@0 as alias1], aggr=[]
153- 08)--------------DataSourceExec: file_groups={1 group: [[WORKSPACE_ROOT/datafusion/core/tests/data/clickbench_hits_10.parquet]]}, projection=[UserID], file_type=parquet
144+ 01)AggregateExec: mode=Single, gby=[], aggr=[count(DISTINCT hits.UserID)]
145+ 02)--DataSourceExec: file_groups={1 group: [[WORKSPACE_ROOT/datafusion/core/tests/data/clickbench_hits_10.parquet]]}, projection=[UserID], file_type=parquet
154146
155147query I
156148SELECT COUNT(DISTINCT "UserID") FROM hits;
@@ -162,20 +154,12 @@ query TT
162154EXPLAIN SELECT COUNT(DISTINCT "SearchPhrase") FROM hits;
163155----
164156logical_plan
165- 01)Projection: count(alias1) AS count(DISTINCT hits.SearchPhrase)
166- 02)--Aggregate: groupBy=[[]], aggr=[[count(alias1)]]
167- 03)----Aggregate: groupBy=[[hits.SearchPhrase AS alias1]], aggr=[[]]
168- 04)------SubqueryAlias: hits
169- 05)--------TableScan: hits_raw projection=[SearchPhrase]
157+ 01)Aggregate: groupBy=[[]], aggr=[[count(DISTINCT hits.SearchPhrase)]]
158+ 02)--SubqueryAlias: hits
159+ 03)----TableScan: hits_raw projection=[SearchPhrase]
170160physical_plan
171- 01)ProjectionExec: expr=[count(alias1)@0 as count(DISTINCT hits.SearchPhrase)]
172- 02)--AggregateExec: mode=Final, gby=[], aggr=[count(alias1)]
173- 03)----CoalescePartitionsExec
174- 04)------AggregateExec: mode=Partial, gby=[], aggr=[count(alias1)]
175- 05)--------AggregateExec: mode=FinalPartitioned, gby=[alias1@0 as alias1], aggr=[]
176- 06)----------RepartitionExec: partitioning=Hash([alias1@0], 4), input_partitions=1
177- 07)------------AggregateExec: mode=Partial, gby=[SearchPhrase@0 as alias1], aggr=[]
178- 08)--------------DataSourceExec: file_groups={1 group: [[WORKSPACE_ROOT/datafusion/core/tests/data/clickbench_hits_10.parquet]]}, projection=[SearchPhrase], file_type=parquet
161+ 01)AggregateExec: mode=Single, gby=[], aggr=[count(DISTINCT hits.SearchPhrase)]
162+ 02)--DataSourceExec: file_groups={1 group: [[WORKSPACE_ROOT/datafusion/core/tests/data/clickbench_hits_10.parquet]]}, projection=[SearchPhrase], file_type=parquet
179163
180164query I
181165SELECT COUNT(DISTINCT "SearchPhrase") FROM hits;
0 commit comments