Query (id=94eaa596d127242:b32b265600000000): DEBUG MODE WARNING: Query profile created while running a DEBUG build of Impala. Use RELEASE builds to measure query performance. Summary: Session ID: d34f3cfc090ec84b:12066560343cbe97 Session Type: BEESWAX Start Time: 2018-10-19 10:30:52.840364000 End Time: 2018-10-19 10:30:53.017545000 Query Type: QUERY Query State: EXCEPTION Query Status: Rejected query from pool default-pool: minimum memory reservation is greater than memory available to the query for buffer reservations. Memory reservation needed given the current plan: 128.00 KB. Adjust either the mem_limit or the pool config (max-query-mem-limit, min-query-mem-limit) for the query to allow the query memory limit to be at least 32.12 MB. Note that changing the mem_limit may also change the plan. See the query profile for more information about the per-node memory requirements. Impala Version: impalad version 3.1.0-SNAPSHOT DEBUG (build 9f5c5e6df03824cba292fe5a619153462c11669c) User: mikeb Connected User: mikeb Delegated User: Network Address: ::ffff:127.0.0.1:36918 Default Db: tpch_parquet Sql Statement: SELECT COUNT(*) FROM customer Coordinator: mikeb-ub162:22000 Query Options (set by configuration): MEM_LIMIT=25165824,MT_DOP=4 Query Options (set by configuration and planner): MEM_LIMIT=25165824,NUM_SCANNER_THREADS=1,MT_DOP=4 Plan: ---------------- Max Per-Host Resource Reservation: Memory=512.00KB Threads=5 Per-Host Resource Estimates: Memory=146MB F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 | Per-Host Resources: mem-estimate=10.00MB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 03:AGGREGATE [FINALIZE] | output: count:merge(*) | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 | tuple-ids=1 row-size=8B cardinality=1 | in pipelines: 03(GETNEXT), 01(OPEN) | 02:EXCHANGE [UNPARTITIONED] | mem-estimate=0B mem-reservation=0B thread-reservation=0 | tuple-ids=1 row-size=8B cardinality=1 | in pipelines: 01(GETNEXT) | F00:PLAN FRAGMENT [RANDOM] hosts=1 instances=4 Per-Host Resources: mem-estimate=136.00MB mem-reservation=512.00KB thread-reservation=4 01:AGGREGATE | output: sum_init_zero(tpch_parquet.customer.parquet-stats: num_rows) | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 | tuple-ids=1 row-size=8B cardinality=1 | in pipelines: 01(GETNEXT), 00(OPEN) | 00:SCAN HDFS [tpch_parquet.customer, RANDOM] partitions=1/1 files=1 size=12.34MB stored statistics: table: rows=150000 size=12.34MB columns: all extrapolated-rows=disabled max-scan-range-rows=150000 mem-estimate=24.00MB mem-reservation=128.00KB thread-reservation=0 tuple-ids=0 row-size=8B cardinality=150000 in pipelines: 00(GETNEXT) ---------------- Estimated Per-Host Mem: 153092096 Per Host Min Memory Reservation: mikeb-ub162:22000(0) mikeb-ub162:22001(128.00 KB) Request Pool: default-pool Admission result: Rejected Query Compilation: 156.372ms - Metadata of all 1 tables cached: 5.700ms (5.700ms) - Analysis finished: 16.648ms (10.948ms) - Value transfer graph computed: 33.521ms (16.872ms) - Single node plan created: 62.873ms (29.352ms) - Runtime filters computed: 67.800ms (4.927ms) - Distributed plan created: 68.078ms (277.939us) - Parallel plans created: 70.011ms (1.933ms) - Planning finished: 156.372ms (86.361ms) Query Timeline: 176.000ms - Query submitted: 0.000ns (0.000ns) - Planning finished: 176.000ms (176.000ms) - Submit for admission: 176.000ms (0.000ns) - Completed admission: 176.000ms (0.000ns) - Rows available: 176.000ms (0.000ns) - Unregister query: 176.000ms (0.000ns) - ComputeScanRangeAssignmentTimer: 0.000ns Frontend: ImpalaServer: - ClientFetchWaitTimer: 0.000ns - RowMaterializationTimer: 0.000ns