You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@impala.apache.org by ta...@apache.org on 2017/11/18 00:31:46 UTC
[03/16] incubator-impala git commit: IMPALA-4252: Min-max runtime
filters for Kudu
http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/2510fe0a/testdata/workloads/functional-planner/queries/PlannerTest/tpcds-all.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/functional-planner/queries/PlannerTest/tpcds-all.test b/testdata/workloads/functional-planner/queries/PlannerTest/tpcds-all.test
index a18f4f5..31f0738 100644
--- a/testdata/workloads/functional-planner/queries/PlannerTest/tpcds-all.test
+++ b/testdata/workloads/functional-planner/queries/PlannerTest/tpcds-all.test
@@ -42,7 +42,7 @@ PLAN-ROOT SINK
|
03:HASH JOIN [INNER JOIN]
| hash predicates: store_sales.ss_item_sk = item.i_item_sk
-| runtime filters: RF001 <- item.i_item_sk
+| runtime filters: RF002 <- item.i_item_sk
|
|--02:SCAN HDFS [tpcds.item]
| partitions=1/1 files=1 size=4.82MB
@@ -50,7 +50,7 @@ PLAN-ROOT SINK
|
01:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> store_sales.ss_sold_date_sk, RF001 -> store_sales.ss_item_sk
+ runtime filters: RF000 -> store_sales.ss_sold_date_sk, RF002 -> store_sales.ss_item_sk
---- DISTRIBUTEDPLAN
PLAN-ROOT SINK
|
@@ -85,7 +85,7 @@ PLAN-ROOT SINK
|
03:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_item_sk = item.i_item_sk
-| runtime filters: RF001 <- item.i_item_sk
+| runtime filters: RF002 <- item.i_item_sk
|
|--07:EXCHANGE [BROADCAST]
| |
@@ -95,7 +95,7 @@ PLAN-ROOT SINK
|
01:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> store_sales.ss_sold_date_sk, RF001 -> store_sales.ss_item_sk
+ runtime filters: RF000 -> store_sales.ss_sold_date_sk, RF002 -> store_sales.ss_item_sk
---- PARALLELPLANS
PLAN-ROOT SINK
|
@@ -134,7 +134,7 @@ PLAN-ROOT SINK
|
03:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_item_sk = item.i_item_sk
-| runtime filters: RF001 <- item.i_item_sk
+| runtime filters: RF002 <- item.i_item_sk
|
|--JOIN BUILD
| | join-table-id=01 plan-id=02 cohort-id=01
@@ -148,7 +148,7 @@ PLAN-ROOT SINK
|
01:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> store_sales.ss_sold_date_sk, RF001 -> store_sales.ss_item_sk
+ runtime filters: RF000 -> store_sales.ss_sold_date_sk, RF002 -> store_sales.ss_item_sk
====
# TPCDS-Q7
select
@@ -198,7 +198,7 @@ PLAN-ROOT SINK
|
07:HASH JOIN [INNER JOIN]
| hash predicates: ss_promo_sk = p_promo_sk
-| runtime filters: RF001 <- p_promo_sk
+| runtime filters: RF002 <- p_promo_sk
|
|--04:SCAN HDFS [tpcds.promotion]
| partitions=1/1 files=1 size=36.36KB
@@ -206,7 +206,7 @@ PLAN-ROOT SINK
|
06:HASH JOIN [INNER JOIN]
| hash predicates: ss_cdemo_sk = cd_demo_sk
-| runtime filters: RF002 <- cd_demo_sk
+| runtime filters: RF004 <- cd_demo_sk
|
|--01:SCAN HDFS [tpcds.customer_demographics]
| partitions=1/1 files=1 size=76.92MB
@@ -214,7 +214,7 @@ PLAN-ROOT SINK
|
05:HASH JOIN [INNER JOIN]
| hash predicates: ss_sold_date_sk = d_date_sk
-| runtime filters: RF003 <- d_date_sk
+| runtime filters: RF006 <- d_date_sk
|
|--02:SCAN HDFS [tpcds.date_dim]
| partitions=1/1 files=1 size=9.84MB
@@ -222,7 +222,7 @@ PLAN-ROOT SINK
|
00:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> ss_item_sk, RF001 -> ss_promo_sk, RF002 -> ss_cdemo_sk, RF003 -> ss_sold_date_sk
+ runtime filters: RF000 -> ss_item_sk, RF002 -> ss_promo_sk, RF004 -> ss_cdemo_sk, RF006 -> ss_sold_date_sk
---- DISTRIBUTEDPLAN
PLAN-ROOT SINK
|
@@ -254,7 +254,7 @@ PLAN-ROOT SINK
|
07:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_promo_sk = p_promo_sk
-| runtime filters: RF001 <- p_promo_sk
+| runtime filters: RF002 <- p_promo_sk
|
|--13:EXCHANGE [BROADCAST]
| |
@@ -264,7 +264,7 @@ PLAN-ROOT SINK
|
06:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_cdemo_sk = cd_demo_sk
-| runtime filters: RF002 <- cd_demo_sk
+| runtime filters: RF004 <- cd_demo_sk
|
|--12:EXCHANGE [BROADCAST]
| |
@@ -274,7 +274,7 @@ PLAN-ROOT SINK
|
05:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_sold_date_sk = d_date_sk
-| runtime filters: RF003 <- d_date_sk
+| runtime filters: RF006 <- d_date_sk
|
|--11:EXCHANGE [BROADCAST]
| |
@@ -284,7 +284,7 @@ PLAN-ROOT SINK
|
00:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> ss_item_sk, RF001 -> ss_promo_sk, RF002 -> ss_cdemo_sk, RF003 -> ss_sold_date_sk
+ runtime filters: RF000 -> ss_item_sk, RF002 -> ss_promo_sk, RF004 -> ss_cdemo_sk, RF006 -> ss_sold_date_sk
---- PARALLELPLANS
PLAN-ROOT SINK
|
@@ -320,7 +320,7 @@ PLAN-ROOT SINK
|
07:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_promo_sk = p_promo_sk
-| runtime filters: RF001 <- p_promo_sk
+| runtime filters: RF002 <- p_promo_sk
|
|--JOIN BUILD
| | join-table-id=01 plan-id=02 cohort-id=01
@@ -334,7 +334,7 @@ PLAN-ROOT SINK
|
06:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_cdemo_sk = cd_demo_sk
-| runtime filters: RF002 <- cd_demo_sk
+| runtime filters: RF004 <- cd_demo_sk
|
|--JOIN BUILD
| | join-table-id=02 plan-id=03 cohort-id=01
@@ -348,7 +348,7 @@ PLAN-ROOT SINK
|
05:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_sold_date_sk = d_date_sk
-| runtime filters: RF003 <- d_date_sk
+| runtime filters: RF006 <- d_date_sk
|
|--JOIN BUILD
| | join-table-id=03 plan-id=04 cohort-id=01
@@ -362,7 +362,7 @@ PLAN-ROOT SINK
|
00:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> ss_item_sk, RF001 -> ss_promo_sk, RF002 -> ss_cdemo_sk, RF003 -> ss_sold_date_sk
+ runtime filters: RF000 -> ss_item_sk, RF002 -> ss_promo_sk, RF004 -> ss_cdemo_sk, RF006 -> ss_sold_date_sk
====
# TPCDS-Q8
select
@@ -449,7 +449,7 @@ PLAN-ROOT SINK
|
|--07:HASH JOIN [RIGHT SEMI JOIN]
| | hash predicates: substr(ca_zip, 1, 5) = substr(ca_zip, 1, 5)
-| | runtime filters: RF002 <- substr(ca_zip, 1, 5)
+| | runtime filters: RF004 <- substr(ca_zip, 1, 5)
| |
| |--05:AGGREGATE [FINALIZE]
| | | output: count(*)
@@ -458,7 +458,7 @@ PLAN-ROOT SINK
| | |
| | 04:HASH JOIN [INNER JOIN]
| | | hash predicates: customer_address.ca_address_sk = customer.c_current_addr_sk
-| | | runtime filters: RF003 <- customer.c_current_addr_sk
+| | | runtime filters: RF006 <- customer.c_current_addr_sk
| | |
| | |--03:SCAN HDFS [tpcds.customer]
| | | partitions=1/1 files=1 size=12.60MB
@@ -466,16 +466,16 @@ PLAN-ROOT SINK
| | |
| | 02:SCAN HDFS [tpcds.customer_address]
| | partitions=1/1 files=1 size=5.25MB
-| | runtime filters: RF003 -> customer_address.ca_address_sk
+| | runtime filters: RF006 -> customer_address.ca_address_sk
| |
| 06:SCAN HDFS [tpcds.customer_address]
| partitions=1/1 files=1 size=5.25MB
| predicates: substr(ca_zip, 1, 5) IN ('89436', '30868', '65085', '22977', '83927', '77557', '58429', '40697', '80614', '10502', '32779', '91137', '61265', '98294', '17921', '18427', '21203', '59362', '87291', '84093', '21505', '17184', '10866', '67898', '25797', '28055', '18377', '80332', '74535', '21757', '29742', '90885', '29898', '17819', '40811', '25990', '47513', '89531', '91068', '10391', '18846', '99223', '82637', '41368', '83658', '86199', '81625', '26696', '89338', '88425', '32200', '81427', '19053', '77471', '36610', '99823', '43276', '41249', '48584', '83550', '82276', '18842', '78890', '14090', '38123', '40936', '34425', '19850', '43286', '80072', '79188', '54191', '11395', '50497', '84861', '90733', '21068', '57666', '37119', '25004', '57835', '70067', '62878', '95806', '19303', '18840', '19124', '29785', '16737', '16022', '49613', '89977', '68310', '60069', '98360', '48649', '39050', '41793', '25002', '27413', '39736', '47208', '16515', '94808', '57648', '15009',
'80015', '42961', '63982', '21744', '71853', '81087', '67468', '34175', '64008', '20261', '11201', '51799', '48043', '45645', '61163', '48375', '36447', '57042', '21218', '41100', '89951', '22745', '35851', '83326', '61125', '78298', '80752', '49858', '52940', '96976', '63792', '11376', '53582', '18717', '90226', '50530', '94203', '99447', '27670', '96577', '57856', '56372', '16165', '23427', '54561', '28806', '44439', '22926', '30123', '61451', '92397', '56979', '92309', '70873', '13355', '21801', '46346', '37562', '56458', '28286', '47306', '99555', '69399', '26234', '47546', '49661', '88601', '35943', '39936', '25632', '24611', '44166', '56648', '30379', '59785', '11110', '14329', '93815', '52226', '71381', '13842', '25612', '63294', '14664', '21077', '82626', '18799', '60915', '81020', '56447', '76619', '11433', '13414', '42548', '92713', '70467', '30884', '47484', '16072', '38936', '13036', '88376', '45539', '35901', '19506', '65690', '73957', '71850', '49231', '14276', '20005'
, '18384', '76615', '11635', '38177', '55607', '41369', '95447', '58581', '58149', '91946', '33790', '76232', '75692', '95464', '22246', '51061', '56692', '53121', '77209', '15482', '10688', '14868', '45907', '73520', '72666', '25734', '17959', '24677', '66446', '94627', '53535', '15560', '41967', '69297', '11929', '59403', '33283', '52232', '57350', '43933', '40921', '36635', '10827', '71286', '19736', '80619', '25251', '95042', '15526', '36496', '55854', '49124', '81980', '35375', '49157', '63512', '28944', '14946', '36503', '54010', '18767', '23969', '43905', '66979', '33113', '21286', '58471', '59080', '13395', '79144', '70373', '67031', '38360', '26705', '50906', '52406', '26066', '73146', '15884', '31897', '30045', '61068', '45550', '92454', '13376', '14354', '19770', '22928', '97790', '50723', '46081', '30202', '14410', '20223', '88500', '67298', '13261', '14172', '81410', '93578', '83583', '46047', '94167', '82564', '21156', '15799', '86709', '37931', '74703', '83103', '2305
4', '70470', '72008', '49247', '91911', '69998', '20961', '70070', '63197', '54853', '88191', '91830', '49521', '19454', '81450', '89091', '62378', '25683', '61869', '51744', '36580', '85778', '36871', '48121', '28810', '83712', '45486', '67393', '26935', '42393', '20132', '55349', '86057', '21309', '80218', '10094', '11357', '48819', '39734', '40758', '30432', '21204', '29467', '30214', '61024', '55307', '74621', '11622', '68908', '33032', '52868', '99194', '99900', '84936', '69036', '99149', '45013', '32895', '59004', '32322', '14933', '32936', '33562', '72550', '27385', '58049', '58200', '16808', '21360', '32961', '18586', '79307', '15492')
-| runtime filters: RF002 -> substr(ca_zip, 1, 5)
+| runtime filters: RF004 -> substr(ca_zip, 1, 5)
|
08:HASH JOIN [INNER JOIN]
| hash predicates: store_sales.ss_store_sk = store.s_store_sk
-| runtime filters: RF001 <- store.s_store_sk
+| runtime filters: RF002 <- store.s_store_sk
|
|--01:SCAN HDFS [tpcds.store]
| partitions=1/1 files=1 size=3.08KB
@@ -483,7 +483,7 @@ PLAN-ROOT SINK
|
00:SCAN HDFS [tpcds.store_sales]
partitions=90/1824 files=90 size=9.71MB
- runtime filters: RF001 -> store_sales.ss_store_sk
+ runtime filters: RF002 -> store_sales.ss_store_sk
---- DISTRIBUTEDPLAN
PLAN-ROOT SINK
|
@@ -512,7 +512,7 @@ PLAN-ROOT SINK
| |
| 07:HASH JOIN [RIGHT SEMI JOIN, PARTITIONED]
| | hash predicates: substr(ca_zip, 1, 5) = substr(ca_zip, 1, 5)
-| | runtime filters: RF002 <- substr(ca_zip, 1, 5)
+| | runtime filters: RF004 <- substr(ca_zip, 1, 5)
| |
| |--15:AGGREGATE [FINALIZE]
| | | output: count:merge(*)
@@ -527,7 +527,7 @@ PLAN-ROOT SINK
| | |
| | 04:HASH JOIN [INNER JOIN, BROADCAST]
| | | hash predicates: customer_address.ca_address_sk = customer.c_current_addr_sk
-| | | runtime filters: RF003 <- customer.c_current_addr_sk
+| | | runtime filters: RF006 <- customer.c_current_addr_sk
| | |
| | |--13:EXCHANGE [BROADCAST]
| | | |
@@ -537,18 +537,18 @@ PLAN-ROOT SINK
| | |
| | 02:SCAN HDFS [tpcds.customer_address]
| | partitions=1/1 files=1 size=5.25MB
-| | runtime filters: RF003 -> customer_address.ca_address_sk
+| | runtime filters: RF006 -> customer_address.ca_address_sk
| |
| 16:EXCHANGE [HASH(substr(ca_zip, 1, 5))]
| |
| 06:SCAN HDFS [tpcds.customer_address]
| partitions=1/1 files=1 size=5.25MB
| predicates: substr(ca_zip, 1, 5) IN ('89436', '30868', '65085', '22977', '83927', '77557', '58429', '40697', '80614', '10502', '32779', '91137', '61265', '98294', '17921', '18427', '21203', '59362', '87291', '84093', '21505', '17184', '10866', '67898', '25797', '28055', '18377', '80332', '74535', '21757', '29742', '90885', '29898', '17819', '40811', '25990', '47513', '89531', '91068', '10391', '18846', '99223', '82637', '41368', '83658', '86199', '81625', '26696', '89338', '88425', '32200', '81427', '19053', '77471', '36610', '99823', '43276', '41249', '48584', '83550', '82276', '18842', '78890', '14090', '38123', '40936', '34425', '19850', '43286', '80072', '79188', '54191', '11395', '50497', '84861', '90733', '21068', '57666', '37119', '25004', '57835', '70067', '62878', '95806', '19303', '18840', '19124', '29785', '16737', '16022', '49613', '89977', '68310', '60069', '98360', '48649', '39050', '41793', '25002', '27413', '39736', '47208', '16515', '94808', '57648', '15009',
'80015', '42961', '63982', '21744', '71853', '81087', '67468', '34175', '64008', '20261', '11201', '51799', '48043', '45645', '61163', '48375', '36447', '57042', '21218', '41100', '89951', '22745', '35851', '83326', '61125', '78298', '80752', '49858', '52940', '96976', '63792', '11376', '53582', '18717', '90226', '50530', '94203', '99447', '27670', '96577', '57856', '56372', '16165', '23427', '54561', '28806', '44439', '22926', '30123', '61451', '92397', '56979', '92309', '70873', '13355', '21801', '46346', '37562', '56458', '28286', '47306', '99555', '69399', '26234', '47546', '49661', '88601', '35943', '39936', '25632', '24611', '44166', '56648', '30379', '59785', '11110', '14329', '93815', '52226', '71381', '13842', '25612', '63294', '14664', '21077', '82626', '18799', '60915', '81020', '56447', '76619', '11433', '13414', '42548', '92713', '70467', '30884', '47484', '16072', '38936', '13036', '88376', '45539', '35901', '19506', '65690', '73957', '71850', '49231', '14276', '20005'
, '18384', '76615', '11635', '38177', '55607', '41369', '95447', '58581', '58149', '91946', '33790', '76232', '75692', '95464', '22246', '51061', '56692', '53121', '77209', '15482', '10688', '14868', '45907', '73520', '72666', '25734', '17959', '24677', '66446', '94627', '53535', '15560', '41967', '69297', '11929', '59403', '33283', '52232', '57350', '43933', '40921', '36635', '10827', '71286', '19736', '80619', '25251', '95042', '15526', '36496', '55854', '49124', '81980', '35375', '49157', '63512', '28944', '14946', '36503', '54010', '18767', '23969', '43905', '66979', '33113', '21286', '58471', '59080', '13395', '79144', '70373', '67031', '38360', '26705', '50906', '52406', '26066', '73146', '15884', '31897', '30045', '61068', '45550', '92454', '13376', '14354', '19770', '22928', '97790', '50723', '46081', '30202', '14410', '20223', '88500', '67298', '13261', '14172', '81410', '93578', '83583', '46047', '94167', '82564', '21156', '15799', '86709', '37931', '74703', '83103', '2305
4', '70470', '72008', '49247', '91911', '69998', '20961', '70070', '63197', '54853', '88191', '91830', '49521', '19454', '81450', '89091', '62378', '25683', '61869', '51744', '36580', '85778', '36871', '48121', '28810', '83712', '45486', '67393', '26935', '42393', '20132', '55349', '86057', '21309', '80218', '10094', '11357', '48819', '39734', '40758', '30432', '21204', '29467', '30214', '61024', '55307', '74621', '11622', '68908', '33032', '52868', '99194', '99900', '84936', '69036', '99149', '45013', '32895', '59004', '32322', '14933', '32936', '33562', '72550', '27385', '58049', '58200', '16808', '21360', '32961', '18586', '79307', '15492')
-| runtime filters: RF002 -> substr(ca_zip, 1, 5)
+| runtime filters: RF004 -> substr(ca_zip, 1, 5)
|
08:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_store_sk = store.s_store_sk
-| runtime filters: RF001 <- store.s_store_sk
+| runtime filters: RF002 <- store.s_store_sk
|
|--12:EXCHANGE [BROADCAST]
| |
@@ -558,7 +558,7 @@ PLAN-ROOT SINK
|
00:SCAN HDFS [tpcds.store_sales]
partitions=90/1824 files=90 size=9.71MB
- runtime filters: RF001 -> store_sales.ss_store_sk
+ runtime filters: RF002 -> store_sales.ss_store_sk
---- PARALLELPLANS
PLAN-ROOT SINK
|
@@ -591,7 +591,7 @@ PLAN-ROOT SINK
| |
| 07:HASH JOIN [RIGHT SEMI JOIN, PARTITIONED]
| | hash predicates: substr(ca_zip, 1, 5) = substr(ca_zip, 1, 5)
-| | runtime filters: RF002 <- substr(ca_zip, 1, 5)
+| | runtime filters: RF004 <- substr(ca_zip, 1, 5)
| |
| |--JOIN BUILD
| | | join-table-id=01 plan-id=02 cohort-id=02
@@ -610,7 +610,7 @@ PLAN-ROOT SINK
| | |
| | 04:HASH JOIN [INNER JOIN, BROADCAST]
| | | hash predicates: customer_address.ca_address_sk = customer.c_current_addr_sk
-| | | runtime filters: RF003 <- customer.c_current_addr_sk
+| | | runtime filters: RF006 <- customer.c_current_addr_sk
| | |
| | |--JOIN BUILD
| | | | join-table-id=02 plan-id=03 cohort-id=03
@@ -624,18 +624,18 @@ PLAN-ROOT SINK
| | |
| | 02:SCAN HDFS [tpcds.customer_address]
| | partitions=1/1 files=1 size=5.25MB
-| | runtime filters: RF003 -> customer_address.ca_address_sk
+| | runtime filters: RF006 -> customer_address.ca_address_sk
| |
| 16:EXCHANGE [HASH(substr(ca_zip, 1, 5))]
| |
| 06:SCAN HDFS [tpcds.customer_address]
| partitions=1/1 files=1 size=5.25MB
| predicates: substr(ca_zip, 1, 5) IN ('89436', '30868', '65085', '22977', '83927', '77557', '58429', '40697', '80614', '10502', '32779', '91137', '61265', '98294', '17921', '18427', '21203', '59362', '87291', '84093', '21505', '17184', '10866', '67898', '25797', '28055', '18377', '80332', '74535', '21757', '29742', '90885', '29898', '17819', '40811', '25990', '47513', '89531', '91068', '10391', '18846', '99223', '82637', '41368', '83658', '86199', '81625', '26696', '89338', '88425', '32200', '81427', '19053', '77471', '36610', '99823', '43276', '41249', '48584', '83550', '82276', '18842', '78890', '14090', '38123', '40936', '34425', '19850', '43286', '80072', '79188', '54191', '11395', '50497', '84861', '90733', '21068', '57666', '37119', '25004', '57835', '70067', '62878', '95806', '19303', '18840', '19124', '29785', '16737', '16022', '49613', '89977', '68310', '60069', '98360', '48649', '39050', '41793', '25002', '27413', '39736', '47208', '16515', '94808', '57648', '15009',
'80015', '42961', '63982', '21744', '71853', '81087', '67468', '34175', '64008', '20261', '11201', '51799', '48043', '45645', '61163', '48375', '36447', '57042', '21218', '41100', '89951', '22745', '35851', '83326', '61125', '78298', '80752', '49858', '52940', '96976', '63792', '11376', '53582', '18717', '90226', '50530', '94203', '99447', '27670', '96577', '57856', '56372', '16165', '23427', '54561', '28806', '44439', '22926', '30123', '61451', '92397', '56979', '92309', '70873', '13355', '21801', '46346', '37562', '56458', '28286', '47306', '99555', '69399', '26234', '47546', '49661', '88601', '35943', '39936', '25632', '24611', '44166', '56648', '30379', '59785', '11110', '14329', '93815', '52226', '71381', '13842', '25612', '63294', '14664', '21077', '82626', '18799', '60915', '81020', '56447', '76619', '11433', '13414', '42548', '92713', '70467', '30884', '47484', '16072', '38936', '13036', '88376', '45539', '35901', '19506', '65690', '73957', '71850', '49231', '14276', '20005'
, '18384', '76615', '11635', '38177', '55607', '41369', '95447', '58581', '58149', '91946', '33790', '76232', '75692', '95464', '22246', '51061', '56692', '53121', '77209', '15482', '10688', '14868', '45907', '73520', '72666', '25734', '17959', '24677', '66446', '94627', '53535', '15560', '41967', '69297', '11929', '59403', '33283', '52232', '57350', '43933', '40921', '36635', '10827', '71286', '19736', '80619', '25251', '95042', '15526', '36496', '55854', '49124', '81980', '35375', '49157', '63512', '28944', '14946', '36503', '54010', '18767', '23969', '43905', '66979', '33113', '21286', '58471', '59080', '13395', '79144', '70373', '67031', '38360', '26705', '50906', '52406', '26066', '73146', '15884', '31897', '30045', '61068', '45550', '92454', '13376', '14354', '19770', '22928', '97790', '50723', '46081', '30202', '14410', '20223', '88500', '67298', '13261', '14172', '81410', '93578', '83583', '46047', '94167', '82564', '21156', '15799', '86709', '37931', '74703', '83103', '2305
4', '70470', '72008', '49247', '91911', '69998', '20961', '70070', '63197', '54853', '88191', '91830', '49521', '19454', '81450', '89091', '62378', '25683', '61869', '51744', '36580', '85778', '36871', '48121', '28810', '83712', '45486', '67393', '26935', '42393', '20132', '55349', '86057', '21309', '80218', '10094', '11357', '48819', '39734', '40758', '30432', '21204', '29467', '30214', '61024', '55307', '74621', '11622', '68908', '33032', '52868', '99194', '99900', '84936', '69036', '99149', '45013', '32895', '59004', '32322', '14933', '32936', '33562', '72550', '27385', '58049', '58200', '16808', '21360', '32961', '18586', '79307', '15492')
-| runtime filters: RF002 -> substr(ca_zip, 1, 5)
+| runtime filters: RF004 -> substr(ca_zip, 1, 5)
|
08:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_store_sk = store.s_store_sk
-| runtime filters: RF001 <- store.s_store_sk
+| runtime filters: RF002 <- store.s_store_sk
|
|--JOIN BUILD
| | join-table-id=03 plan-id=04 cohort-id=01
@@ -649,7 +649,7 @@ PLAN-ROOT SINK
|
00:SCAN HDFS [tpcds.store_sales]
partitions=90/1824 files=90 size=9.71MB
- runtime filters: RF001 -> store_sales.ss_store_sk
+ runtime filters: RF002 -> store_sales.ss_store_sk
====
# TPCDS-Q19
select
@@ -708,15 +708,15 @@ PLAN-ROOT SINK
|
09:HASH JOIN [INNER JOIN]
| hash predicates: ca_address_sk = c_current_addr_sk
-| runtime filters: RF001 <- c_current_addr_sk
+| runtime filters: RF002 <- c_current_addr_sk
|
|--08:HASH JOIN [INNER JOIN]
| | hash predicates: c_customer_sk = ss_customer_sk
-| | runtime filters: RF002 <- ss_customer_sk
+| | runtime filters: RF004 <- ss_customer_sk
| |
| |--07:HASH JOIN [INNER JOIN]
| | | hash predicates: ss_sold_date_sk = d_date_sk
-| | | runtime filters: RF003 <- d_date_sk
+| | | runtime filters: RF006 <- d_date_sk
| | |
| | |--00:SCAN HDFS [tpcds.date_dim]
| | | partitions=1/1 files=1 size=9.84MB
@@ -724,7 +724,7 @@ PLAN-ROOT SINK
| | |
| | 06:HASH JOIN [INNER JOIN]
| | | hash predicates: ss_item_sk = i_item_sk
-| | | runtime filters: RF004 <- i_item_sk
+| | | runtime filters: RF008 <- i_item_sk
| | |
| | |--02:SCAN HDFS [tpcds.item]
| | | partitions=1/1 files=1 size=4.82MB
@@ -732,15 +732,15 @@ PLAN-ROOT SINK
| | |
| | 01:SCAN HDFS [tpcds.store_sales]
| | partitions=30/1824 files=30 size=9.93MB
-| | runtime filters: RF000 -> ss_store_sk, RF003 -> ss_sold_date_sk, RF004 -> ss_item_sk
+| | runtime filters: RF000 -> ss_store_sk, RF006 -> ss_sold_date_sk, RF008 -> ss_item_sk
| |
| 03:SCAN HDFS [tpcds.customer]
| partitions=1/1 files=1 size=12.60MB
-| runtime filters: RF002 -> c_customer_sk
+| runtime filters: RF004 -> c_customer_sk
|
04:SCAN HDFS [tpcds.customer_address]
partitions=1/1 files=1 size=5.25MB
- runtime filters: RF001 -> ca_address_sk
+ runtime filters: RF002 -> ca_address_sk
---- DISTRIBUTEDPLAN
PLAN-ROOT SINK
|
@@ -773,7 +773,7 @@ PLAN-ROOT SINK
|
09:HASH JOIN [INNER JOIN, PARTITIONED]
| hash predicates: c_current_addr_sk = ca_address_sk
-| runtime filters: RF001 <- ca_address_sk
+| runtime filters: RF002 <- ca_address_sk
|
|--18:EXCHANGE [HASH(ca_address_sk)]
| |
@@ -784,19 +784,19 @@ PLAN-ROOT SINK
|
08:HASH JOIN [INNER JOIN, PARTITIONED]
| hash predicates: ss_customer_sk = c_customer_sk
-| runtime filters: RF002 <- c_customer_sk
+| runtime filters: RF004 <- c_customer_sk
|
|--16:EXCHANGE [HASH(c_customer_sk)]
| |
| 03:SCAN HDFS [tpcds.customer]
| partitions=1/1 files=1 size=12.60MB
-| runtime filters: RF001 -> c_current_addr_sk
+| runtime filters: RF002 -> c_current_addr_sk
|
15:EXCHANGE [HASH(ss_customer_sk)]
|
07:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_sold_date_sk = d_date_sk
-| runtime filters: RF003 <- d_date_sk
+| runtime filters: RF006 <- d_date_sk
|
|--14:EXCHANGE [BROADCAST]
| |
@@ -806,7 +806,7 @@ PLAN-ROOT SINK
|
06:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_item_sk = i_item_sk
-| runtime filters: RF004 <- i_item_sk
+| runtime filters: RF008 <- i_item_sk
|
|--13:EXCHANGE [BROADCAST]
| |
@@ -816,7 +816,7 @@ PLAN-ROOT SINK
|
01:SCAN HDFS [tpcds.store_sales]
partitions=30/1824 files=30 size=9.93MB
- runtime filters: RF000 -> ss_store_sk, RF002 -> ss_customer_sk, RF003 -> ss_sold_date_sk, RF004 -> ss_item_sk
+ runtime filters: RF000 -> ss_store_sk, RF004 -> ss_customer_sk, RF006 -> ss_sold_date_sk, RF008 -> ss_item_sk
---- PARALLELPLANS
PLAN-ROOT SINK
|
@@ -853,7 +853,7 @@ PLAN-ROOT SINK
|
09:HASH JOIN [INNER JOIN, PARTITIONED]
| hash predicates: c_current_addr_sk = ca_address_sk
-| runtime filters: RF001 <- ca_address_sk
+| runtime filters: RF002 <- ca_address_sk
|
|--JOIN BUILD
| | join-table-id=01 plan-id=02 cohort-id=01
@@ -868,7 +868,7 @@ PLAN-ROOT SINK
|
08:HASH JOIN [INNER JOIN, PARTITIONED]
| hash predicates: ss_customer_sk = c_customer_sk
-| runtime filters: RF002 <- c_customer_sk
+| runtime filters: RF004 <- c_customer_sk
|
|--JOIN BUILD
| | join-table-id=02 plan-id=03 cohort-id=01
@@ -878,13 +878,13 @@ PLAN-ROOT SINK
| |
| 03:SCAN HDFS [tpcds.customer]
| partitions=1/1 files=1 size=12.60MB
-| runtime filters: RF001 -> c_current_addr_sk
+| runtime filters: RF002 -> c_current_addr_sk
|
15:EXCHANGE [HASH(ss_customer_sk)]
|
07:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_sold_date_sk = d_date_sk
-| runtime filters: RF003 <- d_date_sk
+| runtime filters: RF006 <- d_date_sk
|
|--JOIN BUILD
| | join-table-id=03 plan-id=04 cohort-id=01
@@ -898,7 +898,7 @@ PLAN-ROOT SINK
|
06:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_item_sk = i_item_sk
-| runtime filters: RF004 <- i_item_sk
+| runtime filters: RF008 <- i_item_sk
|
|--JOIN BUILD
| | join-table-id=04 plan-id=05 cohort-id=01
@@ -912,7 +912,7 @@ PLAN-ROOT SINK
|
01:SCAN HDFS [tpcds.store_sales]
partitions=30/1824 files=30 size=9.93MB
- runtime filters: RF000 -> ss_store_sk, RF002 -> ss_customer_sk, RF003 -> ss_sold_date_sk, RF004 -> ss_item_sk
+ runtime filters: RF000 -> ss_store_sk, RF004 -> ss_customer_sk, RF006 -> ss_sold_date_sk, RF008 -> ss_item_sk
====
# TPCDS-Q27
select
@@ -964,7 +964,7 @@ PLAN-ROOT SINK
|
07:HASH JOIN [INNER JOIN]
| hash predicates: ss_store_sk = s_store_sk
-| runtime filters: RF001 <- s_store_sk
+| runtime filters: RF002 <- s_store_sk
|
|--03:SCAN HDFS [tpcds.store]
| partitions=1/1 files=1 size=3.08KB
@@ -972,7 +972,7 @@ PLAN-ROOT SINK
|
06:HASH JOIN [INNER JOIN]
| hash predicates: ss_cdemo_sk = cd_demo_sk
-| runtime filters: RF002 <- cd_demo_sk
+| runtime filters: RF004 <- cd_demo_sk
|
|--01:SCAN HDFS [tpcds.customer_demographics]
| partitions=1/1 files=1 size=76.92MB
@@ -980,7 +980,7 @@ PLAN-ROOT SINK
|
05:HASH JOIN [INNER JOIN]
| hash predicates: ss_sold_date_sk = d_date_sk
-| runtime filters: RF003 <- d_date_sk
+| runtime filters: RF006 <- d_date_sk
|
|--02:SCAN HDFS [tpcds.date_dim]
| partitions=1/1 files=1 size=9.84MB
@@ -988,7 +988,7 @@ PLAN-ROOT SINK
|
00:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> ss_item_sk, RF001 -> ss_store_sk, RF002 -> ss_cdemo_sk, RF003 -> ss_sold_date_sk
+ runtime filters: RF000 -> ss_item_sk, RF002 -> ss_store_sk, RF004 -> ss_cdemo_sk, RF006 -> ss_sold_date_sk
---- DISTRIBUTEDPLAN
PLAN-ROOT SINK
|
@@ -1020,7 +1020,7 @@ PLAN-ROOT SINK
|
07:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_store_sk = s_store_sk
-| runtime filters: RF001 <- s_store_sk
+| runtime filters: RF002 <- s_store_sk
|
|--13:EXCHANGE [BROADCAST]
| |
@@ -1030,7 +1030,7 @@ PLAN-ROOT SINK
|
06:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_cdemo_sk = cd_demo_sk
-| runtime filters: RF002 <- cd_demo_sk
+| runtime filters: RF004 <- cd_demo_sk
|
|--12:EXCHANGE [BROADCAST]
| |
@@ -1040,7 +1040,7 @@ PLAN-ROOT SINK
|
05:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_sold_date_sk = d_date_sk
-| runtime filters: RF003 <- d_date_sk
+| runtime filters: RF006 <- d_date_sk
|
|--11:EXCHANGE [BROADCAST]
| |
@@ -1050,7 +1050,7 @@ PLAN-ROOT SINK
|
00:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> ss_item_sk, RF001 -> ss_store_sk, RF002 -> ss_cdemo_sk, RF003 -> ss_sold_date_sk
+ runtime filters: RF000 -> ss_item_sk, RF002 -> ss_store_sk, RF004 -> ss_cdemo_sk, RF006 -> ss_sold_date_sk
---- PARALLELPLANS
PLAN-ROOT SINK
|
@@ -1086,7 +1086,7 @@ PLAN-ROOT SINK
|
07:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_store_sk = s_store_sk
-| runtime filters: RF001 <- s_store_sk
+| runtime filters: RF002 <- s_store_sk
|
|--JOIN BUILD
| | join-table-id=01 plan-id=02 cohort-id=01
@@ -1100,7 +1100,7 @@ PLAN-ROOT SINK
|
06:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_cdemo_sk = cd_demo_sk
-| runtime filters: RF002 <- cd_demo_sk
+| runtime filters: RF004 <- cd_demo_sk
|
|--JOIN BUILD
| | join-table-id=02 plan-id=03 cohort-id=01
@@ -1114,7 +1114,7 @@ PLAN-ROOT SINK
|
05:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_sold_date_sk = d_date_sk
-| runtime filters: RF003 <- d_date_sk
+| runtime filters: RF006 <- d_date_sk
|
|--JOIN BUILD
| | join-table-id=03 plan-id=04 cohort-id=01
@@ -1128,7 +1128,7 @@ PLAN-ROOT SINK
|
00:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> ss_item_sk, RF001 -> ss_store_sk, RF002 -> ss_cdemo_sk, RF003 -> ss_sold_date_sk
+ runtime filters: RF000 -> ss_item_sk, RF002 -> ss_store_sk, RF004 -> ss_cdemo_sk, RF006 -> ss_sold_date_sk
====
# TPCDS-Q34
select
@@ -1191,7 +1191,7 @@ PLAN-ROOT SINK
| |
| 06:HASH JOIN [INNER JOIN]
| | hash predicates: store_sales.ss_store_sk = store.s_store_sk
-| | runtime filters: RF001 <- store.s_store_sk
+| | runtime filters: RF002 <- store.s_store_sk
| |
| |--02:SCAN HDFS [tpcds.store]
| | partitions=1/1 files=1 size=3.08KB
@@ -1199,7 +1199,7 @@ PLAN-ROOT SINK
| |
| 05:HASH JOIN [INNER JOIN]
| | hash predicates: store_sales.ss_sold_date_sk = date_dim.d_date_sk
-| | runtime filters: RF002 <- date_dim.d_date_sk
+| | runtime filters: RF004 <- date_dim.d_date_sk
| |
| |--01:SCAN HDFS [tpcds.date_dim]
| | partitions=1/1 files=1 size=9.84MB
@@ -1207,7 +1207,7 @@ PLAN-ROOT SINK
| |
| 04:HASH JOIN [INNER JOIN]
| | hash predicates: store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk
-| | runtime filters: RF003 <- household_demographics.hd_demo_sk
+| | runtime filters: RF006 <- household_demographics.hd_demo_sk
| |
| |--03:SCAN HDFS [tpcds.household_demographics]
| | partitions=1/1 files=1 size=148.10KB
@@ -1215,7 +1215,7 @@ PLAN-ROOT SINK
| |
| 00:SCAN HDFS [tpcds.store_sales]
| partitions=1824/1824 files=1824 size=326.32MB
-| runtime filters: RF001 -> store_sales.ss_store_sk, RF002 -> store_sales.ss_sold_date_sk, RF003 -> store_sales.ss_hdemo_sk
+| runtime filters: RF002 -> store_sales.ss_store_sk, RF004 -> store_sales.ss_sold_date_sk, RF006 -> store_sales.ss_hdemo_sk
|
08:SCAN HDFS [tpcds.customer]
partitions=1/1 files=1 size=12.60MB
@@ -1254,7 +1254,7 @@ PLAN-ROOT SINK
|
06:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_store_sk = store.s_store_sk
-| runtime filters: RF001 <- store.s_store_sk
+| runtime filters: RF002 <- store.s_store_sk
|
|--13:EXCHANGE [BROADCAST]
| |
@@ -1264,7 +1264,7 @@ PLAN-ROOT SINK
|
05:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_sold_date_sk = date_dim.d_date_sk
-| runtime filters: RF002 <- date_dim.d_date_sk
+| runtime filters: RF004 <- date_dim.d_date_sk
|
|--12:EXCHANGE [BROADCAST]
| |
@@ -1274,7 +1274,7 @@ PLAN-ROOT SINK
|
04:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk
-| runtime filters: RF003 <- household_demographics.hd_demo_sk
+| runtime filters: RF006 <- household_demographics.hd_demo_sk
|
|--11:EXCHANGE [BROADCAST]
| |
@@ -1284,7 +1284,7 @@ PLAN-ROOT SINK
|
00:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> tpcds.store_sales.ss_customer_sk, RF001 -> store_sales.ss_store_sk, RF002 -> store_sales.ss_sold_date_sk, RF003 -> store_sales.ss_hdemo_sk
+ runtime filters: RF000 -> tpcds.store_sales.ss_customer_sk, RF002 -> store_sales.ss_store_sk, RF004 -> store_sales.ss_sold_date_sk, RF006 -> store_sales.ss_hdemo_sk
---- PARALLELPLANS
PLAN-ROOT SINK
|
@@ -1323,7 +1323,7 @@ PLAN-ROOT SINK
|
06:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_store_sk = store.s_store_sk
-| runtime filters: RF001 <- store.s_store_sk
+| runtime filters: RF002 <- store.s_store_sk
|
|--JOIN BUILD
| | join-table-id=01 plan-id=02 cohort-id=01
@@ -1337,7 +1337,7 @@ PLAN-ROOT SINK
|
05:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_sold_date_sk = date_dim.d_date_sk
-| runtime filters: RF002 <- date_dim.d_date_sk
+| runtime filters: RF004 <- date_dim.d_date_sk
|
|--JOIN BUILD
| | join-table-id=02 plan-id=03 cohort-id=01
@@ -1351,7 +1351,7 @@ PLAN-ROOT SINK
|
04:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk
-| runtime filters: RF003 <- household_demographics.hd_demo_sk
+| runtime filters: RF006 <- household_demographics.hd_demo_sk
|
|--JOIN BUILD
| | join-table-id=03 plan-id=04 cohort-id=01
@@ -1365,7 +1365,7 @@ PLAN-ROOT SINK
|
00:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> tpcds.store_sales.ss_customer_sk, RF001 -> store_sales.ss_store_sk, RF002 -> store_sales.ss_sold_date_sk, RF003 -> store_sales.ss_hdemo_sk
+ runtime filters: RF000 -> tpcds.store_sales.ss_customer_sk, RF002 -> store_sales.ss_store_sk, RF004 -> store_sales.ss_sold_date_sk, RF006 -> store_sales.ss_hdemo_sk
====
# TPCDS-Q42
select
@@ -1413,7 +1413,7 @@ PLAN-ROOT SINK
|
03:HASH JOIN [INNER JOIN]
| hash predicates: store_sales.ss_item_sk = item.i_item_sk
-| runtime filters: RF001 <- item.i_item_sk
+| runtime filters: RF002 <- item.i_item_sk
|
|--02:SCAN HDFS [tpcds.item]
| partitions=1/1 files=1 size=4.82MB
@@ -1421,7 +1421,7 @@ PLAN-ROOT SINK
|
01:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> store_sales.ss_sold_date_sk, RF001 -> store_sales.ss_item_sk
+ runtime filters: RF000 -> store_sales.ss_sold_date_sk, RF002 -> store_sales.ss_item_sk
---- DISTRIBUTEDPLAN
PLAN-ROOT SINK
|
@@ -1454,7 +1454,7 @@ PLAN-ROOT SINK
|
03:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_item_sk = item.i_item_sk
-| runtime filters: RF001 <- item.i_item_sk
+| runtime filters: RF002 <- item.i_item_sk
|
|--07:EXCHANGE [BROADCAST]
| |
@@ -1464,7 +1464,7 @@ PLAN-ROOT SINK
|
01:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> store_sales.ss_sold_date_sk, RF001 -> store_sales.ss_item_sk
+ runtime filters: RF000 -> store_sales.ss_sold_date_sk, RF002 -> store_sales.ss_item_sk
---- PARALLELPLANS
PLAN-ROOT SINK
|
@@ -1501,7 +1501,7 @@ PLAN-ROOT SINK
|
03:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_item_sk = item.i_item_sk
-| runtime filters: RF001 <- item.i_item_sk
+| runtime filters: RF002 <- item.i_item_sk
|
|--JOIN BUILD
| | join-table-id=01 plan-id=02 cohort-id=01
@@ -1515,7 +1515,7 @@ PLAN-ROOT SINK
|
01:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> store_sales.ss_sold_date_sk, RF001 -> store_sales.ss_item_sk
+ runtime filters: RF000 -> store_sales.ss_sold_date_sk, RF002 -> store_sales.ss_item_sk
====
# TPCDS-Q43
select
@@ -1571,7 +1571,7 @@ PLAN-ROOT SINK
|
03:HASH JOIN [INNER JOIN]
| hash predicates: ss_sold_date_sk = d_date_sk
-| runtime filters: RF001 <- d_date_sk
+| runtime filters: RF002 <- d_date_sk
|
|--00:SCAN HDFS [tpcds.date_dim]
| partitions=1/1 files=1 size=9.84MB
@@ -1579,7 +1579,7 @@ PLAN-ROOT SINK
|
01:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> ss_store_sk, RF001 -> ss_sold_date_sk
+ runtime filters: RF000 -> ss_store_sk, RF002 -> ss_sold_date_sk
---- DISTRIBUTEDPLAN
PLAN-ROOT SINK
|
@@ -1612,7 +1612,7 @@ PLAN-ROOT SINK
|
03:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_sold_date_sk = d_date_sk
-| runtime filters: RF001 <- d_date_sk
+| runtime filters: RF002 <- d_date_sk
|
|--07:EXCHANGE [BROADCAST]
| |
@@ -1622,7 +1622,7 @@ PLAN-ROOT SINK
|
01:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> ss_store_sk, RF001 -> ss_sold_date_sk
+ runtime filters: RF000 -> ss_store_sk, RF002 -> ss_sold_date_sk
---- PARALLELPLANS
PLAN-ROOT SINK
|
@@ -1659,7 +1659,7 @@ PLAN-ROOT SINK
|
03:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_sold_date_sk = d_date_sk
-| runtime filters: RF001 <- d_date_sk
+| runtime filters: RF002 <- d_date_sk
|
|--JOIN BUILD
| | join-table-id=01 plan-id=02 cohort-id=01
@@ -1673,7 +1673,7 @@ PLAN-ROOT SINK
|
01:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> ss_store_sk, RF001 -> ss_sold_date_sk
+ runtime filters: RF000 -> ss_store_sk, RF002 -> ss_sold_date_sk
====
# TPCDS-Q46
select
@@ -1742,7 +1742,7 @@ PLAN-ROOT SINK
|
12:HASH JOIN [INNER JOIN]
| hash predicates: ss_customer_sk = c_customer_sk
-| runtime filters: RF001 <- c_customer_sk
+| runtime filters: RF002 <- c_customer_sk
|
|--10:SCAN HDFS [tpcds.customer]
| partitions=1/1 files=1 size=12.60MB
@@ -1754,14 +1754,14 @@ PLAN-ROOT SINK
|
08:HASH JOIN [INNER JOIN]
| hash predicates: store_sales.ss_addr_sk = customer_address.ca_address_sk
-| runtime filters: RF002 <- customer_address.ca_address_sk
+| runtime filters: RF004 <- customer_address.ca_address_sk
|
|--04:SCAN HDFS [tpcds.customer_address]
| partitions=1/1 files=1 size=5.25MB
|
07:HASH JOIN [INNER JOIN]
| hash predicates: store_sales.ss_store_sk = store.s_store_sk
-| runtime filters: RF003 <- store.s_store_sk
+| runtime filters: RF006 <- store.s_store_sk
|
|--02:SCAN HDFS [tpcds.store]
| partitions=1/1 files=1 size=3.08KB
@@ -1769,7 +1769,7 @@ PLAN-ROOT SINK
|
06:HASH JOIN [INNER JOIN]
| hash predicates: store_sales.ss_sold_date_sk = date_dim.d_date_sk
-| runtime filters: RF004 <- date_dim.d_date_sk
+| runtime filters: RF008 <- date_dim.d_date_sk
|
|--01:SCAN HDFS [tpcds.date_dim]
| partitions=1/1 files=1 size=9.84MB
@@ -1777,7 +1777,7 @@ PLAN-ROOT SINK
|
05:HASH JOIN [INNER JOIN]
| hash predicates: store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk
-| runtime filters: RF005 <- household_demographics.hd_demo_sk
+| runtime filters: RF010 <- household_demographics.hd_demo_sk
|
|--03:SCAN HDFS [tpcds.household_demographics]
| partitions=1/1 files=1 size=148.10KB
@@ -1785,7 +1785,7 @@ PLAN-ROOT SINK
|
00:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF001 -> tpcds.store_sales.ss_customer_sk, RF002 -> store_sales.ss_addr_sk, RF003 -> store_sales.ss_store_sk, RF004 -> store_sales.ss_sold_date_sk, RF005 -> store_sales.ss_hdemo_sk
+ runtime filters: RF002 -> tpcds.store_sales.ss_customer_sk, RF004 -> store_sales.ss_addr_sk, RF006 -> store_sales.ss_store_sk, RF008 -> store_sales.ss_sold_date_sk, RF010 -> store_sales.ss_hdemo_sk
---- DISTRIBUTEDPLAN
PLAN-ROOT SINK
|
@@ -1808,7 +1808,7 @@ PLAN-ROOT SINK
|
12:HASH JOIN [INNER JOIN, PARTITIONED]
| hash predicates: ss_customer_sk = c_customer_sk
-| runtime filters: RF001 <- c_customer_sk
+| runtime filters: RF002 <- c_customer_sk
|
|--22:EXCHANGE [HASH(c_customer_sk)]
| |
@@ -1830,7 +1830,7 @@ PLAN-ROOT SINK
|
08:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_addr_sk = customer_address.ca_address_sk
-| runtime filters: RF002 <- customer_address.ca_address_sk
+| runtime filters: RF004 <- customer_address.ca_address_sk
|
|--18:EXCHANGE [BROADCAST]
| |
@@ -1839,7 +1839,7 @@ PLAN-ROOT SINK
|
07:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_store_sk = store.s_store_sk
-| runtime filters: RF003 <- store.s_store_sk
+| runtime filters: RF006 <- store.s_store_sk
|
|--17:EXCHANGE [BROADCAST]
| |
@@ -1849,7 +1849,7 @@ PLAN-ROOT SINK
|
06:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_sold_date_sk = date_dim.d_date_sk
-| runtime filters: RF004 <- date_dim.d_date_sk
+| runtime filters: RF008 <- date_dim.d_date_sk
|
|--16:EXCHANGE [BROADCAST]
| |
@@ -1859,7 +1859,7 @@ PLAN-ROOT SINK
|
05:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk
-| runtime filters: RF005 <- household_demographics.hd_demo_sk
+| runtime filters: RF010 <- household_demographics.hd_demo_sk
|
|--15:EXCHANGE [BROADCAST]
| |
@@ -1869,7 +1869,7 @@ PLAN-ROOT SINK
|
00:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF001 -> tpcds.store_sales.ss_customer_sk, RF002 -> store_sales.ss_addr_sk, RF003 -> store_sales.ss_store_sk, RF004 -> store_sales.ss_sold_date_sk, RF005 -> store_sales.ss_hdemo_sk
+ runtime filters: RF002 -> tpcds.store_sales.ss_customer_sk, RF004 -> store_sales.ss_addr_sk, RF006 -> store_sales.ss_store_sk, RF008 -> store_sales.ss_sold_date_sk, RF010 -> store_sales.ss_hdemo_sk
---- PARALLELPLANS
PLAN-ROOT SINK
|
@@ -1896,7 +1896,7 @@ PLAN-ROOT SINK
|
12:HASH JOIN [INNER JOIN, PARTITIONED]
| hash predicates: ss_customer_sk = c_customer_sk
-| runtime filters: RF001 <- c_customer_sk
+| runtime filters: RF002 <- c_customer_sk
|
|--JOIN BUILD
| | join-table-id=01 plan-id=02 cohort-id=01
@@ -1922,7 +1922,7 @@ PLAN-ROOT SINK
|
08:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_addr_sk = customer_address.ca_address_sk
-| runtime filters: RF002 <- customer_address.ca_address_sk
+| runtime filters: RF004 <- customer_address.ca_address_sk
|
|--JOIN BUILD
| | join-table-id=02 plan-id=03 cohort-id=01
@@ -1935,7 +1935,7 @@ PLAN-ROOT SINK
|
07:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_store_sk = store.s_store_sk
-| runtime filters: RF003 <- store.s_store_sk
+| runtime filters: RF006 <- store.s_store_sk
|
|--JOIN BUILD
| | join-table-id=03 plan-id=04 cohort-id=01
@@ -1949,7 +1949,7 @@ PLAN-ROOT SINK
|
06:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_sold_date_sk = date_dim.d_date_sk
-| runtime filters: RF004 <- date_dim.d_date_sk
+| runtime filters: RF008 <- date_dim.d_date_sk
|
|--JOIN BUILD
| | join-table-id=04 plan-id=05 cohort-id=01
@@ -1963,7 +1963,7 @@ PLAN-ROOT SINK
|
05:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk
-| runtime filters: RF005 <- household_demographics.hd_demo_sk
+| runtime filters: RF010 <- household_demographics.hd_demo_sk
|
|--JOIN BUILD
| | join-table-id=05 plan-id=06 cohort-id=01
@@ -1977,7 +1977,7 @@ PLAN-ROOT SINK
|
00:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF001 -> tpcds.store_sales.ss_customer_sk, RF002 -> store_sales.ss_addr_sk, RF003 -> store_sales.ss_store_sk, RF004 -> store_sales.ss_sold_date_sk, RF005 -> store_sales.ss_hdemo_sk
+ runtime filters: RF002 -> tpcds.store_sales.ss_customer_sk, RF004 -> store_sales.ss_addr_sk, RF006 -> store_sales.ss_store_sk, RF008 -> store_sales.ss_sold_date_sk, RF010 -> store_sales.ss_hdemo_sk
====
# TPCDS-Q52
select
@@ -2024,7 +2024,7 @@ PLAN-ROOT SINK
|
03:HASH JOIN [INNER JOIN]
| hash predicates: store_sales.ss_item_sk = item.i_item_sk
-| runtime filters: RF001 <- item.i_item_sk
+| runtime filters: RF002 <- item.i_item_sk
|
|--02:SCAN HDFS [tpcds.item]
| partitions=1/1 files=1 size=4.82MB
@@ -2032,7 +2032,7 @@ PLAN-ROOT SINK
|
01:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> store_sales.ss_sold_date_sk, RF001 -> store_sales.ss_item_sk
+ runtime filters: RF000 -> store_sales.ss_sold_date_sk, RF002 -> store_sales.ss_item_sk
---- DISTRIBUTEDPLAN
PLAN-ROOT SINK
|
@@ -2065,7 +2065,7 @@ PLAN-ROOT SINK
|
03:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_item_sk = item.i_item_sk
-| runtime filters: RF001 <- item.i_item_sk
+| runtime filters: RF002 <- item.i_item_sk
|
|--07:EXCHANGE [BROADCAST]
| |
@@ -2075,7 +2075,7 @@ PLAN-ROOT SINK
|
01:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> store_sales.ss_sold_date_sk, RF001 -> store_sales.ss_item_sk
+ runtime filters: RF000 -> store_sales.ss_sold_date_sk, RF002 -> store_sales.ss_item_sk
---- PARALLELPLANS
PLAN-ROOT SINK
|
@@ -2112,7 +2112,7 @@ PLAN-ROOT SINK
|
03:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_item_sk = item.i_item_sk
-| runtime filters: RF001 <- item.i_item_sk
+| runtime filters: RF002 <- item.i_item_sk
|
|--JOIN BUILD
| | join-table-id=01 plan-id=02 cohort-id=01
@@ -2126,7 +2126,7 @@ PLAN-ROOT SINK
|
01:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> store_sales.ss_sold_date_sk, RF001 -> store_sales.ss_item_sk
+ runtime filters: RF000 -> store_sales.ss_sold_date_sk, RF002 -> store_sales.ss_item_sk
====
# TPCDS-Q53
select
@@ -2178,7 +2178,7 @@ PLAN-ROOT SINK
|
05:HASH JOIN [INNER JOIN]
| hash predicates: ss_sold_date_sk = d_date_sk
-| runtime filters: RF001 <- d_date_sk
+| runtime filters: RF002 <- d_date_sk
|
|--02:SCAN HDFS [tpcds.date_dim]
| partitions=1/1 files=1 size=9.84MB
@@ -2186,7 +2186,7 @@ PLAN-ROOT SINK
|
04:HASH JOIN [INNER JOIN]
| hash predicates: ss_item_sk = i_item_sk
-| runtime filters: RF002 <- i_item_sk
+| runtime filters: RF004 <- i_item_sk
|
|--00:SCAN HDFS [tpcds.item]
| partitions=1/1 files=1 size=4.82MB
@@ -2194,7 +2194,7 @@ PLAN-ROOT SINK
|
01:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> ss_store_sk, RF001 -> ss_sold_date_sk, RF002 -> ss_item_sk
+ runtime filters: RF000 -> ss_store_sk, RF002 -> ss_sold_date_sk, RF004 -> ss_item_sk
---- DISTRIBUTEDPLAN
PLAN-ROOT SINK
|
@@ -2226,7 +2226,7 @@ PLAN-ROOT SINK
|
05:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_sold_date_sk = d_date_sk
-| runtime filters: RF001 <- d_date_sk
+| runtime filters: RF002 <- d_date_sk
|
|--10:EXCHANGE [BROADCAST]
| |
@@ -2236,7 +2236,7 @@ PLAN-ROOT SINK
|
04:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_item_sk = i_item_sk
-| runtime filters: RF002 <- i_item_sk
+| runtime filters: RF004 <- i_item_sk
|
|--09:EXCHANGE [BROADCAST]
| |
@@ -2246,7 +2246,7 @@ PLAN-ROOT SINK
|
01:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> ss_store_sk, RF001 -> ss_sold_date_sk, RF002 -> ss_item_sk
+ runtime filters: RF000 -> ss_store_sk, RF002 -> ss_sold_date_sk, RF004 -> ss_item_sk
---- PARALLELPLANS
PLAN-ROOT SINK
|
@@ -2282,7 +2282,7 @@ PLAN-ROOT SINK
|
05:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_sold_date_sk = d_date_sk
-| runtime filters: RF001 <- d_date_sk
+| runtime filters: RF002 <- d_date_sk
|
|--JOIN BUILD
| | join-table-id=01 plan-id=02 cohort-id=01
@@ -2296,7 +2296,7 @@ PLAN-ROOT SINK
|
04:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_item_sk = i_item_sk
-| runtime filters: RF002 <- i_item_sk
+| runtime filters: RF004 <- i_item_sk
|
|--JOIN BUILD
| | join-table-id=02 plan-id=03 cohort-id=01
@@ -2310,7 +2310,7 @@ PLAN-ROOT SINK
|
01:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> ss_store_sk, RF001 -> ss_sold_date_sk, RF002 -> ss_item_sk
+ runtime filters: RF000 -> ss_store_sk, RF002 -> ss_sold_date_sk, RF004 -> ss_item_sk
====
# TPCDS-Q55
select
@@ -2354,7 +2354,7 @@ PLAN-ROOT SINK
|
03:HASH JOIN [INNER JOIN]
| hash predicates: ss_item_sk = i_item_sk
-| runtime filters: RF001 <- i_item_sk
+| runtime filters: RF002 <- i_item_sk
|
|--02:SCAN HDFS [tpcds.item]
| partitions=1/1 files=1 size=4.82MB
@@ -2362,7 +2362,7 @@ PLAN-ROOT SINK
|
01:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> ss_sold_date_sk, RF001 -> ss_item_sk
+ runtime filters: RF000 -> ss_sold_date_sk, RF002 -> ss_item_sk
---- DISTRIBUTEDPLAN
PLAN-ROOT SINK
|
@@ -2395,7 +2395,7 @@ PLAN-ROOT SINK
|
03:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_item_sk = i_item_sk
-| runtime filters: RF001 <- i_item_sk
+| runtime filters: RF002 <- i_item_sk
|
|--07:EXCHANGE [BROADCAST]
| |
@@ -2405,7 +2405,7 @@ PLAN-ROOT SINK
|
01:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> ss_sold_date_sk, RF001 -> ss_item_sk
+ runtime filters: RF000 -> ss_sold_date_sk, RF002 -> ss_item_sk
---- PARALLELPLANS
PLAN-ROOT SINK
|
@@ -2442,7 +2442,7 @@ PLAN-ROOT SINK
|
03:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_item_sk = i_item_sk
-| runtime filters: RF001 <- i_item_sk
+| runtime filters: RF002 <- i_item_sk
|
|--JOIN BUILD
| | join-table-id=01 plan-id=02 cohort-id=01
@@ -2456,7 +2456,7 @@ PLAN-ROOT SINK
|
01:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> ss_sold_date_sk, RF001 -> ss_item_sk
+ runtime filters: RF000 -> ss_sold_date_sk, RF002 -> ss_item_sk
====
# TPCDS-Q59
with
@@ -2552,14 +2552,14 @@ PLAN-ROOT SINK
|
|--15:HASH JOIN [INNER JOIN]
| | hash predicates: ss_store_sk = s_store_sk
-| | runtime filters: RF005 <- s_store_sk
+| | runtime filters: RF010 <- s_store_sk
| |
| |--12:SCAN HDFS [tpcds.store]
| | partitions=1/1 files=1 size=3.08KB
| |
| 14:HASH JOIN [INNER JOIN]
| | hash predicates: d_week_seq = d.d_week_seq
-| | runtime filters: RF006 <- d.d_week_seq
+| | runtime filters: RF012 <- d.d_week_seq
| |
| |--13:SCAN HDFS [tpcds.date_dim d]
| | partitions=1/1 files=1 size=9.84MB
@@ -2571,19 +2571,19 @@ PLAN-ROOT SINK
| |
| 10:HASH JOIN [INNER JOIN]
| | hash predicates: ss_sold_date_sk = d_date_sk
-| | runtime filters: RF007 <- d_date_sk
+| | runtime filters: RF014 <- d_date_sk
| |
| |--09:SCAN HDFS [tpcds.date_dim]
| | partitions=1/1 files=1 size=9.84MB
-| | runtime filters: RF006 -> tpcds.date_dim.d_week_seq
+| | runtime filters: RF012 -> tpcds.date_dim.d_week_seq
| |
| 08:SCAN HDFS [tpcds.store_sales]
| partitions=1824/1824 files=1824 size=326.32MB
-| runtime filters: RF005 -> tpcds.store_sales.ss_store_sk, RF007 -> ss_sold_date_sk
+| runtime filters: RF010 -> tpcds.store_sales.ss_store_sk, RF014 -> ss_sold_date_sk
|
07:HASH JOIN [INNER JOIN]
| hash predicates: ss_store_sk = s_store_sk
-| runtime filters: RF002 <- s_store_sk
+| runtime filters: RF004 <- s_store_sk
|
|--04:SCAN HDFS [tpcds.store]
| partitions=1/1 files=1 size=3.08KB
@@ -2591,7 +2591,7 @@ PLAN-ROOT SINK
|
06:HASH JOIN [INNER JOIN]
| hash predicates: d_week_seq = d.d_week_seq
-| runtime filters: RF003 <- d.d_week_seq
+| runtime filters: RF006 <- d.d_week_seq
|
|--05:SCAN HDFS [tpcds.date_dim d]
| partitions=1/1 files=1 size=9.84MB
@@ -2604,15 +2604,15 @@ PLAN-ROOT SINK
|
02:HASH JOIN [INNER JOIN]
| hash predicates: ss_sold_date_sk = d_date_sk
-| runtime filters: RF004 <- d_date_sk
+| runtime filters: RF008 <- d_date_sk
|
|--01:SCAN HDFS [tpcds.date_dim]
| partitions=1/1 files=1 size=9.84MB
-| runtime filters: RF000 -> tpcds.date_dim.d_week_seq, RF003 -> tpcds.date_dim.d_week_seq
+| runtime filters: RF000 -> tpcds.date_dim.d_week_seq, RF006 -> tpcds.date_dim.d_week_seq
|
00:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF002 -> tpcds.store_sales.ss_store_sk, RF004 -> ss_sold_date_sk
+ runtime filters: RF004 -> tpcds.store_sales.ss_store_sk, RF008 -> ss_sold_date_sk
---- DISTRIBUTEDPLAN
PLAN-ROOT SINK
|
@@ -2631,7 +2631,7 @@ PLAN-ROOT SINK
| |
| 15:HASH JOIN [INNER JOIN, BROADCAST]
| | hash predicates: ss_store_sk = s_store_sk
-| | runtime filters: RF005 <- s_store_sk
+| | runtime filters: RF010 <- s_store_sk
| |
| |--27:EXCHANGE [BROADCAST]
| | |
@@ -2640,7 +2640,7 @@ PLAN-ROOT SINK
| |
| 14:HASH JOIN [INNER JOIN, BROADCAST]
| | hash predicates: d_week_seq = d.d_week_seq
-| | runtime filters: RF006 <- d.d_week_seq
+| | runtime filters: RF012 <- d.d_week_seq
| |
| |--26:EXCHANGE [BROADCAST]
| | |
@@ -2660,23 +2660,23 @@ PLAN-ROOT SINK
| |
| 10:HASH JOIN [INNER JOIN, BROADCAST]
| | hash predicates: ss_sold_date_sk = d_date_sk
-| | runtime filters: RF007 <- d_date_sk
+| | runtime filters: RF014 <- d_date_sk
| |
| |--23:EXCHANGE [BROADCAST]
| | |
| | 09:SCAN HDFS [tpcds.date_dim]
| | partitions=1/1 files=1 size=9.84MB
-| | runtime filters: RF006 -> tpcds.date_dim.d_week_seq
+| | runtime filters: RF012 -> tpcds.date_dim.d_week_seq
| |
| 08:SCAN HDFS [tpcds.store_sales]
| partitions=1824/1824 files=1824 size=326.32MB
-| runtime filters: RF005 -> tpcds.store_sales.ss_store_sk, RF007 -> ss_sold_date_sk
+| runtime filters: RF010 -> tpcds.store_sales.ss_store_sk, RF014 -> ss_sold_date_sk
|
28:EXCHANGE [HASH(d_week_seq,s_store_id)]
|
07:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_store_sk = s_store_sk
-| runtime filters: RF002 <- s_store_sk
+| runtime filters: RF004 <- s_store_sk
|
|--22:EXCHANGE [BROADCAST]
| |
@@ -2686,7 +2686,7 @@ PLAN-ROOT SINK
|
06:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: d_week_seq = d.d_week_seq
-| runtime filters: RF003 <- d.d_week_seq
+| runtime filters: RF006 <- d.d_week_seq
|
|--21:EXCHANGE [BROADCAST]
| |
@@ -2707,17 +2707,17 @@ PLAN-ROOT SINK
|
02:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_sold_date_sk = d_date_sk
-| runtime filters: RF004 <- d_date_sk
+| runtime filters: RF008 <- d_date_sk
|
|--18:EXCHANGE [BROADCAST]
| |
| 01:SCAN HDFS [tpcds.date_dim]
| partitions=1/1 files=1 size=9.84MB
-| runtime filters: RF000 -> tpcds.date_dim.d_week_seq, RF003 -> tpcds.date_dim.d_week_seq
+| runtime filters: RF000 -> tpcds.date_dim.d_week_seq, RF006 -> tpcds.date_dim.d_week_seq
|
00:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF002 -> tpcds.store_sales.ss_store_sk, RF004 -> ss_sold_date_sk
+ runtime filters: RF004 -> tpcds.store_sales.ss_store_sk, RF008 -> ss_sold_date_sk
---- PARALLELPLANS
PLAN-ROOT SINK
|
@@ -2740,7 +2740,7 @@ PLAN-ROOT SINK
| |
| 15:HASH JOIN [INNER JOIN, BROADCAST]
| | hash predicates: ss_store_sk = s_store_sk
-| | runtime filters: RF005 <- s_store_sk
+| | runtime filters: RF010 <- s_store_sk
| |
| |--JOIN BUILD
| | | join-table-id=01 plan-id=02 cohort-id=02
@@ -2753,7 +2753,7 @@ PLAN-ROOT SINK
| |
| 14:HASH JOIN [INNER JOIN, BROADCAST]
| | hash predicates: d_week_seq = d.d_week_seq
-| | runtime filters: RF006 <- d.d_week_seq
+| | runtime filters: RF012 <- d.d_week_seq
| |
| |--JOIN BUILD
| | | join-table-id=02 plan-id=03 cohort-id=02
@@ -2777,7 +2777,7 @@ PLAN-ROOT SINK
| |
| 10:HASH JOIN [INNER JOIN, BROADCAST]
| | hash predicates: ss_sold_date_sk = d_date_sk
-| | runtime filters: RF007 <- d_date_sk
+| | runtime filters: RF014 <- d_date_sk
| |
| |--JOIN BUILD
| | | join-table-id=03 plan-id=04 cohort-id=02
@@ -2787,17 +2787,17 @@ PLAN-ROOT SINK
| | |
| | 09:SCAN HDFS [tpcds.date_dim]
| | partitions=1/1 files=1 size=9.84MB
-| | runtime filters: RF006 -> tpcds.date_dim.d_week_seq
+| | runtime filters: RF012 -> tpcds.date_dim.d_week_seq
| |
| 08:SCAN HDFS [tpcds.store_sales]
| partitions=1824/1824 files=1824 size=326.32MB
-| runtime filters: RF005 -> tpcds.store_sales.ss_store_sk, RF007 -> ss_sold_date_sk
+| runtime filters: RF010 -> tpcds.store_sales.ss_store_sk, RF014 -> ss_sold_date_sk
|
28:EXCHANGE [HASH(d_week_seq,s_store_id)]
|
07:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_store_sk = s_store_sk
-| runtime filters: RF002 <- s_store_sk
+| runtime filters: RF004 <- s_store_sk
|
|--JOIN BUILD
| | join-table-id=04 plan-id=05 cohort-id=01
@@ -2811,7 +2811,7 @@ PLAN-ROOT SINK
|
06:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: d_week_seq = d.d_week_seq
-| runtime filters: RF003 <- d.d_week_seq
+| runtime filters: RF006 <- d.d_week_seq
|
|--JOIN BUILD
| | join-table-id=05 plan-id=06 cohort-id=01
@@ -2836,7 +2836,7 @@ PLAN-ROOT SINK
|
02:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_sold_date_sk = d_date_sk
-| runtime filters: RF004 <- d_date_sk
+| runtime filters: RF008 <- d_date_sk
|
|--JOIN BUILD
| | join-table-id=06 plan-id=07 cohort-id=01
@@ -2846,11 +2846,11 @@ PLAN-ROOT SINK
| |
| 01:SCAN HDFS [tpcds.date_dim]
| partitions=1/1 files=1 size=9.84MB
-| runtime filters: RF000 -> tpcds.date_dim.d_week_seq, RF003 -> tpcds.date_dim.d_week_seq
+| runtime filters: RF000 -> tpcds.date_dim.d_week_seq, RF006 -> tpcds.date_dim.d_week_seq
|
00:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF002 -> tpcds.store_sales.ss_store_sk, RF004 -> ss_sold_date_sk
+ runtime filters: RF004 -> tpcds.store_sales.ss_store_sk, RF008 -> ss_sold_date_sk
====
# TPCDS-Q63
select
@@ -2917,7 +2917,7 @@ PLAN-ROOT SINK
|
05:HASH JOIN [INNER JOIN]
| hash predicates: ss_sold_date_sk = d_date_sk
-| runtime filters: RF001 <- d_date_sk
+| runtime filters: RF002 <- d_date_sk
|
|--02:SCAN HDFS [tpcds.date_dim]
| partitions=1/1 files=1 size=9.84MB
@@ -2925,7 +2925,7 @@ PLAN-ROOT SINK
|
04:HASH JOIN [INNER JOIN]
| hash predicates: ss_item_sk = i_item_sk
-| runtime filters: RF002 <- i_item_sk
+| runtime filters: RF004 <- i_item_sk
|
|--00:SCAN HDFS [tpcds.item]
| partitions=1/1 files=1 size=4.82MB
@@ -2933,7 +2933,7 @@ PLAN-ROOT SINK
|
01:SCAN HDFS [tpcds.store_sales]
partitions=364/1824 files=364 size=62.92MB
- runtime filters: RF000 -> ss_store_sk, RF001 -> ss_sold_date_sk, RF002 -> ss_item_sk
+ runtime filters: RF000 -> ss_store_sk, RF002 -> ss_sold_date_sk, RF004 -> ss_item_sk
---- DISTRIBUTEDPLAN
PLAN-ROOT SINK
|
@@ -2975,7 +2975,7 @@ PLAN-ROOT SINK
|
05:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_sold_date_sk = d_date_sk
-| runtime filters: RF001 <- d_date_sk
+| runtime filters: RF002 <- d_date_sk
|
|--13:EXCHANGE [BROADCAST]
| |
@@ -2985,7 +2985,7 @@ PLAN-ROOT SINK
|
04:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_item_sk = i_item_sk
-| runtime filters: RF002 <- i_item_sk
+| runtime filters: RF004 <- i_item_sk
|
|--12:EXCHANGE [BROADCAST]
| |
@@ -2995,7 +2995,7 @@ PLAN-ROOT SINK
|
01:SCAN HDFS [tpcds.store_sales]
partitions=364/1824 files=364 size=62.92MB
- runtime filters: RF000 -> ss_store_sk, RF001 -> ss_sold_date_sk, RF002 -> ss_item_sk
+ runtime filters: RF000 -> ss_store_sk, RF002 -> ss_sold_date_sk, RF004 -> ss_item_sk
---- PARALLELPLANS
PLAN-ROOT SINK
|
@@ -3041,7 +3041,7 @@ PLAN-ROOT SINK
|
05:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_sold_date_sk = d_date_sk
-| runtime filters: RF001 <- d_date_sk
+| runtime filters: RF002 <- d_date_sk
|
|--JOIN BUILD
| | join-table-id=01 plan-id=02 cohort-id=01
@@ -3055,7 +3055,7 @@ PLAN-ROOT SINK
|
04:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_item_sk = i_item_sk
-| runtime filters: RF002 <- i_item_sk
+| runtime filters: RF004 <- i_item_sk
|
|--JOIN BUILD
| | join-table-id=02 plan-id=03 cohort-id=01
@@ -3069,7 +3069,7 @@ PLAN-ROOT SINK
|
01:SCAN HDFS [tpcds.store_sales]
partitions=364/1824 files=364 size=62.92MB
- runtime filters: RF000 -> ss_store_sk, RF001 -> ss_sold_date_sk, RF002 -> ss_item_sk
+ runtime filters: RF000 -> ss_store_sk, RF002 -> ss_sold_date_sk, RF004 -> ss_item_sk
====
# TPCDS-Q65
select
@@ -3147,7 +3147,7 @@ PLAN-ROOT SINK
| |
| 04:HASH JOIN [INNER JOIN]
| | hash predicates: ss_sold_date_sk = d_date_sk
-| | runtime filters: RF004 <- d_date_sk
+| | runtime filters: RF008 <- d_date_sk
| |
| |--03:SCAN HDFS [tpcds.date_dim]
| | partitions=1/1 files=1 size=9.84MB
@@ -3155,18 +3155,18 @@ PLAN-ROOT SINK
| |
| 02:SCAN HDFS [tpcds.store_sales]
| partitions=1824/1824 files=1824 size=326.32MB
-| runtime filters: RF004 -> ss_sold_date_sk
+| runtime filters: RF008 -> ss_sold_date_sk
|
12:HASH JOIN [INNER JOIN]
| hash predicates: ss_item_sk = i_item_sk
-| runtime filters: RF001 <- i_item_sk
+| runtime filters: RF002 <- i_item_sk
|
|--01:SCAN HDFS [tpcds.item]
| partitions=1/1 files=1 size=4.82MB
|
11:HASH JOIN [INNER JOIN]
| hash predicates: ss_store_sk = s_store_sk
-| runtime filters: RF002 <- s_store_sk
+| runtime filters: RF004 <- s_store_sk
|
|--00:SCAN HDFS [tpcds.store]
| partitions=1/1 files=1 size=3.08KB
@@ -3178,7 +3178,7 @@ PLAN-ROOT SINK
|
09:HASH JOIN [INNER JOIN]
| hash predicates: ss_sold_date_sk = d_date_sk
-| runtime filters: RF003 <- d_date_sk
+| runtime filters: RF006 <- d_date_sk
|
|--08:SCAN HDFS [tpcds.date_dim]
| partitions=1/1 files=1 size=9.84MB
@@ -3186,7 +3186,7 @@ PLAN-ROOT SINK
|
07:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> tpcds.store_sales.ss_store_sk, RF001 -> tpcds.store_sales.ss_item_sk, RF002 -> tpcds.store_sales.ss_store_sk, RF003 -> ss_sold_date_sk
+ runtime filters: RF000 -> tpcds.store_sales.ss_store_sk, RF002 -> tpcds.store_sales.ss_item_sk, RF004 -> tpcds.store_sales.ss_store_sk, RF006 -> ss_sold_date_sk
---- DISTRIBUTEDPLAN
PLAN-ROOT SINK
|
@@ -3226,7 +3226,7 @@ PLAN-ROOT SINK
| |
| 04:HASH JOIN [INNER JOIN, BROADCAST]
| | hash predicates: ss_sold_date_sk = d_date_sk
-| | runtime filters: RF004 <- d_date_sk
+| | runtime filters: RF008 <- d_date_sk
| |
| |--21:EXCHANGE [BROADCAST]
| | |
@@ -3236,11 +3236,11 @@ PLAN-ROOT SINK
| |
| 02:SCAN HDFS [tpcds.store_sales]
| partitions=1824/1824 files=1824 size=326.32MB
-| runtime filters: RF004 -> ss_sold_date_sk
+| runtime filters: RF008 -> ss_sold_date_sk
|
12:HASH JOIN [INNER JOIN, PARTITIONED]
| hash predicates: ss_item_sk = i_item_sk
-| runtime filters: RF001 <- i_item_sk
+| runtime filters: RF002 <- i_item_sk
|
|--20:EXCHANGE [HASH(i_item_sk)]
| |
@@ -3251,7 +3251,7 @@ PLAN-ROOT SINK
|
11:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_store_sk = s_store_sk
-| runtime filters: RF002 <- s_store_sk
+| runtime filters: RF004 <- s_store_sk
|
|--18:EXCHANGE [BROADCAST]
| |
@@ -3271,7 +3271,7 @@ PLAN-ROOT SINK
|
09:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_sold_date_sk = d_date_sk
-| runtime filters: RF003 <- d_date_sk
+| runtime filters: RF006 <- d_date_sk
|
|--15:EXCHANGE [BROADCAST]
| |
@@ -3281,7 +3281,7 @@ PLAN-ROOT SINK
|
07:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> tpcds.store_sales.ss_store_sk, RF001 -> tpcds.store_sales.ss_item_sk, RF002 -> tpcds.store_sales.ss_store_sk, RF003 -> ss_sold_date_sk
+ runtime filters: RF000 -> tpcds.store_sales.ss_store_sk, RF002 -> tpcds.store_sales.ss_item_sk, RF004 -> tpcds.store_sales.ss_store_sk, RF006 -> ss_sold_date_sk
---- PARALLELPLANS
PLAN-ROOT SINK
|
@@ -3325,7 +3325,7 @@ PLAN-ROOT SINK
| |
| 04:HASH JOIN [INNER JOIN, BROADCAST]
| | hash predicates: ss_sold_date_sk = d_date_sk
-| | runtime filters: RF004 <- d_date_sk
+| | runtime filters: RF008 <- d_date_sk
| |
| |--JOIN BUILD
| | | join-table-id=01 plan-id=02 cohort-id=02
@@ -3339,11 +3339,11 @@ PLAN-ROOT SINK
| |
| 02:SCAN HDFS [tpcds.store_sales]
| partitions=1824/1824 files=1824 size=326.32MB
-| runtime filters: RF004 -> ss_sold_date_sk
+| runtime filters: RF008 -> ss_sold_date_sk
|
12:HASH JOIN [INNER JOIN, PARTITIONED]
| hash predicates: ss_item_sk = i_item_sk
-| runtime filters: RF001 <- i_item_sk
+| runtime filters: RF002 <- i_item_sk
|
|--JOIN BUILD
| | join-table-id=02 plan-id=03 cohort-id=01
@@ -3358,7 +3358,7 @@ PLAN-ROOT SINK
|
11:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_store_sk = s_store_sk
-| runtime filters: RF002 <- s_store_sk
+| runtime filters: RF004 <- s_store_sk
|
|--JOIN BUILD
| | join-table-id=03 plan-id=04 cohort-id=01
@@ -3382,7 +3382,7 @@ PLAN-ROOT SINK
|
09:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_sold_date_sk = d_date_sk
-| runtime filters: RF003 <- d_date_sk
+| runtime filters: RF006 <- d_date_sk
|
|--JOIN BUILD
| | join-table-id=04 plan-id=05 cohort-id=01
@@ -3396,7 +3396,7 @@ PLAN-ROOT SINK
|
07:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> tpcds.store_sales.ss_store_sk, RF001 -> tpcds.store_sales.ss_item_sk, RF002 -> tpcds.store_sales.ss_store_sk, RF003 -> ss_sold_date_sk
+ runtime filters: RF000 -> tpcds.store_sales.ss_store_sk, RF002 -> tpcds.store_sales.ss_item_sk, RF004 -> tpcds.store_sales.ss_store_sk, RF006 -> ss_sold_date_sk
====
# TPCDS-Q68
select
@@ -3463,7 +3463,7 @@ PLAN-ROOT SINK
|
12:HASH JOIN [INNER JOIN]
| hash predicates: ss_customer_sk = c_customer_sk
-| runtime filters: RF001 <- c_customer_sk
+| runtime filters: RF002 <- c_customer_sk
|
|--10:SCAN HDFS [tpcds.customer]
| partitions=1/1 files=1 size=12.60MB
@@ -3475,14 +3475,14 @@ PLAN-ROOT SINK
|
08:HASH JOIN [INNER JOIN]
| hash predicates: store_sales.ss_addr_sk = customer_address.ca_address_sk
-| runtime filters: RF002 <- customer_address.ca_address_sk
+| runtime filters: RF004 <- customer_address.ca_address_sk
|
|--04:SCAN HDFS [tpcds.customer_address]
| partitions=1/1 files=1 size=5.25MB
|
07:HASH JOIN [INNER JOIN]
| hash predicates: store_sales.ss_store_sk = store.s_store_sk
-| runtime filters: RF003 <- store.s_store_sk
+| runtime filters: RF006 <- store.s_store_sk
|
|--02:SCAN HDFS [tpcds.store]
| partitions=1/1 files=1 size=3.08KB
@@ -3490,7 +3490,7 @@ PLAN-ROOT SINK
|
06:HASH JOIN [INNER JOIN]
| hash predicates: store_sales.ss_sold_date_sk = date_dim.d_date_sk
-| runtime filters: RF004 <- date_dim.d_date_sk
+| runtime filters: RF008 <- date_dim.d_date_sk
|
|--01:SCAN HDFS [tpcds.date_dim]
| partitions=1/1 files=1 size=9.84MB
@@ -3498,7 +3498,7 @@ PLAN-ROOT SINK
|
05:HASH JOIN [INNER JOIN]
| hash predicates: store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk
-| runtime filters: RF005 <- household_demographics.hd_demo_sk
+| runtime filters: RF010 <- household_demographics.hd_demo_sk
|
|--03:SCAN HDFS [tpcds.household_demographics]
| partitions=1/1 files=1 size=148.10KB
@@ -3506,7 +3506,7 @@ PLAN-ROOT SINK
|
00:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF001 -> tpcds.store_sales.ss_customer_sk, RF002 -> store_sales.ss_addr_sk, RF003 -> store_sales.ss_store_sk, RF004 -> store_sales.ss_sold_date_sk, RF005 -> store_sales.ss_hdemo_sk
+ runtime filters: RF002 -> tpcds.store_sales.ss_customer_sk, RF004 -> store_sales.ss_addr_sk, RF006 -> store_sales.ss_store_sk, RF008 -> store_sales.ss_sold_date_sk, RF010 -> store_sales.ss_hdemo_sk
---- DISTRIBUTEDPLAN
PLAN-ROOT SINK
|
@@ -3529,7 +3529,7 @@ PLAN-ROOT SINK
|
12:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_customer_sk = c_customer_sk
-| runtime filters: RF001 <- c_customer_sk
+| runtime filters: RF002 <- c_customer_sk
|
|--21:EXCHANGE [BROADCAST]
| |
@@ -3549,7 +3549,7 @@ PLAN-ROOT SINK
|
08:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_addr_sk = customer_address.ca_address_sk
-| runtime filters: RF002 <- customer_address.ca_address_sk
+| runtime filters: RF004 <- customer_address.ca_address_sk
|
|--18:EXCHANGE [BROADCAST]
| |
@@ -3558,7 +3558,7 @@ PLAN-ROOT SINK
|
07:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_store_sk = store.s_store_sk
-| runtime filters: RF003 <- store.s_store_sk
+| runtime filters: RF006 <- store.s_store_sk
|
|--17:EXCHANGE [BROADCAST]
| |
@@ -3568,7 +3568,7 @@ PLAN-ROOT SINK
|
06:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_sold_date_sk = date_dim.d_date_sk
-| runtime filters: RF004 <- date_dim.d_date_sk
+| runtime filters: RF008 <- date_dim.d_date_sk
|
|--16:EXCHANGE [BROADCAST]
| |
@@ -3578,7 +3578,7 @@ PLAN-ROOT SINK
|
05:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk
-| runtime filters: RF005 <- household_demographics.hd_demo_sk
+| runtime filters: RF010 <- household_demographics.hd_demo_sk
|
|--15:EXCHANGE [BROADCAST]
| |
@@ -3588,7 +3588,7 @@ PLAN-ROOT SINK
|
00:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF001 -> tpcds.store_sales.ss_customer_sk, RF002 -> store_sales.ss_addr_sk, RF003 -> store_sales.ss_store_sk, RF004 -> store_sales.ss_sold_date_sk, RF005 -> store_sales.ss_hdemo_sk
+ runtime filters: RF002 -> tpcds.store_sales.ss_customer_sk, RF004 -> store_sales.ss_addr_sk, RF006 -> store_sales.ss_store_sk, RF008 -> store_sales.ss_sold_date_sk, RF010 -> store_sales.ss_hdemo_sk
---- PARALLELPLANS
PLAN-ROOT SINK
|
@@ -3615,7 +3615,7 @@ PLAN-ROOT SINK
|
12:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_customer_sk = c_customer_sk
-| runtime filters: RF001 <- c_customer_sk
+| runtime filters: RF002 <- c_customer_sk
|
|--JOIN BUILD
| | join-table-id=01 plan-id=02 cohort-id=01
@@ -3639,7 +3639,7 @@ PLAN-ROOT SINK
|
08:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_addr_sk = customer_address.ca_address_sk
-| runtime filters: RF002 <- customer_address.ca_address_sk
+| runtime filters: RF004 <- customer_address.ca_address_sk
|
|--JOIN BUILD
| | join-table-id=02 plan-id=03 cohort-id=01
@@ -3652,7 +3652,7 @@ PLAN-ROOT SINK
|
07:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_store_sk = store.s_store_sk
-| runtime filters: RF003 <- store.s_store_sk
+| runtime filters: RF006 <- store.s_store_sk
|
|--JOIN BUILD
| | join-table-id=03 plan-id=04 cohort-id=01
@@ -3666,7 +3666,7 @@ PLAN-ROOT SINK
|
06:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_sold_date_sk = date_dim.d_date_sk
-| runtime filters: RF004 <- date_dim.d_date_sk
+| runtime filters: RF008 <- date_dim.d_date_sk
|
|--JOIN BUILD
| | join-table-id=04 plan-id=05 cohort-id=01
@@ -3680,7 +3680,7 @@ PLAN-ROOT SINK
|
05:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk
-| runtime filters: RF005 <- household_demographics.hd_demo_sk
+| runtime filters: RF010 <- household_demographics.hd_demo_sk
|
|--JOIN BUILD
| | join-table-id=05 plan-id=06 cohort-id=01
@@ -3694,7 +3694,7 @@ PLAN-ROOT SINK
|
00:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF001 -> tpcds.store_sales.ss_customer_sk, RF002 -> store_sales.ss_addr_sk, RF003 -> store_sales.ss_store_sk, RF004 -> store_sales.ss_sold_date_sk, RF005 -> store_sales.ss_hdemo_sk
+ runtime filters: RF002 -> tpcds.store_sales.ss_customer_sk, RF004 -> store_sales.ss_addr_sk, RF006 -> store_sales.ss_store_sk, RF008 -> store_sales.ss_sold_date_sk, RF010 -> store_sales.ss_hdemo_sk
====
# TPCDS-Q73
select
@@ -3751,7 +3751,7 @@ PLAN-ROOT SINK
| |
| 06:HASH JOIN [INNER JOIN]
| | hash predicates: store_sales.ss_store_sk = store.s_store_sk
-| | runtime filters: RF001 <- store.s_store_sk
+| | runtime filters: RF002 <- store.s_store_sk
| |
| |--02:SCAN HDFS [tpcds.store]
| | partitions=1/1 files=1 size=3.08KB
@@ -3759,14 +3759,14 @@ PLAN-ROOT SINK
| |
| 05:HASH JOIN [INNER JOIN]
| | hash predicates: store_sales.ss_sold_date_sk = date_dim.d_date_sk
-| | runtime filters: RF002 <- date_dim.d_date_sk
+| | runtime filters: RF004 <- date_dim.d_date_sk
| |
| |--01:SCAN HDFS [tpcds.date_dim]
| | partitions=1/1 files=1 size=9.84MB
| |
| 04:HASH JOIN [INNER JOIN]
| | hash predicates: store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk
-| | runtime filters: RF003 <- household_demographics.hd_demo_sk
+| | runtime filters: RF006 <- household_demographics.hd_demo_sk
| |
| |--03:SCAN HDFS [tpcds.household_demographics]
| | partitions=1/1 files=1 size=148.10KB
@@ -3774,7 +3774,7 @@ PLAN-ROOT SINK
| |
| 00:SCAN HDFS [tpcds.store_sales]
| partitions=1824/1824 files=1824 size=326.32MB
-| runtime filters: RF001 -> store_sales.ss_store_sk, RF002 -> store_sales.ss_sold_date_sk, RF003 -> store_sales.ss_hdemo_sk
+| runtime filters: RF002 -> store_sales.ss_store_sk, RF004 -> store_sales.ss_sold_date_sk, RF006 -> store_sales.ss_hdemo_sk
|
08:SCAN HDFS [tpcds.customer]
partitions=1/1 files=1 size=12.60MB
@@ -3813,7 +3813,7 @@ PLAN-ROOT SINK
|
06:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_store_sk = store.s_store_sk
-| runtime filters: RF001 <- store.s_store_sk
+| runtime filters: RF002 <- store.s_store_sk
|
|--13:EXCHANGE [BROADCAST]
| |
@@ -3823,7 +3823,7 @@ PLAN-ROOT SINK
|
05:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_sold_date_sk = date_dim.d_date_sk
-| runtime filters: RF002 <- date_dim.d_date_sk
+| runtime filters: RF004 <- date_dim.d_date_sk
|
|--12:EXCHANGE [BROADCAST]
| |
@@ -3832,7 +3832,7 @@ PLAN-ROOT SINK
|
04:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk
-| runtime filters: RF003 <- household_demographics.hd_demo_sk
+| runtime filters: RF006 <- household_demographics.hd_demo_sk
|
|--11:EXCHANGE [BROADCAST]
| |
@@ -3842,7 +3842,7 @@ PLAN-ROOT SINK
|
00:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> tpcds.store_sales.ss_customer_sk, RF001 -> store_sales.ss_store_sk, RF002 -> store_sales.ss_sold_date_sk, RF003 -> store_sales.ss_hdemo_sk
+ runtime filters: RF000 -> tpcds.store_sales.ss_customer_sk, RF002 -> store_sales.ss_store_sk, RF004 -> store_sales.ss_sold_date_sk, RF006 -> store_sales.ss_hdemo_sk
---- PARALLELPLANS
PLAN-ROOT SINK
|
@@ -3881,7 +3881,7 @@ PLAN-ROOT SINK
|
06:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_store_sk = store.s_store_sk
-| runtime filters: RF001 <- store.s_store_sk
+| runtime filters: RF002 <- store.s_store_sk
|
|--JOIN BUILD
| | join-table-id=01 plan-id=02 cohort-id=01
@@ -3895,7 +3895,7 @@ PLAN-ROOT SINK
|
05:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_sold_date_sk = date_dim.d_date_sk
-| runtime filters: RF002 <- date_dim.d_date_sk
+| runtime filters: RF004 <- date_dim.d_date_sk
|
|--JOIN BUILD
| | join-table-id=02 plan-id=03 cohort-id=01
@@ -3908,7 +3908,7 @@ PLAN-ROOT SINK
|
04:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk
-| runtime filters: RF003 <- household_demographics.hd_demo_sk
+| runtime filters: RF006 <- household_demographics.hd_demo_sk
|
|--JOIN BUILD
| | join-table-id=03 plan-id=04 cohort-id=01
@@ -3922,7 +3922,7 @@ PLAN-ROOT SINK
|
00:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> tpcds.store_sales.ss_customer_sk, RF001 -> store_sales.ss_store_sk, RF002 -> store_sales.ss_sold_date_sk, RF003 -> store_sales.ss_hdemo_sk
+ runtime filters: RF000 -> tpcds.store_sales.ss_customer_sk, RF002 -> store_sales.ss_store_sk, RF004 -> store_sales.ss_sold_date_sk, RF006 -> store_sales.ss_hdemo_sk
====
# TPCDS-Q79
select
@@ -3983,7 +3983,7 @@ PLAN-ROOT SINK
| |
| 06:HASH JOIN [INNER JOIN]
| | hash predicates: store_sales.ss_sold_date_sk = date_dim.d_date_sk
-| | runtime filters: RF001 <- date_dim.d_date_sk
+| | runtime filters: RF002 <- date_dim.d_date_sk
| |
| |--01:SCAN HDFS [tpcds.date_dim]
| | partitions=1/1 files=1 size=9.84MB
@@ -3991,7 +3991,7 @@ PLAN-ROOT SINK
| |
| 05:HASH JOIN [INNER JOIN]
| | hash predicates: store_sales.ss_store_sk = store.s_store_sk
-| | runtime filters: RF002 <- store.s_store_sk
+| | runtime filters: RF004 <- store.s_store_sk
| |
| |--02:SCAN HDFS [tpcds.store]
| | partitions=1/1 files=1 size=3.08KB
@@ -3999,7 +3999,7 @@ PLAN-ROOT SINK
| |
| 04:HASH JOIN [INNER JOIN]
| | hash predicates: store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk
-| | runtime filters: RF003 <- household_demographics.hd_demo_sk
+| | runtime filters: RF006 <- household_demographics.hd_demo_sk
| |
| |--03:SCAN HDFS [tpcds.household_demographics]
| | partitions=1/1 files=1 size=148.10KB
@@ -4007,7 +4007,7 @@ PLAN-ROOT SINK
| |
| 00:SCAN HDFS [tpcds.store_sales]
| partitions=1824/1824 files=1824 size=326.32MB
-| runtime filters: RF001 -> store_sales.ss_sold_date_sk, RF002 -> store_sales.ss_store_sk, RF003 -> store_sales.ss_hdemo_sk
+| runtime filters: RF002 -> store_sales.ss_sold_date_sk, RF004 -> store_sales.ss_store_sk, RF006 -> store_sales.ss_hdemo_sk
|
08:SCAN HDFS [tpcds.customer]
partitions=1/1 files=1 size=12.60MB
@@ -4045,7 +4045,7 @@ PLAN-ROOT SINK
|
06:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_sold_date_sk = date_dim.d_date_sk
-| runtime filters: RF001 <- date_dim.d_date_sk
+| runtime filters: RF002 <- date_dim.d_date_sk
|
|--13:EXCHANGE [BROADCAST]
| |
@@ -4055,7 +4055,7 @@ PLAN-ROOT SINK
|
05:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_store_sk = store.s_store_sk
-| runtime filters: RF002 <- store.s_store_sk
+| runtime filters: RF004 <- store.s_store_sk
|
|--12:EXCHANGE [BROADCAST]
| |
@@ -4065,7 +4065,7 @@ PLAN-ROOT SINK
|
04:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk
-| runtime filters: RF003 <- household_demographics.hd_demo_sk
+| runtime filters: RF006 <- household_demographics.hd_demo_sk
|
|--11:EXCHANGE [BROADCAST]
| |
@@ -4075,7 +4075,7 @@ PLAN-ROOT SINK
|
00:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> tpcds.store_sales.ss_customer_sk, RF001 -> store_sales.ss_sold_date_sk, RF002 -> store_sales.ss_store_sk, RF003 -> store_sales.ss_hdemo_sk
+ runtime filters: RF000 -> tpcds.store_sales.ss_customer_sk, RF002 -> store_sales.ss_sold_date_sk, RF004 -> store_sales.ss_store_sk, RF006 -> store_sales.ss_hdemo_sk
---- PARALLELPLANS
PLAN-ROOT SINK
|
@@ -4113,7 +4113,7 @@ PLAN-ROOT SINK
|
06:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_sold_date_sk = date_dim.d_date_sk
-| runtime filters: RF001 <- date_dim.d_date_sk
+| runtime filters: RF002 <- date_dim.d_date_sk
|
|--JOIN BUILD
| | join-table-id=01 plan-id=02 cohort-id=01
@@ -4127,7 +4127,7 @@ PLAN-ROOT SINK
|
05:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_store_sk = store.s_store_sk
-| runtime filters: RF002 <- store.s_store_sk
+| runtime filters: RF004 <- store.s_store_sk
|
|--JOIN BUILD
| | join-table-id=02 plan-id=03 cohort-id=01
@@ -4141,7 +4141,7 @@ PLAN-ROOT SINK
|
04:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk
-| runtime filters: RF003 <- household_demographics.hd_demo_sk
+| runtime filters: RF006 <- household_demographics.hd_demo_sk
|
|--JOIN BUILD
| | join-table-id=03 plan-id=04 cohort-id=01
@@ -4155,7 +4155,7 @@ PLAN-ROOT SINK
|
00:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> tpcds.store_sales.ss_customer_sk, RF001 -> store_sales.ss_sold_date_sk, RF002 -> store_sales.ss_store_sk, RF003 -> store_sales.ss_hdemo_sk
+ runtime filters: RF000 -> tpcds.store_sales.ss_customer_sk, RF002 -> store_sales.ss_sold_date_sk, RF004 -> store_sales.ss_store_sk, RF006 -> store_sales.ss_hdemo_sk
====
# TPCDS-Q89
select * from (select *
@@ -4212,7 +4212,7 @@ PLAN-ROOT SINK
|
05:HASH JOIN [INNER JOIN]
| hash predicates: ss_sold_date_sk = d_date_sk
-| runtime filters: RF001 <- d_date_sk
+| runtime filters: RF002 <- d_date_sk
|
|--02:SCAN HDFS [tpcds.date_dim]
| partitions=1/1 files=1 size=9.84MB
@@ -4220,7 +4220,7 @@ PLAN-ROOT SINK
|
04:HASH JOIN [INNER JOIN]
| hash predicates: ss_item_sk = i_item_sk
-| runtime filters: RF002 <- i_item_sk
+| runtime filters: RF004 <- i_item_sk
|
|--00:SCAN HDFS [tpcds.item]
| partitions=1/1 files=1 size=4.82MB
@@ -4228,7 +4228,7 @@ PLAN-ROOT SINK
|
01:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> ss_store_sk, RF001 -> ss_sold_date_sk, RF002 -> ss_item_sk
+ runtime filters: RF000 -> ss_store_sk, RF002 -> ss_sold_date_sk, RF004 -> ss_item_sk
---- DISTRIBUTEDPLAN
PLAN-ROOT SINK
|
@@ -4270,7 +4270,7 @@ PLAN-ROOT SINK
|
05:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_sold_date_sk = d_date_sk
-| runtime filters: RF001 <- d_date_sk
+| runtime filters: RF002 <- d_date_sk
|
|--13:EXCHANGE [BROADCAST]
| |
@@ -4280,7 +4280,7 @@ PLAN-ROOT SINK
|
04:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_item_sk = i_item_sk
-| runtime filters: RF002 <- i_item_sk
+| runtime filters: RF004 <- i_item_sk
|
|--12:EXCHANGE [BROADCAST]
| |
@@ -4290,7 +4290,7 @@ PLAN-ROOT SINK
|
01:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> ss_store_sk, RF001 -> ss_sold_date_sk, RF002 -> ss_item_sk
+ runtime filters: RF000 -> ss_store_sk, RF002 -> ss_sold_date_sk, RF004 -> ss_item_sk
---- PARALLELPLANS
PLAN-ROOT SINK
|
@@ -4336,7 +4336,7 @@ PLAN-ROOT SINK
|
05:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_sold_date_sk = d_date_sk
-| runtime filters: RF001 <- d_date_sk
+| runtime filters: RF002 <- d_date_sk
|
|--JOIN BUILD
| | join-table-id=01 plan-id=02 cohort-id=01
@@ -4350,7 +4350,7 @@ PLAN-ROOT SINK
|
04:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss_item_sk = i_item_sk
-| runtime filters: RF002 <- i_item_sk
+| runtime filters: RF004 <- i_item_sk
|
|--JOIN BUILD
| | join-table-id=02 plan-id=03 cohort-id=01
@@ -4364,7 +4364,7 @@ PLAN-ROOT SINK
|
01:SCAN HDFS [tpcds.store_sales]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> ss_store_sk, RF001 -> ss_sold_date_sk, RF002 -> ss_item_sk
+ runtime filters: RF000 -> ss_store_sk, RF002 -> ss_sold_date_sk, RF004 -> ss_item_sk
====
# TPCDS-Q96
SELECT
@@ -4397,7 +4397,7 @@ PLAN-ROOT SINK
|
05:HASH JOIN [INNER JOIN]
| hash predicates: ss.ss_hdemo_sk = hd.hd_demo_sk
-| runtime filters: RF001 <- hd.hd_demo_sk
+| runtime filters: RF002 <- hd.hd_demo_sk
|
|--02:SCAN HDFS [tpcds.household_demographics hd]
| partitions=1/1 files=1 size=148.10KB
@@ -4405,7 +4405,7 @@ PLAN-ROOT SINK
|
04:HASH JOIN [INNER JOIN]
| hash predicates: ss.ss_sold_time_sk = td.t_time_sk
-| runtime filters: RF002 <- td.t_time_sk
+| runtime filters: RF004 <- td.t_time_sk
|
|--01:SCAN HDFS [tpcds.time_dim td]
| partitions=1/1 files=1 size=4.87MB
@@ -4413,7 +4413,7 @@ PLAN-ROOT SINK
|
00:SCAN HDFS [tpcds.store_sales ss]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> ss.ss_store_sk, RF001 -> ss.ss_hdemo_sk, RF002 -> ss.ss_sold_time_sk
+ runtime filters: RF000 -> ss.ss_store_sk, RF002 -> ss.ss_hdemo_sk, RF004 -> ss.ss_sold_time_sk
---- DISTRIBUTEDPLAN
PLAN-ROOT SINK
|
@@ -4437,7 +4437,7 @@ PLAN-ROOT SINK
|
05:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss.ss_hdemo_sk = hd.hd_demo_sk
-| runtime filters: RF001 <- hd.hd_demo_sk
+| runtime filters: RF002 <- hd.hd_demo_sk
|
|--09:EXCHANGE [BROADCAST]
| |
@@ -4447,7 +4447,7 @@ PLAN-ROOT SINK
|
04:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss.ss_sold_time_sk = td.t_time_sk
-| runtime filters: RF002 <- td.t_time_sk
+| runtime filters: RF004 <- td.t_time_sk
|
|--08:EXCHANGE [BROADCAST]
| |
@@ -4457,7 +4457,7 @@ PLAN-ROOT SINK
|
00:SCAN HDFS [tpcds.store_sales ss]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> ss.ss_store_sk, RF001 -> ss.ss_hdemo_sk, RF002 -> ss.ss_sold_time_sk
+ runtime filters: RF000 -> ss.ss_store_sk, RF002 -> ss.ss_hdemo_sk, RF004 -> ss.ss_sold_time_sk
---- PARALLELPLANS
PLAN-ROOT SINK
|
@@ -4485,7 +4485,7 @@ PLAN-ROOT SINK
|
05:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss.ss_hdemo_sk = hd.hd_demo_sk
-| runtime filters: RF001 <- hd.hd_demo_sk
+| runtime filters: RF002 <- hd.hd_demo_sk
|
|--JOIN BUILD
| | join-table-id=01 plan-id=02 cohort-id=01
@@ -4499,7 +4499,7 @@ PLAN-ROOT SINK
|
04:HASH JOIN [INNER JOIN, BROADCAST]
| hash predicates: ss.ss_sold_time_sk = td.t_time_sk
-| runtime filters: RF002 <- td.t_time_sk
+| runtime filters: RF004 <- td.t_time_sk
|
|--JOIN BUILD
| | join-table-id=02 plan-id=03 cohort-id=01
@@ -4513,7 +4513,7 @@ PLAN-ROOT SINK
|
00:SCAN HDFS [tpcds.store_sales ss]
partitions=1824/1824 files=1824 size=326.32MB
- runtime filters: RF000 -> ss.ss_store_sk, RF001 -> ss.ss_hdemo_sk, RF002 -> ss.ss_sold_time_sk
+ runtime filters: RF000 -> ss.ss_store_sk, RF002 -> ss.ss_hdemo_sk, RF004 -> ss.ss_sold_time_sk
====
# TPCDS-Q98
select
@@ -4573,7 +4573,7 @@ PLAN-ROOT SINK
|
03:HASH JOIN [INNER JOIN]
| hash predicates: i_item_sk = ss_item_sk
-| runtime filters: RF001 <- ss_item_sk
+| runtime filters: RF002 <- ss_item_sk
|
|--00:SCAN HDFS [tpcds.store_sales]
| partitions=31/1824 files=31 size=3.43MB
@@ -4582,7 +4582,7 @@ PLAN-ROOT SINK
01:SCAN HDFS [tpcds.item]
partitions=1/1 files=1 size=4.82MB
predicates: i_category IN ('Jewelry', 'Sports', 'Books')
- runtime filters: RF001 -> i_item_sk
+ runtime filters: RF002 -> i_item_sk
---- DISTRIBUTEDPLAN
PLAN-ROOT SINK
|
@@ -4622,7 +4622,7 @@ PLAN-ROOT SINK
|
03:HASH JOIN [INNER JOIN, PARTITIONED]
| hash predicates: ss_item_sk = i_item_sk
-| runtime filters: RF001 <- i_item_sk
+| runtime filters: RF002 <- i_item_sk
|
|--10:EXCHANGE [HASH(i_item_sk)]
| |
@@ -4634,7 +4634,7 @@ PLAN-ROOT SINK
|
00:SCAN HDFS [tpcds.store_sales]
partitions=31/1824 files=31 size=3.43MB
- runtime filters: RF000 -> ss_sold_date_sk, RF001 -> ss_item_sk
+ runtime filters: RF000 -> ss_sold_date_sk, RF002 -> ss_item_sk
---- PARALLELPLANS
PLAN-ROOT SINK
|
@@ -4678,7 +4678,7 @@ PLAN-ROOT SINK
|
03:HASH JOIN [INNER JOIN, PARTITIONED]
| hash predicates: ss_item_sk = i_item_sk
-| runtime filters: RF001 <- i_item_sk
+| runtime filters: RF002 <- i_item_sk
|
|--JOIN BUILD
| | join-table-id=01 plan-id=02 cohort-id=01
@@ -4694,7 +4694,7 @@ PLAN-ROOT SINK
|
00:SCAN HDFS [tpcds.store_sales]
partitions=31/1824 files=31 size=3.43MB
- runtime filters: RF000 -> ss_sold_date_sk, RF001 -> ss_item_sk
+ runtime filters: RF000 -> ss_sold_date_sk, RF002 -> ss_item_sk
====
# TPCD-Q6
select * from (
@@ -4747,7 +4747,7 @@ PLAN-ROOT SINK
|
13:HASH JOIN [LEFT SEMI JOIN]
| hash predicates: d.d_month_seq = (d_month_seq)
-| runtime filters: RF001 <- (d_month_seq)
+| runtime filters: RF002 <- (d_month_seq)
|
|--06:AGGREGATE [FINALIZE]
| | group by: (d_month_seq)
@@ -4759,7 +4759,7 @@ PLAN-ROOT SINK
|
12:HASH JOIN [INNER JOIN]
| hash predicates: s.ss_item_sk = i.i_item_sk
-| runtime filters: RF002 <- i.i_item_sk
+| runtime filters: RF004 <- i.i_item_sk
|
|--04:SCAN HDFS [tpcds.item i]
| partitions=1/1 files=1 size=4.82MB
@@ -4767,30 +4767,30 @@ PLAN-ROOT SINK
|
11:HASH JOIN [INNER JOIN]
| hash predicates: s.ss_sold_date_sk = d.d_date_sk
-| runtime filters: RF003 <- d.d_date_sk
+| runtime filters: RF006 <- d.d_date_sk
<TRUNCATED>