http://git-wip-us.apache.org/repos/asf/impala/blob/8cbec20e/testdata/workloads/functional-planner/queries/PlannerTest/resource-requirements.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/functional-planner/queries/PlannerTest/resource-requirements.test b/testdata/workloads/functional-planner/queries/PlannerTest/resource-requirements.test index 6eb42ef..71040ad 100644 --- a/testdata/workloads/functional-planner/queries/PlannerTest/resource-requirements.test +++ b/testdata/workloads/functional-planner/queries/PlannerTest/resource-requirements.test @@ -10,61 +10,61 @@ PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 00:SCAN HDFS [tpch_parquet.lineitem] - partitions=1/1 files=3 size=193.99MB + partitions=1/1 files=3 size=193.72MB stored statistics: - table: rows=6001215 size=193.99MB + table: rows=6001215 size=193.72MB columns: all - extrapolated-rows=disabled max-scan-range-rows=2141664 + extrapolated-rows=disabled max-scan-range-rows=2141530 mem-estimate=80.00MB mem-reservation=40.00MB thread-reservation=1 tuple-ids=0 row-size=263B cardinality=6001215 in pipelines: 00(GETNEXT) ---- DISTRIBUTEDPLAN Max Per-Host Resource Reservation: Memory=40.00MB Threads=3 -Per-Host Resource Estimates: Memory=80MB +Per-Host Resource Estimates: Memory=91MB F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=10.78MB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 01:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=10.78MB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=263B cardinality=6001215 | in pipelines: 00(GETNEXT) | F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=80.00MB mem-reservation=40.00MB thread-reservation=2 00:SCAN HDFS [tpch_parquet.lineitem, RANDOM] - partitions=1/1 files=3 size=193.99MB + partitions=1/1 files=3 size=193.72MB stored statistics: - table: rows=6001215 size=193.99MB + table: rows=6001215 size=193.72MB columns: all - extrapolated-rows=disabled max-scan-range-rows=2141664 + extrapolated-rows=disabled max-scan-range-rows=2141530 mem-estimate=80.00MB mem-reservation=40.00MB thread-reservation=1 tuple-ids=0 row-size=263B cardinality=6001215 in pipelines: 00(GETNEXT) ---- PARALLELPLANS Max Per-Host Resource Reservation: Memory=80.00MB Threads=3 -Per-Host Resource Estimates: Memory=160MB +Per-Host Resource Estimates: Memory=172MB F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=11.56MB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 01:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=11.56MB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=263B cardinality=6001215 | in pipelines: 00(GETNEXT) | F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=6 Per-Host Resources: mem-estimate=160.00MB mem-reservation=80.00MB thread-reservation=2 00:SCAN HDFS [tpch_parquet.lineitem, RANDOM] - partitions=1/1 files=3 size=193.99MB + partitions=1/1 files=3 size=193.72MB stored statistics: - table: rows=6001215 size=193.99MB + table: rows=6001215 size=193.72MB columns: all - extrapolated-rows=disabled max-scan-range-rows=2141664 + extrapolated-rows=disabled max-scan-range-rows=2141530 mem-estimate=80.00MB mem-reservation=40.00MB thread-reservation=0 tuple-ids=0 row-size=263B cardinality=6001215 in pipelines: 00(GETNEXT) @@ -82,61 +82,61 @@ PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 00:SCAN HDFS [tpch_parquet.lineitem] - partitions=1/1 files=3 size=193.99MB + partitions=1/1 files=3 size=193.72MB stored statistics: - table: rows=6001215 size=193.99MB + table: rows=6001215 size=193.72MB columns: all - extrapolated-rows=disabled max-scan-range-rows=2141664 + extrapolated-rows=disabled max-scan-range-rows=2141530 mem-estimate=80.00MB mem-reservation=4.00MB thread-reservation=1 tuple-ids=0 row-size=42B cardinality=6001215 in pipelines: 00(GETNEXT) ---- DISTRIBUTEDPLAN Max Per-Host Resource Reservation: Memory=4.00MB Threads=3 -Per-Host Resource Estimates: Memory=80MB +Per-Host Resource Estimates: Memory=90MB F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=10.14MB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 01:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=10.14MB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=42B cardinality=6001215 | in pipelines: 00(GETNEXT) | F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=80.00MB mem-reservation=4.00MB thread-reservation=2 00:SCAN HDFS [tpch_parquet.lineitem, RANDOM] - partitions=1/1 files=3 size=193.99MB + partitions=1/1 files=3 size=193.72MB stored statistics: - table: rows=6001215 size=193.99MB + table: rows=6001215 size=193.72MB columns: all - extrapolated-rows=disabled max-scan-range-rows=2141664 + extrapolated-rows=disabled max-scan-range-rows=2141530 mem-estimate=80.00MB mem-reservation=4.00MB thread-reservation=1 tuple-ids=0 row-size=42B cardinality=6001215 in pipelines: 00(GETNEXT) ---- PARALLELPLANS Max Per-Host Resource Reservation: Memory=8.00MB Threads=3 -Per-Host Resource Estimates: Memory=160MB +Per-Host Resource Estimates: Memory=170MB F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=10.27MB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 01:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=10.27MB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=42B cardinality=6001215 | in pipelines: 00(GETNEXT) | F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=6 Per-Host Resources: mem-estimate=160.00MB mem-reservation=8.00MB thread-reservation=2 00:SCAN HDFS [tpch_parquet.lineitem, RANDOM] - partitions=1/1 files=3 size=193.99MB + partitions=1/1 files=3 size=193.72MB stored statistics: - table: rows=6001215 size=193.99MB + table: rows=6001215 size=193.72MB columns: all - extrapolated-rows=disabled max-scan-range-rows=2141664 + extrapolated-rows=disabled max-scan-range-rows=2141530 mem-estimate=80.00MB mem-reservation=4.00MB thread-reservation=0 tuple-ids=0 row-size=42B cardinality=6001215 in pipelines: 00(GETNEXT) @@ -155,7 +155,7 @@ PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 00:SCAN HDFS [functional_parquet.alltypes] - partitions=24/24 files=24 size=199.69KB + partitions=24/24 files=24 size=188.54KB stored statistics: table: rows=unavailable size=unavailable partitions: 0/24 rows=unavailable @@ -171,19 +171,19 @@ WARNING: The following tables are missing relevant table and/or column statistic functional_parquet.alltypes F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=60.00KB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 01:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=60.00KB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=16B cardinality=unavailable | in pipelines: 00(GETNEXT) | F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=16.00MB mem-reservation=16.00KB thread-reservation=2 00:SCAN HDFS [functional_parquet.alltypes, RANDOM] - partitions=24/24 files=24 size=199.69KB + partitions=24/24 files=24 size=188.54KB stored statistics: table: rows=unavailable size=unavailable partitions: 0/24 rows=unavailable @@ -199,19 +199,19 @@ WARNING: The following tables are missing relevant table and/or column statistic functional_parquet.alltypes F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=120.00KB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 01:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=120.00KB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=16B cardinality=unavailable | in pipelines: 00(GETNEXT) | F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=6 Per-Host Resources: mem-estimate=32.00MB mem-reservation=32.00KB thread-reservation=2 00:SCAN HDFS [functional_parquet.alltypes, RANDOM] - partitions=24/24 files=24 size=199.69KB + partitions=24/24 files=24 size=188.54KB stored statistics: table: rows=unavailable size=unavailable partitions: 0/24 rows=unavailable @@ -236,7 +236,7 @@ PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 00:SCAN HDFS [functional_parquet.alltypes] - partitions=24/24 files=24 size=199.69KB + partitions=24/24 files=24 size=188.54KB stored statistics: table: rows=unavailable size=unavailable partitions: 0/24 rows=unavailable @@ -252,19 +252,19 @@ WARNING: The following tables are missing relevant table and/or column statistic functional_parquet.alltypes F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=83.99KB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 01:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=83.99KB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=24B cardinality=unavailable | in pipelines: 00(GETNEXT) | F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=16.00MB mem-reservation=24.00KB thread-reservation=2 00:SCAN HDFS [functional_parquet.alltypes, RANDOM] - partitions=24/24 files=24 size=199.69KB + partitions=24/24 files=24 size=188.54KB stored statistics: table: rows=unavailable size=unavailable partitions: 0/24 rows=unavailable @@ -280,19 +280,19 @@ WARNING: The following tables are missing relevant table and/or column statistic functional_parquet.alltypes F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=167.99KB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 01:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=167.99KB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=24B cardinality=unavailable | in pipelines: 00(GETNEXT) | F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=6 Per-Host Resources: mem-estimate=32.00MB mem-reservation=48.00KB thread-reservation=2 00:SCAN HDFS [functional_parquet.alltypes, RANDOM] - partitions=24/24 files=24 size=199.69KB + partitions=24/24 files=24 size=188.54KB stored statistics: table: rows=unavailable size=unavailable partitions: 0/24 rows=unavailable @@ -317,7 +317,7 @@ PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 00:SCAN HDFS [functional_parquet.alltypes] - partitions=24/24 files=24 size=199.69KB + partitions=24/24 files=24 size=188.54KB stored statistics: table: rows=unavailable size=unavailable partitions: 0/24 rows=unavailable @@ -333,19 +333,19 @@ WARNING: The following tables are missing relevant table and/or column statistic functional_parquet.alltypes F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=16.00KB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 01:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=0B cardinality=unavailable | in pipelines: 00(GETNEXT) | F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=1.00MB mem-reservation=16.00KB thread-reservation=2 00:SCAN HDFS [functional_parquet.alltypes, RANDOM] - partitions=24/24 files=24 size=199.69KB + partitions=24/24 files=24 size=188.54KB stored statistics: table: rows=unavailable size=unavailable partitions: 0/24 rows=unavailable @@ -361,19 +361,19 @@ WARNING: The following tables are missing relevant table and/or column statistic functional_parquet.alltypes F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=24.00KB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 01:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=24.00KB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=0B cardinality=unavailable | in pipelines: 00(GETNEXT) | F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=6 Per-Host Resources: mem-estimate=32.00MB mem-reservation=32.00KB thread-reservation=2 00:SCAN HDFS [functional_parquet.alltypes, RANDOM] - partitions=24/24 files=24 size=199.69KB + partitions=24/24 files=24 size=188.54KB stored statistics: table: rows=unavailable size=unavailable partitions: 0/24 rows=unavailable @@ -396,9 +396,9 @@ PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 00:SCAN HDFS [tpch_parquet.customer] - partitions=1/1 files=1 size=12.34MB + partitions=1/1 files=1 size=12.31MB stored statistics: - table: rows=150000 size=12.34MB + table: rows=150000 size=12.31MB columns: all extrapolated-rows=disabled max-scan-range-rows=150000 mem-estimate=24.00MB mem-reservation=128.00KB thread-reservation=1 @@ -418,9 +418,9 @@ PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 00:SCAN HDFS [tpch_parquet.customer] - partitions=1/1 files=1 size=12.34MB + partitions=1/1 files=1 size=12.31MB stored statistics: - table: rows=150000 size=12.34MB + table: rows=150000 size=12.31MB columns: all extrapolated-rows=disabled max-scan-range-rows=150000 mem-estimate=24.00MB mem-reservation=2.00MB thread-reservation=1 @@ -465,11 +465,11 @@ PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 00:SCAN HDFS [tpch_nested_parquet.customer.c_orders] - partitions=1/1 files=4 size=289.00MB + partitions=1/1 files=4 size=288.99MB stored statistics: - table: rows=150000 size=289.00MB + table: rows=150000 size=288.99MB columns: all - extrapolated-rows=disabled max-scan-range-rows=44227 + extrapolated-rows=disabled max-scan-range-rows=44232 mem-estimate=88.00MB mem-reservation=24.00MB thread-reservation=1 tuple-ids=0 row-size=80B cardinality=1500000 in pipelines: 00(GETNEXT) @@ -488,11 +488,11 @@ PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 00:SCAN HDFS [tpch_nested_parquet.customer.c_orders] - partitions=1/1 files=4 size=289.00MB + partitions=1/1 files=4 size=288.99MB stored statistics: - table: rows=150000 size=289.00MB + table: rows=150000 size=288.99MB columns: all - extrapolated-rows=disabled max-scan-range-rows=44227 + extrapolated-rows=disabled max-scan-range-rows=44232 mem-estimate=88.00MB mem-reservation=4.00MB thread-reservation=1 tuple-ids=0 row-size=16B cardinality=1500000 in pipelines: 00(GETNEXT) @@ -511,11 +511,11 @@ PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 00:SCAN HDFS [tpch_nested_parquet.customer.c_orders] - partitions=1/1 files=4 size=289.00MB + partitions=1/1 files=4 size=288.99MB stored statistics: - table: rows=150000 size=289.00MB + table: rows=150000 size=288.99MB columns: all - extrapolated-rows=disabled max-scan-range-rows=44227 + extrapolated-rows=disabled max-scan-range-rows=44232 mem-estimate=88.00MB mem-reservation=4.00MB thread-reservation=1 tuple-ids=0 row-size=8B cardinality=1500000 in pipelines: 00(GETNEXT) @@ -559,12 +559,12 @@ PLAN-ROOT SINK | in pipelines: 00(GETNEXT) | 00:SCAN HDFS [tpch_nested_parquet.customer c] - partitions=1/1 files=4 size=289.00MB + partitions=1/1 files=4 size=288.99MB predicates: !empty(c.c_orders) stored statistics: - table: rows=150000 size=289.00MB + table: rows=150000 size=288.99MB columns missing stats: c_orders - extrapolated-rows=disabled max-scan-range-rows=44227 + extrapolated-rows=disabled max-scan-range-rows=44232 mem-estimate=88.00MB mem-reservation=32.00MB thread-reservation=1 tuple-ids=0 row-size=24B cardinality=150000 in pipelines: 00(GETNEXT) @@ -607,12 +607,12 @@ PLAN-ROOT SINK | in pipelines: 00(GETNEXT) | 00:SCAN HDFS [tpch_nested_parquet.customer c] - partitions=1/1 files=4 size=289.00MB + partitions=1/1 files=4 size=288.99MB predicates: !empty(c.c_orders) stored statistics: - table: rows=150000 size=289.00MB + table: rows=150000 size=288.99MB columns missing stats: c_orders - extrapolated-rows=disabled max-scan-range-rows=44227 + extrapolated-rows=disabled max-scan-range-rows=44232 mem-estimate=88.00MB mem-reservation=8.00MB thread-reservation=1 tuple-ids=0 row-size=24B cardinality=150000 in pipelines: 00(GETNEXT) @@ -656,12 +656,12 @@ PLAN-ROOT SINK | in pipelines: 00(GETNEXT) | 00:SCAN HDFS [tpch_nested_parquet.customer c] - partitions=1/1 files=4 size=289.00MB + partitions=1/1 files=4 size=288.99MB predicates: !empty(c.c_orders) stored statistics: - table: rows=150000 size=289.00MB + table: rows=150000 size=288.99MB columns missing stats: c_orders - extrapolated-rows=disabled max-scan-range-rows=44227 + extrapolated-rows=disabled max-scan-range-rows=44232 mem-estimate=88.00MB mem-reservation=8.00MB thread-reservation=1 tuple-ids=0 row-size=24B cardinality=150000 in pipelines: 00(GETNEXT) @@ -705,12 +705,12 @@ PLAN-ROOT SINK | in pipelines: 00(GETNEXT) | 00:SCAN HDFS [tpch_nested_parquet.customer c] - partitions=1/1 files=4 size=289.00MB + partitions=1/1 files=4 size=288.99MB predicates: !empty(c.c_orders) stored statistics: - table: rows=150000 size=289.00MB + table: rows=150000 size=288.99MB columns missing stats: c_orders - extrapolated-rows=disabled max-scan-range-rows=44227 + extrapolated-rows=disabled max-scan-range-rows=44232 mem-estimate=88.00MB mem-reservation=8.00MB thread-reservation=1 tuple-ids=0 row-size=24B cardinality=150000 in pipelines: 00(GETNEXT) @@ -753,12 +753,12 @@ PLAN-ROOT SINK | in pipelines: 00(GETNEXT) | 00:SCAN HDFS [tpch_nested_parquet.customer c] - partitions=1/1 files=4 size=289.00MB + partitions=1/1 files=4 size=288.99MB predicates: !empty(c.c_orders) stored statistics: - table: rows=150000 size=289.00MB + table: rows=150000 size=288.99MB columns: unavailable - extrapolated-rows=disabled max-scan-range-rows=44227 + extrapolated-rows=disabled max-scan-range-rows=44232 mem-estimate=88.00MB mem-reservation=4.00MB thread-reservation=1 tuple-ids=0 row-size=16B cardinality=150000 in pipelines: 00(GETNEXT) @@ -823,13 +823,13 @@ PLAN-ROOT SINK | in pipelines: 00(GETNEXT) | 00:SCAN HDFS [tpch_nested_parquet.customer c] - partitions=1/1 files=4 size=289.00MB + partitions=1/1 files=4 size=288.99MB predicates: !empty(c.c_orders) predicates on o: !empty(o.o_lineitems) stored statistics: - table: rows=150000 size=289.00MB + table: rows=150000 size=288.99MB columns missing stats: c_orders - extrapolated-rows=disabled max-scan-range-rows=44227 + extrapolated-rows=disabled max-scan-range-rows=44232 mem-estimate=88.00MB mem-reservation=16.00MB thread-reservation=1 tuple-ids=0 row-size=24B cardinality=150000 in pipelines: 00(GETNEXT) @@ -856,15 +856,15 @@ PLAN-ROOT SINK in pipelines: 00(GETNEXT) ---- DISTRIBUTEDPLAN Max Per-Host Resource Reservation: Memory=8.00MB Threads=3 -Per-Host Resource Estimates: Memory=88MB +Per-Host Resource Estimates: Memory=99MB F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=10.78MB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 01:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=10.78MB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=263B cardinality=6001215 | in pipelines: 00(GETNEXT) | @@ -881,15 +881,15 @@ Per-Host Resources: mem-estimate=88.00MB mem-reservation=8.00MB thread-reservati in pipelines: 00(GETNEXT) ---- PARALLELPLANS Max Per-Host Resource Reservation: Memory=16.00MB Threads=3 -Per-Host Resource Estimates: Memory=176MB +Per-Host Resource Estimates: Memory=188MB F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=11.56MB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 01:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=11.56MB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=263B cardinality=6001215 | in pipelines: 00(GETNEXT) | @@ -927,15 +927,15 @@ PLAN-ROOT SINK in pipelines: 00(GETNEXT) ---- DISTRIBUTEDPLAN Max Per-Host Resource Reservation: Memory=8.00MB Threads=3 -Per-Host Resource Estimates: Memory=88MB +Per-Host Resource Estimates: Memory=98MB F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=10.14MB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 01:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=10.14MB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=42B cardinality=6001215 | in pipelines: 00(GETNEXT) | @@ -952,15 +952,15 @@ Per-Host Resources: mem-estimate=88.00MB mem-reservation=8.00MB thread-reservati in pipelines: 00(GETNEXT) ---- PARALLELPLANS Max Per-Host Resource Reservation: Memory=16.00MB Threads=3 -Per-Host Resource Estimates: Memory=176MB +Per-Host Resource Estimates: Memory=186MB F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=10.27MB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 01:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=10.27MB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=42B cardinality=6001215 | in pipelines: 00(GETNEXT) | @@ -1000,16 +1000,16 @@ PLAN-ROOT SINK in pipelines: 00(GETNEXT) ---- DISTRIBUTEDPLAN Max Per-Host Resource Reservation: Memory=32.00KB Threads=3 -Per-Host Resource Estimates: Memory=16MB +Per-Host Resource Estimates: Memory=17MB Codegen disabled by planner F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=533.50KB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 01:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=533.50KB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=97B cardinality=7300 | in pipelines: 00(GETNEXT) | @@ -1027,16 +1027,16 @@ Per-Host Resources: mem-estimate=16.00MB mem-reservation=32.00KB thread-reservat in pipelines: 00(GETNEXT) ---- PARALLELPLANS Max Per-Host Resource Reservation: Memory=64.00KB Threads=3 -Per-Host Resource Estimates: Memory=32MB +Per-Host Resource Estimates: Memory=33MB Codegen disabled by planner F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=836.50KB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 01:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=836.50KB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=97B cardinality=7300 | in pipelines: 00(GETNEXT) | @@ -1082,12 +1082,12 @@ WARNING: The following tables are missing relevant table and/or column statistic tpch_avro.orders F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=223.95KB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 01:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=223.95KB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=108B cardinality=unavailable | in pipelines: 00(GETNEXT) | @@ -1109,12 +1109,12 @@ WARNING: The following tables are missing relevant table and/or column statistic tpch_avro.orders F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=447.95KB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 01:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=447.95KB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=108B cardinality=unavailable | in pipelines: 00(GETNEXT) | @@ -1159,12 +1159,12 @@ WARNING: The following tables are missing relevant table and/or column statistic tpch_rc.customer F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=101.90KB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 01:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=101.90KB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=98B cardinality=unavailable | in pipelines: 00(GETNEXT) | @@ -1186,12 +1186,12 @@ WARNING: The following tables are missing relevant table and/or column statistic tpch_rc.customer F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=203.90KB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 01:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=203.90KB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=98B cardinality=unavailable | in pipelines: 00(GETNEXT) | @@ -1236,12 +1236,12 @@ WARNING: The following tables are missing relevant table and/or column statistic tpcds_seq_snap.web_returns F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=107.90KB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 01:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=107.90KB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=104B cardinality=unavailable | in pipelines: 00(GETNEXT) | @@ -1263,12 +1263,12 @@ WARNING: The following tables are missing relevant table and/or column statistic tpcds_seq_snap.web_returns F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=215.90KB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 01:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=215.90KB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=104B cardinality=unavailable | in pipelines: 00(GETNEXT) | @@ -1364,7 +1364,7 @@ PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 00:SCAN HDFS [functional.alltypesmixedformat] - partitions=4/4 files=4 size=66.48KB + partitions=4/4 files=4 size=66.06KB stored statistics: table: rows=unavailable size=unavailable partitions: 0/4 rows=unavailable @@ -1380,19 +1380,19 @@ WARNING: The following tables are missing relevant table and/or column statistic functional.alltypesmixedformat F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=275.97KB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 01:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=275.97KB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=88B cardinality=unavailable | in pipelines: 00(GETNEXT) | F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=16.00MB mem-reservation=88.00KB thread-reservation=2 00:SCAN HDFS [functional.alltypesmixedformat, RANDOM] - partitions=4/4 files=4 size=66.48KB + partitions=4/4 files=4 size=66.06KB stored statistics: table: rows=unavailable size=unavailable partitions: 0/4 rows=unavailable @@ -1403,24 +1403,24 @@ Per-Host Resources: mem-estimate=16.00MB mem-reservation=88.00KB thread-reservat in pipelines: 00(GETNEXT) ---- PARALLELPLANS Max Per-Host Resource Reservation: Memory=176.00KB Threads=5 -Per-Host Resource Estimates: Memory=32MB +Per-Host Resource Estimates: Memory=33MB WARNING: The following tables are missing relevant table and/or column statistics. functional.alltypesmixedformat F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=551.97KB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 01:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=551.97KB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=88B cardinality=unavailable | in pipelines: 00(GETNEXT) | F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=6 Per-Host Resources: mem-estimate=32.00MB mem-reservation=176.00KB thread-reservation=4 00:SCAN HDFS [functional.alltypesmixedformat, RANDOM] - partitions=4/4 files=4 size=66.48KB + partitions=4/4 files=4 size=66.06KB stored statistics: table: rows=unavailable size=unavailable partitions: 0/4 rows=unavailable @@ -1457,12 +1457,12 @@ WARNING: The following tables are missing relevant table and/or column statistic functional_hbase.alltypes F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=1.29MB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 01:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=1.29MB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=88B cardinality=14298 | in pipelines: 00(GETNEXT) | @@ -1482,12 +1482,12 @@ WARNING: The following tables are missing relevant table and/or column statistic functional_hbase.alltypes F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=1.38MB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 01:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=1.38MB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=88B cardinality=14298 | in pipelines: 00(GETNEXT) | @@ -1526,12 +1526,12 @@ Per-Host Resource Estimates: Memory=10MB Codegen disabled by planner F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=16.37KB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 01:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=16.37KB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=97B cardinality=50 | in pipelines: 00(GETNEXT) | @@ -1550,12 +1550,12 @@ Per-Host Resource Estimates: Memory=10MB Codegen disabled by planner F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=31.17KB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 01:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=31.17KB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=97B cardinality=50 | in pipelines: 00(GETNEXT) | @@ -1593,12 +1593,12 @@ WARNING: The following tables are missing relevant table and/or column statistic functional.alltypes_datasource F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=686.41KB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 01:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=686.41KB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=116B cardinality=5000 | in pipelines: 00(GETNEXT) | @@ -1615,12 +1615,12 @@ WARNING: The following tables are missing relevant table and/or column statistic functional.alltypes_datasource F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=806.41KB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 01:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=806.41KB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=116B cardinality=5000 | in pipelines: 00(GETNEXT) | @@ -1671,15 +1671,15 @@ PLAN-ROOT SINK in pipelines: 01(GETNEXT) ---- DISTRIBUTEDPLAN Max Per-Host Resource Reservation: Memory=8.00MB Threads=3 -Per-Host Resource Estimates: Memory=88MB +Per-Host Resource Estimates: Memory=99MB F03:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=10.78MB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 03:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=10.78MB mem-reservation=0B thread-reservation=0 | tuple-ids=2 row-size=263B cardinality=12002430 | in pipelines: 01(GETNEXT), 02(GETNEXT) | @@ -1712,15 +1712,15 @@ Per-Host Resources: mem-estimate=88.00MB mem-reservation=8.00MB thread-reservati in pipelines: 01(GETNEXT) ---- PARALLELPLANS Max Per-Host Resource Reservation: Memory=16.00MB Threads=3 -Per-Host Resource Estimates: Memory=176MB +Per-Host Resource Estimates: Memory=188MB F03:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=11.56MB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 03:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=11.56MB mem-reservation=0B thread-reservation=0 | tuple-ids=2 row-size=263B cardinality=12002430 | in pipelines: 01(GETNEXT), 02(GETNEXT) | @@ -1773,30 +1773,30 @@ PLAN-ROOT SINK | in pipelines: 01(GETNEXT), 00(OPEN) | 00:SCAN HDFS [tpch_parquet.lineitem] - partitions=1/1 files=3 size=193.99MB + partitions=1/1 files=3 size=193.72MB stored statistics: - table: rows=6001215 size=193.99MB + table: rows=6001215 size=193.72MB columns: all - extrapolated-rows=disabled max-scan-range-rows=2141664 + extrapolated-rows=disabled max-scan-range-rows=2141530 mem-estimate=80.00MB mem-reservation=4.00MB thread-reservation=1 tuple-ids=0 row-size=8B cardinality=6001215 in pipelines: 00(GETNEXT) ---- DISTRIBUTEDPLAN Max Per-Host Resource Reservation: Memory=46.50MB Threads=4 -Per-Host Resource Estimates: Memory=124MB +Per-Host Resource Estimates: Memory=140MB F02:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=8.01MB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 04:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=8.01MB mem-reservation=0B thread-reservation=0 | tuple-ids=1 row-size=16B cardinality=1563438 | in pipelines: 03(GETNEXT) | F01:PLAN FRAGMENT [HASH(l_orderkey)] hosts=3 instances=3 -Per-Host Resources: mem-estimate=10.00MB mem-reservation=8.50MB thread-reservation=1 +Per-Host Resources: mem-estimate=18.01MB mem-reservation=8.50MB thread-reservation=1 03:AGGREGATE [FINALIZE] | output: count:merge(*) | group by: l_orderkey @@ -1805,7 +1805,7 @@ Per-Host Resources: mem-estimate=10.00MB mem-reservation=8.50MB thread-reservati | in pipelines: 03(GETNEXT), 00(OPEN) | 02:EXCHANGE [HASH(l_orderkey)] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=8.01MB mem-reservation=0B thread-reservation=0 | tuple-ids=1 row-size=16B cardinality=1563438 | in pipelines: 00(GETNEXT) | @@ -1819,30 +1819,30 @@ Per-Host Resources: mem-estimate=114.00MB mem-reservation=38.00MB thread-reserva | in pipelines: 00(GETNEXT) | 00:SCAN HDFS [tpch_parquet.lineitem, RANDOM] - partitions=1/1 files=3 size=193.99MB + partitions=1/1 files=3 size=193.72MB stored statistics: - table: rows=6001215 size=193.99MB + table: rows=6001215 size=193.72MB columns: all - extrapolated-rows=disabled max-scan-range-rows=2141664 + extrapolated-rows=disabled max-scan-range-rows=2141530 mem-estimate=80.00MB mem-reservation=4.00MB thread-reservation=1 tuple-ids=0 row-size=8B cardinality=6001215 in pipelines: 00(GETNEXT) ---- PARALLELPLANS Max Per-Host Resource Reservation: Memory=85.50MB Threads=5 -Per-Host Resource Estimates: Memory=248MB +Per-Host Resource Estimates: Memory=272MB F02:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=8.07MB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 04:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=8.07MB mem-reservation=0B thread-reservation=0 | tuple-ids=1 row-size=16B cardinality=1563438 | in pipelines: 03(GETNEXT) | F01:PLAN FRAGMENT [HASH(l_orderkey)] hosts=3 instances=6 -Per-Host Resources: mem-estimate=20.00MB mem-reservation=9.50MB thread-reservation=2 +Per-Host Resources: mem-estimate=36.14MB mem-reservation=9.50MB thread-reservation=2 03:AGGREGATE [FINALIZE] | output: count:merge(*) | group by: l_orderkey @@ -1851,7 +1851,7 @@ Per-Host Resources: mem-estimate=20.00MB mem-reservation=9.50MB thread-reservati | in pipelines: 03(GETNEXT), 00(OPEN) | 02:EXCHANGE [HASH(l_orderkey)] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=8.07MB mem-reservation=0B thread-reservation=0 | tuple-ids=1 row-size=16B cardinality=1563438 | in pipelines: 00(GETNEXT) | @@ -1865,11 +1865,11 @@ Per-Host Resources: mem-estimate=228.00MB mem-reservation=76.00MB thread-reserva | in pipelines: 00(GETNEXT) | 00:SCAN HDFS [tpch_parquet.lineitem, RANDOM] - partitions=1/1 files=3 size=193.99MB + partitions=1/1 files=3 size=193.72MB stored statistics: - table: rows=6001215 size=193.99MB + table: rows=6001215 size=193.72MB columns: all - extrapolated-rows=disabled max-scan-range-rows=2141664 + extrapolated-rows=disabled max-scan-range-rows=2141530 mem-estimate=80.00MB mem-reservation=4.00MB thread-reservation=0 tuple-ids=0 row-size=8B cardinality=6001215 in pipelines: 00(GETNEXT) @@ -1892,11 +1892,11 @@ PLAN-ROOT SINK | in pipelines: 01(GETNEXT), 00(OPEN) | 00:SCAN HDFS [tpch_parquet.lineitem] - partitions=1/1 files=3 size=193.99MB + partitions=1/1 files=3 size=193.72MB stored statistics: - table: rows=6001215 size=193.99MB + table: rows=6001215 size=193.72MB columns: all - extrapolated-rows=disabled max-scan-range-rows=2141664 + extrapolated-rows=disabled max-scan-range-rows=2141530 mem-estimate=1.00MB mem-reservation=128.00KB thread-reservation=1 tuple-ids=0 row-size=8B cardinality=6001215 in pipelines: 00(GETNEXT) @@ -1905,7 +1905,7 @@ Max Per-Host Resource Reservation: Memory=128.00KB Threads=3 Per-Host Resource Estimates: Memory=21MB F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=10.00MB mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | @@ -1916,7 +1916,7 @@ PLAN-ROOT SINK | in pipelines: 03(GETNEXT), 01(OPEN) | 02:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 | tuple-ids=1 row-size=8B cardinality=1 | in pipelines: 01(GETNEXT) | @@ -1929,11 +1929,11 @@ Per-Host Resources: mem-estimate=11.00MB mem-reservation=128.00KB thread-reserva | in pipelines: 01(GETNEXT), 00(OPEN) | 00:SCAN HDFS [tpch_parquet.lineitem, RANDOM] - partitions=1/1 files=3 size=193.99MB + partitions=1/1 files=3 size=193.72MB stored statistics: - table: rows=6001215 size=193.99MB + table: rows=6001215 size=193.72MB columns: all - extrapolated-rows=disabled max-scan-range-rows=2141664 + extrapolated-rows=disabled max-scan-range-rows=2141530 mem-estimate=1.00MB mem-reservation=128.00KB thread-reservation=1 tuple-ids=0 row-size=8B cardinality=6001215 in pipelines: 00(GETNEXT) @@ -1942,7 +1942,7 @@ Max Per-Host Resource Reservation: Memory=256.00KB Threads=3 Per-Host Resource Estimates: Memory=190MB F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=10.00MB mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | @@ -1953,7 +1953,7 @@ PLAN-ROOT SINK | in pipelines: 03(GETNEXT), 01(OPEN) | 02:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 | tuple-ids=1 row-size=8B cardinality=1 | in pipelines: 01(GETNEXT) | @@ -1966,11 +1966,11 @@ Per-Host Resources: mem-estimate=180.00MB mem-reservation=256.00KB thread-reserv | in pipelines: 01(GETNEXT), 00(OPEN) | 00:SCAN HDFS [tpch_parquet.lineitem, RANDOM] - partitions=1/1 files=3 size=193.99MB + partitions=1/1 files=3 size=193.72MB stored statistics: - table: rows=6001215 size=193.99MB + table: rows=6001215 size=193.72MB columns: all - extrapolated-rows=disabled max-scan-range-rows=2141664 + extrapolated-rows=disabled max-scan-range-rows=2141530 mem-estimate=80.00MB mem-reservation=128.00KB thread-reservation=0 tuple-ids=0 row-size=8B cardinality=6001215 in pipelines: 00(GETNEXT) @@ -1995,26 +1995,26 @@ PLAN-ROOT SINK | in pipelines: 01(GETNEXT), 00(OPEN) | 00:SCAN HDFS [tpch_parquet.lineitem] - partitions=1/1 files=3 size=193.99MB + partitions=1/1 files=3 size=193.72MB stored statistics: - table: rows=6001215 size=193.99MB + table: rows=6001215 size=193.72MB columns: all - extrapolated-rows=disabled max-scan-range-rows=2141664 + extrapolated-rows=disabled max-scan-range-rows=2141530 mem-estimate=80.00MB mem-reservation=40.00MB thread-reservation=1 tuple-ids=0 row-size=263B cardinality=6001215 in pipelines: 00(GETNEXT) ---- DISTRIBUTEDPLAN Max Per-Host Resource Reservation: Memory=52.00MB Threads=3 -Per-Host Resource Estimates: Memory=120MB +Per-Host Resource Estimates: Memory=151MB F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=30.78MB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 02:MERGING-EXCHANGE [UNPARTITIONED] | order by: l_comment ASC -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=30.78MB mem-reservation=0B thread-reservation=0 | tuple-ids=1 row-size=263B cardinality=6001215 | in pipelines: 01(GETNEXT) | @@ -2027,26 +2027,26 @@ Per-Host Resources: mem-estimate=120.00MB mem-reservation=52.00MB thread-reserva | in pipelines: 01(GETNEXT), 00(OPEN) | 00:SCAN HDFS [tpch_parquet.lineitem, RANDOM] - partitions=1/1 files=3 size=193.99MB + partitions=1/1 files=3 size=193.72MB stored statistics: - table: rows=6001215 size=193.99MB + table: rows=6001215 size=193.72MB columns: all - extrapolated-rows=disabled max-scan-range-rows=2141664 + extrapolated-rows=disabled max-scan-range-rows=2141530 mem-estimate=80.00MB mem-reservation=40.00MB thread-reservation=1 tuple-ids=0 row-size=263B cardinality=6001215 in pipelines: 00(GETNEXT) ---- PARALLELPLANS Max Per-Host Resource Reservation: Memory=104.00MB Threads=3 -Per-Host Resource Estimates: Memory=240MB +Per-Host Resource Estimates: Memory=302MB F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=61.56MB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 02:MERGING-EXCHANGE [UNPARTITIONED] | order by: l_comment ASC -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=61.56MB mem-reservation=0B thread-reservation=0 | tuple-ids=1 row-size=263B cardinality=6001215 | in pipelines: 01(GETNEXT) | @@ -2059,11 +2059,11 @@ Per-Host Resources: mem-estimate=240.00MB mem-reservation=104.00MB thread-reserv | in pipelines: 01(GETNEXT), 00(OPEN) | 00:SCAN HDFS [tpch_parquet.lineitem, RANDOM] - partitions=1/1 files=3 size=193.99MB + partitions=1/1 files=3 size=193.72MB stored statistics: - table: rows=6001215 size=193.99MB + table: rows=6001215 size=193.72MB columns: all - extrapolated-rows=disabled max-scan-range-rows=2141664 + extrapolated-rows=disabled max-scan-range-rows=2141530 mem-estimate=80.00MB mem-reservation=40.00MB thread-reservation=0 tuple-ids=0 row-size=263B cardinality=6001215 in pipelines: 00(GETNEXT) @@ -2089,11 +2089,11 @@ PLAN-ROOT SINK | in pipelines: 01(GETNEXT), 00(OPEN) | 00:SCAN HDFS [tpch_parquet.lineitem] - partitions=1/1 files=3 size=193.99MB + partitions=1/1 files=3 size=193.72MB stored statistics: - table: rows=6001215 size=193.99MB + table: rows=6001215 size=193.72MB columns: all - extrapolated-rows=disabled max-scan-range-rows=2141664 + extrapolated-rows=disabled max-scan-range-rows=2141530 mem-estimate=80.00MB mem-reservation=40.00MB thread-reservation=1 tuple-ids=0 row-size=263B cardinality=6001215 in pipelines: 00(GETNEXT) @@ -2102,14 +2102,14 @@ Max Per-Host Resource Reservation: Memory=40.00MB Threads=3 Per-Host Resource Estimates: Memory=80MB F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=86.71KB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 02:MERGING-EXCHANGE [UNPARTITIONED] | order by: l_comment ASC | limit: 100 -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=86.71KB mem-reservation=0B thread-reservation=0 | tuple-ids=1 row-size=263B cardinality=100 | in pipelines: 01(GETNEXT) | @@ -2122,11 +2122,11 @@ Per-Host Resources: mem-estimate=80.03MB mem-reservation=40.00MB thread-reservat | in pipelines: 01(GETNEXT), 00(OPEN) | 00:SCAN HDFS [tpch_parquet.lineitem, RANDOM] - partitions=1/1 files=3 size=193.99MB + partitions=1/1 files=3 size=193.72MB stored statistics: - table: rows=6001215 size=193.99MB + table: rows=6001215 size=193.72MB columns: all - extrapolated-rows=disabled max-scan-range-rows=2141664 + extrapolated-rows=disabled max-scan-range-rows=2141530 mem-estimate=80.00MB mem-reservation=40.00MB thread-reservation=1 tuple-ids=0 row-size=263B cardinality=6001215 in pipelines: 00(GETNEXT) @@ -2135,14 +2135,14 @@ Max Per-Host Resource Reservation: Memory=80.00MB Threads=3 Per-Host Resource Estimates: Memory=160MB F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=164.87KB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 02:MERGING-EXCHANGE [UNPARTITIONED] | order by: l_comment ASC | limit: 100 -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=164.87KB mem-reservation=0B thread-reservation=0 | tuple-ids=1 row-size=263B cardinality=100 | in pipelines: 01(GETNEXT) | @@ -2155,11 +2155,11 @@ Per-Host Resources: mem-estimate=160.05MB mem-reservation=80.00MB thread-reserva | in pipelines: 01(GETNEXT), 00(OPEN) | 00:SCAN HDFS [tpch_parquet.lineitem, RANDOM] - partitions=1/1 files=3 size=193.99MB + partitions=1/1 files=3 size=193.72MB stored statistics: - table: rows=6001215 size=193.99MB + table: rows=6001215 size=193.72MB columns: all - extrapolated-rows=disabled max-scan-range-rows=2141664 + extrapolated-rows=disabled max-scan-range-rows=2141530 mem-estimate=80.00MB mem-reservation=40.00MB thread-reservation=0 tuple-ids=0 row-size=263B cardinality=6001215 in pipelines: 00(GETNEXT) @@ -2206,20 +2206,20 @@ PLAN-ROOT SINK in pipelines: 00(GETNEXT) ---- DISTRIBUTEDPLAN Max Per-Host Resource Reservation: Memory=51.00MB Threads=5 -Per-Host Resource Estimates: Memory=477MB +Per-Host Resource Estimates: Memory=499MB F02:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=11.35MB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 04:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=11.35MB mem-reservation=0B thread-reservation=0 | tuple-ids=0,1 row-size=454B cardinality=5757710 | in pipelines: 00(GETNEXT) | F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 -Per-Host Resources: mem-estimate=389.41MB mem-reservation=43.00MB thread-reservation=2 runtime-filters-memory=1.00MB +Per-Host Resources: mem-estimate=399.80MB mem-reservation=43.00MB thread-reservation=2 runtime-filters-memory=1.00MB 02:HASH JOIN [INNER JOIN, BROADCAST] | hash predicates: l_orderkey = o_orderkey | fk/pk conjuncts: l_orderkey = o_orderkey @@ -2229,7 +2229,7 @@ Per-Host Resources: mem-estimate=389.41MB mem-reservation=43.00MB thread-reserva | in pipelines: 00(GETNEXT), 01(OPEN) | |--03:EXCHANGE [BROADCAST] -| | mem-estimate=0B mem-reservation=0B thread-reservation=0 +| | mem-estimate=10.38MB mem-reservation=0B thread-reservation=0 | | tuple-ids=1 row-size=191B cardinality=1500000 | | in pipelines: 01(GETNEXT) | | @@ -2257,15 +2257,15 @@ Per-Host Resources: mem-estimate=389.41MB mem-reservation=43.00MB thread-reserva in pipelines: 00(GETNEXT) ---- PARALLELPLANS Max Per-Host Resource Reservation: Memory=102.00MB Threads=5 -Per-Host Resource Estimates: Memory=955MB +Per-Host Resource Estimates: Memory=968MB F02:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=12.71MB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 04:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=12.71MB mem-reservation=0B thread-reservation=0 | tuple-ids=0,1 row-size=454B cardinality=5757710 | in pipelines: 00(GETNEXT) | @@ -2288,7 +2288,7 @@ Per-Host Resources: mem-estimate=778.83MB mem-reservation=86.00MB thread-reserva | | mem-estimate=0B mem-reservation=0B thread-reservation=0 | | | 03:EXCHANGE [BROADCAST] -| | mem-estimate=0B mem-reservation=0B thread-reservation=0 +| | mem-estimate=10.76MB mem-reservation=0B thread-reservation=0 | | tuple-ids=1 row-size=191B cardinality=1500000 | | in pipelines: 01(GETNEXT) | | @@ -2357,20 +2357,20 @@ PLAN-ROOT SINK in pipelines: 00(GETNEXT) ---- DISTRIBUTEDPLAN Max Per-Host Resource Reservation: Memory=52.00MB Threads=6 -Per-Host Resource Estimates: Memory=278MB +Per-Host Resource Estimates: Memory=311MB F03:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=11.35MB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 05:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=11.35MB mem-reservation=0B thread-reservation=0 | tuple-ids=0,1 row-size=454B cardinality=5757710 | in pipelines: 00(GETNEXT) | F02:PLAN FRAGMENT [HASH(l_orderkey)] hosts=3 instances=3 -Per-Host Resources: mem-estimate=101.14MB mem-reservation=35.00MB thread-reservation=1 runtime-filters-memory=1.00MB +Per-Host Resources: mem-estimate=122.30MB mem-reservation=35.00MB thread-reservation=1 runtime-filters-memory=1.00MB 02:HASH JOIN [INNER JOIN, PARTITIONED] | hash predicates: l_orderkey = o_orderkey | fk/pk conjuncts: l_orderkey = o_orderkey @@ -2380,7 +2380,7 @@ Per-Host Resources: mem-estimate=101.14MB mem-reservation=35.00MB thread-reserva | in pipelines: 00(GETNEXT), 01(OPEN) | |--04:EXCHANGE [HASH(o_orderkey)] -| | mem-estimate=0B mem-reservation=0B thread-reservation=0 +| | mem-estimate=10.38MB mem-reservation=0B thread-reservation=0 | | tuple-ids=1 row-size=191B cardinality=1500000 | | in pipelines: 01(GETNEXT) | | @@ -2397,7 +2397,7 @@ Per-Host Resources: mem-estimate=101.14MB mem-reservation=35.00MB thread-reserva | in pipelines: 01(GETNEXT) | 03:EXCHANGE [HASH(l_orderkey)] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=10.78MB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=263B cardinality=6001215 | in pipelines: 00(GETNEXT) | @@ -2415,20 +2415,20 @@ Per-Host Resources: mem-estimate=89.00MB mem-reservation=9.00MB thread-reservati in pipelines: 00(GETNEXT) ---- PARALLELPLANS Max Per-Host Resource Reservation: Memory=104.00MB Threads=7 -Per-Host Resource Estimates: Memory=456MB +Per-Host Resource Estimates: Memory=492MB F03:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=12.71MB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 05:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=12.71MB mem-reservation=0B thread-reservation=0 | tuple-ids=0,1 row-size=454B cardinality=5757710 | in pipelines: 00(GETNEXT) | F02:PLAN FRAGMENT [HASH(l_orderkey)] hosts=3 instances=6 -Per-Host Resources: mem-estimate=102.14MB mem-reservation=70.00MB thread-reservation=2 runtime-filters-memory=1.00MB +Per-Host Resources: mem-estimate=125.26MB mem-reservation=70.00MB thread-reservation=2 runtime-filters-memory=1.00MB 02:HASH JOIN [INNER JOIN, PARTITIONED] | hash-table-id=00 | hash predicates: l_orderkey = o_orderkey @@ -2446,7 +2446,7 @@ Per-Host Resources: mem-estimate=102.14MB mem-reservation=70.00MB thread-reserva | | mem-estimate=0B mem-reservation=0B thread-reservation=0 | | | 04:EXCHANGE [HASH(o_orderkey)] -| | mem-estimate=0B mem-reservation=0B thread-reservation=0 +| | mem-estimate=10.76MB mem-reservation=0B thread-reservation=0 | | tuple-ids=1 row-size=191B cardinality=1500000 | | in pipelines: 01(GETNEXT) | | @@ -2463,7 +2463,7 @@ Per-Host Resources: mem-estimate=102.14MB mem-reservation=70.00MB thread-reserva | in pipelines: 01(GETNEXT) | 03:EXCHANGE [HASH(l_orderkey)] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=11.56MB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=263B cardinality=6001215 | in pipelines: 00(GETNEXT) | @@ -2518,27 +2518,27 @@ PLAN-ROOT SINK in pipelines: 00(GETNEXT) ---- DISTRIBUTEDPLAN Max Per-Host Resource Reservation: Memory=16.00MB Threads=5 -Per-Host Resource Estimates: Memory=449MB +Per-Host Resource Estimates: Memory=471MB F02:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=11.35MB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 04:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=11.35MB mem-reservation=0B thread-reservation=0 | tuple-ids=0,1 row-size=454B cardinality=9001822500000 | in pipelines: 00(GETNEXT) | F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 -Per-Host Resources: mem-estimate=361.10MB mem-reservation=8.00MB thread-reservation=2 +Per-Host Resources: mem-estimate=371.49MB mem-reservation=8.00MB thread-reservation=2 02:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] | mem-estimate=273.10MB mem-reservation=0B thread-reservation=0 | tuple-ids=0,1 row-size=454B cardinality=9001822500000 | in pipelines: 00(GETNEXT), 01(OPEN) | |--03:EXCHANGE [BROADCAST] -| | mem-estimate=0B mem-reservation=0B thread-reservation=0 +| | mem-estimate=10.38MB mem-reservation=0B thread-reservation=0 | | tuple-ids=1 row-size=191B cardinality=1500000 | | in pipelines: 01(GETNEXT) | | @@ -2565,20 +2565,20 @@ Per-Host Resources: mem-estimate=361.10MB mem-reservation=8.00MB thread-reservat in pipelines: 00(GETNEXT) ---- PARALLELPLANS Max Per-Host Resource Reservation: Memory=32.00MB Threads=5 -Per-Host Resource Estimates: Memory=898MB +Per-Host Resource Estimates: Memory=932MB F02:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=12.71MB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 04:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=12.71MB mem-reservation=0B thread-reservation=0 | tuple-ids=0,1 row-size=454B cardinality=9001822500000 | in pipelines: 00(GETNEXT) | F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=6 -Per-Host Resources: mem-estimate=722.21MB mem-reservation=16.00MB thread-reservation=2 +Per-Host Resources: mem-estimate=743.73MB mem-reservation=16.00MB thread-reservation=2 02:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] | join table id: 00 | mem-estimate=273.10MB mem-reservation=0B thread-reservation=0 @@ -2592,7 +2592,7 @@ Per-Host Resources: mem-estimate=722.21MB mem-reservation=16.00MB thread-reserva | | mem-estimate=0B mem-reservation=0B thread-reservation=0 | | | 03:EXCHANGE [BROADCAST] -| | mem-estimate=0B mem-reservation=0B thread-reservation=0 +| | mem-estimate=10.76MB mem-reservation=0B thread-reservation=0 | | tuple-ids=1 row-size=191B cardinality=1500000 | | in pipelines: 01(GETNEXT) | | @@ -2705,17 +2705,17 @@ Per-Host Resource Estimates: Memory=26MB Codegen disabled by planner F02:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=56.26KB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 04:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=56.26KB mem-reservation=0B thread-reservation=0 | tuple-ids=3,2 row-size=6B cardinality=7300 | in pipelines: 01(GETNEXT) | F01:PLAN FRAGMENT [HASH(int_col)] hosts=3 instances=3 -Per-Host Resources: mem-estimate=10.00MB mem-reservation=10.00MB thread-reservation=1 +Per-Host Resources: mem-estimate=10.04MB mem-reservation=10.00MB thread-reservation=1 02:ANALYTIC | functions: max(tinyint_col) | partition by: int_col @@ -2730,7 +2730,7 @@ Per-Host Resources: mem-estimate=10.00MB mem-reservation=10.00MB thread-reservat | in pipelines: 01(GETNEXT), 00(OPEN) | 03:EXCHANGE [HASH(int_col)] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=38.88KB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=5B cardinality=7300 | in pipelines: 00(GETNEXT) | @@ -2752,17 +2752,17 @@ Per-Host Resource Estimates: Memory=52MB Codegen disabled by planner F02:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=98.26KB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 04:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=98.26KB mem-reservation=0B thread-reservation=0 | tuple-ids=3,2 row-size=6B cardinality=7300 | in pipelines: 01(GETNEXT) | F01:PLAN FRAGMENT [HASH(int_col)] hosts=3 instances=6 -Per-Host Resources: mem-estimate=20.00MB mem-reservation=20.00MB thread-reservation=2 +Per-Host Resources: mem-estimate=20.13MB mem-reservation=20.00MB thread-reservation=2 02:ANALYTIC | functions: max(tinyint_col) | partition by: int_col @@ -2777,7 +2777,7 @@ Per-Host Resources: mem-estimate=20.00MB mem-reservation=20.00MB thread-reservat | in pipelines: 01(GETNEXT), 00(OPEN) | 03:EXCHANGE [HASH(int_col)] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=65.88KB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=5B cardinality=7300 | in pipelines: 00(GETNEXT) | @@ -2852,20 +2852,20 @@ PLAN-ROOT SINK | in pipelines: 01(GETNEXT), 00(OPEN) | 00:SCAN HDFS [tpch_parquet.orders] - partitions=1/1 files=2 size=54.21MB + partitions=1/1 files=2 size=54.07MB stored statistics: - table: rows=1500000 size=54.21MB + table: rows=1500000 size=54.07MB columns: all - extrapolated-rows=disabled max-scan-range-rows=1177197 + extrapolated-rows=disabled max-scan-range-rows=1177135 mem-estimate=40.00MB mem-reservation=24.00MB thread-reservation=1 tuple-ids=0 row-size=191B cardinality=1500000 in pipelines: 00(GETNEXT) ---- DISTRIBUTEDPLAN Max Per-Host Resource Reservation: Memory=68.00MB Threads=3 -Per-Host Resource Estimates: Memory=102MB +Per-Host Resource Estimates: Memory=108MB F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=44.00MB mem-reservation=32.00MB thread-reservation=1 +| Per-Host Resources: mem-estimate=50.38MB mem-reservation=32.00MB thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | @@ -2907,7 +2907,7 @@ PLAN-ROOT SINK | 07:MERGING-EXCHANGE [UNPARTITIONED] | order by: o_totalprice ASC -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=20.38MB mem-reservation=0B thread-reservation=0 | tuple-ids=6 row-size=191B cardinality=1500000 | in pipelines: 01(GETNEXT) | @@ -2920,20 +2920,20 @@ Per-Host Resources: mem-estimate=58.00MB mem-reservation=36.00MB thread-reservat | in pipelines: 01(GETNEXT), 00(OPEN) | 00:SCAN HDFS [tpch_parquet.orders, RANDOM] - partitions=1/1 files=2 size=54.21MB + partitions=1/1 files=2 size=54.07MB stored statistics: - table: rows=1500000 size=54.21MB + table: rows=1500000 size=54.07MB columns: all - extrapolated-rows=disabled max-scan-range-rows=1177197 + extrapolated-rows=disabled max-scan-range-rows=1177135 mem-estimate=40.00MB mem-reservation=24.00MB thread-reservation=1 tuple-ids=0 row-size=191B cardinality=1500000 in pipelines: 00(GETNEXT) ---- PARALLELPLANS Max Per-Host Resource Reservation: Memory=104.00MB Threads=3 -Per-Host Resource Estimates: Memory=160MB +Per-Host Resource Estimates: Memory=187MB F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=44.00MB mem-reservation=32.00MB thread-reservation=1 +| Per-Host Resources: mem-estimate=70.76MB mem-reservation=32.00MB thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | @@ -2975,7 +2975,7 @@ PLAN-ROOT SINK | 07:MERGING-EXCHANGE [UNPARTITIONED] | order by: o_totalprice ASC -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=40.76MB mem-reservation=0B thread-reservation=0 | tuple-ids=6 row-size=191B cardinality=1500000 | in pipelines: 01(GETNEXT) | @@ -2988,11 +2988,11 @@ Per-Host Resources: mem-estimate=116.00MB mem-reservation=72.00MB thread-reserva | in pipelines: 01(GETNEXT), 00(OPEN) | 00:SCAN HDFS [tpch_parquet.orders, RANDOM] - partitions=1/1 files=2 size=54.21MB + partitions=1/1 files=2 size=54.07MB stored statistics: - table: rows=1500000 size=54.21MB + table: rows=1500000 size=54.07MB columns: all - extrapolated-rows=disabled max-scan-range-rows=1177197 + extrapolated-rows=disabled max-scan-range-rows=1177135 mem-estimate=40.00MB mem-reservation=24.00MB thread-reservation=0 tuple-ids=0 row-size=191B cardinality=1500000 in pipelines: 00(GETNEXT) @@ -3033,23 +3033,23 @@ PLAN-ROOT SINK | | in pipelines: 08(GETNEXT), 09(OPEN) | | | |--09:SCAN HDFS [tpch_parquet.orders] -| | partitions=1/1 files=2 size=54.21MB +| | partitions=1/1 files=2 size=54.07MB | | stored statistics: -| | table: rows=1500000 size=54.21MB +| | table: rows=1500000 size=54.07MB | | columns: all -| | extrapolated-rows=disabled max-scan-range-rows=1177197 +| | extrapolated-rows=disabled max-scan-range-rows=1177135 | | mem-estimate=40.00MB mem-reservation=4.00MB thread-reservation=1 | | tuple-ids=6 row-size=8B cardinality=1500000 | | in pipelines: 09(GETNEXT) | | | 08:SCAN HDFS [tpch_parquet.lineitem] -| partitions=1/1 files=3 size=193.99MB +| partitions=1/1 files=3 size=193.72MB | predicates: l_shipmode = 'F' | runtime filters: RF004[bloom] -> l_orderkey | stored statistics: -| table: rows=6001215 size=193.99MB +| table: rows=6001215 size=193.72MB | columns: all -| extrapolated-rows=disabled max-scan-range-rows=2141664 +| extrapolated-rows=disabled max-scan-range-rows=2141530 | parquet statistics predicates: l_shipmode = 'F' | parquet dictionary predicates: l_shipmode = 'F' | mem-estimate=80.00MB mem-reservation=24.00MB thread-reservation=1 @@ -3065,12 +3065,12 @@ PLAN-ROOT SINK | | in pipelines: 05(GETNEXT), 06(OPEN) | | | |--06:SCAN HDFS [tpch_parquet.orders] -| | partitions=1/1 files=2 size=54.21MB +| | partitions=1/1 files=2 size=54.07MB | | predicates: o_orderpriority = '2-HIGH' | | stored statistics: -| | table: rows=1500000 size=54.21MB +| | table: rows=1500000 size=54.07MB | | columns: all -| | extrapolated-rows=disabled max-scan-range-rows=1177197 +| | extrapolated-rows=disabled max-scan-range-rows=1177135 | | parquet statistics predicates: o_orderpriority = '2-HIGH' | | parquet dictionary predicates: o_orderpriority = '2-HIGH' | | mem-estimate=40.00MB mem-reservation=8.00MB thread-reservation=1 @@ -3078,12 +3078,12 @@ PLAN-ROOT SINK | | in pipelines: 06(GETNEXT) | | | 05:SCAN HDFS [tpch_parquet.lineitem] -| partitions=1/1 files=3 size=193.99MB +| partitions=1/1 files=3 size=193.72MB | runtime filters: RF002[bloom] -> l_orderkey | stored statistics: -| table: rows=6001215 size=193.99MB +| table: rows=6001215 size=193.72MB | columns: all -| extrapolated-rows=disabled max-scan-range-rows=2141664 +| extrapolated-rows=disabled max-scan-range-rows=2141530 | mem-estimate=80.00MB mem-reservation=24.00MB thread-reservation=1 | tuple-ids=3 row-size=70B cardinality=6001215 | in pipelines: 05(GETNEXT) @@ -3103,23 +3103,23 @@ PLAN-ROOT SINK | in pipelines: 01(GETNEXT), 02(OPEN) | |--02:SCAN HDFS [tpch_parquet.orders] -| partitions=1/1 files=2 size=54.21MB +| partitions=1/1 files=2 size=54.07MB | stored statistics: -| table: rows=1500000 size=54.21MB +| table: rows=1500000 size=54.07MB | columns: all -| extrapolated-rows=disabled max-scan-range-rows=1177197 +| extrapolated-rows=disabled max-scan-range-rows=1177135 | mem-estimate=40.00MB mem-reservation=4.00MB thread-reservation=1 | tuple-ids=1 row-size=8B cardinality=1500000 | in pipelines: 02(GETNEXT) | 01:SCAN HDFS [tpch_parquet.lineitem] - partitions=1/1 files=3 size=193.99MB + partitions=1/1 files=3 size=193.72MB predicates: l_tax > 10 runtime filters: RF000[bloom] -> l_orderkey stored statistics: - table: rows=6001215 size=193.99MB + table: rows=6001215 size=193.72MB columns: all - extrapolated-rows=disabled max-scan-range-rows=2141664 + extrapolated-rows=disabled max-scan-range-rows=2141530 parquet statistics predicates: l_tax > 10 parquet dictionary predicates: l_tax > 10 mem-estimate=80.00MB mem-reservation=24.00MB thread-reservation=1 @@ -3127,20 +3127,20 @@ PLAN-ROOT SINK in pipelines: 01(GETNEXT) ---- DISTRIBUTEDPLAN Max Per-Host Resource Reservation: Memory=123.75MB Threads=12 -Per-Host Resource Estimates: Memory=348MB +Per-Host Resource Estimates: Memory=385MB F09:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=10.22MB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 17:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=10.22MB mem-reservation=0B thread-reservation=0 | tuple-ids=7 row-size=70B cardinality=2549844 | in pipelines: 14(GETNEXT), 05(GETNEXT), 08(GETNEXT) | F08:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 -Per-Host Resources: mem-estimate=99.00MB mem-reservation=43.00MB thread-reservation=2 runtime-filters-memory=2.00MB +Per-Host Resources: mem-estimate=109.02MB mem-reservation=43.00MB thread-reservation=2 runtime-filters-memory=2.00MB 00:UNION | pass-through-operands: 14 | mem-estimate=0B mem-reservation=0B thread-reservation=0 @@ -3156,30 +3156,30 @@ Per-Host Resources: mem-estimate=99.00MB mem-reservation=43.00MB thread-reservat | | in pipelines: 08(GETNEXT), 09(OPEN) | | | |--16:EXCHANGE [BROADCAST] -| | | mem-estimate=0B mem-reservation=0B thread-reservation=0 +| | | mem-estimate=10.02MB mem-reservation=0B thread-reservation=0 | | | tuple-ids=6 row-size=8B cardinality=1500000 | | | in pipelines: 09(GETNEXT) | | | | | F07:PLAN FRAGMENT [RANDOM] hosts=2 instances=2 | | Per-Host Resources: mem-estimate=40.00MB mem-reservation=4.00MB thread-reservation=2 | | 09:SCAN HDFS [tpch_parquet.orders, RANDOM] -| | partitions=1/1 files=2 size=54.21MB +| | partitions=1/1 files=2 size=54.07MB | | stored statistics: -| | table: rows=1500000 size=54.21MB +| | table: rows=1500000 size=54.07MB | | columns: all -| | extrapolated-rows=disabled max-scan-range-rows=1177197 +| | extrapolated-rows=disabled max-scan-range-rows=1177135 | | mem-estimate=40.00MB mem-reservation=4.00MB thread-reservation=1 | | tuple-ids=6 row-size=8B cardinality=1500000 | | in pipelines: 09(GETNEXT) | | | 08:SCAN HDFS [tpch_parquet.lineitem, RANDOM] -| partitions=1/1 files=3 size=193.99MB +| partitions=1/1 files=3 size=193.72MB | predicates: l_shipmode = 'F' | runtime filters: RF004[bloom] -> l_orderkey | stored statistics: -| table: rows=6001215 size=193.99MB +| table: rows=6001215 size=193.72MB | columns: all -| extrapolated-rows=disabled max-scan-range-rows=2141664 +| extrapolated-rows=disabled max-scan-range-rows=2141530 | parquet statistics predicates: l_shipmode = 'F' | parquet dictionary predicates: l_shipmode = 'F' | mem-estimate=80.00MB mem-reservation=24.00MB thread-reservation=1 @@ -3195,19 +3195,19 @@ Per-Host Resources: mem-estimate=99.00MB mem-reservation=43.00MB thread-reservat | | in pipelines: 05(GETNEXT), 06(OPEN) | | | |--15:EXCHANGE [BROADCAST] -| | | mem-estimate=0B mem-reservation=0B thread-reservation=0 +| | | mem-estimate=9.34MB mem-reservation=0B thread-reservation=0 | | | tuple-ids=4 row-size=32B cardinality=300000 | | | in pipelines: 06(GETNEXT) | | | | | F05:PLAN FRAGMENT [RANDOM] hosts=2 instances=2 | | Per-Host Resources: mem-estimate=40.00MB mem-reservation=8.00MB thread-reservation=2 | | 06:SCAN HDFS [tpch_parquet.orders, RANDOM] -| | partitions=1/1 files=2 size=54.21MB +| | partitions=1/1 files=2 size=54.07MB | | predicates: o_orderpriority = '2-HIGH' | | stored statistics: -| | table: rows=1500000 size=54.21MB +| | table: rows=1500000 size=54.07MB | | columns: all -| | extrapolated-rows=disabled max-scan-range-rows=1177197 +| | extrapolated-rows=disabled max-scan-range-rows=1177135 | | parquet statistics predicates: o_orderpriority = '2-HIGH' | | parquet dictionary predicates: o_orderpriority = '2-HIGH' | | mem-estimate=40.00MB mem-reservation=8.00MB thread-reservation=1 @@ -3215,12 +3215,12 @@ Per-Host Resources: mem-estimate=99.00MB mem-reservation=43.00MB thread-reservat | | in pipelines: 06(GETNEXT) | | | 05:SCAN HDFS [tpch_parquet.lineitem, RANDOM] -| partitions=1/1 files=3 size=193.99MB +| partitions=1/1 files=3 size=193.72MB | runtime filters: RF002[bloom] -> l_orderkey | stored statistics: -| table: rows=6001215 size=193.99MB +| table: rows=6001215 size=193.72MB | columns: all -| extrapolated-rows=disabled max-scan-range-rows=2141664 +| extrapolated-rows=disabled max-scan-range-rows=2141530 | mem-estimate=80.00MB mem-reservation=24.00MB thread-reservation=1 | tuple-ids=3 row-size=70B cardinality=6001215 | in pipelines: 05(GETNEXT) @@ -3232,12 +3232,12 @@ Per-Host Resources: mem-estimate=99.00MB mem-reservation=43.00MB thread-reservat | in pipelines: 14(GETNEXT), 01(OPEN) | 13:EXCHANGE [HASH(l_orderkey,l_partkey,l_suppkey,l_linenumber,l_comment)] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=10.22MB mem-reservation=0B thread-reservation=0 | tuple-ids=2 row-size=70B cardinality=575772 | in pipelines: 01(GETNEXT) | F02:PLAN FRAGMENT [HASH(l_orderkey)] hosts=3 instances=3 -Per-Host Resources: mem-estimate=48.33MB mem-reservation=39.75MB thread-reservation=1 runtime-filters-memory=1.00MB +Per-Host Resources: mem-estimate=64.32MB mem-reservation=39.75MB thread-reservation=1 runtime-filters-memory=1.00MB 04:AGGREGATE [STREAMING] | group by: l_orderkey, l_partkey, l_suppkey, l_linenumber, l_comment | mem-estimate=42.58MB mem-reservation=34.00MB spill-buffer=2.00MB thread-reservation=0 @@ -3253,37 +3253,37 @@ Per-Host Resources: mem-estimate=48.33MB mem-reservation=39.75MB thread-reservat | in pipelines: 01(GETNEXT), 02(OPEN) | |--12:EXCHANGE [HASH(o_orderkey)] -| | mem-estimate=0B mem-reservation=0B thread-reservation=0 +| | mem-estimate=5.75MB mem-reservation=0B thread-reservation=0 | | tuple-ids=1 row-size=8B cardinality=1500000 | | in pipelines: 02(GETNEXT) | | | F01:PLAN FRAGMENT [RANDOM] hosts=2 instances=2 | Per-Host Resources: mem-estimate=40.00MB mem-reservation=4.00MB thread-reservation=2 | 02:SCAN HDFS [tpch_parquet.orders, RANDOM] -| partitions=1/1 files=2 size=54.21MB +| partitions=1/1 files=2 size=54.07MB | stored statistics: -| table: rows=1500000 size=54.21MB +| table: rows=1500000 size=54.07MB | columns: all -| extrapolated-rows=disabled max-scan-range-rows=1177197 +| extrapolated-rows=disabled max-scan-range-rows=1177135 | mem-estimate=40.00MB mem-reservation=4.00MB thread-reservation=1 | tuple-ids=1 row-size=8B cardinality=1500000 | in pipelines: 02(GETNEXT) | 11:EXCHANGE [HASH(l_orderkey)] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=10.24MB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=78B cardinality=600122 | in pipelines: 01(GETNEXT) | F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=81.00MB mem-reservation=25.00MB thread-reservation=2 runtime-filters-memory=1.00MB 01:SCAN HDFS [tpch_parquet.lineitem, RANDOM] - partitions=1/1 files=3 size=193.99MB + partitions=1/1 files=3 size=193.72MB predicates: l_tax > 10 runtime filters: RF000[bloom] -> l_orderkey stored statistics: - table: rows=6001215 size=193.99MB + table: rows=6001215 size=193.72MB columns: all - extrapolated-rows=disabled max-scan-range-rows=2141664 + extrapolated-rows=disabled max-scan-range-rows=2141530 parquet statistics predicates: l_tax > 10 parquet dictionary predicates: l_tax > 10 mem-estimate=80.00MB mem-reservation=24.00MB thread-reservation=1 @@ -3291,15 +3291,15 @@ Per-Host Resources: mem-estimate=81.00MB mem-reservation=25.00MB thread-reservat in pipelines: 01(GETNEXT) ---- PARALLELPLANS Max Per-Host Resource Reservation: Memory=243.75MB Threads=13 -Per-Host Resource Estimates: Memory=693MB +Per-Host Resource Estimates: Memory=724MB F09:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-estimate=0B mem-reservation=0B thread-reservation=1 +| Per-Host Resources: mem-estimate=10.44MB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 17:EXCHANGE [UNPARTITIONED] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=10.44MB mem-reservation=0B thread-reservation=0 | tuple-ids=7 row-size=70B cardinality=2549844 | in pipelines: 14(GETNEXT), 05(GETNEXT), 08(GETNEXT) | @@ -3328,30 +3328,30 @@ Per-Host Resources: mem-estimate=198.00MB mem-reservation=86.00MB thread-reserva | | | mem-estimate=0B mem-reservation=0B thread-reservation=0 | | | | | 16:EXCHANGE [BROADCAST] -| | | mem-estimate=0B mem-reservation=0B thread-reservation=0 +| | | mem-estimate=10.05MB mem-reservation=0B thread-reservation=0 | | | tuple-ids=6 row-size=8B cardinality=1500000 | | | in pipelines: 09(GETNEXT) | | | | | F07:PLAN FRAGMENT [RANDOM] hosts=2 instances=4 | | Per-Host Resources: mem-estimate=80.00MB mem-reservation=8.00MB thread-reservation=2 | | 09:SCAN HDFS [tpch_parquet.orders, RANDOM] -| | partitions=1/1 files=2 size=54.21MB +| | partitions=1/1 files=2 size=54.07MB | | stored statistics: -| | table: rows=1500000 size=54.21MB +| | table: rows=1500000 size=54.07MB | | columns: all -| | extrapolated-rows=disabled max-scan-range-rows=1177197 +| | extrapolated-rows=disabled max-scan-range-rows=1177135 | | mem-estimate=40.00MB mem-reservation=4.00MB thread-reservation=0 | | tuple-ids=6 row-size=8B cardinality=1500000 | | in pipelines: 09(GETNEXT) | | | 08:SCAN HDFS [tpch_parquet.lineitem, RANDOM] -| partitions=1/1 files=3 size=193.99MB +| partitions=1/1 files=3 size=193.72MB | predicates: l_shipmode = 'F' | runtime filters: RF004[bloom] -> l_orderkey | stored statistics: -| table: rows=6001215 size=193.99MB +| table: rows=6001215 size=193.72MB | columns: all -| extrapolated-rows=disabled max-scan-range-rows=2141664 +| extrapolated-rows=disabled max-scan-range-rows=2141530 | parquet statistics predicates: l_shipmode = 'F' | parquet dictionary predicates: l_shipmode = 'F' | mem-estimate=80.00MB mem-reservation=24.00MB thread-reservation=0 @@ -3375,19 +3375,19 @@ Per-Host Resources: mem-estimate=198.00MB mem-reservation=86.00MB thread-reserva | | | mem-estimate=0B mem-reservation=0B thread-reservation=0 | | | | | 15:EXCHANGE [BROADCAST] -| | | mem-estimate=0B mem-reservation=0B thread-reservation=0 +| | | mem-estimate=9.41MB mem-reservation=0B thread-reservation=0 | | | tuple-ids=4 row-size=32B cardinality=300000 | | | in pipelines: 06(GETNEXT) | | | | | F05:PLAN FRAGMENT [RANDOM] hosts=2 instances=4 | | Per-Host Resources: mem-estimate=80.00MB mem-reservation=16.00MB thread-reservation=2 | | 06:SCAN HDFS [tpch_parquet.orders, RANDOM] -| | partitions=1/1 files=2 size=54.21MB +| | partitions=1/1 files=2 size=54.07MB | | predicates: o_orderpriority = '2-HIGH' | | stored statistics: -| | table: rows=1500000 size=54.21MB +| | table: rows=1500000 size=54.07MB | | columns: all -| | extrapolated-rows=disabled max-scan-range-rows=1177197 +| | extrapolated-rows=disabled max-scan-range-rows=1177135 | | parquet statistics predicates: o_orderpriority = '2-HIGH' | | parquet dictionary predicates: o_orderpriority = '2-HIGH' | | mem-estimate=40.00MB mem-reservation=8.00MB thread-reservation=0 @@ -3395,12 +3395,12 @@ Per-Host Resources: mem-estimate=198.00MB mem-reservation=86.00MB thread-reserva | | in pipelines: 06(GETNEXT) | | | 05:SCAN HDFS [tpch_parquet.lineitem, RANDOM] -| partitions=1/1 files=3 size=193.99MB +| partitions=1/1 files=3 size=193.72MB | runtime filters: RF002[bloom] -> l_orderkey | stored statistics: -| table: rows=6001215 size=193.99MB +| table: rows=6001215 size=193.72MB | columns: all -| extrapolated-rows=disabled max-scan-range-rows=2141664 +| extrapolated-rows=disabled max-scan-range-rows=2141530 | mem-estimate=80.00MB mem-reservation=24.00MB thread-reservation=0 | tuple-ids=3 row-size=70B cardinality=6001215 | in pipelines: 05(GETNEXT) @@ -3412,12 +3412,12 @@ Per-Host Resources: mem-estimate=198.00MB mem-reservation=86.00MB thread-reserva | in pipelines: 14(GETNEXT), 01(OPEN) | 13:EXCHANGE [HASH(l_orderkey,l_partkey,l_suppkey,l_linenumber,l_comment)] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=10.44MB mem-reservation=0B thread-reservation=0 | tuple-ids=2 row-size=70B cardinality=575772 | in pipelines: 01(GETNEXT) | F02:PLAN FRAGMENT [HASH(l_orderkey)] hosts=3 instances=6 -Per-Host Resources: mem-estimate=92.91MB mem-reservation=75.75MB thread-reservation=2 runtime-filters-memory=1.00MB +Per-Host Resources: mem-estimate=113.87MB mem-reservation=75.75MB thread-reservation=2 runtime-filters-memory=1.00MB 04:AGGREGATE [STREAMING] | group by: l_orderkey, l_partkey, l_suppkey, l_linenumber, l_comment | mem-estimate=42.58MB mem-reservation=34.00MB spill-buffer=2.00MB thread-reservation=0 @@ -3441,37 +3441,37 @@ Per-Host Resources: mem-estimate=92.91MB mem-reservation=75.75MB thread-reservat | | mem-estimate=0B mem-reservation=0B thread-reservation=0 | | | 12:EXCHANGE [HASH(o_orderkey)] -| | mem-estimate=0B mem-reservation=0B thread-reservation=0 +| | mem-estimate=5.77MB mem-reservation=0B thread-reservation=0 | | tuple-ids=1 row-size=8B cardinality=1500000 | | in pipelines: 02(GETNEXT) | | | F01:PLAN FRAGMENT [RANDOM] hosts=2 instances=4 | Per-Host Resources: mem-estimate=80.00MB mem-reservation=8.00MB thread-reservation=2 | 02:SCAN HDFS [tpch_parquet.orders, RANDOM] -| partitions=1/1 files=2 size=54.21MB +| partitions=1/1 files=2 size=54.07MB | stored statistics: -| table: rows=1500000 size=54.21MB +| table: rows=1500000 size=54.07MB | columns: all -| extrapolated-rows=disabled max-scan-range-rows=1177197 +| extrapolated-rows=disabled max-scan-range-rows=1177135 | mem-estimate=40.00MB mem-reservation=4.00MB thread-reservation=0 | tuple-ids=1 row-size=8B cardinality=1500000 | in pipelines: 02(GETNEXT) | 11:EXCHANGE [HASH(l_orderkey)] -| mem-estimate=0B mem-reservation=0B thread-reservation=0 +| mem-estimate=10.48MB mem-reservation=0B thread-reservation=0 | tuple-ids=0 row-size=78B cardinality=600122 | in pipelines: 01(GETNEXT) | F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=6 Per-Host Resources: mem-estimate=162.00MB mem-reservation=50.00MB thread-reservation=2 runtime-filters-memory=1.00MB 01:SCAN HDFS [tpch_parquet.lineitem, RANDOM] - partitions=1/1 files=3 size=193.99MB + partitions=1/1 files=3 size=193.72MB predicates: l_tax > 10 runtime filters: RF000[bloom] -> l_orderkey stored statistics: - table: rows=6001215 size=193.99MB + table: rows=6001215 size=193.72MB columns: all - extrapolated-rows=disabled max-scan-range-rows=2141664 + extrapolated-rows=disabled max-scan-range-rows=2141530 parquet statistics predicates: l_tax > 10 parquet dictionary predicates: l_tax > 10 mem-estimate=80.00MB mem-reservation=24.00MB thread-reservation=0 @@ -3609,22 +3609,22 @@ PLAN-ROOT SINK in pipelines: 02(GETNEXT) ---- DISTRIBUTEDPLAN Max Per-Host Resource Reservation: Memory=191.12MB Threads=11 -Per-Host Resource Estimates: Memory=524MB +Per-Host Resource Estimates: Memory=567MB F07:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 -| Per-Host Resources: mem-es
<TRUNCATED>
