PHYSICAL PLAN
*(6) HashAggregate(keys=[dt#958, name#970], functions=[count(1)])
+- Exchange hashpartitioning(dt#958, name#970, 200)
+- *(5) HashAggregate(keys=[dt#958, name#970], functions=[partial_count(1)])
+- *(5) Project [dt#958, name#970]
+- *(5) SortMergeJoin [key#937], [key#960], Inner
:- *(2) Sort [key#937 ASC NULLS FIRST], false, 0
: +- Exchange hashpartitioning(key#937, 200)
: +- *(1) Project [dt#958, key#937]
: +- *(1) Filter isnotnull(key#937)
: +- *(1) FileScan orc transaction[key#937,dt#958] Batched: true, Format: ORC, Location:…
+- *(4) Sort [key#960 ASC NULLS FIRST], false, 0
+- Exchange hashpartitioning(key#960, 200)
+- *(3) Project [key#960, name#970]
+- *(3) Filter isnotnull(key#960)
+- *(3) FileScan orc master[key#960,name#970] Batched: true, Format: ORC, Location:…