Stacktrace query_test/test_runtime_filters.py:288: in test_overlap_min_max_filters test_file_vars={'$RUNTIME_FILTER_WAIT_TIME_MS': str(WAIT_TIME_MS)}) common/impala_test_suite.py:721: in run_test_case update_section=pytest.config.option.update_results) common/test_result_verifier.py:659: in verify_runtime_profile % (function, field, expected_value, actual_value, op, actual)) E AssertionError: Aggregation of SUM over NumRuntimeFilteredPages did not match expected results. E EXPECTED VALUE: E 200 E E E ACTUAL VALUE: E 0 E E OP: E > E E E E PROFILE: E Query (id=c148078d46befb8c:0df7093a00000000): E DEBUG MODE WARNING: Query profile created while running a DEBUG build of Impala. Use RELEASE builds to measure query performance. E - InactiveTotalTime: 0.000ns E - TotalTime: 0.000ns E Summary: E Session ID: cd4bdfdb8acfadfb:84af4defa988e99a E Session Type: BEESWAX E Start Time: 2021-03-29 23:15:30.569387000 E End Time: 2021-03-29 23:15:31.439536000 E Query Type: QUERY E Query State: FINISHED E Impala Query State: FINISHED E Query Status: OK E Impala Version: impalad version 4.0.0-SNAPSHOT DEBUG (build 103774a8e517e5c8532e313df29e67008bc56617) E User: jenkins E Connected User: jenkins E Delegated User: E Network Address: ::1:48722 E Default Db: functional_parquet E Sql Statement: select straight_join a.l_orderkey from E tpch_parquet.lineitem_orderkey_only a join [SHUFFLE] tpch_parquet.orders b E where a.l_orderkey = b.o_orderkey E and b.o_custkey = 5 order by l_orderkey E Coordinator: impala-ec2-centos74-m5-4xlarge-ondemand-00ee.vpc.cloudera.com:27000 E Query Options (set by configuration): ABORT_ON_ERROR=1,EXEC_SINGLE_NODE_ROWS_THRESHOLD=0,RUNTIME_FILTER_WAIT_TIME_MS=60000,DISABLE_CODEGEN_ROWS_THRESHOLD=0,ALLOW_ERASURE_CODED_FILES=1,TIMEZONE=America/Los_Angeles,CLIENT_IDENTIFIER=query_test/test_runtime_filters.py::TestOverlapMinMaxFilters::()::test_overlap_min_max_filters[protocol:beeswax|exec_option:{'batch_size':0;'num_nodes':0;'disable_codegen_rows_threshold':0;'disable_codegen':False;'abort_on_error':1;'exec_single_node_rows_,MINMAX_FILTER_THRESHOLD=0.5,MINMAX_FILTERING_LEVEL=2 E Query Options (set by configuration and planner): ABORT_ON_ERROR=1,EXEC_SINGLE_NODE_ROWS_THRESHOLD=0,RUNTIME_FILTER_WAIT_TIME_MS=60000,MT_DOP=0,DISABLE_CODEGEN_ROWS_THRESHOLD=0,ALLOW_ERASURE_CODED_FILES=1,TIMEZONE=America/Los_Angeles,CLIENT_IDENTIFIER=query_test/test_runtime_filters.py::TestOverlapMinMaxFilters::()::test_overlap_min_max_filters[protocol:beeswax|exec_option:{'batch_size':0;'num_nodes':0;'disable_codegen_rows_threshold':0;'disable_codegen':False;'abort_on_error':1;'exec_single_node_rows_,MINMAX_FILTER_THRESHOLD=0.5,MINMAX_FILTERING_LEVEL=2 E Plan: E ---------------- E Max Per-Host Resource Reservation: Memory=25.94MB Threads=6 E Per-Host Resource Estimates: Memory=247MB E WARNING: The following tables are missing relevant table and/or column statistics. E tpch_parquet.lineitem_orderkey_only E Analyzed query: SELECT /* +straight_join */ a.l_orderkey FROM E tpch_parquet.lineitem_orderkey_only a INNER JOIN /* +SHUFFLE */ E tpch_parquet.orders b WHERE a.l_orderkey = b.o_orderkey AND b.o_custkey = CAST(5 E AS BIGINT) ORDER BY l_orderkey ASC E E F03:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 E | Per-Host Resources: mem-estimate=66.06MB mem-reservation=4.00MB thread-reservation=1 E PLAN-ROOT SINK E | output exprs: l_orderkey E | mem-estimate=46.03MB mem-reservation=4.00MB spill-buffer=2.00MB thread-reservation=0 E | E 06:MERGING-EXCHANGE [UNPARTITIONED] E | order by: l_orderkey ASC E | mem-estimate=20.02MB mem-reservation=0B thread-reservation=0 E | tuple-ids=2 row-size=8B cardinality=6.03M E | in pipelines: 03(GETNEXT) E | E F02:PLAN FRAGMENT [HASH(a.l_orderkey)] hosts=2 instances=2 E Per-Host Resources: mem-estimate=35.98MB mem-reservation=8.94MB thread-reservation=1 runtime-filters-memory=1.00MB E 03:SORT E | order by: l_orderkey ASC E | mem-estimate=23.02MB mem-reservation=6.00MB spill-buffer=2.00MB thread-reservation=0 E | tuple-ids=2 row-size=8B cardinality=6.03M E | in pipelines: 03(GETNEXT), 00(OPEN) E | E 02:HASH JOIN [INNER JOIN, PARTITIONED] E | hash predicates: a.l_orderkey = b.o_orderkey E | fk/pk conjuncts: assumed fk/pk E | runtime filters: RF000[bloom] <- b.o_orderkey, RF001[min_max] <- b.o_orderkey E | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0 E | tuple-ids=0,1 row-size=24B cardinality=6.03M E | in pipelines: 00(GETNEXT), 01(OPEN) E | E |--05:EXCHANGE [HASH(b.o_orderkey)] E | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 E | | tuple-ids=1 row-size=16B cardinality=15 E | | in pipelines: 01(GETNEXT) E | | E | F01:PLAN FRAGMENT [RANDOM] hosts=1 instances=1 E | Per-Host Resources: mem-estimate=128.00MB mem-reservation=8.00MB thread-reservation=2 E | 01:SCAN HDFS [tpch_parquet.orders b, RANDOM] E | HDFS partitions=1/1 files=1 size=53.93MB E | erasure coded: files=1 size=53.93MB E | predicates: b.o_custkey = CAST(5 AS BIGINT) E | stored statistics: E | table: rows=1.50M size=53.93MB E | columns: all E | extrapolated-rows=disabled max-scan-range-rows=1.50M E | parquet statistics predicates: b.o_custkey = CAST(5 AS BIGINT) E | parquet dictionary predicates: b.o_custkey = CAST(5 AS BIGINT) E | mem-estimate=128.00MB mem-reservation=8.00MB thread-reservation=1 E | tuple-ids=1 row-size=16B cardinality=15 E | in pipelines: 01(GETNEXT) E | E 04:EXCHANGE [HASH(a.l_orderkey)] E | mem-estimate=10.02MB mem-reservation=0B thread-reservation=0 E | tuple-ids=0 row-size=8B cardinality=6.03M E | in pipelines: 00(GETNEXT) E | E F00:PLAN FRAGMENT [RANDOM] hosts=2 instances=2 E Per-Host Resources: mem-estimate=17.00MB mem-reservation=5.00MB thread-reservation=2 runtime-filters-memory=1.00MB E 00:SCAN HDFS [tpch_parquet.lineitem_orderkey_only a, RANDOM] E HDFS partitions=1/1 files=2 size=9.26MB E erasure coded: files=2 size=9.26MB E runtime filters: RF001[min_max] -> a.l_orderkey, RF000[bloom] -> a.l_orderkey E stored statistics: E table: rows=unavailable size=unavailable E columns: unavailable E extrapolated-rows=disabled max-scan-range-rows=unavailable E mem-estimate=16.00MB mem-reservation=4.00MB thread-reservation=1 E tuple-ids=0 row-size=8B cardinality=6.03M E in pipelines: 00(GETNEXT) E ---------------- E Estimated Per-Host Mem: 259035012 E Tables Missing Stats: tpch_parquet.lineitem_orderkey_only E Request Pool: default-pool E Per Host Min Memory Reservation: impala-ec2-centos74-m5-4xlarge-ondemand-00ee.vpc.cloudera.com:27002(13.94 MB) impala-ec2-centos74-m5-4xlarge-ondemand-00ee.vpc.cloudera.com:27000(4.00 MB) impala-ec2-centos74-m5-4xlarge-ondemand-00ee.vpc.cloudera.com:27001(21.94 MB) E Per Host Number of Fragment Instances: impala-ec2-centos74-m5-4xlarge-ondemand-00ee.vpc.cloudera.com:27002(2) impala-ec2-centos74-m5-4xlarge-ondemand-00ee.vpc.cloudera.com:27000(1) impala-ec2-centos74-m5-4xlarge-ondemand-00ee.vpc.cloudera.com:27001(3) E Admission result: Admitted immediately E Cluster Memory Admitted: 741.11 MB E Executor Group: default E ExecSummary: E Operator #Hosts #Inst Avg Time Max Time #Rows Est. #Rows Peak Mem Est. Peak Mem Detail E ------------------------------------------------------------------------------------------------------------------------------------------------ E F03:ROOT 1 1 0.000ns 0.000ns 4.01 MB 46.03 MB E 06:MERGING-EXCHANGE 1 1 0.000ns 0.000ns 19 6.03M 32.00 KB 20.02 MB UNPARTITIONED E F02:EXCHANGE SENDER 2 2 0.000ns 0.000ns 14.22 KB 0 E 03:SORT 2 2 0.000ns 0.000ns 19 6.03M 6.02 MB 23.02 MB E 02:HASH JOIN 2 2 1.000ms 2.000ms 19 6.03M 1.99 MB 1.94 MB INNER JOIN, PARTITIONED E |--05:EXCHANGE 2 2 500.000us 1.000ms 4 15 16.00 KB 16.00 KB HASH(b.o_orderkey) E | F01:EXCHANGE SENDER 1 1 0.000ns 0.000ns 23.05 KB 0 E | 01:SCAN HDFS 1 1 127.000ms 127.000ms 4 15 8.94 MB 128.00 MB tpch_parquet.orders b E 04:EXCHANGE 2 2 0.000ns 0.000ns 19 6.03M 16.00 KB 10.02 MB HASH(a.l_orderkey) E F00:EXCHANGE SENDER 2 2 0.000ns 0.000ns 36.44 KB 0 E 00:SCAN HDFS 2 2 536.500ms 653.000ms 19 6.03M 8.62 MB 16.00 MB tpch_parquet.lineitem_orderkey_only a E Errors: E Query Compilation: 4.986ms E - Metadata of all 2 tables cached: 211.793us (211.793us) E - Analysis finished: 441.922us (230.129us) E - Authorization finished (noop): 448.554us (6.632us) E - Value transfer graph computed: 527.420us (78.866us) E - Single node plan created: 1.276ms (748.882us) E - Runtime filters computed: 3.778ms (2.502ms) E - Distributed plan created: 3.797ms (18.282us) E - Planning finished: 4.986ms (1.189ms) E Query Timeline: 873.000ms E - Query submitted: 0.000ns (0.000ns) E - Planning finished: 6.000ms (6.000ms) E - Submit for admission: 7.000ms (1.000ms) E - Completed admission: 7.000ms (0.000ns) E - Ready to start on 3 backends: 8.000ms (1.000ms) E - All 3 execution backends (6 fragment instances) started: 10.000ms (2.000ms) E - First dynamic filter received: 526.000ms (516.000ms) E - Rows available: 832.000ms (306.000ms) E - First row fetched: 864.000ms (32.000ms) E - Last row fetched: 864.000ms (0.000ns) E - Released admission control resources: 870.000ms (6.000ms) E - AdmissionControlTimeSinceLastUpdate: 60.000ms E - ComputeScanRangeAssignmentTimer: 0.000ns E - InactiveTotalTime: 0.000ns E - TotalTime: 0.000ns E Frontend: E - InactiveTotalTime: 0.000ns E - TotalTime: 0.000ns E ImpalaServer: E - ClientFetchWaitTimer: 32.000ms E - InactiveTotalTime: 0.000ns E - NumRowsFetched: 19 (19) E - NumRowsFetchedFromCache: 0 (0) E - RowMaterializationRate: 3.17 K/sec E - RowMaterializationTimer: 6.000ms E - TotalTime: 0.000ns E Execution Profile c148078d46befb8c:0df7093a00000000:(Total: 831.000ms, non-child: 0.000ns, % non-child: 0.00%) E Number of filters: 2 E Filter routing table: E ID Src. Node Tgt. Node(s) Target type Partition filter Pending (Expected) First arrived Completed Enabled Bloom Size Est fpp Min value Max value E --------------------------------------------------------------------------------------------------------------------------------------------------------------- E 1 2 0 REMOTE false 2 (2) N/A N/A true MIN_MAX E 0 2 0 REMOTE false 2 (2) N/A N/A true 1.00 MB 1.75e-39 E Backend startup latencies: Count: 3, min / max: 1ms / 1ms, 25th %-ile: 1ms, 50th %-ile: 1ms, 75th %-ile: 1ms, 90th %-ile: 1ms, 95th %-ile: 1ms, 99.9th %-ile: 1ms E Slowest backend to start up: impala-ec2-centos74-m5-4xlarge-ondemand-00ee.vpc.cloudera.com:27000 E Final filter table: E ID Src. Node Tgt. Node(s) Target type Partition filter Pending (Expected) First arrived Completed Enabled Bloom Size Est fpp Min value Max value E --------------------------------------------------------------------------------------------------------------------------------------------------------------- E 1 2 0 REMOTE false 0 (2) 526.000ms 569.000ms true MIN_MAX E 0 2 0 REMOTE false 0 (2) 526.000ms 569.000ms true 1.00 MB 1.75e-39 E Per Node Peak Memory Usage: impala-ec2-centos74-m5-4xlarge-ondemand-00ee.vpc.cloudera.com:27000(5.01 MB) impala-ec2-centos74-m5-4xlarge-ondemand-00ee.vpc.cloudera.com:27001(25.39 MB) impala-ec2-centos74-m5-4xlarge-ondemand-00ee.vpc.cloudera.com:27002(16.77 MB) E Per Node Bytes Read: impala-ec2-centos74-m5-4xlarge-ondemand-00ee.vpc.cloudera.com:27000(0) impala-ec2-centos74-m5-4xlarge-ondemand-00ee.vpc.cloudera.com:27001(8.77 MB) impala-ec2-centos74-m5-4xlarge-ondemand-00ee.vpc.cloudera.com:27002(100.00 KB) E Per Node User Time: impala-ec2-centos74-m5-4xlarge-ondemand-00ee.vpc.cloudera.com:27000(53.146ms) impala-ec2-centos74-m5-4xlarge-ondemand-00ee.vpc.cloudera.com:27001(1s075ms) impala-ec2-centos74-m5-4xlarge-ondemand-00ee.vpc.cloudera.com:27002(671.811ms) E Per Node System Time: impala-ec2-centos74-m5-4xlarge-ondemand-00ee.vpc.cloudera.com:27000(2.943ms) impala-ec2-centos74-m5-4xlarge-ondemand-00ee.vpc.cloudera.com:27001(8.983ms) impala-ec2-centos74-m5-4xlarge-ondemand-00ee.vpc.cloudera.com:27002(4.989ms) E - ExchangeScanRatio: 0.00 E - FiltersReceived: 4 (4) E - FinalizationTimer: 0.000ns E - InactiveTotalTime: 0.000ns E - InnerNodeSelectivityRatio: 0.62 E - NumBackends: 3 (3) E - NumCompletedBackends: 3 (3) E - NumFragmentInstances: 6 (6) E - NumFragments: 4 (4) E - TotalBytesRead: 8.87 MB (9297742) E - TotalBytesSent: 330.00 B (330) E - TotalCpuTime: 1s817ms E - TotalInnerBytesSent: 126.00 B (126) E - TotalScanBytesSent: 204.00 B (204) E - TotalTime: 831.000ms E Per Node Profiles: E - InactiveTotalTime: 0.000ns E - TotalTime: 0.000ns E impala-ec2-centos74-m5-4xlarge-ondemand-00ee.vpc.cloudera.com:27000: E - AdmissionSlots: 1 (1) E - BloomFilterBytes: 0 E - InactiveTotalTime: 0.000ns E - ScratchBytesRead: 0 E - ScratchBytesWritten: 0 E - ScratchFileUsedBytes: 0 E - ScratchReads: 0 (0) E - ScratchWrites: 0 (0) E - TotalEncryptionTime: 0.000ns E - TotalReadBlockTime: 0.000ns E - TotalTime: 0.000ns E - UncompressedScratchBytesWritten: 0 E Buffer pool: E - AllocTime: 0.000ns E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 0 E - CumulativeAllocations: 0 (0) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 0 E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 0 E - ReadIoBytes: 0 E - ReadIoOps: 0 (0) E - ReadIoWaitTime: 0.000ns E - ReservationLimit: 0 E - SystemAllocTime: 0.000ns E - TotalTime: 0.000ns E - WriteIoBytes: 0 E - WriteIoOps: 0 (0) E - WriteIoWaitTime: 0.000ns E JVM: E - GcCount: 0 (0) E - GcNumInfoThresholdExceeded: 0 (0) E - GcNumWarnThresholdExceeded: 0 (0) E - GcTimeMillis: 0 E - GcTotalExtraSleepTimeMillis: 0 E - InactiveTotalTime: 0.000ns E - TotalTime: 0.000ns E Fragment F03: E - InactiveTotalTime: 0.000ns E - TotalTime: 0.000ns E CodeGen:(Total: 58.000ms, non-child: 58.000ms, % non-child: 100.00%) E - CodegenCompileThreadInvoluntaryContextSwitches: 0 (0) E - CodegenCompileThreadTotalWallClockTime: 0.000ns E - CodegenCompileThreadSysTime: 0.000ns E - CodegenCompileThreadUserTime: 0.000ns E - CodegenCompileThreadVoluntaryContextSwitches: 0 (0) E - CodegenInvoluntaryContextSwitches: 5 (5) E - CodegenTotalWallClockTime: 58.000ms E - CodegenSysTime: 2.943ms E - CodegenUserTime: 52.702ms E - CodegenVoluntaryContextSwitches: 2 (2) E - CompileTime: 4.000ms E - InactiveTotalTime: 0.000ns E - IrGenerationTime: 2.000ms E - LoadTime: 0.000ns E - MainThreadCodegenTime: 24.000ms E - ModuleBitcodeSize: 3.23 MB (3387288) E - NumFunctions: 20 (20) E - NumInstructions: 704 (704) E - OptimizationTime: 16.000ms E - PeakMemoryUsage: 352.00 KB (360448) E - PrepareTime: 34.000ms E - TotalTime: 58.000ms E impala-ec2-centos74-m5-4xlarge-ondemand-00ee.vpc.cloudera.com:27001: E Filter 1 arrival: 559ms E Filter 0 arrival: 560ms E - AdmissionSlots: 1 (1) E - BloomFilterBytes: 2.00 MB (2097152) E - InactiveTotalTime: 0.000ns E - ScratchBytesRead: 0 E - ScratchBytesWritten: 0 E - ScratchFileUsedBytes: 0 E - ScratchReads: 0 (0) E - ScratchWrites: 0 (0) E - TotalEncryptionTime: 0.000ns E - TotalReadBlockTime: 0.000ns E - TotalTime: 0.000ns E - UncompressedScratchBytesWritten: 0 E Buffer pool: E - AllocTime: 0.000ns E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 2.00 MB (2097152) E - CumulativeAllocations: 2 (2) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 2.00 MB (2097152) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 2.00 MB (2097152) E - ReadIoBytes: 0 E - ReadIoOps: 0 (0) E - ReadIoWaitTime: 0.000ns E - ReservationLimit: 2.00 MB (2097152) E - SystemAllocTime: 0.000ns E - TotalTime: 0.000ns E - WriteIoBytes: 0 E - WriteIoOps: 0 (0) E - WriteIoWaitTime: 0.000ns E JVM: E - GcCount: 0 (0) E - GcNumInfoThresholdExceeded: 0 (0) E - GcNumWarnThresholdExceeded: 0 (0) E - GcTimeMillis: 0 E - GcTotalExtraSleepTimeMillis: 0 E - InactiveTotalTime: 0.000ns E - TotalTime: 0.000ns E Fragment F02: E - InactiveTotalTime: 0.000ns E - TotalTime: 0.000ns E CodeGen:(Total: 512.000ms, non-child: 512.000ms, % non-child: 100.00%) E - CodegenCompileThreadInvoluntaryContextSwitches: 0 (0) E - CodegenCompileThreadTotalWallClockTime: 0.000ns E - CodegenCompileThreadSysTime: 0.000ns E - CodegenCompileThreadUserTime: 0.000ns E - CodegenCompileThreadVoluntaryContextSwitches: 0 (0) E - CodegenInvoluntaryContextSwitches: 28 (28) E - CodegenTotalWallClockTime: 512.000ms E - CodegenSysTime: 5.977ms E - CodegenUserTime: 499.049ms E - CodegenVoluntaryContextSwitches: 2 (2) E - CompileTime: 29.000ms E - InactiveTotalTime: 0.000ns E - IrGenerationTime: 21.000ms E - LoadTime: 0.000ns E - MainThreadCodegenTime: 477.000ms E - ModuleBitcodeSize: 3.23 MB (3387288) E - NumFunctions: 98 (98) E - NumInstructions: 4.90K (4900) E - OptimizationTime: 425.000ms E - PeakMemoryUsage: 2.39 MB (2508800) E - PrepareTime: 35.000ms E - TotalTime: 512.000ms E Fragment F00: E - InactiveTotalTime: 0.000ns E - TotalTime: 0.000ns E CodeGen:(Total: 164.000ms, non-child: 164.000ms, % non-child: 100.00%) E - CodegenCompileThreadInvoluntaryContextSwitches: 0 (0) E - CodegenCompileThreadTotalWallClockTime: 0.000ns E - CodegenCompileThreadSysTime: 0.000ns E - CodegenCompileThreadUserTime: 0.000ns E - CodegenCompileThreadVoluntaryContextSwitches: 0 (0) E - CodegenInvoluntaryContextSwitches: 12 (12) E - CodegenTotalWallClockTime: 164.000ms E - CodegenSysTime: 0.000ns E - CodegenUserTime: 163.432ms E - CodegenVoluntaryContextSwitches: 0 (0) E - CompileTime: 11.000ms E - InactiveTotalTime: 0.000ns E - IrGenerationTime: 4.000ms E - LoadTime: 0.000ns E - MainThreadCodegenTime: 132.000ms E - ModuleBitcodeSize: 3.23 MB (3387288) E - NumFunctions: 33 (33) E - NumInstructions: 698 (698) E - OptimizationTime: 115.000ms E - PeakMemoryUsage: 349.00 KB (357376) E - PrepareTime: 32.000ms E - TotalTime: 164.000ms E Fragment F01: E - InactiveTotalTime: 0.000ns E - TotalTime: 0.000ns E CodeGen:(Total: 115.000ms, non-child: 115.000ms, % non-child: 100.00%) E - CodegenCompileThreadInvoluntaryContextSwitches: 0 (0) E - CodegenCompileThreadTotalWallClockTime: 0.000ns E - CodegenCompileThreadSysTime: 0.000ns E - CodegenCompileThreadUserTime: 0.000ns E - CodegenCompileThreadVoluntaryContextSwitches: 0 (0) E - CodegenInvoluntaryContextSwitches: 7 (7) E - CodegenTotalWallClockTime: 115.000ms E - CodegenSysTime: 1.995ms E - CodegenUserTime: 104.706ms E - CodegenVoluntaryContextSwitches: 7 (7) E - CompileTime: 8.000ms E - InactiveTotalTime: 0.000ns E - IrGenerationTime: 4.000ms E - LoadTime: 0.000ns E - MainThreadCodegenTime: 82.000ms E - ModuleBitcodeSize: 3.23 MB (3387288) E - NumFunctions: 36 (36) E - NumInstructions: 712 (712) E - OptimizationTime: 68.000ms E - PeakMemoryUsage: 356.00 KB (364544) E - PrepareTime: 33.000ms E - TotalTime: 115.000ms E impala-ec2-centos74-m5-4xlarge-ondemand-00ee.vpc.cloudera.com:27002: E Filter 1 arrival: 559ms E Filter 0 arrival: 560ms E - AdmissionSlots: 1 (1) E - BloomFilterBytes: 2.00 MB (2097152) E - InactiveTotalTime: 0.000ns E - ScratchBytesRead: 0 E - ScratchBytesWritten: 0 E - ScratchFileUsedBytes: 0 E - ScratchReads: 0 (0) E - ScratchWrites: 0 (0) E - TotalEncryptionTime: 0.000ns E - TotalReadBlockTime: 0.000ns E - TotalTime: 0.000ns E - UncompressedScratchBytesWritten: 0 E Buffer pool: E - AllocTime: 0.000ns E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 2.00 MB (2097152) E - CumulativeAllocations: 2 (2) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 2.00 MB (2097152) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 2.00 MB (2097152) E - ReadIoBytes: 0 E - ReadIoOps: 0 (0) E - ReadIoWaitTime: 0.000ns E - ReservationLimit: 2.00 MB (2097152) E - SystemAllocTime: 0.000ns E - TotalTime: 0.000ns E - WriteIoBytes: 0 E - WriteIoOps: 0 (0) E - WriteIoWaitTime: 0.000ns E JVM: E - GcCount: 0 (0) E - GcNumInfoThresholdExceeded: 0 (0) E - GcNumWarnThresholdExceeded: 0 (0) E - GcTimeMillis: 0 E - GcTotalExtraSleepTimeMillis: 0 E - InactiveTotalTime: 0.000ns E - TotalTime: 0.000ns E Fragment F02: E - InactiveTotalTime: 0.000ns E - TotalTime: 0.000ns E CodeGen:(Total: 539.000ms, non-child: 539.000ms, % non-child: 100.00%) E - CodegenCompileThreadInvoluntaryContextSwitches: 0 (0) E - CodegenCompileThreadTotalWallClockTime: 0.000ns E - CodegenCompileThreadSysTime: 0.000ns E - CodegenCompileThreadUserTime: 0.000ns E - CodegenCompileThreadVoluntaryContextSwitches: 0 (0) E - CodegenInvoluntaryContextSwitches: 29 (29) E - CodegenTotalWallClockTime: 539.000ms E - CodegenSysTime: 2.986ms E - CodegenUserTime: 530.859ms E - CodegenVoluntaryContextSwitches: 0 (0) E - CompileTime: 43.000ms E - InactiveTotalTime: 0.000ns E - IrGenerationTime: 25.000ms E - LoadTime: 0.000ns E - MainThreadCodegenTime: 507.000ms E - ModuleBitcodeSize: 3.23 MB (3387288) E - NumFunctions: 98 (98) E - NumInstructions: 4.90K (4900) E - OptimizationTime: 436.000ms E - PeakMemoryUsage: 2.39 MB (2508800) E - PrepareTime: 32.000ms E - TotalTime: 539.000ms E Fragment F00: E - InactiveTotalTime: 0.000ns E - TotalTime: 0.000ns E CodeGen:(Total: 140.000ms, non-child: 140.000ms, % non-child: 100.00%) E - CodegenCompileThreadInvoluntaryContextSwitches: 0 (0) E - CodegenCompileThreadTotalWallClockTime: 0.000ns E - CodegenCompileThreadSysTime: 0.000ns E - CodegenCompileThreadUserTime: 0.000ns E - CodegenCompileThreadVoluntaryContextSwitches: 0 (0) E - CodegenInvoluntaryContextSwitches: 9 (9) E - CodegenTotalWallClockTime: 140.000ms E - CodegenSysTime: 1.995ms E - CodegenUserTime: 137.601ms E - CodegenVoluntaryContextSwitches: 2 (2) E - CompileTime: 9.000ms E - InactiveTotalTime: 0.000ns E - IrGenerationTime: 3.000ms E - LoadTime: 0.000ns E - MainThreadCodegenTime: 112.000ms E - ModuleBitcodeSize: 3.23 MB (3387288) E - NumFunctions: 33 (33) E - NumInstructions: 698 (698) E - OptimizationTime: 99.000ms E - PeakMemoryUsage: 349.00 KB (357376) E - PrepareTime: 28.000ms E - TotalTime: 140.000ms E Averaged Fragment F03:(Total: 858.000ms, non-child: 60.000ms, % non-child: 6.99%) E split sizes: min: 0, max: 0, avg: 0, stddev: 0 E completion times: min:860.000ms max:860.000ms mean: 860.000ms stddev:0.000ns E execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec E num instances: 1 E - AverageThreadTokens: 0.00 E - BytesAssigned: 0 E - CompletionTime: 860.000ms E - ExchangeScanRatio: 0.00 E - ExecutionRate: 0.00 /sec E - InactiveTotalTime: 0.000ns E - PeakMemoryUsage: 4.05 MB (4243456) E - PeakReservation: 4.00 MB (4194304) E - PeakUsedReservation: 0 E - PerHostPeakMemUsage: 5.01 MB (5251455) E - RowsProduced: 19 (19) E - TotalNetworkReceiveTime: 0.000ns E - TotalNetworkSendTime: 0.000ns E - TotalStorageWaitTime: 0.000ns E - TotalThreadsInvoluntaryContextSwitches: 5 (5) E - TotalThreadsTotalWallClockTime: 857.000ms E - TotalThreadsSysTime: 2.943ms E - TotalThreadsUserTime: 53.146ms E - TotalThreadsVoluntaryContextSwitches: 5 (5) E - TotalTime: 858.000ms E Fragment Instance Lifecycle Timings: E - ExecTime: 35.000ms E - ExecTreeExecTime: 0.000ns E - InactiveTotalTime: 0.000ns E - OpenTime: 822.000ms E - ExecTreeOpenTime: 763.000ms E - PrepareTime: 1.000ms E - ExecTreePrepareTime: 1.000ms E - TotalTime: 0.000ns E PLAN_ROOT_SINK:(Total: 35.000ms, non-child: 0.000ns, % non-child: 0.00%) E - InactiveTotalTime: 35.000ms E - PeakMemoryUsage: 4.01 MB (4202496) E - RowBatchGetWaitTime: 0.000ns E - RowBatchSendWaitTime: 0.000ns E - RowsSent: 19 (19) E - RowsSentRate: 542.00 /sec E - TotalTime: 35.000ms E Buffer pool: E - AllocTime: 0.000ns E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 2.00 MB (2097152) E - CumulativeAllocations: 1 (1) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 4.00 MB (4194304) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 2.00 MB (2097152) E - ReadIoBytes: 0 E - ReadIoOps: 0 (0) E - ReadIoWaitTime: 0.000ns E - ReservationLimit: 100.00 MB (104857600) E - SystemAllocTime: 0.000ns E - TotalTime: 0.000ns E - WriteIoBytes: 0 E - WriteIoOps: 0 (0) E - WriteIoWaitTime: 0.000ns E EXCHANGE_NODE (id=6):(Total: 763.000ms, non-child: 0.000ns, % non-child: 0.00%) E - ConvertRowBatchTime: 0.000ns E - InactiveTotalTime: 763.000ms E - MergeGetNext: 0.000ns E - MergeGetNextBatch: 0.000ns E - PeakMemoryUsage: 32.00 KB (32768) E - RowsReturned: 19 (19) E - RowsReturnedRate: 24.00 /sec E - TotalTime: 763.000ms E Buffer pool: E - AllocTime: 0.000ns E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 32.00 KB (32768) E - CumulativeAllocations: 4 (4) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 32.00 KB (32768) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 32.00 KB (32768) E - ReadIoBytes: 0 E - ReadIoOps: 0 (0) E - ReadIoWaitTime: 0.000ns E - SystemAllocTime: 0.000ns E - TotalTime: 0.000ns E - WriteIoBytes: 0 E - WriteIoOps: 0 (0) E - WriteIoWaitTime: 0.000ns E Dequeue: E - FirstBatchWaitTime: 763.000ms E - InactiveTotalTime: 0.000ns E - TotalBytesDequeued: 323.00 B (323) E - TotalGetBatchTime: 763.000ms E - DataWaitTime: 763.000ms E - TotalTime: 0.000ns E Enqueue: E - DispatchTime: (Avg: 69.167us ; Min: 68.820us ; Max: 69.515us ; Number of samples: 2) E - DeserializeRowBatchTime: 0.000ns E - InactiveTotalTime: 0.000ns E - TotalBatchesEnqueued: 2 (2) E - TotalBatchesReceived: 2 (2) E - TotalBytesReceived: 126.00 B (126) E - TotalEarlySenders: 0 (0) E - TotalEosReceived: 2 (2) E - TotalHasDeferredRPCsTime: 0.000ns E - TotalRPCsDeferred: 0 (0) E - TotalTime: 0.000ns E Coordinator Fragment F03: E - InactiveTotalTime: 0.000ns E - TotalTime: 0.000ns E Instance c148078d46befb8c:0df7093a00000000 (host=impala-ec2-centos74-m5-4xlarge-ondemand-00ee.vpc.cloudera.com:27000):(Total: 858.000ms, non-child: 60.000ms, % non-child: 6.99%) E Last report received time: 2021-03-29 23:15:31.438 E Fragment Instance Lifecycle Event Timeline: 858.000ms E - Prepare Finished: 1.000ms (1.000ms) E - Open Finished: 823.000ms (822.000ms) E - First Batch Produced: 823.000ms (0.000ns) E - First Batch Sent: 823.000ms (0.000ns) E - ExecInternal Finished: 858.000ms (35.000ms) E - MemoryUsage (500.000ms): 8.00 KB, 4.02 MB E - AverageThreadTokens: 0.00 E - BytesAssigned: 0 E - CompletionTime: 860.000ms E - ExchangeScanRatio: 0.00 E - ExecutionRate: 0.00 /sec E - InactiveTotalTime: 0.000ns E - PeakMemoryUsage: 4.05 MB (4243456) E - PeakReservation: 4.00 MB (4194304) E - PeakUsedReservation: 0 E - PerHostPeakMemUsage: 5.01 MB (5251455) E - RowsProduced: 19 (19) E - TotalNetworkReceiveTime: 0.000ns E - TotalNetworkSendTime: 0.000ns E - TotalStorageWaitTime: 0.000ns E - TotalThreadsInvoluntaryContextSwitches: 5 (5) E - TotalThreadsTotalWallClockTime: 857.000ms E - TotalThreadsSysTime: 2.943ms E - TotalThreadsUserTime: 53.146ms E - TotalThreadsVoluntaryContextSwitches: 5 (5) E - TotalTime: 858.000ms E Fragment Instance Lifecycle Timings: E - ExecTime: 35.000ms E - ExecTreeExecTime: 0.000ns E - InactiveTotalTime: 0.000ns E - OpenTime: 822.000ms E - ExecTreeOpenTime: 763.000ms E - PrepareTime: 1.000ms E - ExecTreePrepareTime: 1.000ms E - TotalTime: 0.000ns E PLAN_ROOT_SINK:(Total: 35.000ms, non-child: 0.000ns, % non-child: 0.00%) E - InactiveTotalTime: 35.000ms E - PeakMemoryUsage: 4.01 MB (4202496) E - RowBatchGetWaitTime: 0.000ns E - RowBatchSendWaitTime: 0.000ns E - RowsSent: 19 (19) E - RowsSentRate: 542.00 /sec E - TotalTime: 35.000ms E Buffer pool: E - AllocTime: 0.000ns E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 2.00 MB (2097152) E - CumulativeAllocations: 1 (1) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 4.00 MB (4194304) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 2.00 MB (2097152) E - ReadIoBytes: 0 E - ReadIoOps: 0 (0) E - ReadIoWaitTime: 0.000ns E - ReservationLimit: 100.00 MB (104857600) E - SystemAllocTime: 0.000ns E - TotalTime: 0.000ns E - WriteIoBytes: 0 E - WriteIoOps: 0 (0) E - WriteIoWaitTime: 0.000ns E EXCHANGE_NODE (id=6):(Total: 763.000ms, non-child: 0.000ns, % non-child: 0.00%) E ExecOption: Codegen Enabled E Node Lifecycle Event Timeline: 823.000ms E - Open Started: 59.000ms (59.000ms) E - Open Finished: 822.000ms (763.000ms) E - First Batch Requested: 823.000ms (1.000ms) E - First Batch Returned: 823.000ms (0.000ns) E - Last Batch Returned: 823.000ms (0.000ns) E - Closed: 823.000ms (0.000ns) E - ConvertRowBatchTime: 0.000ns E - InactiveTotalTime: 763.000ms E - MergeGetNext: 0.000ns E - MergeGetNextBatch: 0.000ns E - PeakMemoryUsage: 32.00 KB (32768) E - RowsReturned: 19 (19) E - RowsReturnedRate: 24.00 /sec E - TotalTime: 763.000ms E Buffer pool: E - AllocTime: 0.000ns E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 32.00 KB (32768) E - CumulativeAllocations: 4 (4) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 32.00 KB (32768) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 32.00 KB (32768) E - ReadIoBytes: 0 E - ReadIoOps: 0 (0) E - ReadIoWaitTime: 0.000ns E - SystemAllocTime: 0.000ns E - TotalTime: 0.000ns E - WriteIoBytes: 0 E - WriteIoOps: 0 (0) E - WriteIoWaitTime: 0.000ns E Dequeue: E - BytesDequeued (500.000ms): 0 E - FirstBatchWaitTime: 763.000ms E - InactiveTotalTime: 0.000ns E - TotalBytesDequeued: 323.00 B (323) E - TotalGetBatchTime: 763.000ms E - DataWaitTime: 763.000ms E - TotalTime: 0.000ns E Enqueue: E - BytesReceived (500.000ms): 0 E - DeferredQueueSize (500.000ms): 0 E - DispatchTime: (Avg: 69.167us ; Min: 68.820us ; Max: 69.515us ; Number of samples: 2) E - DeserializeRowBatchTime: 0.000ns E - InactiveTotalTime: 0.000ns E - TotalBatchesEnqueued: 2 (2) E - TotalBatchesReceived: 2 (2) E - TotalBytesReceived: 126.00 B (126) E - TotalEarlySenders: 0 (0) E - TotalEosReceived: 2 (2) E - TotalHasDeferredRPCsTime: 0.000ns E - TotalRPCsDeferred: 0 (0) E - TotalTime: 0.000ns E Averaged Fragment F02 [2 instances]:(Total: 813.000ms, non-child: 525.000ms, % non-child: 64.58%) E split sizes: min: 0, max: 0, avg: 0, stddev: 0 E completion times: min:827.000ms max:833.000ms mean: 830.000ms stddev:3.000ms E execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec E num instances: 2 E - AverageThreadTokens: 1.00 E - BytesAssigned: 0 E - CompletionTime: 830.000ms E - ExchangeScanRatio: 0.00 E - ExecutionRate: 0.00 /sec E - InactiveTotalTime: 0.000ns E - PeakMemoryUsage: 8.02 MB (8413664) E - PeakReservation: 7.94 MB (8323072) E - PeakUsedReservation: 0 E - PerHostPeakMemUsage: 21.08 MB (22104971) E - RowsProduced: 9 (9) E - TotalNetworkReceiveTime: 285.500ms E - TotalNetworkSendTime: 1.000ms E - TotalStorageWaitTime: 0.000ns E - TotalThreadsInvoluntaryContextSwitches: 28 (28) E - TotalThreadsTotalWallClockTime: 813.500ms E - TotalThreadsSysTime: 4.489ms E - TotalThreadsUserTime: 517.096ms E - TotalThreadsVoluntaryContextSwitches: 6 (6) E - TotalTime: 813.000ms E Fragment Instance Lifecycle Timings [2 instances]: E - ExecTime: 1.000ms E - ExecTreeExecTime: 0.000ns E - InactiveTotalTime: 0.000ns E - OpenTime: 811.000ms E - ExecTreeOpenTime: 285.500ms E - PrepareTime: 1.000ms E - ExecTreePrepareTime: 500.000us E - TotalTime: 0.000ns E KrpcDataStreamSender (dst_id=6) [2 instances]:(Total: 1.000ms, non-child: 0.000ns, % non-child: 0.00%) E - NetworkThroughput: (Avg: 314.89 KB/sec ; Min: 136.91 KB/sec ; Max: 492.88 KB/sec ; Number of samples: 2) E - RpcNetworkTime: (Avg: 220.122us ; Min: 138.820us ; Max: 392.306us ; Number of samples: 4) E - RpcRecvrTime: (Avg: 77.038us ; Min: 46.960us ; Max: 109.989us ; Number of samples: 4) E - EosSent: 1 (1) E - InactiveTotalTime: 1.000ms E - PeakMemoryUsage: 14.22 KB (14560) E - RowsSent: 9 (9) E - RpcFailure: 0 (0) E - RpcRetry: 0 (0) E - SerializeBatchTime: 0.000ns E - TotalBytesSent: 63.00 B (63) E - TotalTime: 1.000ms E - UncompressedRowBatchSize: 161.00 B (161) E SORT_NODE (id=3) [2 instances]:(Total: 286.000ms, non-child: 0.000ns, % non-child: 0.00%) E - AddBatchTime: (Avg: 0.000ns ; Min: 0.000ns ; Max: 0.000ns ; Number of samples: 4) E - NumRowsPerRun: (Avg: 9 (9) ; Min: 8 (8) ; Max: 11 (11) ; Number of samples: 2) E - InMemorySortTime: 0.000ns E - InactiveTotalTime: 0.000ns E - InitialRunsCreated: 1 (1) E - PeakMemoryUsage: 6.02 MB (6316032) E - RowsReturned: 9 (9) E - RowsReturnedRate: 33.00 /sec E - SortDataSize: 85.00 B (85) E - SpilledRuns: 0 (0) E - TotalMergesPerformed: 0 (0) E - TotalTime: 286.000ms E Buffer pool [2 instances]: E - AllocTime: 0.000ns E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 2.00 MB (2097152) E - CumulativeAllocations: 1 (1) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 6.00 MB (6291456) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 2.00 MB (2097152) E - ReadIoBytes: 0 E - ReadIoOps: 0 (0) E - ReadIoWaitTime: 0.000ns E - SystemAllocTime: 0.000ns E - TotalTime: 0.000ns E - WriteIoBytes: 0 E - WriteIoOps: 0 (0) E - WriteIoWaitTime: 0.000ns E HASH_JOIN_NODE (id=2) [2 instances]:(Total: 286.500ms, non-child: 1.000ms, % non-child: 0.35%) E - InactiveTotalTime: 0.000ns E - PeakMemoryUsage: 1.99 MB (2083072) E - ProbeRows: 9 (9) E - ProbeRowsPartitioned: 0 (0) E - ProbeTime: 0.000ns E - RowsReturned: 9 (9) E - RowsReturnedRate: 33.00 /sec E - TotalTime: 286.500ms E Buffer pool [2 instances]: E - AllocTime: 0.000ns E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 192.00 KB (196608) E - CumulativeAllocations: 3 (3) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 1.94 MB (2031616) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 192.00 KB (196608) E - ReadIoBytes: 0 E - ReadIoOps: 0 (0) E - ReadIoWaitTime: 0.000ns E - SystemAllocTime: 0.000ns E - TotalTime: 0.000ns E - WriteIoBytes: 0 E - WriteIoOps: 0 (0) E - WriteIoWaitTime: 0.000ns E Hash Join Builder (join_node_id=2) [2 instances]:(Total: 1.000ms, non-child: 1.000ms, % non-child: 100.00%) E - BuildRows: 2 (2) E - BuildRowsPartitionTime: 0.000ns E - HashTablesBuildTime: 0.000ns E - InactiveTotalTime: 0.000ns E - LargestPartitionPercent: 50 (50) E - MaxPartitionLevel: 0 (0) E - NumHashTableBuildsSkipped: 0 (0) E - NumRepartitions: 0 (0) E - PartitionsCreated: 16 (16) E - PeakMemoryUsage: 21.12 KB (21632) E - RepartitionTime: 0.000ns E - SpilledPartitions: 0 (0) E - TotalTime: 1.000ms E Hash Table [2 instances]: E - HashBuckets: 2 (2) E - HashCollisions: 0 (0) E - InactiveTotalTime: 0.000ns E - Probes: 11 (11) E - Resizes: 0 (0) E - TotalTime: 0.000ns E - Travel: 0 (0) E EXCHANGE_NODE (id=5) [2 instances]:(Total: 500.000us, non-child: 500.000us, % non-child: 100.00%) E - ConvertRowBatchTime: 500.000us E - InactiveTotalTime: 0.000ns E - PeakMemoryUsage: 16.00 KB (16384) E - RowsReturned: 2 (2) E - RowsReturnedRate: 1.00 K/sec E - TotalTime: 500.000us E Buffer pool [2 instances]: E - AllocTime: 0.000ns E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 16.00 KB (16384) E - CumulativeAllocations: 2 (2) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 16.00 KB (16384) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 16.00 KB (16384) E - ReadIoBytes: 0 E - ReadIoOps: 0 (0) E - ReadIoWaitTime: 0.000ns E - SystemAllocTime: 0.000ns E - TotalTime: 0.000ns E - WriteIoBytes: 0 E - WriteIoOps: 0 (0) E - WriteIoWaitTime: 0.000ns E Dequeue [2 instances]: E - FirstBatchWaitTime: 0.000ns E - InactiveTotalTime: 0.000ns E - TotalBytesDequeued: 50.00 B (50) E - TotalGetBatchTime: 0.000ns E - DataWaitTime: 0.000ns E - TotalTime: 0.000ns E Enqueue [2 instances]: E - DispatchTime: (Avg: 94.264us ; Min: 67.329us ; Max: 121.199us ; Number of samples: 2) E - DeserializeRowBatchTime: 0.000ns E - InactiveTotalTime: 0.000ns E - TotalBatchesEnqueued: 1 (1) E - TotalBatchesReceived: 1 (1) E - TotalBytesReceived: 39.00 B (39) E - TotalEarlySenders: 0 (0) E - TotalEosReceived: 1 (1) E - TotalHasDeferredRPCsTime: 0.000ns E - TotalRPCsDeferred: 0 (0) E - TotalTime: 0.000ns E EXCHANGE_NODE (id=4) [2 instances]:(Total: 285.500ms, non-child: 0.000ns, % non-child: 0.00%) E - ConvertRowBatchTime: 0.000ns E - InactiveTotalTime: 285.500ms E - PeakMemoryUsage: 16.00 KB (16384) E - RowsReturned: 9 (9) E - RowsReturnedRate: 33.00 /sec E - TotalTime: 285.500ms E Buffer pool [2 instances]: E - AllocTime: 0.000ns E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 16.00 KB (16384) E - CumulativeAllocations: 2 (2) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 16.00 KB (16384) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 16.00 KB (16384) E - ReadIoBytes: 0 E - ReadIoOps: 0 (0) E - ReadIoWaitTime: 0.000ns E - SystemAllocTime: 0.000ns E - TotalTime: 0.000ns E - WriteIoBytes: 0 E - WriteIoOps: 0 (0) E - WriteIoWaitTime: 0.000ns E Dequeue [2 instances]: E - FirstBatchWaitTime: 285.500ms E - InactiveTotalTime: 0.000ns E - TotalBytesDequeued: 161.00 B (161) E - TotalGetBatchTime: 285.500ms E - DataWaitTime: 285.500ms E - TotalTime: 0.000ns E Enqueue [2 instances]: E - DispatchTime: (Avg: 78.394us ; Min: 71.997us ; Max: 84.791us ; Number of samples: 2) E - DeserializeRowBatchTime: 0.000ns E - InactiveTotalTime: 0.000ns E - TotalBatchesEnqueued: 1 (1) E - TotalBatchesReceived: 1 (1) E - TotalBytesReceived: 63.00 B (63) E - TotalEarlySenders: 0 (0) E - TotalEosReceived: 2 (2) E - TotalHasDeferredRPCsTime: 0.000ns E - TotalRPCsDeferred: 0 (0) E - TotalTime: 0.000ns E Fragment F02: E - InactiveTotalTime: 0.000ns E - TotalTime: 0.000ns E Instance c148078d46befb8c:0df7093a00000004 (host=impala-ec2-centos74-m5-4xlarge-ondemand-00ee.vpc.cloudera.com:27001):(Total: 821.000ms, non-child: 511.000ms, % non-child: 62.24%) E Last report received time: 2021-03-29 23:15:31.405 E Fragment Instance Lifecycle Event Timeline: 821.000ms E - Prepare Finished: 1.000ms (1.000ms) E - Open Finished: 820.000ms (819.000ms) E - First Batch Produced: 820.000ms (0.000ns) E - First Batch Sent: 820.000ms (0.000ns) E - ExecInternal Finished: 821.000ms (1.000ms) E - MemoryUsage (500.000ms): 80.47 KB E - ThreadUsage (500.000ms): 1 E - AverageThreadTokens: 1.00 E - BytesAssigned: 0 E - CompletionTime: 827.000ms E - ExchangeScanRatio: 0.00 E - ExecutionRate: 0.00 /sec E - InactiveTotalTime: 0.000ns E - PeakMemoryUsage: 8.02 MB (8413664) E - PeakReservation: 7.94 MB (8323072) E - PeakUsedReservation: 0 E - PerHostPeakMemUsage: 25.39 MB (26625910) E - RowsProduced: 8 (8) E - TotalNetworkReceiveTime: 307.000ms E - TotalNetworkSendTime: 1.000ms E - TotalStorageWaitTime: 0.000ns E - TotalThreadsInvoluntaryContextSwitches: 28 (28) E - TotalThreadsTotalWallClockTime: 822.000ms E - TotalThreadsSysTime: 5.989ms E - TotalThreadsUserTime: 501.696ms E - TotalThreadsVoluntaryContextSwitches: 7 (7) E - TotalTime: 821.000ms E Fragment Instance Lifecycle Timings: E - ExecTime: 1.000ms E - ExecTreeExecTime: 0.000ns E - InactiveTotalTime: 0.000ns E - OpenTime: 819.000ms E - ExecTreeOpenTime: 307.000ms E - PrepareTime: 1.000ms E - ExecTreePrepareTime: 1.000ms E - TotalTime: 0.000ns E KrpcDataStreamSender (dst_id=6):(Total: 1.000ms, non-child: 0.000ns, % non-child: 0.00%) E ExecOption: Unpartitioned Sender Codegen Disabled: not needed E - BytesSent (500.000ms): 0 E - NetworkThroughput: (Avg: 136.91 KB/sec ; Min: 136.91 KB/sec ; Max: 136.91 KB/sec ; Number of samples: 1) E - RpcNetworkTime: (Avg: 300.498us ; Min: 208.690us ; Max: 392.306us ; Number of samples: 2) E - RpcRecvrTime: (Avg: 80.642us ; Min: 51.296us ; Max: 109.989us ; Number of samples: 2) E - EosSent: 1 (1) E - InactiveTotalTime: 1.000ms E - PeakMemoryUsage: 14.22 KB (14560) E - RowsSent: 8 (8) E - RpcFailure: 0 (0) E - RpcRetry: 0 (0) E - SerializeBatchTime: 0.000ns E - TotalBytesSent: 55.00 B (55) E - TotalTime: 1.000ms E - UncompressedRowBatchSize: 136.00 B (136) E SORT_NODE (id=3):(Total: 308.000ms, non-child: 0.000ns, % non-child: 0.00%) E SortType: Total E ExecOption: Codegen Enabled E Node Lifecycle Event Timeline: 820.000ms E - Open Started: 513.000ms (513.000ms) E - Open Finished: 820.000ms (307.000ms) E - First Batch Requested: 820.000ms (0.000ns) E - First Batch Returned: 820.000ms (0.000ns) E - Last Batch Returned: 820.000ms (0.000ns) E - Closed: 820.000ms (0.000ns) E - AddBatchTime: (Avg: 0.000ns ; Min: 0.000ns ; Max: 0.000ns ; Number of samples: 2) E - NumRowsPerRun: (Avg: 8 (8) ; Min: 8 (8) ; Max: 8 (8) ; Number of samples: 1) E - InMemorySortTime: 0.000ns E - InactiveTotalTime: 0.000ns E - InitialRunsCreated: 1 (1) E - PeakMemoryUsage: 6.02 MB (6316032) E - RowsReturned: 8 (8) E - RowsReturnedRate: 25.00 /sec E - SortDataSize: 72.00 B (72) E - SpilledRuns: 0 (0) E - TotalMergesPerformed: 0 (0) E - TotalTime: 308.000ms E Buffer pool: E - AllocTime: 0.000ns E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 2.00 MB (2097152) E - CumulativeAllocations: 1 (1) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 6.00 MB (6291456) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 2.00 MB (2097152) E - ReadIoBytes: 0 E - ReadIoOps: 0 (0) E - ReadIoWaitTime: 0.000ns E - SystemAllocTime: 0.000ns E - TotalTime: 0.000ns E - WriteIoBytes: 0 E - WriteIoOps: 0 (0) E - WriteIoWaitTime: 0.000ns E HASH_JOIN_NODE (id=2):(Total: 309.000ms, non-child: 2.000ms, % non-child: 0.65%) E ExecOption: Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously E Node Lifecycle Event Timeline: 820.000ms E - Open Started: 513.000ms (513.000ms) E - Open Finished: 820.000ms (307.000ms) E - First Batch Requested: 820.000ms (0.000ns) E - First Batch Returned: 820.000ms (0.000ns) E - Last Batch Returned: 820.000ms (0.000ns) E - Closed: 820.000ms (0.000ns) E - InactiveTotalTime: 0.000ns E - PeakMemoryUsage: 1.99 MB (2083072) E - ProbeRows: 8 (8) E - ProbeRowsPartitioned: 0 (0) E - ProbeTime: 0.000ns E - RowsReturned: 8 (8) E - RowsReturnedRate: 25.00 /sec E - TotalTime: 309.000ms E Buffer pool: E - AllocTime: 0.000ns E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 192.00 KB (196608) E - CumulativeAllocations: 3 (3) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 1.94 MB (2031616) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 192.00 KB (196608) E - ReadIoBytes: 0 E - ReadIoOps: 0 (0) E - ReadIoWaitTime: 0.000ns E - SystemAllocTime: 0.000ns E - TotalTime: 0.000ns E - WriteIoBytes: 0 E - WriteIoOps: 0 (0) E - WriteIoWaitTime: 0.000ns E Hash Join Builder (join_node_id=2):(Total: 2.000ms, non-child: 2.000ms, % non-child: 100.00%) E ExecOption: Build Side Codegen Enabled, Hash Table Construction Codegen Enabled E Runtime filters: 2 of 2 Runtime Filters Published E - BuildRows: 2 (2) E - BuildRowsPartitionTime: 0.000ns E - HashTablesBuildTime: 0.000ns E - InactiveTotalTime: 0.000ns E - LargestPartitionPercent: 50 (50) E - MaxPartitionLevel: 0 (0) E - NumHashTableBuildsSkipped: 0 (0) E - NumRepartitions: 0 (0) E - PartitionsCreated: 16 (16) E - PeakMemoryUsage: 21.12 KB (21632) E - RepartitionTime: 0.000ns E - SpilledPartitions: 0 (0) E - TotalTime: 2.000ms E Hash Table: E - HashBuckets: 2 (2) E - HashCollisions: 0 (0) E - InactiveTotalTime: 0.000ns E - Probes: 10 (10) E - Resizes: 0 (0) E - TotalTime: 0.000ns E - Travel: 0 (0) E EXCHANGE_NODE (id=5): E Node Lifecycle Event Timeline: 515.000ms E - Open Started: 513.000ms (513.000ms) E - Open Finished: 513.000ms (0.000ns) E - First Batch Requested: 514.000ms (1.000ms) E - First Batch Returned: 514.000ms (0.000ns) E - Last Batch Returned: 514.000ms (0.000ns) E - Closed: 515.000ms (1.000ms) E - ConvertRowBatchTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakMemoryUsage: 16.00 KB (16384) E - RowsReturned: 2 (2) E - RowsReturnedRate: 0 E - TotalTime: 0.000ns E Buffer pool: E - AllocTime: 0.000ns E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 16.00 KB (16384) E - CumulativeAllocations: 2 (2) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 16.00 KB (16384) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 16.00 KB (16384) E - ReadIoBytes: 0 E - ReadIoOps: 0 (0) E - ReadIoWaitTime: 0.000ns E - SystemAllocTime: 0.000ns E - TotalTime: 0.000ns E - WriteIoBytes: 0 E - WriteIoOps: 0 (0) E - WriteIoWaitTime: 0.000ns E Dequeue: E - BytesDequeued (500.000ms): 0 E - FirstBatchWaitTime: 0.000ns E - InactiveTotalTime: 0.000ns E - TotalBytesDequeued: 50.00 B (50) E - TotalGetBatchTime: 0.000ns E - DataWaitTime: 0.000ns E - TotalTime: 0.000ns E Enqueue: E - BytesReceived (500.000ms): 39.00 B E - DeferredQueueSize (500.000ms): 0 E - DispatchTime: (Avg: 121.199us ; Min: 121.199us ; Max: 121.199us ; Number of samples: 1) E - DeserializeRowBatchTime: 0.000ns E - InactiveTotalTime: 0.000ns E - TotalBatchesEnqueued: 1 (1) E - TotalBatchesReceived: 1 (1) E - TotalBytesReceived: 39.00 B (39) E - TotalEarlySenders: 0 (0) E - TotalEosReceived: 1 (1) E - TotalHasDeferredRPCsTime: 0.000ns E - TotalRPCsDeferred: 0 (0) E - TotalTime: 0.000ns E EXCHANGE_NODE (id=4):(Total: 307.000ms, non-child: 0.000ns, % non-child: 0.00%) E Node Lifecycle Event Timeline: 820.000ms E - Open Started: 513.000ms (513.000ms) E - Open Finished: 820.000ms (307.000ms) E - First Batch Requested: 820.000ms (0.000ns) E - First Batch Returned: 820.000ms (0.000ns) E - Last Batch Returned: 820.000ms (0.000ns) E - Closed: 820.000ms (0.000ns) E - ConvertRowBatchTime: 0.000ns E - InactiveTotalTime: 307.000ms E - PeakMemoryUsage: 16.00 KB (16384) E - RowsReturned: 8 (8) E - RowsReturnedRate: 26.00 /sec E - TotalTime: 307.000ms E Buffer pool: E - AllocTime: 0.000ns E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 16.00 KB (16384) E - CumulativeAllocations: 2 (2) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 16.00 KB (16384) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 16.00 KB (16384) E - ReadIoBytes: 0 E - ReadIoOps: 0 (0) E - ReadIoWaitTime: 0.000ns E - SystemAllocTime: 0.000ns E - TotalTime: 0.000ns E - WriteIoBytes: 0 E - WriteIoOps: 0 (0) E - WriteIoWaitTime: 0.000ns E Dequeue: E - BytesDequeued (500.000ms): 0 E - FirstBatchWaitTime: 307.000ms E - InactiveTotalTime: 0.000ns E - TotalBytesDequeued: 136.00 B (136) E - TotalGetBatchTime: 307.000ms E - DataWaitTime: 307.000ms E - TotalTime: 0.000ns E Enqueue: E - BytesReceived (500.000ms): 0 E - DeferredQueueSize (500.000ms): 0 E - DispatchTime: (Avg: 71.997us ; Min: 71.997us ; Max: 71.997us ; Number of samples: 1) E - DeserializeRowBatchTime: 0.000ns E - InactiveTotalTime: 0.000ns E - TotalBatchesEnqueued: 1 (1) E - TotalBatchesReceived: 1 (1) E - TotalBytesReceived: 55.00 B (55) E - TotalEarlySenders: 0 (0) E - TotalEosReceived: 2 (2) E - TotalHasDeferredRPCsTime: 0.000ns E - TotalRPCsDeferred: 0 (0) E - TotalTime: 0.000ns E Instance c148078d46befb8c:0df7093a00000005 (host=impala-ec2-centos74-m5-4xlarge-ondemand-00ee.vpc.cloudera.com:27002):(Total: 805.000ms, non-child: 539.000ms, % non-child: 66.96%) E Last report received time: 2021-03-29 23:15:31.412 E Fragment Instance Lifecycle Event Timeline: 821.000ms E - Prepare Finished: 17.000ms (17.000ms) E - Open Finished: 820.000ms (803.000ms) E - First Batch Produced: 820.000ms (0.000ns) E - First Batch Sent: 820.000ms (0.000ns) E - ExecInternal Finished: 821.000ms (1.000ms) E - MemoryUsage (500.000ms): 80.47 KB E - ThreadUsage (500.000ms): 1 E - AverageThreadTokens: 1.00 E - BytesAssigned: 0 E - CompletionTime: 833.000ms E - ExchangeScanRatio: 0.00 E - ExecutionRate: 0.00 /sec E - InactiveTotalTime: 0.000ns E - PeakMemoryUsage: 8.02 MB (8413664) E - PeakReservation: 7.94 MB (8323072) E - PeakUsedReservation: 0 E - PerHostPeakMemUsage: 16.77 MB (17584032) E - RowsProduced: 11 (11) E - TotalNetworkReceiveTime: 264.000ms E - TotalNetworkSendTime: 1.000ms E - TotalStorageWaitTime: 0.000ns E - TotalThreadsInvoluntaryContextSwitches: 29 (29) E - TotalThreadsTotalWallClockTime: 805.000ms E - TotalThreadsSysTime: 2.990ms E - TotalThreadsUserTime: 532.496ms E - TotalThreadsVoluntaryContextSwitches: 5 (5) E - TotalTime: 805.000ms E Fragment Instance Lifecycle Timings: E - ExecTime: 1.000ms E - ExecTreeExecTime: 0.000ns E - InactiveTotalTime: 0.000ns E - OpenTime: 803.000ms E - ExecTreeOpenTime: 264.000ms E - PrepareTime: 1.000ms E - ExecTreePrepareTime: 0.000ns E - TotalTime: 0.000ns E KrpcDataStreamSender (dst_id=6):(Total: 1.000ms, non-child: 0.000ns, % non-child: 0.00%) E ExecOption: Unpartitioned Sender Codegen Disabled: not needed E - BytesSent (500.000ms): 0 E - NetworkThroughput: (Avg: 492.88 KB/sec ; Min: 492.88 KB/sec ; Max: 492.88 KB/sec ; Number of samples: 1) E - RpcNetworkTime: (Avg: 139.747us ; Min: 138.820us ; Max: 140.675us ; Number of samples: 2) E - RpcRecvrTime: (Avg: 73.433us ; Min: 46.960us ; Max: 99.907us ; Number of samples: 2) E - EosSent: 1 (1) E - InactiveTotalTime: 1.000ms E - PeakMemoryUsage: 14.22 KB (14560) E - RowsSent: 11 (11) E - RpcFailure: 0 (0) E - RpcRetry: 0 (0) E - SerializeBatchTime: 0.000ns E - TotalBytesSent: 71.00 B (71) E - TotalTime: 1.000ms E - UncompressedRowBatchSize: 187.00 B (187) E SORT_NODE (id=3):(Total: 264.000ms, non-child: 0.000ns, % non-child: 0.00%) E SortType: Total E ExecOption: Codegen Enabled E Node Lifecycle Event Timeline: 820.000ms E - Open Started: 556.000ms (556.000ms) E - Open Finished: 820.000ms (264.000ms) E - First Batch Requested: 820.000ms (0.000ns) E - First Batch Returned: 820.000ms (0.000ns) E - Last Batch Returned: 820.000ms (0.000ns) E - Closed: 820.000ms (0.000ns) E - AddBatchTime: (Avg: 0.000ns ; Min: 0.000ns ; Max: 0.000ns ; Number of samples: 2) E - NumRowsPerRun: (Avg: 11 (11) ; Min: 11 (11) ; Max: 11 (11) ; Number of samples: 1) E - InMemorySortTime: 0.000ns E - InactiveTotalTime: 0.000ns E - InitialRunsCreated: 1 (1) E - PeakMemoryUsage: 6.02 MB (6316032) E - RowsReturned: 11 (11) E - RowsReturnedRate: 41.00 /sec E - SortDataSize: 99.00 B (99) E - SpilledRuns: 0 (0) E - TotalMergesPerformed: 0 (0) E - TotalTime: 264.000ms E Buffer pool: E - AllocTime: 0.000ns E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 2.00 MB (2097152) E - CumulativeAllocations: 1 (1) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 6.00 MB (6291456) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 2.00 MB (2097152) E - ReadIoBytes: 0 E - ReadIoOps: 0 (0) E - ReadIoWaitTime: 0.000ns E - SystemAllocTime: 0.000ns E - TotalTime: 0.000ns E - WriteIoBytes: 0 E - WriteIoOps: 0 (0) E - WriteIoWaitTime: 0.000ns E HASH_JOIN_NODE (id=2):(Total: 264.000ms, non-child: 0.000ns, % non-child: 0.00%) E ExecOption: Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously E Node Lifecycle Event Timeline: 820.000ms E - Open Started: 556.000ms (556.000ms) E - Open Finished: 820.000ms (264.000ms) E - First Batch Requested: 820.000ms (0.000ns) E - First Batch Returned: 820.000ms (0.000ns) E - Last Batch Returned: 820.000ms (0.000ns) E - Closed: 820.000ms (0.000ns) E - InactiveTotalTime: 0.000ns E - PeakMemoryUsage: 1.99 MB (2083072) E - ProbeRows: 11 (11) E - ProbeRowsPartitioned: 0 (0) E - ProbeTime: 0.000ns E - RowsReturned: 11 (11) E - RowsReturnedRate: 41.00 /sec E - TotalTime: 264.000ms E Buffer pool: E - AllocTime: 0.000ns E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 192.00 KB (196608) E - CumulativeAllocations: 3 (3) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 1.94 MB (2031616) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 192.00 KB (196608) E - ReadIoBytes: 0 E - ReadIoOps: 0 (0) E - ReadIoWaitTime: 0.000ns E - SystemAllocTime: 0.000ns E - TotalTime: 0.000ns E - WriteIoBytes: 0 E - WriteIoOps: 0 (0) E - WriteIoWaitTime: 0.000ns E Hash Join Builder (join_node_id=2): E ExecOption: Build Side Codegen Enabled, Hash Table Construction Codegen Enabled E Runtime filters: 2 of 2 Runtime Filters Published E - BuildRows: 2 (2) E - BuildRowsPartitionTime: 0.000ns E - HashTablesBuildTime: 0.000ns E - InactiveTotalTime: 0.000ns E - LargestPartitionPercent: 50 (50) E - MaxPartitionLevel: 0 (0) E - NumHashTableBuildsSkipped: 0 (0) E - NumRepartitions: 0 (0) E - PartitionsCreated: 16 (16) E - PeakMemoryUsage: 21.12 KB (21632) E - RepartitionTime: 0.000ns E - SpilledPartitions: 0 (0) E - TotalTime: 0.000ns E Hash Table: E - HashBuckets: 2 (2) E - HashCollisions: 0 (0) E - InactiveTotalTime: 0.000ns E - Probes: 13 (13) E - Resizes: 0 (0) E - TotalTime: 0.000ns E - Travel: 0 (0) E EXCHANGE_NODE (id=5):(Total: 1.000ms, non-child: 1.000ms, % non-child: 100.00%) E Node Lifecycle Event Timeline: 557.000ms E - Open Started: 556.000ms (556.000ms) E - Open Finished: 556.000ms (0.000ns) E - First Batch Requested: 556.000ms (0.000ns) E - First Batch Returned: 557.000ms (1.000ms) E - Last Batch Returned: 557.000ms (0.000ns) E - Closed: 557.000ms (0.000ns) E - ConvertRowBatchTime: 1.000ms E - InactiveTotalTime: 0.000ns E - PeakMemoryUsage: 16.00 KB (16384) E - RowsReturned: 2 (2) E - RowsReturnedRate: 2.00 K/sec E - TotalTime: 1.000ms E Buffer pool: E - AllocTime: 0.000ns E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 16.00 KB (16384) E - CumulativeAllocations: 2 (2) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 16.00 KB (16384) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 16.00 KB (16384) E - ReadIoBytes: 0 E - ReadIoOps: 0 (0) E - ReadIoWaitTime: 0.000ns E - SystemAllocTime: 0.000ns E - TotalTime: 0.000ns E - WriteIoBytes: 0 E - WriteIoOps: 0 (0) E - WriteIoWaitTime: 0.000ns E Dequeue: E - BytesDequeued (500.000ms): 0 E - FirstBatchWaitTime: 0.000ns E - InactiveTotalTime: 0.000ns E - TotalBytesDequeued: 50.00 B (50) E - TotalGetBatchTime: 0.000ns E - DataWaitTime: 0.000ns E - TotalTime: 0.000ns E Enqueue: E - BytesReceived (500.000ms): 39.00 B E - DeferredQueueSize (500.000ms): 0 E - DispatchTime: (Avg: 67.329us ; Min: 67.329us ; Max: 67.329us ; Number of samples: 1) E - DeserializeRowBatchTime: 0.000ns E - InactiveTotalTime: 0.000ns E - TotalBatchesEnqueued: 1 (1) E - TotalBatchesReceived: 1 (1) E - TotalBytesReceived: 39.00 B (39) E - TotalEarlySenders: 0 (0) E - TotalEosReceived: 1 (1) E - TotalHasDeferredRPCsTime: 0.000ns E - TotalRPCsDeferred: 0 (0) E - TotalTime: 0.000ns E EXCHANGE_NODE (id=4):(Total: 264.000ms, non-child: 0.000ns, % non-child: 0.00%) E Node Lifecycle Event Timeline: 820.000ms E - Open Started: 556.000ms (556.000ms) E - Open Finished: 820.000ms (264.000ms) E - First Batch Requested: 820.000ms (0.000ns) E - First Batch Returned: 820.000ms (0.000ns) E - Last Batch Returned: 820.000ms (0.000ns) E - Closed: 820.000ms (0.000ns) E - ConvertRowBatchTime: 0.000ns E - InactiveTotalTime: 264.000ms E - PeakMemoryUsage: 16.00 KB (16384) E - RowsReturned: 11 (11) E - RowsReturnedRate: 41.00 /sec E - TotalTime: 264.000ms E Buffer pool: E - AllocTime: 0.000ns E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 16.00 KB (16384) E - CumulativeAllocations: 2 (2) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 16.00 KB (16384) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 16.00 KB (16384) E - ReadIoBytes: 0 E - ReadIoOps: 0 (0) E - ReadIoWaitTime: 0.000ns E - SystemAllocTime: 0.000ns E - TotalTime: 0.000ns E - WriteIoBytes: 0 E - WriteIoOps: 0 (0) E - WriteIoWaitTime: 0.000ns E Dequeue: E - BytesDequeued (500.000ms): 0 E - FirstBatchWaitTime: 264.000ms E - InactiveTotalTime: 0.000ns E - TotalBytesDequeued: 187.00 B (187) E - TotalGetBatchTime: 264.000ms E - DataWaitTime: 264.000ms E - TotalTime: 0.000ns E Enqueue: E - BytesReceived (500.000ms): 0 E - DeferredQueueSize (500.000ms): 0 E - DispatchTime: (Avg: 84.791us ; Min: 84.791us ; Max: 84.791us ; Number of samples: 1) E - DeserializeRowBatchTime: 0.000ns E - InactiveTotalTime: 0.000ns E - TotalBatchesEnqueued: 1 (1) E - TotalBatchesReceived: 1 (1) E - TotalBytesReceived: 71.00 B (71) E - TotalEarlySenders: 0 (0) E - TotalEosReceived: 2 (2) E - TotalHasDeferredRPCsTime: 0.000ns E - TotalRPCsDeferred: 0 (0) E - TotalTime: 0.000ns E Averaged Fragment F00 [2 instances]:(Total: 689.500ms, non-child: 152.000ms, % non-child: 22.04%) E split sizes: min: 4.32 MB, max: 4.94 MB, avg: 4.63 MB, stddev: 321.17 KB E completion times: min:826.000ms max:833.000ms mean: 829.500ms stddev:3.500ms E execution rates: min:5.18 MB/sec max:5.99 MB/sec mean:5.58 MB/sec stddev:411.32 KB/sec E num instances: 2 E - AverageThreadTokens: 2.00 E - BytesAssigned: 4.63 MB (4856128) E - CompletionTime: 829.500ms E - ExchangeScanRatio: 0.00 E - ExecutionRate: 5.58 MB/sec E - InactiveTotalTime: 0.000ns E - PeakMemoryUsage: 6.36 MB (6665152) E - PeakReservation: 6.00 MB (6291456) E - PeakUsedReservation: 0 E - PerHostPeakMemUsage: 21.08 MB (22104971) E - RowsProduced: 9 (9) E - TotalNetworkReceiveTime: 0.000ns E - TotalNetworkSendTime: 1.000ms E - TotalStorageWaitTime: 3.500ms E - TotalThreadsInvoluntaryContextSwitches: 11 (11) E - TotalThreadsTotalWallClockTime: 1s082ms E - TotalThreadsSysTime: 1.499ms E - TotalThreadsUserTime: 278.902ms E - TotalThreadsVoluntaryContextSwitches: 24 (24) E - TotalTime: 689.500ms E Fragment Instance Lifecycle Timings [2 instances]: E - ExecTime: 537.000ms E - ExecTreeExecTime: 536.000ms E - InactiveTotalTime: 0.000ns E - OpenTime: 152.500ms E - ExecTreeOpenTime: 500.000us E - PrepareTime: 0.000ns E - ExecTreePrepareTime: 0.000ns E - TotalTime: 0.000ns E KrpcDataStreamSender (dst_id=4) [2 instances]:(Total: 1.000ms, non-child: 0.000ns, % non-child: 0.00%) E - NetworkThroughput: (Avg: 361.61 KB/sec ; Min: 304.93 KB/sec ; Max: 418.28 KB/sec ; Number of samples: 2) E - RpcNetworkTime: (Avg: 317.950us ; Min: 114.354us ; Max: 677.011us ; Number of samples: 6) E - RpcRecvrTime: (Avg: 78.760us ; Min: 51.701us ; Max: 128.400us ; Number of samples: 6) E - EosSent: 2 (2) E - InactiveTotalTime: 1.000ms E - PeakMemoryUsage: 32.44 KB (33216) E - RowsSent: 9 (9) E - RpcFailure: 0 (0) E - RpcRetry: 0 (0) E - SerializeBatchTime: 0.000ns E - TotalBytesSent: 63.00 B (63) E - TotalTime: 1.000ms E - UncompressedRowBatchSize: 161.00 B (161) E HDFS_SCAN_NODE (id=0) [2 instances]:(Total: 536.500ms, non-child: 536.500ms, % non-child: 100.00%) E - FooterProcessingTime: (Avg: 2.000ms ; Min: 2.000ms ; Max: 2.000ms ; Number of samples: 2) E - InitialRangeActualReservation: (Avg: 4.00 MB (4194304) ; Min: 4.00 MB (4194304) ; Max: 4.00 MB (4194304) ; Number of samples: 2) E - InitialRangeIdealReservation: (Avg: 128.00 KB (131072) ; Min: 128.00 KB (131072) ; Max: 128.00 KB (131072) ; Number of samples: 2) E - PageIndexProcessingTime: 0.000ns (Number of samples: 0) E - ParquetCompressedBytesReadPerColumn: (Avg: 4.77 MB (5003210) ; Min: 4.77 MB (5003210) ; Max: 4.77 MB (5003210) ; Number of samples: 1) E - ParquetCompressedPageSize: (Avg: 12.86 KB (13166) ; Min: 2.07 KB (2117) ; Max: 44.01 KB (45063) ; Number of samples: 380) E - ParquetRowGroupActualReservation: (Avg: 8.00 MB (8388608) ; Min: 8.00 MB (8388608) ; Max: 8.00 MB (8388608) ; Number of samples: 1) E - ParquetRowGroupIdealReservation: (Avg: 8.00 MB (8388608) ; Min: 8.00 MB (8388608) ; Max: 8.00 MB (8388608) ; Number of samples: 1) E - ParquetUncompressedBytesReadPerColumn: (Avg: 23.55 MB (24690455) ; Min: 23.55 MB (24690455) ; Max: 23.55 MB (24690455) ; Number of samples: 1) E - ParquetUncompressedPageSize: (Avg: 63.45 KB (64974) ; Min: 10.26 KB (10503) ; Max: 64.01 KB (65544) ; Number of samples: 380) E - AverageHdfsReadThreadConcurrency: 0.00 E - AverageScannerThreadConcurrency: 1.00 E - BytesRead: 2.56 MB (2688141) E - BytesReadDataNodeCache: 0 E - BytesReadLocal: 2.57 MB (2694902) E - BytesReadRemoteUnexpected: 0 E - BytesReadShortCircuit: 2.57 MB (2694902) E - CachedFileHandlesHitCount: 0 (0) E - CachedFileHandlesMissCount: 1 (1) E - CollectionItemsRead: 0 (0) E - DataCacheHitBytes: 0 E - DataCacheHitCount: 0 (0) E - DataCacheMissBytes: 0 E - DataCacheMissCount: 0 (0) E - DataCachePartialHitCount: 0 (0) E - DecompressionTime: 6.000ms E - InactiveTotalTime: 0.000ns E - MaterializeTupleTime: 117.000ms E - MaxCompressedTextFileLength: 0 E - NumColumns: 1 (1) E - NumDictFilteredRowGroups: 0 (0) E - NumDisksAccessed: 1 (1) E - NumPages: 190 (190) E - NumRowGroups: 1 (1) E - NumRowGroupsWithPageIndex: 1 (1) E - NumRuntimeFilteredPages: 0 (0) E - NumRuntimeFilteredRowGroups: 0 (0) E - NumScannerThreadMemUnavailable: 0 (0) E - NumScannerThreadReservationsDenied: 0 (0) E - NumScannerThreadsStarted: 1 (1) E - NumScannersWithNoReads: 0 (0) E - NumStatsFilteredPages: 0 (0) E - NumStatsFilteredRowGroups: 0 (0) E - PeakMemoryUsage: 6.32 MB (6627840) E - PeakScannerThreadConcurrency: 1 (1) E - PerReadThreadRawHdfsThroughput: 677.52 MB/sec E - RemoteScanRanges: 0 (0) E - RowBatchBytesEnqueued: 6.50 KB (6656) E - RowBatchQueueGetWaitTime: 131.000ms E - RowBatchQueuePeakMemoryUsage: 20.50 KB (20992) E - RowBatchQueuePutWaitTime: 0.000ns E - RowBatchesEnqueued: 2 (2) E - RowsRead: 1.60M (1604666) E - RowsReturned: 9 (9) E - RowsReturnedRate: 14.00 /sec E - ScanRangesComplete: 1 (1) E - ScannerIoWaitTime: 3.500ms E - ScannerThreadWorklessLoops: 12 (12) E - ScannerThreadsInvoluntaryContextSwitches: 0 (0) E - ScannerThreadsTotalWallClockTime: 393.000ms E - ScannerThreadsSysTime: 499.500us E - ScannerThreadsUserTime: 127.186ms E - ScannerThreadsVoluntaryContextSwitches: 16 (16) E - TotalRawHdfsOpenFileTime: 1.000ms E - TotalRawHdfsReadTime: 2.500ms E - TotalReadThroughput: 0.00 /sec E - TotalTime: 536.500ms E Buffer pool [2 instances]: E - AllocTime: 0.000ns E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 4.12 MB (4325376) E - CumulativeAllocations: 1 (1) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 6.00 MB (6291456) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 4.06 MB (4259840) E - ReadIoBytes: 0 E - ReadIoOps: 0 (0) E - ReadIoWaitTime: 0.000ns E - SystemAllocTime: 0.000ns E - TotalTime: 0.000ns E - WriteIoBytes: 0 E - WriteIoOps: 0 (0) E - WriteIoWaitTime: 0.000ns E Filter 1 (0) [2 instances]: E - Files processed: 0 (0) E - Files rejected: 0 (0) E - Files total: 0 (0) E - InactiveTotalTime: 0.000ns E - RowGroups processed: 1 (1) E - RowGroups rejected: 0 (0) E - RowGroups total: 1 (1) E - Rows processed: 0 (0) E - Rows rejected: 0 (0) E - Rows total: 1.60M (1604666) E - Splits processed: 0 (0) E - Splits rejected: 0 (0) E - Splits total: 0 (0) E - TotalTime: 0.000ns E Filter 0 (1.00 MB) [2 instances]: E - Files processed: 0 (0) E - Files rejected: 0 (0) E - Files total: 0 (0) E - InactiveTotalTime: 0.000ns E - RowGroups processed: 0 (0) E - RowGroups rejected: 0 (0) E - RowGroups total: 0 (0) E - Rows processed: 1.60M (1604666) E - Rows rejected: 1.60M (1604656) E - Rows total: 1.60M (1604666) E - Splits processed: 0 (0) E - Splits rejected: 0 (0) E - Splits total: 0 (0) E - TotalTime: 0.000ns E Fragment F00: E - InactiveTotalTime: 0.000ns E - TotalTime: 0.000ns E Instance c148078d46befb8c:0df7093a00000001 (host=impala-ec2-centos74-m5-4xlarge-ondemand-00ee.vpc.cloudera.com:27001):(Total: 818.000ms, non-child: 164.000ms, % non-child: 20.05%) E Last report received time: 2021-03-29 23:15:31.405 E Hdfs split stats (:<# splits>/): -1:1/4.94 MB E Fragment Instance Lifecycle Event Timeline: 820.000ms E - Prepare Finished: 2.000ms (2.000ms) E - Open Finished: 166.000ms (164.000ms) E - First Batch Produced: 819.000ms (653.000ms) E - First Batch Sent: 819.000ms (0.000ns) E - ExecInternal Finished: 820.000ms (1.000ms) E - MemoryUsage (500.000ms): 4.04 MB E - ThreadUsage (500.000ms): 2 E - AverageThreadTokens: 2.00 E - BytesAssigned: 4.94 MB (5185009) E - CompletionTime: 826.000ms E - ExchangeScanRatio: 0.00 E - ExecutionRate: 5.99 MB/sec E - InactiveTotalTime: 0.000ns E - PeakMemoryUsage: 8.66 MB (9078208) E - PeakReservation: 8.00 MB (8388608) E - PeakUsedReservation: 0 E - PerHostPeakMemUsage: 25.39 MB (26625910) E - RowsProduced: 19 (19) E - TotalNetworkReceiveTime: 0.000ns E - TotalNetworkSendTime: 1.000ms E - TotalStorageWaitTime: 5.000ms E - TotalThreadsInvoluntaryContextSwitches: 13 (13) E - TotalThreadsTotalWallClockTime: 1s395ms E - TotalThreadsSysTime: 999.000us E - TotalThreadsUserTime: 418.490ms E - TotalThreadsVoluntaryContextSwitches: 28 (28) E - TotalTime: 818.000ms E Fragment Instance Lifecycle Timings: E - ExecTime: 654.000ms E - ExecTreeExecTime: 653.000ms E - InactiveTotalTime: 0.000ns E - OpenTime: 164.000ms E - ExecTreeOpenTime: 0.000ns E - PrepareTime: 0.000ns E - ExecTreePrepareTime: 0.000ns E - TotalTime: 0.000ns E KrpcDataStreamSender (dst_id=4):(Total: 1.000ms, non-child: 0.000ns, % non-child: 0.00%) E ExecOption: Hash Partitioned Sender Codegen Enabled E - BytesSent (500.000ms): 0 E - NetworkThroughput: (Avg: 361.61 KB/sec ; Min: 304.93 KB/sec ; Max: 418.28 KB/sec ; Number of samples: 2) E - RpcNetworkTime: (Avg: 266.314us ; Min: 114.354us ; Max: 608.999us ; Number of samples: 4) E - RpcRecvrTime: (Avg: 85.161us ; Min: 51.701us ; Max: 128.400us ; Number of samples: 4) E - EosSent: 2 (2) E - InactiveTotalTime: 1.000ms E - PeakMemoryUsage: 36.44 KB (37312) E - RowsSent: 19 (19) E - RpcFailure: 0 (0) E - RpcRetry: 0 (0) E - SerializeBatchTime: 0.000ns E - TotalBytesSent: 126.00 B (126) E - TotalTime: 1.000ms E - UncompressedRowBatchSize: 323.00 B (323) E HDFS_SCAN_NODE (id=0):(Total: 653.000ms, non-child: 653.000ms, % non-child: 100.00%) E Table Name: tpch_parquet.lineitem_orderkey_only E Hdfs split stats (:<# splits>/): -1:1/4.94 MB E ExecOption: PARQUET Codegen Enabled, Codegen enabled: 1 out of 1 E Runtime filters: All filters arrived. Waited 393ms. Maximum arrival delay: 560ms. E Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% E File Formats: PARQUET/SNAPPY:1 E Node Lifecycle Event Timeline: 819.000ms E - Open Started: 166.000ms (166.000ms) E - Open Finished: 166.000ms (0.000ns) E - First Batch Requested: 166.000ms (0.000ns) E - First Batch Returned: 819.000ms (653.000ms) E - Last Batch Returned: 819.000ms (0.000ns) E - Closed: 819.000ms (0.000ns) E - BytesReadSeries (500.000ms): 0 E - FooterProcessingTime: (Avg: 2.000ms ; Min: 2.000ms ; Max: 2.000ms ; Number of samples: 1) E - InitialRangeActualReservation: (Avg: 4.00 MB (4194304) ; Min: 4.00 MB (4194304) ; Max: 4.00 MB (4194304) ; Number of samples: 1) E - InitialRangeIdealReservation: (Avg: 128.00 KB (131072) ; Min: 128.00 KB (131072) ; Max: 128.00 KB (131072) ; Number of samples: 1) E - PageIndexProcessingTime: 0.000ns (Number of samples: 0) E - ParquetCompressedBytesReadPerColumn: (Avg: 4.77 MB (5003210) ; Min: 4.77 MB (5003210) ; Max: 4.77 MB (5003210) ; Number of samples: 1) E - ParquetCompressedPageSize: (Avg: 12.86 KB (13166) ; Min: 2.07 KB (2117) ; Max: 44.01 KB (45063) ; Number of samples: 380) E - ParquetRowGroupActualReservation: (Avg: 8.00 MB (8388608) ; Min: 8.00 MB (8388608) ; Max: 8.00 MB (8388608) ; Number of samples: 1) E - ParquetRowGroupIdealReservation: (Avg: 8.00 MB (8388608) ; Min: 8.00 MB (8388608) ; Max: 8.00 MB (8388608) ; Number of samples: 1) E - ParquetUncompressedBytesReadPerColumn: (Avg: 23.55 MB (24690455) ; Min: 23.55 MB (24690455) ; Max: 23.55 MB (24690455) ; Number of samples: 1) E - ParquetUncompressedPageSize: (Avg: 63.45 KB (64974) ; Min: 10.26 KB (10503) ; Max: 64.01 KB (65544) ; Number of samples: 380) E - AverageHdfsReadThreadConcurrency: 0.00 E - AverageScannerThreadConcurrency: 1.00 E - BytesRead: 5.03 MB (5273882) E - BytesReadDataNodeCache: 0 E - BytesReadLocal: 5.04 MB (5287405) E - BytesReadRemoteUnexpected: 0 E - BytesReadShortCircuit: 5.04 MB (5287405) E - CachedFileHandlesHitCount: 1 (1) E - CachedFileHandlesMissCount: 1 (1) E - CollectionItemsRead: 0 (0) E - DataCacheHitBytes: 0 E - DataCacheHitCount: 0 (0) E - DataCacheMissBytes: 0 E - DataCacheMissCount: 0 (0) E - DataCachePartialHitCount: 0 (0) E - DecompressionTime: 12.000ms E - InactiveTotalTime: 0.000ns E - MaterializeTupleTime: 234.000ms E - MaxCompressedTextFileLength: 0 E - NumColumns: 1 (1) E - NumDictFilteredRowGroups: 0 (0) E - NumDisksAccessed: 1 (1) E - NumPages: 380 (380) E - NumRowGroups: 1 (1) E - NumRowGroupsWithPageIndex: 1 (1) E - NumRuntimeFilteredPages: 0 (0) E - NumRuntimeFilteredRowGroups: 0 (0) E - NumScannerThreadMemUnavailable: 0 (0) E - NumScannerThreadReservationsDenied: 0 (0) E - NumScannerThreadsStarted: 1 (1) E - NumScannersWithNoReads: 0 (0) E - NumStatsFilteredPages: 0 (0) E - NumStatsFilteredRowGroups: 0 (0) E - PeakMemoryUsage: 8.62 MB (9040896) E - PeakScannerThreadConcurrency: 1 (1) E - PerReadThreadRawHdfsThroughput: 1.23 GB/sec E - RemoteScanRanges: 0 (0) E - RowBatchBytesEnqueued: 13.00 KB (13312) E - RowBatchQueueGetWaitTime: 260.000ms E - RowBatchQueuePeakMemoryUsage: 25.00 KB (25600) E - RowBatchQueuePutWaitTime: 0.000ns E - RowBatchesEnqueued: 3 (3) E - RowsRead: 3.21M (3209332) E - RowsReturned: 19 (19) E - RowsReturnedRate: 29.00 /sec E - ScanRangesComplete: 1 (1) E - ScannerIoWaitTime: 5.000ms E - ScannerThreadWorklessLoops: 15 (15) E - ScannerThreadsInvoluntaryContextSwitches: 1 (1) E - ScannerThreadsTotalWallClockTime: 577.000ms E - ScannerThreadsSysTime: 999.000us E - ScannerThreadsUserTime: 253.963ms E - ScannerThreadsVoluntaryContextSwitches: 20 (20) E - TotalRawHdfsOpenFileTime: 1.000ms E - TotalRawHdfsReadTime: 4.000ms E - TotalReadThroughput: 0.00 /sec E - TotalTime: 653.000ms E Buffer pool: E - AllocTime: 0.000ns E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 8.12 MB (8519680) E - CumulativeAllocations: 2 (2) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 8.00 MB (8388608) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 8.00 MB (8388608) E - ReadIoBytes: 0 E - ReadIoOps: 0 (0) E - ReadIoWaitTime: 0.000ns E - SystemAllocTime: 0.000ns E - TotalTime: 0.000ns E - WriteIoBytes: 0 E - WriteIoOps: 0 (0) E - WriteIoWaitTime: 0.000ns E Filter 1 (0): E - Files processed: 0 (0) E - Files rejected: 0 (0) E - Files total: 0 (0) E - InactiveTotalTime: 0.000ns E - RowGroups processed: 1 (1) E - RowGroups rejected: 0 (0) E - RowGroups total: 1 (1) E - Rows processed: 0 (0) E - Rows rejected: 0 (0) E - Rows total: 3.21M (3209332) E - Splits processed: 0 (0) E - Splits rejected: 0 (0) E - Splits total: 0 (0) E - TotalTime: 0.000ns E Filter 0 (1.00 MB): E - Files processed: 0 (0) E - Files rejected: 0 (0) E - Files total: 0 (0) E - InactiveTotalTime: 0.000ns E - RowGroups processed: 0 (0) E - RowGroups rejected: 0 (0) E - RowGroups total: 0 (0) E - Rows processed: 3.21M (3209332) E - Rows rejected: 3.21M (3209313) E - Rows total: 3.21M (3209332) E - Splits processed: 0 (0) E - Splits rejected: 0 (0) E - Splits total: 0 (0) E - TotalTime: 0.000ns E Instance c148078d46befb8c:0df7093a00000002 (host=impala-ec2-centos74-m5-4xlarge-ondemand-00ee.vpc.cloudera.com:27002):(Total: 561.000ms, non-child: 140.000ms, % non-child: 24.96%) E Last report received time: 2021-03-29 23:15:31.412 E Hdfs split stats (:<# splits>/): -1:1/4.32 MB E Fragment Instance Lifecycle Event Timeline: 562.000ms E - Prepare Finished: 1.000ms (1.000ms) E - Open Finished: 142.000ms (141.000ms) E - First Batch Produced: 561.000ms (419.000ms) E - First Batch Sent: 561.000ms (0.000ns) E - ExecInternal Finished: 562.000ms (1.000ms) E - MemoryUsage (500.000ms): 4.04 MB E - ThreadUsage (500.000ms): 2 E - AverageThreadTokens: 2.00 E - BytesAssigned: 4.32 MB (4527247) E - CompletionTime: 833.000ms E - ExchangeScanRatio: 0.00 E - ExecutionRate: 5.18 MB/sec E - InactiveTotalTime: 0.000ns E - PeakMemoryUsage: 4.06 MB (4252096) E - PeakReservation: 4.00 MB (4194304) E - PeakUsedReservation: 0 E - PerHostPeakMemUsage: 16.77 MB (17584032) E - RowsProduced: 0 (0) E - TotalNetworkReceiveTime: 0.000ns E - TotalNetworkSendTime: 1.000ms E - TotalStorageWaitTime: 2.000ms E - TotalThreadsInvoluntaryContextSwitches: 9 (9) E - TotalThreadsTotalWallClockTime: 770.000ms E - TotalThreadsSysTime: 1.999ms E - TotalThreadsUserTime: 139.315ms E - TotalThreadsVoluntaryContextSwitches: 20 (20) E - TotalTime: 561.000ms E Fragment Instance Lifecycle Timings: E - ExecTime: 420.000ms E - ExecTreeExecTime: 419.000ms E - InactiveTotalTime: 0.000ns E - OpenTime: 141.000ms E - ExecTreeOpenTime: 1.000ms E - PrepareTime: 0.000ns E - ExecTreePrepareTime: 0.000ns E - TotalTime: 0.000ns E KrpcDataStreamSender (dst_id=4):(Total: 1.000ms, non-child: 0.000ns, % non-child: 0.00%) E ExecOption: Hash Partitioned Sender Codegen Enabled E - BytesSent (500.000ms): 0 E - NetworkThroughput: 0.00 /sec (Number of samples: 0) E - RpcNetworkTime: (Avg: 421.222us ; Min: 165.433us ; Max: 677.011us ; Number of samples: 2) E - RpcRecvrTime: (Avg: 65.960us ; Min: 64.129us ; Max: 67.791us ; Number of samples: 2) E - EosSent: 2 (2) E - InactiveTotalTime: 1.000ms E - PeakMemoryUsage: 28.44 KB (29120) E - RowsSent: 0 (0) E - RpcFailure: 0 (0) E - RpcRetry: 0 (0) E - SerializeBatchTime: 0.000ns E - TotalBytesSent: 0 E - TotalTime: 1.000ms E - UncompressedRowBatchSize: 0 E HDFS_SCAN_NODE (id=0):(Total: 420.000ms, non-child: 420.000ms, % non-child: 100.00%) E Table Name: tpch_parquet.lineitem_orderkey_only E Hdfs split stats (:<# splits>/): -1:1/4.32 MB E ExecOption: PARQUET Codegen Enabled, Codegen enabled: 1 out of 1 E Runtime filters: All filters arrived. Waited 417ms. Maximum arrival delay: 560ms. E Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% E File Formats: PARQUET/NONE:1 E Node Lifecycle Event Timeline: 561.000ms E - Open Started: 141.000ms (141.000ms) E - Open Finished: 142.000ms (1.000ms) E - First Batch Requested: 142.000ms (0.000ns) E - First Batch Returned: 561.000ms (419.000ms) E - Last Batch Returned: 561.000ms (0.000ns) E - Closed: 561.000ms (0.000ns) E - BytesReadSeries (500.000ms): 0 E - FooterProcessingTime: (Avg: 2.000ms ; Min: 2.000ms ; Max: 2.000ms ; Number of samples: 1) E - InitialRangeActualReservation: (Avg: 4.00 MB (4194304) ; Min: 4.00 MB (4194304) ; Max: 4.00 MB (4194304) ; Number of samples: 1) E - InitialRangeIdealReservation: (Avg: 128.00 KB (131072) ; Min: 128.00 KB (131072) ; Max: 128.00 KB (131072) ; Number of samples: 1) E - PageIndexProcessingTime: 0.000ns (Number of samples: 0) E - ParquetCompressedBytesReadPerColumn: 0 (Number of samples: 0) E - ParquetCompressedPageSize: 0 (Number of samples: 0) E - ParquetRowGroupActualReservation: 0 (Number of samples: 0) E - ParquetRowGroupIdealReservation: 0 (Number of samples: 0) E - ParquetUncompressedBytesReadPerColumn: 0 (Number of samples: 0) E - ParquetUncompressedPageSize: 0 (Number of samples: 0) E - AverageHdfsReadThreadConcurrency: 0.00 E - AverageScannerThreadConcurrency: 1.00 E - BytesRead: 100.00 KB (102400) E - BytesReadDataNodeCache: 0 E - BytesReadLocal: 100.00 KB (102400) E - BytesReadRemoteUnexpected: 0 E - BytesReadShortCircuit: 100.00 KB (102400) E - CachedFileHandlesHitCount: 0 (0) E - CachedFileHandlesMissCount: 1 (1) E - CollectionItemsRead: 0 (0) E - DataCacheHitBytes: 0 E - DataCacheHitCount: 0 (0) E - DataCacheMissBytes: 0 E - DataCacheMissCount: 0 (0) E - DataCachePartialHitCount: 0 (0) E - DecompressionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - MaterializeTupleTime: 0.000ns E - MaxCompressedTextFileLength: 0 E - NumColumns: 1 (1) E - NumDictFilteredRowGroups: 0 (0) E - NumDisksAccessed: 1 (1) E - NumPages: 0 (0) E - NumRowGroups: 1 (1) E - NumRowGroupsWithPageIndex: 1 (1) E - NumRuntimeFilteredPages: 0 (0) E - NumRuntimeFilteredRowGroups: 1 (1) E - NumScannerThreadMemUnavailable: 0 (0) E - NumScannerThreadReservationsDenied: 0 (0) E - NumScannerThreadsStarted: 1 (1) E - NumScannersWithNoReads: 0 (0) E - NumStatsFilteredPages: 0 (0) E - NumStatsFilteredRowGroups: 0 (0) E - PeakMemoryUsage: 4.02 MB (4214784) E - PeakScannerThreadConcurrency: 1 (1) E - PerReadThreadRawHdfsThroughput: 97.66 MB/sec E - RemoteScanRanges: 0 (0) E - RowBatchBytesEnqueued: 0 E - RowBatchQueueGetWaitTime: 2.000ms E - RowBatchQueuePeakMemoryUsage: 16.00 KB (16384) E - RowBatchQueuePutWaitTime: 0.000ns E - RowBatchesEnqueued: 2 (2) E - RowsRead: 0 (0) E - RowsReturned: 0 (0) E - RowsReturnedRate: 0 E - ScanRangesComplete: 1 (1) E - ScannerIoWaitTime: 2.000ms E - ScannerThreadWorklessLoops: 10 (10) E - ScannerThreadsInvoluntaryContextSwitches: 0 (0) E - ScannerThreadsTotalWallClockTime: 209.000ms E - ScannerThreadsSysTime: 0.000ns E - ScannerThreadsUserTime: 410.000us E - ScannerThreadsVoluntaryContextSwitches: 13 (13) E - TotalRawHdfsOpenFileTime: 1.000ms E - TotalRawHdfsReadTime: 1.000ms E - TotalReadThroughput: 0.00 /sec E - TotalTime: 420.000ms E Buffer pool: E - AllocTime: 0.000ns E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 128.00 KB (131072) E - CumulativeAllocations: 1 (1) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 4.00 MB (4194304) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 128.00 KB (131072) E - ReadIoBytes: 0 E - ReadIoOps: 0 (0) E - ReadIoWaitTime: 0.000ns E - SystemAllocTime: 0.000ns E - TotalTime: 0.000ns E - WriteIoBytes: 0 E - WriteIoOps: 0 (0) E - WriteIoWaitTime: 0.000ns E Filter 1 (0): E - Files processed: 0 (0) E - Files rejected: 0 (0) E - Files total: 0 (0) E - InactiveTotalTime: 0.000ns E - RowGroups processed: 1 (1) E - RowGroups rejected: 1 (1) E - RowGroups total: 1 (1) E - Rows processed: 0 (0) E - Rows rejected: 0 (0) E - Rows total: 0 (0) E - Splits processed: 0 (0) E - Splits rejected: 0 (0) E - Splits total: 0 (0) E - TotalTime: 0.000ns E Filter 0 (1.00 MB): E - Files processed: 0 (0) E - Files rejected: 0 (0) E - Files total: 0 (0) E - InactiveTotalTime: 0.000ns E - RowGroups processed: 0 (0) E - RowGroups rejected: 0 (0) E - RowGroups total: 0 (0) E - Rows processed: 0 (0) E - Rows rejected: 0 (0) E - Rows total: 0 (0) E - Splits processed: 0 (0) E - Splits rejected: 0 (0) E - Splits total: 0 (0) E - TotalTime: 0.000ns E Averaged Fragment F01:(Total: 242.000ms, non-child: 115.000ms, % non-child: 47.52%) E split sizes: min: 53.93 MB, max: 53.93 MB, avg: 53.93 MB, stddev: 0 E completion times: min:827.000ms max:827.000ms mean: 827.000ms stddev:0.000ns E execution rates: min:65.21 MB/sec max:65.21 MB/sec mean:65.21 MB/sec stddev:0.00 /sec E num instances: 1 E - AverageThreadTokens: 0.00 E - BytesAssigned: 53.93 MB (56551305) E - CompletionTime: 827.000ms E - ExchangeScanRatio: 0.00 E - ExecutionRate: 65.21 MB/sec E - InactiveTotalTime: 0.000ns E - PeakMemoryUsage: 8.96 MB (9392688) E - PeakReservation: 8.00 MB (8388608) E - PeakUsedReservation: 0 E - PerHostPeakMemUsage: 25.39 MB (26625910) E - RowsProduced: 4 (4) E - TotalNetworkReceiveTime: 0.000ns E - TotalNetworkSendTime: 0.000ns E - TotalStorageWaitTime: 67.000ms E - TotalThreadsInvoluntaryContextSwitches: 10 (10) E - TotalThreadsTotalWallClockTime: 367.000ms E - TotalThreadsSysTime: 1.995ms E - TotalThreadsUserTime: 155.534ms E - TotalThreadsVoluntaryContextSwitches: 18 (18) E - TotalTime: 242.000ms E Fragment Instance Lifecycle Timings: E - ExecTime: 126.000ms E - ExecTreeExecTime: 126.000ms E - InactiveTotalTime: 0.000ns E - OpenTime: 116.000ms E - ExecTreeOpenTime: 1.000ms E - PrepareTime: 0.000ns E - ExecTreePrepareTime: 0.000ns E - TotalTime: 0.000ns E KrpcDataStreamSender (dst_id=5): E - NetworkThroughput: (Avg: 162.94 KB/sec ; Min: 160.88 KB/sec ; Max: 165.00 KB/sec ; Number of samples: 2) E - RpcNetworkTime: (Avg: 191.750us ; Min: 145.396us ; Max: 236.739us ; Number of samples: 4) E - RpcRecvrTime: (Avg: 97.462us ; Min: 46.478us ; Max: 158.868us ; Number of samples: 4) E - EosSent: 2 (2) E - InactiveTotalTime: 0.000ns E - PeakMemoryUsage: 23.05 KB (23600) E - RowsSent: 4 (4) E - RpcFailure: 0 (0) E - RpcRetry: 0 (0) E - SerializeBatchTime: 0.000ns E - TotalBytesSent: 78.00 B (78) E - TotalTime: 0.000ns E - UncompressedRowBatchSize: 100.00 B (100) E HDFS_SCAN_NODE (id=1):(Total: 127.000ms, non-child: 127.000ms, % non-child: 100.00%) E - FooterProcessingTime: (Avg: 1.000ms ; Min: 1.000ms ; Max: 1.000ms ; Number of samples: 1) E - InitialRangeActualReservation: (Avg: 8.00 MB (8388608) ; Min: 8.00 MB (8388608) ; Max: 8.00 MB (8388608) ; Number of samples: 1) E - InitialRangeIdealReservation: (Avg: 128.00 KB (131072) ; Min: 128.00 KB (131072) ; Max: 128.00 KB (131072) ; Number of samples: 1) E - PageIndexProcessingTime: (Avg: 21.000ms ; Min: 21.000ms ; Max: 21.000ms ; Number of samples: 1) E - ParquetCompressedBytesReadPerColumn: (Avg: 1.58 MB (1660295) ; Min: 1.22 MB (1280039) ; Max: 1.95 MB (2040551) ; Number of samples: 2) E - ParquetCompressedPageSize: (Avg: 33.43 KB (34232) ; Min: 14.09 KB (14428) ; Max: 36.90 KB (37789) ; Number of samples: 97) E - ParquetRowGroupActualReservation: (Avg: 8.00 MB (8388608) ; Min: 8.00 MB (8388608) ; Max: 8.00 MB (8388608) ; Number of samples: 1) E - ParquetRowGroupIdealReservation: (Avg: 6.00 MB (6291456) ; Min: 6.00 MB (6291456) ; Max: 6.00 MB (6291456) ; Number of samples: 1) E - ParquetUncompressedBytesReadPerColumn: (Avg: 2.99 MB (3138213) ; Min: 2.10 MB (2198276) ; Max: 3.89 MB (4078151) ; Number of samples: 2) E - ParquetUncompressedPageSize: (Avg: 63.19 KB (64705) ; Min: 14.08 KB (14423) ; Max: 64.01 KB (65544) ; Number of samples: 97) E - AverageHdfsReadThreadConcurrency: 0.00 E - AverageScannerThreadConcurrency: 0.00 E - BytesRead: 3.74 MB (3921460) E - BytesReadDataNodeCache: 0 E - BytesReadLocal: 90.89 MB (95310284) E - BytesReadRemoteUnexpected: 0 E - BytesReadShortCircuit: 90.89 MB (95310284) E - CachedFileHandlesHitCount: 57 (57) E - CachedFileHandlesMissCount: 0 (0) E - CollectionItemsRead: 0 (0) E - DataCacheHitBytes: 0 E - DataCacheHitCount: 0 (0) E - DataCacheMissBytes: 0 E - DataCacheMissCount: 0 (0) E - DataCachePartialHitCount: 0 (0) E - DecompressionTime: 10.000ms E - InactiveTotalTime: 0.000ns E - MaterializeTupleTime: 16.000ms E - MaxCompressedTextFileLength: 0 E - NumColumns: 2 (2) E - NumDictFilteredRowGroups: 0 (0) E - NumDisksAccessed: 1 (1) E - NumPages: 360 (360) E - NumRowGroups: 1 (1) E - NumRowGroupsWithPageIndex: 1 (1) E - NumRuntimeFilteredPages: 0 (0) E - NumRuntimeFilteredRowGroups: 0 (0) E - NumScannerThreadMemUnavailable: 0 (0) E - NumScannerThreadReservationsDenied: 0 (0) E - NumScannerThreadsStarted: 1 (1) E - NumScannersWithNoReads: 0 (0) E - NumStatsFilteredPages: 263 (263) E - NumStatsFilteredRowGroups: 0 (0) E - PeakMemoryUsage: 8.94 MB (9369088) E - PeakScannerThreadConcurrency: 1 (1) E - PerReadThreadRawHdfsThroughput: 55.00 MB/sec E - RemoteScanRanges: 0 (0) E - RowBatchBytesEnqueued: 21.00 KB (21504) E - RowBatchQueueGetWaitTime: 122.000ms E - RowBatchQueuePeakMemoryUsage: 33.00 KB (33792) E - RowBatchQueuePutWaitTime: 0.000ns E - RowBatchesEnqueued: 3 (3) E - RowsRead: 287.98K (287976) E - RowsReturned: 4 (4) E - RowsReturnedRate: 31.00 /sec E - ScanRangesComplete: 1 (1) E - ScannerIoWaitTime: 67.000ms E - ScannerThreadWorklessLoops: 0 (0) E - ScannerThreadsInvoluntaryContextSwitches: 4 (4) E - ScannerThreadsTotalWallClockTime: 126.000ms E - ScannerThreadsSysTime: 0.000ns E - ScannerThreadsUserTime: 50.064ms E - ScannerThreadsVoluntaryContextSwitches: 5 (5) E - TotalRawHdfsOpenFileTime: 0.000ns E - TotalRawHdfsReadTime: 68.000ms E - TotalReadThroughput: 0.00 /sec E - TotalTime: 127.000ms E Buffer pool: E - AllocTime: 0.000ns E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 6.12 MB (6422528) E - CumulativeAllocations: 3 (3) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 8.00 MB (8388608) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 6.00 MB (6291456) E - ReadIoBytes: 0 E - ReadIoOps: 0 (0) E - ReadIoWaitTime: 0.000ns E - SystemAllocTime: 0.000ns E - TotalTime: 0.000ns E - WriteIoBytes: 0 E - WriteIoOps: 0 (0) E - WriteIoWaitTime: 0.000ns E Fragment F01: E - InactiveTotalTime: 0.000ns E - TotalTime: 0.000ns E Instance c148078d46befb8c:0df7093a00000003 (host=impala-ec2-centos74-m5-4xlarge-ondemand-00ee.vpc.cloudera.com:27001):(Total: 242.000ms, non-child: 115.000ms, % non-child: 47.52%) E Last report received time: 2021-03-29 23:15:31.405 E Hdfs split stats (:<# splits>/): -1:1/53.93 MB E Fragment Instance Lifecycle Event Timeline: 242.000ms E - Prepare Finished: 0.000ns (0.000ns) E - Open Finished: 116.000ms (116.000ms) E - First Batch Produced: 241.000ms (125.000ms) E - First Batch Sent: 241.000ms (0.000ns) E - ExecInternal Finished: 242.000ms (1.000ms) E - AverageThreadTokens: 0.00 E - BytesAssigned: 53.93 MB (56551305) E - CompletionTime: 827.000ms E - ExchangeScanRatio: 0.00 E - ExecutionRate: 65.21 MB/sec E - InactiveTotalTime: 0.000ns E - PeakMemoryUsage: 8.96 MB (9392688) E - PeakReservation: 8.00 MB (8388608) E - PeakUsedReservation: 0 E - PerHostPeakMemUsage: 25.39 MB (26625910) E - RowsProduced: 4 (4) E - TotalNetworkReceiveTime: 0.000ns E - TotalNetworkSendTime: 0.000ns E - TotalStorageWaitTime: 67.000ms E - TotalThreadsInvoluntaryContextSwitches: 10 (10) E - TotalThreadsTotalWallClockTime: 367.000ms E - TotalThreadsSysTime: 1.995ms E - TotalThreadsUserTime: 155.534ms E - TotalThreadsVoluntaryContextSwitches: 18 (18) E - TotalTime: 242.000ms E Fragment Instance Lifecycle Timings: E - ExecTime: 126.000ms E - ExecTreeExecTime: 126.000ms E - InactiveTotalTime: 0.000ns E - OpenTime: 116.000ms E - ExecTreeOpenTime: 1.000ms E - PrepareTime: 0.000ns E - ExecTreePrepareTime: 0.000ns E - TotalTime: 0.000ns E KrpcDataStreamSender (dst_id=5): E ExecOption: Hash Partitioned Sender Codegen Enabled E - NetworkThroughput: (Avg: 162.94 KB/sec ; Min: 160.88 KB/sec ; Max: 165.00 KB/sec ; Number of samples: 2) E - RpcNetworkTime: (Avg: 191.750us ; Min: 145.396us ; Max: 236.739us ; Number of samples: 4) E - RpcRecvrTime: (Avg: 97.462us ; Min: 46.478us ; Max: 158.868us ; Number of samples: 4) E - EosSent: 2 (2) E - InactiveTotalTime: 0.000ns E - PeakMemoryUsage: 23.05 KB (23600) E - RowsSent: 4 (4) E - RpcFailure: 0 (0) E - RpcRetry: 0 (0) E - SerializeBatchTime: 0.000ns E - TotalBytesSent: 78.00 B (78) E - TotalTime: 0.000ns E - UncompressedRowBatchSize: 100.00 B (100) E HDFS_SCAN_NODE (id=1):(Total: 127.000ms, non-child: 127.000ms, % non-child: 100.00%) E Table Name: tpch_parquet.orders E Hdfs split stats (:<# splits>/): -1:1/53.93 MB E ExecOption: PARQUET Codegen Enabled, Codegen enabled: 1 out of 1 E Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% E File Formats: PARQUET/SNAPPY:1 E Node Lifecycle Event Timeline: 242.000ms E - Open Started: 115.000ms (115.000ms) E - Open Finished: 116.000ms (1.000ms) E - First Batch Requested: 116.000ms (0.000ns) E - First Batch Returned: 241.000ms (125.000ms) E - Last Batch Returned: 242.000ms (1.000ms) E - Closed: 242.000ms (0.000ns) E - FooterProcessingTime: (Avg: 1.000ms ; Min: 1.000ms ; Max: 1.000ms ; Number of samples: 1) E - InitialRangeActualReservation: (Avg: 8.00 MB (8388608) ; Min: 8.00 MB (8388608) ; Max: 8.00 MB (8388608) ; Number of samples: 1) E - InitialRangeIdealReservation: (Avg: 128.00 KB (131072) ; Min: 128.00 KB (131072) ; Max: 128.00 KB (131072) ; Number of samples: 1) E - PageIndexProcessingTime: (Avg: 21.000ms ; Min: 21.000ms ; Max: 21.000ms ; Number of samples: 1) E - ParquetCompressedBytesReadPerColumn: (Avg: 1.58 MB (1660295) ; Min: 1.22 MB (1280039) ; Max: 1.95 MB (2040551) ; Number of samples: 2) E - ParquetCompressedPageSize: (Avg: 33.43 KB (34232) ; Min: 14.09 KB (14428) ; Max: 36.90 KB (37789) ; Number of samples: 97) E - ParquetRowGroupActualReservation: (Avg: 8.00 MB (8388608) ; Min: 8.00 MB (8388608) ; Max: 8.00 MB (8388608) ; Number of samples: 1) E - ParquetRowGroupIdealReservation: (Avg: 6.00 MB (6291456) ; Min: 6.00 MB (6291456) ; Max: 6.00 MB (6291456) ; Number of samples: 1) E - ParquetUncompressedBytesReadPerColumn: (Avg: 2.99 MB (3138213) ; Min: 2.10 MB (2198276) ; Max: 3.89 MB (4078151) ; Number of samples: 2) E - ParquetUncompressedPageSize: (Avg: 63.19 KB (64705) ; Min: 14.08 KB (14423) ; Max: 64.01 KB (65544) ; Number of samples: 97) E - AverageHdfsReadThreadConcurrency: 0.00 E - AverageScannerThreadConcurrency: 0.00 E - BytesRead: 3.74 MB (3921460) E - BytesReadDataNodeCache: 0 E - BytesReadLocal: 90.89 MB (95310284) E - BytesReadRemoteUnexpected: 0 E - BytesReadShortCircuit: 90.89 MB (95310284) E - CachedFileHandlesHitCount: 57 (57) E - CachedFileHandlesMissCount: 0 (0) E - CollectionItemsRead: 0 (0) E - DataCacheHitBytes: 0 E - DataCacheHitCount: 0 (0) E - DataCacheMissBytes: 0 E - DataCacheMissCount: 0 (0) E - DataCachePartialHitCount: 0 (0) E - DecompressionTime: 10.000ms E - InactiveTotalTime: 0.000ns E - MaterializeTupleTime: 16.000ms E - MaxCompressedTextFileLength: 0 E - NumColumns: 2 (2) E - NumDictFilteredRowGroups: 0 (0) E - NumDisksAccessed: 1 (1) E - NumPages: 360 (360) E - NumRowGroups: 1 (1) E - NumRowGroupsWithPageIndex: 1 (1) E - NumRuntimeFilteredPages: 0 (0) E - NumRuntimeFilteredRowGroups: 0 (0) E - NumScannerThreadMemUnavailable: 0 (0) E - NumScannerThreadReservationsDenied: 0 (0) E - NumScannerThreadsStarted: 1 (1) E - NumScannersWithNoReads: 0 (0) E - NumStatsFilteredPages: 263 (263) E - NumStatsFilteredRowGroups: 0 (0) E - PeakMemoryUsage: 8.94 MB (9369088) E - PeakScannerThreadConcurrency: 1 (1) E - PerReadThreadRawHdfsThroughput: 55.00 MB/sec E - RemoteScanRanges: 0 (0) E - RowBatchBytesEnqueued: 21.00 KB (21504) E - RowBatchQueueGetWaitTime: 122.000ms E - RowBatchQueuePeakMemoryUsage: 33.00 KB (33792) E - RowBatchQueuePutWaitTime: 0.000ns E - RowBatchesEnqueued: 3 (3) E - RowsRead: 287.98K (287976) E - RowsReturned: 4 (4) E - RowsReturnedRate: 31.00 /sec E - ScanRangesComplete: 1 (1) E - ScannerIoWaitTime: 67.000ms E - ScannerThreadWorklessLoops: 0 (0) E - ScannerThreadsInvoluntaryContextSwitches: 4 (4) E - ScannerThreadsTotalWallClockTime: 126.000ms E - ScannerThreadsSysTime: 0.000ns E - ScannerThreadsUserTime: 50.064ms E - ScannerThreadsVoluntaryContextSwitches: 5 (5) E - TotalRawHdfsOpenFileTime: 0.000ns E - TotalRawHdfsReadTime: 68.000ms E - TotalReadThroughput: 0.00 /sec E - TotalTime: 127.000ms E Buffer pool: E - AllocTime: 0.000ns E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 6.12 MB (6422528) E - CumulativeAllocations: 3 (3) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 8.00 MB (8388608) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 6.00 MB (6291456) E - ReadIoBytes: 0 E - ReadIoOps: 0 (0) E - ReadIoWaitTime: 0.000ns E - SystemAllocTime: 0.000ns E - TotalTime: 0.000ns E - WriteIoBytes: 0 E - WriteIoOps: 0 (0) E - WriteIoWaitTime: 0.000ns Standard Error SET client_identifier=query_test/test_runtime_filters.py::TestOverlapMinMaxFilters::()::test_overlap_min_max_filters[protocol:beeswax|exec_option:{'batch_size':0;'num_nodes':0;'disable_codegen_rows_threshold':0;'disable_codegen':False;'abort_on_error':1;'exec_single_node_rows_; -- connecting to: localhost:21000 -- connecting to localhost:21050 with impyla -- 2021-03-29 23:15:22,530 INFO MainThread: Closing active operation -- connecting to localhost:28000 with impyla -- 2021-03-29 23:15:22,553 INFO MainThread: Closing active operation -- executing against localhost:21000 SET MINMAX_FILTER_THRESHOLD=0.5; -- 2021-03-29 23:15:22,566 INFO MainThread: Started query 9a4c1552f76b1b0a:84b1db4e00000000 SET client_identifier=query_test/test_runtime_filters.py::TestOverlapMinMaxFilters::()::test_overlap_min_max_filters[protocol:beeswax|exec_option:{'batch_size':0;'num_nodes':0;'disable_codegen_rows_threshold':0;'disable_codegen':False;'abort_on_error':1;'exec_single_node_rows_; -- executing against localhost:21000 use functional_parquet; -- 2021-03-29 23:15:22,572 INFO MainThread: Started query 3348bc289f86b3cf:6173241000000000 SET client_identifier=query_test/test_runtime_filters.py::TestOverlapMinMaxFilters::()::test_overlap_min_max_filters[protocol:beeswax|exec_option:{'batch_size':0;'num_nodes':0;'disable_codegen_rows_threshold':0;'disable_codegen':False;'abort_on_error':1;'exec_single_node_rows_; SET batch_size=0; SET num_nodes=0; SET disable_codegen_rows_threshold=0; SET disable_codegen=False; SET abort_on_error=1; SET exec_single_node_rows_threshold=0; -- 2021-03-29 23:15:22,573 INFO MainThread: Loading query test file: /data/jenkins/workspace/impala-asf-master-core-erasure-coding/repos/Impala/testdata/workloads/functional-query/queries/QueryTest/overlap_min_max_filters.test -- executing against localhost:21000 set PARQUET_PAGE_ROW_COUNT_LIMIT=24000; -- 2021-03-29 23:15:22,593 INFO MainThread: Started query 194319d0b137ced3:560c2e0c00000000 -- executing against localhost:21000 drop table if exists tpch_parquet.lineitem_orderkey_only; -- 2021-03-29 23:15:22,599 INFO MainThread: Started query 674a7d957c5dd00c:e93e5c6200000000 -- executing against localhost:21000 CREATE TABLE tpch_parquet.lineitem_orderkey_only(l_orderkey bigint) sort by (l_orderkey) STORED AS PARQUET; -- 2021-03-29 23:15:22,620 INFO MainThread: Started query e142c4f19e1440cf:38c2e57000000000 -- executing against localhost:21000 insert into tpch_parquet.lineitem_orderkey_only select l_orderkey from tpch_parquet.lineitem; -- 2021-03-29 23:15:26,652 INFO MainThread: Started query 70435fae1bcb42dc:c8c09b9700000000 -- executing against localhost:21000 SET PARQUET_PAGE_ROW_COUNT_LIMIT=""; -- 2021-03-29 23:15:30,546 INFO MainThread: Started query 2c4546e2e7774362:958024e700000000 -- executing against localhost:21000 SET RUNTIME_FILTER_WAIT_TIME_MS=60000; -- 2021-03-29 23:15:30,552 INFO MainThread: Started query 294c0ea4abf3c025:b1ca88a200000000 -- executing against localhost:21000 SET MINMAX_FILTERING_LEVEL=PAGE; -- 2021-03-29 23:15:30,559 INFO MainThread: Started query 0f4e3c77925db959:2bc9b16f00000000 -- executing against localhost:21000 SET MINMAX_FILTER_THRESHOLD=0.5; -- 2021-03-29 23:15:30,564 INFO MainThread: Started query b3423023774baec0:0784fb5f00000000 -- executing against localhost:21000 select straight_join a.l_orderkey from tpch_parquet.lineitem_orderkey_only a join [SHUFFLE] tpch_parquet.orders b where a.l_orderkey = b.o_orderkey and b.o_custkey = 5 order by l_orderkey; -- 2021-03-29 23:15:30,576 INFO MainThread: Started query c148078d46befb8c:0df7093a00000000 -- executing against localhost:21000 SET RUNTIME_FILTER_WAIT_TIME_MS="0"; -- 2021-03-29 23:15:31,457 INFO MainThread: Started query b74145f3c18269cb:8fd08c1900000000 -- executing against localhost:21000 SET MINMAX_FILTERING_LEVEL="ROW_GROUP"; -- 2021-03-29 23:15:31,464 INFO MainThread: Started query 234fa5b64ca1dc7f:ad2364ec00000000 -- executing against localhost:21000 SET MINMAX_FILTER_THRESHOLD="0.000000"; -- 2021-03-29 23:15:31,470 INFO MainThread: Started query 964ce0b4836bcdef:9deebeab00000000