testdata/workloads/functional-planner/queries/PlannerTest/tpcds/tpcds-q64.test

# TPCDS-Q64
WITH cs_ui AS
  (SELECT cs_item_sk,
          sum(cs_ext_list_price) AS sale,
          sum(cr_refunded_cash+cr_reversed_charge+cr_store_credit) AS refund
   FROM catalog_sales,
        catalog_returns
   WHERE cs_item_sk = cr_item_sk
     AND cs_order_number = cr_order_number
   GROUP BY cs_item_sk
   HAVING sum(cs_ext_list_price)>2*sum(cr_refunded_cash+cr_reversed_charge+cr_store_credit)),
     cross_sales AS
  (SELECT i_product_name product_name,
          i_item_sk item_sk,
          s_store_name store_name,
          s_zip store_zip,
          ad1.ca_street_number b_street_number,
          ad1.ca_street_name b_street_name,
          ad1.ca_city b_city,
          ad1.ca_zip b_zip,
          ad2.ca_street_number c_street_number,
          ad2.ca_street_name c_street_name,
          ad2.ca_city c_city,
          ad2.ca_zip c_zip,
          d1.d_year AS syear,
          d2.d_year AS fsyear,
          d3.d_year s2year,
          count(*) cnt,
          sum(ss_wholesale_cost) s1,
          sum(ss_list_price) s2,
          sum(ss_coupon_amt) s3
   FROM store_sales,
        store_returns,
        cs_ui,
        date_dim d1,
        date_dim d2,
        date_dim d3,
        store,
        customer,
        customer_demographics cd1,
        customer_demographics cd2,
        promotion,
        household_demographics hd1,
        household_demographics hd2,
        customer_address ad1,
        customer_address ad2,
        income_band ib1,
        income_band ib2,
        item
   WHERE ss_store_sk = s_store_sk
     AND ss_sold_date_sk = d1.d_date_sk
     AND ss_customer_sk = c_customer_sk
     AND ss_cdemo_sk= cd1.cd_demo_sk
     AND ss_hdemo_sk = hd1.hd_demo_sk
     AND ss_addr_sk = ad1.ca_address_sk
     AND ss_item_sk = i_item_sk
     AND ss_item_sk = sr_item_sk
     AND ss_ticket_number = sr_ticket_number
     AND ss_item_sk = cs_ui.cs_item_sk
     AND c_current_cdemo_sk = cd2.cd_demo_sk
     AND c_current_hdemo_sk = hd2.hd_demo_sk
     AND c_current_addr_sk = ad2.ca_address_sk
     AND c_first_sales_date_sk = d2.d_date_sk
     AND c_first_shipto_date_sk = d3.d_date_sk
     AND ss_promo_sk = p_promo_sk
     AND hd1.hd_income_band_sk = ib1.ib_income_band_sk
     AND hd2.hd_income_band_sk = ib2.ib_income_band_sk
     AND cd1.cd_marital_status <> cd2.cd_marital_status
     AND i_color IN ('purple',
                     'burlywood',
                     'indian',
                     'spring',
                     'floral',
                     'medium')
     AND i_current_price BETWEEN 64 AND 64 + 10
     AND i_current_price BETWEEN 64 + 1 AND 64 + 15
   GROUP BY i_product_name,
            i_item_sk,
            s_store_name,
            s_zip,
            ad1.ca_street_number,
            ad1.ca_street_name,
            ad1.ca_city,
            ad1.ca_zip,
            ad2.ca_street_number,
            ad2.ca_street_name,
            ad2.ca_city,
            ad2.ca_zip,
            d1.d_year,
            d2.d_year,
            d3.d_year)
SELECT cs1.product_name,
       cs1.store_name,
       cs1.store_zip,
       cs1.b_street_number,
       cs1.b_street_name,
       cs1.b_city,
       cs1.b_zip,
       cs1.c_street_number,
       cs1.c_street_name,
       cs1.c_city,
       cs1.c_zip,
       cs1.syear,
       cs1.cnt,
       cs1.s1 AS s11,
       cs1.s2 AS s21,
       cs1.s3 AS s31,
       cs2.s1 AS s12,
       cs2.s2 AS s22,
       cs2.s3 AS s32,
       cs2.syear,
       cs2.cnt
FROM cross_sales cs1,
     cross_sales cs2
WHERE cs1.item_sk=cs2.item_sk
  AND cs1.syear = 1999
  AND cs2.syear = 1999 + 1
  AND cs2.cnt <= cs1.cnt
  AND cs1.store_name = cs2.store_name
  AND cs1.store_zip = cs2.store_zip
ORDER BY cs1.product_name,
         cs1.store_name,
         cs2.cnt,
         cs1.s1,
         cs2.s1;

---- PLAN
Max Per-Host Resource Reservation: Memory=154.39MB Threads=39
Per-Host Resource Estimates: Memory=2.17GB
F00:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
|  Per-Host Resources: mem-estimate=2.17GB mem-reservation=154.39MB thread-reservation=39 runtime-filters-memory=10.00MB
PLAN-ROOT SINK
|  output exprs: product_name, store_name, store_zip, b_street_number, b_street_name, b_city, b_zip, c_street_number, c_street_name, c_city, c_zip, syear, cnt, s1, s2, s3, s1, s2, s3, syear, cnt
|  mem-estimate=0B mem-reservation=0B thread-reservation=0
|
79:SORT
|  order by: product_name ASC, store_name ASC, cnt ASC, s1 ASC, s1 ASC
|  mem-estimate=12.00MB mem-reservation=12.00MB spill-buffer=2.00MB thread-reservation=0
|  tuple-ids=46 row-size=330B cardinality=288.12K
|  in pipelines: 79(GETNEXT), 38(OPEN)
|
78:HASH JOIN [INNER JOIN]
|  hash predicates: i_item_sk = i_item_sk, s_store_name = s_store_name, s_zip = s_zip
|  fk/pk conjuncts: i_item_sk = i_item_sk, s_store_name = s_store_name, s_zip = s_zip
|  other predicates: count(*) <= count(*)
|  mem-estimate=86.56MB mem-reservation=34.00MB spill-buffer=2.00MB thread-reservation=0
|  tuple-ids=21,44 row-size=573B cardinality=288.12K
|  in pipelines: 38(GETNEXT), 77(OPEN)
|
|--77:AGGREGATE [FINALIZE]
|  |  output: count(*), sum(ss_wholesale_cost), sum(ss_list_price), sum(ss_coupon_amt)
|  |  group by: i_product_name, i_item_sk, s_store_name, s_zip, ad1.ca_street_number, ad1.ca_street_name, ad1.ca_city, ad1.ca_zip, ad2.ca_street_number, ad2.ca_street_name, ad2.ca_city, ad2.ca_zip, d1.d_year, d2.d_year, d3.d_year
|  |  mem-estimate=86.56MB mem-reservation=34.00MB spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=44 row-size=286B cardinality=288.12K
|  |  in pipelines: 77(GETNEXT), 56(OPEN)
|  |
|  76:HASH JOIN [INNER JOIN]
|  |  hash predicates: ss_item_sk = cs_item_sk
|  |  fk/pk conjuncts: none
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=40,39,35,34,33,24,23,43,29,37,36,32,38,30,31,41,42,27 row-size=474B cardinality=288.12K
|  |  in pipelines: 56(GETNEXT), 44(OPEN)
|  |
|  |--44:AGGREGATE [FINALIZE]
|  |  |  output: sum(cs_ext_list_price), sum(cr_refunded_cash + cr_reversed_charge + cr_store_credit)
|  |  |  group by: cs_item_sk
|  |  |  having: sum(cs_ext_list_price) > CAST(2 AS DECIMAL(3,0)) * sum(cr_refunded_cash + cr_reversed_charge + cr_store_credit)
|  |  |  mem-estimate=10.00MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  |  tuple-ids=27 row-size=40B cardinality=1.80K
|  |  |  in pipelines: 44(GETNEXT), 41(OPEN)
|  |  |
|  |  43:HASH JOIN [INNER JOIN]
|  |  |  hash predicates: cs_item_sk = cr_item_sk, cs_order_number = cr_order_number
|  |  |  fk/pk conjuncts: cs_item_sk = cr_item_sk, cs_order_number = cr_order_number
|  |  |  mem-estimate=4.75MB mem-reservation=4.75MB spill-buffer=256.00KB thread-reservation=0
|  |  |  tuple-ids=25,26 row-size=48B cardinality=849.41K
|  |  |  in pipelines: 41(GETNEXT), 42(OPEN)
|  |  |
|  |  |--42:SCAN HDFS [tpcds_parquet.catalog_returns]
|  |  |     HDFS partitions=1/1 files=1 size=10.62MB
|  |  |     stored statistics:
|  |  |       table: rows=144.07K size=10.62MB
|  |  |       columns: all
|  |  |     extrapolated-rows=disabled max-scan-range-rows=144.07K
|  |  |     mem-estimate=120.00MB mem-reservation=4.00MB thread-reservation=1
|  |  |     tuple-ids=26 row-size=28B cardinality=144.07K
|  |  |     in pipelines: 42(GETNEXT)
|  |  |
|  |  41:SCAN HDFS [tpcds_parquet.catalog_sales]
|  |     HDFS partitions=1/1 files=3 size=96.62MB
|  |     stored statistics:
|  |       table: rows=1.44M size=96.62MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=650.14K
|  |     mem-estimate=144.00MB mem-reservation=8.00MB thread-reservation=1
|  |     tuple-ids=25 row-size=20B cardinality=1.44M
|  |     in pipelines: 41(GETNEXT)
|  |
|  75:HASH JOIN [INNER JOIN]
|  |  hash predicates: hd2.hd_income_band_sk = ib2.ib_income_band_sk
|  |  fk/pk conjuncts: hd2.hd_income_band_sk = ib2.ib_income_band_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=40,39,35,34,33,24,23,43,29,37,36,32,38,30,31,41,42 row-size=434B cardinality=8.45K
|  |  in pipelines: 56(GETNEXT), 58(OPEN)
|  |
|  |--58:SCAN HDFS [tpcds_parquet.income_band ib2]
|  |     HDFS partitions=1/1 files=1 size=1.21KB
|  |     stored statistics:
|  |       table: rows=20 size=1.21KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=20
|  |     mem-estimate=16.00MB mem-reservation=8.00KB thread-reservation=1
|  |     tuple-ids=42 row-size=4B cardinality=20
|  |     in pipelines: 58(GETNEXT)
|  |
|  74:HASH JOIN [INNER JOIN]
|  |  hash predicates: hd1.hd_income_band_sk = ib1.ib_income_band_sk
|  |  fk/pk conjuncts: hd1.hd_income_band_sk = ib1.ib_income_band_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=40,39,35,34,33,24,23,43,29,37,36,32,38,30,31,41 row-size=430B cardinality=8.45K
|  |  in pipelines: 56(GETNEXT), 57(OPEN)
|  |
|  |--57:SCAN HDFS [tpcds_parquet.income_band ib1]
|  |     HDFS partitions=1/1 files=1 size=1.21KB
|  |     stored statistics:
|  |       table: rows=20 size=1.21KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=20
|  |     mem-estimate=16.00MB mem-reservation=8.00KB thread-reservation=1
|  |     tuple-ids=41 row-size=4B cardinality=20
|  |     in pipelines: 57(GETNEXT)
|  |
|  73:HASH JOIN [INNER JOIN]
|  |  hash predicates: ad2.ca_address_sk = c_current_addr_sk
|  |  fk/pk conjuncts: ad2.ca_address_sk = c_current_addr_sk
|  |  mem-estimate=4.75MB mem-reservation=4.75MB spill-buffer=256.00KB thread-reservation=0
|  |  tuple-ids=40,39,35,34,33,24,23,43,29,37,36,32,38,30,31 row-size=426B cardinality=8.45K
|  |  in pipelines: 56(GETNEXT), 55(OPEN)
|  |
|  |--72:HASH JOIN [INNER JOIN]
|  |  |  hash predicates: ad1.ca_address_sk = ss_addr_sk
|  |  |  fk/pk conjuncts: ad1.ca_address_sk = ss_addr_sk
|  |  |  mem-estimate=4.75MB mem-reservation=4.75MB spill-buffer=256.00KB thread-reservation=0
|  |  |  tuple-ids=39,35,34,33,24,23,43,29,37,36,32,38,30,31 row-size=348B cardinality=8.45K
|  |  |  in pipelines: 55(GETNEXT), 51(OPEN)
|  |  |
|  |  |--71:HASH JOIN [INNER JOIN]
|  |  |  |  hash predicates: cd2.cd_demo_sk = c_current_cdemo_sk
|  |  |  |  fk/pk conjuncts: cd2.cd_demo_sk = c_current_cdemo_sk
|  |  |  |  other predicates: cd1.cd_marital_status != cd2.cd_marital_status
|  |  |  |  runtime filters: RF056[bloom] <- c_current_cdemo_sk
|  |  |  |  mem-estimate=4.75MB mem-reservation=4.75MB spill-buffer=256.00KB thread-reservation=0
|  |  |  |  tuple-ids=35,34,33,24,23,43,29,37,36,32,38,30,31 row-size=271B cardinality=8.45K
|  |  |  |  in pipelines: 51(GETNEXT), 50(OPEN)
|  |  |  |
|  |  |  |--70:HASH JOIN [INNER JOIN]
|  |  |  |  |  hash predicates: cd1.cd_demo_sk = ss_cdemo_sk
|  |  |  |  |  fk/pk conjuncts: cd1.cd_demo_sk = ss_cdemo_sk
|  |  |  |  |  runtime filters: RF058[bloom] <- ss_cdemo_sk
|  |  |  |  |  mem-estimate=2.88MB mem-reservation=2.88MB spill-buffer=128.00KB thread-reservation=0
|  |  |  |  |  tuple-ids=34,33,24,23,43,29,37,36,32,38,30,31 row-size=254B cardinality=8.45K
|  |  |  |  |  in pipelines: 50(GETNEXT), 49(OPEN)
|  |  |  |  |
|  |  |  |  |--69:HASH JOIN [INNER JOIN]
|  |  |  |  |  |  hash predicates: c_first_shipto_date_sk = d3.d_date_sk
|  |  |  |  |  |  fk/pk conjuncts: c_first_shipto_date_sk = d3.d_date_sk
|  |  |  |  |  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  |  |  |  |  tuple-ids=33,24,23,43,29,37,36,32,38,30,31 row-size=237B cardinality=8.45K
|  |  |  |  |  |  in pipelines: 49(GETNEXT), 47(OPEN)
|  |  |  |  |  |
|  |  |  |  |  |--47:SCAN HDFS [tpcds_parquet.date_dim d3]
|  |  |  |  |  |     HDFS partitions=1/1 files=1 size=2.15MB
|  |  |  |  |  |     stored statistics:
|  |  |  |  |  |       table: rows=73.05K size=2.15MB
|  |  |  |  |  |       columns: all
|  |  |  |  |  |     extrapolated-rows=disabled max-scan-range-rows=73.05K
|  |  |  |  |  |     mem-estimate=32.00MB mem-reservation=512.00KB thread-reservation=1
|  |  |  |  |  |     tuple-ids=31 row-size=8B cardinality=73.05K
|  |  |  |  |  |     in pipelines: 47(GETNEXT)
|  |  |  |  |  |
|  |  |  |  |  68:HASH JOIN [INNER JOIN]
|  |  |  |  |  |  hash predicates: c_first_sales_date_sk = d2.d_date_sk
|  |  |  |  |  |  fk/pk conjuncts: c_first_sales_date_sk = d2.d_date_sk
|  |  |  |  |  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  |  |  |  |  tuple-ids=33,24,23,43,29,37,36,32,38,30 row-size=229B cardinality=8.45K
|  |  |  |  |  |  in pipelines: 49(GETNEXT), 46(OPEN)
|  |  |  |  |  |
|  |  |  |  |  |--46:SCAN HDFS [tpcds_parquet.date_dim d2]
|  |  |  |  |  |     HDFS partitions=1/1 files=1 size=2.15MB
|  |  |  |  |  |     stored statistics:
|  |  |  |  |  |       table: rows=73.05K size=2.15MB
|  |  |  |  |  |       columns: all
|  |  |  |  |  |     extrapolated-rows=disabled max-scan-range-rows=73.05K
|  |  |  |  |  |     mem-estimate=32.00MB mem-reservation=512.00KB thread-reservation=1
|  |  |  |  |  |     tuple-ids=30 row-size=8B cardinality=73.05K
|  |  |  |  |  |     in pipelines: 46(GETNEXT)
|  |  |  |  |  |
|  |  |  |  |  67:HASH JOIN [INNER JOIN]
|  |  |  |  |  |  hash predicates: c_current_hdemo_sk = hd2.hd_demo_sk
|  |  |  |  |  |  fk/pk conjuncts: c_current_hdemo_sk = hd2.hd_demo_sk
|  |  |  |  |  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  |  |  |  |  tuple-ids=33,24,23,43,29,37,36,32,38 row-size=221B cardinality=8.45K
|  |  |  |  |  |  in pipelines: 49(GETNEXT), 54(OPEN)
|  |  |  |  |  |
|  |  |  |  |  |--54:SCAN HDFS [tpcds_parquet.household_demographics hd2]
|  |  |  |  |  |     HDFS partitions=1/1 files=1 size=41.69KB
|  |  |  |  |  |     stored statistics:
|  |  |  |  |  |       table: rows=7.20K size=41.69KB
|  |  |  |  |  |       columns: all
|  |  |  |  |  |     extrapolated-rows=disabled max-scan-range-rows=7.20K
|  |  |  |  |  |     mem-estimate=32.00MB mem-reservation=64.00KB thread-reservation=1
|  |  |  |  |  |     tuple-ids=38 row-size=8B cardinality=7.20K
|  |  |  |  |  |     in pipelines: 54(GETNEXT)
|  |  |  |  |  |
|  |  |  |  |  66:HASH JOIN [INNER JOIN]
|  |  |  |  |  |  hash predicates: c_customer_sk = ss_customer_sk
|  |  |  |  |  |  fk/pk conjuncts: c_customer_sk = ss_customer_sk
|  |  |  |  |  |  mem-estimate=2.88MB mem-reservation=2.88MB spill-buffer=128.00KB thread-reservation=0
|  |  |  |  |  |  tuple-ids=33,24,23,43,29,37,36,32 row-size=213B cardinality=8.66K
|  |  |  |  |  |  in pipelines: 49(GETNEXT), 40(OPEN)
|  |  |  |  |  |
|  |  |  |  |  |--65:HASH JOIN [INNER JOIN]
|  |  |  |  |  |  |  hash predicates: ss_store_sk = s_store_sk
|  |  |  |  |  |  |  fk/pk conjuncts: ss_store_sk = s_store_sk
|  |  |  |  |  |  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  |  |  |  |  |  tuple-ids=24,23,43,29,37,36,32 row-size=189B cardinality=8.66K
|  |  |  |  |  |  |  in pipelines: 40(GETNEXT), 48(OPEN)
|  |  |  |  |  |  |
|  |  |  |  |  |  |--48:SCAN HDFS [tpcds_parquet.store]
|  |  |  |  |  |  |     HDFS partitions=1/1 files=1 size=9.93KB
|  |  |  |  |  |  |     stored statistics:
|  |  |  |  |  |  |       table: rows=12 size=9.93KB
|  |  |  |  |  |  |       columns: all
|  |  |  |  |  |  |     extrapolated-rows=disabled max-scan-range-rows=12
|  |  |  |  |  |  |     mem-estimate=48.00MB mem-reservation=24.00KB thread-reservation=1
|  |  |  |  |  |  |     tuple-ids=32 row-size=37B cardinality=12
|  |  |  |  |  |  |     in pipelines: 48(GETNEXT)
|  |  |  |  |  |  |
|  |  |  |  |  |  64:HASH JOIN [INNER JOIN]
|  |  |  |  |  |  |  hash predicates: ss_promo_sk = p_promo_sk
|  |  |  |  |  |  |  fk/pk conjuncts: ss_promo_sk = p_promo_sk
|  |  |  |  |  |  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  |  |  |  |  |  tuple-ids=24,23,43,29,37,36 row-size=151B cardinality=8.66K
|  |  |  |  |  |  |  in pipelines: 40(GETNEXT), 52(OPEN)
|  |  |  |  |  |  |
|  |  |  |  |  |  |--52:SCAN HDFS [tpcds_parquet.promotion]
|  |  |  |  |  |  |     HDFS partitions=1/1 files=1 size=23.30KB
|  |  |  |  |  |  |     stored statistics:
|  |  |  |  |  |  |       table: rows=300 size=23.30KB
|  |  |  |  |  |  |       columns: all
|  |  |  |  |  |  |     extrapolated-rows=disabled max-scan-range-rows=300
|  |  |  |  |  |  |     mem-estimate=16.00MB mem-reservation=32.00KB thread-reservation=1
|  |  |  |  |  |  |     tuple-ids=36 row-size=4B cardinality=300
|  |  |  |  |  |  |     in pipelines: 52(GETNEXT)
|  |  |  |  |  |  |
|  |  |  |  |  |  63:HASH JOIN [INNER JOIN]
|  |  |  |  |  |  |  hash predicates: ss_hdemo_sk = hd1.hd_demo_sk
|  |  |  |  |  |  |  fk/pk conjuncts: ss_hdemo_sk = hd1.hd_demo_sk
|  |  |  |  |  |  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  |  |  |  |  |  tuple-ids=24,23,43,29,37 row-size=147B cardinality=8.72K
|  |  |  |  |  |  |  in pipelines: 40(GETNEXT), 53(OPEN)
|  |  |  |  |  |  |
|  |  |  |  |  |  |--53:SCAN HDFS [tpcds_parquet.household_demographics hd1]
|  |  |  |  |  |  |     HDFS partitions=1/1 files=1 size=41.69KB
|  |  |  |  |  |  |     stored statistics:
|  |  |  |  |  |  |       table: rows=7.20K size=41.69KB
|  |  |  |  |  |  |       columns: all
|  |  |  |  |  |  |     extrapolated-rows=disabled max-scan-range-rows=7.20K
|  |  |  |  |  |  |     mem-estimate=32.00MB mem-reservation=64.00KB thread-reservation=1
|  |  |  |  |  |  |     tuple-ids=37 row-size=8B cardinality=7.20K
|  |  |  |  |  |  |     in pipelines: 53(GETNEXT)
|  |  |  |  |  |  |
|  |  |  |  |  |  62:HASH JOIN [INNER JOIN]
|  |  |  |  |  |  |  hash predicates: sr_item_sk = ss_item_sk, sr_ticket_number = ss_ticket_number
|  |  |  |  |  |  |  fk/pk conjuncts: sr_item_sk = ss_item_sk, sr_ticket_number = ss_ticket_number
|  |  |  |  |  |  |  runtime filters: RF074[bloom] <- ss_item_sk, RF075[bloom] <- ss_ticket_number
|  |  |  |  |  |  |  mem-estimate=2.88MB mem-reservation=2.88MB spill-buffer=128.00KB thread-reservation=0
|  |  |  |  |  |  |  tuple-ids=24,23,43,29 row-size=139B cardinality=8.93K
|  |  |  |  |  |  |  in pipelines: 40(GETNEXT), 39(OPEN)
|  |  |  |  |  |  |
|  |  |  |  |  |  |--61:HASH JOIN [INNER JOIN]
|  |  |  |  |  |  |  |  hash predicates: ss_sold_date_sk = d1.d_date_sk
|  |  |  |  |  |  |  |  fk/pk conjuncts: ss_sold_date_sk = d1.d_date_sk
|  |  |  |  |  |  |  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  |  |  |  |  |  |  tuple-ids=23,43,29 row-size=123B cardinality=12.14K
|  |  |  |  |  |  |  |  in pipelines: 39(GETNEXT), 45(OPEN)
|  |  |  |  |  |  |  |
|  |  |  |  |  |  |  |--45:SCAN HDFS [tpcds_parquet.date_dim d1]
|  |  |  |  |  |  |  |     HDFS partitions=1/1 files=1 size=2.15MB
|  |  |  |  |  |  |  |     predicates: d1.d_year = CAST(2000 AS INT)
|  |  |  |  |  |  |  |     stored statistics:
|  |  |  |  |  |  |  |       table: rows=73.05K size=2.15MB
|  |  |  |  |  |  |  |       columns: all
|  |  |  |  |  |  |  |     extrapolated-rows=disabled max-scan-range-rows=73.05K
|  |  |  |  |  |  |  |     parquet statistics predicates: d1.d_year = CAST(2000 AS INT)
|  |  |  |  |  |  |  |     parquet dictionary predicates: d1.d_year = CAST(2000 AS INT)
|  |  |  |  |  |  |  |     mem-estimate=32.00MB mem-reservation=512.00KB thread-reservation=1
|  |  |  |  |  |  |  |     tuple-ids=29 row-size=8B cardinality=373
|  |  |  |  |  |  |  |     in pipelines: 45(GETNEXT)
|  |  |  |  |  |  |  |
|  |  |  |  |  |  |  60:HASH JOIN [INNER JOIN]
|  |  |  |  |  |  |  |  hash predicates: ss_item_sk = i_item_sk
|  |  |  |  |  |  |  |  fk/pk conjuncts: ss_item_sk = i_item_sk
|  |  |  |  |  |  |  |  runtime filters: RF080[bloom] <- i_item_sk
|  |  |  |  |  |  |  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  |  |  |  |  |  |  tuple-ids=23,43 row-size=115B cardinality=59.37K
|  |  |  |  |  |  |  |  in pipelines: 39(GETNEXT), 59(OPEN)
|  |  |  |  |  |  |  |
|  |  |  |  |  |  |  |--59:SCAN HDFS [tpcds_parquet.item]
|  |  |  |  |  |  |  |     HDFS partitions=1/1 files=1 size=1.73MB
|  |  |  |  |  |  |  |     predicates: i_color IN ('purple', 'burlywood', 'indian', 'spring', 'floral', 'medium'), i_current_price <= CAST(74 AS DECIMAL(3,0)), i_current_price <= CAST(79 AS DECIMAL(3,0)), i_current_price >= CAST(64 AS DECIMAL(3,0)), i_current_price >= CAST(65 AS DECIMAL(3,0))
|  |  |  |  |  |  |  |     stored statistics:
|  |  |  |  |  |  |  |       table: rows=18.00K size=1.73MB
|  |  |  |  |  |  |  |       columns: all
|  |  |  |  |  |  |  |     extrapolated-rows=disabled max-scan-range-rows=18.00K
|  |  |  |  |  |  |  |     parquet statistics predicates: i_color IN ('purple', 'burlywood', 'indian', 'spring', 'floral', 'medium'), i_current_price <= CAST(74 AS DECIMAL(3,0)), i_current_price <= CAST(79 AS DECIMAL(3,0)), i_current_price >= CAST(64 AS DECIMAL(3,0)), i_current_price >= CAST(65 AS DECIMAL(3,0))
|  |  |  |  |  |  |  |     parquet dictionary predicates: i_color IN ('purple', 'burlywood', 'indian', 'spring', 'floral', 'medium'), i_current_price <= CAST(74 AS DECIMAL(3,0)), i_current_price <= CAST(79 AS DECIMAL(3,0)), i_current_price >= CAST(64 AS DECIMAL(3,0)), i_current_price >= CAST(65 AS DECIMAL(3,0))
|  |  |  |  |  |  |  |     mem-estimate=64.00MB mem-reservation=512.00KB thread-reservation=1
|  |  |  |  |  |  |  |     tuple-ids=43 row-size=59B cardinality=371
|  |  |  |  |  |  |  |     in pipelines: 59(GETNEXT)
|  |  |  |  |  |  |  |
|  |  |  |  |  |  |  39:SCAN HDFS [tpcds_parquet.store_sales]
|  |  |  |  |  |  |     HDFS partitions=1824/1824 files=1824 size=200.95MB
|  |  |  |  |  |  |     runtime filters: RF080[bloom] -> ss_item_sk
|  |  |  |  |  |  |     stored statistics:
|  |  |  |  |  |  |       table: rows=2.88M size=200.95MB
|  |  |  |  |  |  |       partitions: 1824/1824 rows=2.88M
|  |  |  |  |  |  |       columns: all
|  |  |  |  |  |  |     extrapolated-rows=disabled max-scan-range-rows=130.09K
|  |  |  |  |  |  |     mem-estimate=128.00MB mem-reservation=8.00MB thread-reservation=1
|  |  |  |  |  |  |     tuple-ids=23 row-size=56B cardinality=2.88M
|  |  |  |  |  |  |     in pipelines: 39(GETNEXT)
|  |  |  |  |  |  |
|  |  |  |  |  |  40:SCAN HDFS [tpcds_parquet.store_returns]
|  |  |  |  |  |     HDFS partitions=1/1 files=1 size=15.43MB
|  |  |  |  |  |     runtime filters: RF074[bloom] -> sr_item_sk, RF075[bloom] -> sr_ticket_number
|  |  |  |  |  |     stored statistics:
|  |  |  |  |  |       table: rows=287.51K size=15.43MB
|  |  |  |  |  |       columns: all
|  |  |  |  |  |     extrapolated-rows=disabled max-scan-range-rows=287.51K
|  |  |  |  |  |     mem-estimate=48.00MB mem-reservation=4.00MB thread-reservation=1
|  |  |  |  |  |     tuple-ids=24 row-size=16B cardinality=287.51K
|  |  |  |  |  |     in pipelines: 40(GETNEXT)
|  |  |  |  |  |
|  |  |  |  |  49:SCAN HDFS [tpcds_parquet.customer]
|  |  |  |  |     HDFS partitions=1/1 files=1 size=5.49MB
|  |  |  |  |     stored statistics:
|  |  |  |  |       table: rows=100.00K size=5.49MB
|  |  |  |  |       columns: all
|  |  |  |  |     extrapolated-rows=disabled max-scan-range-rows=100.00K
|  |  |  |  |     mem-estimate=96.00MB mem-reservation=2.00MB thread-reservation=1
|  |  |  |  |     tuple-ids=33 row-size=24B cardinality=100.00K
|  |  |  |  |     in pipelines: 49(GETNEXT)
|  |  |  |  |
|  |  |  |  50:SCAN HDFS [tpcds_parquet.customer_demographics cd1]
|  |  |  |     HDFS partitions=1/1 files=1 size=7.49MB
|  |  |  |     runtime filters: RF058[bloom] -> cd1.cd_demo_sk
|  |  |  |     stored statistics:
|  |  |  |       table: rows=1.92M size=7.49MB
|  |  |  |       columns: all
|  |  |  |     extrapolated-rows=disabled max-scan-range-rows=1.92M
|  |  |  |     mem-estimate=32.00MB mem-reservation=8.00MB thread-reservation=1
|  |  |  |     tuple-ids=34 row-size=17B cardinality=1.92M
|  |  |  |     in pipelines: 50(GETNEXT)
|  |  |  |
|  |  |  51:SCAN HDFS [tpcds_parquet.customer_demographics cd2]
|  |  |     HDFS partitions=1/1 files=1 size=7.49MB
|  |  |     runtime filters: RF056[bloom] -> cd2.cd_demo_sk
|  |  |     stored statistics:
|  |  |       table: rows=1.92M size=7.49MB
|  |  |       columns: all
|  |  |     extrapolated-rows=disabled max-scan-range-rows=1.92M
|  |  |     mem-estimate=32.00MB mem-reservation=8.00MB thread-reservation=1
|  |  |     tuple-ids=35 row-size=17B cardinality=1.92M
|  |  |     in pipelines: 51(GETNEXT)
|  |  |
|  |  55:SCAN HDFS [tpcds_parquet.customer_address ad1]
|  |     HDFS partitions=1/1 files=1 size=1.16MB
|  |     stored statistics:
|  |       table: rows=50.00K size=1.16MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=50.00K
|  |     mem-estimate=80.00MB mem-reservation=1.00MB thread-reservation=1
|  |     tuple-ids=39 row-size=78B cardinality=50.00K
|  |     in pipelines: 55(GETNEXT)
|  |
|  56:SCAN HDFS [tpcds_parquet.customer_address ad2]
|     HDFS partitions=1/1 files=1 size=1.16MB
|     stored statistics:
|       table: rows=50.00K size=1.16MB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=50.00K
|     mem-estimate=80.00MB mem-reservation=1.00MB thread-reservation=1
|     tuple-ids=40 row-size=78B cardinality=50.00K
|     in pipelines: 56(GETNEXT)
|
38:AGGREGATE [FINALIZE]
|  output: count(*), sum(ss_wholesale_cost), sum(ss_list_price), sum(ss_coupon_amt)
|  group by: i_product_name, i_item_sk, s_store_name, s_zip, ad1.ca_street_number, ad1.ca_street_name, ad1.ca_city, ad1.ca_zip, ad2.ca_street_number, ad2.ca_street_name, ad2.ca_city, ad2.ca_zip, d1.d_year, d2.d_year, d3.d_year
|  mem-estimate=86.56MB mem-reservation=34.00MB spill-buffer=2.00MB thread-reservation=0
|  tuple-ids=21 row-size=286B cardinality=288.12K
|  in pipelines: 38(GETNEXT), 17(OPEN)
|
37:HASH JOIN [INNER JOIN]
|  hash predicates: ss_item_sk = cs_item_sk
|  fk/pk conjuncts: none
|  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=17,16,12,11,10,1,0,20,6,14,13,9,15,7,8,18,19,4 row-size=474B cardinality=288.12K
|  in pipelines: 17(GETNEXT), 05(OPEN)
|
|--05:AGGREGATE [FINALIZE]
|  |  output: sum(cs_ext_list_price), sum(cr_refunded_cash + cr_reversed_charge + cr_store_credit)
|  |  group by: cs_item_sk
|  |  having: sum(cs_ext_list_price) > CAST(2 AS DECIMAL(3,0)) * sum(cr_refunded_cash + cr_reversed_charge + cr_store_credit)
|  |  mem-estimate=10.00MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=4 row-size=40B cardinality=1.80K
|  |  in pipelines: 05(GETNEXT), 02(OPEN)
|  |
|  04:HASH JOIN [INNER JOIN]
|  |  hash predicates: cs_item_sk = cr_item_sk, cs_order_number = cr_order_number
|  |  fk/pk conjuncts: cs_item_sk = cr_item_sk, cs_order_number = cr_order_number
|  |  mem-estimate=4.75MB mem-reservation=4.75MB spill-buffer=256.00KB thread-reservation=0
|  |  tuple-ids=2,3 row-size=48B cardinality=849.41K
|  |  in pipelines: 02(GETNEXT), 03(OPEN)
|  |
|  |--03:SCAN HDFS [tpcds_parquet.catalog_returns]
|  |     HDFS partitions=1/1 files=1 size=10.62MB
|  |     stored statistics:
|  |       table: rows=144.07K size=10.62MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=144.07K
|  |     mem-estimate=120.00MB mem-reservation=4.00MB thread-reservation=1
|  |     tuple-ids=3 row-size=28B cardinality=144.07K
|  |     in pipelines: 03(GETNEXT)
|  |
|  02:SCAN HDFS [tpcds_parquet.catalog_sales]
|     HDFS partitions=1/1 files=3 size=96.62MB
|     stored statistics:
|       table: rows=1.44M size=96.62MB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=650.14K
|     mem-estimate=144.00MB mem-reservation=8.00MB thread-reservation=1
|     tuple-ids=2 row-size=20B cardinality=1.44M
|     in pipelines: 02(GETNEXT)
|
36:HASH JOIN [INNER JOIN]
|  hash predicates: hd2.hd_income_band_sk = ib2.ib_income_band_sk
|  fk/pk conjuncts: hd2.hd_income_band_sk = ib2.ib_income_band_sk
|  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=17,16,12,11,10,1,0,20,6,14,13,9,15,7,8,18,19 row-size=434B cardinality=8.45K
|  in pipelines: 17(GETNEXT), 19(OPEN)
|
|--19:SCAN HDFS [tpcds_parquet.income_band ib2]
|     HDFS partitions=1/1 files=1 size=1.21KB
|     stored statistics:
|       table: rows=20 size=1.21KB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=20
|     mem-estimate=16.00MB mem-reservation=8.00KB thread-reservation=1
|     tuple-ids=19 row-size=4B cardinality=20
|     in pipelines: 19(GETNEXT)
|
35:HASH JOIN [INNER JOIN]
|  hash predicates: hd1.hd_income_band_sk = ib1.ib_income_band_sk
|  fk/pk conjuncts: hd1.hd_income_band_sk = ib1.ib_income_band_sk
|  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=17,16,12,11,10,1,0,20,6,14,13,9,15,7,8,18 row-size=430B cardinality=8.45K
|  in pipelines: 17(GETNEXT), 18(OPEN)
|
|--18:SCAN HDFS [tpcds_parquet.income_band ib1]
|     HDFS partitions=1/1 files=1 size=1.21KB
|     stored statistics:
|       table: rows=20 size=1.21KB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=20
|     mem-estimate=16.00MB mem-reservation=8.00KB thread-reservation=1
|     tuple-ids=18 row-size=4B cardinality=20
|     in pipelines: 18(GETNEXT)
|
34:HASH JOIN [INNER JOIN]
|  hash predicates: ad2.ca_address_sk = c_current_addr_sk
|  fk/pk conjuncts: ad2.ca_address_sk = c_current_addr_sk
|  mem-estimate=4.75MB mem-reservation=4.75MB spill-buffer=256.00KB thread-reservation=0
|  tuple-ids=17,16,12,11,10,1,0,20,6,14,13,9,15,7,8 row-size=426B cardinality=8.45K
|  in pipelines: 17(GETNEXT), 16(OPEN)
|
|--33:HASH JOIN [INNER JOIN]
|  |  hash predicates: ad1.ca_address_sk = ss_addr_sk
|  |  fk/pk conjuncts: ad1.ca_address_sk = ss_addr_sk
|  |  mem-estimate=4.75MB mem-reservation=4.75MB spill-buffer=256.00KB thread-reservation=0
|  |  tuple-ids=16,12,11,10,1,0,20,6,14,13,9,15,7,8 row-size=348B cardinality=8.45K
|  |  in pipelines: 16(GETNEXT), 12(OPEN)
|  |
|  |--32:HASH JOIN [INNER JOIN]
|  |  |  hash predicates: cd2.cd_demo_sk = c_current_cdemo_sk
|  |  |  fk/pk conjuncts: cd2.cd_demo_sk = c_current_cdemo_sk
|  |  |  other predicates: cd1.cd_marital_status != cd2.cd_marital_status
|  |  |  runtime filters: RF016[bloom] <- c_current_cdemo_sk
|  |  |  mem-estimate=4.75MB mem-reservation=4.75MB spill-buffer=256.00KB thread-reservation=0
|  |  |  tuple-ids=12,11,10,1,0,20,6,14,13,9,15,7,8 row-size=271B cardinality=8.45K
|  |  |  in pipelines: 12(GETNEXT), 11(OPEN)
|  |  |
|  |  |--31:HASH JOIN [INNER JOIN]
|  |  |  |  hash predicates: cd1.cd_demo_sk = ss_cdemo_sk
|  |  |  |  fk/pk conjuncts: cd1.cd_demo_sk = ss_cdemo_sk
|  |  |  |  runtime filters: RF018[bloom] <- ss_cdemo_sk
|  |  |  |  mem-estimate=2.88MB mem-reservation=2.88MB spill-buffer=128.00KB thread-reservation=0
|  |  |  |  tuple-ids=11,10,1,0,20,6,14,13,9,15,7,8 row-size=254B cardinality=8.45K
|  |  |  |  in pipelines: 11(GETNEXT), 10(OPEN)
|  |  |  |
|  |  |  |--30:HASH JOIN [INNER JOIN]
|  |  |  |  |  hash predicates: c_first_shipto_date_sk = d3.d_date_sk
|  |  |  |  |  fk/pk conjuncts: c_first_shipto_date_sk = d3.d_date_sk
|  |  |  |  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  |  |  |  tuple-ids=10,1,0,20,6,14,13,9,15,7,8 row-size=237B cardinality=8.45K
|  |  |  |  |  in pipelines: 10(GETNEXT), 08(OPEN)
|  |  |  |  |
|  |  |  |  |--08:SCAN HDFS [tpcds_parquet.date_dim d3]
|  |  |  |  |     HDFS partitions=1/1 files=1 size=2.15MB
|  |  |  |  |     stored statistics:
|  |  |  |  |       table: rows=73.05K size=2.15MB
|  |  |  |  |       columns: all
|  |  |  |  |     extrapolated-rows=disabled max-scan-range-rows=73.05K
|  |  |  |  |     mem-estimate=32.00MB mem-reservation=512.00KB thread-reservation=1
|  |  |  |  |     tuple-ids=8 row-size=8B cardinality=73.05K
|  |  |  |  |     in pipelines: 08(GETNEXT)
|  |  |  |  |
|  |  |  |  29:HASH JOIN [INNER JOIN]
|  |  |  |  |  hash predicates: c_first_sales_date_sk = d2.d_date_sk
|  |  |  |  |  fk/pk conjuncts: c_first_sales_date_sk = d2.d_date_sk
|  |  |  |  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  |  |  |  tuple-ids=10,1,0,20,6,14,13,9,15,7 row-size=229B cardinality=8.45K
|  |  |  |  |  in pipelines: 10(GETNEXT), 07(OPEN)
|  |  |  |  |
|  |  |  |  |--07:SCAN HDFS [tpcds_parquet.date_dim d2]
|  |  |  |  |     HDFS partitions=1/1 files=1 size=2.15MB
|  |  |  |  |     stored statistics:
|  |  |  |  |       table: rows=73.05K size=2.15MB
|  |  |  |  |       columns: all
|  |  |  |  |     extrapolated-rows=disabled max-scan-range-rows=73.05K
|  |  |  |  |     mem-estimate=32.00MB mem-reservation=512.00KB thread-reservation=1
|  |  |  |  |     tuple-ids=7 row-size=8B cardinality=73.05K
|  |  |  |  |     in pipelines: 07(GETNEXT)
|  |  |  |  |
|  |  |  |  28:HASH JOIN [INNER JOIN]
|  |  |  |  |  hash predicates: c_current_hdemo_sk = hd2.hd_demo_sk
|  |  |  |  |  fk/pk conjuncts: c_current_hdemo_sk = hd2.hd_demo_sk
|  |  |  |  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  |  |  |  tuple-ids=10,1,0,20,6,14,13,9,15 row-size=221B cardinality=8.45K
|  |  |  |  |  in pipelines: 10(GETNEXT), 15(OPEN)
|  |  |  |  |
|  |  |  |  |--15:SCAN HDFS [tpcds_parquet.household_demographics hd2]
|  |  |  |  |     HDFS partitions=1/1 files=1 size=41.69KB
|  |  |  |  |     stored statistics:
|  |  |  |  |       table: rows=7.20K size=41.69KB
|  |  |  |  |       columns: all
|  |  |  |  |     extrapolated-rows=disabled max-scan-range-rows=7.20K
|  |  |  |  |     mem-estimate=32.00MB mem-reservation=64.00KB thread-reservation=1
|  |  |  |  |     tuple-ids=15 row-size=8B cardinality=7.20K
|  |  |  |  |     in pipelines: 15(GETNEXT)
|  |  |  |  |
|  |  |  |  27:HASH JOIN [INNER JOIN]
|  |  |  |  |  hash predicates: c_customer_sk = ss_customer_sk
|  |  |  |  |  fk/pk conjuncts: c_customer_sk = ss_customer_sk
|  |  |  |  |  mem-estimate=2.88MB mem-reservation=2.88MB spill-buffer=128.00KB thread-reservation=0
|  |  |  |  |  tuple-ids=10,1,0,20,6,14,13,9 row-size=213B cardinality=8.66K
|  |  |  |  |  in pipelines: 10(GETNEXT), 01(OPEN)
|  |  |  |  |
|  |  |  |  |--26:HASH JOIN [INNER JOIN]
|  |  |  |  |  |  hash predicates: ss_store_sk = s_store_sk
|  |  |  |  |  |  fk/pk conjuncts: ss_store_sk = s_store_sk
|  |  |  |  |  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  |  |  |  |  tuple-ids=1,0,20,6,14,13,9 row-size=189B cardinality=8.66K
|  |  |  |  |  |  in pipelines: 01(GETNEXT), 09(OPEN)
|  |  |  |  |  |
|  |  |  |  |  |--09:SCAN HDFS [tpcds_parquet.store]
|  |  |  |  |  |     HDFS partitions=1/1 files=1 size=9.93KB
|  |  |  |  |  |     stored statistics:
|  |  |  |  |  |       table: rows=12 size=9.93KB
|  |  |  |  |  |       columns: all
|  |  |  |  |  |     extrapolated-rows=disabled max-scan-range-rows=12
|  |  |  |  |  |     mem-estimate=48.00MB mem-reservation=24.00KB thread-reservation=1
|  |  |  |  |  |     tuple-ids=9 row-size=37B cardinality=12
|  |  |  |  |  |     in pipelines: 09(GETNEXT)
|  |  |  |  |  |
|  |  |  |  |  25:HASH JOIN [INNER JOIN]
|  |  |  |  |  |  hash predicates: ss_promo_sk = p_promo_sk
|  |  |  |  |  |  fk/pk conjuncts: ss_promo_sk = p_promo_sk
|  |  |  |  |  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  |  |  |  |  tuple-ids=1,0,20,6,14,13 row-size=151B cardinality=8.66K
|  |  |  |  |  |  in pipelines: 01(GETNEXT), 13(OPEN)
|  |  |  |  |  |
|  |  |  |  |  |--13:SCAN HDFS [tpcds_parquet.promotion]
|  |  |  |  |  |     HDFS partitions=1/1 files=1 size=23.30KB
|  |  |  |  |  |     stored statistics:
|  |  |  |  |  |       table: rows=300 size=23.30KB
|  |  |  |  |  |       columns: all
|  |  |  |  |  |     extrapolated-rows=disabled max-scan-range-rows=300
|  |  |  |  |  |     mem-estimate=16.00MB mem-reservation=32.00KB thread-reservation=1
|  |  |  |  |  |     tuple-ids=13 row-size=4B cardinality=300
|  |  |  |  |  |     in pipelines: 13(GETNEXT)
|  |  |  |  |  |
|  |  |  |  |  24:HASH JOIN [INNER JOIN]
|  |  |  |  |  |  hash predicates: ss_hdemo_sk = hd1.hd_demo_sk
|  |  |  |  |  |  fk/pk conjuncts: ss_hdemo_sk = hd1.hd_demo_sk
|  |  |  |  |  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  |  |  |  |  tuple-ids=1,0,20,6,14 row-size=147B cardinality=8.72K
|  |  |  |  |  |  in pipelines: 01(GETNEXT), 14(OPEN)
|  |  |  |  |  |
|  |  |  |  |  |--14:SCAN HDFS [tpcds_parquet.household_demographics hd1]
|  |  |  |  |  |     HDFS partitions=1/1 files=1 size=41.69KB
|  |  |  |  |  |     stored statistics:
|  |  |  |  |  |       table: rows=7.20K size=41.69KB
|  |  |  |  |  |       columns: all
|  |  |  |  |  |     extrapolated-rows=disabled max-scan-range-rows=7.20K
|  |  |  |  |  |     mem-estimate=32.00MB mem-reservation=64.00KB thread-reservation=1
|  |  |  |  |  |     tuple-ids=14 row-size=8B cardinality=7.20K
|  |  |  |  |  |     in pipelines: 14(GETNEXT)
|  |  |  |  |  |
|  |  |  |  |  23:HASH JOIN [INNER JOIN]
|  |  |  |  |  |  hash predicates: sr_item_sk = ss_item_sk, sr_ticket_number = ss_ticket_number
|  |  |  |  |  |  fk/pk conjuncts: sr_item_sk = ss_item_sk, sr_ticket_number = ss_ticket_number
|  |  |  |  |  |  runtime filters: RF034[bloom] <- ss_item_sk, RF035[bloom] <- ss_ticket_number
|  |  |  |  |  |  mem-estimate=2.88MB mem-reservation=2.88MB spill-buffer=128.00KB thread-reservation=0
|  |  |  |  |  |  tuple-ids=1,0,20,6 row-size=139B cardinality=8.93K
|  |  |  |  |  |  in pipelines: 01(GETNEXT), 00(OPEN)
|  |  |  |  |  |
|  |  |  |  |  |--22:HASH JOIN [INNER JOIN]
|  |  |  |  |  |  |  hash predicates: ss_sold_date_sk = d1.d_date_sk
|  |  |  |  |  |  |  fk/pk conjuncts: ss_sold_date_sk = d1.d_date_sk
|  |  |  |  |  |  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  |  |  |  |  |  tuple-ids=0,20,6 row-size=123B cardinality=12.14K
|  |  |  |  |  |  |  in pipelines: 00(GETNEXT), 06(OPEN)
|  |  |  |  |  |  |
|  |  |  |  |  |  |--06:SCAN HDFS [tpcds_parquet.date_dim d1]
|  |  |  |  |  |  |     HDFS partitions=1/1 files=1 size=2.15MB
|  |  |  |  |  |  |     predicates: d1.d_year = CAST(1999 AS INT)
|  |  |  |  |  |  |     stored statistics:
|  |  |  |  |  |  |       table: rows=73.05K size=2.15MB
|  |  |  |  |  |  |       columns: all
|  |  |  |  |  |  |     extrapolated-rows=disabled max-scan-range-rows=73.05K
|  |  |  |  |  |  |     parquet statistics predicates: d1.d_year = CAST(1999 AS INT)
|  |  |  |  |  |  |     parquet dictionary predicates: d1.d_year = CAST(1999 AS INT)
|  |  |  |  |  |  |     mem-estimate=32.00MB mem-reservation=512.00KB thread-reservation=1
|  |  |  |  |  |  |     tuple-ids=6 row-size=8B cardinality=373
|  |  |  |  |  |  |     in pipelines: 06(GETNEXT)
|  |  |  |  |  |  |
|  |  |  |  |  |  21:HASH JOIN [INNER JOIN]
|  |  |  |  |  |  |  hash predicates: ss_item_sk = i_item_sk
|  |  |  |  |  |  |  fk/pk conjuncts: ss_item_sk = i_item_sk
|  |  |  |  |  |  |  runtime filters: RF040[bloom] <- i_item_sk
|  |  |  |  |  |  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  |  |  |  |  |  tuple-ids=0,20 row-size=115B cardinality=59.37K
|  |  |  |  |  |  |  in pipelines: 00(GETNEXT), 20(OPEN)
|  |  |  |  |  |  |
|  |  |  |  |  |  |--20:SCAN HDFS [tpcds_parquet.item]
|  |  |  |  |  |  |     HDFS partitions=1/1 files=1 size=1.73MB
|  |  |  |  |  |  |     predicates: i_color IN ('purple', 'burlywood', 'indian', 'spring', 'floral', 'medium'), i_current_price <= CAST(74 AS DECIMAL(3,0)), i_current_price <= CAST(79 AS DECIMAL(3,0)), i_current_price >= CAST(64 AS DECIMAL(3,0)), i_current_price >= CAST(65 AS DECIMAL(3,0))
|  |  |  |  |  |  |     stored statistics:
|  |  |  |  |  |  |       table: rows=18.00K size=1.73MB
|  |  |  |  |  |  |       columns: all
|  |  |  |  |  |  |     extrapolated-rows=disabled max-scan-range-rows=18.00K
|  |  |  |  |  |  |     parquet statistics predicates: i_color IN ('purple', 'burlywood', 'indian', 'spring', 'floral', 'medium'), i_current_price <= CAST(74 AS DECIMAL(3,0)), i_current_price <= CAST(79 AS DECIMAL(3,0)), i_current_price >= CAST(64 AS DECIMAL(3,0)), i_current_price >= CAST(65 AS DECIMAL(3,0))
|  |  |  |  |  |  |     parquet dictionary predicates: i_color IN ('purple', 'burlywood', 'indian', 'spring', 'floral', 'medium'), i_current_price <= CAST(74 AS DECIMAL(3,0)), i_current_price <= CAST(79 AS DECIMAL(3,0)), i_current_price >= CAST(64 AS DECIMAL(3,0)), i_current_price >= CAST(65 AS DECIMAL(3,0))
|  |  |  |  |  |  |     mem-estimate=64.00MB mem-reservation=512.00KB thread-reservation=1
|  |  |  |  |  |  |     tuple-ids=20 row-size=59B cardinality=371
|  |  |  |  |  |  |     in pipelines: 20(GETNEXT)
|  |  |  |  |  |  |
|  |  |  |  |  |  00:SCAN HDFS [tpcds_parquet.store_sales]
|  |  |  |  |  |     HDFS partitions=1824/1824 files=1824 size=200.95MB
|  |  |  |  |  |     runtime filters: RF040[bloom] -> ss_item_sk
|  |  |  |  |  |     stored statistics:
|  |  |  |  |  |       table: rows=2.88M size=200.95MB
|  |  |  |  |  |       partitions: 1824/1824 rows=2.88M
|  |  |  |  |  |       columns: all
|  |  |  |  |  |     extrapolated-rows=disabled max-scan-range-rows=130.09K
|  |  |  |  |  |     mem-estimate=128.00MB mem-reservation=8.00MB thread-reservation=1
|  |  |  |  |  |     tuple-ids=0 row-size=56B cardinality=2.88M
|  |  |  |  |  |     in pipelines: 00(GETNEXT)
|  |  |  |  |  |
|  |  |  |  |  01:SCAN HDFS [tpcds_parquet.store_returns]
|  |  |  |  |     HDFS partitions=1/1 files=1 size=15.43MB
|  |  |  |  |     runtime filters: RF034[bloom] -> sr_item_sk, RF035[bloom] -> sr_ticket_number
|  |  |  |  |     stored statistics:
|  |  |  |  |       table: rows=287.51K size=15.43MB
|  |  |  |  |       columns: all
|  |  |  |  |     extrapolated-rows=disabled max-scan-range-rows=287.51K
|  |  |  |  |     mem-estimate=48.00MB mem-reservation=4.00MB thread-reservation=1
|  |  |  |  |     tuple-ids=1 row-size=16B cardinality=287.51K
|  |  |  |  |     in pipelines: 01(GETNEXT)
|  |  |  |  |
|  |  |  |  10:SCAN HDFS [tpcds_parquet.customer]
|  |  |  |     HDFS partitions=1/1 files=1 size=5.49MB
|  |  |  |     stored statistics:
|  |  |  |       table: rows=100.00K size=5.49MB
|  |  |  |       columns: all
|  |  |  |     extrapolated-rows=disabled max-scan-range-rows=100.00K
|  |  |  |     mem-estimate=96.00MB mem-reservation=2.00MB thread-reservation=1
|  |  |  |     tuple-ids=10 row-size=24B cardinality=100.00K
|  |  |  |     in pipelines: 10(GETNEXT)
|  |  |  |
|  |  |  11:SCAN HDFS [tpcds_parquet.customer_demographics cd1]
|  |  |     HDFS partitions=1/1 files=1 size=7.49MB
|  |  |     runtime filters: RF018[bloom] -> cd1.cd_demo_sk
|  |  |     stored statistics:
|  |  |       table: rows=1.92M size=7.49MB
|  |  |       columns: all
|  |  |     extrapolated-rows=disabled max-scan-range-rows=1.92M
|  |  |     mem-estimate=32.00MB mem-reservation=8.00MB thread-reservation=1
|  |  |     tuple-ids=11 row-size=17B cardinality=1.92M
|  |  |     in pipelines: 11(GETNEXT)
|  |  |
|  |  12:SCAN HDFS [tpcds_parquet.customer_demographics cd2]
|  |     HDFS partitions=1/1 files=1 size=7.49MB
|  |     runtime filters: RF016[bloom] -> cd2.cd_demo_sk
|  |     stored statistics:
|  |       table: rows=1.92M size=7.49MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=1.92M
|  |     mem-estimate=32.00MB mem-reservation=8.00MB thread-reservation=1
|  |     tuple-ids=12 row-size=17B cardinality=1.92M
|  |     in pipelines: 12(GETNEXT)
|  |
|  16:SCAN HDFS [tpcds_parquet.customer_address ad1]
|     HDFS partitions=1/1 files=1 size=1.16MB
|     stored statistics:
|       table: rows=50.00K size=1.16MB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=50.00K
|     mem-estimate=80.00MB mem-reservation=1.00MB thread-reservation=1
|     tuple-ids=16 row-size=78B cardinality=50.00K
|     in pipelines: 16(GETNEXT)
|
17:SCAN HDFS [tpcds_parquet.customer_address ad2]
   HDFS partitions=1/1 files=1 size=1.16MB
   stored statistics:
     table: rows=50.00K size=1.16MB
     columns: all
   extrapolated-rows=disabled max-scan-range-rows=50.00K
   mem-estimate=80.00MB mem-reservation=1.00MB thread-reservation=1
   tuple-ids=17 row-size=78B cardinality=50.00K
   in pipelines: 17(GETNEXT)
---- DISTRIBUTEDPLAN
Max Per-Host Resource Reservation: Memory=436.52MB Threads=98
Per-Host Resource Estimates: Memory=2.68GB
F59:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
|  Per-Host Resources: mem-estimate=30.98MB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
|  output exprs: product_name, store_name, store_zip, b_street_number, b_street_name, b_city, b_zip, c_street_number, c_street_name, c_city, c_zip, syear, cnt, s1, s2, s3, s1, s2, s3, syear, cnt
|  mem-estimate=0B mem-reservation=0B thread-reservation=0
|
142:MERGING-EXCHANGE [UNPARTITIONED]
|  order by: product_name ASC, store_name ASC, cnt ASC, s1 ASC, s1 ASC
|  mem-estimate=30.98MB mem-reservation=0B thread-reservation=0
|  tuple-ids=46 row-size=330B cardinality=288.12K
|  in pipelines: 79(GETNEXT)
|
F58:PLAN FRAGMENT [HASH(i_item_sk,s_store_name,s_zip)] hosts=3 instances=3
Per-Host Resources: mem-estimate=56.85MB mem-reservation=46.00MB thread-reservation=1
79:SORT
|  order by: product_name ASC, store_name ASC, cnt ASC, s1 ASC, s1 ASC
|  mem-estimate=12.00MB mem-reservation=12.00MB spill-buffer=2.00MB thread-reservation=0
|  tuple-ids=46 row-size=330B cardinality=288.12K
|  in pipelines: 79(GETNEXT), 109(OPEN)
|
78:HASH JOIN [INNER JOIN, PARTITIONED]
|  hash predicates: i_item_sk = i_item_sk, s_store_name = s_store_name, s_zip = s_zip
|  fk/pk conjuncts: i_item_sk = i_item_sk, s_store_name = s_store_name, s_zip = s_zip
|  other predicates: count(*) <= count(*)
|  mem-estimate=34.00MB mem-reservation=34.00MB spill-buffer=2.00MB thread-reservation=0
|  tuple-ids=21,44 row-size=573B cardinality=288.12K
|  in pipelines: 109(GETNEXT), 139(OPEN)
|
|--141:EXCHANGE [HASH(i_item_sk,s_store_name,s_zip)]
|  |  mem-estimate=10.85MB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=44 row-size=286B cardinality=288.12K
|  |  in pipelines: 139(GETNEXT)
|  |
|  F57:PLAN FRAGMENT [HASH(i_product_name,i_item_sk,s_store_name,s_zip,ad1.ca_street_number,ad1.ca_street_name,ad1.ca_city,ad1.ca_zip,ad2.ca_street_number,ad2.ca_street_name,ad2.ca_city,ad2.ca_zip,d1.d_year,d2.d_year,d3.d_year)] hosts=3 instances=3
|  Per-Host Resources: mem-estimate=54.13MB mem-reservation=34.00MB thread-reservation=1
|  139:AGGREGATE [FINALIZE]
|  |  output: count:merge(*), sum:merge(ss_wholesale_cost), sum:merge(ss_list_price), sum:merge(ss_coupon_amt)
|  |  group by: i_product_name, i_item_sk, s_store_name, s_zip, ad1.ca_street_number, ad1.ca_street_name, ad1.ca_city, ad1.ca_zip, ad2.ca_street_number, ad2.ca_street_name, ad2.ca_city, ad2.ca_zip, d1.d_year, d2.d_year, d3.d_year
|  |  mem-estimate=43.28MB mem-reservation=34.00MB spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=44 row-size=286B cardinality=288.12K
|  |  in pipelines: 139(GETNEXT), 39(OPEN)
|  |
|  138:EXCHANGE [HASH(i_product_name,i_item_sk,s_store_name,s_zip,ad1.ca_street_number,ad1.ca_street_name,ad1.ca_city,ad1.ca_zip,ad2.ca_street_number,ad2.ca_street_name,ad2.ca_city,ad2.ca_zip,d1.d_year,d2.d_year,d3.d_year)]
|  |  mem-estimate=10.85MB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=44 row-size=286B cardinality=288.12K
|  |  in pipelines: 39(GETNEXT)
|  |
|  F51:PLAN FRAGMENT [HASH(c_current_addr_sk)] hosts=3 instances=3
|  Per-Host Resources: mem-estimate=58.09MB mem-reservation=42.69MB thread-reservation=1
|  77:AGGREGATE [STREAMING]
|  |  output: count(*), sum(ss_wholesale_cost), sum(ss_list_price), sum(ss_coupon_amt)
|  |  group by: i_product_name, i_item_sk, s_store_name, s_zip, ad1.ca_street_number, ad1.ca_street_name, ad1.ca_city, ad1.ca_zip, ad2.ca_street_number, ad2.ca_street_name, ad2.ca_city, ad2.ca_zip, d1.d_year, d2.d_year, d3.d_year
|  |  mem-estimate=43.28MB mem-reservation=34.00MB spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=44 row-size=286B cardinality=288.12K
|  |  in pipelines: 39(GETNEXT)
|  |
|  76:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash predicates: ss_item_sk = cs_item_sk
|  |  fk/pk conjuncts: none
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33,38,30,31,34,35,39,40,41,42,27 row-size=474B cardinality=288.12K
|  |  in pipelines: 39(GETNEXT), 136(OPEN)
|  |
|  |--137:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=202.23KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=27 row-size=40B cardinality=1.80K
|  |  |  in pipelines: 136(GETNEXT)
|  |  |
|  |  F56:PLAN FRAGMENT [HASH(cs_item_sk)] hosts=3 instances=3
|  |  Per-Host Resources: mem-estimate=10.36MB mem-reservation=1.94MB thread-reservation=1
|  |  136:AGGREGATE [FINALIZE]
|  |  |  output: sum:merge(cs_ext_list_price), sum:merge(cr_refunded_cash + cr_reversed_charge + cr_store_credit)
|  |  |  group by: cs_item_sk
|  |  |  having: sum(cs_ext_list_price) > CAST(2 AS DECIMAL(3,0)) * sum(cr_refunded_cash + cr_reversed_charge + cr_store_credit)
|  |  |  mem-estimate=10.00MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  |  tuple-ids=27 row-size=40B cardinality=1.80K
|  |  |  in pipelines: 136(GETNEXT), 41(OPEN)
|  |  |
|  |  135:EXCHANGE [HASH(cs_item_sk)]
|  |  |  mem-estimate=366.05KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=27 row-size=40B cardinality=17.98K
|  |  |  in pipelines: 41(GETNEXT)
|  |  |
|  |  F54:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  |  Per-Host Resources: mem-estimate=164.63MB mem-reservation=16.75MB thread-reservation=2 runtime-filters-memory=2.00MB
|  |  44:AGGREGATE [STREAMING]
|  |  |  output: sum(cs_ext_list_price), sum(cr_refunded_cash + cr_reversed_charge + cr_store_credit)
|  |  |  group by: cs_item_sk
|  |  |  mem-estimate=10.00MB mem-reservation=2.00MB spill-buffer=64.00KB thread-reservation=0
|  |  |  tuple-ids=27 row-size=40B cardinality=17.98K
|  |  |  in pipelines: 41(GETNEXT)
|  |  |
|  |  43:HASH JOIN [INNER JOIN, BROADCAST]
|  |  |  hash predicates: cs_item_sk = cr_item_sk, cs_order_number = cr_order_number
|  |  |  fk/pk conjuncts: cs_item_sk = cr_item_sk, cs_order_number = cr_order_number
|  |  |  runtime filters: RF082[bloom] <- cr_item_sk, RF083[bloom] <- cr_order_number
|  |  |  mem-estimate=4.75MB mem-reservation=4.75MB spill-buffer=256.00KB thread-reservation=0
|  |  |  tuple-ids=25,26 row-size=48B cardinality=849.41K
|  |  |  in pipelines: 41(GETNEXT), 42(OPEN)
|  |  |
|  |  |--134:EXCHANGE [BROADCAST]
|  |  |  |  mem-estimate=3.88MB mem-reservation=0B thread-reservation=0
|  |  |  |  tuple-ids=26 row-size=28B cardinality=144.07K
|  |  |  |  in pipelines: 42(GETNEXT)
|  |  |  |
|  |  |  F55:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  |  Per-Host Resources: mem-estimate=120.00MB mem-reservation=4.00MB thread-reservation=2
|  |  |  42:SCAN HDFS [tpcds_parquet.catalog_returns, RANDOM]
|  |  |     HDFS partitions=1/1 files=1 size=10.62MB
|  |  |     stored statistics:
|  |  |       table: rows=144.07K size=10.62MB
|  |  |       columns: all
|  |  |     extrapolated-rows=disabled max-scan-range-rows=144.07K
|  |  |     mem-estimate=120.00MB mem-reservation=4.00MB thread-reservation=1
|  |  |     tuple-ids=26 row-size=28B cardinality=144.07K
|  |  |     in pipelines: 42(GETNEXT)
|  |  |
|  |  41:SCAN HDFS [tpcds_parquet.catalog_sales, RANDOM]
|  |     HDFS partitions=1/1 files=3 size=96.62MB
|  |     runtime filters: RF082[bloom] -> cs_item_sk, RF083[bloom] -> cs_order_number
|  |     stored statistics:
|  |       table: rows=1.44M size=96.62MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=650.14K
|  |     mem-estimate=144.00MB mem-reservation=8.00MB thread-reservation=1
|  |     tuple-ids=25 row-size=20B cardinality=1.44M
|  |     in pipelines: 41(GETNEXT)
|  |
|  75:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash predicates: hd2.hd_income_band_sk = ib2.ib_income_band_sk
|  |  fk/pk conjuncts: hd2.hd_income_band_sk = ib2.ib_income_band_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33,38,30,31,34,35,39,40,41,42 row-size=434B cardinality=8.45K
|  |  in pipelines: 39(GETNEXT), 58(OPEN)
|  |
|  |--133:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=42 row-size=4B cardinality=20
|  |  |  in pipelines: 58(GETNEXT)
|  |  |
|  |  F53:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=16.00MB mem-reservation=8.00KB thread-reservation=2
|  |  58:SCAN HDFS [tpcds_parquet.income_band ib2, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=1.21KB
|  |     stored statistics:
|  |       table: rows=20 size=1.21KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=20
|  |     mem-estimate=16.00MB mem-reservation=8.00KB thread-reservation=1
|  |     tuple-ids=42 row-size=4B cardinality=20
|  |     in pipelines: 58(GETNEXT)
|  |
|  74:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash predicates: hd1.hd_income_band_sk = ib1.ib_income_band_sk
|  |  fk/pk conjuncts: hd1.hd_income_band_sk = ib1.ib_income_band_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33,38,30,31,34,35,39,40,41 row-size=430B cardinality=8.45K
|  |  in pipelines: 39(GETNEXT), 57(OPEN)
|  |
|  |--132:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=41 row-size=4B cardinality=20
|  |  |  in pipelines: 57(GETNEXT)
|  |  |
|  |  F52:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=16.00MB mem-reservation=8.00KB thread-reservation=2
|  |  57:SCAN HDFS [tpcds_parquet.income_band ib1, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=1.21KB
|  |     stored statistics:
|  |       table: rows=20 size=1.21KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=20
|  |     mem-estimate=16.00MB mem-reservation=8.00KB thread-reservation=1
|  |     tuple-ids=41 row-size=4B cardinality=20
|  |     in pipelines: 57(GETNEXT)
|  |
|  73:HASH JOIN [INNER JOIN, PARTITIONED]
|  |  hash predicates: c_current_addr_sk = ad2.ca_address_sk
|  |  fk/pk conjuncts: c_current_addr_sk = ad2.ca_address_sk
|  |  mem-estimate=2.88MB mem-reservation=2.88MB spill-buffer=128.00KB thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33,38,30,31,34,35,39,40 row-size=426B cardinality=8.45K
|  |  in pipelines: 39(GETNEXT), 56(OPEN)
|  |
|  |--131:EXCHANGE [HASH(ad2.ca_address_sk)]
|  |  |  mem-estimate=3.78MB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=40 row-size=78B cardinality=50.00K
|  |  |  in pipelines: 56(GETNEXT)
|  |  |
|  |  F50:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=80.00MB mem-reservation=1.00MB thread-reservation=2
|  |  56:SCAN HDFS [tpcds_parquet.customer_address ad2, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=1.16MB
|  |     stored statistics:
|  |       table: rows=50.00K size=1.16MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=50.00K
|  |     mem-estimate=80.00MB mem-reservation=1.00MB thread-reservation=1
|  |     tuple-ids=40 row-size=78B cardinality=50.00K
|  |     in pipelines: 56(GETNEXT)
|  |
|  130:EXCHANGE [HASH(c_current_addr_sk)]
|  |  mem-estimate=2.12MB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33,38,30,31,34,35,39 row-size=348B cardinality=8.45K
|  |  in pipelines: 39(GETNEXT)
|  |
|  F49:PLAN FRAGMENT [HASH(ss_addr_sk)] hosts=3 instances=3
|  Per-Host Resources: mem-estimate=8.33MB mem-reservation=2.88MB thread-reservation=1
|  72:HASH JOIN [INNER JOIN, PARTITIONED]
|  |  hash predicates: ss_addr_sk = ad1.ca_address_sk
|  |  fk/pk conjuncts: ss_addr_sk = ad1.ca_address_sk
|  |  mem-estimate=2.88MB mem-reservation=2.88MB spill-buffer=128.00KB thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33,38,30,31,34,35,39 row-size=348B cardinality=8.45K
|  |  in pipelines: 39(GETNEXT), 55(OPEN)
|  |
|  |--129:EXCHANGE [HASH(ad1.ca_address_sk)]
|  |  |  mem-estimate=3.78MB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=39 row-size=78B cardinality=50.00K
|  |  |  in pipelines: 55(GETNEXT)
|  |  |
|  |  F48:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=80.00MB mem-reservation=1.00MB thread-reservation=2
|  |  55:SCAN HDFS [tpcds_parquet.customer_address ad1, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=1.16MB
|  |     stored statistics:
|  |       table: rows=50.00K size=1.16MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=50.00K
|  |     mem-estimate=80.00MB mem-reservation=1.00MB thread-reservation=1
|  |     tuple-ids=39 row-size=78B cardinality=50.00K
|  |     in pipelines: 55(GETNEXT)
|  |
|  128:EXCHANGE [HASH(ss_addr_sk)]
|  |  mem-estimate=1.67MB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33,38,30,31,34,35 row-size=271B cardinality=8.45K
|  |  in pipelines: 39(GETNEXT)
|  |
|  F47:PLAN FRAGMENT [HASH(c_current_cdemo_sk)] hosts=3 instances=3
|  Per-Host Resources: mem-estimate=28.59MB mem-reservation=17.00MB thread-reservation=1
|  71:HASH JOIN [INNER JOIN, PARTITIONED]
|  |  hash predicates: c_current_cdemo_sk = cd2.cd_demo_sk
|  |  fk/pk conjuncts: c_current_cdemo_sk = cd2.cd_demo_sk
|  |  other predicates: cd1.cd_marital_status != cd2.cd_marital_status
|  |  mem-estimate=17.00MB mem-reservation=17.00MB spill-buffer=1.00MB thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33,38,30,31,34,35 row-size=271B cardinality=8.45K
|  |  in pipelines: 39(GETNEXT), 51(OPEN)
|  |
|  |--127:EXCHANGE [HASH(cd2.cd_demo_sk)]
|  |  |  mem-estimate=10.02MB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=35 row-size=17B cardinality=1.92M
|  |  |  in pipelines: 51(GETNEXT)
|  |  |
|  |  F46:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=32.00MB mem-reservation=8.00MB thread-reservation=2
|  |  51:SCAN HDFS [tpcds_parquet.customer_demographics cd2, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=7.49MB
|  |     stored statistics:
|  |       table: rows=1.92M size=7.49MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=1.92M
|  |     mem-estimate=32.00MB mem-reservation=8.00MB thread-reservation=1
|  |     tuple-ids=35 row-size=17B cardinality=1.92M
|  |     in pipelines: 51(GETNEXT)
|  |
|  126:EXCHANGE [HASH(c_current_cdemo_sk)]
|  |  mem-estimate=1.57MB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33,38,30,31,34 row-size=254B cardinality=8.45K
|  |  in pipelines: 39(GETNEXT)
|  |
|  F45:PLAN FRAGMENT [HASH(ss_cdemo_sk)] hosts=3 instances=3
|  Per-Host Resources: mem-estimate=28.48MB mem-reservation=17.00MB thread-reservation=1
|  70:HASH JOIN [INNER JOIN, PARTITIONED]
|  |  hash predicates: ss_cdemo_sk = cd1.cd_demo_sk
|  |  fk/pk conjuncts: ss_cdemo_sk = cd1.cd_demo_sk
|  |  mem-estimate=17.00MB mem-reservation=17.00MB spill-buffer=1.00MB thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33,38,30,31,34 row-size=254B cardinality=8.45K
|  |  in pipelines: 39(GETNEXT), 50(OPEN)
|  |
|  |--125:EXCHANGE [HASH(cd1.cd_demo_sk)]
|  |  |  mem-estimate=10.02MB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=34 row-size=17B cardinality=1.92M
|  |  |  in pipelines: 50(GETNEXT)
|  |  |
|  |  F44:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=32.00MB mem-reservation=8.00MB thread-reservation=2
|  |  50:SCAN HDFS [tpcds_parquet.customer_demographics cd1, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=7.49MB
|  |     stored statistics:
|  |       table: rows=1.92M size=7.49MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=1.92M
|  |     mem-estimate=32.00MB mem-reservation=8.00MB thread-reservation=1
|  |     tuple-ids=34 row-size=17B cardinality=1.92M
|  |     in pipelines: 50(GETNEXT)
|  |
|  124:EXCHANGE [HASH(ss_cdemo_sk)]
|  |  mem-estimate=1.46MB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33,38,30,31 row-size=237B cardinality=8.45K
|  |  in pipelines: 39(GETNEXT)
|  |
|  F43:PLAN FRAGMENT [HASH(c_first_shipto_date_sk)] hosts=3 instances=3
|  Per-Host Resources: mem-estimate=3.91MB mem-reservation=1.94MB thread-reservation=1
|  69:HASH JOIN [INNER JOIN, PARTITIONED]
|  |  hash predicates: c_first_shipto_date_sk = d3.d_date_sk
|  |  fk/pk conjuncts: c_first_shipto_date_sk = d3.d_date_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33,38,30,31 row-size=237B cardinality=8.45K
|  |  in pipelines: 39(GETNEXT), 47(OPEN)
|  |
|  |--123:EXCHANGE [HASH(d3.d_date_sk)]
|  |  |  mem-estimate=582.70KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=31 row-size=8B cardinality=73.05K
|  |  |  in pipelines: 47(GETNEXT)
|  |  |
|  |  F42:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=32.00MB mem-reservation=512.00KB thread-reservation=2
|  |  47:SCAN HDFS [tpcds_parquet.date_dim d3, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=2.15MB
|  |     stored statistics:
|  |       table: rows=73.05K size=2.15MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=73.05K
|  |     mem-estimate=32.00MB mem-reservation=512.00KB thread-reservation=1
|  |     tuple-ids=31 row-size=8B cardinality=73.05K
|  |     in pipelines: 47(GETNEXT)
|  |
|  122:EXCHANGE [HASH(c_first_shipto_date_sk)]
|  |  mem-estimate=1.40MB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33,38,30 row-size=229B cardinality=8.45K
|  |  in pipelines: 39(GETNEXT)
|  |
|  F41:PLAN FRAGMENT [HASH(c_first_sales_date_sk)] hosts=3 instances=3
|  Per-Host Resources: mem-estimate=3.85MB mem-reservation=1.94MB thread-reservation=1
|  68:HASH JOIN [INNER JOIN, PARTITIONED]
|  |  hash predicates: c_first_sales_date_sk = d2.d_date_sk
|  |  fk/pk conjuncts: c_first_sales_date_sk = d2.d_date_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33,38,30 row-size=229B cardinality=8.45K
|  |  in pipelines: 39(GETNEXT), 46(OPEN)
|  |
|  |--121:EXCHANGE [HASH(d2.d_date_sk)]
|  |  |  mem-estimate=582.70KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=30 row-size=8B cardinality=73.05K
|  |  |  in pipelines: 46(GETNEXT)
|  |  |
|  |  F40:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=32.00MB mem-reservation=512.00KB thread-reservation=2
|  |  46:SCAN HDFS [tpcds_parquet.date_dim d2, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=2.15MB
|  |     stored statistics:
|  |       table: rows=73.05K size=2.15MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=73.05K
|  |     mem-estimate=32.00MB mem-reservation=512.00KB thread-reservation=1
|  |     tuple-ids=30 row-size=8B cardinality=73.05K
|  |     in pipelines: 46(GETNEXT)
|  |
|  120:EXCHANGE [HASH(c_first_sales_date_sk)]
|  |  mem-estimate=1.35MB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33,38 row-size=221B cardinality=8.45K
|  |  in pipelines: 39(GETNEXT)
|  |
|  F38:PLAN FRAGMENT [HASH(ss_customer_sk)] hosts=3 instances=3
|  Per-Host Resources: mem-estimate=7.41MB mem-reservation=3.88MB thread-reservation=1
|  67:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash predicates: c_current_hdemo_sk = hd2.hd_demo_sk
|  |  fk/pk conjuncts: c_current_hdemo_sk = hd2.hd_demo_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33,38 row-size=221B cardinality=8.45K
|  |  in pipelines: 39(GETNEXT), 54(OPEN)
|  |
|  |--119:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=68.25KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=38 row-size=8B cardinality=7.20K
|  |  |  in pipelines: 54(GETNEXT)
|  |  |
|  |  F39:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=32.00MB mem-reservation=64.00KB thread-reservation=2
|  |  54:SCAN HDFS [tpcds_parquet.household_demographics hd2, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=41.69KB
|  |     stored statistics:
|  |       table: rows=7.20K size=41.69KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=7.20K
|  |     mem-estimate=32.00MB mem-reservation=64.00KB thread-reservation=1
|  |     tuple-ids=38 row-size=8B cardinality=7.20K
|  |     in pipelines: 54(GETNEXT)
|  |
|  66:HASH JOIN [INNER JOIN, PARTITIONED]
|  |  hash predicates: ss_customer_sk = c_customer_sk
|  |  fk/pk conjuncts: ss_customer_sk = c_customer_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33 row-size=213B cardinality=8.66K
|  |  in pipelines: 39(GETNEXT), 49(OPEN)
|  |
|  |--118:EXCHANGE [HASH(c_customer_sk)]
|  |  |  mem-estimate=2.32MB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=33 row-size=24B cardinality=100.00K
|  |  |  in pipelines: 49(GETNEXT)
|  |  |
|  |  F37:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=96.00MB mem-reservation=2.00MB thread-reservation=2
|  |  49:SCAN HDFS [tpcds_parquet.customer, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=5.49MB
|  |     stored statistics:
|  |       table: rows=100.00K size=5.49MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=100.00K
|  |     mem-estimate=96.00MB mem-reservation=2.00MB thread-reservation=1
|  |     tuple-ids=33 row-size=24B cardinality=100.00K
|  |     in pipelines: 49(GETNEXT)
|  |
|  117:EXCHANGE [HASH(ss_customer_sk)]
|  |  mem-estimate=1.15MB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32 row-size=189B cardinality=8.66K
|  |  in pipelines: 39(GETNEXT)
|  |
|  F33:PLAN FRAGMENT [HASH(ss_item_sk,ss_ticket_number)] hosts=3 instances=3
|  Per-Host Resources: mem-estimate=14.07MB mem-reservation=8.69MB thread-reservation=1
|  65:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash predicates: ss_store_sk = s_store_sk
|  |  fk/pk conjuncts: ss_store_sk = s_store_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32 row-size=189B cardinality=8.66K
|  |  in pipelines: 39(GETNEXT), 48(OPEN)
|  |
|  |--116:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=32 row-size=37B cardinality=12
|  |  |  in pipelines: 48(GETNEXT)
|  |  |
|  |  F36:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=48.00MB mem-reservation=24.00KB thread-reservation=2
|  |  48:SCAN HDFS [tpcds_parquet.store, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=9.93KB
|  |     stored statistics:
|  |       table: rows=12 size=9.93KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=12
|  |     mem-estimate=48.00MB mem-reservation=24.00KB thread-reservation=1
|  |     tuple-ids=32 row-size=37B cardinality=12
|  |     in pipelines: 48(GETNEXT)
|  |
|  64:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash predicates: ss_promo_sk = p_promo_sk
|  |  fk/pk conjuncts: ss_promo_sk = p_promo_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36 row-size=151B cardinality=8.66K
|  |  in pipelines: 39(GETNEXT), 52(OPEN)
|  |
|  |--115:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=36 row-size=4B cardinality=300
|  |  |  in pipelines: 52(GETNEXT)
|  |  |
|  |  F35:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=16.00MB mem-reservation=32.00KB thread-reservation=2
|  |  52:SCAN HDFS [tpcds_parquet.promotion, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=23.30KB
|  |     stored statistics:
|  |       table: rows=300 size=23.30KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=300
|  |     mem-estimate=16.00MB mem-reservation=32.00KB thread-reservation=1
|  |     tuple-ids=36 row-size=4B cardinality=300
|  |     in pipelines: 52(GETNEXT)
|  |
|  63:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash predicates: ss_hdemo_sk = hd1.hd_demo_sk
|  |  fk/pk conjuncts: ss_hdemo_sk = hd1.hd_demo_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=23,43,29,24,37 row-size=147B cardinality=8.72K
|  |  in pipelines: 39(GETNEXT), 53(OPEN)
|  |
|  |--114:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=68.25KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=37 row-size=8B cardinality=7.20K
|  |  |  in pipelines: 53(GETNEXT)
|  |  |
|  |  F34:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=32.00MB mem-reservation=64.00KB thread-reservation=2
|  |  53:SCAN HDFS [tpcds_parquet.household_demographics hd1, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=41.69KB
|  |     stored statistics:
|  |       table: rows=7.20K size=41.69KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=7.20K
|  |     mem-estimate=32.00MB mem-reservation=64.00KB thread-reservation=1
|  |     tuple-ids=37 row-size=8B cardinality=7.20K
|  |     in pipelines: 53(GETNEXT)
|  |
|  62:HASH JOIN [INNER JOIN, PARTITIONED]
|  |  hash predicates: ss_item_sk = sr_item_sk, ss_ticket_number = sr_ticket_number
|  |  fk/pk conjuncts: ss_item_sk = sr_item_sk, ss_ticket_number = sr_ticket_number
|  |  mem-estimate=2.88MB mem-reservation=2.88MB spill-buffer=128.00KB thread-reservation=0
|  |  tuple-ids=23,43,29,24 row-size=139B cardinality=8.93K
|  |  in pipelines: 39(GETNEXT), 40(OPEN)
|  |
|  |--113:EXCHANGE [HASH(sr_item_sk,sr_ticket_number)]
|  |  |  mem-estimate=4.41MB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=24 row-size=16B cardinality=287.51K
|  |  |  in pipelines: 40(GETNEXT)
|  |  |
|  |  F32:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=48.00MB mem-reservation=4.00MB thread-reservation=2
|  |  40:SCAN HDFS [tpcds_parquet.store_returns, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=15.43MB
|  |     stored statistics:
|  |       table: rows=287.51K size=15.43MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=287.51K
|  |     mem-estimate=48.00MB mem-reservation=4.00MB thread-reservation=1
|  |     tuple-ids=24 row-size=16B cardinality=287.51K
|  |     in pipelines: 40(GETNEXT)
|  |
|  112:EXCHANGE [HASH(ss_item_sk,ss_ticket_number)]
|  |  mem-estimate=894.08KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=23,43,29 row-size=123B cardinality=12.14K
|  |  in pipelines: 39(GETNEXT)
|  |
|  F29:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  Per-Host Resources: mem-estimate=133.93MB mem-reservation=13.88MB thread-reservation=2 runtime-filters-memory=2.00MB
|  61:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash predicates: ss_sold_date_sk = d1.d_date_sk
|  |  fk/pk conjuncts: ss_sold_date_sk = d1.d_date_sk
|  |  runtime filters: RF078[bloom] <- d1.d_date_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=23,43,29 row-size=123B cardinality=12.14K
|  |  in pipelines: 39(GETNEXT), 45(OPEN)
|  |
|  |--111:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=29 row-size=8B cardinality=373
|  |  |  in pipelines: 45(GETNEXT)
|  |  |
|  |  F31:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=32.00MB mem-reservation=512.00KB thread-reservation=2
|  |  45:SCAN HDFS [tpcds_parquet.date_dim d1, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=2.15MB
|  |     predicates: d1.d_year = CAST(2000 AS INT)
|  |     stored statistics:
|  |       table: rows=73.05K size=2.15MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=73.05K
|  |     parquet statistics predicates: d1.d_year = CAST(2000 AS INT)
|  |     parquet dictionary predicates: d1.d_year = CAST(2000 AS INT)
|  |     mem-estimate=32.00MB mem-reservation=512.00KB thread-reservation=1
|  |     tuple-ids=29 row-size=8B cardinality=373
|  |     in pipelines: 45(GETNEXT)
|  |
|  60:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash predicates: ss_item_sk = i_item_sk
|  |  fk/pk conjuncts: ss_item_sk = i_item_sk
|  |  runtime filters: RF080[bloom] <- i_item_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=23,43 row-size=115B cardinality=59.37K
|  |  in pipelines: 39(GETNEXT), 59(OPEN)
|  |
|  |--110:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=44.51KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=43 row-size=59B cardinality=371
|  |  |  in pipelines: 59(GETNEXT)
|  |  |
|  |  F30:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=64.00MB mem-reservation=512.00KB thread-reservation=2
|  |  59:SCAN HDFS [tpcds_parquet.item, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=1.73MB
|  |     predicates: i_color IN ('purple', 'burlywood', 'indian', 'spring', 'floral', 'medium'), i_current_price <= CAST(74 AS DECIMAL(3,0)), i_current_price <= CAST(79 AS DECIMAL(3,0)), i_current_price >= CAST(64 AS DECIMAL(3,0)), i_current_price >= CAST(65 AS DECIMAL(3,0))
|  |     stored statistics:
|  |       table: rows=18.00K size=1.73MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=18.00K
|  |     parquet statistics predicates: i_color IN ('purple', 'burlywood', 'indian', 'spring', 'floral', 'medium'), i_current_price <= CAST(74 AS DECIMAL(3,0)), i_current_price <= CAST(79 AS DECIMAL(3,0)), i_current_price >= CAST(64 AS DECIMAL(3,0)), i_current_price >= CAST(65 AS DECIMAL(3,0))
|  |     parquet dictionary predicates: i_color IN ('purple', 'burlywood', 'indian', 'spring', 'floral', 'medium'), i_current_price <= CAST(74 AS DECIMAL(3,0)), i_current_price <= CAST(79 AS DECIMAL(3,0)), i_current_price >= CAST(64 AS DECIMAL(3,0)), i_current_price >= CAST(65 AS DECIMAL(3,0))
|  |     mem-estimate=64.00MB mem-reservation=512.00KB thread-reservation=1
|  |     tuple-ids=43 row-size=59B cardinality=371
|  |     in pipelines: 59(GETNEXT)
|  |
|  39:SCAN HDFS [tpcds_parquet.store_sales, RANDOM]
|     HDFS partitions=1824/1824 files=1824 size=200.95MB
|     runtime filters: RF080[bloom] -> ss_item_sk, RF078[bloom] -> ss_sold_date_sk
|     stored statistics:
|       table: rows=2.88M size=200.95MB
|       partitions: 1824/1824 rows=2.88M
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=130.09K
|     mem-estimate=128.00MB mem-reservation=8.00MB thread-reservation=1
|     tuple-ids=23 row-size=56B cardinality=2.88M
|     in pipelines: 39(GETNEXT)
|
140:EXCHANGE [HASH(i_item_sk,s_store_name,s_zip)]
|  mem-estimate=10.85MB mem-reservation=0B thread-reservation=0
|  tuple-ids=21 row-size=286B cardinality=288.12K
|  in pipelines: 109(GETNEXT)
|
F28:PLAN FRAGMENT [HASH(i_product_name,i_item_sk,s_store_name,s_zip,ad1.ca_street_number,ad1.ca_street_name,ad1.ca_city,ad1.ca_zip,ad2.ca_street_number,ad2.ca_street_name,ad2.ca_city,ad2.ca_zip,d1.d_year,d2.d_year,d3.d_year)] hosts=3 instances=3
Per-Host Resources: mem-estimate=54.13MB mem-reservation=34.00MB thread-reservation=1
109:AGGREGATE [FINALIZE]
|  output: count:merge(*), sum:merge(ss_wholesale_cost), sum:merge(ss_list_price), sum:merge(ss_coupon_amt)
|  group by: i_product_name, i_item_sk, s_store_name, s_zip, ad1.ca_street_number, ad1.ca_street_name, ad1.ca_city, ad1.ca_zip, ad2.ca_street_number, ad2.ca_street_name, ad2.ca_city, ad2.ca_zip, d1.d_year, d2.d_year, d3.d_year
|  mem-estimate=43.28MB mem-reservation=34.00MB spill-buffer=2.00MB thread-reservation=0
|  tuple-ids=21 row-size=286B cardinality=288.12K
|  in pipelines: 109(GETNEXT), 00(OPEN)
|
108:EXCHANGE [HASH(i_product_name,i_item_sk,s_store_name,s_zip,ad1.ca_street_number,ad1.ca_street_name,ad1.ca_city,ad1.ca_zip,ad2.ca_street_number,ad2.ca_street_name,ad2.ca_city,ad2.ca_zip,d1.d_year,d2.d_year,d3.d_year)]
|  mem-estimate=10.85MB mem-reservation=0B thread-reservation=0
|  tuple-ids=21 row-size=286B cardinality=288.12K
|  in pipelines: 00(GETNEXT)
|
F22:PLAN FRAGMENT [HASH(c_current_addr_sk)] hosts=3 instances=3
Per-Host Resources: mem-estimate=58.09MB mem-reservation=42.69MB thread-reservation=1
38:AGGREGATE [STREAMING]
|  output: count(*), sum(ss_wholesale_cost), sum(ss_list_price), sum(ss_coupon_amt)
|  group by: i_product_name, i_item_sk, s_store_name, s_zip, ad1.ca_street_number, ad1.ca_street_name, ad1.ca_city, ad1.ca_zip, ad2.ca_street_number, ad2.ca_street_name, ad2.ca_city, ad2.ca_zip, d1.d_year, d2.d_year, d3.d_year
|  mem-estimate=43.28MB mem-reservation=34.00MB spill-buffer=2.00MB thread-reservation=0
|  tuple-ids=21 row-size=286B cardinality=288.12K
|  in pipelines: 00(GETNEXT)
|
37:HASH JOIN [INNER JOIN, BROADCAST]
|  hash predicates: ss_item_sk = cs_item_sk
|  fk/pk conjuncts: none
|  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10,15,7,8,11,12,16,17,18,19,4 row-size=474B cardinality=288.12K
|  in pipelines: 00(GETNEXT), 106(OPEN)
|
|--107:EXCHANGE [BROADCAST]
|  |  mem-estimate=202.23KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=4 row-size=40B cardinality=1.80K
|  |  in pipelines: 106(GETNEXT)
|  |
|  F27:PLAN FRAGMENT [HASH(cs_item_sk)] hosts=3 instances=3
|  Per-Host Resources: mem-estimate=10.36MB mem-reservation=1.94MB thread-reservation=1
|  106:AGGREGATE [FINALIZE]
|  |  output: sum:merge(cs_ext_list_price), sum:merge(cr_refunded_cash + cr_reversed_charge + cr_store_credit)
|  |  group by: cs_item_sk
|  |  having: sum(cs_ext_list_price) > CAST(2 AS DECIMAL(3,0)) * sum(cr_refunded_cash + cr_reversed_charge + cr_store_credit)
|  |  mem-estimate=10.00MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=4 row-size=40B cardinality=1.80K
|  |  in pipelines: 106(GETNEXT), 02(OPEN)
|  |
|  105:EXCHANGE [HASH(cs_item_sk)]
|  |  mem-estimate=366.05KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=4 row-size=40B cardinality=17.98K
|  |  in pipelines: 02(GETNEXT)
|  |
|  F25:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  Per-Host Resources: mem-estimate=164.63MB mem-reservation=16.75MB thread-reservation=2 runtime-filters-memory=2.00MB
|  05:AGGREGATE [STREAMING]
|  |  output: sum(cs_ext_list_price), sum(cr_refunded_cash + cr_reversed_charge + cr_store_credit)
|  |  group by: cs_item_sk
|  |  mem-estimate=10.00MB mem-reservation=2.00MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=4 row-size=40B cardinality=17.98K
|  |  in pipelines: 02(GETNEXT)
|  |
|  04:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash predicates: cs_item_sk = cr_item_sk, cs_order_number = cr_order_number
|  |  fk/pk conjuncts: cs_item_sk = cr_item_sk, cs_order_number = cr_order_number
|  |  runtime filters: RF042[bloom] <- cr_item_sk, RF043[bloom] <- cr_order_number
|  |  mem-estimate=4.75MB mem-reservation=4.75MB spill-buffer=256.00KB thread-reservation=0
|  |  tuple-ids=2,3 row-size=48B cardinality=849.41K
|  |  in pipelines: 02(GETNEXT), 03(OPEN)
|  |
|  |--104:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=3.88MB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=3 row-size=28B cardinality=144.07K
|  |  |  in pipelines: 03(GETNEXT)
|  |  |
|  |  F26:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=120.00MB mem-reservation=4.00MB thread-reservation=2
|  |  03:SCAN HDFS [tpcds_parquet.catalog_returns, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=10.62MB
|  |     stored statistics:
|  |       table: rows=144.07K size=10.62MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=144.07K
|  |     mem-estimate=120.00MB mem-reservation=4.00MB thread-reservation=1
|  |     tuple-ids=3 row-size=28B cardinality=144.07K
|  |     in pipelines: 03(GETNEXT)
|  |
|  02:SCAN HDFS [tpcds_parquet.catalog_sales, RANDOM]
|     HDFS partitions=1/1 files=3 size=96.62MB
|     runtime filters: RF042[bloom] -> cs_item_sk, RF043[bloom] -> cs_order_number
|     stored statistics:
|       table: rows=1.44M size=96.62MB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=650.14K
|     mem-estimate=144.00MB mem-reservation=8.00MB thread-reservation=1
|     tuple-ids=2 row-size=20B cardinality=1.44M
|     in pipelines: 02(GETNEXT)
|
36:HASH JOIN [INNER JOIN, BROADCAST]
|  hash predicates: hd2.hd_income_band_sk = ib2.ib_income_band_sk
|  fk/pk conjuncts: hd2.hd_income_band_sk = ib2.ib_income_band_sk
|  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10,15,7,8,11,12,16,17,18,19 row-size=434B cardinality=8.45K
|  in pipelines: 00(GETNEXT), 19(OPEN)
|
|--103:EXCHANGE [BROADCAST]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=19 row-size=4B cardinality=20
|  |  in pipelines: 19(GETNEXT)
|  |
|  F24:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Host Resources: mem-estimate=16.00MB mem-reservation=8.00KB thread-reservation=2
|  19:SCAN HDFS [tpcds_parquet.income_band ib2, RANDOM]
|     HDFS partitions=1/1 files=1 size=1.21KB
|     stored statistics:
|       table: rows=20 size=1.21KB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=20
|     mem-estimate=16.00MB mem-reservation=8.00KB thread-reservation=1
|     tuple-ids=19 row-size=4B cardinality=20
|     in pipelines: 19(GETNEXT)
|
35:HASH JOIN [INNER JOIN, BROADCAST]
|  hash predicates: hd1.hd_income_band_sk = ib1.ib_income_band_sk
|  fk/pk conjuncts: hd1.hd_income_band_sk = ib1.ib_income_band_sk
|  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10,15,7,8,11,12,16,17,18 row-size=430B cardinality=8.45K
|  in pipelines: 00(GETNEXT), 18(OPEN)
|
|--102:EXCHANGE [BROADCAST]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=18 row-size=4B cardinality=20
|  |  in pipelines: 18(GETNEXT)
|  |
|  F23:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Host Resources: mem-estimate=16.00MB mem-reservation=8.00KB thread-reservation=2
|  18:SCAN HDFS [tpcds_parquet.income_band ib1, RANDOM]
|     HDFS partitions=1/1 files=1 size=1.21KB
|     stored statistics:
|       table: rows=20 size=1.21KB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=20
|     mem-estimate=16.00MB mem-reservation=8.00KB thread-reservation=1
|     tuple-ids=18 row-size=4B cardinality=20
|     in pipelines: 18(GETNEXT)
|
34:HASH JOIN [INNER JOIN, PARTITIONED]
|  hash predicates: c_current_addr_sk = ad2.ca_address_sk
|  fk/pk conjuncts: c_current_addr_sk = ad2.ca_address_sk
|  mem-estimate=2.88MB mem-reservation=2.88MB spill-buffer=128.00KB thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10,15,7,8,11,12,16,17 row-size=426B cardinality=8.45K
|  in pipelines: 00(GETNEXT), 17(OPEN)
|
|--101:EXCHANGE [HASH(ad2.ca_address_sk)]
|  |  mem-estimate=3.78MB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=17 row-size=78B cardinality=50.00K
|  |  in pipelines: 17(GETNEXT)
|  |
|  F21:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Host Resources: mem-estimate=80.00MB mem-reservation=1.00MB thread-reservation=2
|  17:SCAN HDFS [tpcds_parquet.customer_address ad2, RANDOM]
|     HDFS partitions=1/1 files=1 size=1.16MB
|     stored statistics:
|       table: rows=50.00K size=1.16MB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=50.00K
|     mem-estimate=80.00MB mem-reservation=1.00MB thread-reservation=1
|     tuple-ids=17 row-size=78B cardinality=50.00K
|     in pipelines: 17(GETNEXT)
|
100:EXCHANGE [HASH(c_current_addr_sk)]
|  mem-estimate=2.12MB mem-reservation=0B thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10,15,7,8,11,12,16 row-size=348B cardinality=8.45K
|  in pipelines: 00(GETNEXT)
|
F20:PLAN FRAGMENT [HASH(ss_addr_sk)] hosts=3 instances=3
Per-Host Resources: mem-estimate=8.33MB mem-reservation=2.88MB thread-reservation=1
33:HASH JOIN [INNER JOIN, PARTITIONED]
|  hash predicates: ss_addr_sk = ad1.ca_address_sk
|  fk/pk conjuncts: ss_addr_sk = ad1.ca_address_sk
|  mem-estimate=2.88MB mem-reservation=2.88MB spill-buffer=128.00KB thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10,15,7,8,11,12,16 row-size=348B cardinality=8.45K
|  in pipelines: 00(GETNEXT), 16(OPEN)
|
|--99:EXCHANGE [HASH(ad1.ca_address_sk)]
|  |  mem-estimate=3.78MB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=16 row-size=78B cardinality=50.00K
|  |  in pipelines: 16(GETNEXT)
|  |
|  F19:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Host Resources: mem-estimate=80.00MB mem-reservation=1.00MB thread-reservation=2
|  16:SCAN HDFS [tpcds_parquet.customer_address ad1, RANDOM]
|     HDFS partitions=1/1 files=1 size=1.16MB
|     stored statistics:
|       table: rows=50.00K size=1.16MB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=50.00K
|     mem-estimate=80.00MB mem-reservation=1.00MB thread-reservation=1
|     tuple-ids=16 row-size=78B cardinality=50.00K
|     in pipelines: 16(GETNEXT)
|
98:EXCHANGE [HASH(ss_addr_sk)]
|  mem-estimate=1.67MB mem-reservation=0B thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10,15,7,8,11,12 row-size=271B cardinality=8.45K
|  in pipelines: 00(GETNEXT)
|
F18:PLAN FRAGMENT [HASH(c_current_cdemo_sk)] hosts=3 instances=3
Per-Host Resources: mem-estimate=28.59MB mem-reservation=17.00MB thread-reservation=1
32:HASH JOIN [INNER JOIN, PARTITIONED]
|  hash predicates: c_current_cdemo_sk = cd2.cd_demo_sk
|  fk/pk conjuncts: c_current_cdemo_sk = cd2.cd_demo_sk
|  other predicates: cd1.cd_marital_status != cd2.cd_marital_status
|  mem-estimate=17.00MB mem-reservation=17.00MB spill-buffer=1.00MB thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10,15,7,8,11,12 row-size=271B cardinality=8.45K
|  in pipelines: 00(GETNEXT), 12(OPEN)
|
|--97:EXCHANGE [HASH(cd2.cd_demo_sk)]
|  |  mem-estimate=10.02MB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=12 row-size=17B cardinality=1.92M
|  |  in pipelines: 12(GETNEXT)
|  |
|  F17:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Host Resources: mem-estimate=32.00MB mem-reservation=8.00MB thread-reservation=2
|  12:SCAN HDFS [tpcds_parquet.customer_demographics cd2, RANDOM]
|     HDFS partitions=1/1 files=1 size=7.49MB
|     stored statistics:
|       table: rows=1.92M size=7.49MB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=1.92M
|     mem-estimate=32.00MB mem-reservation=8.00MB thread-reservation=1
|     tuple-ids=12 row-size=17B cardinality=1.92M
|     in pipelines: 12(GETNEXT)
|
96:EXCHANGE [HASH(c_current_cdemo_sk)]
|  mem-estimate=1.57MB mem-reservation=0B thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10,15,7,8,11 row-size=254B cardinality=8.45K
|  in pipelines: 00(GETNEXT)
|
F16:PLAN FRAGMENT [HASH(ss_cdemo_sk)] hosts=3 instances=3
Per-Host Resources: mem-estimate=28.48MB mem-reservation=17.00MB thread-reservation=1
31:HASH JOIN [INNER JOIN, PARTITIONED]
|  hash predicates: ss_cdemo_sk = cd1.cd_demo_sk
|  fk/pk conjuncts: ss_cdemo_sk = cd1.cd_demo_sk
|  mem-estimate=17.00MB mem-reservation=17.00MB spill-buffer=1.00MB thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10,15,7,8,11 row-size=254B cardinality=8.45K
|  in pipelines: 00(GETNEXT), 11(OPEN)
|
|--95:EXCHANGE [HASH(cd1.cd_demo_sk)]
|  |  mem-estimate=10.02MB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=11 row-size=17B cardinality=1.92M
|  |  in pipelines: 11(GETNEXT)
|  |
|  F15:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Host Resources: mem-estimate=32.00MB mem-reservation=8.00MB thread-reservation=2
|  11:SCAN HDFS [tpcds_parquet.customer_demographics cd1, RANDOM]
|     HDFS partitions=1/1 files=1 size=7.49MB
|     stored statistics:
|       table: rows=1.92M size=7.49MB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=1.92M
|     mem-estimate=32.00MB mem-reservation=8.00MB thread-reservation=1
|     tuple-ids=11 row-size=17B cardinality=1.92M
|     in pipelines: 11(GETNEXT)
|
94:EXCHANGE [HASH(ss_cdemo_sk)]
|  mem-estimate=1.46MB mem-reservation=0B thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10,15,7,8 row-size=237B cardinality=8.45K
|  in pipelines: 00(GETNEXT)
|
F14:PLAN FRAGMENT [HASH(c_first_shipto_date_sk)] hosts=3 instances=3
Per-Host Resources: mem-estimate=3.91MB mem-reservation=1.94MB thread-reservation=1
30:HASH JOIN [INNER JOIN, PARTITIONED]
|  hash predicates: c_first_shipto_date_sk = d3.d_date_sk
|  fk/pk conjuncts: c_first_shipto_date_sk = d3.d_date_sk
|  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10,15,7,8 row-size=237B cardinality=8.45K
|  in pipelines: 00(GETNEXT), 08(OPEN)
|
|--93:EXCHANGE [HASH(d3.d_date_sk)]
|  |  mem-estimate=582.70KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=8 row-size=8B cardinality=73.05K
|  |  in pipelines: 08(GETNEXT)
|  |
|  F13:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Host Resources: mem-estimate=32.00MB mem-reservation=512.00KB thread-reservation=2
|  08:SCAN HDFS [tpcds_parquet.date_dim d3, RANDOM]
|     HDFS partitions=1/1 files=1 size=2.15MB
|     stored statistics:
|       table: rows=73.05K size=2.15MB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=73.05K
|     mem-estimate=32.00MB mem-reservation=512.00KB thread-reservation=1
|     tuple-ids=8 row-size=8B cardinality=73.05K
|     in pipelines: 08(GETNEXT)
|
92:EXCHANGE [HASH(c_first_shipto_date_sk)]
|  mem-estimate=1.40MB mem-reservation=0B thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10,15,7 row-size=229B cardinality=8.45K
|  in pipelines: 00(GETNEXT)
|
F12:PLAN FRAGMENT [HASH(c_first_sales_date_sk)] hosts=3 instances=3
Per-Host Resources: mem-estimate=3.85MB mem-reservation=1.94MB thread-reservation=1
29:HASH JOIN [INNER JOIN, PARTITIONED]
|  hash predicates: c_first_sales_date_sk = d2.d_date_sk
|  fk/pk conjuncts: c_first_sales_date_sk = d2.d_date_sk
|  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10,15,7 row-size=229B cardinality=8.45K
|  in pipelines: 00(GETNEXT), 07(OPEN)
|
|--91:EXCHANGE [HASH(d2.d_date_sk)]
|  |  mem-estimate=582.70KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=7 row-size=8B cardinality=73.05K
|  |  in pipelines: 07(GETNEXT)
|  |
|  F11:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Host Resources: mem-estimate=32.00MB mem-reservation=512.00KB thread-reservation=2
|  07:SCAN HDFS [tpcds_parquet.date_dim d2, RANDOM]
|     HDFS partitions=1/1 files=1 size=2.15MB
|     stored statistics:
|       table: rows=73.05K size=2.15MB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=73.05K
|     mem-estimate=32.00MB mem-reservation=512.00KB thread-reservation=1
|     tuple-ids=7 row-size=8B cardinality=73.05K
|     in pipelines: 07(GETNEXT)
|
90:EXCHANGE [HASH(c_first_sales_date_sk)]
|  mem-estimate=1.35MB mem-reservation=0B thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10,15 row-size=221B cardinality=8.45K
|  in pipelines: 00(GETNEXT)
|
F09:PLAN FRAGMENT [HASH(ss_customer_sk)] hosts=3 instances=3
Per-Host Resources: mem-estimate=7.41MB mem-reservation=3.88MB thread-reservation=1
28:HASH JOIN [INNER JOIN, BROADCAST]
|  hash predicates: c_current_hdemo_sk = hd2.hd_demo_sk
|  fk/pk conjuncts: c_current_hdemo_sk = hd2.hd_demo_sk
|  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10,15 row-size=221B cardinality=8.45K
|  in pipelines: 00(GETNEXT), 15(OPEN)
|
|--89:EXCHANGE [BROADCAST]
|  |  mem-estimate=68.25KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=15 row-size=8B cardinality=7.20K
|  |  in pipelines: 15(GETNEXT)
|  |
|  F10:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Host Resources: mem-estimate=32.00MB mem-reservation=64.00KB thread-reservation=2
|  15:SCAN HDFS [tpcds_parquet.household_demographics hd2, RANDOM]
|     HDFS partitions=1/1 files=1 size=41.69KB
|     stored statistics:
|       table: rows=7.20K size=41.69KB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=7.20K
|     mem-estimate=32.00MB mem-reservation=64.00KB thread-reservation=1
|     tuple-ids=15 row-size=8B cardinality=7.20K
|     in pipelines: 15(GETNEXT)
|
27:HASH JOIN [INNER JOIN, PARTITIONED]
|  hash predicates: ss_customer_sk = c_customer_sk
|  fk/pk conjuncts: ss_customer_sk = c_customer_sk
|  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10 row-size=213B cardinality=8.66K
|  in pipelines: 00(GETNEXT), 10(OPEN)
|
|--88:EXCHANGE [HASH(c_customer_sk)]
|  |  mem-estimate=2.32MB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=10 row-size=24B cardinality=100.00K
|  |  in pipelines: 10(GETNEXT)
|  |
|  F08:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Host Resources: mem-estimate=96.00MB mem-reservation=2.00MB thread-reservation=2
|  10:SCAN HDFS [tpcds_parquet.customer, RANDOM]
|     HDFS partitions=1/1 files=1 size=5.49MB
|     stored statistics:
|       table: rows=100.00K size=5.49MB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=100.00K
|     mem-estimate=96.00MB mem-reservation=2.00MB thread-reservation=1
|     tuple-ids=10 row-size=24B cardinality=100.00K
|     in pipelines: 10(GETNEXT)
|
87:EXCHANGE [HASH(ss_customer_sk)]
|  mem-estimate=1.15MB mem-reservation=0B thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9 row-size=189B cardinality=8.66K
|  in pipelines: 00(GETNEXT)
|
F04:PLAN FRAGMENT [HASH(ss_item_sk,ss_ticket_number)] hosts=3 instances=3
Per-Host Resources: mem-estimate=16.07MB mem-reservation=10.69MB thread-reservation=1 runtime-filters-memory=2.00MB
26:HASH JOIN [INNER JOIN, BROADCAST]
|  hash predicates: ss_store_sk = s_store_sk
|  fk/pk conjuncts: ss_store_sk = s_store_sk
|  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9 row-size=189B cardinality=8.66K
|  in pipelines: 00(GETNEXT), 09(OPEN)
|
|--86:EXCHANGE [BROADCAST]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=9 row-size=37B cardinality=12
|  |  in pipelines: 09(GETNEXT)
|  |
|  F07:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Host Resources: mem-estimate=48.00MB mem-reservation=24.00KB thread-reservation=2
|  09:SCAN HDFS [tpcds_parquet.store, RANDOM]
|     HDFS partitions=1/1 files=1 size=9.93KB
|     stored statistics:
|       table: rows=12 size=9.93KB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=12
|     mem-estimate=48.00MB mem-reservation=24.00KB thread-reservation=1
|     tuple-ids=9 row-size=37B cardinality=12
|     in pipelines: 09(GETNEXT)
|
25:HASH JOIN [INNER JOIN, BROADCAST]
|  hash predicates: ss_promo_sk = p_promo_sk
|  fk/pk conjuncts: ss_promo_sk = p_promo_sk
|  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=0,20,6,1,14,13 row-size=151B cardinality=8.66K
|  in pipelines: 00(GETNEXT), 13(OPEN)
|
|--85:EXCHANGE [BROADCAST]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=13 row-size=4B cardinality=300
|  |  in pipelines: 13(GETNEXT)
|  |
|  F06:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Host Resources: mem-estimate=16.00MB mem-reservation=32.00KB thread-reservation=2
|  13:SCAN HDFS [tpcds_parquet.promotion, RANDOM]
|     HDFS partitions=1/1 files=1 size=23.30KB
|     stored statistics:
|       table: rows=300 size=23.30KB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=300
|     mem-estimate=16.00MB mem-reservation=32.00KB thread-reservation=1
|     tuple-ids=13 row-size=4B cardinality=300
|     in pipelines: 13(GETNEXT)
|
24:HASH JOIN [INNER JOIN, BROADCAST]
|  hash predicates: ss_hdemo_sk = hd1.hd_demo_sk
|  fk/pk conjuncts: ss_hdemo_sk = hd1.hd_demo_sk
|  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=0,20,6,1,14 row-size=147B cardinality=8.72K
|  in pipelines: 00(GETNEXT), 14(OPEN)
|
|--84:EXCHANGE [BROADCAST]
|  |  mem-estimate=68.25KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=14 row-size=8B cardinality=7.20K
|  |  in pipelines: 14(GETNEXT)
|  |
|  F05:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Host Resources: mem-estimate=32.00MB mem-reservation=64.00KB thread-reservation=2
|  14:SCAN HDFS [tpcds_parquet.household_demographics hd1, RANDOM]
|     HDFS partitions=1/1 files=1 size=41.69KB
|     stored statistics:
|       table: rows=7.20K size=41.69KB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=7.20K
|     mem-estimate=32.00MB mem-reservation=64.00KB thread-reservation=1
|     tuple-ids=14 row-size=8B cardinality=7.20K
|     in pipelines: 14(GETNEXT)
|
23:HASH JOIN [INNER JOIN, PARTITIONED]
|  hash predicates: ss_item_sk = sr_item_sk, ss_ticket_number = sr_ticket_number
|  fk/pk conjuncts: ss_item_sk = sr_item_sk, ss_ticket_number = sr_ticket_number
|  runtime filters: RF034[bloom] <- sr_item_sk, RF035[bloom] <- sr_ticket_number
|  mem-estimate=2.88MB mem-reservation=2.88MB spill-buffer=128.00KB thread-reservation=0
|  tuple-ids=0,20,6,1 row-size=139B cardinality=8.93K
|  in pipelines: 00(GETNEXT), 01(OPEN)
|
|--83:EXCHANGE [HASH(sr_item_sk,sr_ticket_number)]
|  |  mem-estimate=4.41MB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=1 row-size=16B cardinality=287.51K
|  |  in pipelines: 01(GETNEXT)
|  |
|  F03:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Host Resources: mem-estimate=48.00MB mem-reservation=4.00MB thread-reservation=2
|  01:SCAN HDFS [tpcds_parquet.store_returns, RANDOM]
|     HDFS partitions=1/1 files=1 size=15.43MB
|     stored statistics:
|       table: rows=287.51K size=15.43MB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=287.51K
|     mem-estimate=48.00MB mem-reservation=4.00MB thread-reservation=1
|     tuple-ids=1 row-size=16B cardinality=287.51K
|     in pipelines: 01(GETNEXT)
|
82:EXCHANGE [HASH(ss_item_sk,ss_ticket_number)]
|  mem-estimate=894.08KB mem-reservation=0B thread-reservation=0
|  tuple-ids=0,20,6 row-size=123B cardinality=12.14K
|  in pipelines: 00(GETNEXT)
|
F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
Per-Host Resources: mem-estimate=135.93MB mem-reservation=15.88MB thread-reservation=2 runtime-filters-memory=4.00MB
22:HASH JOIN [INNER JOIN, BROADCAST]
|  hash predicates: ss_sold_date_sk = d1.d_date_sk
|  fk/pk conjuncts: ss_sold_date_sk = d1.d_date_sk
|  runtime filters: RF038[bloom] <- d1.d_date_sk
|  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=0,20,6 row-size=123B cardinality=12.14K
|  in pipelines: 00(GETNEXT), 06(OPEN)
|
|--81:EXCHANGE [BROADCAST]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=6 row-size=8B cardinality=373
|  |  in pipelines: 06(GETNEXT)
|  |
|  F02:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Host Resources: mem-estimate=32.00MB mem-reservation=512.00KB thread-reservation=2
|  06:SCAN HDFS [tpcds_parquet.date_dim d1, RANDOM]
|     HDFS partitions=1/1 files=1 size=2.15MB
|     predicates: d1.d_year = CAST(1999 AS INT)
|     stored statistics:
|       table: rows=73.05K size=2.15MB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=73.05K
|     parquet statistics predicates: d1.d_year = CAST(1999 AS INT)
|     parquet dictionary predicates: d1.d_year = CAST(1999 AS INT)
|     mem-estimate=32.00MB mem-reservation=512.00KB thread-reservation=1
|     tuple-ids=6 row-size=8B cardinality=373
|     in pipelines: 06(GETNEXT)
|
21:HASH JOIN [INNER JOIN, BROADCAST]
|  hash predicates: ss_item_sk = i_item_sk
|  fk/pk conjuncts: ss_item_sk = i_item_sk
|  runtime filters: RF040[bloom] <- i_item_sk
|  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=0,20 row-size=115B cardinality=59.37K
|  in pipelines: 00(GETNEXT), 20(OPEN)
|
|--80:EXCHANGE [BROADCAST]
|  |  mem-estimate=44.51KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=20 row-size=59B cardinality=371
|  |  in pipelines: 20(GETNEXT)
|  |
|  F01:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Host Resources: mem-estimate=65.00MB mem-reservation=1.50MB thread-reservation=2 runtime-filters-memory=1.00MB
|  20:SCAN HDFS [tpcds_parquet.item, RANDOM]
|     HDFS partitions=1/1 files=1 size=1.73MB
|     predicates: i_color IN ('purple', 'burlywood', 'indian', 'spring', 'floral', 'medium'), i_current_price <= CAST(74 AS DECIMAL(3,0)), i_current_price <= CAST(79 AS DECIMAL(3,0)), i_current_price >= CAST(64 AS DECIMAL(3,0)), i_current_price >= CAST(65 AS DECIMAL(3,0))
|     runtime filters: RF034[bloom] -> tpcds_parquet.item.i_item_sk
|     stored statistics:
|       table: rows=18.00K size=1.73MB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=18.00K
|     parquet statistics predicates: i_color IN ('purple', 'burlywood', 'indian', 'spring', 'floral', 'medium'), i_current_price <= CAST(74 AS DECIMAL(3,0)), i_current_price <= CAST(79 AS DECIMAL(3,0)), i_current_price >= CAST(64 AS DECIMAL(3,0)), i_current_price >= CAST(65 AS DECIMAL(3,0))
|     parquet dictionary predicates: i_color IN ('purple', 'burlywood', 'indian', 'spring', 'floral', 'medium'), i_current_price <= CAST(74 AS DECIMAL(3,0)), i_current_price <= CAST(79 AS DECIMAL(3,0)), i_current_price >= CAST(64 AS DECIMAL(3,0)), i_current_price >= CAST(65 AS DECIMAL(3,0))
|     mem-estimate=64.00MB mem-reservation=512.00KB thread-reservation=1
|     tuple-ids=20 row-size=59B cardinality=371
|     in pipelines: 20(GETNEXT)
|
00:SCAN HDFS [tpcds_parquet.store_sales, RANDOM]
   HDFS partitions=1824/1824 files=1824 size=200.95MB
   runtime filters: RF040[bloom] -> ss_item_sk, RF038[bloom] -> ss_sold_date_sk, RF034[bloom] -> ss_item_sk, RF035[bloom] -> ss_ticket_number
   stored statistics:
     table: rows=2.88M size=200.95MB
     partitions: 1824/1824 rows=2.88M
     columns: all
   extrapolated-rows=disabled max-scan-range-rows=130.09K
   mem-estimate=128.00MB mem-reservation=8.00MB thread-reservation=1
   tuple-ids=0 row-size=56B cardinality=2.88M
   in pipelines: 00(GETNEXT)
---- PARALLELPLANS
Max Per-Host Resource Reservation: Memory=672.52MB Threads=135
Per-Host Resource Estimates: Memory=1.64GB
F59:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
|  Per-Instance Resources: mem-estimate=32.22MB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
|  output exprs: product_name, store_name, store_zip, b_street_number, b_street_name, b_city, b_zip, c_street_number, c_street_name, c_city, c_zip, syear, cnt, s1, s2, s3, s1, s2, s3, syear, cnt
|  mem-estimate=0B mem-reservation=0B thread-reservation=0
|
142:MERGING-EXCHANGE [UNPARTITIONED]
|  order by: product_name ASC, store_name ASC, cnt ASC, s1 ASC, s1 ASC
|  mem-estimate=32.22MB mem-reservation=0B thread-reservation=0
|  tuple-ids=46 row-size=330B cardinality=288.12K
|  in pipelines: 79(GETNEXT)
|
F58:PLAN FRAGMENT [HASH(i_item_sk,s_store_name,s_zip)] hosts=3 instances=6
Per-Instance Resources: mem-estimate=23.70MB mem-reservation=12.00MB thread-reservation=1
79:SORT
|  order by: product_name ASC, store_name ASC, cnt ASC, s1 ASC, s1 ASC
|  mem-estimate=12.00MB mem-reservation=12.00MB spill-buffer=2.00MB thread-reservation=0
|  tuple-ids=46 row-size=330B cardinality=288.12K
|  in pipelines: 79(GETNEXT), 109(OPEN)
|
78:HASH JOIN [INNER JOIN, PARTITIONED]
|  hash-table-id=00
|  hash predicates: i_item_sk = i_item_sk, s_store_name = s_store_name, s_zip = s_zip
|  fk/pk conjuncts: i_item_sk = i_item_sk, s_store_name = s_store_name, s_zip = s_zip
|  other predicates: count(*) <= count(*)
|  mem-estimate=0B mem-reservation=0B spill-buffer=1.00MB thread-reservation=0
|  tuple-ids=21,44 row-size=573B cardinality=288.12K
|  in pipelines: 109(GETNEXT), 139(OPEN)
|
|--F60:PLAN FRAGMENT [HASH(i_item_sk,s_store_name,s_zip)] hosts=3 instances=6
|  |  Per-Instance Resources: mem-estimate=28.70MB mem-reservation=17.00MB thread-reservation=1
|  JOIN BUILD
|  |  join-table-id=00 plan-id=01 cohort-id=01
|  |  build expressions: i_item_sk, s_store_name, s_zip
|  |  mem-estimate=17.00MB mem-reservation=17.00MB spill-buffer=1.00MB thread-reservation=0
|  |
|  141:EXCHANGE [HASH(i_item_sk,s_store_name,s_zip)]
|  |  mem-estimate=11.70MB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=44 row-size=286B cardinality=288.12K
|  |  in pipelines: 139(GETNEXT)
|  |
|  F57:PLAN FRAGMENT [HASH(i_product_name,i_item_sk,s_store_name,s_zip,ad1.ca_street_number,ad1.ca_street_name,ad1.ca_city,ad1.ca_zip,ad2.ca_street_number,ad2.ca_street_name,ad2.ca_city,ad2.ca_zip,d1.d_year,d2.d_year,d3.d_year)] hosts=3 instances=6
|  Per-Instance Resources: mem-estimate=45.70MB mem-reservation=34.00MB thread-reservation=1
|  139:AGGREGATE [FINALIZE]
|  |  output: count:merge(*), sum:merge(ss_wholesale_cost), sum:merge(ss_list_price), sum:merge(ss_coupon_amt)
|  |  group by: i_product_name, i_item_sk, s_store_name, s_zip, ad1.ca_street_number, ad1.ca_street_name, ad1.ca_city, ad1.ca_zip, ad2.ca_street_number, ad2.ca_street_name, ad2.ca_city, ad2.ca_zip, d1.d_year, d2.d_year, d3.d_year
|  |  mem-estimate=34.00MB mem-reservation=34.00MB spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=44 row-size=286B cardinality=288.12K
|  |  in pipelines: 139(GETNEXT), 39(OPEN)
|  |
|  138:EXCHANGE [HASH(i_product_name,i_item_sk,s_store_name,s_zip,ad1.ca_street_number,ad1.ca_street_name,ad1.ca_city,ad1.ca_zip,ad2.ca_street_number,ad2.ca_street_name,ad2.ca_city,ad2.ca_zip,d1.d_year,d2.d_year,d3.d_year)]
|  |  mem-estimate=11.70MB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=44 row-size=286B cardinality=288.12K
|  |  in pipelines: 39(GETNEXT)
|  |
|  F51:PLAN FRAGMENT [HASH(c_current_addr_sk)] hosts=3 instances=6
|  Per-Instance Resources: mem-estimate=37.30MB mem-reservation=34.00MB thread-reservation=1
|  77:AGGREGATE [STREAMING]
|  |  output: count(*), sum(ss_wholesale_cost), sum(ss_list_price), sum(ss_coupon_amt)
|  |  group by: i_product_name, i_item_sk, s_store_name, s_zip, ad1.ca_street_number, ad1.ca_street_name, ad1.ca_city, ad1.ca_zip, ad2.ca_street_number, ad2.ca_street_name, ad2.ca_city, ad2.ca_zip, d1.d_year, d2.d_year, d3.d_year
|  |  mem-estimate=34.00MB mem-reservation=34.00MB spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=44 row-size=286B cardinality=288.12K
|  |  in pipelines: 39(GETNEXT)
|  |
|  76:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash-table-id=01
|  |  hash predicates: ss_item_sk = cs_item_sk
|  |  fk/pk conjuncts: none
|  |  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33,38,30,31,34,35,39,40,41,42,27 row-size=474B cardinality=288.12K
|  |  in pipelines: 39(GETNEXT), 136(OPEN)
|  |
|  |--F61:PLAN FRAGMENT [HASH(c_current_addr_sk)] hosts=3 instances=3
|  |  |  Per-Instance Resources: mem-estimate=4.07MB mem-reservation=3.88MB thread-reservation=1
|  |  JOIN BUILD
|  |  |  join-table-id=01 plan-id=02 cohort-id=02
|  |  |  build expressions: cs_item_sk
|  |  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  137:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=202.23KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=27 row-size=40B cardinality=1.80K
|  |  |  in pipelines: 136(GETNEXT)
|  |  |
|  |  F56:PLAN FRAGMENT [HASH(cs_item_sk)] hosts=3 instances=3
|  |  Per-Instance Resources: mem-estimate=10.36MB mem-reservation=1.94MB thread-reservation=1
|  |  136:AGGREGATE [FINALIZE]
|  |  |  output: sum:merge(cs_ext_list_price), sum:merge(cr_refunded_cash + cr_reversed_charge + cr_store_credit)
|  |  |  group by: cs_item_sk
|  |  |  having: sum(cs_ext_list_price) > CAST(2 AS DECIMAL(3,0)) * sum(cr_refunded_cash + cr_reversed_charge + cr_store_credit)
|  |  |  mem-estimate=10.00MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  |  tuple-ids=27 row-size=40B cardinality=1.80K
|  |  |  in pipelines: 136(GETNEXT), 41(OPEN)
|  |  |
|  |  135:EXCHANGE [HASH(cs_item_sk)]
|  |  |  mem-estimate=366.05KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=27 row-size=40B cardinality=17.98K
|  |  |  in pipelines: 41(GETNEXT)
|  |  |
|  |  F54:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  |  Per-Host Shared Resources: mem-estimate=2.00MB mem-reservation=2.00MB thread-reservation=0 runtime-filters-memory=2.00MB
|  |  Per-Instance Resources: mem-estimate=58.00MB mem-reservation=10.00MB thread-reservation=1
|  |  44:AGGREGATE [STREAMING]
|  |  |  output: sum(cs_ext_list_price), sum(cr_refunded_cash + cr_reversed_charge + cr_store_credit)
|  |  |  group by: cs_item_sk
|  |  |  mem-estimate=10.00MB mem-reservation=2.00MB spill-buffer=64.00KB thread-reservation=0
|  |  |  tuple-ids=27 row-size=40B cardinality=17.98K
|  |  |  in pipelines: 41(GETNEXT)
|  |  |
|  |  43:HASH JOIN [INNER JOIN, BROADCAST]
|  |  |  hash-table-id=02
|  |  |  hash predicates: cs_item_sk = cr_item_sk, cs_order_number = cr_order_number
|  |  |  fk/pk conjuncts: cs_item_sk = cr_item_sk, cs_order_number = cr_order_number
|  |  |  mem-estimate=0B mem-reservation=0B spill-buffer=256.00KB thread-reservation=0
|  |  |  tuple-ids=25,26 row-size=48B cardinality=849.41K
|  |  |  in pipelines: 41(GETNEXT), 42(OPEN)
|  |  |
|  |  |--F62:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  |  |  |  Per-Instance Resources: mem-estimate=15.38MB mem-reservation=11.50MB thread-reservation=1 runtime-filters-memory=2.00MB
|  |  |  JOIN BUILD
|  |  |  |  join-table-id=02 plan-id=03 cohort-id=03
|  |  |  |  build expressions: cr_item_sk, cr_order_number
|  |  |  |  runtime filters: RF082[bloom] <- cr_item_sk, RF083[bloom] <- cr_order_number
|  |  |  |  mem-estimate=9.50MB mem-reservation=9.50MB spill-buffer=256.00KB thread-reservation=0
|  |  |  |
|  |  |  134:EXCHANGE [BROADCAST]
|  |  |  |  mem-estimate=3.88MB mem-reservation=0B thread-reservation=0
|  |  |  |  tuple-ids=26 row-size=28B cardinality=144.07K
|  |  |  |  in pipelines: 42(GETNEXT)
|  |  |  |
|  |  |  F55:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  |  Per-Instance Resources: mem-estimate=24.00MB mem-reservation=4.00MB thread-reservation=1
|  |  |  42:SCAN HDFS [tpcds_parquet.catalog_returns, RANDOM]
|  |  |     HDFS partitions=1/1 files=1 size=10.62MB
|  |  |     stored statistics:
|  |  |       table: rows=144.07K size=10.62MB
|  |  |       columns: all
|  |  |     extrapolated-rows=disabled max-scan-range-rows=144.07K
|  |  |     mem-estimate=24.00MB mem-reservation=4.00MB thread-reservation=0
|  |  |     tuple-ids=26 row-size=28B cardinality=144.07K
|  |  |     in pipelines: 42(GETNEXT)
|  |  |
|  |  41:SCAN HDFS [tpcds_parquet.catalog_sales, RANDOM]
|  |     HDFS partitions=1/1 files=3 size=96.62MB
|  |     runtime filters: RF082[bloom] -> cs_item_sk, RF083[bloom] -> cs_order_number
|  |     stored statistics:
|  |       table: rows=1.44M size=96.62MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=650.14K
|  |     mem-estimate=48.00MB mem-reservation=8.00MB thread-reservation=0
|  |     tuple-ids=25 row-size=20B cardinality=1.44M
|  |     in pipelines: 41(GETNEXT)
|  |
|  75:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash-table-id=03
|  |  hash predicates: hd2.hd_income_band_sk = ib2.ib_income_band_sk
|  |  fk/pk conjuncts: hd2.hd_income_band_sk = ib2.ib_income_band_sk
|  |  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33,38,30,31,34,35,39,40,41,42 row-size=434B cardinality=8.45K
|  |  in pipelines: 39(GETNEXT), 58(OPEN)
|  |
|  |--F63:PLAN FRAGMENT [HASH(c_current_addr_sk)] hosts=3 instances=3
|  |  |  Per-Instance Resources: mem-estimate=3.89MB mem-reservation=3.88MB thread-reservation=1
|  |  JOIN BUILD
|  |  |  join-table-id=03 plan-id=04 cohort-id=02
|  |  |  build expressions: ib2.ib_income_band_sk
|  |  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  133:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=42 row-size=4B cardinality=20
|  |  |  in pipelines: 58(GETNEXT)
|  |  |
|  |  F53:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=8.00KB thread-reservation=1
|  |  58:SCAN HDFS [tpcds_parquet.income_band ib2, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=1.21KB
|  |     stored statistics:
|  |       table: rows=20 size=1.21KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=20
|  |     mem-estimate=16.00MB mem-reservation=8.00KB thread-reservation=0
|  |     tuple-ids=42 row-size=4B cardinality=20
|  |     in pipelines: 58(GETNEXT)
|  |
|  74:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash-table-id=04
|  |  hash predicates: hd1.hd_income_band_sk = ib1.ib_income_band_sk
|  |  fk/pk conjuncts: hd1.hd_income_band_sk = ib1.ib_income_band_sk
|  |  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33,38,30,31,34,35,39,40,41 row-size=430B cardinality=8.45K
|  |  in pipelines: 39(GETNEXT), 57(OPEN)
|  |
|  |--F64:PLAN FRAGMENT [HASH(c_current_addr_sk)] hosts=3 instances=3
|  |  |  Per-Instance Resources: mem-estimate=3.89MB mem-reservation=3.88MB thread-reservation=1
|  |  JOIN BUILD
|  |  |  join-table-id=04 plan-id=05 cohort-id=02
|  |  |  build expressions: ib1.ib_income_band_sk
|  |  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  132:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=41 row-size=4B cardinality=20
|  |  |  in pipelines: 57(GETNEXT)
|  |  |
|  |  F52:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=8.00KB thread-reservation=1
|  |  57:SCAN HDFS [tpcds_parquet.income_band ib1, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=1.21KB
|  |     stored statistics:
|  |       table: rows=20 size=1.21KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=20
|  |     mem-estimate=16.00MB mem-reservation=8.00KB thread-reservation=0
|  |     tuple-ids=41 row-size=4B cardinality=20
|  |     in pipelines: 57(GETNEXT)
|  |
|  73:HASH JOIN [INNER JOIN, PARTITIONED]
|  |  hash-table-id=05
|  |  hash predicates: c_current_addr_sk = ad2.ca_address_sk
|  |  fk/pk conjuncts: c_current_addr_sk = ad2.ca_address_sk
|  |  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33,38,30,31,34,35,39,40 row-size=426B cardinality=8.45K
|  |  in pipelines: 39(GETNEXT), 56(OPEN)
|  |
|  |--F65:PLAN FRAGMENT [HASH(c_current_addr_sk)] hosts=3 instances=6
|  |  |  Per-Instance Resources: mem-estimate=5.71MB mem-reservation=1.94MB thread-reservation=1
|  |  JOIN BUILD
|  |  |  join-table-id=05 plan-id=06 cohort-id=02
|  |  |  build expressions: ad2.ca_address_sk
|  |  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  131:EXCHANGE [HASH(ad2.ca_address_sk)]
|  |  |  mem-estimate=3.78MB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=40 row-size=78B cardinality=50.00K
|  |  |  in pipelines: 56(GETNEXT)
|  |  |
|  |  F50:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=1.00MB thread-reservation=1
|  |  56:SCAN HDFS [tpcds_parquet.customer_address ad2, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=1.16MB
|  |     stored statistics:
|  |       table: rows=50.00K size=1.16MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=50.00K
|  |     mem-estimate=16.00MB mem-reservation=1.00MB thread-reservation=0
|  |     tuple-ids=40 row-size=78B cardinality=50.00K
|  |     in pipelines: 56(GETNEXT)
|  |
|  130:EXCHANGE [HASH(c_current_addr_sk)]
|  |  mem-estimate=3.30MB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33,38,30,31,34,35,39 row-size=348B cardinality=8.45K
|  |  in pipelines: 39(GETNEXT)
|  |
|  F49:PLAN FRAGMENT [HASH(ss_addr_sk)] hosts=3 instances=6
|  Per-Instance Resources: mem-estimate=2.62MB mem-reservation=0B thread-reservation=1
|  72:HASH JOIN [INNER JOIN, PARTITIONED]
|  |  hash-table-id=06
|  |  hash predicates: ss_addr_sk = ad1.ca_address_sk
|  |  fk/pk conjuncts: ss_addr_sk = ad1.ca_address_sk
|  |  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33,38,30,31,34,35,39 row-size=348B cardinality=8.45K
|  |  in pipelines: 39(GETNEXT), 55(OPEN)
|  |
|  |--F66:PLAN FRAGMENT [HASH(ss_addr_sk)] hosts=3 instances=6
|  |  |  Per-Instance Resources: mem-estimate=5.71MB mem-reservation=1.94MB thread-reservation=1
|  |  JOIN BUILD
|  |  |  join-table-id=06 plan-id=07 cohort-id=02
|  |  |  build expressions: ad1.ca_address_sk
|  |  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  129:EXCHANGE [HASH(ad1.ca_address_sk)]
|  |  |  mem-estimate=3.78MB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=39 row-size=78B cardinality=50.00K
|  |  |  in pipelines: 55(GETNEXT)
|  |  |
|  |  F48:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=1.00MB thread-reservation=1
|  |  55:SCAN HDFS [tpcds_parquet.customer_address ad1, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=1.16MB
|  |     stored statistics:
|  |       table: rows=50.00K size=1.16MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=50.00K
|  |     mem-estimate=16.00MB mem-reservation=1.00MB thread-reservation=0
|  |     tuple-ids=39 row-size=78B cardinality=50.00K
|  |     in pipelines: 55(GETNEXT)
|  |
|  128:EXCHANGE [HASH(ss_addr_sk)]
|  |  mem-estimate=2.62MB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33,38,30,31,34,35 row-size=271B cardinality=8.45K
|  |  in pipelines: 39(GETNEXT)
|  |
|  F47:PLAN FRAGMENT [HASH(c_current_cdemo_sk)] hosts=3 instances=6
|  Per-Instance Resources: mem-estimate=2.45MB mem-reservation=0B thread-reservation=1
|  71:HASH JOIN [INNER JOIN, PARTITIONED]
|  |  hash-table-id=07
|  |  hash predicates: c_current_cdemo_sk = cd2.cd_demo_sk
|  |  fk/pk conjuncts: c_current_cdemo_sk = cd2.cd_demo_sk
|  |  other predicates: cd1.cd_marital_status != cd2.cd_marital_status
|  |  mem-estimate=0B mem-reservation=0B spill-buffer=512.00KB thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33,38,30,31,34,35 row-size=271B cardinality=8.45K
|  |  in pipelines: 39(GETNEXT), 51(OPEN)
|  |
|  |--F67:PLAN FRAGMENT [HASH(c_current_cdemo_sk)] hosts=3 instances=6
|  |  |  Per-Instance Resources: mem-estimate=18.52MB mem-reservation=8.50MB thread-reservation=1
|  |  JOIN BUILD
|  |  |  join-table-id=07 plan-id=08 cohort-id=02
|  |  |  build expressions: cd2.cd_demo_sk
|  |  |  mem-estimate=8.50MB mem-reservation=8.50MB spill-buffer=512.00KB thread-reservation=0
|  |  |
|  |  127:EXCHANGE [HASH(cd2.cd_demo_sk)]
|  |  |  mem-estimate=10.02MB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=35 row-size=17B cardinality=1.92M
|  |  |  in pipelines: 51(GETNEXT)
|  |  |
|  |  F46:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=8.00MB thread-reservation=1
|  |  51:SCAN HDFS [tpcds_parquet.customer_demographics cd2, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=7.49MB
|  |     stored statistics:
|  |       table: rows=1.92M size=7.49MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=1.92M
|  |     mem-estimate=16.00MB mem-reservation=8.00MB thread-reservation=0
|  |     tuple-ids=35 row-size=17B cardinality=1.92M
|  |     in pipelines: 51(GETNEXT)
|  |
|  126:EXCHANGE [HASH(c_current_cdemo_sk)]
|  |  mem-estimate=2.45MB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33,38,30,31,34 row-size=254B cardinality=8.45K
|  |  in pipelines: 39(GETNEXT)
|  |
|  F45:PLAN FRAGMENT [HASH(ss_cdemo_sk)] hosts=3 instances=6
|  Per-Instance Resources: mem-estimate=2.28MB mem-reservation=0B thread-reservation=1
|  70:HASH JOIN [INNER JOIN, PARTITIONED]
|  |  hash-table-id=08
|  |  hash predicates: ss_cdemo_sk = cd1.cd_demo_sk
|  |  fk/pk conjuncts: ss_cdemo_sk = cd1.cd_demo_sk
|  |  mem-estimate=0B mem-reservation=0B spill-buffer=512.00KB thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33,38,30,31,34 row-size=254B cardinality=8.45K
|  |  in pipelines: 39(GETNEXT), 50(OPEN)
|  |
|  |--F68:PLAN FRAGMENT [HASH(ss_cdemo_sk)] hosts=3 instances=6
|  |  |  Per-Instance Resources: mem-estimate=18.52MB mem-reservation=8.50MB thread-reservation=1
|  |  JOIN BUILD
|  |  |  join-table-id=08 plan-id=09 cohort-id=02
|  |  |  build expressions: cd1.cd_demo_sk
|  |  |  mem-estimate=8.50MB mem-reservation=8.50MB spill-buffer=512.00KB thread-reservation=0
|  |  |
|  |  125:EXCHANGE [HASH(cd1.cd_demo_sk)]
|  |  |  mem-estimate=10.02MB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=34 row-size=17B cardinality=1.92M
|  |  |  in pipelines: 50(GETNEXT)
|  |  |
|  |  F44:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=8.00MB thread-reservation=1
|  |  50:SCAN HDFS [tpcds_parquet.customer_demographics cd1, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=7.49MB
|  |     stored statistics:
|  |       table: rows=1.92M size=7.49MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=1.92M
|  |     mem-estimate=16.00MB mem-reservation=8.00MB thread-reservation=0
|  |     tuple-ids=34 row-size=17B cardinality=1.92M
|  |     in pipelines: 50(GETNEXT)
|  |
|  124:EXCHANGE [HASH(ss_cdemo_sk)]
|  |  mem-estimate=2.28MB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33,38,30,31 row-size=237B cardinality=8.45K
|  |  in pipelines: 39(GETNEXT)
|  |
|  F43:PLAN FRAGMENT [HASH(c_first_shipto_date_sk)] hosts=3 instances=6
|  Per-Instance Resources: mem-estimate=2.19MB mem-reservation=0B thread-reservation=1
|  69:HASH JOIN [INNER JOIN, PARTITIONED]
|  |  hash-table-id=09
|  |  hash predicates: c_first_shipto_date_sk = d3.d_date_sk
|  |  fk/pk conjuncts: c_first_shipto_date_sk = d3.d_date_sk
|  |  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33,38,30,31 row-size=237B cardinality=8.45K
|  |  in pipelines: 39(GETNEXT), 47(OPEN)
|  |
|  |--F69:PLAN FRAGMENT [HASH(c_first_shipto_date_sk)] hosts=3 instances=6
|  |  |  Per-Instance Resources: mem-estimate=2.51MB mem-reservation=1.94MB thread-reservation=1
|  |  JOIN BUILD
|  |  |  join-table-id=09 plan-id=10 cohort-id=02
|  |  |  build expressions: d3.d_date_sk
|  |  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  123:EXCHANGE [HASH(d3.d_date_sk)]
|  |  |  mem-estimate=582.70KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=31 row-size=8B cardinality=73.05K
|  |  |  in pipelines: 47(GETNEXT)
|  |  |
|  |  F42:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=512.00KB thread-reservation=1
|  |  47:SCAN HDFS [tpcds_parquet.date_dim d3, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=2.15MB
|  |     stored statistics:
|  |       table: rows=73.05K size=2.15MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=73.05K
|  |     mem-estimate=16.00MB mem-reservation=512.00KB thread-reservation=0
|  |     tuple-ids=31 row-size=8B cardinality=73.05K
|  |     in pipelines: 47(GETNEXT)
|  |
|  122:EXCHANGE [HASH(c_first_shipto_date_sk)]
|  |  mem-estimate=2.19MB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33,38,30 row-size=229B cardinality=8.45K
|  |  in pipelines: 39(GETNEXT)
|  |
|  F41:PLAN FRAGMENT [HASH(c_first_sales_date_sk)] hosts=3 instances=6
|  Per-Instance Resources: mem-estimate=2.10MB mem-reservation=0B thread-reservation=1
|  68:HASH JOIN [INNER JOIN, PARTITIONED]
|  |  hash-table-id=10
|  |  hash predicates: c_first_sales_date_sk = d2.d_date_sk
|  |  fk/pk conjuncts: c_first_sales_date_sk = d2.d_date_sk
|  |  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33,38,30 row-size=229B cardinality=8.45K
|  |  in pipelines: 39(GETNEXT), 46(OPEN)
|  |
|  |--F70:PLAN FRAGMENT [HASH(c_first_sales_date_sk)] hosts=3 instances=6
|  |  |  Per-Instance Resources: mem-estimate=2.51MB mem-reservation=1.94MB thread-reservation=1
|  |  JOIN BUILD
|  |  |  join-table-id=10 plan-id=11 cohort-id=02
|  |  |  build expressions: d2.d_date_sk
|  |  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  121:EXCHANGE [HASH(d2.d_date_sk)]
|  |  |  mem-estimate=582.70KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=30 row-size=8B cardinality=73.05K
|  |  |  in pipelines: 46(GETNEXT)
|  |  |
|  |  F40:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=512.00KB thread-reservation=1
|  |  46:SCAN HDFS [tpcds_parquet.date_dim d2, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=2.15MB
|  |     stored statistics:
|  |       table: rows=73.05K size=2.15MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=73.05K
|  |     mem-estimate=16.00MB mem-reservation=512.00KB thread-reservation=0
|  |     tuple-ids=30 row-size=8B cardinality=73.05K
|  |     in pipelines: 46(GETNEXT)
|  |
|  120:EXCHANGE [HASH(c_first_sales_date_sk)]
|  |  mem-estimate=2.10MB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33,38 row-size=221B cardinality=8.45K
|  |  in pipelines: 39(GETNEXT)
|  |
|  F38:PLAN FRAGMENT [HASH(ss_customer_sk)] hosts=3 instances=6
|  Per-Instance Resources: mem-estimate=1.79MB mem-reservation=0B thread-reservation=1
|  67:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash-table-id=11
|  |  hash predicates: c_current_hdemo_sk = hd2.hd_demo_sk
|  |  fk/pk conjuncts: c_current_hdemo_sk = hd2.hd_demo_sk
|  |  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33,38 row-size=221B cardinality=8.45K
|  |  in pipelines: 39(GETNEXT), 54(OPEN)
|  |
|  |--F71:PLAN FRAGMENT [HASH(ss_customer_sk)] hosts=3 instances=3
|  |  |  Per-Instance Resources: mem-estimate=3.94MB mem-reservation=3.88MB thread-reservation=1
|  |  JOIN BUILD
|  |  |  join-table-id=11 plan-id=12 cohort-id=02
|  |  |  build expressions: hd2.hd_demo_sk
|  |  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  119:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=68.25KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=38 row-size=8B cardinality=7.20K
|  |  |  in pipelines: 54(GETNEXT)
|  |  |
|  |  F39:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=64.00KB thread-reservation=1
|  |  54:SCAN HDFS [tpcds_parquet.household_demographics hd2, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=41.69KB
|  |     stored statistics:
|  |       table: rows=7.20K size=41.69KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=7.20K
|  |     mem-estimate=16.00MB mem-reservation=64.00KB thread-reservation=0
|  |     tuple-ids=38 row-size=8B cardinality=7.20K
|  |     in pipelines: 54(GETNEXT)
|  |
|  66:HASH JOIN [INNER JOIN, PARTITIONED]
|  |  hash-table-id=12
|  |  hash predicates: ss_customer_sk = c_customer_sk
|  |  fk/pk conjuncts: ss_customer_sk = c_customer_sk
|  |  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32,33 row-size=213B cardinality=8.66K
|  |  in pipelines: 39(GETNEXT), 49(OPEN)
|  |
|  |--F72:PLAN FRAGMENT [HASH(ss_customer_sk)] hosts=3 instances=6
|  |  |  Per-Instance Resources: mem-estimate=4.25MB mem-reservation=1.94MB thread-reservation=1
|  |  JOIN BUILD
|  |  |  join-table-id=12 plan-id=13 cohort-id=02
|  |  |  build expressions: c_customer_sk
|  |  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  118:EXCHANGE [HASH(c_customer_sk)]
|  |  |  mem-estimate=2.32MB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=33 row-size=24B cardinality=100.00K
|  |  |  in pipelines: 49(GETNEXT)
|  |  |
|  |  F37:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=2.00MB thread-reservation=1
|  |  49:SCAN HDFS [tpcds_parquet.customer, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=5.49MB
|  |     stored statistics:
|  |       table: rows=100.00K size=5.49MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=100.00K
|  |     mem-estimate=16.00MB mem-reservation=2.00MB thread-reservation=0
|  |     tuple-ids=33 row-size=24B cardinality=100.00K
|  |     in pipelines: 49(GETNEXT)
|  |
|  117:EXCHANGE [HASH(ss_customer_sk)]
|  |  mem-estimate=1.79MB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32 row-size=189B cardinality=8.66K
|  |  in pipelines: 39(GETNEXT)
|  |
|  F33:PLAN FRAGMENT [HASH(ss_item_sk,ss_ticket_number)] hosts=3 instances=6
|  Per-Instance Resources: mem-estimate=1.27MB mem-reservation=0B thread-reservation=1
|  65:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash-table-id=13
|  |  hash predicates: ss_store_sk = s_store_sk
|  |  fk/pk conjuncts: ss_store_sk = s_store_sk
|  |  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36,32 row-size=189B cardinality=8.66K
|  |  in pipelines: 39(GETNEXT), 48(OPEN)
|  |
|  |--F73:PLAN FRAGMENT [HASH(ss_item_sk,ss_ticket_number)] hosts=3 instances=3
|  |  |  Per-Instance Resources: mem-estimate=3.89MB mem-reservation=3.88MB thread-reservation=1
|  |  JOIN BUILD
|  |  |  join-table-id=13 plan-id=14 cohort-id=02
|  |  |  build expressions: s_store_sk
|  |  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  116:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=32 row-size=37B cardinality=12
|  |  |  in pipelines: 48(GETNEXT)
|  |  |
|  |  F36:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=24.00KB thread-reservation=1
|  |  48:SCAN HDFS [tpcds_parquet.store, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=9.93KB
|  |     stored statistics:
|  |       table: rows=12 size=9.93KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=12
|  |     mem-estimate=16.00MB mem-reservation=24.00KB thread-reservation=0
|  |     tuple-ids=32 row-size=37B cardinality=12
|  |     in pipelines: 48(GETNEXT)
|  |
|  64:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash-table-id=14
|  |  hash predicates: ss_promo_sk = p_promo_sk
|  |  fk/pk conjuncts: ss_promo_sk = p_promo_sk
|  |  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=23,43,29,24,37,36 row-size=151B cardinality=8.66K
|  |  in pipelines: 39(GETNEXT), 52(OPEN)
|  |
|  |--F74:PLAN FRAGMENT [HASH(ss_item_sk,ss_ticket_number)] hosts=3 instances=3
|  |  |  Per-Instance Resources: mem-estimate=3.89MB mem-reservation=3.88MB thread-reservation=1
|  |  JOIN BUILD
|  |  |  join-table-id=14 plan-id=15 cohort-id=02
|  |  |  build expressions: p_promo_sk
|  |  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  115:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=36 row-size=4B cardinality=300
|  |  |  in pipelines: 52(GETNEXT)
|  |  |
|  |  F35:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=32.00KB thread-reservation=1
|  |  52:SCAN HDFS [tpcds_parquet.promotion, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=23.30KB
|  |     stored statistics:
|  |       table: rows=300 size=23.30KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=300
|  |     mem-estimate=16.00MB mem-reservation=32.00KB thread-reservation=0
|  |     tuple-ids=36 row-size=4B cardinality=300
|  |     in pipelines: 52(GETNEXT)
|  |
|  63:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash-table-id=15
|  |  hash predicates: ss_hdemo_sk = hd1.hd_demo_sk
|  |  fk/pk conjuncts: ss_hdemo_sk = hd1.hd_demo_sk
|  |  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=23,43,29,24,37 row-size=147B cardinality=8.72K
|  |  in pipelines: 39(GETNEXT), 53(OPEN)
|  |
|  |--F75:PLAN FRAGMENT [HASH(ss_item_sk,ss_ticket_number)] hosts=3 instances=3
|  |  |  Per-Instance Resources: mem-estimate=3.94MB mem-reservation=3.88MB thread-reservation=1
|  |  JOIN BUILD
|  |  |  join-table-id=15 plan-id=16 cohort-id=02
|  |  |  build expressions: hd1.hd_demo_sk
|  |  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  114:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=68.25KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=37 row-size=8B cardinality=7.20K
|  |  |  in pipelines: 53(GETNEXT)
|  |  |
|  |  F34:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=64.00KB thread-reservation=1
|  |  53:SCAN HDFS [tpcds_parquet.household_demographics hd1, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=41.69KB
|  |     stored statistics:
|  |       table: rows=7.20K size=41.69KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=7.20K
|  |     mem-estimate=16.00MB mem-reservation=64.00KB thread-reservation=0
|  |     tuple-ids=37 row-size=8B cardinality=7.20K
|  |     in pipelines: 53(GETNEXT)
|  |
|  62:HASH JOIN [INNER JOIN, PARTITIONED]
|  |  hash-table-id=16
|  |  hash predicates: ss_item_sk = sr_item_sk, ss_ticket_number = sr_ticket_number
|  |  fk/pk conjuncts: ss_item_sk = sr_item_sk, ss_ticket_number = sr_ticket_number
|  |  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=23,43,29,24 row-size=139B cardinality=8.93K
|  |  in pipelines: 39(GETNEXT), 40(OPEN)
|  |
|  |--F76:PLAN FRAGMENT [HASH(ss_item_sk,ss_ticket_number)] hosts=3 instances=6
|  |  |  Per-Instance Resources: mem-estimate=6.34MB mem-reservation=1.94MB thread-reservation=1
|  |  JOIN BUILD
|  |  |  join-table-id=16 plan-id=17 cohort-id=02
|  |  |  build expressions: sr_item_sk, sr_ticket_number
|  |  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  113:EXCHANGE [HASH(sr_item_sk,sr_ticket_number)]
|  |  |  mem-estimate=4.41MB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=24 row-size=16B cardinality=287.51K
|  |  |  in pipelines: 40(GETNEXT)
|  |  |
|  |  F32:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=24.00MB mem-reservation=4.00MB thread-reservation=1
|  |  40:SCAN HDFS [tpcds_parquet.store_returns, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=15.43MB
|  |     stored statistics:
|  |       table: rows=287.51K size=15.43MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=287.51K
|  |     mem-estimate=24.00MB mem-reservation=4.00MB thread-reservation=0
|  |     tuple-ids=24 row-size=16B cardinality=287.51K
|  |     in pipelines: 40(GETNEXT)
|  |
|  112:EXCHANGE [HASH(ss_item_sk,ss_ticket_number)]
|  |  mem-estimate=1.27MB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=23,43,29 row-size=123B cardinality=12.14K
|  |  in pipelines: 39(GETNEXT)
|  |
|  F29:PLAN FRAGMENT [RANDOM] hosts=3 instances=6
|  Per-Host Shared Resources: mem-estimate=2.00MB mem-reservation=2.00MB thread-reservation=0 runtime-filters-memory=2.00MB
|  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=8.00MB thread-reservation=1
|  61:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash-table-id=17
|  |  hash predicates: ss_sold_date_sk = d1.d_date_sk
|  |  fk/pk conjuncts: ss_sold_date_sk = d1.d_date_sk
|  |  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=23,43,29 row-size=123B cardinality=12.14K
|  |  in pipelines: 39(GETNEXT), 45(OPEN)
|  |
|  |--F77:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  |  |  Per-Instance Resources: mem-estimate=4.89MB mem-reservation=4.88MB thread-reservation=1 runtime-filters-memory=1.00MB
|  |  JOIN BUILD
|  |  |  join-table-id=17 plan-id=18 cohort-id=02
|  |  |  build expressions: d1.d_date_sk
|  |  |  runtime filters: RF078[bloom] <- d1.d_date_sk
|  |  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  111:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=29 row-size=8B cardinality=373
|  |  |  in pipelines: 45(GETNEXT)
|  |  |
|  |  F31:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=512.00KB thread-reservation=1
|  |  45:SCAN HDFS [tpcds_parquet.date_dim d1, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=2.15MB
|  |     predicates: d1.d_year = CAST(2000 AS INT)
|  |     stored statistics:
|  |       table: rows=73.05K size=2.15MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=73.05K
|  |     parquet statistics predicates: d1.d_year = CAST(2000 AS INT)
|  |     parquet dictionary predicates: d1.d_year = CAST(2000 AS INT)
|  |     mem-estimate=16.00MB mem-reservation=512.00KB thread-reservation=0
|  |     tuple-ids=29 row-size=8B cardinality=373
|  |     in pipelines: 45(GETNEXT)
|  |
|  60:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash-table-id=18
|  |  hash predicates: ss_item_sk = i_item_sk
|  |  fk/pk conjuncts: ss_item_sk = i_item_sk
|  |  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=23,43 row-size=115B cardinality=59.37K
|  |  in pipelines: 39(GETNEXT), 59(OPEN)
|  |
|  |--F78:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  |  |  Per-Instance Resources: mem-estimate=4.92MB mem-reservation=4.88MB thread-reservation=1 runtime-filters-memory=1.00MB
|  |  JOIN BUILD
|  |  |  join-table-id=18 plan-id=19 cohort-id=02
|  |  |  build expressions: i_item_sk
|  |  |  runtime filters: RF080[bloom] <- i_item_sk
|  |  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  110:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=44.51KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=43 row-size=59B cardinality=371
|  |  |  in pipelines: 59(GETNEXT)
|  |  |
|  |  F30:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=512.00KB thread-reservation=1
|  |  59:SCAN HDFS [tpcds_parquet.item, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=1.73MB
|  |     predicates: i_color IN ('purple', 'burlywood', 'indian', 'spring', 'floral', 'medium'), i_current_price <= CAST(74 AS DECIMAL(3,0)), i_current_price <= CAST(79 AS DECIMAL(3,0)), i_current_price >= CAST(64 AS DECIMAL(3,0)), i_current_price >= CAST(65 AS DECIMAL(3,0))
|  |     stored statistics:
|  |       table: rows=18.00K size=1.73MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=18.00K
|  |     parquet statistics predicates: i_color IN ('purple', 'burlywood', 'indian', 'spring', 'floral', 'medium'), i_current_price <= CAST(74 AS DECIMAL(3,0)), i_current_price <= CAST(79 AS DECIMAL(3,0)), i_current_price >= CAST(64 AS DECIMAL(3,0)), i_current_price >= CAST(65 AS DECIMAL(3,0))
|  |     parquet dictionary predicates: i_color IN ('purple', 'burlywood', 'indian', 'spring', 'floral', 'medium'), i_current_price <= CAST(74 AS DECIMAL(3,0)), i_current_price <= CAST(79 AS DECIMAL(3,0)), i_current_price >= CAST(64 AS DECIMAL(3,0)), i_current_price >= CAST(65 AS DECIMAL(3,0))
|  |     mem-estimate=16.00MB mem-reservation=512.00KB thread-reservation=0
|  |     tuple-ids=43 row-size=59B cardinality=371
|  |     in pipelines: 59(GETNEXT)
|  |
|  39:SCAN HDFS [tpcds_parquet.store_sales, RANDOM]
|     HDFS partitions=1824/1824 files=1824 size=200.95MB
|     runtime filters: RF080[bloom] -> ss_item_sk, RF078[bloom] -> ss_sold_date_sk
|     stored statistics:
|       table: rows=2.88M size=200.95MB
|       partitions: 1824/1824 rows=2.88M
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=130.09K
|     mem-estimate=16.00MB mem-reservation=8.00MB thread-reservation=0
|     tuple-ids=23 row-size=56B cardinality=2.88M
|     in pipelines: 39(GETNEXT)
|
140:EXCHANGE [HASH(i_item_sk,s_store_name,s_zip)]
|  mem-estimate=11.70MB mem-reservation=0B thread-reservation=0
|  tuple-ids=21 row-size=286B cardinality=288.12K
|  in pipelines: 109(GETNEXT)
|
F28:PLAN FRAGMENT [HASH(i_product_name,i_item_sk,s_store_name,s_zip,ad1.ca_street_number,ad1.ca_street_name,ad1.ca_city,ad1.ca_zip,ad2.ca_street_number,ad2.ca_street_name,ad2.ca_city,ad2.ca_zip,d1.d_year,d2.d_year,d3.d_year)] hosts=3 instances=6
Per-Instance Resources: mem-estimate=45.70MB mem-reservation=34.00MB thread-reservation=1
109:AGGREGATE [FINALIZE]
|  output: count:merge(*), sum:merge(ss_wholesale_cost), sum:merge(ss_list_price), sum:merge(ss_coupon_amt)
|  group by: i_product_name, i_item_sk, s_store_name, s_zip, ad1.ca_street_number, ad1.ca_street_name, ad1.ca_city, ad1.ca_zip, ad2.ca_street_number, ad2.ca_street_name, ad2.ca_city, ad2.ca_zip, d1.d_year, d2.d_year, d3.d_year
|  mem-estimate=34.00MB mem-reservation=34.00MB spill-buffer=2.00MB thread-reservation=0
|  tuple-ids=21 row-size=286B cardinality=288.12K
|  in pipelines: 109(GETNEXT), 00(OPEN)
|
108:EXCHANGE [HASH(i_product_name,i_item_sk,s_store_name,s_zip,ad1.ca_street_number,ad1.ca_street_name,ad1.ca_city,ad1.ca_zip,ad2.ca_street_number,ad2.ca_street_name,ad2.ca_city,ad2.ca_zip,d1.d_year,d2.d_year,d3.d_year)]
|  mem-estimate=11.70MB mem-reservation=0B thread-reservation=0
|  tuple-ids=21 row-size=286B cardinality=288.12K
|  in pipelines: 00(GETNEXT)
|
F22:PLAN FRAGMENT [HASH(c_current_addr_sk)] hosts=3 instances=6
Per-Instance Resources: mem-estimate=37.30MB mem-reservation=34.00MB thread-reservation=1
38:AGGREGATE [STREAMING]
|  output: count(*), sum(ss_wholesale_cost), sum(ss_list_price), sum(ss_coupon_amt)
|  group by: i_product_name, i_item_sk, s_store_name, s_zip, ad1.ca_street_number, ad1.ca_street_name, ad1.ca_city, ad1.ca_zip, ad2.ca_street_number, ad2.ca_street_name, ad2.ca_city, ad2.ca_zip, d1.d_year, d2.d_year, d3.d_year
|  mem-estimate=34.00MB mem-reservation=34.00MB spill-buffer=2.00MB thread-reservation=0
|  tuple-ids=21 row-size=286B cardinality=288.12K
|  in pipelines: 00(GETNEXT)
|
37:HASH JOIN [INNER JOIN, BROADCAST]
|  hash-table-id=19
|  hash predicates: ss_item_sk = cs_item_sk
|  fk/pk conjuncts: none
|  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10,15,7,8,11,12,16,17,18,19,4 row-size=474B cardinality=288.12K
|  in pipelines: 00(GETNEXT), 106(OPEN)
|
|--F79:PLAN FRAGMENT [HASH(c_current_addr_sk)] hosts=3 instances=3
|  |  Per-Instance Resources: mem-estimate=4.07MB mem-reservation=3.88MB thread-reservation=1
|  JOIN BUILD
|  |  join-table-id=19 plan-id=20 cohort-id=01
|  |  build expressions: cs_item_sk
|  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |
|  107:EXCHANGE [BROADCAST]
|  |  mem-estimate=202.23KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=4 row-size=40B cardinality=1.80K
|  |  in pipelines: 106(GETNEXT)
|  |
|  F27:PLAN FRAGMENT [HASH(cs_item_sk)] hosts=3 instances=3
|  Per-Instance Resources: mem-estimate=10.36MB mem-reservation=1.94MB thread-reservation=1
|  106:AGGREGATE [FINALIZE]
|  |  output: sum:merge(cs_ext_list_price), sum:merge(cr_refunded_cash + cr_reversed_charge + cr_store_credit)
|  |  group by: cs_item_sk
|  |  having: sum(cs_ext_list_price) > CAST(2 AS DECIMAL(3,0)) * sum(cr_refunded_cash + cr_reversed_charge + cr_store_credit)
|  |  mem-estimate=10.00MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=4 row-size=40B cardinality=1.80K
|  |  in pipelines: 106(GETNEXT), 02(OPEN)
|  |
|  105:EXCHANGE [HASH(cs_item_sk)]
|  |  mem-estimate=366.05KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=4 row-size=40B cardinality=17.98K
|  |  in pipelines: 02(GETNEXT)
|  |
|  F25:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  Per-Host Shared Resources: mem-estimate=2.00MB mem-reservation=2.00MB thread-reservation=0 runtime-filters-memory=2.00MB
|  Per-Instance Resources: mem-estimate=58.00MB mem-reservation=10.00MB thread-reservation=1
|  05:AGGREGATE [STREAMING]
|  |  output: sum(cs_ext_list_price), sum(cr_refunded_cash + cr_reversed_charge + cr_store_credit)
|  |  group by: cs_item_sk
|  |  mem-estimate=10.00MB mem-reservation=2.00MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=4 row-size=40B cardinality=17.98K
|  |  in pipelines: 02(GETNEXT)
|  |
|  04:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash-table-id=20
|  |  hash predicates: cs_item_sk = cr_item_sk, cs_order_number = cr_order_number
|  |  fk/pk conjuncts: cs_item_sk = cr_item_sk, cs_order_number = cr_order_number
|  |  mem-estimate=0B mem-reservation=0B spill-buffer=256.00KB thread-reservation=0
|  |  tuple-ids=2,3 row-size=48B cardinality=849.41K
|  |  in pipelines: 02(GETNEXT), 03(OPEN)
|  |
|  |--F80:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  |  |  Per-Instance Resources: mem-estimate=15.38MB mem-reservation=11.50MB thread-reservation=1 runtime-filters-memory=2.00MB
|  |  JOIN BUILD
|  |  |  join-table-id=20 plan-id=21 cohort-id=04
|  |  |  build expressions: cr_item_sk, cr_order_number
|  |  |  runtime filters: RF042[bloom] <- cr_item_sk, RF043[bloom] <- cr_order_number
|  |  |  mem-estimate=9.50MB mem-reservation=9.50MB spill-buffer=256.00KB thread-reservation=0
|  |  |
|  |  104:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=3.88MB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=3 row-size=28B cardinality=144.07K
|  |  |  in pipelines: 03(GETNEXT)
|  |  |
|  |  F26:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=24.00MB mem-reservation=4.00MB thread-reservation=1
|  |  03:SCAN HDFS [tpcds_parquet.catalog_returns, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=10.62MB
|  |     stored statistics:
|  |       table: rows=144.07K size=10.62MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=144.07K
|  |     mem-estimate=24.00MB mem-reservation=4.00MB thread-reservation=0
|  |     tuple-ids=3 row-size=28B cardinality=144.07K
|  |     in pipelines: 03(GETNEXT)
|  |
|  02:SCAN HDFS [tpcds_parquet.catalog_sales, RANDOM]
|     HDFS partitions=1/1 files=3 size=96.62MB
|     runtime filters: RF042[bloom] -> cs_item_sk, RF043[bloom] -> cs_order_number
|     stored statistics:
|       table: rows=1.44M size=96.62MB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=650.14K
|     mem-estimate=48.00MB mem-reservation=8.00MB thread-reservation=0
|     tuple-ids=2 row-size=20B cardinality=1.44M
|     in pipelines: 02(GETNEXT)
|
36:HASH JOIN [INNER JOIN, BROADCAST]
|  hash-table-id=21
|  hash predicates: hd2.hd_income_band_sk = ib2.ib_income_band_sk
|  fk/pk conjuncts: hd2.hd_income_band_sk = ib2.ib_income_band_sk
|  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10,15,7,8,11,12,16,17,18,19 row-size=434B cardinality=8.45K
|  in pipelines: 00(GETNEXT), 19(OPEN)
|
|--F81:PLAN FRAGMENT [HASH(c_current_addr_sk)] hosts=3 instances=3
|  |  Per-Instance Resources: mem-estimate=3.89MB mem-reservation=3.88MB thread-reservation=1
|  JOIN BUILD
|  |  join-table-id=21 plan-id=22 cohort-id=01
|  |  build expressions: ib2.ib_income_band_sk
|  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |
|  103:EXCHANGE [BROADCAST]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=19 row-size=4B cardinality=20
|  |  in pipelines: 19(GETNEXT)
|  |
|  F24:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=8.00KB thread-reservation=1
|  19:SCAN HDFS [tpcds_parquet.income_band ib2, RANDOM]
|     HDFS partitions=1/1 files=1 size=1.21KB
|     stored statistics:
|       table: rows=20 size=1.21KB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=20
|     mem-estimate=16.00MB mem-reservation=8.00KB thread-reservation=0
|     tuple-ids=19 row-size=4B cardinality=20
|     in pipelines: 19(GETNEXT)
|
35:HASH JOIN [INNER JOIN, BROADCAST]
|  hash-table-id=22
|  hash predicates: hd1.hd_income_band_sk = ib1.ib_income_band_sk
|  fk/pk conjuncts: hd1.hd_income_band_sk = ib1.ib_income_band_sk
|  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10,15,7,8,11,12,16,17,18 row-size=430B cardinality=8.45K
|  in pipelines: 00(GETNEXT), 18(OPEN)
|
|--F82:PLAN FRAGMENT [HASH(c_current_addr_sk)] hosts=3 instances=3
|  |  Per-Instance Resources: mem-estimate=3.89MB mem-reservation=3.88MB thread-reservation=1
|  JOIN BUILD
|  |  join-table-id=22 plan-id=23 cohort-id=01
|  |  build expressions: ib1.ib_income_band_sk
|  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |
|  102:EXCHANGE [BROADCAST]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=18 row-size=4B cardinality=20
|  |  in pipelines: 18(GETNEXT)
|  |
|  F23:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=8.00KB thread-reservation=1
|  18:SCAN HDFS [tpcds_parquet.income_band ib1, RANDOM]
|     HDFS partitions=1/1 files=1 size=1.21KB
|     stored statistics:
|       table: rows=20 size=1.21KB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=20
|     mem-estimate=16.00MB mem-reservation=8.00KB thread-reservation=0
|     tuple-ids=18 row-size=4B cardinality=20
|     in pipelines: 18(GETNEXT)
|
34:HASH JOIN [INNER JOIN, PARTITIONED]
|  hash-table-id=23
|  hash predicates: c_current_addr_sk = ad2.ca_address_sk
|  fk/pk conjuncts: c_current_addr_sk = ad2.ca_address_sk
|  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10,15,7,8,11,12,16,17 row-size=426B cardinality=8.45K
|  in pipelines: 00(GETNEXT), 17(OPEN)
|
|--F83:PLAN FRAGMENT [HASH(c_current_addr_sk)] hosts=3 instances=6
|  |  Per-Instance Resources: mem-estimate=5.71MB mem-reservation=1.94MB thread-reservation=1
|  JOIN BUILD
|  |  join-table-id=23 plan-id=24 cohort-id=01
|  |  build expressions: ad2.ca_address_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |
|  101:EXCHANGE [HASH(ad2.ca_address_sk)]
|  |  mem-estimate=3.78MB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=17 row-size=78B cardinality=50.00K
|  |  in pipelines: 17(GETNEXT)
|  |
|  F21:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=1.00MB thread-reservation=1
|  17:SCAN HDFS [tpcds_parquet.customer_address ad2, RANDOM]
|     HDFS partitions=1/1 files=1 size=1.16MB
|     stored statistics:
|       table: rows=50.00K size=1.16MB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=50.00K
|     mem-estimate=16.00MB mem-reservation=1.00MB thread-reservation=0
|     tuple-ids=17 row-size=78B cardinality=50.00K
|     in pipelines: 17(GETNEXT)
|
100:EXCHANGE [HASH(c_current_addr_sk)]
|  mem-estimate=3.30MB mem-reservation=0B thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10,15,7,8,11,12,16 row-size=348B cardinality=8.45K
|  in pipelines: 00(GETNEXT)
|
F20:PLAN FRAGMENT [HASH(ss_addr_sk)] hosts=3 instances=6
Per-Instance Resources: mem-estimate=2.62MB mem-reservation=0B thread-reservation=1
33:HASH JOIN [INNER JOIN, PARTITIONED]
|  hash-table-id=24
|  hash predicates: ss_addr_sk = ad1.ca_address_sk
|  fk/pk conjuncts: ss_addr_sk = ad1.ca_address_sk
|  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10,15,7,8,11,12,16 row-size=348B cardinality=8.45K
|  in pipelines: 00(GETNEXT), 16(OPEN)
|
|--F84:PLAN FRAGMENT [HASH(ss_addr_sk)] hosts=3 instances=6
|  |  Per-Instance Resources: mem-estimate=5.71MB mem-reservation=1.94MB thread-reservation=1
|  JOIN BUILD
|  |  join-table-id=24 plan-id=25 cohort-id=01
|  |  build expressions: ad1.ca_address_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |
|  99:EXCHANGE [HASH(ad1.ca_address_sk)]
|  |  mem-estimate=3.78MB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=16 row-size=78B cardinality=50.00K
|  |  in pipelines: 16(GETNEXT)
|  |
|  F19:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=1.00MB thread-reservation=1
|  16:SCAN HDFS [tpcds_parquet.customer_address ad1, RANDOM]
|     HDFS partitions=1/1 files=1 size=1.16MB
|     stored statistics:
|       table: rows=50.00K size=1.16MB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=50.00K
|     mem-estimate=16.00MB mem-reservation=1.00MB thread-reservation=0
|     tuple-ids=16 row-size=78B cardinality=50.00K
|     in pipelines: 16(GETNEXT)
|
98:EXCHANGE [HASH(ss_addr_sk)]
|  mem-estimate=2.62MB mem-reservation=0B thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10,15,7,8,11,12 row-size=271B cardinality=8.45K
|  in pipelines: 00(GETNEXT)
|
F18:PLAN FRAGMENT [HASH(c_current_cdemo_sk)] hosts=3 instances=6
Per-Instance Resources: mem-estimate=2.45MB mem-reservation=0B thread-reservation=1
32:HASH JOIN [INNER JOIN, PARTITIONED]
|  hash-table-id=25
|  hash predicates: c_current_cdemo_sk = cd2.cd_demo_sk
|  fk/pk conjuncts: c_current_cdemo_sk = cd2.cd_demo_sk
|  other predicates: cd1.cd_marital_status != cd2.cd_marital_status
|  mem-estimate=0B mem-reservation=0B spill-buffer=512.00KB thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10,15,7,8,11,12 row-size=271B cardinality=8.45K
|  in pipelines: 00(GETNEXT), 12(OPEN)
|
|--F85:PLAN FRAGMENT [HASH(c_current_cdemo_sk)] hosts=3 instances=6
|  |  Per-Instance Resources: mem-estimate=18.52MB mem-reservation=8.50MB thread-reservation=1
|  JOIN BUILD
|  |  join-table-id=25 plan-id=26 cohort-id=01
|  |  build expressions: cd2.cd_demo_sk
|  |  mem-estimate=8.50MB mem-reservation=8.50MB spill-buffer=512.00KB thread-reservation=0
|  |
|  97:EXCHANGE [HASH(cd2.cd_demo_sk)]
|  |  mem-estimate=10.02MB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=12 row-size=17B cardinality=1.92M
|  |  in pipelines: 12(GETNEXT)
|  |
|  F17:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=8.00MB thread-reservation=1
|  12:SCAN HDFS [tpcds_parquet.customer_demographics cd2, RANDOM]
|     HDFS partitions=1/1 files=1 size=7.49MB
|     stored statistics:
|       table: rows=1.92M size=7.49MB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=1.92M
|     mem-estimate=16.00MB mem-reservation=8.00MB thread-reservation=0
|     tuple-ids=12 row-size=17B cardinality=1.92M
|     in pipelines: 12(GETNEXT)
|
96:EXCHANGE [HASH(c_current_cdemo_sk)]
|  mem-estimate=2.45MB mem-reservation=0B thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10,15,7,8,11 row-size=254B cardinality=8.45K
|  in pipelines: 00(GETNEXT)
|
F16:PLAN FRAGMENT [HASH(ss_cdemo_sk)] hosts=3 instances=6
Per-Instance Resources: mem-estimate=2.28MB mem-reservation=0B thread-reservation=1
31:HASH JOIN [INNER JOIN, PARTITIONED]
|  hash-table-id=26
|  hash predicates: ss_cdemo_sk = cd1.cd_demo_sk
|  fk/pk conjuncts: ss_cdemo_sk = cd1.cd_demo_sk
|  mem-estimate=0B mem-reservation=0B spill-buffer=512.00KB thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10,15,7,8,11 row-size=254B cardinality=8.45K
|  in pipelines: 00(GETNEXT), 11(OPEN)
|
|--F86:PLAN FRAGMENT [HASH(ss_cdemo_sk)] hosts=3 instances=6
|  |  Per-Instance Resources: mem-estimate=18.52MB mem-reservation=8.50MB thread-reservation=1
|  JOIN BUILD
|  |  join-table-id=26 plan-id=27 cohort-id=01
|  |  build expressions: cd1.cd_demo_sk
|  |  mem-estimate=8.50MB mem-reservation=8.50MB spill-buffer=512.00KB thread-reservation=0
|  |
|  95:EXCHANGE [HASH(cd1.cd_demo_sk)]
|  |  mem-estimate=10.02MB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=11 row-size=17B cardinality=1.92M
|  |  in pipelines: 11(GETNEXT)
|  |
|  F15:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=8.00MB thread-reservation=1
|  11:SCAN HDFS [tpcds_parquet.customer_demographics cd1, RANDOM]
|     HDFS partitions=1/1 files=1 size=7.49MB
|     stored statistics:
|       table: rows=1.92M size=7.49MB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=1.92M
|     mem-estimate=16.00MB mem-reservation=8.00MB thread-reservation=0
|     tuple-ids=11 row-size=17B cardinality=1.92M
|     in pipelines: 11(GETNEXT)
|
94:EXCHANGE [HASH(ss_cdemo_sk)]
|  mem-estimate=2.28MB mem-reservation=0B thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10,15,7,8 row-size=237B cardinality=8.45K
|  in pipelines: 00(GETNEXT)
|
F14:PLAN FRAGMENT [HASH(c_first_shipto_date_sk)] hosts=3 instances=6
Per-Instance Resources: mem-estimate=2.19MB mem-reservation=0B thread-reservation=1
30:HASH JOIN [INNER JOIN, PARTITIONED]
|  hash-table-id=27
|  hash predicates: c_first_shipto_date_sk = d3.d_date_sk
|  fk/pk conjuncts: c_first_shipto_date_sk = d3.d_date_sk
|  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10,15,7,8 row-size=237B cardinality=8.45K
|  in pipelines: 00(GETNEXT), 08(OPEN)
|
|--F87:PLAN FRAGMENT [HASH(c_first_shipto_date_sk)] hosts=3 instances=6
|  |  Per-Instance Resources: mem-estimate=2.51MB mem-reservation=1.94MB thread-reservation=1
|  JOIN BUILD
|  |  join-table-id=27 plan-id=28 cohort-id=01
|  |  build expressions: d3.d_date_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |
|  93:EXCHANGE [HASH(d3.d_date_sk)]
|  |  mem-estimate=582.70KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=8 row-size=8B cardinality=73.05K
|  |  in pipelines: 08(GETNEXT)
|  |
|  F13:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=512.00KB thread-reservation=1
|  08:SCAN HDFS [tpcds_parquet.date_dim d3, RANDOM]
|     HDFS partitions=1/1 files=1 size=2.15MB
|     stored statistics:
|       table: rows=73.05K size=2.15MB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=73.05K
|     mem-estimate=16.00MB mem-reservation=512.00KB thread-reservation=0
|     tuple-ids=8 row-size=8B cardinality=73.05K
|     in pipelines: 08(GETNEXT)
|
92:EXCHANGE [HASH(c_first_shipto_date_sk)]
|  mem-estimate=2.19MB mem-reservation=0B thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10,15,7 row-size=229B cardinality=8.45K
|  in pipelines: 00(GETNEXT)
|
F12:PLAN FRAGMENT [HASH(c_first_sales_date_sk)] hosts=3 instances=6
Per-Instance Resources: mem-estimate=2.10MB mem-reservation=0B thread-reservation=1
29:HASH JOIN [INNER JOIN, PARTITIONED]
|  hash-table-id=28
|  hash predicates: c_first_sales_date_sk = d2.d_date_sk
|  fk/pk conjuncts: c_first_sales_date_sk = d2.d_date_sk
|  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10,15,7 row-size=229B cardinality=8.45K
|  in pipelines: 00(GETNEXT), 07(OPEN)
|
|--F88:PLAN FRAGMENT [HASH(c_first_sales_date_sk)] hosts=3 instances=6
|  |  Per-Instance Resources: mem-estimate=2.51MB mem-reservation=1.94MB thread-reservation=1
|  JOIN BUILD
|  |  join-table-id=28 plan-id=29 cohort-id=01
|  |  build expressions: d2.d_date_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |
|  91:EXCHANGE [HASH(d2.d_date_sk)]
|  |  mem-estimate=582.70KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=7 row-size=8B cardinality=73.05K
|  |  in pipelines: 07(GETNEXT)
|  |
|  F11:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=512.00KB thread-reservation=1
|  07:SCAN HDFS [tpcds_parquet.date_dim d2, RANDOM]
|     HDFS partitions=1/1 files=1 size=2.15MB
|     stored statistics:
|       table: rows=73.05K size=2.15MB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=73.05K
|     mem-estimate=16.00MB mem-reservation=512.00KB thread-reservation=0
|     tuple-ids=7 row-size=8B cardinality=73.05K
|     in pipelines: 07(GETNEXT)
|
90:EXCHANGE [HASH(c_first_sales_date_sk)]
|  mem-estimate=2.10MB mem-reservation=0B thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10,15 row-size=221B cardinality=8.45K
|  in pipelines: 00(GETNEXT)
|
F09:PLAN FRAGMENT [HASH(ss_customer_sk)] hosts=3 instances=6
Per-Instance Resources: mem-estimate=1.79MB mem-reservation=0B thread-reservation=1
28:HASH JOIN [INNER JOIN, BROADCAST]
|  hash-table-id=29
|  hash predicates: c_current_hdemo_sk = hd2.hd_demo_sk
|  fk/pk conjuncts: c_current_hdemo_sk = hd2.hd_demo_sk
|  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10,15 row-size=221B cardinality=8.45K
|  in pipelines: 00(GETNEXT), 15(OPEN)
|
|--F89:PLAN FRAGMENT [HASH(ss_customer_sk)] hosts=3 instances=3
|  |  Per-Instance Resources: mem-estimate=3.94MB mem-reservation=3.88MB thread-reservation=1
|  JOIN BUILD
|  |  join-table-id=29 plan-id=30 cohort-id=01
|  |  build expressions: hd2.hd_demo_sk
|  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |
|  89:EXCHANGE [BROADCAST]
|  |  mem-estimate=68.25KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=15 row-size=8B cardinality=7.20K
|  |  in pipelines: 15(GETNEXT)
|  |
|  F10:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=64.00KB thread-reservation=1
|  15:SCAN HDFS [tpcds_parquet.household_demographics hd2, RANDOM]
|     HDFS partitions=1/1 files=1 size=41.69KB
|     stored statistics:
|       table: rows=7.20K size=41.69KB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=7.20K
|     mem-estimate=16.00MB mem-reservation=64.00KB thread-reservation=0
|     tuple-ids=15 row-size=8B cardinality=7.20K
|     in pipelines: 15(GETNEXT)
|
27:HASH JOIN [INNER JOIN, PARTITIONED]
|  hash-table-id=30
|  hash predicates: ss_customer_sk = c_customer_sk
|  fk/pk conjuncts: ss_customer_sk = c_customer_sk
|  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9,10 row-size=213B cardinality=8.66K
|  in pipelines: 00(GETNEXT), 10(OPEN)
|
|--F90:PLAN FRAGMENT [HASH(ss_customer_sk)] hosts=3 instances=6
|  |  Per-Instance Resources: mem-estimate=4.25MB mem-reservation=1.94MB thread-reservation=1
|  JOIN BUILD
|  |  join-table-id=30 plan-id=31 cohort-id=01
|  |  build expressions: c_customer_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |
|  88:EXCHANGE [HASH(c_customer_sk)]
|  |  mem-estimate=2.32MB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=10 row-size=24B cardinality=100.00K
|  |  in pipelines: 10(GETNEXT)
|  |
|  F08:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=2.00MB thread-reservation=1
|  10:SCAN HDFS [tpcds_parquet.customer, RANDOM]
|     HDFS partitions=1/1 files=1 size=5.49MB
|     stored statistics:
|       table: rows=100.00K size=5.49MB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=100.00K
|     mem-estimate=16.00MB mem-reservation=2.00MB thread-reservation=0
|     tuple-ids=10 row-size=24B cardinality=100.00K
|     in pipelines: 10(GETNEXT)
|
87:EXCHANGE [HASH(ss_customer_sk)]
|  mem-estimate=1.79MB mem-reservation=0B thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9 row-size=189B cardinality=8.66K
|  in pipelines: 00(GETNEXT)
|
F04:PLAN FRAGMENT [HASH(ss_item_sk,ss_ticket_number)] hosts=3 instances=6
Per-Instance Resources: mem-estimate=1.27MB mem-reservation=0B thread-reservation=1
26:HASH JOIN [INNER JOIN, BROADCAST]
|  hash-table-id=31
|  hash predicates: ss_store_sk = s_store_sk
|  fk/pk conjuncts: ss_store_sk = s_store_sk
|  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=0,20,6,1,14,13,9 row-size=189B cardinality=8.66K
|  in pipelines: 00(GETNEXT), 09(OPEN)
|
|--F91:PLAN FRAGMENT [HASH(ss_item_sk,ss_ticket_number)] hosts=3 instances=3
|  |  Per-Instance Resources: mem-estimate=3.89MB mem-reservation=3.88MB thread-reservation=1
|  JOIN BUILD
|  |  join-table-id=31 plan-id=32 cohort-id=01
|  |  build expressions: s_store_sk
|  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |
|  86:EXCHANGE [BROADCAST]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=9 row-size=37B cardinality=12
|  |  in pipelines: 09(GETNEXT)
|  |
|  F07:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=24.00KB thread-reservation=1
|  09:SCAN HDFS [tpcds_parquet.store, RANDOM]
|     HDFS partitions=1/1 files=1 size=9.93KB
|     stored statistics:
|       table: rows=12 size=9.93KB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=12
|     mem-estimate=16.00MB mem-reservation=24.00KB thread-reservation=0
|     tuple-ids=9 row-size=37B cardinality=12
|     in pipelines: 09(GETNEXT)
|
25:HASH JOIN [INNER JOIN, BROADCAST]
|  hash-table-id=32
|  hash predicates: ss_promo_sk = p_promo_sk
|  fk/pk conjuncts: ss_promo_sk = p_promo_sk
|  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=0,20,6,1,14,13 row-size=151B cardinality=8.66K
|  in pipelines: 00(GETNEXT), 13(OPEN)
|
|--F92:PLAN FRAGMENT [HASH(ss_item_sk,ss_ticket_number)] hosts=3 instances=3
|  |  Per-Instance Resources: mem-estimate=3.89MB mem-reservation=3.88MB thread-reservation=1
|  JOIN BUILD
|  |  join-table-id=32 plan-id=33 cohort-id=01
|  |  build expressions: p_promo_sk
|  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |
|  85:EXCHANGE [BROADCAST]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=13 row-size=4B cardinality=300
|  |  in pipelines: 13(GETNEXT)
|  |
|  F06:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=32.00KB thread-reservation=1
|  13:SCAN HDFS [tpcds_parquet.promotion, RANDOM]
|     HDFS partitions=1/1 files=1 size=23.30KB
|     stored statistics:
|       table: rows=300 size=23.30KB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=300
|     mem-estimate=16.00MB mem-reservation=32.00KB thread-reservation=0
|     tuple-ids=13 row-size=4B cardinality=300
|     in pipelines: 13(GETNEXT)
|
24:HASH JOIN [INNER JOIN, BROADCAST]
|  hash-table-id=33
|  hash predicates: ss_hdemo_sk = hd1.hd_demo_sk
|  fk/pk conjuncts: ss_hdemo_sk = hd1.hd_demo_sk
|  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=0,20,6,1,14 row-size=147B cardinality=8.72K
|  in pipelines: 00(GETNEXT), 14(OPEN)
|
|--F93:PLAN FRAGMENT [HASH(ss_item_sk,ss_ticket_number)] hosts=3 instances=3
|  |  Per-Instance Resources: mem-estimate=3.94MB mem-reservation=3.88MB thread-reservation=1
|  JOIN BUILD
|  |  join-table-id=33 plan-id=34 cohort-id=01
|  |  build expressions: hd1.hd_demo_sk
|  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |
|  84:EXCHANGE [BROADCAST]
|  |  mem-estimate=68.25KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=14 row-size=8B cardinality=7.20K
|  |  in pipelines: 14(GETNEXT)
|  |
|  F05:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=64.00KB thread-reservation=1
|  14:SCAN HDFS [tpcds_parquet.household_demographics hd1, RANDOM]
|     HDFS partitions=1/1 files=1 size=41.69KB
|     stored statistics:
|       table: rows=7.20K size=41.69KB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=7.20K
|     mem-estimate=16.00MB mem-reservation=64.00KB thread-reservation=0
|     tuple-ids=14 row-size=8B cardinality=7.20K
|     in pipelines: 14(GETNEXT)
|
23:HASH JOIN [INNER JOIN, PARTITIONED]
|  hash-table-id=34
|  hash predicates: ss_item_sk = sr_item_sk, ss_ticket_number = sr_ticket_number
|  fk/pk conjuncts: ss_item_sk = sr_item_sk, ss_ticket_number = sr_ticket_number
|  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=0,20,6,1 row-size=139B cardinality=8.93K
|  in pipelines: 00(GETNEXT), 01(OPEN)
|
|--F94:PLAN FRAGMENT [HASH(ss_item_sk,ss_ticket_number)] hosts=3 instances=6
|  |  Per-Instance Resources: mem-estimate=8.34MB mem-reservation=3.94MB thread-reservation=1 runtime-filters-memory=2.00MB
|  JOIN BUILD
|  |  join-table-id=34 plan-id=35 cohort-id=01
|  |  build expressions: sr_item_sk, sr_ticket_number
|  |  runtime filters: RF034[bloom] <- sr_item_sk, RF035[bloom] <- sr_ticket_number
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |
|  83:EXCHANGE [HASH(sr_item_sk,sr_ticket_number)]
|  |  mem-estimate=4.41MB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=1 row-size=16B cardinality=287.51K
|  |  in pipelines: 01(GETNEXT)
|  |
|  F03:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Instance Resources: mem-estimate=24.00MB mem-reservation=4.00MB thread-reservation=1
|  01:SCAN HDFS [tpcds_parquet.store_returns, RANDOM]
|     HDFS partitions=1/1 files=1 size=15.43MB
|     stored statistics:
|       table: rows=287.51K size=15.43MB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=287.51K
|     mem-estimate=24.00MB mem-reservation=4.00MB thread-reservation=0
|     tuple-ids=1 row-size=16B cardinality=287.51K
|     in pipelines: 01(GETNEXT)
|
82:EXCHANGE [HASH(ss_item_sk,ss_ticket_number)]
|  mem-estimate=1.27MB mem-reservation=0B thread-reservation=0
|  tuple-ids=0,20,6 row-size=123B cardinality=12.14K
|  in pipelines: 00(GETNEXT)
|
F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=6
Per-Host Shared Resources: mem-estimate=4.00MB mem-reservation=4.00MB thread-reservation=0 runtime-filters-memory=4.00MB
Per-Instance Resources: mem-estimate=16.00MB mem-reservation=8.00MB thread-reservation=1
22:HASH JOIN [INNER JOIN, BROADCAST]
|  hash-table-id=35
|  hash predicates: ss_sold_date_sk = d1.d_date_sk
|  fk/pk conjuncts: ss_sold_date_sk = d1.d_date_sk
|  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=0,20,6 row-size=123B cardinality=12.14K
|  in pipelines: 00(GETNEXT), 06(OPEN)
|
|--F95:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  |  Per-Instance Resources: mem-estimate=4.89MB mem-reservation=4.88MB thread-reservation=1 runtime-filters-memory=1.00MB
|  JOIN BUILD
|  |  join-table-id=35 plan-id=36 cohort-id=01
|  |  build expressions: d1.d_date_sk
|  |  runtime filters: RF038[bloom] <- d1.d_date_sk
|  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |
|  81:EXCHANGE [BROADCAST]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=6 row-size=8B cardinality=373
|  |  in pipelines: 06(GETNEXT)
|  |
|  F02:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=512.00KB thread-reservation=1
|  06:SCAN HDFS [tpcds_parquet.date_dim d1, RANDOM]
|     HDFS partitions=1/1 files=1 size=2.15MB
|     predicates: d1.d_year = CAST(1999 AS INT)
|     stored statistics:
|       table: rows=73.05K size=2.15MB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=73.05K
|     parquet statistics predicates: d1.d_year = CAST(1999 AS INT)
|     parquet dictionary predicates: d1.d_year = CAST(1999 AS INT)
|     mem-estimate=16.00MB mem-reservation=512.00KB thread-reservation=0
|     tuple-ids=6 row-size=8B cardinality=373
|     in pipelines: 06(GETNEXT)
|
21:HASH JOIN [INNER JOIN, BROADCAST]
|  hash-table-id=36
|  hash predicates: ss_item_sk = i_item_sk
|  fk/pk conjuncts: ss_item_sk = i_item_sk
|  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=0,20 row-size=115B cardinality=59.37K
|  in pipelines: 00(GETNEXT), 20(OPEN)
|
|--F96:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  |  Per-Instance Resources: mem-estimate=4.92MB mem-reservation=4.88MB thread-reservation=1 runtime-filters-memory=1.00MB
|  JOIN BUILD
|  |  join-table-id=36 plan-id=37 cohort-id=01
|  |  build expressions: i_item_sk
|  |  runtime filters: RF040[bloom] <- i_item_sk
|  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |
|  80:EXCHANGE [BROADCAST]
|  |  mem-estimate=44.51KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=20 row-size=59B cardinality=371
|  |  in pipelines: 20(GETNEXT)
|  |
|  F01:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Host Shared Resources: mem-estimate=1.00MB mem-reservation=1.00MB thread-reservation=0 runtime-filters-memory=1.00MB
|  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=512.00KB thread-reservation=1
|  20:SCAN HDFS [tpcds_parquet.item, RANDOM]
|     HDFS partitions=1/1 files=1 size=1.73MB
|     predicates: i_color IN ('purple', 'burlywood', 'indian', 'spring', 'floral', 'medium'), i_current_price <= CAST(74 AS DECIMAL(3,0)), i_current_price <= CAST(79 AS DECIMAL(3,0)), i_current_price >= CAST(64 AS DECIMAL(3,0)), i_current_price >= CAST(65 AS DECIMAL(3,0))
|     runtime filters: RF034[bloom] -> tpcds_parquet.item.i_item_sk
|     stored statistics:
|       table: rows=18.00K size=1.73MB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=18.00K
|     parquet statistics predicates: i_color IN ('purple', 'burlywood', 'indian', 'spring', 'floral', 'medium'), i_current_price <= CAST(74 AS DECIMAL(3,0)), i_current_price <= CAST(79 AS DECIMAL(3,0)), i_current_price >= CAST(64 AS DECIMAL(3,0)), i_current_price >= CAST(65 AS DECIMAL(3,0))
|     parquet dictionary predicates: i_color IN ('purple', 'burlywood', 'indian', 'spring', 'floral', 'medium'), i_current_price <= CAST(74 AS DECIMAL(3,0)), i_current_price <= CAST(79 AS DECIMAL(3,0)), i_current_price >= CAST(64 AS DECIMAL(3,0)), i_current_price >= CAST(65 AS DECIMAL(3,0))
|     mem-estimate=16.00MB mem-reservation=512.00KB thread-reservation=0
|     tuple-ids=20 row-size=59B cardinality=371
|     in pipelines: 20(GETNEXT)
|
00:SCAN HDFS [tpcds_parquet.store_sales, RANDOM]
   HDFS partitions=1824/1824 files=1824 size=200.95MB
   runtime filters: RF040[bloom] -> ss_item_sk, RF038[bloom] -> ss_sold_date_sk, RF034[bloom] -> ss_item_sk, RF035[bloom] -> ss_ticket_number
   stored statistics:
     table: rows=2.88M size=200.95MB
     partitions: 1824/1824 rows=2.88M
     columns: all
   extrapolated-rows=disabled max-scan-range-rows=130.09K
   mem-estimate=16.00MB mem-reservation=8.00MB thread-reservation=0
   tuple-ids=0 row-size=56B cardinality=2.88M
   in pipelines: 00(GETNEXT)
====