E PROFILE: E Query (id=b640be200cbf18f1:50e209bd00000000): 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: 2b4f8c5ceddbf1ef:92e4e8aa99895dad E Session Type: BEESWAX E Start Time: 2020-09-28 09:49:55.883177000 E End Time: 2020-09-28 09:50:01.208162000 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 c4277d8f7558451731b6da4d984df7bd78942050) E User: jenkins E Connected User: jenkins E Delegated User: E Network Address: ::1:39450 E Default Db: functional_kudu E Sql Statement: select STRAIGHT_JOIN a.d5_0, a.d5_1, a.d5_3, a.d5_5 E from decimal_rtf_tbl a E join [BROADCAST] decimal_rtf_tiny_tbl b E where a.d5_0 = b.d5_0 E and a.d5_1 = b.d5_1 E and a.d5_3 = b.d5_3 E and a.d5_5 = b.d5_5 E order by 1 E Coordinator: impala-ec2-centos74-m5-4xlarge-ondemand-0366.vpc.cloudera.com:22000 E Query Options (set by configuration): ABORT_ON_ERROR=1,DISABLE_CODEGEN=1,EXEC_SINGLE_NODE_ROWS_THRESHOLD=0,RUNTIME_FILTER_WAIT_TIME_MS=60000,DISABLE_CODEGEN_ROWS_THRESHOLD=0,TIMEZONE=America/Los_Angeles,CLIENT_IDENTIFIER=query_test/test_runtime_filters.py::TestMinMaxFilters::()::test_decimal_min_max_filters[protocol:beeswax|exec_option:{'batch_size':0;'num_nodes':0;'disable_codegen_rows_threshold':0;'disable_codegen':True;'abort_on_error':1;'exec_single_node_rows_threshol E Query Options (set by configuration and planner): ABORT_ON_ERROR=1,DISABLE_CODEGEN=1,EXEC_SINGLE_NODE_ROWS_THRESHOLD=0,RUNTIME_FILTER_WAIT_TIME_MS=60000,MT_DOP=0,DISABLE_CODEGEN_ROWS_THRESHOLD=0,TIMEZONE=America/Los_Angeles,CLIENT_IDENTIFIER=query_test/test_runtime_filters.py::TestMinMaxFilters::()::test_decimal_min_max_filters[protocol:beeswax|exec_option:{'batch_size':0;'num_nodes':0;'disable_codegen_rows_threshold':0;'disable_codegen':True;'abort_on_error':1;'exec_single_node_rows_threshol E Plan: E ---------------- E Max Per-Host Resource Reservation: Memory=11.94MB Threads=5 E Per-Host Resource Estimates: Memory=24MB E Analyzed query: SELECT /* +straight_join */ a.d5_0, a.d5_1, a.d5_3, a.d5_5 FROM E functional_kudu.decimal_rtf_tbl a INNER JOIN /* +BROADCAST */ E functional_kudu.decimal_rtf_tiny_tbl b WHERE a.d5_0 = b.d5_0 AND a.d5_1 = b.d5_1 E AND a.d5_3 = b.d5_3 AND a.d5_5 = b.d5_5 ORDER BY CAST(1 AS TINYINT) ASC E E F02:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 E | Per-Host Resources: mem-estimate=16.00KB mem-reservation=0B thread-reservation=1 E PLAN-ROOT SINK E | output exprs: d5_0, d5_1, d5_3, d5_5 E | mem-estimate=0B mem-reservation=0B thread-reservation=0 E | E 05:MERGING-EXCHANGE [UNPARTITIONED] E | order by: d5_0 ASC E | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 E | tuple-ids=2 row-size=16B cardinality=51 E | in pipelines: 03(GETNEXT) E | E F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 E Per-Host Resources: mem-estimate=17.94MB mem-reservation=11.94MB thread-reservation=2 runtime-filters-memory=4.00MB E 03:SORT E | order by: d5_0 ASC E | mem-estimate=6.00MB mem-reservation=6.00MB spill-buffer=2.00MB thread-reservation=0 E | tuple-ids=2 row-size=16B cardinality=51 E | in pipelines: 03(GETNEXT), 00(OPEN) E | E 02:HASH JOIN [INNER JOIN, BROADCAST] E | hash predicates: a.d5_0 = b.d5_0, a.d5_1 = b.d5_1, a.d5_3 = b.d5_3, a.d5_5 = b.d5_5 E | fk/pk conjuncts: a.d5_0 = b.d5_0, a.d5_1 = b.d5_1, a.d5_3 = b.d5_3, a.d5_5 = b.d5_5 E | runtime filters: RF000[bloom] <- b.d5_0, RF001[bloom] <- b.d5_1, RF002[bloom] <- b.d5_3, RF003[bloom] <- b.d5_5, RF004[min_max] <- b.d5_0, RF005[min_max] <- b.d5_1, RF006[min_max] <- b.d5_3, RF007[min_max] <- b.d5_5 E | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0 E | tuple-ids=0,1 row-size=32B cardinality=51 E | in pipelines: 00(GETNEXT), 01(OPEN) E | E |--04:EXCHANGE [BROADCAST] E | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 E | | tuple-ids=1 row-size=16B cardinality=40 E | | in pipelines: 01(GETNEXT) E | | E | F01:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 E | Per-Host Resources: mem-estimate=6.00MB mem-reservation=0B thread-reservation=2 E | 01:SCAN KUDU [functional_kudu.decimal_rtf_tiny_tbl b] E | mem-estimate=6.00MB mem-reservation=0B thread-reservation=1 E | tuple-ids=1 row-size=16B cardinality=40 E | in pipelines: 01(GETNEXT) E | E 00:SCAN KUDU [functional_kudu.decimal_rtf_tbl a] E runtime filters: RF000[bloom] -> a.d5_0, RF001[bloom] -> a.d5_1, RF002[bloom] -> a.d5_3, RF003[bloom] -> a.d5_5, RF004[min_max] -> a.d5_0, RF005[min_max] -> a.d5_1, RF006[min_max] -> a.d5_3, RF007[min_max] -> a.d5_5 E mem-estimate=6.00MB mem-reservation=0B thread-reservation=1 E tuple-ids=0 row-size=16B cardinality=1.40K E in pipelines: 00(GETNEXT) E ---------------- E Estimated Per-Host Mem: 25116672 E Request Pool: default-pool E Per Host Min Memory Reservation: impala-ec2-centos74-m5-4xlarge-ondemand-0366.vpc.cloudera.com:22001(11.94 MB) impala-ec2-centos74-m5-4xlarge-ondemand-0366.vpc.cloudera.com:22000(11.94 MB) impala-ec2-centos74-m5-4xlarge-ondemand-0366.vpc.cloudera.com:22002(11.94 MB) E Per Host Number of Fragment Instances: impala-ec2-centos74-m5-4xlarge-ondemand-0366.vpc.cloudera.com:22001(2) impala-ec2-centos74-m5-4xlarge-ondemand-0366.vpc.cloudera.com:22000(3) impala-ec2-centos74-m5-4xlarge-ondemand-0366.vpc.cloudera.com:22002(2) E Admission result: Admitted immediately E Cluster Memory Admitted: 71.86 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 F02:ROOT 1 1 0.000ns 0.000ns 0 0 E 05:MERGING-EXCHANGE 1 1 0.000ns 0.000ns 38 51 48.00 KB 16.00 KB UNPARTITIONED E F00:EXCHANGE SENDER 3 3 0.000ns 0.000ns 7.52 KB 0 E 03:SORT 3 3 0.000ns 0.000ns 38 51 6.08 MB 6.00 MB E 02:HASH JOIN 3 3 0.000ns 0.000ns 38 51 2.01 MB 1.94 MB INNER JOIN, BROADCAST E |--04:EXCHANGE 3 3 0.000ns 0.000ns 40 40 104.00 KB 16.00 KB BROADCAST E | F01:EXCHANGE SENDER 3 3 666.663us 999.996us 24.00 KB 0 E | 01:SCAN KUDU 3 3 13.666ms 14.999ms 40 40 72.00 KB 6.00 MB functional_kudu.decimal_rtf_tiny_tbl b E 00:SCAN KUDU 3 3 100.332ms 104.999ms 38 1.40K 48.00 KB 6.00 MB functional_kudu.decimal_rtf_tbl a E Errors: E Query Compilation: 5s162ms E - Metadata load started: 297.169us (297.169us) E - Metadata load finished. loaded-tables=2/2 load-requests=1 catalog-updates=5 storage-load-time=73ms: 5s117ms (5s117ms) E - Analysis finished: 5s117ms (263.456us) E - Authorization finished (noop): 5s117ms (13.526us) E - Value transfer graph computed: 5s118ms (132.720us) E - Single node plan created: 5s160ms (42.913ms) E - Runtime filters computed: 5s161ms (106.505us) E - Distributed plan created: 5s161ms (14.434us) E - Planning finished: 5s162ms (1.407ms) E Query Timeline: 5s328ms E - Query submitted: 0.000ns (0.000ns) E - Planning finished: 5s163ms (5s163ms) E - Submit for admission: 5s163ms (0.000ns) E - Completed admission: 5s164ms (999.995us) E - Ready to start on 3 backends: 5s165ms (999.995us) E - All 3 execution backends (7 fragment instances) started: 5s173ms (7.999ms) E - Rows available: 5s282ms (108.999ms) E - First row fetched: 5s319ms (36.999ms) E - Last row fetched: 5s319ms (0.000ns) E - Released admission control resources: 5s324ms (4.999ms) E - AdmissionControlTimeSinceLastUpdate: 34.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: 36.999ms E - InactiveTotalTime: 0.000ns E - NumRowsFetched: 38 (38) E - NumRowsFetchedFromCache: 0 (0) E - RowMaterializationRate: 5.43 K/sec E - RowMaterializationTimer: 6.999ms E - TotalTime: 0.000ns E Execution Profile b640be200cbf18f1:50e209bd00000000:(Total: 124.999ms, non-child: 0.000ns, % non-child: 0.00%) E Number of filters: 8 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 E ----------------------------------------------------------------------------------------------------------------------------------------- E 7 2 0 LOCAL false 0 (3) N/A N/A true MIN_MAX E 6 2 0 LOCAL false 0 (3) N/A N/A true MIN_MAX E 5 2 0 LOCAL false 0 (3) N/A N/A true MIN_MAX E 4 2 0 LOCAL false 0 (3) N/A N/A true MIN_MAX E 3 2 0 LOCAL false 0 (3) N/A N/A true 1.00 MB 4.48e-36 E 2 2 0 LOCAL false 0 (3) N/A N/A true 1.00 MB 4.48e-36 E 1 2 0 LOCAL false 0 (3) N/A N/A true 1.00 MB 4.48e-36 E 0 2 0 LOCAL false 0 (3) N/A N/A true 1.00 MB 4.48e-36 E Backend startup latencies: Count: 3, min / max: 2ms / 6ms, 25th %-ile: 2ms, 50th %-ile: 3ms, 75th %-ile: 3ms, 90th %-ile: 6ms, 95th %-ile: 6ms, 99.9th %-ile: 6ms E Slowest backend to start up: impala-ec2-centos74-m5-4xlarge-ondemand-0366.vpc.cloudera.com:22002 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 E ----------------------------------------------------------------------------------------------------------------------------------------- E 7 2 0 LOCAL false 0 (3) N/A N/A true MIN_MAX E 6 2 0 LOCAL false 0 (3) N/A N/A true MIN_MAX E 5 2 0 LOCAL false 0 (3) N/A N/A true MIN_MAX E 4 2 0 LOCAL false 0 (3) N/A N/A true MIN_MAX E 3 2 0 LOCAL false 0 (3) N/A N/A true 1.00 MB 4.48e-36 E 2 2 0 LOCAL false 0 (3) N/A N/A true 1.00 MB 4.48e-36 E 1 2 0 LOCAL false 0 (3) N/A N/A true 1.00 MB 4.48e-36 E 0 2 0 LOCAL false 0 (3) N/A N/A true 1.00 MB 4.48e-36 E Per Node Peak Memory Usage: impala-ec2-centos74-m5-4xlarge-ondemand-0366.vpc.cloudera.com:22000(12.13 MB) impala-ec2-centos74-m5-4xlarge-ondemand-0366.vpc.cloudera.com:22002(12.16 MB) impala-ec2-centos74-m5-4xlarge-ondemand-0366.vpc.cloudera.com:22001(12.15 MB) E Per Node Bytes Read: impala-ec2-centos74-m5-4xlarge-ondemand-0366.vpc.cloudera.com:22000(0) impala-ec2-centos74-m5-4xlarge-ondemand-0366.vpc.cloudera.com:22002(0) impala-ec2-centos74-m5-4xlarge-ondemand-0366.vpc.cloudera.com:22001(0) E Per Node User Time: impala-ec2-centos74-m5-4xlarge-ondemand-0366.vpc.cloudera.com:22000(15.910ms) impala-ec2-centos74-m5-4xlarge-ondemand-0366.vpc.cloudera.com:22002(13.203ms) impala-ec2-centos74-m5-4xlarge-ondemand-0366.vpc.cloudera.com:22001(16.621ms) E Per Node System Time: impala-ec2-centos74-m5-4xlarge-ondemand-0366.vpc.cloudera.com:22000(13.460ms) impala-ec2-centos74-m5-4xlarge-ondemand-0366.vpc.cloudera.com:22002(17.786ms) impala-ec2-centos74-m5-4xlarge-ondemand-0366.vpc.cloudera.com:22001(22.338ms) E - ExchangeScanRatio: 0.00 E - FiltersReceived: 0 (0) E - FinalizationTimer: 0.000ns E - InactiveTotalTime: 0.000ns E - InnerNodeSelectivityRatio: 0.00 E - NumBackends: 3 (3) E - NumCompletedBackends: 3 (3) E - NumFragmentInstances: 7 (7) E - NumFragments: 3 (3) E - TotalBytesRead: 0 E - TotalBytesSent: 1.76 KB (1799) E - TotalCpuTime: 99.318ms E - TotalInnerBytesSent: 1.76 KB (1799) E - TotalScanBytesSent: 0 E - TotalTime: 124.999ms E Per Node Profiles: E - InactiveTotalTime: 0.000ns E - TotalTime: 0.000ns E impala-ec2-centos74-m5-4xlarge-ondemand-0366.vpc.cloudera.com:22000: E Filter 0 arrival: 41ms E Filter 1 arrival: 42ms E Filter 2 arrival: 42ms E Filter 3 arrival: 42ms E Filter 4 arrival: 42ms E Filter 5 arrival: 42ms E Filter 6 arrival: 42ms E Filter 7 arrival: 42ms E - AdmissionSlots: 1 (1) E - BloomFilterBytes: 4.00 MB (4194304) 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: 4.00 MB (4194304) E - CumulativeAllocations: 4 (4) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 4.00 MB (4194304) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 4.00 MB (4194304) E - ReadIoBytes: 0 E - ReadIoOps: 0 (0) E - ReadIoWaitTime: 0.000ns E - ReservationLimit: 4.00 MB (4194304) 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 Fragment F00: E - InactiveTotalTime: 0.000ns E - TotalTime: 0.000ns E Fragment F01: E - InactiveTotalTime: 0.000ns E - TotalTime: 0.000ns E impala-ec2-centos74-m5-4xlarge-ondemand-0366.vpc.cloudera.com:22002: E Filter 0 arrival: 37ms E Filter 1 arrival: 37ms E Filter 2 arrival: 37ms E Filter 3 arrival: 37ms E Filter 4 arrival: 37ms E Filter 5 arrival: 37ms E Filter 6 arrival: 37ms E Filter 7 arrival: 37ms E - AdmissionSlots: 1 (1) E - BloomFilterBytes: 4.00 MB (4194304) 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: 999.996us E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 4.00 MB (4194304) E - CumulativeAllocations: 4 (4) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 4.00 MB (4194304) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 4.00 MB (4194304) E - ReadIoBytes: 0 E - ReadIoOps: 0 (0) E - ReadIoWaitTime: 0.000ns E - ReservationLimit: 4.00 MB (4194304) E - SystemAllocTime: 999.996us 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 F00: E - InactiveTotalTime: 0.000ns E - TotalTime: 0.000ns E Fragment F01: E - InactiveTotalTime: 0.000ns E - TotalTime: 0.000ns E impala-ec2-centos74-m5-4xlarge-ondemand-0366.vpc.cloudera.com:22001: E Filter 0 arrival: 39ms E Filter 1 arrival: 39ms E Filter 2 arrival: 39ms E Filter 3 arrival: 39ms E Filter 4 arrival: 39ms E Filter 5 arrival: 39ms E Filter 6 arrival: 39ms E Filter 7 arrival: 39ms E - AdmissionSlots: 1 (1) E - BloomFilterBytes: 4.00 MB (4194304) 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: 999.995us E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 4.00 MB (4194304) E - CumulativeAllocations: 4 (4) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 4.00 MB (4194304) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 4.00 MB (4194304) E - ReadIoBytes: 0 E - ReadIoOps: 0 (0) E - ReadIoWaitTime: 0.000ns E - ReservationLimit: 4.00 MB (4194304) E - SystemAllocTime: 999.995us 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 F00: E - InactiveTotalTime: 0.000ns E - TotalTime: 0.000ns E Fragment F01: E - InactiveTotalTime: 0.000ns E - TotalTime: 0.000ns E Averaged Fragment F02:(Total: 146.999ms, non-child: 999.995us, % non-child: 0.68%) E split sizes: min: 0, max: 0, avg: 0, stddev: 0 E completion times: min:154.999ms max:154.999ms mean: 154.999ms 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: 154.999ms E - ExchangeScanRatio: 0.00 E - ExecutionRate: 0.00 /sec E - InactiveTotalTime: 0.000ns E - PeakMemoryUsage: 56.00 KB (57344) E - PeakReservation: 0 E - PeakUsedReservation: 0 E - PerHostPeakMemUsage: 12.13 MB (12721944) E - RowsProduced: 38 (38) E - TotalNetworkReceiveTime: 0.000ns E - TotalNetworkSendTime: 0.000ns E - TotalStorageWaitTime: 0.000ns E - TotalThreadsInvoluntaryContextSwitches: 0 (0) E - TotalThreadsTotalWallClockTime: 145.999ms E - TotalThreadsSysTime: 0.000ns E - TotalThreadsUserTime: 592.000us E - TotalThreadsVoluntaryContextSwitches: 4 (4) E - TotalTime: 146.999ms E Fragment Instance Lifecycle Timings: E - ExecTime: 36.999ms E - ExecTreeExecTime: 999.995us E - InactiveTotalTime: 0.000ns E - OpenTime: 108.999ms E - ExecTreeOpenTime: 108.999ms E - PrepareTime: 999.995us E - ExecTreePrepareTime: 999.995us E - TotalTime: 0.000ns E PLAN_ROOT_SINK:(Total: 35.999ms, non-child: 0.000ns, % non-child: 0.00%) E - InactiveTotalTime: 35.999ms E - PeakMemoryUsage: 0 E - RowsSent: 38 (38) E - RowsSentRate: 1.05 K/sec E - TotalTime: 35.999ms E EXCHANGE_NODE (id=5):(Total: 109.999ms, non-child: 0.000ns, % non-child: 0.00%) E - ConvertRowBatchTime: 0.000ns E - InactiveTotalTime: 109.999ms E - MergeGetNext: 999.995us E - MergeGetNextBatch: 999.995us E - PeakMemoryUsage: 48.00 KB (49152) E - RowsReturned: 38 (38) E - RowsReturnedRate: 345.00 /sec E - TotalTime: 109.999ms E Buffer pool: E - AllocTime: 999.995us E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 48.00 KB (49152) E - CumulativeAllocations: 6 (6) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 48.00 KB (49152) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 48.00 KB (49152) 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: 108.999ms E - InactiveTotalTime: 0.000ns E - TotalBytesDequeued: 950.00 B (950) E - TotalGetBatchTime: 109.999ms E - DataWaitTime: 109.999ms E - TotalTime: 0.000ns E Enqueue: E - DeserializeRowBatchTime: 999.995us E - InactiveTotalTime: 0.000ns E - TotalBatchesEnqueued: 3 (3) E - TotalBatchesReceived: 3 (3) E - TotalBytesReceived: 413.00 B (413) E - TotalEarlySenders: 0 (0) E - TotalEosReceived: 3 (3) E - TotalHasDeferredRPCsTime: 0.000ns E - TotalRPCsDeferred: 0 (0) E - TotalTime: 0.000ns E Coordinator Fragment F02: E - InactiveTotalTime: 0.000ns E - TotalTime: 0.000ns E Instance b640be200cbf18f1:50e209bd00000000 (host=impala-ec2-centos74-m5-4xlarge-ondemand-0366.vpc.cloudera.com:22000):(Total: 146.999ms, non-child: 999.995us, % non-child: 0.68%) E Last report received time: 2020-09-28 09:50:01.207 E Fragment Instance Lifecycle Event Timeline: 150.999ms E - Prepare Finished: 4.999ms (4.999ms) E - Open Finished: 113.999ms (108.999ms) E - First Batch Produced: 114.999ms (999.995us) E - First Batch Sent: 150.999ms (35.999ms) E - ExecInternal Finished: 150.999ms (0.000ns) E - AverageThreadTokens: 0.00 E - BytesAssigned: 0 E - CompletionTime: 154.999ms E - ExchangeScanRatio: 0.00 E - ExecutionRate: 0.00 /sec E - InactiveTotalTime: 0.000ns E - PeakMemoryUsage: 56.00 KB (57344) E - PeakReservation: 0 E - PeakUsedReservation: 0 E - PerHostPeakMemUsage: 12.13 MB (12721944) E - RowsProduced: 38 (38) E - TotalNetworkReceiveTime: 0.000ns E - TotalNetworkSendTime: 0.000ns E - TotalStorageWaitTime: 0.000ns E - TotalThreadsInvoluntaryContextSwitches: 0 (0) E - TotalThreadsTotalWallClockTime: 145.999ms E - TotalThreadsSysTime: 0.000ns E - TotalThreadsUserTime: 592.000us E - TotalThreadsVoluntaryContextSwitches: 4 (4) E - TotalTime: 146.999ms E Fragment Instance Lifecycle Timings: E - ExecTime: 36.999ms E - ExecTreeExecTime: 999.995us E - InactiveTotalTime: 0.000ns E - OpenTime: 108.999ms E - ExecTreeOpenTime: 108.999ms E - PrepareTime: 999.995us E - ExecTreePrepareTime: 999.995us E - TotalTime: 0.000ns E PLAN_ROOT_SINK:(Total: 35.999ms, non-child: 0.000ns, % non-child: 0.00%) E - InactiveTotalTime: 35.999ms E - PeakMemoryUsage: 0 E - RowsSent: 38 (38) E - RowsSentRate: 1.05 K/sec E - TotalTime: 35.999ms E EXCHANGE_NODE (id=5):(Total: 109.999ms, non-child: 0.000ns, % non-child: 0.00%) E ExecOption: Codegen Disabled: disabled by query option DISABLE_CODEGEN E Node Lifecycle Event Timeline: 150.999ms E - Open Started: 4.999ms (4.999ms) E - Open Finished: 113.999ms (108.999ms) E - First Batch Requested: 113.999ms (0.000ns) E - First Batch Returned: 114.999ms (999.995us) E - Last Batch Returned: 114.999ms (0.000ns) E - Closed: 150.999ms (35.999ms) E - ConvertRowBatchTime: 0.000ns E - InactiveTotalTime: 109.999ms E - MergeGetNext: 999.995us E - MergeGetNextBatch: 999.995us E - PeakMemoryUsage: 48.00 KB (49152) E - RowsReturned: 38 (38) E - RowsReturnedRate: 345.00 /sec E - TotalTime: 109.999ms E Buffer pool: E - AllocTime: 999.995us E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 48.00 KB (49152) E - CumulativeAllocations: 6 (6) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 48.00 KB (49152) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 48.00 KB (49152) 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: 108.999ms E - InactiveTotalTime: 0.000ns E - TotalBytesDequeued: 950.00 B (950) E - TotalGetBatchTime: 109.999ms E - DataWaitTime: 109.999ms E - TotalTime: 0.000ns E Enqueue: E - DispatchTime: (Avg: 52.420us ; Min: 40.397us ; Max: 66.558us ; Number of samples: 3) E - DeserializeRowBatchTime: 999.995us E - InactiveTotalTime: 0.000ns E - TotalBatchesEnqueued: 3 (3) E - TotalBatchesReceived: 3 (3) E - TotalBytesReceived: 413.00 B (413) E - TotalEarlySenders: 0 (0) E - TotalEosReceived: 3 (3) E - TotalHasDeferredRPCsTime: 0.000ns E - TotalRPCsDeferred: 0 (0) E - TotalTime: 0.000ns E Averaged Fragment F00 [3 instances]:(Total: 92.999ms, non-child: 0.000ns, % non-child: 0.00%) E split sizes: min: 0, max: 0, avg: 0, stddev: 0 E completion times: min:93.999ms max:154.999ms mean: 121.666ms stddev:25.223ms E execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec E num instances: 3 E - AverageThreadTokens: 0.00 E - BytesAssigned: 0 E - CompletionTime: 121.666ms E - ExchangeScanRatio: 0.00 E - ExecutionRate: 0.00 /sec E - InactiveTotalTime: 0.000ns E - PeakMemoryUsage: 8.09 MB (8478488) E - PeakReservation: 7.94 MB (8323072) E - PeakUsedReservation: 0 E - PerHostPeakMemUsage: 12.15 MB (12738328) E - RowsProduced: 12 (12) E - TotalNetworkReceiveTime: 22.666ms E - TotalNetworkSendTime: 1.999ms E - TotalStorageWaitTime: 116.332ms E - TotalThreadsInvoluntaryContextSwitches: 4 (4) E - TotalThreadsTotalWallClockTime: 255.332ms E - TotalThreadsSysTime: 17.861ms E - TotalThreadsUserTime: 12.957ms E - TotalThreadsVoluntaryContextSwitches: 25 (25) E - TotalTime: 92.999ms E Fragment Instance Lifecycle Timings [3 instances]: E - ExecTime: 1.999ms E - ExecTreeExecTime: 0.000ns E - InactiveTotalTime: 0.000ns E - OpenTime: 89.999ms E - ExecTreeOpenTime: 89.999ms E - PrepareTime: 999.995us E - ExecTreePrepareTime: 999.995us E - TotalTime: 0.000ns E KrpcDataStreamSender (dst_id=5) [3 instances]:(Total: 1.999ms, non-child: 0.000ns, % non-child: 0.00%) E - EosSent: 1 (1) E - InactiveTotalTime: 1.999ms E - PeakMemoryUsage: 7.52 KB (7704) E - RowsSent: 12 (12) E - RpcFailure: 0 (0) E - RpcRetry: 0 (0) E - SerializeBatchTime: 0.000ns E - TotalBytesSent: 137.00 B (137) E - TotalTime: 1.999ms E - UncompressedRowBatchSize: 316.00 B (316) E SORT_NODE (id=3) [3 instances]:(Total: 90.999ms, non-child: 0.000ns, % non-child: 0.00%) E - InMemorySortTime: 0.000ns E - InactiveTotalTime: 0.000ns E - InitialRunsCreated: 1 (1) E - PeakMemoryUsage: 6.07 MB (6362453) E - RowsReturned: 12 (12) E - RowsReturnedRate: 140.00 /sec E - SortDataSize: 215.00 B (215) E - SpilledRuns: 0 (0) E - TotalMergesPerformed: 0 (0) E - TotalTime: 90.999ms E Buffer pool [3 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) [3 instances]:(Total: 90.999ms, non-child: 0.000ns, % non-child: 0.00%) E - InactiveTotalTime: 0.000ns E - PeakMemoryUsage: 2.01 MB (2105600) E - ProbeRows: 12 (12) E - ProbeRowsPartitioned: 0 (0) E - ProbeTime: 0.000ns E - RowsReturned: 12 (12) E - RowsReturnedRate: 140.00 /sec E - TotalTime: 90.999ms E Buffer pool [3 instances]: E - AllocTime: 0.000ns E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 1.00 MB (1048576) E - CumulativeAllocations: 16 (16) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 1.94 MB (2031616) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 1.00 MB (1048576) 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) [3 instances]:(Total: 3.999ms, non-child: 3.999ms, % non-child: 100.00%) E - BuildRows: 40 (40) E - BuildRowsPartitionTime: 333.331us E - HashTablesBuildTime: 333.332us E - InactiveTotalTime: 0.000ns E - LargestPartitionPercent: 20 (20) E - MaxPartitionLevel: 0 (0) E - NumHashTableBuildsSkipped: 0 (0) E - NumRepartitions: 0 (0) E - PartitionsCreated: 16 (16) E - PeakMemoryUsage: 32.12 KB (32896) E - RepartitionTime: 0.000ns E - SpilledPartitions: 0 (0) E - TotalTime: 3.999ms E Hash Table [3 instances]: E - HashBuckets: 73 (73) E - HashCollisions: 0 (0) E - InactiveTotalTime: 0.000ns E - Probes: 52 (52) E - Resizes: 0 (0) E - TotalTime: 0.000ns E - Travel: 12 (12) E EXCHANGE_NODE (id=4) [3 instances]:(Total: 22.666ms, non-child: 0.000ns, % non-child: 0.00%) E - ConvertRowBatchTime: 0.000ns E - InactiveTotalTime: 22.666ms E - PeakMemoryUsage: 93.33 KB (95573) E - RowsReturned: 40 (40) E - RowsReturnedRate: 1.78 K/sec E - TotalTime: 22.666ms E Buffer pool [3 instances]: E - AllocTime: 0.000ns E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 160.00 KB (163840) E - CumulativeAllocations: 20 (20) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 93.33 KB (95573) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 93.33 KB (95573) 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 [3 instances]: E - FirstBatchWaitTime: 333.331us E - InactiveTotalTime: 0.000ns E - TotalBytesDequeued: 960.00 B (960) E - TotalGetBatchTime: 22.666ms E - DataWaitTime: 22.666ms E - TotalTime: 0.000ns E Enqueue [3 instances]: E - DeserializeRowBatchTime: 0.000ns E - InactiveTotalTime: 0.000ns E - TotalBatchesEnqueued: 10 (10) E - TotalBatchesReceived: 10 (10) E - TotalBytesReceived: 462.00 B (462) E - TotalEarlySenders: 0 (0) E - TotalEosReceived: 3 (3) E - TotalHasDeferredRPCsTime: 0.000ns E - TotalRPCsDeferred: 0 (0) E - TotalTime: 0.000ns E KUDU_SCAN_NODE (id=0) [3 instances]:(Total: 100.332ms, non-child: 100.332ms, % non-child: 100.00%) E - AverageScannerThreadConcurrency: 0.00 E - InactiveTotalTime: 0.000ns E - KuduClientTime: 116.332ms E - KuduRemoteScanTokens: 0 (0) E - MaterializeTupleTime: 0.000ns E - NumScannerThreadMemUnavailable: 0 (0) E - NumScannerThreadsStarted: 3 (3) E - PeakMemoryUsage: 32.00 KB (32768) E - PeakScannerThreadConcurrency: 3 (3) E - RowBatchBytesEnqueued: 53.33 KB (54613) E - RowBatchQueueGetWaitTime: 30.999ms E - RowBatchQueuePeakMemoryUsage: 32.00 KB (32768) E - RowBatchQueuePutWaitTime: 0.000ns E - RowBatchesEnqueued: 3 (3) E - RowsRead: 12 (12) E - RowsReturned: 12 (12) E - RowsReturnedRate: 126.00 /sec E - ScanRangesComplete: 3 (3) E - ScannerThreadsInvoluntaryContextSwitches: 4 (4) E - ScannerThreadsTotalWallClockTime: 119.666ms E - ScannerThreadsSysTime: 15.979ms E - ScannerThreadsUserTime: 8.912ms E - ScannerThreadsVoluntaryContextSwitches: 4 (4) E - TotalKuduScanRoundTrips: 3 (3) E - TotalTime: 100.332ms E Filter 0 (1.00 MB) [3 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: 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 1 (1.00 MB) [3 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: 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 2 (1.00 MB) [3 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: 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 3 (1.00 MB) [3 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: 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 Fragment F00: E - InactiveTotalTime: 0.000ns E - TotalTime: 0.000ns E Instance b640be200cbf18f1:50e209bd00000006 (host=impala-ec2-centos74-m5-4xlarge-ondemand-0366.vpc.cloudera.com:22001):(Total: 105.999ms, non-child: 0.000ns, % non-child: 0.00%) E Last report received time: 2020-09-28 09:50:01.170 E Hdfs split stats (:<# splits>/): E Fragment Instance Lifecycle Event Timeline: 112.999ms E - Prepare Finished: 7.999ms (7.999ms) E - Open Finished: 109.999ms (101.999ms) E - First Batch Produced: 109.999ms (0.000ns) E - First Batch Sent: 109.999ms (0.000ns) E - ExecInternal Finished: 112.999ms (2.999ms) E - AverageThreadTokens: 0.00 E - BytesAssigned: 0 E - CompletionTime: 115.999ms E - ExchangeScanRatio: 0.00 E - ExecutionRate: 0.00 /sec E - InactiveTotalTime: 0.000ns E - PeakMemoryUsage: 8.10 MB (8494872) E - PeakReservation: 7.94 MB (8323072) E - PeakUsedReservation: 0 E - PerHostPeakMemUsage: 12.15 MB (12738328) E - RowsProduced: 12 (12) E - TotalNetworkReceiveTime: 25.999ms E - TotalNetworkSendTime: 2.999ms E - TotalStorageWaitTime: 135.999ms E - TotalThreadsInvoluntaryContextSwitches: 2 (2) E - TotalThreadsTotalWallClockTime: 327.998ms E - TotalThreadsSysTime: 22.338ms E - TotalThreadsUserTime: 14.347ms E - TotalThreadsVoluntaryContextSwitches: 35 (35) E - TotalTime: 105.999ms E Fragment Instance Lifecycle Timings: E - ExecTime: 2.999ms E - ExecTreeExecTime: 0.000ns E - InactiveTotalTime: 0.000ns E - OpenTime: 101.999ms E - ExecTreeOpenTime: 101.999ms E - PrepareTime: 999.995us E - ExecTreePrepareTime: 999.995us E - TotalTime: 0.000ns E KrpcDataStreamSender (dst_id=5):(Total: 2.999ms, non-child: 0.000ns, % non-child: 0.00%) E ExecOption: Codegen Disabled: disabled by query option DISABLE_CODEGEN E - NetworkThroughput: (Avg: 59.92 KB/sec ; Min: 59.92 KB/sec ; Max: 59.92 KB/sec ; Number of samples: 1) E - RpcNetworkTime: (Avg: 1.190ms ; Min: 98.660us ; Max: 2.281ms ; Number of samples: 2) E - RpcRecvrTime: (Avg: 64.783us ; Min: 46.346us ; Max: 83.221us ; Number of samples: 2) E - EosSent: 1 (1) E - InactiveTotalTime: 2.999ms E - PeakMemoryUsage: 7.52 KB (7704) E - RowsSent: 12 (12) E - RpcFailure: 0 (0) E - RpcRetry: 0 (0) E - SerializeBatchTime: 0.000ns E - TotalBytesSent: 140.00 B (140) E - TotalTime: 2.999ms E - UncompressedRowBatchSize: 300.00 B (300) E SORT_NODE (id=3):(Total: 102.999ms, non-child: 0.000ns, % non-child: 0.00%) E SortType: Total E ExecOption: Codegen Disabled: disabled by query option DISABLE_CODEGEN E Node Lifecycle Event Timeline: 109.999ms E - Open Started: 7.999ms (7.999ms) E - Open Finished: 109.999ms (101.999ms) E - First Batch Requested: 109.999ms (0.000ns) E - First Batch Returned: 109.999ms (0.000ns) E - Last Batch Returned: 109.999ms (0.000ns) E - Closed: 109.999ms (0.000ns) E - AddBatchTime: (Avg: 0.000ns ; Min: 0.000ns ; Max: 0.000ns ; Number of samples: 2) E - NumRowsPerRun: (Avg: 12 (12) ; Min: 12 (12) ; Max: 12 (12) ; Number of samples: 1) E - InMemorySortTime: 0.000ns E - InactiveTotalTime: 0.000ns E - InitialRunsCreated: 1 (1) E - PeakMemoryUsage: 6.08 MB (6373376) E - RowsReturned: 12 (12) E - RowsReturnedRate: 116.00 /sec E - SortDataSize: 204.00 B (204) E - SpilledRuns: 0 (0) E - TotalMergesPerformed: 0 (0) E - TotalTime: 102.999ms 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: 102.999ms, non-child: 0.000ns, % non-child: 0.00%) E ExecOption: Codegen Disabled: disabled by query option DISABLE_CODEGEN, Join Build-Side Prepared Asynchronously E Node Lifecycle Event Timeline: 109.999ms E - Open Started: 7.999ms (7.999ms) E - Open Finished: 92.999ms (84.999ms) E - First Batch Requested: 93.999ms (999.995us) E - First Batch Returned: 109.999ms (15.999ms) E - Last Batch Returned: 109.999ms (0.000ns) E - Closed: 109.999ms (0.000ns) E - InactiveTotalTime: 0.000ns E - PeakMemoryUsage: 2.01 MB (2105600) E - ProbeRows: 12 (12) E - ProbeRowsPartitioned: 0 (0) E - ProbeTime: 0.000ns E - RowsReturned: 12 (12) E - RowsReturnedRate: 116.00 /sec E - TotalTime: 102.999ms E Buffer pool: E - AllocTime: 0.000ns E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 1.00 MB (1048576) E - CumulativeAllocations: 16 (16) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 1.94 MB (2031616) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 1.00 MB (1048576) 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: 3.999ms, non-child: 3.999ms, % non-child: 100.00%) E ExecOption: Codegen Disabled: disabled by query option DISABLE_CODEGEN E Runtime filters: 8 of 8 Runtime Filters Published E - BuildRows: 40 (40) E - BuildRowsPartitionTime: 0.000ns E - HashTablesBuildTime: 999.996us E - InactiveTotalTime: 0.000ns E - LargestPartitionPercent: 20 (20) E - MaxPartitionLevel: 0 (0) E - NumHashTableBuildsSkipped: 0 (0) E - NumRepartitions: 0 (0) E - PartitionsCreated: 16 (16) E - PeakMemoryUsage: 32.12 KB (32896) E - RepartitionTime: 0.000ns E - SpilledPartitions: 0 (0) E - TotalTime: 3.999ms E Hash Table: E - HashBuckets: 73 (73) E - HashCollisions: 0 (0) E - InactiveTotalTime: 0.000ns E - Probes: 52 (52) E - Resizes: 0 (0) E - TotalTime: 0.000ns E - Travel: 13 (13) E EXCHANGE_NODE (id=4):(Total: 25.999ms, non-child: 0.000ns, % non-child: 0.00%) E Node Lifecycle Event Timeline: 38.999ms E - Open Started: 8.999ms (8.999ms) E - Open Finished: 9.999ms (999.995us) E - First Batch Requested: 12.999ms (2.999ms) E - First Batch Returned: 37.999ms (24.999ms) E - Last Batch Returned: 37.999ms (0.000ns) E - Closed: 38.999ms (999.996us) E - ConvertRowBatchTime: 0.000ns E - InactiveTotalTime: 25.999ms E - PeakMemoryUsage: 88.00 KB (90112) E - RowsReturned: 40 (40) E - RowsReturnedRate: 1.54 K/sec E - TotalTime: 25.999ms E Buffer pool: E - AllocTime: 0.000ns E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 160.00 KB (163840) E - CumulativeAllocations: 20 (20) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 88.00 KB (90112) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 88.00 KB (90112) 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: 999.995us E - InactiveTotalTime: 0.000ns E - TotalBytesDequeued: 960.00 B (960) E - TotalGetBatchTime: 25.999ms E - DataWaitTime: 25.999ms E - TotalTime: 0.000ns E Enqueue: E - DispatchTime: (Avg: 187.903us ; Min: 37.865us ; Max: 843.964us ; Number of samples: 10) E - DeserializeRowBatchTime: 0.000ns E - InactiveTotalTime: 0.000ns E - TotalBatchesEnqueued: 10 (10) E - TotalBatchesReceived: 10 (10) E - TotalBytesReceived: 462.00 B (462) E - TotalEarlySenders: 0 (0) E - TotalEosReceived: 3 (3) E - TotalHasDeferredRPCsTime: 0.000ns E - TotalRPCsDeferred: 0 (0) E - TotalTime: 0.000ns E KUDU_SCAN_NODE (id=0):(Total: 104.999ms, non-child: 104.999ms, % non-child: 100.00%) E Table Name: functional_kudu.decimal_rtf_tbl E Runtime filters: All filters arrived. Waited 22ms. Maximum arrival delay: 39ms. E Node Lifecycle Event Timeline: 109.999ms E - Open Started: 15.999ms (15.999ms) E - Open Finished: 79.999ms (63.999ms) E - First Batch Requested: 90.999ms (10.999ms) E - First Batch Returned: 92.999ms (1.999ms) E - Last Batch Returned: 109.999ms (16.999ms) E - Closed: 109.999ms (0.000ns) E - AverageScannerThreadConcurrency: 0.00 E - InactiveTotalTime: 0.000ns E - KuduClientTime: 135.999ms E - KuduRemoteScanTokens: 0 (0) E - MaterializeTupleTime: 0.000ns E - NumScannerThreadMemUnavailable: 0 (0) E - NumScannerThreadsStarted: 4 (4) E - PeakMemoryUsage: 48.00 KB (49152) E - PeakScannerThreadConcurrency: 4 (4) E - RowBatchBytesEnqueued: 64.00 KB (65536) E - RowBatchQueueGetWaitTime: 17.999ms E - RowBatchQueuePeakMemoryUsage: 48.00 KB (49152) E - RowBatchQueuePutWaitTime: 0.000ns E - RowBatchesEnqueued: 4 (4) E - RowsRead: 12 (12) E - RowsReturned: 12 (12) E - RowsReturnedRate: 114.00 /sec E - ScanRangesComplete: 4 (4) E - ScannerThreadsInvoluntaryContextSwitches: 2 (2) E - ScannerThreadsTotalWallClockTime: 140.999ms E - ScannerThreadsSysTime: 21.151ms E - ScannerThreadsUserTime: 8.961ms E - ScannerThreadsVoluntaryContextSwitches: 7 (7) E - TotalKuduScanRoundTrips: 4 (4) E - TotalTime: 104.999ms 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 Filter 1 (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 Filter 2 (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 Filter 3 (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 Instance b640be200cbf18f1:50e209bd00000005 (host=impala-ec2-centos74-m5-4xlarge-ondemand-0366.vpc.cloudera.com:22002):(Total: 86.999ms, non-child: 0.000ns, % non-child: 0.00%) E Last report received time: 2020-09-28 09:50:01.151 E Hdfs split stats (:<# splits>/): E Fragment Instance Lifecycle Event Timeline: 88.999ms E - Prepare Finished: 2.999ms (2.999ms) E - Open Finished: 86.999ms (83.999ms) E - First Batch Produced: 86.999ms (0.000ns) E - First Batch Sent: 86.999ms (0.000ns) E - ExecInternal Finished: 88.999ms (1.999ms) E - AverageThreadTokens: 0.00 E - BytesAssigned: 0 E - CompletionTime: 93.999ms E - ExchangeScanRatio: 0.00 E - ExecutionRate: 0.00 /sec E - InactiveTotalTime: 0.000ns E - PeakMemoryUsage: 8.08 MB (8470296) E - PeakReservation: 7.94 MB (8323072) E - PeakUsedReservation: 0 E - PerHostPeakMemUsage: 12.16 MB (12754712) E - RowsProduced: 13 (13) E - TotalNetworkReceiveTime: 21.999ms E - TotalNetworkSendTime: 1.999ms E - TotalStorageWaitTime: 113.999ms E - TotalThreadsInvoluntaryContextSwitches: 2 (2) E - TotalThreadsTotalWallClockTime: 226.998ms E - TotalThreadsSysTime: 17.786ms E - TotalThreadsUserTime: 11.087ms E - TotalThreadsVoluntaryContextSwitches: 21 (21) E - TotalTime: 86.999ms E Fragment Instance Lifecycle Timings: E - ExecTime: 1.999ms E - ExecTreeExecTime: 0.000ns E - InactiveTotalTime: 0.000ns E - OpenTime: 83.999ms E - ExecTreeOpenTime: 83.999ms E - PrepareTime: 999.995us E - ExecTreePrepareTime: 999.995us E - TotalTime: 0.000ns E KrpcDataStreamSender (dst_id=5):(Total: 1.999ms, non-child: 0.000ns, % non-child: 0.00%) E ExecOption: Codegen Disabled: disabled by query option DISABLE_CODEGEN E - NetworkThroughput: (Avg: 162.32 KB/sec ; Min: 162.32 KB/sec ; Max: 162.32 KB/sec ; Number of samples: 1) E - RpcNetworkTime: (Avg: 464.056us ; Min: 67.798us ; Max: 860.315us ; Number of samples: 2) E - RpcRecvrTime: (Avg: 81.734us ; Min: 47.315us ; Max: 116.153us ; Number of samples: 2) E - EosSent: 1 (1) E - InactiveTotalTime: 1.999ms E - PeakMemoryUsage: 7.52 KB (7704) E - RowsSent: 13 (13) E - RpcFailure: 0 (0) E - RpcRetry: 0 (0) E - SerializeBatchTime: 0.000ns E - TotalBytesSent: 143.00 B (143) E - TotalTime: 1.999ms E - UncompressedRowBatchSize: 325.00 B (325) E SORT_NODE (id=3):(Total: 84.999ms, non-child: 0.000ns, % non-child: 0.00%) E SortType: Total E ExecOption: Codegen Disabled: disabled by query option DISABLE_CODEGEN E Node Lifecycle Event Timeline: 86.999ms E - Open Started: 2.999ms (2.999ms) E - Open Finished: 86.999ms (83.999ms) E - First Batch Requested: 86.999ms (0.000ns) E - First Batch Returned: 86.999ms (0.000ns) E - Last Batch Returned: 86.999ms (0.000ns) E - Closed: 86.999ms (0.000ns) E - AddBatchTime: (Avg: 0.000ns ; Min: 0.000ns ; Max: 0.000ns ; Number of samples: 2) E - NumRowsPerRun: (Avg: 13 (13) ; Min: 13 (13) ; Max: 13 (13) ; Number of samples: 1) E - InMemorySortTime: 0.000ns E - InactiveTotalTime: 0.000ns E - InitialRunsCreated: 1 (1) E - PeakMemoryUsage: 6.06 MB (6356992) E - RowsReturned: 13 (13) E - RowsReturnedRate: 152.00 /sec E - SortDataSize: 221.00 B (221) E - SpilledRuns: 0 (0) E - TotalMergesPerformed: 0 (0) E - TotalTime: 84.999ms 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: 84.999ms, non-child: 0.000ns, % non-child: 0.00%) E ExecOption: Codegen Disabled: disabled by query option DISABLE_CODEGEN, Join Build-Side Prepared Asynchronously E Node Lifecycle Event Timeline: 86.999ms E - Open Started: 2.999ms (2.999ms) E - Open Finished: 70.999ms (67.999ms) E - First Batch Requested: 71.999ms (999.995us) E - First Batch Returned: 86.999ms (14.999ms) E - Last Batch Returned: 86.999ms (0.000ns) E - Closed: 86.999ms (0.000ns) E - InactiveTotalTime: 0.000ns E - PeakMemoryUsage: 2.01 MB (2105600) E - ProbeRows: 13 (13) E - ProbeRowsPartitioned: 0 (0) E - ProbeTime: 0.000ns E - RowsReturned: 13 (13) E - RowsReturnedRate: 152.00 /sec E - TotalTime: 84.999ms E Buffer pool: E - AllocTime: 0.000ns E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 1.00 MB (1048576) E - CumulativeAllocations: 16 (16) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 1.94 MB (2031616) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 1.00 MB (1048576) 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: 3.999ms, non-child: 3.999ms, % non-child: 100.00%) E ExecOption: Codegen Disabled: disabled by query option DISABLE_CODEGEN E Runtime filters: 8 of 8 Runtime Filters Published E - BuildRows: 40 (40) E - BuildRowsPartitionTime: 999.995us E - HashTablesBuildTime: 0.000ns E - InactiveTotalTime: 0.000ns E - LargestPartitionPercent: 20 (20) E - MaxPartitionLevel: 0 (0) E - NumHashTableBuildsSkipped: 0 (0) E - NumRepartitions: 0 (0) E - PartitionsCreated: 16 (16) E - PeakMemoryUsage: 32.12 KB (32896) E - RepartitionTime: 0.000ns E - SpilledPartitions: 0 (0) E - TotalTime: 3.999ms E Hash Table: E - HashBuckets: 73 (73) E - HashCollisions: 0 (0) E - InactiveTotalTime: 0.000ns E - Probes: 53 (53) E - Resizes: 0 (0) E - TotalTime: 0.000ns E - Travel: 11 (11) E EXCHANGE_NODE (id=4):(Total: 21.999ms, non-child: 0.000ns, % non-child: 0.00%) E Node Lifecycle Event Timeline: 35.999ms E - Open Started: 9.999ms (9.999ms) E - Open Finished: 9.999ms (0.000ns) E - First Batch Requested: 12.999ms (2.999ms) E - First Batch Returned: 34.999ms (21.999ms) E - Last Batch Returned: 34.999ms (0.000ns) E - Closed: 35.999ms (999.995us) E - ConvertRowBatchTime: 0.000ns E - InactiveTotalTime: 21.999ms E - PeakMemoryUsage: 88.00 KB (90112) E - RowsReturned: 40 (40) E - RowsReturnedRate: 1.82 K/sec E - TotalTime: 21.999ms E Buffer pool: E - AllocTime: 0.000ns E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 160.00 KB (163840) E - CumulativeAllocations: 20 (20) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 88.00 KB (90112) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 88.00 KB (90112) 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: 0.000ns E - InactiveTotalTime: 0.000ns E - TotalBytesDequeued: 960.00 B (960) E - TotalGetBatchTime: 21.999ms E - DataWaitTime: 21.999ms E - TotalTime: 0.000ns E Enqueue: E - DispatchTime: (Avg: 56.390us ; Min: 35.560us ; Max: 101.506us ; Number of samples: 10) E - DeserializeRowBatchTime: 0.000ns E - InactiveTotalTime: 0.000ns E - TotalBatchesEnqueued: 10 (10) E - TotalBatchesReceived: 10 (10) E - TotalBytesReceived: 462.00 B (462) E - TotalEarlySenders: 0 (0) E - TotalEosReceived: 3 (3) E - TotalHasDeferredRPCsTime: 0.000ns E - TotalRPCsDeferred: 0 (0) E - TotalTime: 0.000ns E KUDU_SCAN_NODE (id=0):(Total: 101.999ms, non-child: 101.999ms, % non-child: 100.00%) E Table Name: functional_kudu.decimal_rtf_tbl E Runtime filters: All filters arrived. Waited 26ms. Maximum arrival delay: 37ms. E Node Lifecycle Event Timeline: 86.999ms E - Open Started: 9.999ms (9.999ms) E - Open Finished: 39.999ms (29.999ms) E - First Batch Requested: 39.999ms (0.000ns) E - First Batch Returned: 70.999ms (30.999ms) E - Last Batch Returned: 86.999ms (15.999ms) E - Closed: 86.999ms (0.000ns) E - AverageScannerThreadConcurrency: 0.00 E - InactiveTotalTime: 0.000ns E - KuduClientTime: 113.999ms E - KuduRemoteScanTokens: 0 (0) E - MaterializeTupleTime: 0.000ns E - NumScannerThreadMemUnavailable: 0 (0) E - NumScannerThreadsStarted: 3 (3) E - PeakMemoryUsage: 24.00 KB (24576) E - PeakScannerThreadConcurrency: 3 (3) E - RowBatchBytesEnqueued: 48.00 KB (49152) E - RowBatchQueueGetWaitTime: 44.999ms E - RowBatchQueuePeakMemoryUsage: 24.00 KB (24576) E - RowBatchQueuePutWaitTime: 0.000ns E - RowBatchesEnqueued: 3 (3) E - RowsRead: 13 (13) E - RowsReturned: 13 (13) E - RowsReturnedRate: 127.00 /sec E - ScanRangesComplete: 3 (3) E - ScannerThreadsInvoluntaryContextSwitches: 2 (2) E - ScannerThreadsTotalWallClockTime: 114.999ms E - ScannerThreadsSysTime: 15.756ms E - ScannerThreadsUserTime: 7.326ms E - ScannerThreadsVoluntaryContextSwitches: 3 (3) E - TotalKuduScanRoundTrips: 3 (3) E - TotalTime: 101.999ms 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 Filter 1 (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 Filter 2 (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 Filter 3 (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 Instance b640be200cbf18f1:50e209bd00000004 (host=impala-ec2-centos74-m5-4xlarge-ondemand-0366.vpc.cloudera.com:22000):(Total: 85.999ms, non-child: 0.000ns, % non-child: 0.00%) E Last report received time: 2020-09-28 09:50:01.207 E Hdfs split stats (:<# splits>/): E Fragment Instance Lifecycle Event Timeline: 92.999ms E - Prepare Finished: 7.999ms (7.999ms) E - Open Finished: 91.999ms (83.999ms) E - First Batch Produced: 91.999ms (0.000ns) E - First Batch Sent: 91.999ms (0.000ns) E - ExecInternal Finished: 92.999ms (999.995us) E - AverageThreadTokens: 0.00 E - BytesAssigned: 0 E - CompletionTime: 154.999ms E - ExchangeScanRatio: 0.00 E - ExecutionRate: 0.00 /sec E - InactiveTotalTime: 0.000ns E - PeakMemoryUsage: 8.08 MB (8470296) E - PeakReservation: 7.94 MB (8323072) E - PeakUsedReservation: 0 E - PerHostPeakMemUsage: 12.13 MB (12721944) E - RowsProduced: 13 (13) E - TotalNetworkReceiveTime: 19.999ms E - TotalNetworkSendTime: 999.995us E - TotalStorageWaitTime: 98.999ms E - TotalThreadsInvoluntaryContextSwitches: 8 (8) E - TotalThreadsTotalWallClockTime: 210.999ms E - TotalThreadsSysTime: 13.460ms E - TotalThreadsUserTime: 13.438ms E - TotalThreadsVoluntaryContextSwitches: 20 (20) E - TotalTime: 85.999ms E Fragment Instance Lifecycle Timings: E - ExecTime: 999.995us E - ExecTreeExecTime: 0.000ns E - InactiveTotalTime: 0.000ns E - OpenTime: 83.999ms E - ExecTreeOpenTime: 83.999ms E - PrepareTime: 999.996us E - ExecTreePrepareTime: 999.996us E - TotalTime: 0.000ns E KrpcDataStreamSender (dst_id=5):(Total: 999.995us, non-child: 0.000ns, % non-child: 0.00%) E ExecOption: Codegen Disabled: disabled by query option DISABLE_CODEGEN E - NetworkThroughput: (Avg: 218.34 KB/sec ; Min: 218.34 KB/sec ; Max: 218.34 KB/sec ; Number of samples: 1) E - RpcNetworkTime: (Avg: 328.528us ; Min: 75.618us ; Max: 581.439us ; Number of samples: 2) E - RpcRecvrTime: (Avg: 69.759us ; Min: 49.814us ; Max: 89.705us ; Number of samples: 2) E - EosSent: 1 (1) E - InactiveTotalTime: 999.995us E - PeakMemoryUsage: 7.52 KB (7704) E - RowsSent: 13 (13) E - RpcFailure: 0 (0) E - RpcRetry: 0 (0) E - SerializeBatchTime: 0.000ns E - TotalBytesSent: 130.00 B (130) E - TotalTime: 999.995us E - UncompressedRowBatchSize: 325.00 B (325) E SORT_NODE (id=3):(Total: 84.999ms, non-child: 0.000ns, % non-child: 0.00%) E SortType: Total E ExecOption: Codegen Disabled: disabled by query option DISABLE_CODEGEN E Node Lifecycle Event Timeline: 91.999ms E - Open Started: 7.999ms (7.999ms) E - Open Finished: 91.999ms (83.999ms) E - First Batch Requested: 91.999ms (0.000ns) E - First Batch Returned: 91.999ms (0.000ns) E - Last Batch Returned: 91.999ms (0.000ns) E - Closed: 91.999ms (0.000ns) E - AddBatchTime: (Avg: 0.000ns ; Min: 0.000ns ; Max: 0.000ns ; Number of samples: 2) E - NumRowsPerRun: (Avg: 13 (13) ; Min: 13 (13) ; Max: 13 (13) ; Number of samples: 1) E - InMemorySortTime: 0.000ns E - InactiveTotalTime: 0.000ns E - InitialRunsCreated: 1 (1) E - PeakMemoryUsage: 6.06 MB (6356992) E - RowsReturned: 13 (13) E - RowsReturnedRate: 152.00 /sec E - SortDataSize: 221.00 B (221) E - SpilledRuns: 0 (0) E - TotalMergesPerformed: 0 (0) E - TotalTime: 84.999ms 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: 84.999ms, non-child: 0.000ns, % non-child: 0.00%) E ExecOption: Codegen Disabled: disabled by query option DISABLE_CODEGEN, Join Build-Side Prepared Asynchronously E Node Lifecycle Event Timeline: 91.999ms E - Open Started: 7.999ms (7.999ms) E - Open Finished: 76.999ms (68.999ms) E - First Batch Requested: 76.999ms (0.000ns) E - First Batch Returned: 91.999ms (14.999ms) E - Last Batch Returned: 91.999ms (0.000ns) E - Closed: 91.999ms (0.000ns) E - InactiveTotalTime: 0.000ns E - PeakMemoryUsage: 2.01 MB (2105600) E - ProbeRows: 13 (13) E - ProbeRowsPartitioned: 0 (0) E - ProbeTime: 0.000ns E - RowsReturned: 13 (13) E - RowsReturnedRate: 152.00 /sec E - TotalTime: 84.999ms E Buffer pool: E - AllocTime: 0.000ns E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 1.00 MB (1048576) E - CumulativeAllocations: 16 (16) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 1.94 MB (2031616) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 1.00 MB (1048576) 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: 3.999ms, non-child: 3.999ms, % non-child: 100.00%) E ExecOption: Codegen Disabled: disabled by query option DISABLE_CODEGEN E Runtime filters: 8 of 8 Runtime Filters Published E - BuildRows: 40 (40) E - BuildRowsPartitionTime: 0.000ns E - HashTablesBuildTime: 0.000ns E - InactiveTotalTime: 0.000ns E - LargestPartitionPercent: 20 (20) E - MaxPartitionLevel: 0 (0) E - NumHashTableBuildsSkipped: 0 (0) E - NumRepartitions: 0 (0) E - PartitionsCreated: 16 (16) E - PeakMemoryUsage: 32.12 KB (32896) E - RepartitionTime: 0.000ns E - SpilledPartitions: 0 (0) E - TotalTime: 3.999ms E Hash Table: E - HashBuckets: 73 (73) E - HashCollisions: 0 (0) E - InactiveTotalTime: 0.000ns E - Probes: 53 (53) E - Resizes: 0 (0) E - TotalTime: 0.000ns E - Travel: 13 (13) E EXCHANGE_NODE (id=4):(Total: 19.999ms, non-child: 0.000ns, % non-child: 0.00%) E Node Lifecycle Event Timeline: 40.999ms E - Open Started: 17.999ms (17.999ms) E - Open Finished: 17.999ms (0.000ns) E - First Batch Requested: 19.999ms (1.999ms) E - First Batch Returned: 39.999ms (19.999ms) E - Last Batch Returned: 39.999ms (0.000ns) E - Closed: 40.999ms (999.996us) E - ConvertRowBatchTime: 0.000ns E - InactiveTotalTime: 19.999ms E - PeakMemoryUsage: 104.00 KB (106496) E - RowsReturned: 40 (40) E - RowsReturnedRate: 2.00 K/sec E - TotalTime: 19.999ms E Buffer pool: E - AllocTime: 0.000ns E - CompressionTime: 0.000ns E - CumulativeAllocationBytes: 160.00 KB (163840) E - CumulativeAllocations: 20 (20) E - EncryptionTime: 0.000ns E - InactiveTotalTime: 0.000ns E - PeakReservation: 104.00 KB (106496) E - PeakUnpinnedBytes: 0 E - PeakUsedReservation: 104.00 KB (106496) 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: 0.000ns E - InactiveTotalTime: 0.000ns E - TotalBytesDequeued: 960.00 B (960) E - TotalGetBatchTime: 19.999ms E - DataWaitTime: 19.999ms E - TotalTime: 0.000ns E Enqueue: E - DispatchTime: (Avg: 55.371us ; Min: 40.333us ; Max: 88.148us ; Number of samples: 10) E - DeserializeRowBatchTime: 0.000ns E - InactiveTotalTime: 0.000ns E - TotalBatchesEnqueued: 10 (10) E - TotalBatchesReceived: 10 (10) E - TotalBytesReceived: 462.00 B (462) E - TotalEarlySenders: 0 (0) E - TotalEosReceived: 3 (3) E - TotalHasDeferredRPCsTime: 0.000ns E - TotalRPCsDeferred: 0 (0) E - TotalTime: 0.000ns E KUDU_SCAN_NODE (id=0):(Total: 93.999ms, non-child: 93.999ms, % non-child: 100.00%) E Table Name: functional_kudu.decimal_rtf_tbl E Runtime filters: All filters arrived. Waited 22ms. Maximum arrival delay: 42ms. E Node Lifecycle Event Timeline: 91.999ms E - Open Started: 18.999ms (18.999ms) E - Open Finished: 59.999ms (40.999ms) E - First Batch Requested: 59.999ms (0.000ns) E - First Batch Returned: 76.999ms (16.999ms) E - Last Batch Returned: 90.999ms (13.999ms) E - Closed: 91.999ms (999.996us) E - AverageScannerThreadConcurrency: 0.00 E - InactiveTotalTime: 0.000ns E - KuduClientTime: 98.999ms E - KuduRemoteScanTokens: 0 (0) E - MaterializeTupleTime: 0.000ns E - NumScannerThreadMemUnavailable: 0 (0) E - NumScannerThreadsStarted: 3 (3) E - PeakMemoryUsage: 24.00 KB (24576) E - PeakScannerThreadConcurrency: 3 (3) E - RowBatchBytesEnqueued: 48.00 KB (49152) E - RowBatchQueueGetWaitTime: 29.999ms E - RowBatchQueuePeakMemoryUsage: 24.00 KB (24576) E - RowBatchQueuePutWaitTime: 0.000ns E - RowBatchesEnqueued: 3 (3) E - RowsRead: 13 (13) E - RowsReturned: 13 (13) E - RowsReturnedRate: 138.00 /sec E - ScanRangesComplete: 3 (3) E - ScannerThreadsInvoluntaryContextSwitches: 8 (8) E - ScannerThreadsTotalWallClockTime: 102.999ms E - ScannerThreadsSysTime: 11.031ms E - ScannerThreadsUserTime: 10.449ms E - ScannerThreadsVoluntaryContextSwitches: 4 (4) E - TotalKuduScanRoundTrips: 3 (3) E - TotalTime: 93.999ms 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 Filter 1 (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 Filter 2 (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 Filter 3 (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 [3 instances]:(Total: 26.666ms, non-child: 333.332us, % non-child: 1.25%) E split sizes: min: 0, max: 0, avg: 0, stddev: 0 E completion times: min:94.999ms max:154.999ms mean: 122.332ms stddev:24.783ms E execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec E num instances: 3 E - AverageThreadTokens: 0.00 E - BytesAssigned: 0 E - CompletionTime: 122.332ms E - ExchangeScanRatio: 0.00 E - ExecutionRate: 0.00 /sec E - InactiveTotalTime: 0.000ns E - PeakMemoryUsage: 80.00 KB (81920) E - PeakReservation: 0 E - PeakUsedReservation: 0 E - PerHostPeakMemUsage: 12.15 MB (12738328) E - RowsProduced: 13 (13) E - TotalNetworkReceiveTime: 0.000ns E - TotalNetworkSendTime: 11.999ms E - TotalStorageWaitTime: 25.666ms E - TotalThreadsInvoluntaryContextSwitches: 0 (0) E - TotalThreadsTotalWallClockTime: 58.999ms E - TotalThreadsSysTime: 0.000ns E - TotalThreadsUserTime: 2.090ms E - TotalThreadsVoluntaryContextSwitches: 15 (15) E - TotalTime: 26.666ms E Fragment Instance Lifecycle Timings [3 instances]: E - ExecTime: 18.333ms E - ExecTreeExecTime: 5.333ms E - InactiveTotalTime: 0.000ns E - OpenTime: 8.333ms E - ExecTreeOpenTime: 8.333ms E - PrepareTime: 0.000ns E - ExecTreePrepareTime: 0.000ns E - TotalTime: 0.000ns E KrpcDataStreamSender (dst_id=4) [3 instances]:(Total: 12.666ms, non-child: 666.664us, % non-child: 5.26%) E - EosSent: 3 (3) E - InactiveTotalTime: 11.999ms E - PeakMemoryUsage: 24.00 KB (24576) E - RowsSent: 13 (13) E - RpcFailure: 0 (0) E - RpcRetry: 0 (0) E - SerializeBatchTime: 0.000ns E - TotalBytesSent: 462.00 B (462) E - TotalTime: 12.666ms E - UncompressedRowBatchSize: 960.00 B (960) E KUDU_SCAN_NODE (id=1) [3 instances]:(Total: 13.666ms, non-child: 13.666ms, % non-child: 100.00%) E - AverageScannerThreadConcurrency: 0.00 E - InactiveTotalTime: 0.000ns E - KuduClientTime: 25.666ms E - KuduRemoteScanTokens: 0 (0) E - MaterializeTupleTime: 0.000ns E - NumScannerThreadMemUnavailable: 0 (0) E - NumScannerThreadsStarted: 3 (3) E - PeakMemoryUsage: 48.00 KB (49152) E - PeakScannerThreadConcurrency: 3 (3) E - RowBatchBytesEnqueued: 53.33 KB (54613) E - RowBatchQueueGetWaitTime: 5.333ms E - RowBatchQueuePeakMemoryUsage: 48.00 KB (49152) E - RowBatchQueuePutWaitTime: 0.000ns E - RowBatchesEnqueued: 3 (3) E - RowsRead: 13 (13) E - RowsReturned: 13 (13) E - RowsReturnedRate: 981.00 /sec E - ScanRangesComplete: 3 (3) E - ScannerThreadsInvoluntaryContextSwitches: 0 (0) E - ScannerThreadsTotalWallClockTime: 32.333ms E - ScannerThreadsSysTime: 0.000ns E - ScannerThreadsUserTime: 881.000us E - ScannerThreadsVoluntaryContextSwitches: 4 (4) E - TotalKuduScanRoundTrips: 3 (3) E - TotalTime: 13.666ms E Fragment F01: E - InactiveTotalTime: 0.000ns E - TotalTime: 0.000ns E Instance b640be200cbf18f1:50e209bd00000002 (host=impala-ec2-centos74-m5-4xlarge-ondemand-0366.vpc.cloudera.com:22002):(Total: 38.999ms, non-child: 0.000ns, % non-child: 0.00%) E Last report received time: 2020-09-28 09:50:01.152 E Hdfs split stats (:<# splits>/): E Fragment Instance Lifecycle Event Timeline: 39.999ms E - Prepare Finished: 999.995us (999.995us) E - Open Finished: 15.999ms (14.999ms) E - First Batch Produced: 15.999ms (0.000ns) E - First Batch Sent: 15.999ms (0.000ns) E - ExecInternal Finished: 39.999ms (23.999ms) E - AverageThreadTokens: 0.00 E - BytesAssigned: 0 E - CompletionTime: 94.999ms E - ExchangeScanRatio: 0.00 E - ExecutionRate: 0.00 /sec E - InactiveTotalTime: 0.000ns E - PeakMemoryUsage: 80.00 KB (81920) E - PeakReservation: 0 E - PeakUsedReservation: 0 E - PerHostPeakMemUsage: 12.16 MB (12754712) E - RowsProduced: 14 (14) E - TotalNetworkReceiveTime: 0.000ns E - TotalNetworkSendTime: 22.999ms E - TotalStorageWaitTime: 19.999ms E - TotalThreadsInvoluntaryContextSwitches: 0 (0) E - TotalThreadsTotalWallClockTime: 78.999ms E - TotalThreadsSysTime: 0.000ns E - TotalThreadsUserTime: 2.116ms E - TotalThreadsVoluntaryContextSwitches: 15 (15) E - TotalTime: 38.999ms E Fragment Instance Lifecycle Timings: E - ExecTime: 23.999ms E - ExecTreeExecTime: 0.000ns E - InactiveTotalTime: 0.000ns E - OpenTime: 14.999ms E - ExecTreeOpenTime: 14.999ms E - PrepareTime: 0.000ns E - ExecTreePrepareTime: 0.000ns E - TotalTime: 0.000ns E KrpcDataStreamSender (dst_id=4):(Total: 23.999ms, non-child: 999.996us, % non-child: 4.17%) E ExecOption: Codegen Disabled: disabled by query option DISABLE_CODEGEN E - NetworkThroughput: (Avg: 123.62 KB/sec ; Min: 3.35 KB/sec ; Max: 252.72 KB/sec ; Number of samples: 9) E - RpcNetworkTime: (Avg: 2.518ms ; Min: 200.940us ; Max: 18.351ms ; Number of samples: 12) E - RpcRecvrTime: (Avg: 186.217us ; Min: 40.439us ; Max: 875.973us ; Number of samples: 12) E - EosSent: 3 (3) E - InactiveTotalTime: 22.999ms E - PeakMemoryUsage: 24.00 KB (24576) E - RowsSent: 14 (14) E - RpcFailure: 0 (0) E - RpcRetry: 0 (0) E - SerializeBatchTime: 0.000ns E - TotalBytesSent: 474.00 B (474) E - TotalTime: 23.999ms E - UncompressedRowBatchSize: 1008.00 B (1008) E KUDU_SCAN_NODE (id=1):(Total: 14.999ms, non-child: 14.999ms, % non-child: 100.00%) E Table Name: functional_kudu.decimal_rtf_tiny_tbl E Node Lifecycle Event Timeline: 34.999ms E - Open Started: 999.995us (999.995us) E - Open Finished: 15.999ms (14.999ms) E - First Batch Requested: 15.999ms (0.000ns) E - First Batch Returned: 15.999ms (0.000ns) E - Last Batch Returned: 34.999ms (18.999ms) E - Closed: 34.999ms (0.000ns) E - AverageScannerThreadConcurrency: 0.00 E - InactiveTotalTime: 0.000ns E - KuduClientTime: 19.999ms E - KuduRemoteScanTokens: 0 (0) E - MaterializeTupleTime: 0.000ns E - NumScannerThreadMemUnavailable: 0 (0) E - NumScannerThreadsStarted: 3 (3) E - PeakMemoryUsage: 48.00 KB (49152) E - PeakScannerThreadConcurrency: 3 (3) E - RowBatchBytesEnqueued: 48.00 KB (49152) E - RowBatchQueueGetWaitTime: 0.000ns E - RowBatchQueuePeakMemoryUsage: 48.00 KB (49152) E - RowBatchQueuePutWaitTime: 0.000ns E - RowBatchesEnqueued: 3 (3) E - RowsRead: 14 (14) E - RowsReturned: 14 (14) E - RowsReturnedRate: 933.00 /sec E - ScanRangesComplete: 3 (3) E - ScannerThreadsInvoluntaryContextSwitches: 0 (0) E - ScannerThreadsTotalWallClockTime: 39.999ms E - ScannerThreadsSysTime: 0.000ns E - ScannerThreadsUserTime: 832.000us E - ScannerThreadsVoluntaryContextSwitches: 5 (5) E - TotalKuduScanRoundTrips: 3 (3) E - TotalTime: 14.999ms E Instance b640be200cbf18f1:50e209bd00000003 (host=impala-ec2-centos74-m5-4xlarge-ondemand-0366.vpc.cloudera.com:22001):(Total: 23.999ms, non-child: 0.000ns, % non-child: 0.00%) E Last report received time: 2020-09-28 09:50:01.171 E Hdfs split stats (:<# splits>/): E Fragment Instance Lifecycle Event Timeline: 30.999ms E - Prepare Finished: 6.999ms (6.999ms) E - Open Finished: 14.999ms (7.999ms) E - First Batch Produced: 18.999ms (3.999ms) E - First Batch Sent: 18.999ms (0.000ns) E - ExecInternal Finished: 30.999ms (11.999ms) E - AverageThreadTokens: 0.00 E - BytesAssigned: 0 E - CompletionTime: 116.999ms E - ExchangeScanRatio: 0.00 E - ExecutionRate: 0.00 /sec E - InactiveTotalTime: 0.000ns E - PeakMemoryUsage: 104.00 KB (106496) E - PeakReservation: 0 E - PeakUsedReservation: 0 E - PerHostPeakMemUsage: 12.15 MB (12738328) E - RowsProduced: 13 (13) E - TotalNetworkReceiveTime: 0.000ns E - TotalNetworkSendTime: 10.999ms E - TotalStorageWaitTime: 29.999ms E - TotalThreadsInvoluntaryContextSwitches: 0 (0) E - TotalThreadsTotalWallClockTime: 53.999ms E - TotalThreadsSysTime: 0.000ns E - TotalThreadsUserTime: 2.274ms E - TotalThreadsVoluntaryContextSwitches: 17 (17) E - TotalTime: 23.999ms E Fragment Instance Lifecycle Timings: E - ExecTime: 15.999ms E - ExecTreeExecTime: 3.999ms E - InactiveTotalTime: 0.000ns E - OpenTime: 7.999ms E - ExecTreeOpenTime: 7.999ms E - PrepareTime: 0.000ns E - ExecTreePrepareTime: 0.000ns E - TotalTime: 0.000ns E KrpcDataStreamSender (dst_id=4):(Total: 11.999ms, non-child: 999.995us, % non-child: 8.33%) E ExecOption: Codegen Disabled: disabled by query option DISABLE_CODEGEN E - NetworkThroughput: (Avg: 107.86 KB/sec ; Min: 4.79 KB/sec ; Max: 278.51 KB/sec ; Number of samples: 12) E - RpcNetworkTime: (Avg: 1.064ms ; Min: 122.724us ; Max: 7.131ms ; Number of samples: 15) E - RpcRecvrTime: (Avg: 103.941us ; Min: 32.421us ; Max: 500.220us ; Number of samples: 15) E - EosSent: 3 (3) E - InactiveTotalTime: 10.999ms E - PeakMemoryUsage: 24.00 KB (24576) E - RowsSent: 13 (13) E - RpcFailure: 0 (0) E - RpcRetry: 0 (0) E - SerializeBatchTime: 0.000ns E - TotalBytesSent: 504.00 B (504) E - TotalTime: 11.999ms E - UncompressedRowBatchSize: 936.00 B (936) E KUDU_SCAN_NODE (id=1):(Total: 11.999ms, non-child: 11.999ms, % non-child: 100.00%) E Table Name: functional_kudu.decimal_rtf_tiny_tbl E Node Lifecycle Event Timeline: 28.999ms E - Open Started: 6.999ms (6.999ms) E - Open Finished: 14.999ms (7.999ms) E - First Batch Requested: 14.999ms (0.000ns) E - First Batch Returned: 18.999ms (3.999ms) E - Last Batch Returned: 28.999ms (9.999ms) E - Closed: 28.999ms (0.000ns) E - AverageScannerThreadConcurrency: 0.00 E - InactiveTotalTime: 0.000ns E - KuduClientTime: 29.999ms E - KuduRemoteScanTokens: 0 (0) E - MaterializeTupleTime: 0.000ns E - NumScannerThreadMemUnavailable: 0 (0) E - NumScannerThreadsStarted: 4 (4) E - PeakMemoryUsage: 72.00 KB (73728) E - PeakScannerThreadConcurrency: 4 (4) E - RowBatchBytesEnqueued: 64.00 KB (65536) E - RowBatchQueueGetWaitTime: 3.999ms E - RowBatchQueuePeakMemoryUsage: 72.00 KB (73728) E - RowBatchQueuePutWaitTime: 0.000ns E - RowBatchesEnqueued: 4 (4) E - RowsRead: 13 (13) E - RowsReturned: 13 (13) E - RowsReturnedRate: 1.08 K/sec E - ScanRangesComplete: 4 (4) E - ScannerThreadsInvoluntaryContextSwitches: 0 (0) E - ScannerThreadsTotalWallClockTime: 29.999ms E - ScannerThreadsSysTime: 0.000ns E - ScannerThreadsUserTime: 945.000us E - ScannerThreadsVoluntaryContextSwitches: 4 (4) E - TotalKuduScanRoundTrips: 4 (4) E - TotalTime: 11.999ms E Instance b640be200cbf18f1:50e209bd00000001 (host=impala-ec2-centos74-m5-4xlarge-ondemand-0366.vpc.cloudera.com:22000):(Total: 16.999ms, non-child: 999.996us, % non-child: 5.88%) E Last report received time: 2020-09-28 09:50:01.207 E Hdfs split stats (:<# splits>/): E Fragment Instance Lifecycle Event Timeline: 20.999ms E - Prepare Finished: 3.999ms (3.999ms) E - Open Finished: 5.999ms (1.999ms) E - First Batch Produced: 10.999ms (4.999ms) E - First Batch Sent: 10.999ms (0.000ns) E - ExecInternal Finished: 20.999ms (9.999ms) E - AverageThreadTokens: 0.00 E - BytesAssigned: 0 E - CompletionTime: 154.999ms E - ExchangeScanRatio: 0.00 E - ExecutionRate: 0.00 /sec E - InactiveTotalTime: 0.000ns E - PeakMemoryUsage: 56.00 KB (57344) E - PeakReservation: 0 E - PeakUsedReservation: 0 E - PerHostPeakMemUsage: 12.13 MB (12721944) E - RowsProduced: 13 (13) E - TotalNetworkReceiveTime: 0.000ns E - TotalNetworkSendTime: 1.999ms E - TotalStorageWaitTime: 26.999ms E - TotalThreadsInvoluntaryContextSwitches: 0 (0) E - TotalThreadsTotalWallClockTime: 43.999ms E - TotalThreadsSysTime: 0.000ns E - TotalThreadsUserTime: 1.880ms E - TotalThreadsVoluntaryContextSwitches: 15 (15) E - TotalTime: 16.999ms E Fragment Instance Lifecycle Timings: E - ExecTime: 14.999ms E - ExecTreeExecTime: 11.999ms E - InactiveTotalTime: 0.000ns E - OpenTime: 1.999ms E - ExecTreeOpenTime: 1.999ms E - PrepareTime: 0.000ns E - ExecTreePrepareTime: 0.000ns E - TotalTime: 0.000ns E KrpcDataStreamSender (dst_id=4):(Total: 1.999ms, non-child: 0.000ns, % non-child: 0.00%) E ExecOption: Codegen Disabled: disabled by query option DISABLE_CODEGEN E - NetworkThroughput: (Avg: 180.88 KB/sec ; Min: 14.66 KB/sec ; Max: 335.24 KB/sec ; Number of samples: 9) E - RpcNetworkTime: (Avg: 599.192us ; Min: 125.260us ; Max: 2.864ms ; Number of samples: 12) E - RpcRecvrTime: (Avg: 81.296us ; Min: 52.931us ; Max: 103.853us ; Number of samples: 12) E - EosSent: 3 (3) E - InactiveTotalTime: 1.999ms E - PeakMemoryUsage: 24.00 KB (24576) E - RowsSent: 13 (13) E - RpcFailure: 0 (0) E - RpcRetry: 0 (0) E - SerializeBatchTime: 0.000ns E - TotalBytesSent: 408.00 B (408) E - TotalTime: 1.999ms E - UncompressedRowBatchSize: 936.00 B (936) E KUDU_SCAN_NODE (id=1):(Total: 13.999ms, non-child: 13.999ms, % non-child: 100.00%) E Table Name: functional_kudu.decimal_rtf_tiny_tbl E Node Lifecycle Event Timeline: 18.999ms E - Open Started: 3.999ms (3.999ms) E - Open Finished: 5.999ms (1.999ms) E - First Batch Requested: 5.999ms (0.000ns) E - First Batch Returned: 10.999ms (4.999ms) E - Last Batch Returned: 18.999ms (7.999ms) E - Closed: 18.999ms (0.000ns) E - AverageScannerThreadConcurrency: 0.00 E - InactiveTotalTime: 0.000ns E - KuduClientTime: 26.999ms E - KuduRemoteScanTokens: 0 (0) E - MaterializeTupleTime: 0.000ns E - NumScannerThreadMemUnavailable: 0 (0) E - NumScannerThreadsStarted: 3 (3) E - PeakMemoryUsage: 24.00 KB (24576) E - PeakScannerThreadConcurrency: 3 (3) E - RowBatchBytesEnqueued: 48.00 KB (49152) E - RowBatchQueueGetWaitTime: 11.999ms E - RowBatchQueuePeakMemoryUsage: 24.00 KB (24576) E - RowBatchQueuePutWaitTime: 0.000ns E - RowBatchesEnqueued: 3 (3) E - RowsRead: 13 (13) E - RowsReturned: 13 (13) E - RowsReturnedRate: 928.00 /sec E - ScanRangesComplete: 3 (3) E - ScannerThreadsInvoluntaryContextSwitches: 0 (0) E - ScannerThreadsTotalWallClockTime: 26.999ms E - ScannerThreadsSysTime: 0.000ns E - ScannerThreadsUserTime: 866.000us E - ScannerThreadsVoluntaryContextSwitches: 3 (3) E - TotalKuduScanRoundTrips: 3 (3) E - TotalTime: 13.999ms