| # TPCDS-Q9 |
| select case when (select count(*) |
| from store_sales |
| where ss_quantity between 1 and 20) > 74129 |
| then (select avg(ss_ext_discount_amt) |
| from store_sales |
| where ss_quantity between 1 and 20) |
| else (select avg(ss_net_profit) |
| from store_sales |
| where ss_quantity between 1 and 20) end bucket1, |
| case when (select count(*) |
| from store_sales |
| where ss_quantity between 21 and 40) > 122840 |
| then (select avg(ss_ext_discount_amt) |
| from store_sales |
| where ss_quantity between 21 and 40) |
| else (select avg(ss_net_profit) |
| from store_sales |
| where ss_quantity between 21 and 40) end bucket2, |
| case when (select count(*) |
| from store_sales |
| where ss_quantity between 41 and 60) > 56580 |
| then (select avg(ss_ext_discount_amt) |
| from store_sales |
| where ss_quantity between 41 and 60) |
| else (select avg(ss_net_profit) |
| from store_sales |
| where ss_quantity between 41 and 60) end bucket3, |
| case when (select count(*) |
| from store_sales |
| where ss_quantity between 61 and 80) > 10097 |
| then (select avg(ss_ext_discount_amt) |
| from store_sales |
| where ss_quantity between 61 and 80) |
| else (select avg(ss_net_profit) |
| from store_sales |
| where ss_quantity between 61 and 80) end bucket4, |
| case when (select count(*) |
| from store_sales |
| where ss_quantity between 81 and 100) > 165306 |
| then (select avg(ss_ext_discount_amt) |
| from store_sales |
| where ss_quantity between 81 and 100) |
| else (select avg(ss_net_profit) |
| from store_sales |
| where ss_quantity between 81 and 100) end bucket5 |
| from reason |
| where r_reason_sk = 1 |
| ---- PLAN |
| Max Per-Host Resource Reservation: Memory=10.63MB Threads=17 |
| Per-Host Resource Estimates: Memory=566MB |
| F00:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 |
| | Per-Host Resources: mem-estimate=566.00MB mem-reservation=10.63MB thread-reservation=17 |
| PLAN-ROOT SINK |
| | output exprs: CASE WHEN count(*) > CAST(74129 AS BIGINT) THEN avg(ss_ext_discount_amt) ELSE avg(ss_net_profit) END, CASE WHEN count(*) > CAST(122840 AS BIGINT) THEN avg(ss_ext_discount_amt) ELSE avg(ss_net_profit) END, CASE WHEN count(*) > CAST(56580 AS BIGINT) THEN avg(ss_ext_discount_amt) ELSE avg(ss_net_profit) END, CASE WHEN count(*) > CAST(10097 AS BIGINT) THEN avg(ss_ext_discount_amt) ELSE avg(ss_net_profit) END, CASE WHEN count(*) > CAST(165306 AS BIGINT) THEN avg(ss_ext_discount_amt) ELSE avg(ss_net_profit) END |
| | mem-estimate=0B mem-reservation=0B thread-reservation=0 |
| | |
| 45:NESTED LOOP JOIN [CROSS JOIN] |
| | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13,17,21,24,28,32,35,39,43,46,50,54 row-size=124B cardinality=1 |
| | in pipelines: 02(GETNEXT), 30(OPEN) |
| | |
| |--30:AGGREGATE [FINALIZE] |
| | | output: avg(ss_net_profit) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=54 row-size=8B cardinality=1 |
| | | in pipelines: 30(GETNEXT), 29(OPEN) |
| | | |
| | 29:SCAN HDFS [tpcds_parquet.store_sales] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(100 AS INT), ss_quantity >= CAST(81 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(100 AS INT), ss_quantity >= CAST(81 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(100 AS INT), ss_quantity >= CAST(81 AS INT) |
| | mem-estimate=32.00MB mem-reservation=1.00MB thread-reservation=1 |
| | tuple-ids=52 row-size=8B cardinality=288.04K |
| | in pipelines: 29(GETNEXT) |
| | |
| 44:NESTED LOOP JOIN [CROSS JOIN] |
| | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13,17,21,24,28,32,35,39,43,46,50 row-size=116B cardinality=1 |
| | in pipelines: 02(GETNEXT), 28(OPEN) |
| | |
| |--28:AGGREGATE [FINALIZE] |
| | | output: avg(ss_ext_discount_amt) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=50 row-size=8B cardinality=1 |
| | | in pipelines: 28(GETNEXT), 27(OPEN) |
| | | |
| | 27:SCAN HDFS [tpcds_parquet.store_sales] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(100 AS INT), ss_quantity >= CAST(81 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(100 AS INT), ss_quantity >= CAST(81 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(100 AS INT), ss_quantity >= CAST(81 AS INT) |
| | mem-estimate=32.00MB mem-reservation=1.00MB thread-reservation=1 |
| | tuple-ids=48 row-size=8B cardinality=288.04K |
| | in pipelines: 27(GETNEXT) |
| | |
| 43:NESTED LOOP JOIN [CROSS JOIN] |
| | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13,17,21,24,28,32,35,39,43,46 row-size=108B cardinality=1 |
| | in pipelines: 02(GETNEXT), 26(OPEN) |
| | |
| |--26: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: 26(GETNEXT), 25(OPEN) |
| | | |
| | 25:SCAN HDFS [tpcds_parquet.store_sales] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(100 AS INT), ss_quantity >= CAST(81 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(100 AS INT), ss_quantity >= CAST(81 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(100 AS INT), ss_quantity >= CAST(81 AS INT) |
| | mem-estimate=16.00MB mem-reservation=128.00KB thread-reservation=1 |
| | tuple-ids=45 row-size=4B cardinality=288.04K |
| | in pipelines: 25(GETNEXT) |
| | |
| 42:NESTED LOOP JOIN [CROSS JOIN] |
| | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13,17,21,24,28,32,35,39,43 row-size=100B cardinality=1 |
| | in pipelines: 02(GETNEXT), 24(OPEN) |
| | |
| |--24:AGGREGATE [FINALIZE] |
| | | output: avg(ss_net_profit) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=43 row-size=8B cardinality=1 |
| | | in pipelines: 24(GETNEXT), 23(OPEN) |
| | | |
| | 23:SCAN HDFS [tpcds_parquet.store_sales] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(80 AS INT), ss_quantity >= CAST(61 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(80 AS INT), ss_quantity >= CAST(61 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(80 AS INT), ss_quantity >= CAST(61 AS INT) |
| | mem-estimate=32.00MB mem-reservation=1.00MB thread-reservation=1 |
| | tuple-ids=41 row-size=8B cardinality=288.04K |
| | in pipelines: 23(GETNEXT) |
| | |
| 41:NESTED LOOP JOIN [CROSS JOIN] |
| | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13,17,21,24,28,32,35,39 row-size=92B cardinality=1 |
| | in pipelines: 02(GETNEXT), 22(OPEN) |
| | |
| |--22:AGGREGATE [FINALIZE] |
| | | output: avg(ss_ext_discount_amt) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=39 row-size=8B cardinality=1 |
| | | in pipelines: 22(GETNEXT), 21(OPEN) |
| | | |
| | 21:SCAN HDFS [tpcds_parquet.store_sales] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(80 AS INT), ss_quantity >= CAST(61 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(80 AS INT), ss_quantity >= CAST(61 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(80 AS INT), ss_quantity >= CAST(61 AS INT) |
| | mem-estimate=32.00MB mem-reservation=1.00MB thread-reservation=1 |
| | tuple-ids=37 row-size=8B cardinality=288.04K |
| | in pipelines: 21(GETNEXT) |
| | |
| 40:NESTED LOOP JOIN [CROSS JOIN] |
| | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13,17,21,24,28,32,35 row-size=84B cardinality=1 |
| | in pipelines: 02(GETNEXT), 20(OPEN) |
| | |
| |--20:AGGREGATE [FINALIZE] |
| | | output: count(*) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=35 row-size=8B cardinality=1 |
| | | in pipelines: 20(GETNEXT), 19(OPEN) |
| | | |
| | 19:SCAN HDFS [tpcds_parquet.store_sales] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(80 AS INT), ss_quantity >= CAST(61 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(80 AS INT), ss_quantity >= CAST(61 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(80 AS INT), ss_quantity >= CAST(61 AS INT) |
| | mem-estimate=16.00MB mem-reservation=128.00KB thread-reservation=1 |
| | tuple-ids=34 row-size=4B cardinality=288.04K |
| | in pipelines: 19(GETNEXT) |
| | |
| 39:NESTED LOOP JOIN [CROSS JOIN] |
| | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13,17,21,24,28,32 row-size=76B cardinality=1 |
| | in pipelines: 02(GETNEXT), 18(OPEN) |
| | |
| |--18:AGGREGATE [FINALIZE] |
| | | output: avg(ss_net_profit) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=32 row-size=8B cardinality=1 |
| | | in pipelines: 18(GETNEXT), 17(OPEN) |
| | | |
| | 17:SCAN HDFS [tpcds_parquet.store_sales] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(60 AS INT), ss_quantity >= CAST(41 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(60 AS INT), ss_quantity >= CAST(41 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(60 AS INT), ss_quantity >= CAST(41 AS INT) |
| | mem-estimate=32.00MB mem-reservation=1.00MB thread-reservation=1 |
| | tuple-ids=30 row-size=8B cardinality=288.04K |
| | in pipelines: 17(GETNEXT) |
| | |
| 38:NESTED LOOP JOIN [CROSS JOIN] |
| | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13,17,21,24,28 row-size=68B cardinality=1 |
| | in pipelines: 02(GETNEXT), 16(OPEN) |
| | |
| |--16:AGGREGATE [FINALIZE] |
| | | output: avg(ss_ext_discount_amt) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=28 row-size=8B cardinality=1 |
| | | in pipelines: 16(GETNEXT), 15(OPEN) |
| | | |
| | 15:SCAN HDFS [tpcds_parquet.store_sales] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(60 AS INT), ss_quantity >= CAST(41 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(60 AS INT), ss_quantity >= CAST(41 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(60 AS INT), ss_quantity >= CAST(41 AS INT) |
| | mem-estimate=32.00MB mem-reservation=1.00MB thread-reservation=1 |
| | tuple-ids=26 row-size=8B cardinality=288.04K |
| | in pipelines: 15(GETNEXT) |
| | |
| 37:NESTED LOOP JOIN [CROSS JOIN] |
| | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13,17,21,24 row-size=60B cardinality=1 |
| | in pipelines: 02(GETNEXT), 14(OPEN) |
| | |
| |--14:AGGREGATE [FINALIZE] |
| | | output: count(*) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=24 row-size=8B cardinality=1 |
| | | in pipelines: 14(GETNEXT), 13(OPEN) |
| | | |
| | 13:SCAN HDFS [tpcds_parquet.store_sales] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(60 AS INT), ss_quantity >= CAST(41 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(60 AS INT), ss_quantity >= CAST(41 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(60 AS INT), ss_quantity >= CAST(41 AS INT) |
| | mem-estimate=16.00MB mem-reservation=128.00KB thread-reservation=1 |
| | tuple-ids=23 row-size=4B cardinality=288.04K |
| | in pipelines: 13(GETNEXT) |
| | |
| 36:NESTED LOOP JOIN [CROSS JOIN] |
| | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13,17,21 row-size=52B cardinality=1 |
| | in pipelines: 02(GETNEXT), 12(OPEN) |
| | |
| |--12:AGGREGATE [FINALIZE] |
| | | output: avg(ss_net_profit) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=21 row-size=8B cardinality=1 |
| | | in pipelines: 12(GETNEXT), 11(OPEN) |
| | | |
| | 11:SCAN HDFS [tpcds_parquet.store_sales] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(40 AS INT), ss_quantity >= CAST(21 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(40 AS INT), ss_quantity >= CAST(21 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(40 AS INT), ss_quantity >= CAST(21 AS INT) |
| | mem-estimate=32.00MB mem-reservation=1.00MB thread-reservation=1 |
| | tuple-ids=19 row-size=8B cardinality=288.04K |
| | in pipelines: 11(GETNEXT) |
| | |
| 35:NESTED LOOP JOIN [CROSS JOIN] |
| | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13,17 row-size=44B cardinality=1 |
| | in pipelines: 02(GETNEXT), 10(OPEN) |
| | |
| |--10:AGGREGATE [FINALIZE] |
| | | output: avg(ss_ext_discount_amt) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=17 row-size=8B cardinality=1 |
| | | in pipelines: 10(GETNEXT), 09(OPEN) |
| | | |
| | 09:SCAN HDFS [tpcds_parquet.store_sales] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(40 AS INT), ss_quantity >= CAST(21 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(40 AS INT), ss_quantity >= CAST(21 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(40 AS INT), ss_quantity >= CAST(21 AS INT) |
| | mem-estimate=32.00MB mem-reservation=1.00MB thread-reservation=1 |
| | tuple-ids=15 row-size=8B cardinality=288.04K |
| | in pipelines: 09(GETNEXT) |
| | |
| 34:NESTED LOOP JOIN [CROSS JOIN] |
| | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13 row-size=36B cardinality=1 |
| | in pipelines: 02(GETNEXT), 08(OPEN) |
| | |
| |--08:AGGREGATE [FINALIZE] |
| | | output: count(*) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=13 row-size=8B cardinality=1 |
| | | in pipelines: 08(GETNEXT), 07(OPEN) |
| | | |
| | 07:SCAN HDFS [tpcds_parquet.store_sales] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(40 AS INT), ss_quantity >= CAST(21 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(40 AS INT), ss_quantity >= CAST(21 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(40 AS INT), ss_quantity >= CAST(21 AS INT) |
| | mem-estimate=16.00MB mem-reservation=128.00KB thread-reservation=1 |
| | tuple-ids=12 row-size=4B cardinality=288.04K |
| | in pipelines: 07(GETNEXT) |
| | |
| 33:NESTED LOOP JOIN [CROSS JOIN] |
| | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10 row-size=28B cardinality=1 |
| | in pipelines: 02(GETNEXT), 06(OPEN) |
| | |
| |--06:AGGREGATE [FINALIZE] |
| | | output: avg(ss_net_profit) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=10 row-size=8B cardinality=1 |
| | | in pipelines: 06(GETNEXT), 05(OPEN) |
| | | |
| | 05:SCAN HDFS [tpcds_parquet.store_sales] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(20 AS INT), ss_quantity >= CAST(1 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(20 AS INT), ss_quantity >= CAST(1 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(20 AS INT), ss_quantity >= CAST(1 AS INT) |
| | mem-estimate=32.00MB mem-reservation=1.00MB thread-reservation=1 |
| | tuple-ids=8 row-size=8B cardinality=288.04K |
| | in pipelines: 05(GETNEXT) |
| | |
| 32:NESTED LOOP JOIN [CROSS JOIN] |
| | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6 row-size=20B cardinality=1 |
| | in pipelines: 02(GETNEXT), 04(OPEN) |
| | |
| |--04:AGGREGATE [FINALIZE] |
| | | output: avg(ss_ext_discount_amt) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=6 row-size=8B cardinality=1 |
| | | in pipelines: 04(GETNEXT), 03(OPEN) |
| | | |
| | 03:SCAN HDFS [tpcds_parquet.store_sales] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(20 AS INT), ss_quantity >= CAST(1 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(20 AS INT), ss_quantity >= CAST(1 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(20 AS INT), ss_quantity >= CAST(1 AS INT) |
| | mem-estimate=32.00MB mem-reservation=1.00MB thread-reservation=1 |
| | tuple-ids=4 row-size=8B cardinality=288.04K |
| | in pipelines: 03(GETNEXT) |
| | |
| 31:NESTED LOOP JOIN [CROSS JOIN] |
| | mem-estimate=4B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0 row-size=12B cardinality=1 |
| | in pipelines: 02(GETNEXT), 00(OPEN) |
| | |
| |--00:SCAN HDFS [tpcds_parquet.reason] |
| | HDFS partitions=1/1 files=1 size=1.92KB |
| | predicates: r_reason_sk = CAST(1 AS INT) |
| | stored statistics: |
| | table: rows=35 size=1.92KB |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=35 |
| | parquet statistics predicates: r_reason_sk = CAST(1 AS INT) |
| | parquet dictionary predicates: r_reason_sk = CAST(1 AS INT) |
| | mem-estimate=16.00MB mem-reservation=8.00KB thread-reservation=1 |
| | tuple-ids=0 row-size=4B cardinality=1 |
| | in pipelines: 00(GETNEXT) |
| | |
| 02:AGGREGATE [FINALIZE] |
| | output: count(*) |
| | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | tuple-ids=2 row-size=8B cardinality=1 |
| | in pipelines: 02(GETNEXT), 01(OPEN) |
| | |
| 01:SCAN HDFS [tpcds_parquet.store_sales] |
| HDFS partitions=1824/1824 files=1824 size=201.02MB |
| predicates: ss_quantity <= CAST(20 AS INT), ss_quantity >= CAST(1 AS INT) |
| stored statistics: |
| table: rows=2.88M size=201.02MB |
| partitions: 1824/1824 rows=2.88M |
| columns: all |
| extrapolated-rows=disabled max-scan-range-rows=130.09K |
| parquet statistics predicates: ss_quantity <= CAST(20 AS INT), ss_quantity >= CAST(1 AS INT) |
| parquet dictionary predicates: ss_quantity <= CAST(20 AS INT), ss_quantity >= CAST(1 AS INT) |
| mem-estimate=16.00MB mem-reservation=128.00KB thread-reservation=1 |
| tuple-ids=1 row-size=4B cardinality=288.04K |
| in pipelines: 01(GETNEXT) |
| ---- DISTRIBUTEDPLAN |
| Max Per-Host Resource Reservation: Memory=10.63MB Threads=47 |
| Per-Host Resource Estimates: Memory=716MB |
| F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 |
| | Per-Host Resources: mem-estimate=10.25MB mem-reservation=0B thread-reservation=1 |
| PLAN-ROOT SINK |
| | output exprs: CASE WHEN count(*) > CAST(74129 AS BIGINT) THEN avg(ss_ext_discount_amt) ELSE avg(ss_net_profit) END, CASE WHEN count(*) > CAST(122840 AS BIGINT) THEN avg(ss_ext_discount_amt) ELSE avg(ss_net_profit) END, CASE WHEN count(*) > CAST(56580 AS BIGINT) THEN avg(ss_ext_discount_amt) ELSE avg(ss_net_profit) END, CASE WHEN count(*) > CAST(10097 AS BIGINT) THEN avg(ss_ext_discount_amt) ELSE avg(ss_net_profit) END, CASE WHEN count(*) > CAST(165306 AS BIGINT) THEN avg(ss_ext_discount_amt) ELSE avg(ss_net_profit) END |
| | mem-estimate=0B mem-reservation=0B thread-reservation=0 |
| | |
| 45:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] |
| | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13,17,21,24,28,32,35,39,43,46,50,54 row-size=124B cardinality=1 |
| | in pipelines: 47(GETNEXT), 89(OPEN) |
| | |
| |--90:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=54 row-size=8B cardinality=1 |
| | | in pipelines: 89(GETNEXT) |
| | | |
| | F30:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 |
| | Per-Host Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1 |
| | 89:AGGREGATE [FINALIZE] |
| | | output: avg:merge(ss_net_profit) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=54 row-size=8B cardinality=1 |
| | | in pipelines: 89(GETNEXT), 30(OPEN) |
| | | |
| | 88:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=53 row-size=8B cardinality=1 |
| | | in pipelines: 30(GETNEXT) |
| | | |
| | F29:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 |
| | Per-Host Resources: mem-estimate=42.00MB mem-reservation=1.00MB thread-reservation=2 |
| | 30:AGGREGATE |
| | | output: avg(ss_net_profit) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=53 row-size=8B cardinality=1 |
| | | in pipelines: 30(GETNEXT), 29(OPEN) |
| | | |
| | 29:SCAN HDFS [tpcds_parquet.store_sales, RANDOM] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(100 AS INT), ss_quantity >= CAST(81 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(100 AS INT), ss_quantity >= CAST(81 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(100 AS INT), ss_quantity >= CAST(81 AS INT) |
| | mem-estimate=32.00MB mem-reservation=1.00MB thread-reservation=1 |
| | tuple-ids=52 row-size=8B cardinality=288.04K |
| | in pipelines: 29(GETNEXT) |
| | |
| 44:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] |
| | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13,17,21,24,28,32,35,39,43,46,50 row-size=116B cardinality=1 |
| | in pipelines: 47(GETNEXT), 86(OPEN) |
| | |
| |--87:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=50 row-size=8B cardinality=1 |
| | | in pipelines: 86(GETNEXT) |
| | | |
| | F28:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 |
| | Per-Host Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1 |
| | 86:AGGREGATE [FINALIZE] |
| | | output: avg:merge(ss_ext_discount_amt) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=50 row-size=8B cardinality=1 |
| | | in pipelines: 86(GETNEXT), 28(OPEN) |
| | | |
| | 85:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=49 row-size=8B cardinality=1 |
| | | in pipelines: 28(GETNEXT) |
| | | |
| | F27:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 |
| | Per-Host Resources: mem-estimate=42.00MB mem-reservation=1.00MB thread-reservation=2 |
| | 28:AGGREGATE |
| | | output: avg(ss_ext_discount_amt) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=49 row-size=8B cardinality=1 |
| | | in pipelines: 28(GETNEXT), 27(OPEN) |
| | | |
| | 27:SCAN HDFS [tpcds_parquet.store_sales, RANDOM] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(100 AS INT), ss_quantity >= CAST(81 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(100 AS INT), ss_quantity >= CAST(81 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(100 AS INT), ss_quantity >= CAST(81 AS INT) |
| | mem-estimate=32.00MB mem-reservation=1.00MB thread-reservation=1 |
| | tuple-ids=48 row-size=8B cardinality=288.04K |
| | in pipelines: 27(GETNEXT) |
| | |
| 43:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] |
| | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13,17,21,24,28,32,35,39,43,46 row-size=108B cardinality=1 |
| | in pipelines: 47(GETNEXT), 83(OPEN) |
| | |
| |--84:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=46 row-size=8B cardinality=1 |
| | | in pipelines: 83(GETNEXT) |
| | | |
| | F26:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 |
| | Per-Host Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1 |
| | 83: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: 83(GETNEXT), 26(OPEN) |
| | | |
| | 82:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=46 row-size=8B cardinality=1 |
| | | in pipelines: 26(GETNEXT) |
| | | |
| | F25:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 |
| | Per-Host Resources: mem-estimate=26.00MB mem-reservation=128.00KB thread-reservation=2 |
| | 26: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: 26(GETNEXT), 25(OPEN) |
| | | |
| | 25:SCAN HDFS [tpcds_parquet.store_sales, RANDOM] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(100 AS INT), ss_quantity >= CAST(81 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(100 AS INT), ss_quantity >= CAST(81 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(100 AS INT), ss_quantity >= CAST(81 AS INT) |
| | mem-estimate=16.00MB mem-reservation=128.00KB thread-reservation=1 |
| | tuple-ids=45 row-size=4B cardinality=288.04K |
| | in pipelines: 25(GETNEXT) |
| | |
| 42:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] |
| | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13,17,21,24,28,32,35,39,43 row-size=100B cardinality=1 |
| | in pipelines: 47(GETNEXT), 80(OPEN) |
| | |
| |--81:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=43 row-size=8B cardinality=1 |
| | | in pipelines: 80(GETNEXT) |
| | | |
| | F24:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 |
| | Per-Host Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1 |
| | 80:AGGREGATE [FINALIZE] |
| | | output: avg:merge(ss_net_profit) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=43 row-size=8B cardinality=1 |
| | | in pipelines: 80(GETNEXT), 24(OPEN) |
| | | |
| | 79:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=42 row-size=8B cardinality=1 |
| | | in pipelines: 24(GETNEXT) |
| | | |
| | F23:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 |
| | Per-Host Resources: mem-estimate=42.00MB mem-reservation=1.00MB thread-reservation=2 |
| | 24:AGGREGATE |
| | | output: avg(ss_net_profit) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=42 row-size=8B cardinality=1 |
| | | in pipelines: 24(GETNEXT), 23(OPEN) |
| | | |
| | 23:SCAN HDFS [tpcds_parquet.store_sales, RANDOM] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(80 AS INT), ss_quantity >= CAST(61 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(80 AS INT), ss_quantity >= CAST(61 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(80 AS INT), ss_quantity >= CAST(61 AS INT) |
| | mem-estimate=32.00MB mem-reservation=1.00MB thread-reservation=1 |
| | tuple-ids=41 row-size=8B cardinality=288.04K |
| | in pipelines: 23(GETNEXT) |
| | |
| 41:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] |
| | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13,17,21,24,28,32,35,39 row-size=92B cardinality=1 |
| | in pipelines: 47(GETNEXT), 77(OPEN) |
| | |
| |--78:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=39 row-size=8B cardinality=1 |
| | | in pipelines: 77(GETNEXT) |
| | | |
| | F22:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 |
| | Per-Host Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1 |
| | 77:AGGREGATE [FINALIZE] |
| | | output: avg:merge(ss_ext_discount_amt) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=39 row-size=8B cardinality=1 |
| | | in pipelines: 77(GETNEXT), 22(OPEN) |
| | | |
| | 76:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=38 row-size=8B cardinality=1 |
| | | in pipelines: 22(GETNEXT) |
| | | |
| | F21:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 |
| | Per-Host Resources: mem-estimate=42.00MB mem-reservation=1.00MB thread-reservation=2 |
| | 22:AGGREGATE |
| | | output: avg(ss_ext_discount_amt) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=38 row-size=8B cardinality=1 |
| | | in pipelines: 22(GETNEXT), 21(OPEN) |
| | | |
| | 21:SCAN HDFS [tpcds_parquet.store_sales, RANDOM] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(80 AS INT), ss_quantity >= CAST(61 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(80 AS INT), ss_quantity >= CAST(61 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(80 AS INT), ss_quantity >= CAST(61 AS INT) |
| | mem-estimate=32.00MB mem-reservation=1.00MB thread-reservation=1 |
| | tuple-ids=37 row-size=8B cardinality=288.04K |
| | in pipelines: 21(GETNEXT) |
| | |
| 40:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] |
| | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13,17,21,24,28,32,35 row-size=84B cardinality=1 |
| | in pipelines: 47(GETNEXT), 74(OPEN) |
| | |
| |--75:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=35 row-size=8B cardinality=1 |
| | | in pipelines: 74(GETNEXT) |
| | | |
| | F20:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 |
| | Per-Host Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1 |
| | 74:AGGREGATE [FINALIZE] |
| | | output: count:merge(*) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=35 row-size=8B cardinality=1 |
| | | in pipelines: 74(GETNEXT), 20(OPEN) |
| | | |
| | 73:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=35 row-size=8B cardinality=1 |
| | | in pipelines: 20(GETNEXT) |
| | | |
| | F19:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 |
| | Per-Host Resources: mem-estimate=26.00MB mem-reservation=128.00KB thread-reservation=2 |
| | 20:AGGREGATE |
| | | output: count(*) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=35 row-size=8B cardinality=1 |
| | | in pipelines: 20(GETNEXT), 19(OPEN) |
| | | |
| | 19:SCAN HDFS [tpcds_parquet.store_sales, RANDOM] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(80 AS INT), ss_quantity >= CAST(61 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(80 AS INT), ss_quantity >= CAST(61 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(80 AS INT), ss_quantity >= CAST(61 AS INT) |
| | mem-estimate=16.00MB mem-reservation=128.00KB thread-reservation=1 |
| | tuple-ids=34 row-size=4B cardinality=288.04K |
| | in pipelines: 19(GETNEXT) |
| | |
| 39:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] |
| | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13,17,21,24,28,32 row-size=76B cardinality=1 |
| | in pipelines: 47(GETNEXT), 71(OPEN) |
| | |
| |--72:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=32 row-size=8B cardinality=1 |
| | | in pipelines: 71(GETNEXT) |
| | | |
| | F18:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 |
| | Per-Host Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1 |
| | 71:AGGREGATE [FINALIZE] |
| | | output: avg:merge(ss_net_profit) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=32 row-size=8B cardinality=1 |
| | | in pipelines: 71(GETNEXT), 18(OPEN) |
| | | |
| | 70:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=31 row-size=8B cardinality=1 |
| | | in pipelines: 18(GETNEXT) |
| | | |
| | F17:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 |
| | Per-Host Resources: mem-estimate=42.00MB mem-reservation=1.00MB thread-reservation=2 |
| | 18:AGGREGATE |
| | | output: avg(ss_net_profit) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=31 row-size=8B cardinality=1 |
| | | in pipelines: 18(GETNEXT), 17(OPEN) |
| | | |
| | 17:SCAN HDFS [tpcds_parquet.store_sales, RANDOM] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(60 AS INT), ss_quantity >= CAST(41 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(60 AS INT), ss_quantity >= CAST(41 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(60 AS INT), ss_quantity >= CAST(41 AS INT) |
| | mem-estimate=32.00MB mem-reservation=1.00MB thread-reservation=1 |
| | tuple-ids=30 row-size=8B cardinality=288.04K |
| | in pipelines: 17(GETNEXT) |
| | |
| 38:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] |
| | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13,17,21,24,28 row-size=68B cardinality=1 |
| | in pipelines: 47(GETNEXT), 68(OPEN) |
| | |
| |--69:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=28 row-size=8B cardinality=1 |
| | | in pipelines: 68(GETNEXT) |
| | | |
| | F16:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 |
| | Per-Host Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1 |
| | 68:AGGREGATE [FINALIZE] |
| | | output: avg:merge(ss_ext_discount_amt) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=28 row-size=8B cardinality=1 |
| | | in pipelines: 68(GETNEXT), 16(OPEN) |
| | | |
| | 67:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=27 row-size=8B cardinality=1 |
| | | in pipelines: 16(GETNEXT) |
| | | |
| | F15:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 |
| | Per-Host Resources: mem-estimate=42.00MB mem-reservation=1.00MB thread-reservation=2 |
| | 16:AGGREGATE |
| | | output: avg(ss_ext_discount_amt) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=27 row-size=8B cardinality=1 |
| | | in pipelines: 16(GETNEXT), 15(OPEN) |
| | | |
| | 15:SCAN HDFS [tpcds_parquet.store_sales, RANDOM] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(60 AS INT), ss_quantity >= CAST(41 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(60 AS INT), ss_quantity >= CAST(41 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(60 AS INT), ss_quantity >= CAST(41 AS INT) |
| | mem-estimate=32.00MB mem-reservation=1.00MB thread-reservation=1 |
| | tuple-ids=26 row-size=8B cardinality=288.04K |
| | in pipelines: 15(GETNEXT) |
| | |
| 37:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] |
| | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13,17,21,24 row-size=60B cardinality=1 |
| | in pipelines: 47(GETNEXT), 65(OPEN) |
| | |
| |--66:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=24 row-size=8B cardinality=1 |
| | | in pipelines: 65(GETNEXT) |
| | | |
| | F14:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 |
| | Per-Host Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1 |
| | 65:AGGREGATE [FINALIZE] |
| | | output: count:merge(*) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=24 row-size=8B cardinality=1 |
| | | in pipelines: 65(GETNEXT), 14(OPEN) |
| | | |
| | 64:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=24 row-size=8B cardinality=1 |
| | | in pipelines: 14(GETNEXT) |
| | | |
| | F13:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 |
| | Per-Host Resources: mem-estimate=26.00MB mem-reservation=128.00KB thread-reservation=2 |
| | 14:AGGREGATE |
| | | output: count(*) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=24 row-size=8B cardinality=1 |
| | | in pipelines: 14(GETNEXT), 13(OPEN) |
| | | |
| | 13:SCAN HDFS [tpcds_parquet.store_sales, RANDOM] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(60 AS INT), ss_quantity >= CAST(41 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(60 AS INT), ss_quantity >= CAST(41 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(60 AS INT), ss_quantity >= CAST(41 AS INT) |
| | mem-estimate=16.00MB mem-reservation=128.00KB thread-reservation=1 |
| | tuple-ids=23 row-size=4B cardinality=288.04K |
| | in pipelines: 13(GETNEXT) |
| | |
| 36:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] |
| | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13,17,21 row-size=52B cardinality=1 |
| | in pipelines: 47(GETNEXT), 62(OPEN) |
| | |
| |--63:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=21 row-size=8B cardinality=1 |
| | | in pipelines: 62(GETNEXT) |
| | | |
| | F12:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 |
| | Per-Host Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1 |
| | 62:AGGREGATE [FINALIZE] |
| | | output: avg:merge(ss_net_profit) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=21 row-size=8B cardinality=1 |
| | | in pipelines: 62(GETNEXT), 12(OPEN) |
| | | |
| | 61:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=20 row-size=8B cardinality=1 |
| | | in pipelines: 12(GETNEXT) |
| | | |
| | F11:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 |
| | Per-Host Resources: mem-estimate=42.00MB mem-reservation=1.00MB thread-reservation=2 |
| | 12:AGGREGATE |
| | | output: avg(ss_net_profit) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=20 row-size=8B cardinality=1 |
| | | in pipelines: 12(GETNEXT), 11(OPEN) |
| | | |
| | 11:SCAN HDFS [tpcds_parquet.store_sales, RANDOM] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(40 AS INT), ss_quantity >= CAST(21 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(40 AS INT), ss_quantity >= CAST(21 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(40 AS INT), ss_quantity >= CAST(21 AS INT) |
| | mem-estimate=32.00MB mem-reservation=1.00MB thread-reservation=1 |
| | tuple-ids=19 row-size=8B cardinality=288.04K |
| | in pipelines: 11(GETNEXT) |
| | |
| 35:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] |
| | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13,17 row-size=44B cardinality=1 |
| | in pipelines: 47(GETNEXT), 59(OPEN) |
| | |
| |--60:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=17 row-size=8B cardinality=1 |
| | | in pipelines: 59(GETNEXT) |
| | | |
| | F10:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 |
| | Per-Host Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1 |
| | 59:AGGREGATE [FINALIZE] |
| | | output: avg:merge(ss_ext_discount_amt) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=17 row-size=8B cardinality=1 |
| | | in pipelines: 59(GETNEXT), 10(OPEN) |
| | | |
| | 58:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=16 row-size=8B cardinality=1 |
| | | in pipelines: 10(GETNEXT) |
| | | |
| | F09:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 |
| | Per-Host Resources: mem-estimate=42.00MB mem-reservation=1.00MB thread-reservation=2 |
| | 10:AGGREGATE |
| | | output: avg(ss_ext_discount_amt) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=16 row-size=8B cardinality=1 |
| | | in pipelines: 10(GETNEXT), 09(OPEN) |
| | | |
| | 09:SCAN HDFS [tpcds_parquet.store_sales, RANDOM] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(40 AS INT), ss_quantity >= CAST(21 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(40 AS INT), ss_quantity >= CAST(21 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(40 AS INT), ss_quantity >= CAST(21 AS INT) |
| | mem-estimate=32.00MB mem-reservation=1.00MB thread-reservation=1 |
| | tuple-ids=15 row-size=8B cardinality=288.04K |
| | in pipelines: 09(GETNEXT) |
| | |
| 34:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] |
| | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13 row-size=36B cardinality=1 |
| | in pipelines: 47(GETNEXT), 56(OPEN) |
| | |
| |--57:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=13 row-size=8B cardinality=1 |
| | | in pipelines: 56(GETNEXT) |
| | | |
| | F08:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 |
| | Per-Host Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1 |
| | 56:AGGREGATE [FINALIZE] |
| | | output: count:merge(*) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=13 row-size=8B cardinality=1 |
| | | in pipelines: 56(GETNEXT), 08(OPEN) |
| | | |
| | 55:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=13 row-size=8B cardinality=1 |
| | | in pipelines: 08(GETNEXT) |
| | | |
| | F07:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 |
| | Per-Host Resources: mem-estimate=26.00MB mem-reservation=128.00KB thread-reservation=2 |
| | 08:AGGREGATE |
| | | output: count(*) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=13 row-size=8B cardinality=1 |
| | | in pipelines: 08(GETNEXT), 07(OPEN) |
| | | |
| | 07:SCAN HDFS [tpcds_parquet.store_sales, RANDOM] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(40 AS INT), ss_quantity >= CAST(21 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(40 AS INT), ss_quantity >= CAST(21 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(40 AS INT), ss_quantity >= CAST(21 AS INT) |
| | mem-estimate=16.00MB mem-reservation=128.00KB thread-reservation=1 |
| | tuple-ids=12 row-size=4B cardinality=288.04K |
| | in pipelines: 07(GETNEXT) |
| | |
| 33:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] |
| | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10 row-size=28B cardinality=1 |
| | in pipelines: 47(GETNEXT), 53(OPEN) |
| | |
| |--54:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=10 row-size=8B cardinality=1 |
| | | in pipelines: 53(GETNEXT) |
| | | |
| | F06:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 |
| | Per-Host Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1 |
| | 53:AGGREGATE [FINALIZE] |
| | | output: avg:merge(ss_net_profit) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=10 row-size=8B cardinality=1 |
| | | in pipelines: 53(GETNEXT), 06(OPEN) |
| | | |
| | 52:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=9 row-size=8B cardinality=1 |
| | | in pipelines: 06(GETNEXT) |
| | | |
| | F05:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 |
| | Per-Host Resources: mem-estimate=42.00MB mem-reservation=1.00MB thread-reservation=2 |
| | 06:AGGREGATE |
| | | output: avg(ss_net_profit) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=9 row-size=8B cardinality=1 |
| | | in pipelines: 06(GETNEXT), 05(OPEN) |
| | | |
| | 05:SCAN HDFS [tpcds_parquet.store_sales, RANDOM] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(20 AS INT), ss_quantity >= CAST(1 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(20 AS INT), ss_quantity >= CAST(1 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(20 AS INT), ss_quantity >= CAST(1 AS INT) |
| | mem-estimate=32.00MB mem-reservation=1.00MB thread-reservation=1 |
| | tuple-ids=8 row-size=8B cardinality=288.04K |
| | in pipelines: 05(GETNEXT) |
| | |
| 32:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] |
| | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6 row-size=20B cardinality=1 |
| | in pipelines: 47(GETNEXT), 50(OPEN) |
| | |
| |--51:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=6 row-size=8B cardinality=1 |
| | | in pipelines: 50(GETNEXT) |
| | | |
| | F04:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 |
| | Per-Host Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1 |
| | 50:AGGREGATE [FINALIZE] |
| | | output: avg:merge(ss_ext_discount_amt) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=6 row-size=8B cardinality=1 |
| | | in pipelines: 50(GETNEXT), 04(OPEN) |
| | | |
| | 49:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=5 row-size=8B cardinality=1 |
| | | in pipelines: 04(GETNEXT) |
| | | |
| | F03:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 |
| | Per-Host Resources: mem-estimate=42.00MB mem-reservation=1.00MB thread-reservation=2 |
| | 04:AGGREGATE |
| | | output: avg(ss_ext_discount_amt) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=5 row-size=8B cardinality=1 |
| | | in pipelines: 04(GETNEXT), 03(OPEN) |
| | | |
| | 03:SCAN HDFS [tpcds_parquet.store_sales, RANDOM] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(20 AS INT), ss_quantity >= CAST(1 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(20 AS INT), ss_quantity >= CAST(1 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(20 AS INT), ss_quantity >= CAST(1 AS INT) |
| | mem-estimate=32.00MB mem-reservation=1.00MB thread-reservation=1 |
| | tuple-ids=4 row-size=8B cardinality=288.04K |
| | in pipelines: 03(GETNEXT) |
| | |
| 31:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] |
| | mem-estimate=4B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0 row-size=12B cardinality=1 |
| | in pipelines: 47(GETNEXT), 00(OPEN) |
| | |
| |--48:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=0 row-size=4B cardinality=1 |
| | | in pipelines: 00(GETNEXT) |
| | | |
| | F02:PLAN FRAGMENT [RANDOM] hosts=1 instances=1 |
| | Per-Host Resources: mem-estimate=16.00MB mem-reservation=8.00KB thread-reservation=2 |
| | 00:SCAN HDFS [tpcds_parquet.reason, RANDOM] |
| | HDFS partitions=1/1 files=1 size=1.92KB |
| | predicates: r_reason_sk = CAST(1 AS INT) |
| | stored statistics: |
| | table: rows=35 size=1.92KB |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=35 |
| | parquet statistics predicates: r_reason_sk = CAST(1 AS INT) |
| | parquet dictionary predicates: r_reason_sk = CAST(1 AS INT) |
| | mem-estimate=16.00MB mem-reservation=8.00KB thread-reservation=1 |
| | tuple-ids=0 row-size=4B cardinality=1 |
| | in pipelines: 00(GETNEXT) |
| | |
| 47:AGGREGATE [FINALIZE] |
| | output: count:merge(*) |
| | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | tuple-ids=2 row-size=8B cardinality=1 |
| | in pipelines: 47(GETNEXT), 02(OPEN) |
| | |
| 46:EXCHANGE [UNPARTITIONED] |
| | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2 row-size=8B cardinality=1 |
| | in pipelines: 02(GETNEXT) |
| | |
| F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 |
| Per-Host Resources: mem-estimate=26.00MB mem-reservation=128.00KB thread-reservation=2 |
| 02:AGGREGATE |
| | output: count(*) |
| | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | tuple-ids=2 row-size=8B cardinality=1 |
| | in pipelines: 02(GETNEXT), 01(OPEN) |
| | |
| 01:SCAN HDFS [tpcds_parquet.store_sales, RANDOM] |
| HDFS partitions=1824/1824 files=1824 size=201.02MB |
| predicates: ss_quantity <= CAST(20 AS INT), ss_quantity >= CAST(1 AS INT) |
| stored statistics: |
| table: rows=2.88M size=201.02MB |
| partitions: 1824/1824 rows=2.88M |
| columns: all |
| extrapolated-rows=disabled max-scan-range-rows=130.09K |
| parquet statistics predicates: ss_quantity <= CAST(20 AS INT), ss_quantity >= CAST(1 AS INT) |
| parquet dictionary predicates: ss_quantity <= CAST(20 AS INT), ss_quantity >= CAST(1 AS INT) |
| mem-estimate=16.00MB mem-reservation=128.00KB thread-reservation=1 |
| tuple-ids=1 row-size=4B cardinality=288.04K |
| in pipelines: 01(GETNEXT) |
| ---- PARALLELPLANS |
| Max Per-Host Resource Reservation: Memory=21.26MB Threads=61 |
| Per-Host Resource Estimates: Memory=946MB |
| F01: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: CASE WHEN count(*) > CAST(74129 AS BIGINT) THEN avg(ss_ext_discount_amt) ELSE avg(ss_net_profit) END, CASE WHEN count(*) > CAST(122840 AS BIGINT) THEN avg(ss_ext_discount_amt) ELSE avg(ss_net_profit) END, CASE WHEN count(*) > CAST(56580 AS BIGINT) THEN avg(ss_ext_discount_amt) ELSE avg(ss_net_profit) END, CASE WHEN count(*) > CAST(10097 AS BIGINT) THEN avg(ss_ext_discount_amt) ELSE avg(ss_net_profit) END, CASE WHEN count(*) > CAST(165306 AS BIGINT) THEN avg(ss_ext_discount_amt) ELSE avg(ss_net_profit) END |
| | mem-estimate=0B mem-reservation=0B thread-reservation=0 |
| | |
| 45:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] |
| | join table id: 00 |
| | mem-estimate=0B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13,17,21,24,28,32,35,39,43,46,50,54 row-size=124B cardinality=1 |
| | in pipelines: 47(GETNEXT), 89(OPEN) |
| | |
| |--F31: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 |
| | | |
| | 90:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=54 row-size=8B cardinality=1 |
| | | in pipelines: 89(GETNEXT) |
| | | |
| | F30:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 |
| | Per-Instance Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1 |
| | 89:AGGREGATE [FINALIZE] |
| | | output: avg:merge(ss_net_profit) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=54 row-size=8B cardinality=1 |
| | | in pipelines: 89(GETNEXT), 30(OPEN) |
| | | |
| | 88:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=53 row-size=8B cardinality=1 |
| | | in pipelines: 30(GETNEXT) |
| | | |
| | F29:PLAN FRAGMENT [RANDOM] hosts=3 instances=6 |
| | Per-Instance Resources: mem-estimate=26.00MB mem-reservation=1.00MB thread-reservation=1 |
| | 30:AGGREGATE |
| | | output: avg(ss_net_profit) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=53 row-size=8B cardinality=1 |
| | | in pipelines: 30(GETNEXT), 29(OPEN) |
| | | |
| | 29:SCAN HDFS [tpcds_parquet.store_sales, RANDOM] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(100 AS INT), ss_quantity >= CAST(81 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(100 AS INT), ss_quantity >= CAST(81 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(100 AS INT), ss_quantity >= CAST(81 AS INT) |
| | mem-estimate=16.00MB mem-reservation=1.00MB thread-reservation=0 |
| | tuple-ids=52 row-size=8B cardinality=288.04K |
| | in pipelines: 29(GETNEXT) |
| | |
| 44:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] |
| | join table id: 01 |
| | mem-estimate=0B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13,17,21,24,28,32,35,39,43,46,50 row-size=116B cardinality=1 |
| | in pipelines: 47(GETNEXT), 86(OPEN) |
| | |
| |--F32: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=01 plan-id=02 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=50 row-size=8B cardinality=1 |
| | | in pipelines: 86(GETNEXT) |
| | | |
| | F28:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 |
| | Per-Instance Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1 |
| | 86:AGGREGATE [FINALIZE] |
| | | output: avg:merge(ss_ext_discount_amt) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=50 row-size=8B cardinality=1 |
| | | in pipelines: 86(GETNEXT), 28(OPEN) |
| | | |
| | 85:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=49 row-size=8B cardinality=1 |
| | | in pipelines: 28(GETNEXT) |
| | | |
| | F27:PLAN FRAGMENT [RANDOM] hosts=3 instances=6 |
| | Per-Instance Resources: mem-estimate=26.00MB mem-reservation=1.00MB thread-reservation=1 |
| | 28:AGGREGATE |
| | | output: avg(ss_ext_discount_amt) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=49 row-size=8B cardinality=1 |
| | | in pipelines: 28(GETNEXT), 27(OPEN) |
| | | |
| | 27:SCAN HDFS [tpcds_parquet.store_sales, RANDOM] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(100 AS INT), ss_quantity >= CAST(81 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(100 AS INT), ss_quantity >= CAST(81 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(100 AS INT), ss_quantity >= CAST(81 AS INT) |
| | mem-estimate=16.00MB mem-reservation=1.00MB thread-reservation=0 |
| | tuple-ids=48 row-size=8B cardinality=288.04K |
| | in pipelines: 27(GETNEXT) |
| | |
| 43:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] |
| | join table id: 02 |
| | mem-estimate=0B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13,17,21,24,28,32,35,39,43,46 row-size=108B cardinality=1 |
| | in pipelines: 47(GETNEXT), 83(OPEN) |
| | |
| |--F33: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=02 plan-id=03 cohort-id=01 |
| | | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | | |
| | 84:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=46 row-size=8B cardinality=1 |
| | | in pipelines: 83(GETNEXT) |
| | | |
| | F26:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 |
| | Per-Instance Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1 |
| | 83: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: 83(GETNEXT), 26(OPEN) |
| | | |
| | 82:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=46 row-size=8B cardinality=1 |
| | | in pipelines: 26(GETNEXT) |
| | | |
| | F25:PLAN FRAGMENT [RANDOM] hosts=3 instances=6 |
| | Per-Instance Resources: mem-estimate=26.00MB mem-reservation=128.00KB thread-reservation=1 |
| | 26: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: 26(GETNEXT), 25(OPEN) |
| | | |
| | 25:SCAN HDFS [tpcds_parquet.store_sales, RANDOM] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(100 AS INT), ss_quantity >= CAST(81 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(100 AS INT), ss_quantity >= CAST(81 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(100 AS INT), ss_quantity >= CAST(81 AS INT) |
| | mem-estimate=16.00MB mem-reservation=128.00KB thread-reservation=0 |
| | tuple-ids=45 row-size=4B cardinality=288.04K |
| | in pipelines: 25(GETNEXT) |
| | |
| 42:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] |
| | join table id: 03 |
| | mem-estimate=0B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13,17,21,24,28,32,35,39,43 row-size=100B cardinality=1 |
| | in pipelines: 47(GETNEXT), 80(OPEN) |
| | |
| |--F34: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=03 plan-id=04 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=43 row-size=8B cardinality=1 |
| | | in pipelines: 80(GETNEXT) |
| | | |
| | F24:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 |
| | Per-Instance Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1 |
| | 80:AGGREGATE [FINALIZE] |
| | | output: avg:merge(ss_net_profit) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=43 row-size=8B cardinality=1 |
| | | in pipelines: 80(GETNEXT), 24(OPEN) |
| | | |
| | 79:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=42 row-size=8B cardinality=1 |
| | | in pipelines: 24(GETNEXT) |
| | | |
| | F23:PLAN FRAGMENT [RANDOM] hosts=3 instances=6 |
| | Per-Instance Resources: mem-estimate=26.00MB mem-reservation=1.00MB thread-reservation=1 |
| | 24:AGGREGATE |
| | | output: avg(ss_net_profit) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=42 row-size=8B cardinality=1 |
| | | in pipelines: 24(GETNEXT), 23(OPEN) |
| | | |
| | 23:SCAN HDFS [tpcds_parquet.store_sales, RANDOM] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(80 AS INT), ss_quantity >= CAST(61 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(80 AS INT), ss_quantity >= CAST(61 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(80 AS INT), ss_quantity >= CAST(61 AS INT) |
| | mem-estimate=16.00MB mem-reservation=1.00MB thread-reservation=0 |
| | tuple-ids=41 row-size=8B cardinality=288.04K |
| | in pipelines: 23(GETNEXT) |
| | |
| 41:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] |
| | join table id: 04 |
| | mem-estimate=0B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13,17,21,24,28,32,35,39 row-size=92B cardinality=1 |
| | in pipelines: 47(GETNEXT), 77(OPEN) |
| | |
| |--F35: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 |
| | | |
| | 78:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=39 row-size=8B cardinality=1 |
| | | in pipelines: 77(GETNEXT) |
| | | |
| | F22:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 |
| | Per-Instance Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1 |
| | 77:AGGREGATE [FINALIZE] |
| | | output: avg:merge(ss_ext_discount_amt) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=39 row-size=8B cardinality=1 |
| | | in pipelines: 77(GETNEXT), 22(OPEN) |
| | | |
| | 76:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=38 row-size=8B cardinality=1 |
| | | in pipelines: 22(GETNEXT) |
| | | |
| | F21:PLAN FRAGMENT [RANDOM] hosts=3 instances=6 |
| | Per-Instance Resources: mem-estimate=26.00MB mem-reservation=1.00MB thread-reservation=1 |
| | 22:AGGREGATE |
| | | output: avg(ss_ext_discount_amt) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=38 row-size=8B cardinality=1 |
| | | in pipelines: 22(GETNEXT), 21(OPEN) |
| | | |
| | 21:SCAN HDFS [tpcds_parquet.store_sales, RANDOM] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(80 AS INT), ss_quantity >= CAST(61 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(80 AS INT), ss_quantity >= CAST(61 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(80 AS INT), ss_quantity >= CAST(61 AS INT) |
| | mem-estimate=16.00MB mem-reservation=1.00MB thread-reservation=0 |
| | tuple-ids=37 row-size=8B cardinality=288.04K |
| | in pipelines: 21(GETNEXT) |
| | |
| 40:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] |
| | join table id: 05 |
| | mem-estimate=0B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13,17,21,24,28,32,35 row-size=84B cardinality=1 |
| | in pipelines: 47(GETNEXT), 74(OPEN) |
| | |
| |--F36: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=05 plan-id=06 cohort-id=01 |
| | | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | | |
| | 75:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=35 row-size=8B cardinality=1 |
| | | in pipelines: 74(GETNEXT) |
| | | |
| | F20:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 |
| | Per-Instance Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1 |
| | 74:AGGREGATE [FINALIZE] |
| | | output: count:merge(*) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=35 row-size=8B cardinality=1 |
| | | in pipelines: 74(GETNEXT), 20(OPEN) |
| | | |
| | 73:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=35 row-size=8B cardinality=1 |
| | | in pipelines: 20(GETNEXT) |
| | | |
| | F19:PLAN FRAGMENT [RANDOM] hosts=3 instances=6 |
| | Per-Instance Resources: mem-estimate=26.00MB mem-reservation=128.00KB thread-reservation=1 |
| | 20:AGGREGATE |
| | | output: count(*) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=35 row-size=8B cardinality=1 |
| | | in pipelines: 20(GETNEXT), 19(OPEN) |
| | | |
| | 19:SCAN HDFS [tpcds_parquet.store_sales, RANDOM] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(80 AS INT), ss_quantity >= CAST(61 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(80 AS INT), ss_quantity >= CAST(61 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(80 AS INT), ss_quantity >= CAST(61 AS INT) |
| | mem-estimate=16.00MB mem-reservation=128.00KB thread-reservation=0 |
| | tuple-ids=34 row-size=4B cardinality=288.04K |
| | in pipelines: 19(GETNEXT) |
| | |
| 39:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] |
| | join table id: 06 |
| | mem-estimate=0B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13,17,21,24,28,32 row-size=76B cardinality=1 |
| | in pipelines: 47(GETNEXT), 71(OPEN) |
| | |
| |--F37: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=06 plan-id=07 cohort-id=01 |
| | | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | | |
| | 72:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=32 row-size=8B cardinality=1 |
| | | in pipelines: 71(GETNEXT) |
| | | |
| | F18:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 |
| | Per-Instance Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1 |
| | 71:AGGREGATE [FINALIZE] |
| | | output: avg:merge(ss_net_profit) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=32 row-size=8B cardinality=1 |
| | | in pipelines: 71(GETNEXT), 18(OPEN) |
| | | |
| | 70:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=31 row-size=8B cardinality=1 |
| | | in pipelines: 18(GETNEXT) |
| | | |
| | F17:PLAN FRAGMENT [RANDOM] hosts=3 instances=6 |
| | Per-Instance Resources: mem-estimate=26.00MB mem-reservation=1.00MB thread-reservation=1 |
| | 18:AGGREGATE |
| | | output: avg(ss_net_profit) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=31 row-size=8B cardinality=1 |
| | | in pipelines: 18(GETNEXT), 17(OPEN) |
| | | |
| | 17:SCAN HDFS [tpcds_parquet.store_sales, RANDOM] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(60 AS INT), ss_quantity >= CAST(41 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(60 AS INT), ss_quantity >= CAST(41 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(60 AS INT), ss_quantity >= CAST(41 AS INT) |
| | mem-estimate=16.00MB mem-reservation=1.00MB thread-reservation=0 |
| | tuple-ids=30 row-size=8B cardinality=288.04K |
| | in pipelines: 17(GETNEXT) |
| | |
| 38:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] |
| | join table id: 07 |
| | mem-estimate=0B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13,17,21,24,28 row-size=68B cardinality=1 |
| | in pipelines: 47(GETNEXT), 68(OPEN) |
| | |
| |--F38: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=07 plan-id=08 cohort-id=01 |
| | | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | | |
| | 69:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=28 row-size=8B cardinality=1 |
| | | in pipelines: 68(GETNEXT) |
| | | |
| | F16:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 |
| | Per-Instance Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1 |
| | 68:AGGREGATE [FINALIZE] |
| | | output: avg:merge(ss_ext_discount_amt) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=28 row-size=8B cardinality=1 |
| | | in pipelines: 68(GETNEXT), 16(OPEN) |
| | | |
| | 67:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=27 row-size=8B cardinality=1 |
| | | in pipelines: 16(GETNEXT) |
| | | |
| | F15:PLAN FRAGMENT [RANDOM] hosts=3 instances=6 |
| | Per-Instance Resources: mem-estimate=26.00MB mem-reservation=1.00MB thread-reservation=1 |
| | 16:AGGREGATE |
| | | output: avg(ss_ext_discount_amt) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=27 row-size=8B cardinality=1 |
| | | in pipelines: 16(GETNEXT), 15(OPEN) |
| | | |
| | 15:SCAN HDFS [tpcds_parquet.store_sales, RANDOM] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(60 AS INT), ss_quantity >= CAST(41 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(60 AS INT), ss_quantity >= CAST(41 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(60 AS INT), ss_quantity >= CAST(41 AS INT) |
| | mem-estimate=16.00MB mem-reservation=1.00MB thread-reservation=0 |
| | tuple-ids=26 row-size=8B cardinality=288.04K |
| | in pipelines: 15(GETNEXT) |
| | |
| 37:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] |
| | join table id: 08 |
| | mem-estimate=0B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13,17,21,24 row-size=60B cardinality=1 |
| | in pipelines: 47(GETNEXT), 65(OPEN) |
| | |
| |--F39: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 |
| | | |
| | 66:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=24 row-size=8B cardinality=1 |
| | | in pipelines: 65(GETNEXT) |
| | | |
| | F14:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 |
| | Per-Instance Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1 |
| | 65:AGGREGATE [FINALIZE] |
| | | output: count:merge(*) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=24 row-size=8B cardinality=1 |
| | | in pipelines: 65(GETNEXT), 14(OPEN) |
| | | |
| | 64:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=24 row-size=8B cardinality=1 |
| | | in pipelines: 14(GETNEXT) |
| | | |
| | F13:PLAN FRAGMENT [RANDOM] hosts=3 instances=6 |
| | Per-Instance Resources: mem-estimate=26.00MB mem-reservation=128.00KB thread-reservation=1 |
| | 14:AGGREGATE |
| | | output: count(*) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=24 row-size=8B cardinality=1 |
| | | in pipelines: 14(GETNEXT), 13(OPEN) |
| | | |
| | 13:SCAN HDFS [tpcds_parquet.store_sales, RANDOM] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(60 AS INT), ss_quantity >= CAST(41 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(60 AS INT), ss_quantity >= CAST(41 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(60 AS INT), ss_quantity >= CAST(41 AS INT) |
| | mem-estimate=16.00MB mem-reservation=128.00KB thread-reservation=0 |
| | tuple-ids=23 row-size=4B cardinality=288.04K |
| | in pipelines: 13(GETNEXT) |
| | |
| 36:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] |
| | join table id: 09 |
| | mem-estimate=0B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13,17,21 row-size=52B cardinality=1 |
| | in pipelines: 47(GETNEXT), 62(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=09 plan-id=10 cohort-id=01 |
| | | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | | |
| | 63:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=21 row-size=8B cardinality=1 |
| | | in pipelines: 62(GETNEXT) |
| | | |
| | F12:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 |
| | Per-Instance Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1 |
| | 62:AGGREGATE [FINALIZE] |
| | | output: avg:merge(ss_net_profit) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=21 row-size=8B cardinality=1 |
| | | in pipelines: 62(GETNEXT), 12(OPEN) |
| | | |
| | 61:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=20 row-size=8B cardinality=1 |
| | | in pipelines: 12(GETNEXT) |
| | | |
| | F11:PLAN FRAGMENT [RANDOM] hosts=3 instances=6 |
| | Per-Instance Resources: mem-estimate=26.00MB mem-reservation=1.00MB thread-reservation=1 |
| | 12:AGGREGATE |
| | | output: avg(ss_net_profit) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=20 row-size=8B cardinality=1 |
| | | in pipelines: 12(GETNEXT), 11(OPEN) |
| | | |
| | 11:SCAN HDFS [tpcds_parquet.store_sales, RANDOM] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(40 AS INT), ss_quantity >= CAST(21 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(40 AS INT), ss_quantity >= CAST(21 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(40 AS INT), ss_quantity >= CAST(21 AS INT) |
| | mem-estimate=16.00MB mem-reservation=1.00MB thread-reservation=0 |
| | tuple-ids=19 row-size=8B cardinality=288.04K |
| | in pipelines: 11(GETNEXT) |
| | |
| 35:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] |
| | join table id: 10 |
| | mem-estimate=0B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13,17 row-size=44B cardinality=1 |
| | in pipelines: 47(GETNEXT), 59(OPEN) |
| | |
| |--F41: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=10 plan-id=11 cohort-id=01 |
| | | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | | |
| | 60:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=17 row-size=8B cardinality=1 |
| | | in pipelines: 59(GETNEXT) |
| | | |
| | F10:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 |
| | Per-Instance Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1 |
| | 59:AGGREGATE [FINALIZE] |
| | | output: avg:merge(ss_ext_discount_amt) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=17 row-size=8B cardinality=1 |
| | | in pipelines: 59(GETNEXT), 10(OPEN) |
| | | |
| | 58:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=16 row-size=8B cardinality=1 |
| | | in pipelines: 10(GETNEXT) |
| | | |
| | F09:PLAN FRAGMENT [RANDOM] hosts=3 instances=6 |
| | Per-Instance Resources: mem-estimate=26.00MB mem-reservation=1.00MB thread-reservation=1 |
| | 10:AGGREGATE |
| | | output: avg(ss_ext_discount_amt) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=16 row-size=8B cardinality=1 |
| | | in pipelines: 10(GETNEXT), 09(OPEN) |
| | | |
| | 09:SCAN HDFS [tpcds_parquet.store_sales, RANDOM] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(40 AS INT), ss_quantity >= CAST(21 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(40 AS INT), ss_quantity >= CAST(21 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(40 AS INT), ss_quantity >= CAST(21 AS INT) |
| | mem-estimate=16.00MB mem-reservation=1.00MB thread-reservation=0 |
| | tuple-ids=15 row-size=8B cardinality=288.04K |
| | in pipelines: 09(GETNEXT) |
| | |
| 34:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] |
| | join table id: 11 |
| | mem-estimate=0B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10,13 row-size=36B cardinality=1 |
| | in pipelines: 47(GETNEXT), 56(OPEN) |
| | |
| |--F42: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=11 plan-id=12 cohort-id=01 |
| | | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | | |
| | 57:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=13 row-size=8B cardinality=1 |
| | | in pipelines: 56(GETNEXT) |
| | | |
| | F08:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 |
| | Per-Instance Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1 |
| | 56:AGGREGATE [FINALIZE] |
| | | output: count:merge(*) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=13 row-size=8B cardinality=1 |
| | | in pipelines: 56(GETNEXT), 08(OPEN) |
| | | |
| | 55:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=13 row-size=8B cardinality=1 |
| | | in pipelines: 08(GETNEXT) |
| | | |
| | F07:PLAN FRAGMENT [RANDOM] hosts=3 instances=6 |
| | Per-Instance Resources: mem-estimate=26.00MB mem-reservation=128.00KB thread-reservation=1 |
| | 08:AGGREGATE |
| | | output: count(*) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=13 row-size=8B cardinality=1 |
| | | in pipelines: 08(GETNEXT), 07(OPEN) |
| | | |
| | 07:SCAN HDFS [tpcds_parquet.store_sales, RANDOM] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(40 AS INT), ss_quantity >= CAST(21 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(40 AS INT), ss_quantity >= CAST(21 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(40 AS INT), ss_quantity >= CAST(21 AS INT) |
| | mem-estimate=16.00MB mem-reservation=128.00KB thread-reservation=0 |
| | tuple-ids=12 row-size=4B cardinality=288.04K |
| | in pipelines: 07(GETNEXT) |
| | |
| 33:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] |
| | join table id: 12 |
| | mem-estimate=0B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6,10 row-size=28B cardinality=1 |
| | in pipelines: 47(GETNEXT), 53(OPEN) |
| | |
| |--F43: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 |
| | | |
| | 54:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=10 row-size=8B cardinality=1 |
| | | in pipelines: 53(GETNEXT) |
| | | |
| | F06:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 |
| | Per-Instance Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1 |
| | 53:AGGREGATE [FINALIZE] |
| | | output: avg:merge(ss_net_profit) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=10 row-size=8B cardinality=1 |
| | | in pipelines: 53(GETNEXT), 06(OPEN) |
| | | |
| | 52:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=9 row-size=8B cardinality=1 |
| | | in pipelines: 06(GETNEXT) |
| | | |
| | F05:PLAN FRAGMENT [RANDOM] hosts=3 instances=6 |
| | Per-Instance Resources: mem-estimate=26.00MB mem-reservation=1.00MB thread-reservation=1 |
| | 06:AGGREGATE |
| | | output: avg(ss_net_profit) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=9 row-size=8B cardinality=1 |
| | | in pipelines: 06(GETNEXT), 05(OPEN) |
| | | |
| | 05:SCAN HDFS [tpcds_parquet.store_sales, RANDOM] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(20 AS INT), ss_quantity >= CAST(1 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(20 AS INT), ss_quantity >= CAST(1 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(20 AS INT), ss_quantity >= CAST(1 AS INT) |
| | mem-estimate=16.00MB mem-reservation=1.00MB thread-reservation=0 |
| | tuple-ids=8 row-size=8B cardinality=288.04K |
| | in pipelines: 05(GETNEXT) |
| | |
| 32:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] |
| | join table id: 13 |
| | mem-estimate=0B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0,6 row-size=20B cardinality=1 |
| | in pipelines: 47(GETNEXT), 50(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=13 plan-id=14 cohort-id=01 |
| | | mem-estimate=8B mem-reservation=0B thread-reservation=0 |
| | | |
| | 51:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=6 row-size=8B cardinality=1 |
| | | in pipelines: 50(GETNEXT) |
| | | |
| | F04:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 |
| | Per-Instance Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1 |
| | 50:AGGREGATE [FINALIZE] |
| | | output: avg:merge(ss_ext_discount_amt) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=6 row-size=8B cardinality=1 |
| | | in pipelines: 50(GETNEXT), 04(OPEN) |
| | | |
| | 49:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=5 row-size=8B cardinality=1 |
| | | in pipelines: 04(GETNEXT) |
| | | |
| | F03:PLAN FRAGMENT [RANDOM] hosts=3 instances=6 |
| | Per-Instance Resources: mem-estimate=26.00MB mem-reservation=1.00MB thread-reservation=1 |
| | 04:AGGREGATE |
| | | output: avg(ss_ext_discount_amt) |
| | | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | | tuple-ids=5 row-size=8B cardinality=1 |
| | | in pipelines: 04(GETNEXT), 03(OPEN) |
| | | |
| | 03:SCAN HDFS [tpcds_parquet.store_sales, RANDOM] |
| | HDFS partitions=1824/1824 files=1824 size=201.02MB |
| | predicates: ss_quantity <= CAST(20 AS INT), ss_quantity >= CAST(1 AS INT) |
| | stored statistics: |
| | table: rows=2.88M size=201.02MB |
| | partitions: 1824/1824 rows=2.88M |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=130.09K |
| | parquet statistics predicates: ss_quantity <= CAST(20 AS INT), ss_quantity >= CAST(1 AS INT) |
| | parquet dictionary predicates: ss_quantity <= CAST(20 AS INT), ss_quantity >= CAST(1 AS INT) |
| | mem-estimate=16.00MB mem-reservation=1.00MB thread-reservation=0 |
| | tuple-ids=4 row-size=8B cardinality=288.04K |
| | in pipelines: 03(GETNEXT) |
| | |
| 31:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] |
| | join table id: 14 |
| | mem-estimate=0B mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2,0 row-size=12B cardinality=1 |
| | in pipelines: 47(GETNEXT), 00(OPEN) |
| | |
| |--F45:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 |
| | | Per-Instance Resources: mem-estimate=16.00KB mem-reservation=0B thread-reservation=1 |
| | JOIN BUILD |
| | | join-table-id=14 plan-id=15 cohort-id=01 |
| | | mem-estimate=4B mem-reservation=0B thread-reservation=0 |
| | | |
| | 48:EXCHANGE [UNPARTITIONED] |
| | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | | tuple-ids=0 row-size=4B cardinality=1 |
| | | in pipelines: 00(GETNEXT) |
| | | |
| | F02:PLAN FRAGMENT [RANDOM] hosts=1 instances=1 |
| | Per-Instance Resources: mem-estimate=16.00MB mem-reservation=8.00KB thread-reservation=1 |
| | 00:SCAN HDFS [tpcds_parquet.reason, RANDOM] |
| | HDFS partitions=1/1 files=1 size=1.92KB |
| | predicates: r_reason_sk = CAST(1 AS INT) |
| | stored statistics: |
| | table: rows=35 size=1.92KB |
| | columns: all |
| | extrapolated-rows=disabled max-scan-range-rows=35 |
| | parquet statistics predicates: r_reason_sk = CAST(1 AS INT) |
| | parquet dictionary predicates: r_reason_sk = CAST(1 AS INT) |
| | mem-estimate=16.00MB mem-reservation=8.00KB thread-reservation=0 |
| | tuple-ids=0 row-size=4B cardinality=1 |
| | in pipelines: 00(GETNEXT) |
| | |
| 47:AGGREGATE [FINALIZE] |
| | output: count:merge(*) |
| | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | tuple-ids=2 row-size=8B cardinality=1 |
| | in pipelines: 47(GETNEXT), 02(OPEN) |
| | |
| 46:EXCHANGE [UNPARTITIONED] |
| | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 |
| | tuple-ids=2 row-size=8B cardinality=1 |
| | in pipelines: 02(GETNEXT) |
| | |
| F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=6 |
| Per-Instance Resources: mem-estimate=26.00MB mem-reservation=128.00KB thread-reservation=1 |
| 02:AGGREGATE |
| | output: count(*) |
| | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 |
| | tuple-ids=2 row-size=8B cardinality=1 |
| | in pipelines: 02(GETNEXT), 01(OPEN) |
| | |
| 01:SCAN HDFS [tpcds_parquet.store_sales, RANDOM] |
| HDFS partitions=1824/1824 files=1824 size=201.02MB |
| predicates: ss_quantity <= CAST(20 AS INT), ss_quantity >= CAST(1 AS INT) |
| stored statistics: |
| table: rows=2.88M size=201.02MB |
| partitions: 1824/1824 rows=2.88M |
| columns: all |
| extrapolated-rows=disabled max-scan-range-rows=130.09K |
| parquet statistics predicates: ss_quantity <= CAST(20 AS INT), ss_quantity >= CAST(1 AS INT) |
| parquet dictionary predicates: ss_quantity <= CAST(20 AS INT), ss_quantity >= CAST(1 AS INT) |
| mem-estimate=16.00MB mem-reservation=128.00KB thread-reservation=0 |
| tuple-ids=1 row-size=4B cardinality=288.04K |
| in pipelines: 01(GETNEXT) |
| ==== |
