@@ -8,18 +8,18 @@ PhysicalResultSink
88----------PhysicalDistribute[DistributionSpecHash]
99------------hashAgg[LOCAL]
1010--------------PhysicalProject
11- ----------------hashJoin[INNER_JOIN shuffle] hashCondition=((catalog_sales.cs_bill_customer_sk = customer.c_customer_sk)) otherCondition=(OR[substring(ca_zip, 1, 5) IN ('80348', '81792', '83405', '85392', '85460', '85669', '86197', '86475', '88274'),ca_state IN ('CA', 'GA', 'WA'),(catalog_sales.cs_sales_price > 500.00)]) build RFs:RF2 c_customer_sk->[cs_bill_customer_sk]
11+ ----------------hashJoin[INNER_JOIN shuffle] hashCondition=((catalog_sales.cs_bill_customer_sk = customer.c_customer_sk)) otherCondition=(OR[substring(ca_zip, 1, 5) IN ('80348', '81792', '83405', '85392', '85460', '85669', '86197', '86475', '88274'),ca_state IN ('CA', 'GA', 'WA'),(catalog_sales.cs_sales_price > 500.00)])
1212------------------PhysicalProject
1313--------------------hashJoin[INNER_JOIN broadcast] hashCondition=((catalog_sales.cs_sold_date_sk = date_dim.d_date_sk)) otherCondition=() build RFs:RF1 d_date_sk->[cs_sold_date_sk]
1414----------------------PhysicalProject
15- ------------------------PhysicalOlapScan[catalog_sales] apply RFs: RF1 RF2
15+ ------------------------PhysicalOlapScan[catalog_sales] apply RFs: RF1
1616----------------------PhysicalProject
1717------------------------filter((date_dim.d_qoy = 1) and (date_dim.d_year = 2001))
1818--------------------------PhysicalOlapScan[date_dim]
1919------------------PhysicalProject
20- --------------------hashJoin[INNER_JOIN bucketShuffle] hashCondition=((customer.c_current_addr_sk = customer_address.ca_address_sk)) otherCondition=() build RFs:RF0 c_current_addr_sk->[ca_address_sk]
21- ----------------------PhysicalProject
22- ------------------------PhysicalOlapScan[customer_address] apply RFs: RF0
20+ --------------------hashJoin[INNER_JOIN shuffle] hashCondition=((customer.c_current_addr_sk = customer_address.ca_address_sk)) otherCondition=()
2321----------------------PhysicalProject
2422------------------------PhysicalOlapScan[customer]
23+ ----------------------PhysicalProject
24+ ------------------------PhysicalOlapScan[customer_address]
2525
0 commit comments