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

# TPCDS-Q88
select  *
from
 (select count(*) h8_30_to_9
 from store_sales, household_demographics , time_dim, store
 where ss_sold_time_sk = time_dim.t_time_sk
     and ss_hdemo_sk = household_demographics.hd_demo_sk
     and ss_store_sk = s_store_sk
     and time_dim.t_hour = 8
     and time_dim.t_minute >= 30
     and ((household_demographics.hd_dep_count = 1 and household_demographics.hd_vehicle_count<=1+2) or
          (household_demographics.hd_dep_count = 0 and household_demographics.hd_vehicle_count<=0+2) or
          (household_demographics.hd_dep_count = 2 and household_demographics.hd_vehicle_count<=2+2))
     and store.s_store_name = 'ese') s1,
 (select count(*) h9_to_9_30
 from store_sales, household_demographics , time_dim, store
 where ss_sold_time_sk = time_dim.t_time_sk
     and ss_hdemo_sk = household_demographics.hd_demo_sk
     and ss_store_sk = s_store_sk
     and time_dim.t_hour = 9
     and time_dim.t_minute < 30
     and ((household_demographics.hd_dep_count = 1 and household_demographics.hd_vehicle_count<=1+2) or
          (household_demographics.hd_dep_count = 0 and household_demographics.hd_vehicle_count<=0+2) or
          (household_demographics.hd_dep_count = 2 and household_demographics.hd_vehicle_count<=2+2))
     and store.s_store_name = 'ese') s2,
 (select count(*) h9_30_to_10
 from store_sales, household_demographics , time_dim, store
 where ss_sold_time_sk = time_dim.t_time_sk
     and ss_hdemo_sk = household_demographics.hd_demo_sk
     and ss_store_sk = s_store_sk
     and time_dim.t_hour = 9
     and time_dim.t_minute >= 30
     and ((household_demographics.hd_dep_count = 1 and household_demographics.hd_vehicle_count<=1+2) or
          (household_demographics.hd_dep_count = 0 and household_demographics.hd_vehicle_count<=0+2) or
          (household_demographics.hd_dep_count = 2 and household_demographics.hd_vehicle_count<=2+2))
     and store.s_store_name = 'ese') s3,
 (select count(*) h10_to_10_30
 from store_sales, household_demographics , time_dim, store
 where ss_sold_time_sk = time_dim.t_time_sk
     and ss_hdemo_sk = household_demographics.hd_demo_sk
     and ss_store_sk = s_store_sk
     and time_dim.t_hour = 10
     and time_dim.t_minute < 30
     and ((household_demographics.hd_dep_count = 1 and household_demographics.hd_vehicle_count<=1+2) or
          (household_demographics.hd_dep_count = 0 and household_demographics.hd_vehicle_count<=0+2) or
          (household_demographics.hd_dep_count = 2 and household_demographics.hd_vehicle_count<=2+2))
     and store.s_store_name = 'ese') s4,
 (select count(*) h10_30_to_11
 from store_sales, household_demographics , time_dim, store
 where ss_sold_time_sk = time_dim.t_time_sk
     and ss_hdemo_sk = household_demographics.hd_demo_sk
     and ss_store_sk = s_store_sk
     and time_dim.t_hour = 10
     and time_dim.t_minute >= 30
     and ((household_demographics.hd_dep_count = 1 and household_demographics.hd_vehicle_count<=1+2) or
          (household_demographics.hd_dep_count = 0 and household_demographics.hd_vehicle_count<=0+2) or
          (household_demographics.hd_dep_count = 2 and household_demographics.hd_vehicle_count<=2+2))
     and store.s_store_name = 'ese') s5,
 (select count(*) h11_to_11_30
 from store_sales, household_demographics , time_dim, store
 where ss_sold_time_sk = time_dim.t_time_sk
     and ss_hdemo_sk = household_demographics.hd_demo_sk
     and ss_store_sk = s_store_sk
     and time_dim.t_hour = 11
     and time_dim.t_minute < 30
     and ((household_demographics.hd_dep_count = 1 and household_demographics.hd_vehicle_count<=1+2) or
          (household_demographics.hd_dep_count = 0 and household_demographics.hd_vehicle_count<=0+2) or
          (household_demographics.hd_dep_count = 2 and household_demographics.hd_vehicle_count<=2+2))
     and store.s_store_name = 'ese') s6,
 (select count(*) h11_30_to_12
 from store_sales, household_demographics , time_dim, store
 where ss_sold_time_sk = time_dim.t_time_sk
     and ss_hdemo_sk = household_demographics.hd_demo_sk
     and ss_store_sk = s_store_sk
     and time_dim.t_hour = 11
     and time_dim.t_minute >= 30
     and ((household_demographics.hd_dep_count = 1 and household_demographics.hd_vehicle_count<=1+2) or
          (household_demographics.hd_dep_count = 0 and household_demographics.hd_vehicle_count<=0+2) or
          (household_demographics.hd_dep_count = 2 and household_demographics.hd_vehicle_count<=2+2))
     and store.s_store_name = 'ese') s7,
 (select count(*) h12_to_12_30
 from store_sales, household_demographics , time_dim, store
 where ss_sold_time_sk = time_dim.t_time_sk
     and ss_hdemo_sk = household_demographics.hd_demo_sk
     and ss_store_sk = s_store_sk
     and time_dim.t_hour = 12
     and time_dim.t_minute < 30
     and ((household_demographics.hd_dep_count = 1 and household_demographics.hd_vehicle_count<=1+2) or
          (household_demographics.hd_dep_count = 0 and household_demographics.hd_vehicle_count<=0+2) or
          (household_demographics.hd_dep_count = 2 and household_demographics.hd_vehicle_count<=2+2))
     and store.s_store_name = 'ese') s8
---- PLAN
Max Per-Host Resource Reservation: Memory=69.12MB Threads=33
Per-Host Resource Estimates: Memory=1.43GB
F00:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
|  Per-Host Resources: mem-estimate=1.43GB mem-reservation=69.12MB thread-reservation=33 runtime-filters-memory=10.00MB
PLAN-ROOT SINK
|  output exprs: count(*), count(*), count(*), count(*), count(*), count(*), count(*), count(*)
|  mem-estimate=0B mem-reservation=0B thread-reservation=0
|
70:NESTED LOOP JOIN [CROSS JOIN]
|  mem-estimate=8B mem-reservation=0B thread-reservation=0
|  tuple-ids=4,10,16,22,28,34,40,46 row-size=64B cardinality=1
|  in pipelines: 07(GETNEXT), 63(OPEN)
|
|--63:AGGREGATE [FINALIZE]
|  |  output: count(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=46 row-size=8B cardinality=1
|  |  in pipelines: 63(GETNEXT), 56(OPEN)
|  |
|  62: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=42,44,43,45 row-size=56B cardinality=2.27K
|  |  in pipelines: 56(GETNEXT), 59(OPEN)
|  |
|  |--59:SCAN HDFS [tpcds_parquet.store]
|  |     HDFS partitions=1/1 files=1 size=9.93KB
|  |     predicates: store.s_store_name = 'ese'
|  |     stored statistics:
|  |       table: rows=12 size=9.93KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=12
|  |     parquet statistics predicates: store.s_store_name = 'ese'
|  |     parquet dictionary predicates: store.s_store_name = 'ese'
|  |     mem-estimate=32.00MB mem-reservation=16.00KB thread-reservation=1
|  |     tuple-ids=45 row-size=20B cardinality=2
|  |     in pipelines: 59(GETNEXT)
|  |
|  61:HASH JOIN [INNER JOIN]
|  |  hash predicates: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  fk/pk conjuncts: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=42,44,43 row-size=36B cardinality=6.82K
|  |  in pipelines: 56(GETNEXT), 57(OPEN)
|  |
|  |--57:SCAN HDFS [tpcds_parquet.household_demographics]
|  |     HDFS partitions=1/1 files=1 size=41.69KB
|  |     predicates: ((household_demographics.hd_dep_count = CAST(1 AS INT) AND household_demographics.hd_vehicle_count <= CAST(3 AS INT)) OR (household_demographics.hd_dep_count = CAST(0 AS INT) AND household_demographics.hd_vehicle_count <= CAST(2 AS INT)) OR (household_demographics.hd_dep_count = CAST(2 AS INT) AND household_demographics.hd_vehicle_count <= CAST(4 AS INT)))
|  |     stored statistics:
|  |       table: rows=7.20K size=41.69KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=7.20K
|  |     mem-estimate=48.00MB mem-reservation=64.00KB thread-reservation=1
|  |     tuple-ids=43 row-size=12B cardinality=720
|  |     in pipelines: 57(GETNEXT)
|  |
|  60:HASH JOIN [INNER JOIN]
|  |  hash predicates: ss_sold_time_sk = time_dim.t_time_sk
|  |  fk/pk conjuncts: ss_sold_time_sk = time_dim.t_time_sk
|  |  runtime filters: RF046[bloom] <- time_dim.t_time_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=42,44 row-size=24B cardinality=69.82K
|  |  in pipelines: 56(GETNEXT), 58(OPEN)
|  |
|  |--58:SCAN HDFS [tpcds_parquet.time_dim]
|  |     HDFS partitions=1/1 files=1 size=1.31MB
|  |     predicates: time_dim.t_hour = CAST(12 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     stored statistics:
|  |       table: rows=86.40K size=1.31MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=86.40K
|  |     parquet statistics predicates: time_dim.t_hour = CAST(12 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     parquet dictionary predicates: time_dim.t_hour = CAST(12 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     mem-estimate=48.00MB mem-reservation=512.00KB thread-reservation=1
|  |     tuple-ids=44 row-size=12B cardinality=1.14K
|  |     in pipelines: 58(GETNEXT)
|  |
|  56:SCAN HDFS [tpcds_parquet.store_sales]
|     HDFS partitions=1824/1824 files=1824 size=200.95MB
|     runtime filters: RF046[bloom] -> ss_sold_time_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=48.00MB mem-reservation=1.00MB thread-reservation=1
|     tuple-ids=42 row-size=12B cardinality=2.88M
|     in pipelines: 56(GETNEXT)
|
69:NESTED LOOP JOIN [CROSS JOIN]
|  mem-estimate=8B mem-reservation=0B thread-reservation=0
|  tuple-ids=4,10,16,22,28,34,40 row-size=56B cardinality=1
|  in pipelines: 07(GETNEXT), 55(OPEN)
|
|--55:AGGREGATE [FINALIZE]
|  |  output: count(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=40 row-size=8B cardinality=1
|  |  in pipelines: 55(GETNEXT), 48(OPEN)
|  |
|  54: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=36,38,37,39 row-size=56B cardinality=2.27K
|  |  in pipelines: 48(GETNEXT), 51(OPEN)
|  |
|  |--51:SCAN HDFS [tpcds_parquet.store]
|  |     HDFS partitions=1/1 files=1 size=9.93KB
|  |     predicates: store.s_store_name = 'ese'
|  |     stored statistics:
|  |       table: rows=12 size=9.93KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=12
|  |     parquet statistics predicates: store.s_store_name = 'ese'
|  |     parquet dictionary predicates: store.s_store_name = 'ese'
|  |     mem-estimate=32.00MB mem-reservation=16.00KB thread-reservation=1
|  |     tuple-ids=39 row-size=20B cardinality=2
|  |     in pipelines: 51(GETNEXT)
|  |
|  53:HASH JOIN [INNER JOIN]
|  |  hash predicates: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  fk/pk conjuncts: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=36,38,37 row-size=36B cardinality=6.82K
|  |  in pipelines: 48(GETNEXT), 49(OPEN)
|  |
|  |--49:SCAN HDFS [tpcds_parquet.household_demographics]
|  |     HDFS partitions=1/1 files=1 size=41.69KB
|  |     predicates: ((household_demographics.hd_dep_count = CAST(1 AS INT) AND household_demographics.hd_vehicle_count <= CAST(3 AS INT)) OR (household_demographics.hd_dep_count = CAST(0 AS INT) AND household_demographics.hd_vehicle_count <= CAST(2 AS INT)) OR (household_demographics.hd_dep_count = CAST(2 AS INT) AND household_demographics.hd_vehicle_count <= CAST(4 AS INT)))
|  |     stored statistics:
|  |       table: rows=7.20K size=41.69KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=7.20K
|  |     mem-estimate=48.00MB mem-reservation=64.00KB thread-reservation=1
|  |     tuple-ids=37 row-size=12B cardinality=720
|  |     in pipelines: 49(GETNEXT)
|  |
|  52:HASH JOIN [INNER JOIN]
|  |  hash predicates: ss_sold_time_sk = time_dim.t_time_sk
|  |  fk/pk conjuncts: ss_sold_time_sk = time_dim.t_time_sk
|  |  runtime filters: RF040[bloom] <- time_dim.t_time_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=36,38 row-size=24B cardinality=69.82K
|  |  in pipelines: 48(GETNEXT), 50(OPEN)
|  |
|  |--50:SCAN HDFS [tpcds_parquet.time_dim]
|  |     HDFS partitions=1/1 files=1 size=1.31MB
|  |     predicates: time_dim.t_hour = CAST(11 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|  |     stored statistics:
|  |       table: rows=86.40K size=1.31MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=86.40K
|  |     parquet statistics predicates: time_dim.t_hour = CAST(11 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|  |     parquet dictionary predicates: time_dim.t_hour = CAST(11 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|  |     mem-estimate=48.00MB mem-reservation=512.00KB thread-reservation=1
|  |     tuple-ids=38 row-size=12B cardinality=1.14K
|  |     in pipelines: 50(GETNEXT)
|  |
|  48:SCAN HDFS [tpcds_parquet.store_sales]
|     HDFS partitions=1824/1824 files=1824 size=200.95MB
|     runtime filters: RF040[bloom] -> ss_sold_time_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=48.00MB mem-reservation=1.00MB thread-reservation=1
|     tuple-ids=36 row-size=12B cardinality=2.88M
|     in pipelines: 48(GETNEXT)
|
68:NESTED LOOP JOIN [CROSS JOIN]
|  mem-estimate=8B mem-reservation=0B thread-reservation=0
|  tuple-ids=4,10,16,22,28,34 row-size=48B cardinality=1
|  in pipelines: 07(GETNEXT), 47(OPEN)
|
|--47:AGGREGATE [FINALIZE]
|  |  output: count(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=34 row-size=8B cardinality=1
|  |  in pipelines: 47(GETNEXT), 40(OPEN)
|  |
|  46: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=30,32,31,33 row-size=56B cardinality=2.27K
|  |  in pipelines: 40(GETNEXT), 43(OPEN)
|  |
|  |--43:SCAN HDFS [tpcds_parquet.store]
|  |     HDFS partitions=1/1 files=1 size=9.93KB
|  |     predicates: store.s_store_name = 'ese'
|  |     stored statistics:
|  |       table: rows=12 size=9.93KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=12
|  |     parquet statistics predicates: store.s_store_name = 'ese'
|  |     parquet dictionary predicates: store.s_store_name = 'ese'
|  |     mem-estimate=32.00MB mem-reservation=16.00KB thread-reservation=1
|  |     tuple-ids=33 row-size=20B cardinality=2
|  |     in pipelines: 43(GETNEXT)
|  |
|  45:HASH JOIN [INNER JOIN]
|  |  hash predicates: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  fk/pk conjuncts: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=30,32,31 row-size=36B cardinality=6.82K
|  |  in pipelines: 40(GETNEXT), 41(OPEN)
|  |
|  |--41:SCAN HDFS [tpcds_parquet.household_demographics]
|  |     HDFS partitions=1/1 files=1 size=41.69KB
|  |     predicates: ((household_demographics.hd_dep_count = CAST(1 AS INT) AND household_demographics.hd_vehicle_count <= CAST(3 AS INT)) OR (household_demographics.hd_dep_count = CAST(0 AS INT) AND household_demographics.hd_vehicle_count <= CAST(2 AS INT)) OR (household_demographics.hd_dep_count = CAST(2 AS INT) AND household_demographics.hd_vehicle_count <= CAST(4 AS INT)))
|  |     stored statistics:
|  |       table: rows=7.20K size=41.69KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=7.20K
|  |     mem-estimate=48.00MB mem-reservation=64.00KB thread-reservation=1
|  |     tuple-ids=31 row-size=12B cardinality=720
|  |     in pipelines: 41(GETNEXT)
|  |
|  44:HASH JOIN [INNER JOIN]
|  |  hash predicates: ss_sold_time_sk = time_dim.t_time_sk
|  |  fk/pk conjuncts: ss_sold_time_sk = time_dim.t_time_sk
|  |  runtime filters: RF034[bloom] <- time_dim.t_time_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=30,32 row-size=24B cardinality=69.82K
|  |  in pipelines: 40(GETNEXT), 42(OPEN)
|  |
|  |--42:SCAN HDFS [tpcds_parquet.time_dim]
|  |     HDFS partitions=1/1 files=1 size=1.31MB
|  |     predicates: time_dim.t_hour = CAST(11 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     stored statistics:
|  |       table: rows=86.40K size=1.31MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=86.40K
|  |     parquet statistics predicates: time_dim.t_hour = CAST(11 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     parquet dictionary predicates: time_dim.t_hour = CAST(11 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     mem-estimate=48.00MB mem-reservation=512.00KB thread-reservation=1
|  |     tuple-ids=32 row-size=12B cardinality=1.14K
|  |     in pipelines: 42(GETNEXT)
|  |
|  40:SCAN HDFS [tpcds_parquet.store_sales]
|     HDFS partitions=1824/1824 files=1824 size=200.95MB
|     runtime filters: RF034[bloom] -> ss_sold_time_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=48.00MB mem-reservation=1.00MB thread-reservation=1
|     tuple-ids=30 row-size=12B cardinality=2.88M
|     in pipelines: 40(GETNEXT)
|
67:NESTED LOOP JOIN [CROSS JOIN]
|  mem-estimate=8B mem-reservation=0B thread-reservation=0
|  tuple-ids=4,10,16,22,28 row-size=40B cardinality=1
|  in pipelines: 07(GETNEXT), 39(OPEN)
|
|--39:AGGREGATE [FINALIZE]
|  |  output: count(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=28 row-size=8B cardinality=1
|  |  in pipelines: 39(GETNEXT), 32(OPEN)
|  |
|  38: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,26,25,27 row-size=56B cardinality=2.27K
|  |  in pipelines: 32(GETNEXT), 35(OPEN)
|  |
|  |--35:SCAN HDFS [tpcds_parquet.store]
|  |     HDFS partitions=1/1 files=1 size=9.93KB
|  |     predicates: store.s_store_name = 'ese'
|  |     stored statistics:
|  |       table: rows=12 size=9.93KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=12
|  |     parquet statistics predicates: store.s_store_name = 'ese'
|  |     parquet dictionary predicates: store.s_store_name = 'ese'
|  |     mem-estimate=32.00MB mem-reservation=16.00KB thread-reservation=1
|  |     tuple-ids=27 row-size=20B cardinality=2
|  |     in pipelines: 35(GETNEXT)
|  |
|  37:HASH JOIN [INNER JOIN]
|  |  hash predicates: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  fk/pk conjuncts: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=24,26,25 row-size=36B cardinality=6.82K
|  |  in pipelines: 32(GETNEXT), 33(OPEN)
|  |
|  |--33:SCAN HDFS [tpcds_parquet.household_demographics]
|  |     HDFS partitions=1/1 files=1 size=41.69KB
|  |     predicates: ((household_demographics.hd_dep_count = CAST(1 AS INT) AND household_demographics.hd_vehicle_count <= CAST(3 AS INT)) OR (household_demographics.hd_dep_count = CAST(0 AS INT) AND household_demographics.hd_vehicle_count <= CAST(2 AS INT)) OR (household_demographics.hd_dep_count = CAST(2 AS INT) AND household_demographics.hd_vehicle_count <= CAST(4 AS INT)))
|  |     stored statistics:
|  |       table: rows=7.20K size=41.69KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=7.20K
|  |     mem-estimate=48.00MB mem-reservation=64.00KB thread-reservation=1
|  |     tuple-ids=25 row-size=12B cardinality=720
|  |     in pipelines: 33(GETNEXT)
|  |
|  36:HASH JOIN [INNER JOIN]
|  |  hash predicates: ss_sold_time_sk = time_dim.t_time_sk
|  |  fk/pk conjuncts: ss_sold_time_sk = time_dim.t_time_sk
|  |  runtime filters: RF028[bloom] <- time_dim.t_time_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=24,26 row-size=24B cardinality=69.82K
|  |  in pipelines: 32(GETNEXT), 34(OPEN)
|  |
|  |--34:SCAN HDFS [tpcds_parquet.time_dim]
|  |     HDFS partitions=1/1 files=1 size=1.31MB
|  |     predicates: time_dim.t_hour = CAST(10 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|  |     stored statistics:
|  |       table: rows=86.40K size=1.31MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=86.40K
|  |     parquet statistics predicates: time_dim.t_hour = CAST(10 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|  |     parquet dictionary predicates: time_dim.t_hour = CAST(10 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|  |     mem-estimate=48.00MB mem-reservation=512.00KB thread-reservation=1
|  |     tuple-ids=26 row-size=12B cardinality=1.14K
|  |     in pipelines: 34(GETNEXT)
|  |
|  32:SCAN HDFS [tpcds_parquet.store_sales]
|     HDFS partitions=1824/1824 files=1824 size=200.95MB
|     runtime filters: RF028[bloom] -> ss_sold_time_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=48.00MB mem-reservation=1.00MB thread-reservation=1
|     tuple-ids=24 row-size=12B cardinality=2.88M
|     in pipelines: 32(GETNEXT)
|
66:NESTED LOOP JOIN [CROSS JOIN]
|  mem-estimate=8B mem-reservation=0B thread-reservation=0
|  tuple-ids=4,10,16,22 row-size=32B cardinality=1
|  in pipelines: 07(GETNEXT), 31(OPEN)
|
|--31:AGGREGATE [FINALIZE]
|  |  output: count(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=22 row-size=8B cardinality=1
|  |  in pipelines: 31(GETNEXT), 24(OPEN)
|  |
|  30: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=18,20,19,21 row-size=56B cardinality=2.27K
|  |  in pipelines: 24(GETNEXT), 27(OPEN)
|  |
|  |--27:SCAN HDFS [tpcds_parquet.store]
|  |     HDFS partitions=1/1 files=1 size=9.93KB
|  |     predicates: store.s_store_name = 'ese'
|  |     stored statistics:
|  |       table: rows=12 size=9.93KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=12
|  |     parquet statistics predicates: store.s_store_name = 'ese'
|  |     parquet dictionary predicates: store.s_store_name = 'ese'
|  |     mem-estimate=32.00MB mem-reservation=16.00KB thread-reservation=1
|  |     tuple-ids=21 row-size=20B cardinality=2
|  |     in pipelines: 27(GETNEXT)
|  |
|  29:HASH JOIN [INNER JOIN]
|  |  hash predicates: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  fk/pk conjuncts: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=18,20,19 row-size=36B cardinality=6.82K
|  |  in pipelines: 24(GETNEXT), 25(OPEN)
|  |
|  |--25:SCAN HDFS [tpcds_parquet.household_demographics]
|  |     HDFS partitions=1/1 files=1 size=41.69KB
|  |     predicates: ((household_demographics.hd_dep_count = CAST(1 AS INT) AND household_demographics.hd_vehicle_count <= CAST(3 AS INT)) OR (household_demographics.hd_dep_count = CAST(0 AS INT) AND household_demographics.hd_vehicle_count <= CAST(2 AS INT)) OR (household_demographics.hd_dep_count = CAST(2 AS INT) AND household_demographics.hd_vehicle_count <= CAST(4 AS INT)))
|  |     stored statistics:
|  |       table: rows=7.20K size=41.69KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=7.20K
|  |     mem-estimate=48.00MB mem-reservation=64.00KB thread-reservation=1
|  |     tuple-ids=19 row-size=12B cardinality=720
|  |     in pipelines: 25(GETNEXT)
|  |
|  28:HASH JOIN [INNER JOIN]
|  |  hash predicates: ss_sold_time_sk = time_dim.t_time_sk
|  |  fk/pk conjuncts: ss_sold_time_sk = time_dim.t_time_sk
|  |  runtime filters: RF022[bloom] <- time_dim.t_time_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=18,20 row-size=24B cardinality=69.82K
|  |  in pipelines: 24(GETNEXT), 26(OPEN)
|  |
|  |--26:SCAN HDFS [tpcds_parquet.time_dim]
|  |     HDFS partitions=1/1 files=1 size=1.31MB
|  |     predicates: time_dim.t_hour = CAST(10 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     stored statistics:
|  |       table: rows=86.40K size=1.31MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=86.40K
|  |     parquet statistics predicates: time_dim.t_hour = CAST(10 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     parquet dictionary predicates: time_dim.t_hour = CAST(10 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     mem-estimate=48.00MB mem-reservation=512.00KB thread-reservation=1
|  |     tuple-ids=20 row-size=12B cardinality=1.14K
|  |     in pipelines: 26(GETNEXT)
|  |
|  24:SCAN HDFS [tpcds_parquet.store_sales]
|     HDFS partitions=1824/1824 files=1824 size=200.95MB
|     runtime filters: RF022[bloom] -> ss_sold_time_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=48.00MB mem-reservation=1.00MB thread-reservation=1
|     tuple-ids=18 row-size=12B cardinality=2.88M
|     in pipelines: 24(GETNEXT)
|
65:NESTED LOOP JOIN [CROSS JOIN]
|  mem-estimate=8B mem-reservation=0B thread-reservation=0
|  tuple-ids=4,10,16 row-size=24B cardinality=1
|  in pipelines: 07(GETNEXT), 23(OPEN)
|
|--23:AGGREGATE [FINALIZE]
|  |  output: count(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=16 row-size=8B cardinality=1
|  |  in pipelines: 23(GETNEXT), 16(OPEN)
|  |
|  22: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=12,14,13,15 row-size=56B cardinality=2.27K
|  |  in pipelines: 16(GETNEXT), 19(OPEN)
|  |
|  |--19:SCAN HDFS [tpcds_parquet.store]
|  |     HDFS partitions=1/1 files=1 size=9.93KB
|  |     predicates: store.s_store_name = 'ese'
|  |     stored statistics:
|  |       table: rows=12 size=9.93KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=12
|  |     parquet statistics predicates: store.s_store_name = 'ese'
|  |     parquet dictionary predicates: store.s_store_name = 'ese'
|  |     mem-estimate=32.00MB mem-reservation=16.00KB thread-reservation=1
|  |     tuple-ids=15 row-size=20B cardinality=2
|  |     in pipelines: 19(GETNEXT)
|  |
|  21:HASH JOIN [INNER JOIN]
|  |  hash predicates: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  fk/pk conjuncts: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=12,14,13 row-size=36B cardinality=6.82K
|  |  in pipelines: 16(GETNEXT), 17(OPEN)
|  |
|  |--17:SCAN HDFS [tpcds_parquet.household_demographics]
|  |     HDFS partitions=1/1 files=1 size=41.69KB
|  |     predicates: ((household_demographics.hd_dep_count = CAST(1 AS INT) AND household_demographics.hd_vehicle_count <= CAST(3 AS INT)) OR (household_demographics.hd_dep_count = CAST(0 AS INT) AND household_demographics.hd_vehicle_count <= CAST(2 AS INT)) OR (household_demographics.hd_dep_count = CAST(2 AS INT) AND household_demographics.hd_vehicle_count <= CAST(4 AS INT)))
|  |     stored statistics:
|  |       table: rows=7.20K size=41.69KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=7.20K
|  |     mem-estimate=48.00MB mem-reservation=64.00KB thread-reservation=1
|  |     tuple-ids=13 row-size=12B cardinality=720
|  |     in pipelines: 17(GETNEXT)
|  |
|  20:HASH JOIN [INNER JOIN]
|  |  hash predicates: ss_sold_time_sk = time_dim.t_time_sk
|  |  fk/pk conjuncts: ss_sold_time_sk = time_dim.t_time_sk
|  |  runtime filters: RF016[bloom] <- time_dim.t_time_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=12,14 row-size=24B cardinality=69.82K
|  |  in pipelines: 16(GETNEXT), 18(OPEN)
|  |
|  |--18:SCAN HDFS [tpcds_parquet.time_dim]
|  |     HDFS partitions=1/1 files=1 size=1.31MB
|  |     predicates: time_dim.t_hour = CAST(9 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|  |     stored statistics:
|  |       table: rows=86.40K size=1.31MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=86.40K
|  |     parquet statistics predicates: time_dim.t_hour = CAST(9 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|  |     parquet dictionary predicates: time_dim.t_hour = CAST(9 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|  |     mem-estimate=48.00MB mem-reservation=512.00KB thread-reservation=1
|  |     tuple-ids=14 row-size=12B cardinality=1.14K
|  |     in pipelines: 18(GETNEXT)
|  |
|  16:SCAN HDFS [tpcds_parquet.store_sales]
|     HDFS partitions=1824/1824 files=1824 size=200.95MB
|     runtime filters: RF016[bloom] -> ss_sold_time_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=48.00MB mem-reservation=1.00MB thread-reservation=1
|     tuple-ids=12 row-size=12B cardinality=2.88M
|     in pipelines: 16(GETNEXT)
|
64:NESTED LOOP JOIN [CROSS JOIN]
|  mem-estimate=8B mem-reservation=0B thread-reservation=0
|  tuple-ids=4,10 row-size=16B cardinality=1
|  in pipelines: 07(GETNEXT), 15(OPEN)
|
|--15:AGGREGATE [FINALIZE]
|  |  output: count(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=10 row-size=8B cardinality=1
|  |  in pipelines: 15(GETNEXT), 08(OPEN)
|  |
|  14: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=6,8,7,9 row-size=56B cardinality=2.27K
|  |  in pipelines: 08(GETNEXT), 11(OPEN)
|  |
|  |--11:SCAN HDFS [tpcds_parquet.store]
|  |     HDFS partitions=1/1 files=1 size=9.93KB
|  |     predicates: store.s_store_name = 'ese'
|  |     stored statistics:
|  |       table: rows=12 size=9.93KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=12
|  |     parquet statistics predicates: store.s_store_name = 'ese'
|  |     parquet dictionary predicates: store.s_store_name = 'ese'
|  |     mem-estimate=32.00MB mem-reservation=16.00KB thread-reservation=1
|  |     tuple-ids=9 row-size=20B cardinality=2
|  |     in pipelines: 11(GETNEXT)
|  |
|  13:HASH JOIN [INNER JOIN]
|  |  hash predicates: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  fk/pk conjuncts: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  runtime filters: RF008[bloom] <- household_demographics.hd_demo_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=6,8,7 row-size=36B cardinality=6.82K
|  |  in pipelines: 08(GETNEXT), 09(OPEN)
|  |
|  |--09:SCAN HDFS [tpcds_parquet.household_demographics]
|  |     HDFS partitions=1/1 files=1 size=41.69KB
|  |     predicates: ((household_demographics.hd_dep_count = CAST(1 AS INT) AND household_demographics.hd_vehicle_count <= CAST(3 AS INT)) OR (household_demographics.hd_dep_count = CAST(0 AS INT) AND household_demographics.hd_vehicle_count <= CAST(2 AS INT)) OR (household_demographics.hd_dep_count = CAST(2 AS INT) AND household_demographics.hd_vehicle_count <= CAST(4 AS INT)))
|  |     stored statistics:
|  |       table: rows=7.20K size=41.69KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=7.20K
|  |     mem-estimate=48.00MB mem-reservation=64.00KB thread-reservation=1
|  |     tuple-ids=7 row-size=12B cardinality=720
|  |     in pipelines: 09(GETNEXT)
|  |
|  12:HASH JOIN [INNER JOIN]
|  |  hash predicates: ss_sold_time_sk = time_dim.t_time_sk
|  |  fk/pk conjuncts: ss_sold_time_sk = time_dim.t_time_sk
|  |  runtime filters: RF010[bloom] <- time_dim.t_time_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=6,8 row-size=24B cardinality=69.82K
|  |  in pipelines: 08(GETNEXT), 10(OPEN)
|  |
|  |--10:SCAN HDFS [tpcds_parquet.time_dim]
|  |     HDFS partitions=1/1 files=1 size=1.31MB
|  |     predicates: time_dim.t_hour = CAST(9 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     stored statistics:
|  |       table: rows=86.40K size=1.31MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=86.40K
|  |     parquet statistics predicates: time_dim.t_hour = CAST(9 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     parquet dictionary predicates: time_dim.t_hour = CAST(9 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     mem-estimate=48.00MB mem-reservation=512.00KB thread-reservation=1
|  |     tuple-ids=8 row-size=12B cardinality=1.14K
|  |     in pipelines: 10(GETNEXT)
|  |
|  08:SCAN HDFS [tpcds_parquet.store_sales]
|     HDFS partitions=1824/1824 files=1824 size=200.95MB
|     runtime filters: RF010[bloom] -> ss_sold_time_sk, RF008[bloom] -> ss_hdemo_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=48.00MB mem-reservation=1.00MB thread-reservation=1
|     tuple-ids=6 row-size=12B cardinality=2.88M
|     in pipelines: 08(GETNEXT)
|
07:AGGREGATE [FINALIZE]
|  output: count(*)
|  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  tuple-ids=4 row-size=8B cardinality=1
|  in pipelines: 07(GETNEXT), 00(OPEN)
|
06: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=0,2,1,3 row-size=56B cardinality=2.27K
|  in pipelines: 00(GETNEXT), 03(OPEN)
|
|--03:SCAN HDFS [tpcds_parquet.store]
|     HDFS partitions=1/1 files=1 size=9.93KB
|     predicates: store.s_store_name = 'ese'
|     stored statistics:
|       table: rows=12 size=9.93KB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=12
|     parquet statistics predicates: store.s_store_name = 'ese'
|     parquet dictionary predicates: store.s_store_name = 'ese'
|     mem-estimate=32.00MB mem-reservation=16.00KB thread-reservation=1
|     tuple-ids=3 row-size=20B cardinality=2
|     in pipelines: 03(GETNEXT)
|
05:HASH JOIN [INNER JOIN]
|  hash predicates: ss_hdemo_sk = household_demographics.hd_demo_sk
|  fk/pk conjuncts: ss_hdemo_sk = household_demographics.hd_demo_sk
|  runtime filters: RF002[bloom] <- household_demographics.hd_demo_sk
|  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=0,2,1 row-size=36B cardinality=6.82K
|  in pipelines: 00(GETNEXT), 01(OPEN)
|
|--01:SCAN HDFS [tpcds_parquet.household_demographics]
|     HDFS partitions=1/1 files=1 size=41.69KB
|     predicates: ((household_demographics.hd_dep_count = CAST(1 AS INT) AND household_demographics.hd_vehicle_count <= CAST(3 AS INT)) OR (household_demographics.hd_dep_count = CAST(0 AS INT) AND household_demographics.hd_vehicle_count <= CAST(2 AS INT)) OR (household_demographics.hd_dep_count = CAST(2 AS INT) AND household_demographics.hd_vehicle_count <= CAST(4 AS INT)))
|     stored statistics:
|       table: rows=7.20K size=41.69KB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=7.20K
|     mem-estimate=48.00MB mem-reservation=64.00KB thread-reservation=1
|     tuple-ids=1 row-size=12B cardinality=720
|     in pipelines: 01(GETNEXT)
|
04:HASH JOIN [INNER JOIN]
|  hash predicates: ss_sold_time_sk = time_dim.t_time_sk
|  fk/pk conjuncts: ss_sold_time_sk = time_dim.t_time_sk
|  runtime filters: RF004[bloom] <- time_dim.t_time_sk
|  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=0,2 row-size=24B cardinality=69.82K
|  in pipelines: 00(GETNEXT), 02(OPEN)
|
|--02:SCAN HDFS [tpcds_parquet.time_dim]
|     HDFS partitions=1/1 files=1 size=1.31MB
|     predicates: time_dim.t_hour = CAST(8 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|     stored statistics:
|       table: rows=86.40K size=1.31MB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=86.40K
|     parquet statistics predicates: time_dim.t_hour = CAST(8 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|     parquet dictionary predicates: time_dim.t_hour = CAST(8 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|     mem-estimate=48.00MB mem-reservation=512.00KB thread-reservation=1
|     tuple-ids=2 row-size=12B cardinality=1.14K
|     in pipelines: 02(GETNEXT)
|
00:SCAN HDFS [tpcds_parquet.store_sales]
   HDFS partitions=1824/1824 files=1824 size=200.95MB
   runtime filters: RF004[bloom] -> ss_sold_time_sk, RF002[bloom] -> ss_hdemo_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=48.00MB mem-reservation=1.00MB thread-reservation=1
   tuple-ids=0 row-size=12B cardinality=2.88M
   in pipelines: 00(GETNEXT)
---- DISTRIBUTEDPLAN
Max Per-Host Resource Reservation: Memory=69.12MB Threads=72
Per-Host Resource Estimates: Memory=1.59GB
F04:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
|  Per-Host Resources: mem-estimate=10.13MB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
|  output exprs: count(*), count(*), count(*), count(*), count(*), count(*), count(*), count(*)
|  mem-estimate=0B mem-reservation=0B thread-reservation=0
|
70:NESTED LOOP JOIN [CROSS JOIN, BROADCAST]
|  mem-estimate=8B mem-reservation=0B thread-reservation=0
|  tuple-ids=4,10,16,22,28,34,40,46 row-size=64B cardinality=1
|  in pipelines: 75(GETNEXT), 116(OPEN)
|
|--117:EXCHANGE [UNPARTITIONED]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=46 row-size=8B cardinality=1
|  |  in pipelines: 116(GETNEXT)
|  |
|  F39:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
|  Per-Host Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1
|  116:AGGREGATE [FINALIZE]
|  |  output: count:merge(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=46 row-size=8B cardinality=1
|  |  in pipelines: 116(GETNEXT), 63(OPEN)
|  |
|  115:EXCHANGE [UNPARTITIONED]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=46 row-size=8B cardinality=1
|  |  in pipelines: 63(GETNEXT)
|  |
|  F35:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  Per-Host Resources: mem-estimate=64.81MB mem-reservation=7.81MB thread-reservation=2 runtime-filters-memory=1.00MB
|  63:AGGREGATE
|  |  output: count(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=46 row-size=8B cardinality=1
|  |  in pipelines: 63(GETNEXT), 56(OPEN)
|  |
|  62: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=42,44,43,45 row-size=56B cardinality=2.27K
|  |  in pipelines: 56(GETNEXT), 59(OPEN)
|  |
|  |--114:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=45 row-size=20B cardinality=2
|  |  |  in pipelines: 59(GETNEXT)
|  |  |
|  |  F38:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=32.00MB mem-reservation=16.00KB thread-reservation=2
|  |  59:SCAN HDFS [tpcds_parquet.store, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=9.93KB
|  |     predicates: store.s_store_name = 'ese'
|  |     stored statistics:
|  |       table: rows=12 size=9.93KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=12
|  |     parquet statistics predicates: store.s_store_name = 'ese'
|  |     parquet dictionary predicates: store.s_store_name = 'ese'
|  |     mem-estimate=32.00MB mem-reservation=16.00KB thread-reservation=1
|  |     tuple-ids=45 row-size=20B cardinality=2
|  |     in pipelines: 59(GETNEXT)
|  |
|  61:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash predicates: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  fk/pk conjuncts: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=42,44,43 row-size=36B cardinality=6.82K
|  |  in pipelines: 56(GETNEXT), 57(OPEN)
|  |
|  |--113:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=19.69KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=43 row-size=12B cardinality=720
|  |  |  in pipelines: 57(GETNEXT)
|  |  |
|  |  F37:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=48.00MB mem-reservation=64.00KB thread-reservation=2
|  |  57:SCAN HDFS [tpcds_parquet.household_demographics, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=41.69KB
|  |     predicates: ((household_demographics.hd_dep_count = CAST(1 AS INT) AND household_demographics.hd_vehicle_count <= CAST(3 AS INT)) OR (household_demographics.hd_dep_count = CAST(0 AS INT) AND household_demographics.hd_vehicle_count <= CAST(2 AS INT)) OR (household_demographics.hd_dep_count = CAST(2 AS INT) AND household_demographics.hd_vehicle_count <= CAST(4 AS INT)))
|  |     stored statistics:
|  |       table: rows=7.20K size=41.69KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=7.20K
|  |     mem-estimate=48.00MB mem-reservation=64.00KB thread-reservation=1
|  |     tuple-ids=43 row-size=12B cardinality=720
|  |     in pipelines: 57(GETNEXT)
|  |
|  60:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash predicates: ss_sold_time_sk = time_dim.t_time_sk
|  |  fk/pk conjuncts: ss_sold_time_sk = time_dim.t_time_sk
|  |  runtime filters: RF046[bloom] <- time_dim.t_time_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=42,44 row-size=24B cardinality=69.82K
|  |  in pipelines: 56(GETNEXT), 58(OPEN)
|  |
|  |--112:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=29.34KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=44 row-size=12B cardinality=1.14K
|  |  |  in pipelines: 58(GETNEXT)
|  |  |
|  |  F36:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=48.00MB mem-reservation=512.00KB thread-reservation=2
|  |  58:SCAN HDFS [tpcds_parquet.time_dim, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=1.31MB
|  |     predicates: time_dim.t_hour = CAST(12 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     stored statistics:
|  |       table: rows=86.40K size=1.31MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=86.40K
|  |     parquet statistics predicates: time_dim.t_hour = CAST(12 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     parquet dictionary predicates: time_dim.t_hour = CAST(12 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     mem-estimate=48.00MB mem-reservation=512.00KB thread-reservation=1
|  |     tuple-ids=44 row-size=12B cardinality=1.14K
|  |     in pipelines: 58(GETNEXT)
|  |
|  56:SCAN HDFS [tpcds_parquet.store_sales, RANDOM]
|     HDFS partitions=1824/1824 files=1824 size=200.95MB
|     runtime filters: RF046[bloom] -> ss_sold_time_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=48.00MB mem-reservation=1.00MB thread-reservation=1
|     tuple-ids=42 row-size=12B cardinality=2.88M
|     in pipelines: 56(GETNEXT)
|
69:NESTED LOOP JOIN [CROSS JOIN, BROADCAST]
|  mem-estimate=8B mem-reservation=0B thread-reservation=0
|  tuple-ids=4,10,16,22,28,34,40 row-size=56B cardinality=1
|  in pipelines: 75(GETNEXT), 110(OPEN)
|
|--111:EXCHANGE [UNPARTITIONED]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=40 row-size=8B cardinality=1
|  |  in pipelines: 110(GETNEXT)
|  |
|  F34:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
|  Per-Host Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1
|  110:AGGREGATE [FINALIZE]
|  |  output: count:merge(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=40 row-size=8B cardinality=1
|  |  in pipelines: 110(GETNEXT), 55(OPEN)
|  |
|  109:EXCHANGE [UNPARTITIONED]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=40 row-size=8B cardinality=1
|  |  in pipelines: 55(GETNEXT)
|  |
|  F30:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  Per-Host Resources: mem-estimate=64.81MB mem-reservation=7.81MB thread-reservation=2 runtime-filters-memory=1.00MB
|  55:AGGREGATE
|  |  output: count(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=40 row-size=8B cardinality=1
|  |  in pipelines: 55(GETNEXT), 48(OPEN)
|  |
|  54: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=36,38,37,39 row-size=56B cardinality=2.27K
|  |  in pipelines: 48(GETNEXT), 51(OPEN)
|  |
|  |--108:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=39 row-size=20B cardinality=2
|  |  |  in pipelines: 51(GETNEXT)
|  |  |
|  |  F33:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=32.00MB mem-reservation=16.00KB thread-reservation=2
|  |  51:SCAN HDFS [tpcds_parquet.store, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=9.93KB
|  |     predicates: store.s_store_name = 'ese'
|  |     stored statistics:
|  |       table: rows=12 size=9.93KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=12
|  |     parquet statistics predicates: store.s_store_name = 'ese'
|  |     parquet dictionary predicates: store.s_store_name = 'ese'
|  |     mem-estimate=32.00MB mem-reservation=16.00KB thread-reservation=1
|  |     tuple-ids=39 row-size=20B cardinality=2
|  |     in pipelines: 51(GETNEXT)
|  |
|  53:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash predicates: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  fk/pk conjuncts: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=36,38,37 row-size=36B cardinality=6.82K
|  |  in pipelines: 48(GETNEXT), 49(OPEN)
|  |
|  |--107:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=19.69KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=37 row-size=12B cardinality=720
|  |  |  in pipelines: 49(GETNEXT)
|  |  |
|  |  F32:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=48.00MB mem-reservation=64.00KB thread-reservation=2
|  |  49:SCAN HDFS [tpcds_parquet.household_demographics, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=41.69KB
|  |     predicates: ((household_demographics.hd_dep_count = CAST(1 AS INT) AND household_demographics.hd_vehicle_count <= CAST(3 AS INT)) OR (household_demographics.hd_dep_count = CAST(0 AS INT) AND household_demographics.hd_vehicle_count <= CAST(2 AS INT)) OR (household_demographics.hd_dep_count = CAST(2 AS INT) AND household_demographics.hd_vehicle_count <= CAST(4 AS INT)))
|  |     stored statistics:
|  |       table: rows=7.20K size=41.69KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=7.20K
|  |     mem-estimate=48.00MB mem-reservation=64.00KB thread-reservation=1
|  |     tuple-ids=37 row-size=12B cardinality=720
|  |     in pipelines: 49(GETNEXT)
|  |
|  52:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash predicates: ss_sold_time_sk = time_dim.t_time_sk
|  |  fk/pk conjuncts: ss_sold_time_sk = time_dim.t_time_sk
|  |  runtime filters: RF040[bloom] <- time_dim.t_time_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=36,38 row-size=24B cardinality=69.82K
|  |  in pipelines: 48(GETNEXT), 50(OPEN)
|  |
|  |--106:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=29.34KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=38 row-size=12B cardinality=1.14K
|  |  |  in pipelines: 50(GETNEXT)
|  |  |
|  |  F31:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=48.00MB mem-reservation=512.00KB thread-reservation=2
|  |  50:SCAN HDFS [tpcds_parquet.time_dim, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=1.31MB
|  |     predicates: time_dim.t_hour = CAST(11 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|  |     stored statistics:
|  |       table: rows=86.40K size=1.31MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=86.40K
|  |     parquet statistics predicates: time_dim.t_hour = CAST(11 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|  |     parquet dictionary predicates: time_dim.t_hour = CAST(11 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|  |     mem-estimate=48.00MB mem-reservation=512.00KB thread-reservation=1
|  |     tuple-ids=38 row-size=12B cardinality=1.14K
|  |     in pipelines: 50(GETNEXT)
|  |
|  48:SCAN HDFS [tpcds_parquet.store_sales, RANDOM]
|     HDFS partitions=1824/1824 files=1824 size=200.95MB
|     runtime filters: RF040[bloom] -> ss_sold_time_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=48.00MB mem-reservation=1.00MB thread-reservation=1
|     tuple-ids=36 row-size=12B cardinality=2.88M
|     in pipelines: 48(GETNEXT)
|
68:NESTED LOOP JOIN [CROSS JOIN, BROADCAST]
|  mem-estimate=8B mem-reservation=0B thread-reservation=0
|  tuple-ids=4,10,16,22,28,34 row-size=48B cardinality=1
|  in pipelines: 75(GETNEXT), 104(OPEN)
|
|--105:EXCHANGE [UNPARTITIONED]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=34 row-size=8B cardinality=1
|  |  in pipelines: 104(GETNEXT)
|  |
|  F29:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
|  Per-Host Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1
|  104:AGGREGATE [FINALIZE]
|  |  output: count:merge(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=34 row-size=8B cardinality=1
|  |  in pipelines: 104(GETNEXT), 47(OPEN)
|  |
|  103:EXCHANGE [UNPARTITIONED]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=34 row-size=8B cardinality=1
|  |  in pipelines: 47(GETNEXT)
|  |
|  F25:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  Per-Host Resources: mem-estimate=64.81MB mem-reservation=7.81MB thread-reservation=2 runtime-filters-memory=1.00MB
|  47:AGGREGATE
|  |  output: count(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=34 row-size=8B cardinality=1
|  |  in pipelines: 47(GETNEXT), 40(OPEN)
|  |
|  46: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=30,32,31,33 row-size=56B cardinality=2.27K
|  |  in pipelines: 40(GETNEXT), 43(OPEN)
|  |
|  |--102:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=33 row-size=20B cardinality=2
|  |  |  in pipelines: 43(GETNEXT)
|  |  |
|  |  F28:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=32.00MB mem-reservation=16.00KB thread-reservation=2
|  |  43:SCAN HDFS [tpcds_parquet.store, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=9.93KB
|  |     predicates: store.s_store_name = 'ese'
|  |     stored statistics:
|  |       table: rows=12 size=9.93KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=12
|  |     parquet statistics predicates: store.s_store_name = 'ese'
|  |     parquet dictionary predicates: store.s_store_name = 'ese'
|  |     mem-estimate=32.00MB mem-reservation=16.00KB thread-reservation=1
|  |     tuple-ids=33 row-size=20B cardinality=2
|  |     in pipelines: 43(GETNEXT)
|  |
|  45:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash predicates: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  fk/pk conjuncts: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=30,32,31 row-size=36B cardinality=6.82K
|  |  in pipelines: 40(GETNEXT), 41(OPEN)
|  |
|  |--101:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=19.69KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=31 row-size=12B cardinality=720
|  |  |  in pipelines: 41(GETNEXT)
|  |  |
|  |  F27:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=48.00MB mem-reservation=64.00KB thread-reservation=2
|  |  41:SCAN HDFS [tpcds_parquet.household_demographics, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=41.69KB
|  |     predicates: ((household_demographics.hd_dep_count = CAST(1 AS INT) AND household_demographics.hd_vehicle_count <= CAST(3 AS INT)) OR (household_demographics.hd_dep_count = CAST(0 AS INT) AND household_demographics.hd_vehicle_count <= CAST(2 AS INT)) OR (household_demographics.hd_dep_count = CAST(2 AS INT) AND household_demographics.hd_vehicle_count <= CAST(4 AS INT)))
|  |     stored statistics:
|  |       table: rows=7.20K size=41.69KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=7.20K
|  |     mem-estimate=48.00MB mem-reservation=64.00KB thread-reservation=1
|  |     tuple-ids=31 row-size=12B cardinality=720
|  |     in pipelines: 41(GETNEXT)
|  |
|  44:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash predicates: ss_sold_time_sk = time_dim.t_time_sk
|  |  fk/pk conjuncts: ss_sold_time_sk = time_dim.t_time_sk
|  |  runtime filters: RF034[bloom] <- time_dim.t_time_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=30,32 row-size=24B cardinality=69.82K
|  |  in pipelines: 40(GETNEXT), 42(OPEN)
|  |
|  |--100:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=29.34KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=32 row-size=12B cardinality=1.14K
|  |  |  in pipelines: 42(GETNEXT)
|  |  |
|  |  F26:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=48.00MB mem-reservation=512.00KB thread-reservation=2
|  |  42:SCAN HDFS [tpcds_parquet.time_dim, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=1.31MB
|  |     predicates: time_dim.t_hour = CAST(11 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     stored statistics:
|  |       table: rows=86.40K size=1.31MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=86.40K
|  |     parquet statistics predicates: time_dim.t_hour = CAST(11 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     parquet dictionary predicates: time_dim.t_hour = CAST(11 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     mem-estimate=48.00MB mem-reservation=512.00KB thread-reservation=1
|  |     tuple-ids=32 row-size=12B cardinality=1.14K
|  |     in pipelines: 42(GETNEXT)
|  |
|  40:SCAN HDFS [tpcds_parquet.store_sales, RANDOM]
|     HDFS partitions=1824/1824 files=1824 size=200.95MB
|     runtime filters: RF034[bloom] -> ss_sold_time_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=48.00MB mem-reservation=1.00MB thread-reservation=1
|     tuple-ids=30 row-size=12B cardinality=2.88M
|     in pipelines: 40(GETNEXT)
|
67:NESTED LOOP JOIN [CROSS JOIN, BROADCAST]
|  mem-estimate=8B mem-reservation=0B thread-reservation=0
|  tuple-ids=4,10,16,22,28 row-size=40B cardinality=1
|  in pipelines: 75(GETNEXT), 98(OPEN)
|
|--99:EXCHANGE [UNPARTITIONED]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=28 row-size=8B cardinality=1
|  |  in pipelines: 98(GETNEXT)
|  |
|  F24:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
|  Per-Host Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1
|  98:AGGREGATE [FINALIZE]
|  |  output: count:merge(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=28 row-size=8B cardinality=1
|  |  in pipelines: 98(GETNEXT), 39(OPEN)
|  |
|  97:EXCHANGE [UNPARTITIONED]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=28 row-size=8B cardinality=1
|  |  in pipelines: 39(GETNEXT)
|  |
|  F20:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  Per-Host Resources: mem-estimate=64.81MB mem-reservation=7.81MB thread-reservation=2 runtime-filters-memory=1.00MB
|  39:AGGREGATE
|  |  output: count(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=28 row-size=8B cardinality=1
|  |  in pipelines: 39(GETNEXT), 32(OPEN)
|  |
|  38: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=24,26,25,27 row-size=56B cardinality=2.27K
|  |  in pipelines: 32(GETNEXT), 35(OPEN)
|  |
|  |--96:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=27 row-size=20B cardinality=2
|  |  |  in pipelines: 35(GETNEXT)
|  |  |
|  |  F23:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=32.00MB mem-reservation=16.00KB thread-reservation=2
|  |  35:SCAN HDFS [tpcds_parquet.store, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=9.93KB
|  |     predicates: store.s_store_name = 'ese'
|  |     stored statistics:
|  |       table: rows=12 size=9.93KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=12
|  |     parquet statistics predicates: store.s_store_name = 'ese'
|  |     parquet dictionary predicates: store.s_store_name = 'ese'
|  |     mem-estimate=32.00MB mem-reservation=16.00KB thread-reservation=1
|  |     tuple-ids=27 row-size=20B cardinality=2
|  |     in pipelines: 35(GETNEXT)
|  |
|  37:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash predicates: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  fk/pk conjuncts: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=24,26,25 row-size=36B cardinality=6.82K
|  |  in pipelines: 32(GETNEXT), 33(OPEN)
|  |
|  |--95:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=19.69KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=25 row-size=12B cardinality=720
|  |  |  in pipelines: 33(GETNEXT)
|  |  |
|  |  F22:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=48.00MB mem-reservation=64.00KB thread-reservation=2
|  |  33:SCAN HDFS [tpcds_parquet.household_demographics, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=41.69KB
|  |     predicates: ((household_demographics.hd_dep_count = CAST(1 AS INT) AND household_demographics.hd_vehicle_count <= CAST(3 AS INT)) OR (household_demographics.hd_dep_count = CAST(0 AS INT) AND household_demographics.hd_vehicle_count <= CAST(2 AS INT)) OR (household_demographics.hd_dep_count = CAST(2 AS INT) AND household_demographics.hd_vehicle_count <= CAST(4 AS INT)))
|  |     stored statistics:
|  |       table: rows=7.20K size=41.69KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=7.20K
|  |     mem-estimate=48.00MB mem-reservation=64.00KB thread-reservation=1
|  |     tuple-ids=25 row-size=12B cardinality=720
|  |     in pipelines: 33(GETNEXT)
|  |
|  36:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash predicates: ss_sold_time_sk = time_dim.t_time_sk
|  |  fk/pk conjuncts: ss_sold_time_sk = time_dim.t_time_sk
|  |  runtime filters: RF028[bloom] <- time_dim.t_time_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=24,26 row-size=24B cardinality=69.82K
|  |  in pipelines: 32(GETNEXT), 34(OPEN)
|  |
|  |--94:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=29.34KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=26 row-size=12B cardinality=1.14K
|  |  |  in pipelines: 34(GETNEXT)
|  |  |
|  |  F21:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=48.00MB mem-reservation=512.00KB thread-reservation=2
|  |  34:SCAN HDFS [tpcds_parquet.time_dim, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=1.31MB
|  |     predicates: time_dim.t_hour = CAST(10 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|  |     stored statistics:
|  |       table: rows=86.40K size=1.31MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=86.40K
|  |     parquet statistics predicates: time_dim.t_hour = CAST(10 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|  |     parquet dictionary predicates: time_dim.t_hour = CAST(10 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|  |     mem-estimate=48.00MB mem-reservation=512.00KB thread-reservation=1
|  |     tuple-ids=26 row-size=12B cardinality=1.14K
|  |     in pipelines: 34(GETNEXT)
|  |
|  32:SCAN HDFS [tpcds_parquet.store_sales, RANDOM]
|     HDFS partitions=1824/1824 files=1824 size=200.95MB
|     runtime filters: RF028[bloom] -> ss_sold_time_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=48.00MB mem-reservation=1.00MB thread-reservation=1
|     tuple-ids=24 row-size=12B cardinality=2.88M
|     in pipelines: 32(GETNEXT)
|
66:NESTED LOOP JOIN [CROSS JOIN, BROADCAST]
|  mem-estimate=8B mem-reservation=0B thread-reservation=0
|  tuple-ids=4,10,16,22 row-size=32B cardinality=1
|  in pipelines: 75(GETNEXT), 92(OPEN)
|
|--93:EXCHANGE [UNPARTITIONED]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=22 row-size=8B cardinality=1
|  |  in pipelines: 92(GETNEXT)
|  |
|  F19:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
|  Per-Host Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1
|  92:AGGREGATE [FINALIZE]
|  |  output: count:merge(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=22 row-size=8B cardinality=1
|  |  in pipelines: 92(GETNEXT), 31(OPEN)
|  |
|  91:EXCHANGE [UNPARTITIONED]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=22 row-size=8B cardinality=1
|  |  in pipelines: 31(GETNEXT)
|  |
|  F15:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  Per-Host Resources: mem-estimate=64.81MB mem-reservation=7.81MB thread-reservation=2 runtime-filters-memory=1.00MB
|  31:AGGREGATE
|  |  output: count(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=22 row-size=8B cardinality=1
|  |  in pipelines: 31(GETNEXT), 24(OPEN)
|  |
|  30: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=18,20,19,21 row-size=56B cardinality=2.27K
|  |  in pipelines: 24(GETNEXT), 27(OPEN)
|  |
|  |--90:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=21 row-size=20B cardinality=2
|  |  |  in pipelines: 27(GETNEXT)
|  |  |
|  |  F18:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=32.00MB mem-reservation=16.00KB thread-reservation=2
|  |  27:SCAN HDFS [tpcds_parquet.store, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=9.93KB
|  |     predicates: store.s_store_name = 'ese'
|  |     stored statistics:
|  |       table: rows=12 size=9.93KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=12
|  |     parquet statistics predicates: store.s_store_name = 'ese'
|  |     parquet dictionary predicates: store.s_store_name = 'ese'
|  |     mem-estimate=32.00MB mem-reservation=16.00KB thread-reservation=1
|  |     tuple-ids=21 row-size=20B cardinality=2
|  |     in pipelines: 27(GETNEXT)
|  |
|  29:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash predicates: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  fk/pk conjuncts: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=18,20,19 row-size=36B cardinality=6.82K
|  |  in pipelines: 24(GETNEXT), 25(OPEN)
|  |
|  |--89:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=19.69KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=19 row-size=12B cardinality=720
|  |  |  in pipelines: 25(GETNEXT)
|  |  |
|  |  F17:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=48.00MB mem-reservation=64.00KB thread-reservation=2
|  |  25:SCAN HDFS [tpcds_parquet.household_demographics, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=41.69KB
|  |     predicates: ((household_demographics.hd_dep_count = CAST(1 AS INT) AND household_demographics.hd_vehicle_count <= CAST(3 AS INT)) OR (household_demographics.hd_dep_count = CAST(0 AS INT) AND household_demographics.hd_vehicle_count <= CAST(2 AS INT)) OR (household_demographics.hd_dep_count = CAST(2 AS INT) AND household_demographics.hd_vehicle_count <= CAST(4 AS INT)))
|  |     stored statistics:
|  |       table: rows=7.20K size=41.69KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=7.20K
|  |     mem-estimate=48.00MB mem-reservation=64.00KB thread-reservation=1
|  |     tuple-ids=19 row-size=12B cardinality=720
|  |     in pipelines: 25(GETNEXT)
|  |
|  28:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash predicates: ss_sold_time_sk = time_dim.t_time_sk
|  |  fk/pk conjuncts: ss_sold_time_sk = time_dim.t_time_sk
|  |  runtime filters: RF022[bloom] <- time_dim.t_time_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=18,20 row-size=24B cardinality=69.82K
|  |  in pipelines: 24(GETNEXT), 26(OPEN)
|  |
|  |--88:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=29.34KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=20 row-size=12B cardinality=1.14K
|  |  |  in pipelines: 26(GETNEXT)
|  |  |
|  |  F16:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=48.00MB mem-reservation=512.00KB thread-reservation=2
|  |  26:SCAN HDFS [tpcds_parquet.time_dim, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=1.31MB
|  |     predicates: time_dim.t_hour = CAST(10 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     stored statistics:
|  |       table: rows=86.40K size=1.31MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=86.40K
|  |     parquet statistics predicates: time_dim.t_hour = CAST(10 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     parquet dictionary predicates: time_dim.t_hour = CAST(10 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     mem-estimate=48.00MB mem-reservation=512.00KB thread-reservation=1
|  |     tuple-ids=20 row-size=12B cardinality=1.14K
|  |     in pipelines: 26(GETNEXT)
|  |
|  24:SCAN HDFS [tpcds_parquet.store_sales, RANDOM]
|     HDFS partitions=1824/1824 files=1824 size=200.95MB
|     runtime filters: RF022[bloom] -> ss_sold_time_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=48.00MB mem-reservation=1.00MB thread-reservation=1
|     tuple-ids=18 row-size=12B cardinality=2.88M
|     in pipelines: 24(GETNEXT)
|
65:NESTED LOOP JOIN [CROSS JOIN, BROADCAST]
|  mem-estimate=8B mem-reservation=0B thread-reservation=0
|  tuple-ids=4,10,16 row-size=24B cardinality=1
|  in pipelines: 75(GETNEXT), 86(OPEN)
|
|--87:EXCHANGE [UNPARTITIONED]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=16 row-size=8B cardinality=1
|  |  in pipelines: 86(GETNEXT)
|  |
|  F14:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
|  Per-Host Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1
|  86:AGGREGATE [FINALIZE]
|  |  output: count:merge(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=16 row-size=8B cardinality=1
|  |  in pipelines: 86(GETNEXT), 23(OPEN)
|  |
|  85:EXCHANGE [UNPARTITIONED]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=16 row-size=8B cardinality=1
|  |  in pipelines: 23(GETNEXT)
|  |
|  F10:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  Per-Host Resources: mem-estimate=64.81MB mem-reservation=7.81MB thread-reservation=2 runtime-filters-memory=1.00MB
|  23:AGGREGATE
|  |  output: count(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=16 row-size=8B cardinality=1
|  |  in pipelines: 23(GETNEXT), 16(OPEN)
|  |
|  22: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=12,14,13,15 row-size=56B cardinality=2.27K
|  |  in pipelines: 16(GETNEXT), 19(OPEN)
|  |
|  |--84:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=15 row-size=20B cardinality=2
|  |  |  in pipelines: 19(GETNEXT)
|  |  |
|  |  F13:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=32.00MB mem-reservation=16.00KB thread-reservation=2
|  |  19:SCAN HDFS [tpcds_parquet.store, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=9.93KB
|  |     predicates: store.s_store_name = 'ese'
|  |     stored statistics:
|  |       table: rows=12 size=9.93KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=12
|  |     parquet statistics predicates: store.s_store_name = 'ese'
|  |     parquet dictionary predicates: store.s_store_name = 'ese'
|  |     mem-estimate=32.00MB mem-reservation=16.00KB thread-reservation=1
|  |     tuple-ids=15 row-size=20B cardinality=2
|  |     in pipelines: 19(GETNEXT)
|  |
|  21:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash predicates: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  fk/pk conjuncts: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=12,14,13 row-size=36B cardinality=6.82K
|  |  in pipelines: 16(GETNEXT), 17(OPEN)
|  |
|  |--83:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=19.69KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=13 row-size=12B cardinality=720
|  |  |  in pipelines: 17(GETNEXT)
|  |  |
|  |  F12:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=48.00MB mem-reservation=64.00KB thread-reservation=2
|  |  17:SCAN HDFS [tpcds_parquet.household_demographics, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=41.69KB
|  |     predicates: ((household_demographics.hd_dep_count = CAST(1 AS INT) AND household_demographics.hd_vehicle_count <= CAST(3 AS INT)) OR (household_demographics.hd_dep_count = CAST(0 AS INT) AND household_demographics.hd_vehicle_count <= CAST(2 AS INT)) OR (household_demographics.hd_dep_count = CAST(2 AS INT) AND household_demographics.hd_vehicle_count <= CAST(4 AS INT)))
|  |     stored statistics:
|  |       table: rows=7.20K size=41.69KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=7.20K
|  |     mem-estimate=48.00MB mem-reservation=64.00KB thread-reservation=1
|  |     tuple-ids=13 row-size=12B cardinality=720
|  |     in pipelines: 17(GETNEXT)
|  |
|  20:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash predicates: ss_sold_time_sk = time_dim.t_time_sk
|  |  fk/pk conjuncts: ss_sold_time_sk = time_dim.t_time_sk
|  |  runtime filters: RF016[bloom] <- time_dim.t_time_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=12,14 row-size=24B cardinality=69.82K
|  |  in pipelines: 16(GETNEXT), 18(OPEN)
|  |
|  |--82:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=29.34KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=14 row-size=12B cardinality=1.14K
|  |  |  in pipelines: 18(GETNEXT)
|  |  |
|  |  F11:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=48.00MB mem-reservation=512.00KB thread-reservation=2
|  |  18:SCAN HDFS [tpcds_parquet.time_dim, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=1.31MB
|  |     predicates: time_dim.t_hour = CAST(9 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|  |     stored statistics:
|  |       table: rows=86.40K size=1.31MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=86.40K
|  |     parquet statistics predicates: time_dim.t_hour = CAST(9 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|  |     parquet dictionary predicates: time_dim.t_hour = CAST(9 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|  |     mem-estimate=48.00MB mem-reservation=512.00KB thread-reservation=1
|  |     tuple-ids=14 row-size=12B cardinality=1.14K
|  |     in pipelines: 18(GETNEXT)
|  |
|  16:SCAN HDFS [tpcds_parquet.store_sales, RANDOM]
|     HDFS partitions=1824/1824 files=1824 size=200.95MB
|     runtime filters: RF016[bloom] -> ss_sold_time_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=48.00MB mem-reservation=1.00MB thread-reservation=1
|     tuple-ids=12 row-size=12B cardinality=2.88M
|     in pipelines: 16(GETNEXT)
|
64:NESTED LOOP JOIN [CROSS JOIN, BROADCAST]
|  mem-estimate=8B mem-reservation=0B thread-reservation=0
|  tuple-ids=4,10 row-size=16B cardinality=1
|  in pipelines: 75(GETNEXT), 80(OPEN)
|
|--81:EXCHANGE [UNPARTITIONED]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=10 row-size=8B cardinality=1
|  |  in pipelines: 80(GETNEXT)
|  |
|  F09:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
|  Per-Host Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1
|  80:AGGREGATE [FINALIZE]
|  |  output: count:merge(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=10 row-size=8B cardinality=1
|  |  in pipelines: 80(GETNEXT), 15(OPEN)
|  |
|  79:EXCHANGE [UNPARTITIONED]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=10 row-size=8B cardinality=1
|  |  in pipelines: 15(GETNEXT)
|  |
|  F05:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  Per-Host Resources: mem-estimate=65.81MB mem-reservation=8.81MB thread-reservation=2 runtime-filters-memory=2.00MB
|  15:AGGREGATE
|  |  output: count(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=10 row-size=8B cardinality=1
|  |  in pipelines: 15(GETNEXT), 08(OPEN)
|  |
|  14: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=6,8,7,9 row-size=56B cardinality=2.27K
|  |  in pipelines: 08(GETNEXT), 11(OPEN)
|  |
|  |--78:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=9 row-size=20B cardinality=2
|  |  |  in pipelines: 11(GETNEXT)
|  |  |
|  |  F08:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=32.00MB mem-reservation=16.00KB thread-reservation=2
|  |  11:SCAN HDFS [tpcds_parquet.store, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=9.93KB
|  |     predicates: store.s_store_name = 'ese'
|  |     stored statistics:
|  |       table: rows=12 size=9.93KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=12
|  |     parquet statistics predicates: store.s_store_name = 'ese'
|  |     parquet dictionary predicates: store.s_store_name = 'ese'
|  |     mem-estimate=32.00MB mem-reservation=16.00KB thread-reservation=1
|  |     tuple-ids=9 row-size=20B cardinality=2
|  |     in pipelines: 11(GETNEXT)
|  |
|  13:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash predicates: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  fk/pk conjuncts: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  runtime filters: RF008[bloom] <- household_demographics.hd_demo_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=6,8,7 row-size=36B cardinality=6.82K
|  |  in pipelines: 08(GETNEXT), 09(OPEN)
|  |
|  |--77:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=19.69KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=7 row-size=12B cardinality=720
|  |  |  in pipelines: 09(GETNEXT)
|  |  |
|  |  F07:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=48.00MB mem-reservation=64.00KB thread-reservation=2
|  |  09:SCAN HDFS [tpcds_parquet.household_demographics, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=41.69KB
|  |     predicates: ((household_demographics.hd_dep_count = CAST(1 AS INT) AND household_demographics.hd_vehicle_count <= CAST(3 AS INT)) OR (household_demographics.hd_dep_count = CAST(0 AS INT) AND household_demographics.hd_vehicle_count <= CAST(2 AS INT)) OR (household_demographics.hd_dep_count = CAST(2 AS INT) AND household_demographics.hd_vehicle_count <= CAST(4 AS INT)))
|  |     stored statistics:
|  |       table: rows=7.20K size=41.69KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=7.20K
|  |     mem-estimate=48.00MB mem-reservation=64.00KB thread-reservation=1
|  |     tuple-ids=7 row-size=12B cardinality=720
|  |     in pipelines: 09(GETNEXT)
|  |
|  12:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash predicates: ss_sold_time_sk = time_dim.t_time_sk
|  |  fk/pk conjuncts: ss_sold_time_sk = time_dim.t_time_sk
|  |  runtime filters: RF010[bloom] <- time_dim.t_time_sk
|  |  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=6,8 row-size=24B cardinality=69.82K
|  |  in pipelines: 08(GETNEXT), 10(OPEN)
|  |
|  |--76:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=29.34KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=8 row-size=12B cardinality=1.14K
|  |  |  in pipelines: 10(GETNEXT)
|  |  |
|  |  F06:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Host Resources: mem-estimate=48.00MB mem-reservation=512.00KB thread-reservation=2
|  |  10:SCAN HDFS [tpcds_parquet.time_dim, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=1.31MB
|  |     predicates: time_dim.t_hour = CAST(9 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     stored statistics:
|  |       table: rows=86.40K size=1.31MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=86.40K
|  |     parquet statistics predicates: time_dim.t_hour = CAST(9 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     parquet dictionary predicates: time_dim.t_hour = CAST(9 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     mem-estimate=48.00MB mem-reservation=512.00KB thread-reservation=1
|  |     tuple-ids=8 row-size=12B cardinality=1.14K
|  |     in pipelines: 10(GETNEXT)
|  |
|  08:SCAN HDFS [tpcds_parquet.store_sales, RANDOM]
|     HDFS partitions=1824/1824 files=1824 size=200.95MB
|     runtime filters: RF010[bloom] -> ss_sold_time_sk, RF008[bloom] -> ss_hdemo_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=48.00MB mem-reservation=1.00MB thread-reservation=1
|     tuple-ids=6 row-size=12B cardinality=2.88M
|     in pipelines: 08(GETNEXT)
|
75:AGGREGATE [FINALIZE]
|  output: count:merge(*)
|  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  tuple-ids=4 row-size=8B cardinality=1
|  in pipelines: 75(GETNEXT), 07(OPEN)
|
74:EXCHANGE [UNPARTITIONED]
|  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  tuple-ids=4 row-size=8B cardinality=1
|  in pipelines: 07(GETNEXT)
|
F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
Per-Host Resources: mem-estimate=65.81MB mem-reservation=8.81MB thread-reservation=2 runtime-filters-memory=2.00MB
07:AGGREGATE
|  output: count(*)
|  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  tuple-ids=4 row-size=8B cardinality=1
|  in pipelines: 07(GETNEXT), 00(OPEN)
|
06: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,2,1,3 row-size=56B cardinality=2.27K
|  in pipelines: 00(GETNEXT), 03(OPEN)
|
|--73:EXCHANGE [BROADCAST]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=3 row-size=20B cardinality=2
|  |  in pipelines: 03(GETNEXT)
|  |
|  F03:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Host Resources: mem-estimate=32.00MB mem-reservation=16.00KB thread-reservation=2
|  03:SCAN HDFS [tpcds_parquet.store, RANDOM]
|     HDFS partitions=1/1 files=1 size=9.93KB
|     predicates: store.s_store_name = 'ese'
|     stored statistics:
|       table: rows=12 size=9.93KB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=12
|     parquet statistics predicates: store.s_store_name = 'ese'
|     parquet dictionary predicates: store.s_store_name = 'ese'
|     mem-estimate=32.00MB mem-reservation=16.00KB thread-reservation=1
|     tuple-ids=3 row-size=20B cardinality=2
|     in pipelines: 03(GETNEXT)
|
05:HASH JOIN [INNER JOIN, BROADCAST]
|  hash predicates: ss_hdemo_sk = household_demographics.hd_demo_sk
|  fk/pk conjuncts: ss_hdemo_sk = household_demographics.hd_demo_sk
|  runtime filters: RF002[bloom] <- household_demographics.hd_demo_sk
|  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=0,2,1 row-size=36B cardinality=6.82K
|  in pipelines: 00(GETNEXT), 01(OPEN)
|
|--72:EXCHANGE [BROADCAST]
|  |  mem-estimate=19.69KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=1 row-size=12B cardinality=720
|  |  in pipelines: 01(GETNEXT)
|  |
|  F02:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Host Resources: mem-estimate=48.00MB mem-reservation=64.00KB thread-reservation=2
|  01:SCAN HDFS [tpcds_parquet.household_demographics, RANDOM]
|     HDFS partitions=1/1 files=1 size=41.69KB
|     predicates: ((household_demographics.hd_dep_count = CAST(1 AS INT) AND household_demographics.hd_vehicle_count <= CAST(3 AS INT)) OR (household_demographics.hd_dep_count = CAST(0 AS INT) AND household_demographics.hd_vehicle_count <= CAST(2 AS INT)) OR (household_demographics.hd_dep_count = CAST(2 AS INT) AND household_demographics.hd_vehicle_count <= CAST(4 AS INT)))
|     stored statistics:
|       table: rows=7.20K size=41.69KB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=7.20K
|     mem-estimate=48.00MB mem-reservation=64.00KB thread-reservation=1
|     tuple-ids=1 row-size=12B cardinality=720
|     in pipelines: 01(GETNEXT)
|
04:HASH JOIN [INNER JOIN, BROADCAST]
|  hash predicates: ss_sold_time_sk = time_dim.t_time_sk
|  fk/pk conjuncts: ss_sold_time_sk = time_dim.t_time_sk
|  runtime filters: RF004[bloom] <- time_dim.t_time_sk
|  mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=0,2 row-size=24B cardinality=69.82K
|  in pipelines: 00(GETNEXT), 02(OPEN)
|
|--71:EXCHANGE [BROADCAST]
|  |  mem-estimate=29.34KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=2 row-size=12B cardinality=1.14K
|  |  in pipelines: 02(GETNEXT)
|  |
|  F01:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Host Resources: mem-estimate=48.00MB mem-reservation=512.00KB thread-reservation=2
|  02:SCAN HDFS [tpcds_parquet.time_dim, RANDOM]
|     HDFS partitions=1/1 files=1 size=1.31MB
|     predicates: time_dim.t_hour = CAST(8 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|     stored statistics:
|       table: rows=86.40K size=1.31MB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=86.40K
|     parquet statistics predicates: time_dim.t_hour = CAST(8 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|     parquet dictionary predicates: time_dim.t_hour = CAST(8 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|     mem-estimate=48.00MB mem-reservation=512.00KB thread-reservation=1
|     tuple-ids=2 row-size=12B cardinality=1.14K
|     in pipelines: 02(GETNEXT)
|
00:SCAN HDFS [tpcds_parquet.store_sales, RANDOM]
   HDFS partitions=1824/1824 files=1824 size=200.95MB
   runtime filters: RF004[bloom] -> ss_sold_time_sk, RF002[bloom] -> ss_hdemo_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=48.00MB mem-reservation=1.00MB thread-reservation=1
   tuple-ids=0 row-size=12B cardinality=2.88M
   in pipelines: 00(GETNEXT)
---- PARALLELPLANS
Max Per-Host Resource Reservation: Memory=133.62MB Threads=79
Per-Host Resource Estimates: Memory=994MB
F04:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
|  Per-Instance Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1
PLAN-ROOT SINK
|  output exprs: count(*), count(*), count(*), count(*), count(*), count(*), count(*), count(*)
|  mem-estimate=0B mem-reservation=0B thread-reservation=0
|
70:NESTED LOOP JOIN [CROSS JOIN, BROADCAST]
|  join table id: 00
|  mem-estimate=0B mem-reservation=0B thread-reservation=0
|  tuple-ids=4,10,16,22,28,34,40,46 row-size=64B cardinality=1
|  in pipelines: 75(GETNEXT), 116(OPEN)
|
|--F40:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.01KB mem-reservation=0B thread-reservation=1
|  JOIN BUILD
|  |  join-table-id=00 plan-id=01 cohort-id=01
|  |  mem-estimate=8B mem-reservation=0B thread-reservation=0
|  |
|  117:EXCHANGE [UNPARTITIONED]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=46 row-size=8B cardinality=1
|  |  in pipelines: 116(GETNEXT)
|  |
|  F39:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
|  Per-Instance Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1
|  116:AGGREGATE [FINALIZE]
|  |  output: count:merge(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=46 row-size=8B cardinality=1
|  |  in pipelines: 116(GETNEXT), 63(OPEN)
|  |
|  115:EXCHANGE [UNPARTITIONED]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=46 row-size=8B cardinality=1
|  |  in pipelines: 63(GETNEXT)
|  |
|  F35:PLAN FRAGMENT [RANDOM] hosts=3 instances=6
|  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=26.00MB mem-reservation=1.00MB thread-reservation=1
|  63:AGGREGATE
|  |  output: count(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=46 row-size=8B cardinality=1
|  |  in pipelines: 63(GETNEXT), 56(OPEN)
|  |
|  62:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash-table-id=01
|  |  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=42,44,43,45 row-size=56B cardinality=2.27K
|  |  in pipelines: 56(GETNEXT), 59(OPEN)
|  |
|  |--F41:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  |  |  Per-Instance Resources: mem-estimate=3.89MB mem-reservation=3.88MB thread-reservation=1
|  |  JOIN BUILD
|  |  |  join-table-id=01 plan-id=02 cohort-id=02
|  |  |  build expressions: s_store_sk
|  |  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  114:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=45 row-size=20B cardinality=2
|  |  |  in pipelines: 59(GETNEXT)
|  |  |
|  |  F38:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=16.00KB thread-reservation=1
|  |  59:SCAN HDFS [tpcds_parquet.store, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=9.93KB
|  |     predicates: store.s_store_name = 'ese'
|  |     stored statistics:
|  |       table: rows=12 size=9.93KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=12
|  |     parquet statistics predicates: store.s_store_name = 'ese'
|  |     parquet dictionary predicates: store.s_store_name = 'ese'
|  |     mem-estimate=16.00MB mem-reservation=16.00KB thread-reservation=0
|  |     tuple-ids=45 row-size=20B cardinality=2
|  |     in pipelines: 59(GETNEXT)
|  |
|  61:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash-table-id=02
|  |  hash predicates: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  fk/pk conjuncts: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=42,44,43 row-size=36B cardinality=6.82K
|  |  in pipelines: 56(GETNEXT), 57(OPEN)
|  |
|  |--F42:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  |  |  Per-Instance Resources: mem-estimate=3.89MB mem-reservation=3.88MB thread-reservation=1
|  |  JOIN BUILD
|  |  |  join-table-id=02 plan-id=03 cohort-id=02
|  |  |  build expressions: household_demographics.hd_demo_sk
|  |  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  113:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=19.69KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=43 row-size=12B cardinality=720
|  |  |  in pipelines: 57(GETNEXT)
|  |  |
|  |  F37:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=64.00KB thread-reservation=1
|  |  57:SCAN HDFS [tpcds_parquet.household_demographics, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=41.69KB
|  |     predicates: ((household_demographics.hd_dep_count = CAST(1 AS INT) AND household_demographics.hd_vehicle_count <= CAST(3 AS INT)) OR (household_demographics.hd_dep_count = CAST(0 AS INT) AND household_demographics.hd_vehicle_count <= CAST(2 AS INT)) OR (household_demographics.hd_dep_count = CAST(2 AS INT) AND household_demographics.hd_vehicle_count <= CAST(4 AS INT)))
|  |     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=43 row-size=12B cardinality=720
|  |     in pipelines: 57(GETNEXT)
|  |
|  60:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash-table-id=03
|  |  hash predicates: ss_sold_time_sk = time_dim.t_time_sk
|  |  fk/pk conjuncts: ss_sold_time_sk = time_dim.t_time_sk
|  |  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=42,44 row-size=24B cardinality=69.82K
|  |  in pipelines: 56(GETNEXT), 58(OPEN)
|  |
|  |--F43:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  |  |  Per-Instance Resources: mem-estimate=4.90MB mem-reservation=4.88MB thread-reservation=1 runtime-filters-memory=1.00MB
|  |  JOIN BUILD
|  |  |  join-table-id=03 plan-id=04 cohort-id=02
|  |  |  build expressions: time_dim.t_time_sk
|  |  |  runtime filters: RF046[bloom] <- time_dim.t_time_sk
|  |  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  112:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=29.34KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=44 row-size=12B cardinality=1.14K
|  |  |  in pipelines: 58(GETNEXT)
|  |  |
|  |  F36:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=512.00KB thread-reservation=1
|  |  58:SCAN HDFS [tpcds_parquet.time_dim, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=1.31MB
|  |     predicates: time_dim.t_hour = CAST(12 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     stored statistics:
|  |       table: rows=86.40K size=1.31MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=86.40K
|  |     parquet statistics predicates: time_dim.t_hour = CAST(12 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     parquet dictionary predicates: time_dim.t_hour = CAST(12 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     mem-estimate=16.00MB mem-reservation=512.00KB thread-reservation=0
|  |     tuple-ids=44 row-size=12B cardinality=1.14K
|  |     in pipelines: 58(GETNEXT)
|  |
|  56:SCAN HDFS [tpcds_parquet.store_sales, RANDOM]
|     HDFS partitions=1824/1824 files=1824 size=200.95MB
|     runtime filters: RF046[bloom] -> ss_sold_time_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=1.00MB thread-reservation=0
|     tuple-ids=42 row-size=12B cardinality=2.88M
|     in pipelines: 56(GETNEXT)
|
69:NESTED LOOP JOIN [CROSS JOIN, BROADCAST]
|  join table id: 04
|  mem-estimate=0B mem-reservation=0B thread-reservation=0
|  tuple-ids=4,10,16,22,28,34,40 row-size=56B cardinality=1
|  in pipelines: 75(GETNEXT), 110(OPEN)
|
|--F44:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.01KB mem-reservation=0B thread-reservation=1
|  JOIN BUILD
|  |  join-table-id=04 plan-id=05 cohort-id=01
|  |  mem-estimate=8B mem-reservation=0B thread-reservation=0
|  |
|  111:EXCHANGE [UNPARTITIONED]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=40 row-size=8B cardinality=1
|  |  in pipelines: 110(GETNEXT)
|  |
|  F34:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
|  Per-Instance Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1
|  110:AGGREGATE [FINALIZE]
|  |  output: count:merge(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=40 row-size=8B cardinality=1
|  |  in pipelines: 110(GETNEXT), 55(OPEN)
|  |
|  109:EXCHANGE [UNPARTITIONED]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=40 row-size=8B cardinality=1
|  |  in pipelines: 55(GETNEXT)
|  |
|  F30:PLAN FRAGMENT [RANDOM] hosts=3 instances=6
|  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=26.00MB mem-reservation=1.00MB thread-reservation=1
|  55:AGGREGATE
|  |  output: count(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=40 row-size=8B cardinality=1
|  |  in pipelines: 55(GETNEXT), 48(OPEN)
|  |
|  54:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash-table-id=05
|  |  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=36,38,37,39 row-size=56B cardinality=2.27K
|  |  in pipelines: 48(GETNEXT), 51(OPEN)
|  |
|  |--F45:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  |  |  Per-Instance Resources: mem-estimate=3.89MB mem-reservation=3.88MB thread-reservation=1
|  |  JOIN BUILD
|  |  |  join-table-id=05 plan-id=06 cohort-id=03
|  |  |  build expressions: s_store_sk
|  |  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  108:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=39 row-size=20B cardinality=2
|  |  |  in pipelines: 51(GETNEXT)
|  |  |
|  |  F33:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=16.00KB thread-reservation=1
|  |  51:SCAN HDFS [tpcds_parquet.store, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=9.93KB
|  |     predicates: store.s_store_name = 'ese'
|  |     stored statistics:
|  |       table: rows=12 size=9.93KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=12
|  |     parquet statistics predicates: store.s_store_name = 'ese'
|  |     parquet dictionary predicates: store.s_store_name = 'ese'
|  |     mem-estimate=16.00MB mem-reservation=16.00KB thread-reservation=0
|  |     tuple-ids=39 row-size=20B cardinality=2
|  |     in pipelines: 51(GETNEXT)
|  |
|  53:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash-table-id=06
|  |  hash predicates: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  fk/pk conjuncts: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=36,38,37 row-size=36B cardinality=6.82K
|  |  in pipelines: 48(GETNEXT), 49(OPEN)
|  |
|  |--F46:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  |  |  Per-Instance Resources: mem-estimate=3.89MB mem-reservation=3.88MB thread-reservation=1
|  |  JOIN BUILD
|  |  |  join-table-id=06 plan-id=07 cohort-id=03
|  |  |  build expressions: household_demographics.hd_demo_sk
|  |  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  107:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=19.69KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=37 row-size=12B cardinality=720
|  |  |  in pipelines: 49(GETNEXT)
|  |  |
|  |  F32:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=64.00KB thread-reservation=1
|  |  49:SCAN HDFS [tpcds_parquet.household_demographics, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=41.69KB
|  |     predicates: ((household_demographics.hd_dep_count = CAST(1 AS INT) AND household_demographics.hd_vehicle_count <= CAST(3 AS INT)) OR (household_demographics.hd_dep_count = CAST(0 AS INT) AND household_demographics.hd_vehicle_count <= CAST(2 AS INT)) OR (household_demographics.hd_dep_count = CAST(2 AS INT) AND household_demographics.hd_vehicle_count <= CAST(4 AS INT)))
|  |     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=12B cardinality=720
|  |     in pipelines: 49(GETNEXT)
|  |
|  52:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash-table-id=07
|  |  hash predicates: ss_sold_time_sk = time_dim.t_time_sk
|  |  fk/pk conjuncts: ss_sold_time_sk = time_dim.t_time_sk
|  |  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=36,38 row-size=24B cardinality=69.82K
|  |  in pipelines: 48(GETNEXT), 50(OPEN)
|  |
|  |--F47:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  |  |  Per-Instance Resources: mem-estimate=4.90MB mem-reservation=4.88MB thread-reservation=1 runtime-filters-memory=1.00MB
|  |  JOIN BUILD
|  |  |  join-table-id=07 plan-id=08 cohort-id=03
|  |  |  build expressions: time_dim.t_time_sk
|  |  |  runtime filters: RF040[bloom] <- time_dim.t_time_sk
|  |  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  106:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=29.34KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=38 row-size=12B cardinality=1.14K
|  |  |  in pipelines: 50(GETNEXT)
|  |  |
|  |  F31:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=512.00KB thread-reservation=1
|  |  50:SCAN HDFS [tpcds_parquet.time_dim, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=1.31MB
|  |     predicates: time_dim.t_hour = CAST(11 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|  |     stored statistics:
|  |       table: rows=86.40K size=1.31MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=86.40K
|  |     parquet statistics predicates: time_dim.t_hour = CAST(11 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|  |     parquet dictionary predicates: time_dim.t_hour = CAST(11 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|  |     mem-estimate=16.00MB mem-reservation=512.00KB thread-reservation=0
|  |     tuple-ids=38 row-size=12B cardinality=1.14K
|  |     in pipelines: 50(GETNEXT)
|  |
|  48:SCAN HDFS [tpcds_parquet.store_sales, RANDOM]
|     HDFS partitions=1824/1824 files=1824 size=200.95MB
|     runtime filters: RF040[bloom] -> ss_sold_time_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=1.00MB thread-reservation=0
|     tuple-ids=36 row-size=12B cardinality=2.88M
|     in pipelines: 48(GETNEXT)
|
68:NESTED LOOP JOIN [CROSS JOIN, BROADCAST]
|  join table id: 08
|  mem-estimate=0B mem-reservation=0B thread-reservation=0
|  tuple-ids=4,10,16,22,28,34 row-size=48B cardinality=1
|  in pipelines: 75(GETNEXT), 104(OPEN)
|
|--F48:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.01KB mem-reservation=0B thread-reservation=1
|  JOIN BUILD
|  |  join-table-id=08 plan-id=09 cohort-id=01
|  |  mem-estimate=8B mem-reservation=0B thread-reservation=0
|  |
|  105:EXCHANGE [UNPARTITIONED]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=34 row-size=8B cardinality=1
|  |  in pipelines: 104(GETNEXT)
|  |
|  F29:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
|  Per-Instance Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1
|  104:AGGREGATE [FINALIZE]
|  |  output: count:merge(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=34 row-size=8B cardinality=1
|  |  in pipelines: 104(GETNEXT), 47(OPEN)
|  |
|  103:EXCHANGE [UNPARTITIONED]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=34 row-size=8B cardinality=1
|  |  in pipelines: 47(GETNEXT)
|  |
|  F25:PLAN FRAGMENT [RANDOM] hosts=3 instances=6
|  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=26.00MB mem-reservation=1.00MB thread-reservation=1
|  47:AGGREGATE
|  |  output: count(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=34 row-size=8B cardinality=1
|  |  in pipelines: 47(GETNEXT), 40(OPEN)
|  |
|  46:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash-table-id=09
|  |  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=30,32,31,33 row-size=56B cardinality=2.27K
|  |  in pipelines: 40(GETNEXT), 43(OPEN)
|  |
|  |--F49:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  |  |  Per-Instance Resources: mem-estimate=3.89MB mem-reservation=3.88MB thread-reservation=1
|  |  JOIN BUILD
|  |  |  join-table-id=09 plan-id=10 cohort-id=04
|  |  |  build expressions: s_store_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=33 row-size=20B cardinality=2
|  |  |  in pipelines: 43(GETNEXT)
|  |  |
|  |  F28:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=16.00KB thread-reservation=1
|  |  43:SCAN HDFS [tpcds_parquet.store, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=9.93KB
|  |     predicates: store.s_store_name = 'ese'
|  |     stored statistics:
|  |       table: rows=12 size=9.93KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=12
|  |     parquet statistics predicates: store.s_store_name = 'ese'
|  |     parquet dictionary predicates: store.s_store_name = 'ese'
|  |     mem-estimate=16.00MB mem-reservation=16.00KB thread-reservation=0
|  |     tuple-ids=33 row-size=20B cardinality=2
|  |     in pipelines: 43(GETNEXT)
|  |
|  45:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash-table-id=10
|  |  hash predicates: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  fk/pk conjuncts: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=30,32,31 row-size=36B cardinality=6.82K
|  |  in pipelines: 40(GETNEXT), 41(OPEN)
|  |
|  |--F50:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  |  |  Per-Instance Resources: mem-estimate=3.89MB mem-reservation=3.88MB thread-reservation=1
|  |  JOIN BUILD
|  |  |  join-table-id=10 plan-id=11 cohort-id=04
|  |  |  build expressions: household_demographics.hd_demo_sk
|  |  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  101:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=19.69KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=31 row-size=12B cardinality=720
|  |  |  in pipelines: 41(GETNEXT)
|  |  |
|  |  F27:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=64.00KB thread-reservation=1
|  |  41:SCAN HDFS [tpcds_parquet.household_demographics, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=41.69KB
|  |     predicates: ((household_demographics.hd_dep_count = CAST(1 AS INT) AND household_demographics.hd_vehicle_count <= CAST(3 AS INT)) OR (household_demographics.hd_dep_count = CAST(0 AS INT) AND household_demographics.hd_vehicle_count <= CAST(2 AS INT)) OR (household_demographics.hd_dep_count = CAST(2 AS INT) AND household_demographics.hd_vehicle_count <= CAST(4 AS INT)))
|  |     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=31 row-size=12B cardinality=720
|  |     in pipelines: 41(GETNEXT)
|  |
|  44:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash-table-id=11
|  |  hash predicates: ss_sold_time_sk = time_dim.t_time_sk
|  |  fk/pk conjuncts: ss_sold_time_sk = time_dim.t_time_sk
|  |  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=30,32 row-size=24B cardinality=69.82K
|  |  in pipelines: 40(GETNEXT), 42(OPEN)
|  |
|  |--F51:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  |  |  Per-Instance Resources: mem-estimate=4.90MB mem-reservation=4.88MB thread-reservation=1 runtime-filters-memory=1.00MB
|  |  JOIN BUILD
|  |  |  join-table-id=11 plan-id=12 cohort-id=04
|  |  |  build expressions: time_dim.t_time_sk
|  |  |  runtime filters: RF034[bloom] <- time_dim.t_time_sk
|  |  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  100:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=29.34KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=32 row-size=12B cardinality=1.14K
|  |  |  in pipelines: 42(GETNEXT)
|  |  |
|  |  F26:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=512.00KB thread-reservation=1
|  |  42:SCAN HDFS [tpcds_parquet.time_dim, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=1.31MB
|  |     predicates: time_dim.t_hour = CAST(11 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     stored statistics:
|  |       table: rows=86.40K size=1.31MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=86.40K
|  |     parquet statistics predicates: time_dim.t_hour = CAST(11 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     parquet dictionary predicates: time_dim.t_hour = CAST(11 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     mem-estimate=16.00MB mem-reservation=512.00KB thread-reservation=0
|  |     tuple-ids=32 row-size=12B cardinality=1.14K
|  |     in pipelines: 42(GETNEXT)
|  |
|  40:SCAN HDFS [tpcds_parquet.store_sales, RANDOM]
|     HDFS partitions=1824/1824 files=1824 size=200.95MB
|     runtime filters: RF034[bloom] -> ss_sold_time_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=1.00MB thread-reservation=0
|     tuple-ids=30 row-size=12B cardinality=2.88M
|     in pipelines: 40(GETNEXT)
|
67:NESTED LOOP JOIN [CROSS JOIN, BROADCAST]
|  join table id: 12
|  mem-estimate=0B mem-reservation=0B thread-reservation=0
|  tuple-ids=4,10,16,22,28 row-size=40B cardinality=1
|  in pipelines: 75(GETNEXT), 98(OPEN)
|
|--F52:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.01KB mem-reservation=0B thread-reservation=1
|  JOIN BUILD
|  |  join-table-id=12 plan-id=13 cohort-id=01
|  |  mem-estimate=8B mem-reservation=0B thread-reservation=0
|  |
|  99:EXCHANGE [UNPARTITIONED]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=28 row-size=8B cardinality=1
|  |  in pipelines: 98(GETNEXT)
|  |
|  F24:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
|  Per-Instance Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1
|  98:AGGREGATE [FINALIZE]
|  |  output: count:merge(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=28 row-size=8B cardinality=1
|  |  in pipelines: 98(GETNEXT), 39(OPEN)
|  |
|  97:EXCHANGE [UNPARTITIONED]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=28 row-size=8B cardinality=1
|  |  in pipelines: 39(GETNEXT)
|  |
|  F20:PLAN FRAGMENT [RANDOM] hosts=3 instances=6
|  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=26.00MB mem-reservation=1.00MB thread-reservation=1
|  39:AGGREGATE
|  |  output: count(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=28 row-size=8B cardinality=1
|  |  in pipelines: 39(GETNEXT), 32(OPEN)
|  |
|  38: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=24,26,25,27 row-size=56B cardinality=2.27K
|  |  in pipelines: 32(GETNEXT), 35(OPEN)
|  |
|  |--F53:PLAN FRAGMENT [RANDOM] 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=05
|  |  |  build expressions: s_store_sk
|  |  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  96:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=27 row-size=20B cardinality=2
|  |  |  in pipelines: 35(GETNEXT)
|  |  |
|  |  F23:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=16.00KB thread-reservation=1
|  |  35:SCAN HDFS [tpcds_parquet.store, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=9.93KB
|  |     predicates: store.s_store_name = 'ese'
|  |     stored statistics:
|  |       table: rows=12 size=9.93KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=12
|  |     parquet statistics predicates: store.s_store_name = 'ese'
|  |     parquet dictionary predicates: store.s_store_name = 'ese'
|  |     mem-estimate=16.00MB mem-reservation=16.00KB thread-reservation=0
|  |     tuple-ids=27 row-size=20B cardinality=2
|  |     in pipelines: 35(GETNEXT)
|  |
|  37:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash-table-id=14
|  |  hash predicates: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  fk/pk conjuncts: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=24,26,25 row-size=36B cardinality=6.82K
|  |  in pipelines: 32(GETNEXT), 33(OPEN)
|  |
|  |--F54:PLAN FRAGMENT [RANDOM] 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=05
|  |  |  build expressions: household_demographics.hd_demo_sk
|  |  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  95:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=19.69KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=25 row-size=12B cardinality=720
|  |  |  in pipelines: 33(GETNEXT)
|  |  |
|  |  F22:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=64.00KB thread-reservation=1
|  |  33:SCAN HDFS [tpcds_parquet.household_demographics, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=41.69KB
|  |     predicates: ((household_demographics.hd_dep_count = CAST(1 AS INT) AND household_demographics.hd_vehicle_count <= CAST(3 AS INT)) OR (household_demographics.hd_dep_count = CAST(0 AS INT) AND household_demographics.hd_vehicle_count <= CAST(2 AS INT)) OR (household_demographics.hd_dep_count = CAST(2 AS INT) AND household_demographics.hd_vehicle_count <= CAST(4 AS INT)))
|  |     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=25 row-size=12B cardinality=720
|  |     in pipelines: 33(GETNEXT)
|  |
|  36:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash-table-id=15
|  |  hash predicates: ss_sold_time_sk = time_dim.t_time_sk
|  |  fk/pk conjuncts: ss_sold_time_sk = time_dim.t_time_sk
|  |  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=24,26 row-size=24B cardinality=69.82K
|  |  in pipelines: 32(GETNEXT), 34(OPEN)
|  |
|  |--F55:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  |  |  Per-Instance Resources: mem-estimate=4.90MB mem-reservation=4.88MB thread-reservation=1 runtime-filters-memory=1.00MB
|  |  JOIN BUILD
|  |  |  join-table-id=15 plan-id=16 cohort-id=05
|  |  |  build expressions: time_dim.t_time_sk
|  |  |  runtime filters: RF028[bloom] <- time_dim.t_time_sk
|  |  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  94:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=29.34KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=26 row-size=12B cardinality=1.14K
|  |  |  in pipelines: 34(GETNEXT)
|  |  |
|  |  F21:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=512.00KB thread-reservation=1
|  |  34:SCAN HDFS [tpcds_parquet.time_dim, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=1.31MB
|  |     predicates: time_dim.t_hour = CAST(10 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|  |     stored statistics:
|  |       table: rows=86.40K size=1.31MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=86.40K
|  |     parquet statistics predicates: time_dim.t_hour = CAST(10 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|  |     parquet dictionary predicates: time_dim.t_hour = CAST(10 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|  |     mem-estimate=16.00MB mem-reservation=512.00KB thread-reservation=0
|  |     tuple-ids=26 row-size=12B cardinality=1.14K
|  |     in pipelines: 34(GETNEXT)
|  |
|  32:SCAN HDFS [tpcds_parquet.store_sales, RANDOM]
|     HDFS partitions=1824/1824 files=1824 size=200.95MB
|     runtime filters: RF028[bloom] -> ss_sold_time_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=1.00MB thread-reservation=0
|     tuple-ids=24 row-size=12B cardinality=2.88M
|     in pipelines: 32(GETNEXT)
|
66:NESTED LOOP JOIN [CROSS JOIN, BROADCAST]
|  join table id: 16
|  mem-estimate=0B mem-reservation=0B thread-reservation=0
|  tuple-ids=4,10,16,22 row-size=32B cardinality=1
|  in pipelines: 75(GETNEXT), 92(OPEN)
|
|--F56:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.01KB mem-reservation=0B thread-reservation=1
|  JOIN BUILD
|  |  join-table-id=16 plan-id=17 cohort-id=01
|  |  mem-estimate=8B mem-reservation=0B thread-reservation=0
|  |
|  93:EXCHANGE [UNPARTITIONED]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=22 row-size=8B cardinality=1
|  |  in pipelines: 92(GETNEXT)
|  |
|  F19:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
|  Per-Instance Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1
|  92:AGGREGATE [FINALIZE]
|  |  output: count:merge(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=22 row-size=8B cardinality=1
|  |  in pipelines: 92(GETNEXT), 31(OPEN)
|  |
|  91:EXCHANGE [UNPARTITIONED]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=22 row-size=8B cardinality=1
|  |  in pipelines: 31(GETNEXT)
|  |
|  F15:PLAN FRAGMENT [RANDOM] hosts=3 instances=6
|  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=26.00MB mem-reservation=1.00MB thread-reservation=1
|  31:AGGREGATE
|  |  output: count(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=22 row-size=8B cardinality=1
|  |  in pipelines: 31(GETNEXT), 24(OPEN)
|  |
|  30:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash-table-id=17
|  |  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=18,20,19,21 row-size=56B cardinality=2.27K
|  |  in pipelines: 24(GETNEXT), 27(OPEN)
|  |
|  |--F57:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  |  |  Per-Instance Resources: mem-estimate=3.89MB mem-reservation=3.88MB thread-reservation=1
|  |  JOIN BUILD
|  |  |  join-table-id=17 plan-id=18 cohort-id=06
|  |  |  build expressions: s_store_sk
|  |  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  90:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=21 row-size=20B cardinality=2
|  |  |  in pipelines: 27(GETNEXT)
|  |  |
|  |  F18:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=16.00KB thread-reservation=1
|  |  27:SCAN HDFS [tpcds_parquet.store, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=9.93KB
|  |     predicates: store.s_store_name = 'ese'
|  |     stored statistics:
|  |       table: rows=12 size=9.93KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=12
|  |     parquet statistics predicates: store.s_store_name = 'ese'
|  |     parquet dictionary predicates: store.s_store_name = 'ese'
|  |     mem-estimate=16.00MB mem-reservation=16.00KB thread-reservation=0
|  |     tuple-ids=21 row-size=20B cardinality=2
|  |     in pipelines: 27(GETNEXT)
|  |
|  29:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash-table-id=18
|  |  hash predicates: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  fk/pk conjuncts: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=18,20,19 row-size=36B cardinality=6.82K
|  |  in pipelines: 24(GETNEXT), 25(OPEN)
|  |
|  |--F58:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  |  |  Per-Instance Resources: mem-estimate=3.89MB mem-reservation=3.88MB thread-reservation=1
|  |  JOIN BUILD
|  |  |  join-table-id=18 plan-id=19 cohort-id=06
|  |  |  build expressions: household_demographics.hd_demo_sk
|  |  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  89:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=19.69KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=19 row-size=12B cardinality=720
|  |  |  in pipelines: 25(GETNEXT)
|  |  |
|  |  F17:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=64.00KB thread-reservation=1
|  |  25:SCAN HDFS [tpcds_parquet.household_demographics, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=41.69KB
|  |     predicates: ((household_demographics.hd_dep_count = CAST(1 AS INT) AND household_demographics.hd_vehicle_count <= CAST(3 AS INT)) OR (household_demographics.hd_dep_count = CAST(0 AS INT) AND household_demographics.hd_vehicle_count <= CAST(2 AS INT)) OR (household_demographics.hd_dep_count = CAST(2 AS INT) AND household_demographics.hd_vehicle_count <= CAST(4 AS INT)))
|  |     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=19 row-size=12B cardinality=720
|  |     in pipelines: 25(GETNEXT)
|  |
|  28:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash-table-id=19
|  |  hash predicates: ss_sold_time_sk = time_dim.t_time_sk
|  |  fk/pk conjuncts: ss_sold_time_sk = time_dim.t_time_sk
|  |  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=18,20 row-size=24B cardinality=69.82K
|  |  in pipelines: 24(GETNEXT), 26(OPEN)
|  |
|  |--F59:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  |  |  Per-Instance Resources: mem-estimate=4.90MB mem-reservation=4.88MB thread-reservation=1 runtime-filters-memory=1.00MB
|  |  JOIN BUILD
|  |  |  join-table-id=19 plan-id=20 cohort-id=06
|  |  |  build expressions: time_dim.t_time_sk
|  |  |  runtime filters: RF022[bloom] <- time_dim.t_time_sk
|  |  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  88:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=29.34KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=20 row-size=12B cardinality=1.14K
|  |  |  in pipelines: 26(GETNEXT)
|  |  |
|  |  F16:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=512.00KB thread-reservation=1
|  |  26:SCAN HDFS [tpcds_parquet.time_dim, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=1.31MB
|  |     predicates: time_dim.t_hour = CAST(10 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     stored statistics:
|  |       table: rows=86.40K size=1.31MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=86.40K
|  |     parquet statistics predicates: time_dim.t_hour = CAST(10 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     parquet dictionary predicates: time_dim.t_hour = CAST(10 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     mem-estimate=16.00MB mem-reservation=512.00KB thread-reservation=0
|  |     tuple-ids=20 row-size=12B cardinality=1.14K
|  |     in pipelines: 26(GETNEXT)
|  |
|  24:SCAN HDFS [tpcds_parquet.store_sales, RANDOM]
|     HDFS partitions=1824/1824 files=1824 size=200.95MB
|     runtime filters: RF022[bloom] -> ss_sold_time_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=1.00MB thread-reservation=0
|     tuple-ids=18 row-size=12B cardinality=2.88M
|     in pipelines: 24(GETNEXT)
|
65:NESTED LOOP JOIN [CROSS JOIN, BROADCAST]
|  join table id: 20
|  mem-estimate=0B mem-reservation=0B thread-reservation=0
|  tuple-ids=4,10,16 row-size=24B cardinality=1
|  in pipelines: 75(GETNEXT), 86(OPEN)
|
|--F60:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.01KB mem-reservation=0B thread-reservation=1
|  JOIN BUILD
|  |  join-table-id=20 plan-id=21 cohort-id=01
|  |  mem-estimate=8B mem-reservation=0B thread-reservation=0
|  |
|  87:EXCHANGE [UNPARTITIONED]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=16 row-size=8B cardinality=1
|  |  in pipelines: 86(GETNEXT)
|  |
|  F14:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
|  Per-Instance Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1
|  86:AGGREGATE [FINALIZE]
|  |  output: count:merge(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=16 row-size=8B cardinality=1
|  |  in pipelines: 86(GETNEXT), 23(OPEN)
|  |
|  85:EXCHANGE [UNPARTITIONED]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=16 row-size=8B cardinality=1
|  |  in pipelines: 23(GETNEXT)
|  |
|  F10:PLAN FRAGMENT [RANDOM] hosts=3 instances=6
|  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=26.00MB mem-reservation=1.00MB thread-reservation=1
|  23:AGGREGATE
|  |  output: count(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=16 row-size=8B cardinality=1
|  |  in pipelines: 23(GETNEXT), 16(OPEN)
|  |
|  22:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash-table-id=21
|  |  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=12,14,13,15 row-size=56B cardinality=2.27K
|  |  in pipelines: 16(GETNEXT), 19(OPEN)
|  |
|  |--F61:PLAN FRAGMENT [RANDOM] 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=07
|  |  |  build expressions: s_store_sk
|  |  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  84:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=15 row-size=20B cardinality=2
|  |  |  in pipelines: 19(GETNEXT)
|  |  |
|  |  F13:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=16.00KB thread-reservation=1
|  |  19:SCAN HDFS [tpcds_parquet.store, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=9.93KB
|  |     predicates: store.s_store_name = 'ese'
|  |     stored statistics:
|  |       table: rows=12 size=9.93KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=12
|  |     parquet statistics predicates: store.s_store_name = 'ese'
|  |     parquet dictionary predicates: store.s_store_name = 'ese'
|  |     mem-estimate=16.00MB mem-reservation=16.00KB thread-reservation=0
|  |     tuple-ids=15 row-size=20B cardinality=2
|  |     in pipelines: 19(GETNEXT)
|  |
|  21:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash-table-id=22
|  |  hash predicates: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  fk/pk conjuncts: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=12,14,13 row-size=36B cardinality=6.82K
|  |  in pipelines: 16(GETNEXT), 17(OPEN)
|  |
|  |--F62:PLAN FRAGMENT [RANDOM] 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=07
|  |  |  build expressions: household_demographics.hd_demo_sk
|  |  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  83:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=19.69KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=13 row-size=12B cardinality=720
|  |  |  in pipelines: 17(GETNEXT)
|  |  |
|  |  F12:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=64.00KB thread-reservation=1
|  |  17:SCAN HDFS [tpcds_parquet.household_demographics, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=41.69KB
|  |     predicates: ((household_demographics.hd_dep_count = CAST(1 AS INT) AND household_demographics.hd_vehicle_count <= CAST(3 AS INT)) OR (household_demographics.hd_dep_count = CAST(0 AS INT) AND household_demographics.hd_vehicle_count <= CAST(2 AS INT)) OR (household_demographics.hd_dep_count = CAST(2 AS INT) AND household_demographics.hd_vehicle_count <= CAST(4 AS INT)))
|  |     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=13 row-size=12B cardinality=720
|  |     in pipelines: 17(GETNEXT)
|  |
|  20:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash-table-id=23
|  |  hash predicates: ss_sold_time_sk = time_dim.t_time_sk
|  |  fk/pk conjuncts: ss_sold_time_sk = time_dim.t_time_sk
|  |  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=12,14 row-size=24B cardinality=69.82K
|  |  in pipelines: 16(GETNEXT), 18(OPEN)
|  |
|  |--F63:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  |  |  Per-Instance Resources: mem-estimate=4.90MB mem-reservation=4.88MB thread-reservation=1 runtime-filters-memory=1.00MB
|  |  JOIN BUILD
|  |  |  join-table-id=23 plan-id=24 cohort-id=07
|  |  |  build expressions: time_dim.t_time_sk
|  |  |  runtime filters: RF016[bloom] <- time_dim.t_time_sk
|  |  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  82:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=29.34KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=14 row-size=12B cardinality=1.14K
|  |  |  in pipelines: 18(GETNEXT)
|  |  |
|  |  F11:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=512.00KB thread-reservation=1
|  |  18:SCAN HDFS [tpcds_parquet.time_dim, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=1.31MB
|  |     predicates: time_dim.t_hour = CAST(9 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|  |     stored statistics:
|  |       table: rows=86.40K size=1.31MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=86.40K
|  |     parquet statistics predicates: time_dim.t_hour = CAST(9 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|  |     parquet dictionary predicates: time_dim.t_hour = CAST(9 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|  |     mem-estimate=16.00MB mem-reservation=512.00KB thread-reservation=0
|  |     tuple-ids=14 row-size=12B cardinality=1.14K
|  |     in pipelines: 18(GETNEXT)
|  |
|  16:SCAN HDFS [tpcds_parquet.store_sales, RANDOM]
|     HDFS partitions=1824/1824 files=1824 size=200.95MB
|     runtime filters: RF016[bloom] -> ss_sold_time_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=1.00MB thread-reservation=0
|     tuple-ids=12 row-size=12B cardinality=2.88M
|     in pipelines: 16(GETNEXT)
|
64:NESTED LOOP JOIN [CROSS JOIN, BROADCAST]
|  join table id: 24
|  mem-estimate=0B mem-reservation=0B thread-reservation=0
|  tuple-ids=4,10 row-size=16B cardinality=1
|  in pipelines: 75(GETNEXT), 80(OPEN)
|
|--F64:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.01KB mem-reservation=0B thread-reservation=1
|  JOIN BUILD
|  |  join-table-id=24 plan-id=25 cohort-id=01
|  |  mem-estimate=8B mem-reservation=0B thread-reservation=0
|  |
|  81:EXCHANGE [UNPARTITIONED]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=10 row-size=8B cardinality=1
|  |  in pipelines: 80(GETNEXT)
|  |
|  F09:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
|  Per-Instance Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1
|  80:AGGREGATE [FINALIZE]
|  |  output: count:merge(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=10 row-size=8B cardinality=1
|  |  in pipelines: 80(GETNEXT), 15(OPEN)
|  |
|  79:EXCHANGE [UNPARTITIONED]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=10 row-size=8B cardinality=1
|  |  in pipelines: 15(GETNEXT)
|  |
|  F05: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=26.00MB mem-reservation=1.00MB thread-reservation=1
|  15:AGGREGATE
|  |  output: count(*)
|  |  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  |  tuple-ids=10 row-size=8B cardinality=1
|  |  in pipelines: 15(GETNEXT), 08(OPEN)
|  |
|  14:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash-table-id=25
|  |  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=6,8,7,9 row-size=56B cardinality=2.27K
|  |  in pipelines: 08(GETNEXT), 11(OPEN)
|  |
|  |--F65:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  |  |  Per-Instance Resources: mem-estimate=3.89MB mem-reservation=3.88MB thread-reservation=1
|  |  JOIN BUILD
|  |  |  join-table-id=25 plan-id=26 cohort-id=08
|  |  |  build expressions: s_store_sk
|  |  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  78:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=9 row-size=20B cardinality=2
|  |  |  in pipelines: 11(GETNEXT)
|  |  |
|  |  F08:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=16.00KB thread-reservation=1
|  |  11:SCAN HDFS [tpcds_parquet.store, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=9.93KB
|  |     predicates: store.s_store_name = 'ese'
|  |     stored statistics:
|  |       table: rows=12 size=9.93KB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=12
|  |     parquet statistics predicates: store.s_store_name = 'ese'
|  |     parquet dictionary predicates: store.s_store_name = 'ese'
|  |     mem-estimate=16.00MB mem-reservation=16.00KB thread-reservation=0
|  |     tuple-ids=9 row-size=20B cardinality=2
|  |     in pipelines: 11(GETNEXT)
|  |
|  13:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash-table-id=26
|  |  hash predicates: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  fk/pk conjuncts: ss_hdemo_sk = household_demographics.hd_demo_sk
|  |  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=6,8,7 row-size=36B cardinality=6.82K
|  |  in pipelines: 08(GETNEXT), 09(OPEN)
|  |
|  |--F66: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=26 plan-id=27 cohort-id=08
|  |  |  build expressions: household_demographics.hd_demo_sk
|  |  |  runtime filters: RF008[bloom] <- household_demographics.hd_demo_sk
|  |  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  77:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=19.69KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=7 row-size=12B cardinality=720
|  |  |  in pipelines: 09(GETNEXT)
|  |  |
|  |  F07:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=64.00KB thread-reservation=1
|  |  09:SCAN HDFS [tpcds_parquet.household_demographics, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=41.69KB
|  |     predicates: ((household_demographics.hd_dep_count = CAST(1 AS INT) AND household_demographics.hd_vehicle_count <= CAST(3 AS INT)) OR (household_demographics.hd_dep_count = CAST(0 AS INT) AND household_demographics.hd_vehicle_count <= CAST(2 AS INT)) OR (household_demographics.hd_dep_count = CAST(2 AS INT) AND household_demographics.hd_vehicle_count <= CAST(4 AS INT)))
|  |     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=7 row-size=12B cardinality=720
|  |     in pipelines: 09(GETNEXT)
|  |
|  12:HASH JOIN [INNER JOIN, BROADCAST]
|  |  hash-table-id=27
|  |  hash predicates: ss_sold_time_sk = time_dim.t_time_sk
|  |  fk/pk conjuncts: ss_sold_time_sk = time_dim.t_time_sk
|  |  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  |  tuple-ids=6,8 row-size=24B cardinality=69.82K
|  |  in pipelines: 08(GETNEXT), 10(OPEN)
|  |
|  |--F67:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  |  |  Per-Instance Resources: mem-estimate=4.90MB mem-reservation=4.88MB thread-reservation=1 runtime-filters-memory=1.00MB
|  |  JOIN BUILD
|  |  |  join-table-id=27 plan-id=28 cohort-id=08
|  |  |  build expressions: time_dim.t_time_sk
|  |  |  runtime filters: RF010[bloom] <- time_dim.t_time_sk
|  |  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |  |
|  |  76:EXCHANGE [BROADCAST]
|  |  |  mem-estimate=29.34KB mem-reservation=0B thread-reservation=0
|  |  |  tuple-ids=8 row-size=12B cardinality=1.14K
|  |  |  in pipelines: 10(GETNEXT)
|  |  |
|  |  F06:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  |  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=512.00KB thread-reservation=1
|  |  10:SCAN HDFS [tpcds_parquet.time_dim, RANDOM]
|  |     HDFS partitions=1/1 files=1 size=1.31MB
|  |     predicates: time_dim.t_hour = CAST(9 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     stored statistics:
|  |       table: rows=86.40K size=1.31MB
|  |       columns: all
|  |     extrapolated-rows=disabled max-scan-range-rows=86.40K
|  |     parquet statistics predicates: time_dim.t_hour = CAST(9 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     parquet dictionary predicates: time_dim.t_hour = CAST(9 AS INT), time_dim.t_minute < CAST(30 AS INT)
|  |     mem-estimate=16.00MB mem-reservation=512.00KB thread-reservation=0
|  |     tuple-ids=8 row-size=12B cardinality=1.14K
|  |     in pipelines: 10(GETNEXT)
|  |
|  08:SCAN HDFS [tpcds_parquet.store_sales, RANDOM]
|     HDFS partitions=1824/1824 files=1824 size=200.95MB
|     runtime filters: RF010[bloom] -> ss_sold_time_sk, RF008[bloom] -> ss_hdemo_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=1.00MB thread-reservation=0
|     tuple-ids=6 row-size=12B cardinality=2.88M
|     in pipelines: 08(GETNEXT)
|
75:AGGREGATE [FINALIZE]
|  output: count:merge(*)
|  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  tuple-ids=4 row-size=8B cardinality=1
|  in pipelines: 75(GETNEXT), 07(OPEN)
|
74:EXCHANGE [UNPARTITIONED]
|  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  tuple-ids=4 row-size=8B cardinality=1
|  in pipelines: 07(GETNEXT)
|
F00: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=26.00MB mem-reservation=1.00MB thread-reservation=1
07:AGGREGATE
|  output: count(*)
|  mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0
|  tuple-ids=4 row-size=8B cardinality=1
|  in pipelines: 07(GETNEXT), 00(OPEN)
|
06:HASH JOIN [INNER JOIN, BROADCAST]
|  hash-table-id=28
|  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,2,1,3 row-size=56B cardinality=2.27K
|  in pipelines: 00(GETNEXT), 03(OPEN)
|
|--F68:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  |  Per-Instance Resources: mem-estimate=3.89MB mem-reservation=3.88MB thread-reservation=1
|  JOIN BUILD
|  |  join-table-id=28 plan-id=29 cohort-id=01
|  |  build expressions: s_store_sk
|  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |
|  73:EXCHANGE [BROADCAST]
|  |  mem-estimate=16.00KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=3 row-size=20B cardinality=2
|  |  in pipelines: 03(GETNEXT)
|  |
|  F03:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=16.00KB thread-reservation=1
|  03:SCAN HDFS [tpcds_parquet.store, RANDOM]
|     HDFS partitions=1/1 files=1 size=9.93KB
|     predicates: store.s_store_name = 'ese'
|     stored statistics:
|       table: rows=12 size=9.93KB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=12
|     parquet statistics predicates: store.s_store_name = 'ese'
|     parquet dictionary predicates: store.s_store_name = 'ese'
|     mem-estimate=16.00MB mem-reservation=16.00KB thread-reservation=0
|     tuple-ids=3 row-size=20B cardinality=2
|     in pipelines: 03(GETNEXT)
|
05:HASH JOIN [INNER JOIN, BROADCAST]
|  hash-table-id=29
|  hash predicates: ss_hdemo_sk = household_demographics.hd_demo_sk
|  fk/pk conjuncts: ss_hdemo_sk = household_demographics.hd_demo_sk
|  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=0,2,1 row-size=36B cardinality=6.82K
|  in pipelines: 00(GETNEXT), 01(OPEN)
|
|--F69: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=29 plan-id=30 cohort-id=01
|  |  build expressions: household_demographics.hd_demo_sk
|  |  runtime filters: RF002[bloom] <- household_demographics.hd_demo_sk
|  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |
|  72:EXCHANGE [BROADCAST]
|  |  mem-estimate=19.69KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=1 row-size=12B cardinality=720
|  |  in pipelines: 01(GETNEXT)
|  |
|  F02:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=64.00KB thread-reservation=1
|  01:SCAN HDFS [tpcds_parquet.household_demographics, RANDOM]
|     HDFS partitions=1/1 files=1 size=41.69KB
|     predicates: ((household_demographics.hd_dep_count = CAST(1 AS INT) AND household_demographics.hd_vehicle_count <= CAST(3 AS INT)) OR (household_demographics.hd_dep_count = CAST(0 AS INT) AND household_demographics.hd_vehicle_count <= CAST(2 AS INT)) OR (household_demographics.hd_dep_count = CAST(2 AS INT) AND household_demographics.hd_vehicle_count <= CAST(4 AS INT)))
|     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=1 row-size=12B cardinality=720
|     in pipelines: 01(GETNEXT)
|
04:HASH JOIN [INNER JOIN, BROADCAST]
|  hash-table-id=30
|  hash predicates: ss_sold_time_sk = time_dim.t_time_sk
|  fk/pk conjuncts: ss_sold_time_sk = time_dim.t_time_sk
|  mem-estimate=0B mem-reservation=0B spill-buffer=64.00KB thread-reservation=0
|  tuple-ids=0,2 row-size=24B cardinality=69.82K
|  in pipelines: 00(GETNEXT), 02(OPEN)
|
|--F70:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
|  |  Per-Instance Resources: mem-estimate=4.90MB mem-reservation=4.88MB thread-reservation=1 runtime-filters-memory=1.00MB
|  JOIN BUILD
|  |  join-table-id=30 plan-id=31 cohort-id=01
|  |  build expressions: time_dim.t_time_sk
|  |  runtime filters: RF004[bloom] <- time_dim.t_time_sk
|  |  mem-estimate=3.88MB mem-reservation=3.88MB spill-buffer=64.00KB thread-reservation=0
|  |
|  71:EXCHANGE [BROADCAST]
|  |  mem-estimate=29.34KB mem-reservation=0B thread-reservation=0
|  |  tuple-ids=2 row-size=12B cardinality=1.14K
|  |  in pipelines: 02(GETNEXT)
|  |
|  F01:PLAN FRAGMENT [RANDOM] hosts=1 instances=1
|  Per-Instance Resources: mem-estimate=16.00MB mem-reservation=512.00KB thread-reservation=1
|  02:SCAN HDFS [tpcds_parquet.time_dim, RANDOM]
|     HDFS partitions=1/1 files=1 size=1.31MB
|     predicates: time_dim.t_hour = CAST(8 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|     stored statistics:
|       table: rows=86.40K size=1.31MB
|       columns: all
|     extrapolated-rows=disabled max-scan-range-rows=86.40K
|     parquet statistics predicates: time_dim.t_hour = CAST(8 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|     parquet dictionary predicates: time_dim.t_hour = CAST(8 AS INT), time_dim.t_minute >= CAST(30 AS INT)
|     mem-estimate=16.00MB mem-reservation=512.00KB thread-reservation=0
|     tuple-ids=2 row-size=12B cardinality=1.14K
|     in pipelines: 02(GETNEXT)
|
00:SCAN HDFS [tpcds_parquet.store_sales, RANDOM]
   HDFS partitions=1824/1824 files=1824 size=200.95MB
   runtime filters: RF004[bloom] -> ss_sold_time_sk, RF002[bloom] -> ss_hdemo_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=1.00MB thread-reservation=0
   tuple-ids=0 row-size=12B cardinality=2.88M
   in pipelines: 00(GETNEXT)
====