Query (id=2b4a14d9933eb108:7565b86500000000): DEBUG MODE WARNING: Query profile created while running a DEBUG build of Impala. Use RELEASE builds to measure query performance. Summary: Session ID: 96497109c3cd3d4a:8a0cb4017961658c Session Type: BEESWAX Start Time: 2019-01-18 00:09:20.021599000 End Time: Query Type: QUERY Query State: FINISHED Query Status: OK Impala Version: impalad version 3.2.0-SNAPSHOT DEBUG (build e9d62bd2339dd434437f8220bd89c276e7555c07) User: jenkins Connected User: jenkins Delegated User: Network Address: ::1:46296 Default Db: functional_kudu Sql Statement: select STRAIGHT_JOIN count(*) from decimal_rtf_tbl a join [BROADCAST] decimal_rtf_tiny_tbl b where a.d38_38 = b.d38_38 and b.d38_38 != 0 Coordinator: downstream-jenkins-host:22000 Query Options (set by configuration): ABORT_ON_ERROR=1,EXEC_SINGLE_NODE_ROWS_THRESHOLD=0,RUNTIME_FILTER_WAIT_TIME_MS=100000,DISABLE_CODEGEN_ROWS_THRESHOLD=0,CLIENT_IDENTIFIER=query_test/test_runtime_filters.py::TestMinMaxFilters::()::test_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;'debug_action':None;'exec_single_node_ Query Options (set by configuration and planner): ABORT_ON_ERROR=1,EXEC_SINGLE_NODE_ROWS_THRESHOLD=0,RUNTIME_FILTER_WAIT_TIME_MS=100000,MT_DOP=0,DISABLE_CODEGEN_ROWS_THRESHOLD=0,CLIENT_IDENTIFIER=query_test/test_runtime_filters.py::TestMinMaxFilters::()::test_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;'debug_action':None;'exec_single_node_ Plan: ---------------- Max Per-Host Resource Reservation: Memory=1.94MB Threads=5 Per-Host Resource Estimates: Memory=25MB Analyzed query: SELECT -- +straight_join count(*) FROM functional_kudu.decimal_rtf_tbl a INNER JOIN -- +BROADCAST functional_kudu.decimal_rtf_tiny_tbl b WHERE a.d38_38 = b.d38_38 AND b.d38_38 != CAST(0 AS DECIMAL(3,0)) F02:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1 | Per-Host Resources: mem-estimate=10.02MB mem-reservation=0B thread-reservation=1 PLAN-ROOT SINK | mem-estimate=0B mem-reservation=0B thread-reservation=0 | 06:AGGREGATE [FINALIZE] | output: count:merge(*) | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 | tuple-ids=2 row-size=8B cardinality=1 | in pipelines: 06(GETNEXT), 03(OPEN) | 05:EXCHANGE [UNPARTITIONED] | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 | tuple-ids=2 row-size=8B cardinality=1 | in pipelines: 03(GETNEXT) | F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 Per-Host Resources: mem-estimate=13.44MB mem-reservation=1.94MB thread-reservation=2 03:AGGREGATE | output: count(*) | mem-estimate=10.00MB mem-reservation=0B spill-buffer=2.00MB thread-reservation=0 | tuple-ids=2 row-size=8B cardinality=1 | in pipelines: 03(GETNEXT), 00(OPEN) | 02:HASH JOIN [INNER JOIN, BROADCAST] | hash predicates: a.d38_38 = b.d38_38 | fk/pk conjuncts: a.d38_38 = b.d38_38 | runtime filters: RF001[min_max] <- b.d38_38 | mem-estimate=1.94MB mem-reservation=1.94MB spill-buffer=64.00KB thread-reservation=0 | tuple-ids=0,1 row-size=32B cardinality=1 | in pipelines: 00(GETNEXT), 01(OPEN) | |--04:EXCHANGE [BROADCAST] | | mem-estimate=16.00KB mem-reservation=0B thread-reservation=0 | | tuple-ids=1 row-size=16B cardinality=4 | | in pipelines: 01(GETNEXT) | | | F01:PLAN FRAGMENT [RANDOM] hosts=3 instances=3 | Per-Host Resources: mem-estimate=1.50MB mem-reservation=0B thread-reservation=2 | 01:SCAN KUDU [functional_kudu.decimal_rtf_tiny_tbl b] | predicates: b.d38_38 != CAST(0 AS DECIMAL(3,0)) | mem-estimate=1.50MB mem-reservation=0B thread-reservation=1 | tuple-ids=1 row-size=16B cardinality=4 | in pipelines: 01(GETNEXT) | 00:SCAN KUDU [functional_kudu.decimal_rtf_tbl a] predicates: a.d38_38 != CAST(0 AS DECIMAL(3,0)) runtime filters: RF001[min_max] -> a.d38_38 mem-estimate=1.50MB mem-reservation=0B thread-reservation=1 tuple-ids=0 row-size=16B cardinality=140 in pipelines: 00(GETNEXT) ---------------- Estimated Per-Host Mem: 26165248 Per Host Min Memory Reservation: downstream-jenkins-host:22000(1.94 MB) downstream-jenkins-host:22001(1.94 MB) downstream-jenkins-host:22002(1.94 MB) Request Pool: default-pool Admission result: Admitted immediately Cluster Memory Admitted: 74.86 MB ExecSummary: Operator #Hosts Avg Time Max Time #Rows Est. #Rows Peak Mem Est. Peak Mem Detail ------------------------------------------------------------------------------------------------------------------------------------------- F02:ROOT 1 999.981us 999.981us 0 0 06:AGGREGATE 1 2.999ms 2.999ms 1 1 16.00 KB 10.00 MB FINALIZE 05:EXCHANGE 1 999.981us 999.981us 3 1 32.00 KB 16.00 KB UNPARTITIONED F00:EXCHANGE SENDER 3 0.000ns 0.000ns 16.00 KB 0 03:AGGREGATE 3 0.000ns 0.000ns 3 1 88.00 KB 10.00 MB 02:HASH JOIN 3 14.333ms 25.999ms 37 1 2.00 MB 1.94 MB INNER JOIN, BROADCAST |--04:EXCHANGE 3 1.333ms 1.999ms 39 4 160.00 KB 16.00 KB BROADCAST | F01:EXCHANGE SENDER 3 1.999ms 2.999ms 24.00 KB 0 | 01:SCAN KUDU 3 224.662ms 390.992ms 39 4 52.00 KB 1.50 MB functional_kudu.decimal_rtf_tiny_tbl b 00:SCAN KUDU 3 16s111ms 36s812ms 661 140 76.00 KB 1.50 MB functional_kudu.decimal_rtf_tbl a Errors: Query Compilation: 2.522ms - Metadata of all 2 tables cached: 318.221us (318.221us) - Analysis finished: 608.460us (290.239us) - Value transfer graph computed: 618.724us (10.264us) - Single node plan created: 1.907ms (1.288ms) - Runtime filters computed: 2.018ms (110.666us) - Distributed plan created: 2.031ms (12.946us) - Planning finished: 2.522ms (491.100us) Query Timeline: 1m47s - Query submitted: 0.000ns (0.000ns) - Planning finished: 3.999ms (3.999ms) - Submit for admission: 7.999ms (3.999ms) - Completed admission: 8.999ms (999.981us) - Ready to start on 3 backends: 12.999ms (3.999ms) - All 3 execution backends (7 fragment instances) started: 19.999ms (6.999ms) - Rows available: 1m47s (1m47s) - First row fetched: 1m47s (27.999ms) - Last row fetched: 1m47s (6.999ms) - Released admission control resources: 1m47s (14.999ms) - ComputeScanRangeAssignmentTimer: 999.981us Frontend: ImpalaServer: - ClientFetchWaitTimer: 27.999ms - RowMaterializationTimer: 35.999ms Execution Profile 2b4a14d9933eb108:7565b86500000000:(Total: 1m47s, non-child: 0.000ns, % non-child: 0.00%) Number of filters: 1 Filter routing table: ID Src. Node Tgt. Node(s) Target type Partition filter Pending (Expected) First arrived Completed Enabled ------------------------------------------------------------------------------------------------------------------- 1 2 0 LOCAL false 0 (3) N/A N/A true Backend startup latencies: Count: 3, min / max: 3ms / 5ms, 25th %-ile: 3ms, 50th %-ile: 4ms, 75th %-ile: 4ms, 90th %-ile: 5ms, 95th %-ile: 5ms, 99.9th %-ile: 5ms Slowest backend to start up: downstream-jenkins-host:22000 Final filter table: ID Src. Node Tgt. Node(s) Target type Partition filter Pending (Expected) First arrived Completed Enabled ------------------------------------------------------------------------------------------------------------------- 1 2 0 LOCAL false 0 (3) N/A N/A true Per Node Peak Memory Usage: downstream-jenkins-host:22000(5.75 MB) downstream-jenkins-host:22001(5.79 MB) downstream-jenkins-host:22002(5.69 MB) Per Node Bytes Read: downstream-jenkins-host:22000(0) downstream-jenkins-host:22001(0) downstream-jenkins-host:22002(0) Per Node User Time: downstream-jenkins-host:22000(2m38s) downstream-jenkins-host:22001(3m10s) downstream-jenkins-host:22002(1m56s) Per Node System Time: downstream-jenkins-host:22000(64.553ms) downstream-jenkins-host:22001(107.326ms) downstream-jenkins-host:22002(76.613ms) - FiltersReceived: 0 (0) - FinalizationTimer: 0.000ns - NumBackends: 3 (3) - NumFragmentInstances: 7 (7) - NumFragments: 3 (3) - TotalBytesRead: 0 - TotalCpuTime: 7m46s Averaged Fragment F02:(Total: 1m47s, non-child: 4.999ms, % non-child: 0.00%) split sizes: min: 0, max: 0, avg: 0, stddev: 0 completion times: min:1m47s max:1m47s mean: 1m47s stddev:0.000ns execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec num instances: 1 - AverageThreadTokens: 0.00 - BloomFilterBytes: 0 - PeakMemoryUsage: 56.00 KB (57344) - PeakReservation: 0 - PeakUsedReservation: 0 - PerHostPeakMemUsage: 5.75 MB (6031104) - RowsProduced: 1 (1) - TotalNetworkReceiveTime: 1m47s - TotalNetworkSendTime: 0.000ns - TotalStorageWaitTime: 0.000ns - TotalThreadsInvoluntaryContextSwitches: 10 (10) - TotalThreadsTotalWallClockTime: 1m47s - TotalThreadsSysTime: 995.000us - TotalThreadsUserTime: 212.405ms - TotalThreadsVoluntaryContextSwitches: 5 (5) Buffer pool: - AllocTime: 0.000ns - CumulativeAllocationBytes: 0 - CumulativeAllocations: 0 (0) - PeakReservation: 0 - PeakUnpinnedBytes: 0 - PeakUsedReservation: 0 - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - ReservationLimit: 0 - SystemAllocTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns Fragment Instance Lifecycle Timings: - ExecTime: 37.999ms - ExecTreeExecTime: 0.000ns - OpenTime: 1m47s - ExecTreeOpenTime: 1m47s - PrepareTime: 5.999ms - ExecTreePrepareTime: 2.999ms PLAN_ROOT_SINK:(Total: 37.999ms, non-child: 37.999ms, % non-child: 100.00%) - PeakMemoryUsage: 0 AGGREGATION_NODE (id=6):(Total: 1m47s, non-child: 2.999ms, % non-child: 0.00%) - PeakMemoryUsage: 16.00 KB (16384) - RowsReturned: 1 (1) - RowsReturnedRate: 0 NonGroupingAggregator 0: - BuildTime: 0.000ns - PeakMemoryUsage: 8.00 KB (8192) - RowsReturned: 1 (1) EXCHANGE_NODE (id=5):(Total: 1m47s, non-child: 1m47s, % non-child: 100.00%) - ConvertRowBatchTime: 0.000ns - PeakMemoryUsage: 32.00 KB (32768) - RowsReturned: 3 (3) - RowsReturnedRate: 0 Buffer pool: - AllocTime: 0.000ns - CumulativeAllocationBytes: 48.00 KB (49152) - CumulativeAllocations: 6 (6) - PeakReservation: 32.00 KB (32768) - PeakUnpinnedBytes: 0 - PeakUsedReservation: 32.00 KB (32768) - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - SystemAllocTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns Dequeue: - FirstBatchWaitTime: 1m42s - TotalBytesDequeued: 48.00 B (48) - TotalGetBatchTime: 1m47s - DataWaitTime: 1m47s Enqueue: - DeserializeRowBatchTime: 999.981us - TotalBatchesEnqueued: 3 (3) - TotalBatchesReceived: 3 (3) - TotalBytesReceived: 36.00 B (36) - TotalEarlySenders: 0 (0) - TotalEosReceived: 3 (3) - TotalHasDeferredRPCsTime: 0.000ns - TotalRPCsDeferred: 0 (0) CodeGen:(Total: 211.995ms, non-child: 211.995ms, % non-child: 100.00%) - CodegenInvoluntaryContextSwitches: 10 (10) - CodegenTotalWallClockTime: 211.995ms - CodegenSysTime: 991.000us - CodegenUserTime: 209.607ms - CodegenVoluntaryContextSwitches: 0 (0) - CompileTime: 0.000ns - IrGenerationTime: 0.000ns - LoadTime: 0.000ns - ModuleBitcodeSize: 2.32 MB (2434748) - NumFunctions: 0 (0) - NumInstructions: 0 (0) - OptimizationTime: 0.000ns - PeakMemoryUsage: 0 - PrepareTime: 211.995ms Coordinator Fragment F02: Instance 2b4a14d9933eb108:7565b86500000000 (host=downstream-jenkins-host:22000):(Total: 1m47s, non-child: 4.999ms, % non-child: 0.00%) Last report received time: 2019-01-18 00:11:07.968 Fragment Instance Lifecycle Event Timeline: 1m47s - Prepare Finished: 6.999ms (6.999ms) - Open Finished: 1m47s (1m47s) - First Batch Produced: 1m47s (0.000ns) - First Batch Sent: 1m47s (37.999ms) - ExecInternal Finished: 1m47s (0.000ns) MemoryUsage(2s000ms): 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 12.00 KB, 48.00 KB, 48.00 KB - AverageThreadTokens: 0.00 - BloomFilterBytes: 0 - PeakMemoryUsage: 56.00 KB (57344) - PeakReservation: 0 - PeakUsedReservation: 0 - PerHostPeakMemUsage: 5.75 MB (6031104) - RowsProduced: 1 (1) - TotalNetworkReceiveTime: 1m47s - TotalNetworkSendTime: 0.000ns - TotalStorageWaitTime: 0.000ns - TotalThreadsInvoluntaryContextSwitches: 10 (10) - TotalThreadsTotalWallClockTime: 1m47s - TotalThreadsSysTime: 995.000us - TotalThreadsUserTime: 212.405ms - TotalThreadsVoluntaryContextSwitches: 5 (5) Buffer pool: - AllocTime: 0.000ns - CumulativeAllocationBytes: 0 - CumulativeAllocations: 0 (0) - PeakReservation: 0 - PeakUnpinnedBytes: 0 - PeakUsedReservation: 0 - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - ReservationLimit: 0 - SystemAllocTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns Fragment Instance Lifecycle Timings: - ExecTime: 37.999ms - ExecTreeExecTime: 0.000ns - OpenTime: 1m47s - ExecTreeOpenTime: 1m47s - PrepareTime: 5.999ms - ExecTreePrepareTime: 2.999ms PLAN_ROOT_SINK:(Total: 37.999ms, non-child: 999.981us, % non-child: 2.63%) - PeakMemoryUsage: 0 AGGREGATION_NODE (id=6):(Total: 1m47s, non-child: 2.999ms, % non-child: 0.00%) Node Lifecycle Event Timeline: 1m47s - Open Started: 219.995ms (219.995ms) - Open Finished: 1m47s (1m47s) - First Batch Requested: 1m47s (0.000ns) - First Batch Returned: 1m47s (0.000ns) - Last Batch Returned: 1m47s (0.000ns) - Closed: 1m47s (37.999ms) - PeakMemoryUsage: 16.00 KB (16384) - RowsReturned: 1 (1) - RowsReturnedRate: 0 NonGroupingAggregator 0: - BuildTime: 0.000ns - PeakMemoryUsage: 8.00 KB (8192) - RowsReturned: 1 (1) EXCHANGE_NODE (id=5):(Total: 1m47s, non-child: 999.981us, % non-child: 0.00%) Node Lifecycle Event Timeline: 1m47s - Open Started: 219.995ms (219.995ms) - Open Finished: 1m42s (1m42s) - First Batch Requested: 1m42s (0.000ns) - First Batch Returned: 1m47s (5s422ms) - Last Batch Returned: 1m47s (0.000ns) - Closed: 1m47s (0.000ns) - ConvertRowBatchTime: 0.000ns - PeakMemoryUsage: 32.00 KB (32768) - RowsReturned: 3 (3) - RowsReturnedRate: 0 Buffer pool: - AllocTime: 0.000ns - CumulativeAllocationBytes: 48.00 KB (49152) - CumulativeAllocations: 6 (6) - PeakReservation: 32.00 KB (32768) - PeakUnpinnedBytes: 0 - PeakUsedReservation: 32.00 KB (32768) - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - SystemAllocTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns Dequeue: BytesDequeued(2s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 32.00 B, 32.00 B - FirstBatchWaitTime: 1m42s - TotalBytesDequeued: 48.00 B (48) - TotalGetBatchTime: 1m47s - DataWaitTime: 1m47s Enqueue: BytesReceived(2s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 24.00 B, 24.00 B DeferredQueueSize(2s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - DispatchTime: (Avg: 3.840ms ; Min: 319.467us ; Max: 5.996ms ; Number of samples: 3) - DeserializeRowBatchTime: 999.981us - TotalBatchesEnqueued: 3 (3) - TotalBatchesReceived: 3 (3) - TotalBytesReceived: 36.00 B (36) - TotalEarlySenders: 0 (0) - TotalEosReceived: 3 (3) - TotalHasDeferredRPCsTime: 0.000ns - TotalRPCsDeferred: 0 (0) CodeGen:(Total: 211.995ms, non-child: 211.995ms, % non-child: 100.00%) - CodegenInvoluntaryContextSwitches: 10 (10) - CodegenTotalWallClockTime: 211.995ms - CodegenSysTime: 991.000us - CodegenUserTime: 209.607ms - CodegenVoluntaryContextSwitches: 0 (0) - CompileTime: 0.000ns - IrGenerationTime: 0.000ns - LoadTime: 0.000ns - ModuleBitcodeSize: 2.32 MB (2434748) - NumFunctions: 0 (0) - NumInstructions: 0 (0) - OptimizationTime: 0.000ns - PeakMemoryUsage: 0 - PrepareTime: 211.995ms Averaged Fragment F00:(Total: 1m44s, non-child: 0.000ns, % non-child: 0.00%) split sizes: min: 0, max: 0, avg: 0, stddev: 0 completion times: min:1m42s max:1m47s mean: 1m45s stddev:2s236ms execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec num instances: 3 - AverageThreadTokens: 1.17 - BloomFilterBytes: 0 - PeakMemoryUsage: 2.67 MB (2795093) - PeakReservation: 1.94 MB (2031616) - PeakUsedReservation: 0 - PerHostPeakMemUsage: 5.74 MB (6022912) - RowsProduced: 1 (1) - TotalNetworkReceiveTime: 17s665ms - TotalNetworkSendTime: 21.332ms - TotalStorageWaitTime: 39.999ms - TotalThreadsInvoluntaryContextSwitches: 9.67K (9668) - TotalThreadsTotalWallClockTime: 2m2s - TotalThreadsSysTime: 40.075ms - TotalThreadsUserTime: 1m20s - TotalThreadsVoluntaryContextSwitches: 768 (768) Buffer pool: - AllocTime: 0.000ns - CumulativeAllocationBytes: 0 - CumulativeAllocations: 0 (0) - PeakReservation: 0 - PeakUnpinnedBytes: 0 - PeakUsedReservation: 0 - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - ReservationLimit: 0 - SystemAllocTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns Fragment Instance Lifecycle Timings: - ExecTime: 22.332ms - ExecTreeExecTime: 333.327us - OpenTime: 1m44s - ExecTreeOpenTime: 17s740ms - PrepareTime: 8.666ms - ExecTreePrepareTime: 4.666ms KrpcDataStreamSender (dst_id=5):(Total: 21.332ms, non-child: 21.332ms, % non-child: 100.00%) - EosSent: 1 (1) - PeakMemoryUsage: 16.00 KB (16384) - RowsSent: 1 (1) - RpcFailure: 0 (0) - RpcRetry: 0 (0) - SerializeBatchTime: 0.000ns - TotalBytesSent: 12.00 B (12) - UncompressedRowBatchSize: 16.00 B (16) AGGREGATION_NODE (id=3):(Total: 17s745ms, non-child: 0.000ns, % non-child: 0.00%) - PeakMemoryUsage: 77.33 KB (79189) - RowsReturned: 1 (1) - RowsReturnedRate: 1.00 /sec NonGroupingAggregator 0: - BuildTime: 0.000ns - PeakMemoryUsage: 8.00 KB (8192) - RowsReturned: 1 (1) HASH_JOIN_NODE (id=2):(Total: 17s747ms, non-child: 14.333ms, % non-child: 0.04%) - BuildRows: 39 (39) - BuildTime: 6.999ms - NumHashTableBuildsSkipped: 0 (0) - PeakMemoryUsage: 2.00 MB (2099456) - ProbeRows: 220 (220) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 0.000ns - RowsReturned: 12 (12) - RowsReturnedRate: 21.00 /sec Buffer pool: - AllocTime: 0.000ns - CumulativeAllocationBytes: 1.00 MB (1048576) - CumulativeAllocations: 16 (16) - PeakReservation: 1.94 MB (2031616) - PeakUnpinnedBytes: 0 - PeakUsedReservation: 1.00 MB (1048576) - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - SystemAllocTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns Hash Join Builder (join_node_id=2): - BuildRowsPartitionTime: 333.327us - BuildRowsPartitioned: 39 (39) - HashBuckets: 74 (74) - HashCollisions: 0 (0) - HashTablesBuildTime: 1.999ms - LargestPartitionPercent: 15 (15) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 29.12 KB (29824) - RepartitionTime: 0.000ns - SpilledPartitions: 0 (0) EXCHANGE_NODE (id=4):(Total: 17s666ms, non-child: 17s666ms, % non-child: 100.00%) - ConvertRowBatchTime: 333.327us - PeakMemoryUsage: 114.67 KB (117418) - RowsReturned: 39 (39) - RowsReturnedRate: 13.00 K/sec Buffer pool: - AllocTime: 4.333ms - CumulativeAllocationBytes: 160.00 KB (163840) - CumulativeAllocations: 20 (20) - PeakReservation: 114.67 KB (117418) - PeakUnpinnedBytes: 0 - PeakUsedReservation: 114.67 KB (117418) - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - SystemAllocTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns Dequeue: - FirstBatchWaitTime: 0.000ns - TotalBytesDequeued: 936.00 B (936) - TotalGetBatchTime: 17s665ms - DataWaitTime: 17s664ms Enqueue: - DeserializeRowBatchTime: 5.666ms - TotalBatchesEnqueued: 10 (10) - TotalBatchesReceived: 10 (10) - TotalBytesReceived: 657.00 B (657) - TotalEarlySenders: 0 (0) - TotalEosReceived: 3 (3) - TotalHasDeferredRPCsTime: 0.000ns - TotalRPCsDeferred: 0 (0) KUDU_SCAN_NODE (id=0):(Total: 16s111ms, non-child: 16s111ms, % non-child: 100.00%) - AverageScannerThreadConcurrency: 0.00 - KuduClientTime: 39.999ms - KuduRemoteScanTokens: 0 (0) - MaterializeTupleTime(*): 2.333ms - NumScannerThreadMemUnavailable: 0 (0) - NumScannerThreadsStarted: 3 (3) - PeakMemoryUsage: 68.00 KB (69632) - PeakScannerThreadConcurrency: 3 (3) - RowBatchBytesEnqueued: 53.33 KB (54613) - RowBatchQueueGetWaitTime: 10.999ms - RowBatchQueuePeakMemoryUsage: 64.00 KB (65536) - RowBatchQueuePutWaitTime: 0.000ns - RowBatchesEnqueued: 3 (3) - RowsRead: 370 (370) - RowsReturned: 220 (220) - RowsReturnedRate: 559.00 /sec - ScanRangesComplete: 3 (3) - ScannerThreadsInvoluntaryContextSwitches: 1 (1) - ScannerThreadsTotalWallClockTime: 82.665ms - ScannerThreadsSysTime: 0.000ns - ScannerThreadsUserTime: 12.776ms - ScannerThreadsVoluntaryContextSwitches: 10 (10) - TotalKuduScanRoundTrips: 3 (3) CodeGen:(Total: 1m26s, non-child: 1m26s, % non-child: 100.00%) - CodegenInvoluntaryContextSwitches: 9.65K (9655) - CodegenTotalWallClockTime: 1m26s - CodegenSysTime: 12.251ms - CodegenUserTime: 1m20s - CodegenVoluntaryContextSwitches: 14 (14) - CompileTime: 564.322ms - IrGenerationTime: 80.331ms - LoadTime: 0.000ns - ModuleBitcodeSize: 2.32 MB (2434748) - NumFunctions: 127 (127) - NumInstructions: 5.08K (5084) - OptimizationTime: 1m25s - PeakMemoryUsage: 2.48 MB (2603008) - PrepareTime: 150.997ms Fragment F00: Instance 2b4a14d9933eb108:7565b86500000006 (host=downstream-jenkins-host:22001):(Total: 1m47s, non-child: 3.999ms, % non-child: 0.00%) Last report received time: 2019-01-18 00:11:07.958 Hdfs split stats (:<# splits>/): Filter 1 arrival: 1m47s Fragment Instance Lifecycle Event Timeline: 1m47s - Prepare Finished: 10.999ms (10.999ms) - Open Finished: 1m47s (1m47s) - First Batch Produced: 1m47s (0.000ns) - First Batch Sent: 1m47s (0.000ns) - ExecInternal Finished: 1m47s (54.998ms) MemoryUsage(2s000ms): 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.61 MB, 2.61 MB, 2.61 MB, 2.61 MB, 2.61 MB, 2.61 MB, 2.61 MB, 2.61 MB, 2.61 MB, 2.61 MB, 2.61 MB, 2.63 MB, 2.66 MB, 2.66 MB, 2.66 MB, 2.66 MB, 2.66 MB, 2.66 MB, 2.66 MB, 2.66 MB, 2.66 MB, 2.68 MB, 2.72 MB, 2.72 MB ThreadUsage(2s000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.00 - BloomFilterBytes: 0 - PeakMemoryUsage: 2.72 MB (2855168) - PeakReservation: 1.94 MB (2031616) - PeakUsedReservation: 0 - PerHostPeakMemUsage: 5.79 MB (6067968) - RowsProduced: 1 (1) - TotalNetworkReceiveTime: 0.000ns - TotalNetworkSendTime: 52.998ms - TotalStorageWaitTime: 84.998ms - TotalThreadsInvoluntaryContextSwitches: 6.98K (6984) - TotalThreadsTotalWallClockTime: 1m48s - TotalThreadsSysTime: 50.670ms - TotalThreadsUserTime: 1m39s - TotalThreadsVoluntaryContextSwitches: 23 (23) Buffer pool: - AllocTime: 0.000ns - CumulativeAllocationBytes: 0 - CumulativeAllocations: 0 (0) - PeakReservation: 0 - PeakUnpinnedBytes: 0 - PeakUsedReservation: 0 - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - ReservationLimit: 0 - SystemAllocTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns Fragment Instance Lifecycle Timings: - ExecTime: 53.998ms - ExecTreeExecTime: 0.000ns - OpenTime: 1m47s - ExecTreeOpenTime: 165.996ms - PrepareTime: 8.999ms - ExecTreePrepareTime: 4.999ms KrpcDataStreamSender (dst_id=5):(Total: 52.998ms, non-child: 0.000ns, % non-child: 0.00%) ExecOption: Unpartitioned Sender Codegen Disabled: not needed BytesSent(2s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - NetworkThroughput: (Avg: 1.16 KB/sec ; Min: 1.16 KB/sec ; Max: 1.16 KB/sec ; Number of samples: 1) - EosSent: 1 (1) - PeakMemoryUsage: 16.00 KB (16384) - RowsSent: 1 (1) - RpcFailure: 0 (0) - RpcRetry: 0 (0) - SerializeBatchTime: 0.000ns - TotalBytesSent: 12.00 B (12) - UncompressedRowBatchSize: 16.00 B (16) AGGREGATION_NODE (id=3):(Total: 170.996ms, non-child: 0.000ns, % non-child: 0.00%) Node Lifecycle Event Timeline: 1m47s - Open Started: 1m47s (1m47s) - Open Finished: 1m47s (165.996ms) - First Batch Requested: 1m47s (999.981us) - First Batch Returned: 1m47s (0.000ns) - Last Batch Returned: 1m47s (0.000ns) - Closed: 1m47s (53.998ms) - PeakMemoryUsage: 88.00 KB (90112) - RowsReturned: 1 (1) - RowsReturnedRate: 5.00 /sec NonGroupingAggregator 0: ExecOption: Codegen Enabled - BuildTime: 0.000ns - PeakMemoryUsage: 8.00 KB (8192) - RowsReturned: 1 (1) HASH_JOIN_NODE (id=2):(Total: 172.996ms, non-child: 9.999ms, % non-child: 5.78%) ExecOption: Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously Node Lifecycle Event Timeline: 1m47s - Open Started: 1m47s (1m47s) - Open Finished: 1m47s (130.997ms) - First Batch Requested: 1m47s (0.000ns) - First Batch Returned: 1m47s (34.999ms) - Last Batch Returned: 1m47s (0.000ns) - Closed: 1m47s (0.000ns) - BuildRows: 39 (39) - BuildTime: 6.999ms - NumHashTableBuildsSkipped: 0 (0) - PeakMemoryUsage: 2.00 MB (2099456) - ProbeRows: 270 (270) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 0.000ns - RowsReturned: 11 (11) - RowsReturnedRate: 63.00 /sec Buffer pool: - AllocTime: 0.000ns - CumulativeAllocationBytes: 1.00 MB (1048576) - CumulativeAllocations: 16 (16) - PeakReservation: 1.94 MB (2031616) - PeakUnpinnedBytes: 0 - PeakUsedReservation: 1.00 MB (1048576) - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - SystemAllocTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns Hash Join Builder (join_node_id=2): ExecOption: Build Side Codegen Enabled, Hash Table Construction Codegen Enabled Runtime filters: 1 of 1 Runtime Filter Published - BuildRowsPartitionTime: 0.000ns - BuildRowsPartitioned: 39 (39) - HashBuckets: 74 (74) - HashCollisions: 0 (0) - HashTablesBuildTime: 1.999ms - LargestPartitionPercent: 15 (15) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 29.12 KB (29824) - RepartitionTime: 0.000ns - SpilledPartitions: 0 (0) EXCHANGE_NODE (id=4):(Total: 999.981us, non-child: 999.981us, % non-child: 100.00%) Node Lifecycle Event Timeline: 1m47s - Open Started: 1m47s (1m47s) - Open Finished: 1m47s (0.000ns) - First Batch Requested: 1m47s (4.999ms) - First Batch Returned: 1m47s (999.981us) - Last Batch Returned: 1m47s (0.000ns) - Closed: 1m47s (3.999ms) - ConvertRowBatchTime: 0.000ns - PeakMemoryUsage: 160.00 KB (163840) - RowsReturned: 39 (39) - RowsReturnedRate: 39.00 K/sec Buffer pool: - AllocTime: 0.000ns - CumulativeAllocationBytes: 160.00 KB (163840) - CumulativeAllocations: 20 (20) - PeakReservation: 160.00 KB (163840) - PeakUnpinnedBytes: 0 - PeakUsedReservation: 160.00 KB (163840) - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - SystemAllocTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns Dequeue: BytesDequeued(2s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - FirstBatchWaitTime: 0.000ns - TotalBytesDequeued: 936.00 B (936) - TotalGetBatchTime: 0.000ns - DataWaitTime: 0.000ns Enqueue: BytesReceived(2s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 209.00 B, 209.00 B, 209.00 B, 209.00 B, 209.00 B, 209.00 B, 209.00 B, 209.00 B, 209.00 B, 209.00 B, 209.00 B, 266.00 B, 439.00 B, 439.00 B, 439.00 B, 439.00 B, 439.00 B, 439.00 B, 439.00 B, 439.00 B, 439.00 B, 493.00 B, 657.00 B, 657.00 B DeferredQueueSize(2s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - DispatchTime: (Avg: 2.798ms ; Min: 171.545us ; Max: 7.962ms ; Number of samples: 10) - DeserializeRowBatchTime: 999.980us - TotalBatchesEnqueued: 10 (10) - TotalBatchesReceived: 10 (10) - TotalBytesReceived: 657.00 B (657) - TotalEarlySenders: 0 (0) - TotalEosReceived: 3 (3) - TotalHasDeferredRPCsTime: 0.000ns - TotalRPCsDeferred: 0 (0) KUDU_SCAN_NODE (id=0):(Total: 162.996ms, non-child: 162.996ms, % non-child: 100.00%) Runtime filters: All filters arrived. Waited 0 Node Lifecycle Event Timeline: 1m47s - Open Started: 1m47s (1m47s) - Open Finished: 1m47s (106.997ms) - First Batch Requested: 1m47s (0.000ns) - First Batch Returned: 1m47s (0.000ns) - Last Batch Returned: 1m47s (32.999ms) - Closed: 1m47s (1.999ms) - AverageScannerThreadConcurrency: 0.00 - KuduClientTime: 84.998ms - KuduRemoteScanTokens: 0 (0) - MaterializeTupleTime(*): 2.999ms - NumScannerThreadMemUnavailable: 0 (0) - NumScannerThreadsStarted: 4 (4) - PeakMemoryUsage: 52.00 KB (53248) - PeakScannerThreadConcurrency: 4 (4) - RowBatchBytesEnqueued: 64.00 KB (65536) - RowBatchQueueGetWaitTime: 32.999ms - RowBatchQueuePeakMemoryUsage: 48.00 KB (49152) - RowBatchQueuePutWaitTime: 0.000ns - RowBatchesEnqueued: 4 (4) - RowsRead: 270 (270) - RowsReturned: 270 (270) - RowsReturnedRate: 1.66 K/sec - ScanRangesComplete: 4 (4) - ScannerThreadsInvoluntaryContextSwitches: 0 (0) - ScannerThreadsTotalWallClockTime: 182.996ms - ScannerThreadsSysTime: 0.000ns - ScannerThreadsUserTime: 17.975ms - ScannerThreadsVoluntaryContextSwitches: 12 (12) - TotalKuduScanRoundTrips: 4 (4) CodeGen:(Total: 1m47s, non-child: 1m47s, % non-child: 100.00%) - CodegenInvoluntaryContextSwitches: 6.97K (6968) - CodegenTotalWallClockTime: 1m47s - CodegenSysTime: 6.951ms - CodegenUserTime: 1m39s - CodegenVoluntaryContextSwitches: 4 (4) - CompileTime: 570.989ms - IrGenerationTime: 71.998ms - LoadTime: 0.000ns - ModuleBitcodeSize: 2.32 MB (2434748) - NumFunctions: 127 (127) - NumInstructions: 5.08K (5084) - OptimizationTime: 1m46s - PeakMemoryUsage: 2.48 MB (2603008) - PrepareTime: 144.997ms Instance 2b4a14d9933eb108:7565b86500000004 (host=downstream-jenkins-host:22000):(Total: 1m42s, non-child: 0.000ns, % non-child: 0.00%) Last report received time: 2019-01-18 00:11:05.700 Hdfs split stats (:<# splits>/): Filter 1 arrival: 1m42s Fragment Instance Lifecycle Event Timeline: 1m42s - Prepare Finished: 9.999ms (9.999ms) - Open Finished: 1m42s (1m42s) - First Batch Produced: 1m42s (999.981us) - First Batch Sent: 1m42s (0.000ns) - ExecInternal Finished: 1m42s (8.999ms) MemoryUsage(2s000ms): 1.95 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.60 MB, 2.61 MB, 2.61 MB, 2.61 MB, 2.61 MB, 2.61 MB, 2.61 MB, 2.61 MB, 2.61 MB, 2.61 MB, 2.61 MB, 2.61 MB, 2.66 MB, 2.66 MB, 2.04 MB, 1.66 MB, 2.15 MB, 2.15 MB, 2.15 MB, 2.15 MB, 2.17 MB, 2.22 MB ThreadUsage(2s000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 2 - AverageThreadTokens: 1.13 - BloomFilterBytes: 0 - PeakMemoryUsage: 2.66 MB (2789632) - PeakReservation: 1.94 MB (2031616) - PeakUsedReservation: 0 - PerHostPeakMemUsage: 5.75 MB (6031104) - RowsProduced: 1 (1) - TotalNetworkReceiveTime: 13s778ms - TotalNetworkSendTime: 7.999ms - TotalStorageWaitTime: 9.999ms - TotalThreadsInvoluntaryContextSwitches: 18.25K (18253) - TotalThreadsTotalWallClockTime: 1m56s - TotalThreadsSysTime: 41.709ms - TotalThreadsUserTime: 1m21s - TotalThreadsVoluntaryContextSwitches: 592 (592) Buffer pool: - AllocTime: 0.000ns - CumulativeAllocationBytes: 0 - CumulativeAllocations: 0 (0) - PeakReservation: 0 - PeakUnpinnedBytes: 0 - PeakUsedReservation: 0 - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - ReservationLimit: 0 - SystemAllocTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns Fragment Instance Lifecycle Timings: - ExecTime: 8.999ms - ExecTreeExecTime: 999.981us - OpenTime: 1m42s - ExecTreeOpenTime: 13s811ms - PrepareTime: 8.999ms - ExecTreePrepareTime: 4.999ms KrpcDataStreamSender (dst_id=5):(Total: 7.999ms, non-child: 0.000ns, % non-child: 0.00%) ExecOption: Unpartitioned Sender Codegen Disabled: not needed BytesSent(2s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - NetworkThroughput: (Avg: 11.55 KB/sec ; Min: 11.55 KB/sec ; Max: 11.55 KB/sec ; Number of samples: 1) - EosSent: 1 (1) - PeakMemoryUsage: 16.00 KB (16384) - RowsSent: 1 (1) - RpcFailure: 0 (0) - RpcRetry: 0 (0) - SerializeBatchTime: 0.000ns - TotalBytesSent: 12.00 B (12) - UncompressedRowBatchSize: 16.00 B (16) AGGREGATION_NODE (id=3):(Total: 13s817ms, non-child: 0.000ns, % non-child: 0.00%) Node Lifecycle Event Timeline: 1m42s - Open Started: 1m28s (1m28s) - Open Finished: 1m42s (13s811ms) - First Batch Requested: 1m42s (0.000ns) - First Batch Returned: 1m42s (999.981us) - Last Batch Returned: 1m42s (0.000ns) - Closed: 1m42s (7.999ms) - PeakMemoryUsage: 72.00 KB (73728) - RowsReturned: 1 (1) - RowsReturnedRate: 0 NonGroupingAggregator 0: ExecOption: Codegen Enabled - BuildTime: 0.000ns - PeakMemoryUsage: 8.00 KB (8192) - RowsReturned: 1 (1) HASH_JOIN_NODE (id=2):(Total: 13s819ms, non-child: 25.999ms, % non-child: 0.10%) ExecOption: Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously Node Lifecycle Event Timeline: 1m42s - Open Started: 1m28s (1m28s) - Open Finished: 1m42s (13s808ms) - First Batch Requested: 1m42s (0.000ns) - First Batch Returned: 1m42s (1.999ms) - Last Batch Returned: 1m42s (999.981us) - Closed: 1m42s (0.000ns) - BuildRows: 39 (39) - BuildTime: 6.999ms - NumHashTableBuildsSkipped: 0 (0) - PeakMemoryUsage: 2.00 MB (2099456) - ProbeRows: 189 (189) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 0.000ns - RowsReturned: 13 (13) - RowsReturnedRate: 0 Buffer pool: - AllocTime: 0.000ns - CumulativeAllocationBytes: 1.00 MB (1048576) - CumulativeAllocations: 16 (16) - PeakReservation: 1.94 MB (2031616) - PeakUnpinnedBytes: 0 - PeakUsedReservation: 1.00 MB (1048576) - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - SystemAllocTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns Hash Join Builder (join_node_id=2): ExecOption: Build Side Codegen Enabled, Hash Table Construction Codegen Enabled Runtime filters: 1 of 1 Runtime Filter Published - BuildRowsPartitionTime: 0.000ns - BuildRowsPartitioned: 39 (39) - HashBuckets: 74 (74) - HashCollisions: 0 (0) - HashTablesBuildTime: 1.999ms - LargestPartitionPercent: 15 (15) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 29.12 KB (29824) - RepartitionTime: 0.000ns - SpilledPartitions: 0 (0) EXCHANGE_NODE (id=4):(Total: 13s778ms, non-child: 999.980us, % non-child: 0.01%) Node Lifecycle Event Timeline: 1m42s - Open Started: 1m28s (1m28s) - Open Finished: 1m28s (0.000ns) - First Batch Requested: 1m28s (4.999ms) - First Batch Returned: 1m42s (13s778ms) - Last Batch Returned: 1m42s (0.000ns) - Closed: 1m42s (3.999ms) - ConvertRowBatchTime: 0.000ns - PeakMemoryUsage: 96.00 KB (98304) - RowsReturned: 39 (39) - RowsReturnedRate: 2.00 /sec Buffer pool: - AllocTime: 11.999ms - CumulativeAllocationBytes: 160.00 KB (163840) - CumulativeAllocations: 20 (20) - PeakReservation: 96.00 KB (98304) - PeakUnpinnedBytes: 0 - PeakUsedReservation: 96.00 KB (98304) - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - SystemAllocTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns Dequeue: BytesDequeued(2s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 486.00 B, 648.00 B, 648.00 B, 648.00 B, 648.00 B, 648.00 B, 648.00 B - FirstBatchWaitTime: 0.000ns - TotalBytesDequeued: 936.00 B (936) - TotalGetBatchTime: 13s778ms - DataWaitTime: 13s777ms Enqueue: BytesReceived(2s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 156.00 B, 209.00 B, 209.00 B, 209.00 B, 209.00 B, 209.00 B, 209.00 B, 209.00 B, 209.00 B, 209.00 B, 209.00 B, 209.00 B, 439.00 B, 439.00 B, 439.00 B, 439.00 B, 439.00 B, 439.00 B, 439.00 B, 439.00 B, 439.00 B, 439.00 B DeferredQueueSize(2s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - DispatchTime: (Avg: 2.325ms ; Min: 190.885us ; Max: 8.823ms ; Number of samples: 10) - DeserializeRowBatchTime: 12.999ms - TotalBatchesEnqueued: 10 (10) - TotalBatchesReceived: 10 (10) - TotalBytesReceived: 657.00 B (657) - TotalEarlySenders: 0 (0) - TotalEosReceived: 3 (3) - TotalHasDeferredRPCsTime: 0.000ns - TotalRPCsDeferred: 0 (0) KUDU_SCAN_NODE (id=0):(Total: 11s359ms, non-child: 11s359ms, % non-child: 100.00%) Runtime filters: Not all filters arrived (arrived: [], missing [1]), waited for 11s337ms Node Lifecycle Event Timeline: 1m42s - Open Started: 1m28s (1m28s) - Open Finished: 1m40s (11s349ms) - First Batch Requested: 1m42s (2s437ms) - First Batch Returned: 1m42s (0.000ns) - Last Batch Returned: 1m42s (999.981us) - Closed: 1m42s (1.999ms) - AverageScannerThreadConcurrency: 0.00 - KuduClientTime: 9.999ms - KuduRemoteScanTokens: 0 (0) - MaterializeTupleTime(*): 2.999ms - NumScannerThreadMemUnavailable: 0 (0) - NumScannerThreadsStarted: 3 (3) - PeakMemoryUsage: 76.00 KB (77824) - PeakScannerThreadConcurrency: 3 (3) - RowBatchBytesEnqueued: 48.00 KB (49152) - RowBatchQueueGetWaitTime: 0.000ns - RowBatchQueuePeakMemoryUsage: 72.00 KB (73728) - RowBatchQueuePutWaitTime: 0.000ns - RowBatchesEnqueued: 3 (3) - RowsRead: 396 (396) - RowsReturned: 189 (189) - RowsReturnedRate: 16.00 /sec - ScanRangesComplete: 3 (3) - ScannerThreadsInvoluntaryContextSwitches: 2 (2) - ScannerThreadsTotalWallClockTime: 25.999ms - ScannerThreadsSysTime: 0.000ns - ScannerThreadsUserTime: 10.978ms - ScannerThreadsVoluntaryContextSwitches: 10 (10) - TotalKuduScanRoundTrips: 3 (3) CodeGen:(Total: 1m28s, non-child: 1m28s, % non-child: 100.00%) - CodegenInvoluntaryContextSwitches: 18.24K (18239) - CodegenTotalWallClockTime: 1m28s - CodegenSysTime: 19.859ms - CodegenUserTime: 1m21s - CodegenVoluntaryContextSwitches: 38 (38) - CompileTime: 682.986ms - IrGenerationTime: 82.998ms - LoadTime: 0.000ns - ModuleBitcodeSize: 2.32 MB (2434748) - NumFunctions: 127 (127) - NumInstructions: 5.08K (5084) - OptimizationTime: 1m27s - PeakMemoryUsage: 2.48 MB (2603008) - PrepareTime: 155.997ms Instance 2b4a14d9933eb108:7565b86500000005 (host=downstream-jenkins-host:22002):(Total: 1m42s, non-child: 0.000ns, % non-child: 0.00%) Last report received time: 2019-01-18 00:11:02.506 Hdfs split stats (:<# splits>/): Filter 1 arrival: 1m42s Fragment Instance Lifecycle Event Timeline: 1m42s - Prepare Finished: 8.999ms (8.999ms) - Open Finished: 1m42s (1m42s) - First Batch Produced: 1m42s (0.000ns) - First Batch Sent: 1m42s (999.980us) - ExecInternal Finished: 1m42s (3.999ms) MemoryUsage(2s000ms): 1.95 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.57 MB, 2.60 MB, 2.61 MB, 1.74 MB, 2.10 MB, 2.10 MB, 2.10 MB, 2.10 MB, 2.10 MB, 2.10 MB, 2.10 MB, 2.10 MB, 2.10 MB, 2.11 MB, 2.11 MB, 2.11 MB, 2.11 MB, 2.11 MB, 2.11 MB, 2.11 MB, 2.11 MB, 2.13 MB, 2.18 MB ThreadUsage(2s000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2 - AverageThreadTokens: 1.38 - BloomFilterBytes: 0 - PeakMemoryUsage: 2.61 MB (2740480) - PeakReservation: 1.94 MB (2031616) - PeakUsedReservation: 0 - PerHostPeakMemUsage: 5.69 MB (5969664) - RowsProduced: 1 (1) - TotalNetworkReceiveTime: 39s218ms - TotalNetworkSendTime: 2.999ms - TotalStorageWaitTime: 24.999ms - TotalThreadsInvoluntaryContextSwitches: 3.77K (3769) - TotalThreadsTotalWallClockTime: 2m21s - TotalThreadsSysTime: 27.847ms - TotalThreadsUserTime: 1m1s - TotalThreadsVoluntaryContextSwitches: 1.69K (1691) Buffer pool: - AllocTime: 0.000ns - CumulativeAllocationBytes: 0 - CumulativeAllocations: 0 (0) - PeakReservation: 0 - PeakUnpinnedBytes: 0 - PeakUsedReservation: 0 - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - ReservationLimit: 0 - SystemAllocTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns Fragment Instance Lifecycle Timings: - ExecTime: 3.999ms - ExecTreeExecTime: 0.000ns - OpenTime: 1m42s - ExecTreeOpenTime: 39s245ms - PrepareTime: 7.999ms - ExecTreePrepareTime: 3.999ms KrpcDataStreamSender (dst_id=5):(Total: 2.999ms, non-child: 0.000ns, % non-child: 0.00%) ExecOption: Unpartitioned Sender Codegen Disabled: not needed BytesSent(2s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - NetworkThroughput: (Avg: 7.37 KB/sec ; Min: 7.37 KB/sec ; Max: 7.37 KB/sec ; Number of samples: 1) - EosSent: 1 (1) - PeakMemoryUsage: 16.00 KB (16384) - RowsSent: 1 (1) - RpcFailure: 0 (0) - RpcRetry: 0 (0) - SerializeBatchTime: 0.000ns - TotalBytesSent: 12.00 B (12) - UncompressedRowBatchSize: 16.00 B (16) AGGREGATION_NODE (id=3):(Total: 39s249ms, non-child: 0.000ns, % non-child: 0.00%) Node Lifecycle Event Timeline: 1m42s - Open Started: 1m3s (1m3s) - Open Finished: 1m42s (39s245ms) - First Batch Requested: 1m42s (0.000ns) - First Batch Returned: 1m42s (0.000ns) - Last Batch Returned: 1m42s (0.000ns) - Closed: 1m42s (3.999ms) - PeakMemoryUsage: 72.00 KB (73728) - RowsReturned: 1 (1) - RowsReturnedRate: 0 NonGroupingAggregator 0: ExecOption: Codegen Enabled - BuildTime: 0.000ns - PeakMemoryUsage: 8.00 KB (8192) - RowsReturned: 1 (1) HASH_JOIN_NODE (id=2):(Total: 39s251ms, non-child: 6.999ms, % non-child: 0.01%) ExecOption: Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously Node Lifecycle Event Timeline: 1m42s - Open Started: 1m3s (1m3s) - Open Finished: 1m42s (39s243ms) - First Batch Requested: 1m42s (0.000ns) - First Batch Returned: 1m42s (999.981us) - Last Batch Returned: 1m42s (999.981us) - Closed: 1m42s (0.000ns) - BuildRows: 39 (39) - BuildTime: 6.999ms - NumHashTableBuildsSkipped: 0 (0) - PeakMemoryUsage: 2.00 MB (2099456) - ProbeRows: 202 (202) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 0.000ns - RowsReturned: 13 (13) - RowsReturnedRate: 0 Buffer pool: - AllocTime: 0.000ns - CumulativeAllocationBytes: 1.00 MB (1048576) - CumulativeAllocations: 16 (16) - PeakReservation: 1.94 MB (2031616) - PeakUnpinnedBytes: 0 - PeakUsedReservation: 1.00 MB (1048576) - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - SystemAllocTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns Hash Join Builder (join_node_id=2): ExecOption: Build Side Codegen Enabled, Hash Table Construction Codegen Enabled Runtime filters: 1 of 1 Runtime Filter Published - BuildRowsPartitionTime: 999.981us - BuildRowsPartitioned: 39 (39) - HashBuckets: 74 (74) - HashCollisions: 0 (0) - HashTablesBuildTime: 1.999ms - LargestPartitionPercent: 15 (15) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 29.12 KB (29824) - RepartitionTime: 0.000ns - SpilledPartitions: 0 (0) EXCHANGE_NODE (id=4):(Total: 39s219ms, non-child: 1.999ms, % non-child: 0.01%) Node Lifecycle Event Timeline: 1m42s - Open Started: 1m3s (1m3s) - Open Finished: 1m3s (0.000ns) - First Batch Requested: 1m3s (3.999ms) - First Batch Returned: 1m42s (39s219ms) - Last Batch Returned: 1m42s (0.000ns) - Closed: 1m42s (3.999ms) - ConvertRowBatchTime: 999.981us - PeakMemoryUsage: 88.00 KB (90112) - RowsReturned: 39 (39) - RowsReturnedRate: 0 Buffer pool: - AllocTime: 999.980us - CumulativeAllocationBytes: 160.00 KB (163840) - CumulativeAllocations: 20 (20) - PeakReservation: 88.00 KB (90112) - PeakUnpinnedBytes: 0 - PeakUsedReservation: 88.00 KB (90112) - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - SystemAllocTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns Dequeue: BytesDequeued(2s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 156.00 B, 312.00 B, 312.00 B, 312.00 B, 312.00 B, 312.00 B, 312.00 B, 312.00 B, 312.00 B, 312.00 B, 648.00 B, 648.00 B, 648.00 B, 648.00 B, 648.00 B, 648.00 B, 648.00 B, 648.00 B, 648.00 B, 648.00 B - FirstBatchWaitTime: 0.000ns - TotalBytesDequeued: 936.00 B (936) - TotalGetBatchTime: 39s218ms - DataWaitTime: 39s217ms Enqueue: BytesReceived(2s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 156.00 B, 209.00 B, 209.00 B, 209.00 B, 209.00 B, 209.00 B, 209.00 B, 209.00 B, 209.00 B, 209.00 B, 209.00 B, 209.00 B, 439.00 B, 439.00 B, 439.00 B, 439.00 B, 439.00 B, 439.00 B, 439.00 B, 439.00 B, 439.00 B, 439.00 B DeferredQueueSize(2s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - DispatchTime: (Avg: 1.497ms ; Min: 154.502us ; Max: 6.196ms ; Number of samples: 10) - DeserializeRowBatchTime: 2.999ms - TotalBatchesEnqueued: 10 (10) - TotalBatchesReceived: 10 (10) - TotalBytesReceived: 657.00 B (657) - TotalEarlySenders: 0 (0) - TotalEosReceived: 3 (3) - TotalHasDeferredRPCsTime: 0.000ns - TotalRPCsDeferred: 0 (0) KUDU_SCAN_NODE (id=0):(Total: 36s812ms, non-child: 36s812ms, % non-child: 100.00%) Runtime filters: Not all filters arrived (arrived: [], missing [1]), waited for 36s768ms Node Lifecycle Event Timeline: 1m42s - Open Started: 1m3s (1m3s) - Open Finished: 1m40s (36s791ms) - First Batch Requested: 1m42s (2s435ms) - First Batch Returned: 1m42s (0.000ns) - Last Batch Returned: 1m42s (0.000ns) - Closed: 1m42s (1.999ms) - AverageScannerThreadConcurrency: 0.00 - KuduClientTime: 24.999ms - KuduRemoteScanTokens: 0 (0) - MaterializeTupleTime(*): 999.981us - NumScannerThreadMemUnavailable: 0 (0) - NumScannerThreadsStarted: 3 (3) - PeakMemoryUsage: 76.00 KB (77824) - PeakScannerThreadConcurrency: 3 (3) - RowBatchBytesEnqueued: 48.00 KB (49152) - RowBatchQueueGetWaitTime: 0.000ns - RowBatchQueuePeakMemoryUsage: 72.00 KB (73728) - RowBatchQueuePutWaitTime: 0.000ns - RowBatchesEnqueued: 3 (3) - RowsRead: 444 (444) - RowsReturned: 202 (202) - RowsReturnedRate: 5.00 /sec - ScanRangesComplete: 3 (3) - ScannerThreadsInvoluntaryContextSwitches: 1 (1) - ScannerThreadsTotalWallClockTime: 38.999ms - ScannerThreadsSysTime: 0.000ns - ScannerThreadsUserTime: 9.376ms - ScannerThreadsVoluntaryContextSwitches: 10 (10) - TotalKuduScanRoundTrips: 3 (3) CodeGen:(Total: 1m3s, non-child: 1m3s, % non-child: 100.00%) - CodegenInvoluntaryContextSwitches: 3.76K (3759) - CodegenTotalWallClockTime: 1m3s - CodegenSysTime: 9.943ms - CodegenUserTime: 1m1s - CodegenVoluntaryContextSwitches: 2 (2) - CompileTime: 438.991ms - IrGenerationTime: 85.998ms - LoadTime: 0.000ns - ModuleBitcodeSize: 2.32 MB (2434748) - NumFunctions: 127 (127) - NumInstructions: 5.08K (5084) - OptimizationTime: 1m2s - PeakMemoryUsage: 2.48 MB (2603008) - PrepareTime: 151.997ms Averaged Fragment F01:(Total: 1m21s, non-child: 0.000ns, % non-child: 0.00%) split sizes: min: 0, max: 0, avg: 0, stddev: 0 completion times: min:1m max:1m45s mean: 1m23s stddev:18s503ms execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec num instances: 3 - AverageThreadTokens: 1.00 - BloomFilterBytes: 0 - PeakMemoryUsage: 1.19 MB (1246720) - PeakReservation: 0 - PeakUsedReservation: 0 - PerHostPeakMemUsage: 5.74 MB (6022912) - RowsProduced: 13 (13) - TotalNetworkReceiveTime: 0.000ns - TotalNetworkSendTime: 41.665ms - TotalStorageWaitTime: 115.664ms - TotalThreadsInvoluntaryContextSwitches: 5.04K (5042) - TotalThreadsTotalWallClockTime: 1m21s - TotalThreadsSysTime: 42.423ms - TotalThreadsUserTime: 1m14s - TotalThreadsVoluntaryContextSwitches: 32 (32) Buffer pool: - AllocTime: 0.000ns - CumulativeAllocationBytes: 0 - CumulativeAllocations: 0 (0) - PeakReservation: 0 - PeakUnpinnedBytes: 0 - PeakUsedReservation: 0 - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - ReservationLimit: 0 - SystemAllocTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns Fragment Instance Lifecycle Timings: - ExecTime: 87.998ms - ExecTreeExecTime: 44.665ms - OpenTime: 1m21s - ExecTreeOpenTime: 128.664ms - PrepareTime: 3.999ms - ExecTreePrepareTime: 999.980us KrpcDataStreamSender (dst_id=4):(Total: 43.665ms, non-child: 43.665ms, % non-child: 100.00%) - EosSent: 3 (3) - PeakMemoryUsage: 24.00 KB (24576) - RowsSent: 13 (13) - RpcFailure: 0 (0) - RpcRetry: 0 (0) - SerializeBatchTime: 0.000ns - TotalBytesSent: 657.00 B (657) - UncompressedRowBatchSize: 936.00 B (936) KUDU_SCAN_NODE (id=1):(Total: 224.662ms, non-child: 224.662ms, % non-child: 100.00%) - AverageScannerThreadConcurrency: 0.67 - KuduClientTime: 115.664ms - KuduRemoteScanTokens: 0 (0) - MaterializeTupleTime(*): 1.333ms - NumScannerThreadMemUnavailable: 0 (0) - NumScannerThreadsStarted: 3 (3) - PeakMemoryUsage: 36.00 KB (36864) - PeakScannerThreadConcurrency: 3 (3) - RowBatchBytesEnqueued: 53.33 KB (54613) - RowBatchQueueGetWaitTime: 44.332ms - RowBatchQueuePeakMemoryUsage: 32.00 KB (32768) - RowBatchQueuePutWaitTime: 0.000ns - RowBatchesEnqueued: 3 (3) - RowsRead: 13 (13) - RowsReturned: 13 (13) - RowsReturnedRate: 75.00 /sec - ScanRangesComplete: 3 (3) - ScannerThreadsInvoluntaryContextSwitches: 0 (0) - ScannerThreadsTotalWallClockTime: 185.329ms - ScannerThreadsSysTime: 0.000ns - ScannerThreadsUserTime: 12.929ms - ScannerThreadsVoluntaryContextSwitches: 9 (9) - TotalKuduScanRoundTrips: 3 (3) CodeGen:(Total: 1m20s, non-child: 1m20s, % non-child: 100.00%) - CodegenInvoluntaryContextSwitches: 4.98K (4984) - CodegenTotalWallClockTime: 1m20s - CodegenSysTime: 9.941ms - CodegenUserTime: 1m14s - CodegenVoluntaryContextSwitches: 11 (11) - CompileTime: 517.656ms - IrGenerationTime: 39.999ms - LoadTime: 0.000ns - ModuleBitcodeSize: 2.32 MB (2434748) - NumFunctions: 76 (76) - NumInstructions: 2.37K (2371) - OptimizationTime: 1m20s - PeakMemoryUsage: 1.16 MB (1213952) - PrepareTime: 177.329ms Fragment F01: Instance 2b4a14d9933eb108:7565b86500000003 (host=downstream-jenkins-host:22001):(Total: 1m42s, non-child: 0.000ns, % non-child: 0.00%) Last report received time: 2019-01-18 00:11:05.533 Hdfs split stats (:<# splits>/): Fragment Instance Lifecycle Event Timeline: 1m42s - Prepare Finished: 5.999ms (5.999ms) - Open Finished: 1m42s (1m42s) - First Batch Produced: 1m42s (0.000ns) - First Batch Sent: 1m42s (0.000ns) - ExecInternal Finished: 1m42s (55.998ms) MemoryUsage(2s000ms): 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB ThreadUsage(2s000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.00 - BloomFilterBytes: 0 - PeakMemoryUsage: 1.19 MB (1246720) - PeakReservation: 0 - PeakUsedReservation: 0 - PerHostPeakMemUsage: 5.79 MB (6067968) - RowsProduced: 12 (12) - TotalNetworkReceiveTime: 0.000ns - TotalNetworkSendTime: 31.999ms - TotalStorageWaitTime: 133.997ms - TotalThreadsInvoluntaryContextSwitches: 6.47K (6475) - TotalThreadsTotalWallClockTime: 1m42s - TotalThreadsSysTime: 56.656ms - TotalThreadsUserTime: 1m31s - TotalThreadsVoluntaryContextSwitches: 25 (25) Buffer pool: - AllocTime: 0.000ns - CumulativeAllocationBytes: 0 - CumulativeAllocations: 0 (0) - PeakReservation: 0 - PeakUnpinnedBytes: 0 - PeakUsedReservation: 0 - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - ReservationLimit: 0 - SystemAllocTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns Fragment Instance Lifecycle Timings: - ExecTime: 54.998ms - ExecTreeExecTime: 19.999ms - OpenTime: 1m42s - ExecTreeOpenTime: 135.997ms - PrepareTime: 3.999ms - ExecTreePrepareTime: 999.981us KrpcDataStreamSender (dst_id=4):(Total: 33.999ms, non-child: 1.999ms, % non-child: 5.88%) ExecOption: Unpartitioned Sender Codegen Disabled: not needed BytesSent(2s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - NetworkThroughput: (Avg: 36.69 KB/sec ; Min: 3.96 KB/sec ; Max: 124.20 KB/sec ; Number of samples: 12) - EosSent: 3 (3) - PeakMemoryUsage: 24.00 KB (24576) - RowsSent: 12 (12) - RpcFailure: 0 (0) - RpcRetry: 0 (0) - SerializeBatchTime: 0.000ns - TotalBytesSent: 654.00 B (654) - UncompressedRowBatchSize: 864.00 B (864) KUDU_SCAN_NODE (id=1):(Total: 178.996ms, non-child: 178.996ms, % non-child: 100.00%) Node Lifecycle Event Timeline: 1m42s - Open Started: 1m42s (1m42s) - Open Finished: 1m42s (134.997ms) - First Batch Requested: 1m42s (999.981us) - First Batch Returned: 1m42s (0.000ns) - Last Batch Returned: 1m42s (42.999ms) - Closed: 1m42s (11.999ms) - AverageScannerThreadConcurrency: 0.00 - KuduClientTime: 133.997ms - KuduRemoteScanTokens: 0 (0) - MaterializeTupleTime(*): 1.999ms - NumScannerThreadMemUnavailable: 0 (0) - NumScannerThreadsStarted: 4 (4) - PeakMemoryUsage: 52.00 KB (53248) - PeakScannerThreadConcurrency: 4 (4) - RowBatchBytesEnqueued: 64.00 KB (65536) - RowBatchQueueGetWaitTime: 19.999ms - RowBatchQueuePeakMemoryUsage: 48.00 KB (49152) - RowBatchQueuePutWaitTime: 0.000ns - RowBatchesEnqueued: 4 (4) - RowsRead: 13 (13) - RowsReturned: 12 (12) - RowsReturnedRate: 67.00 /sec - ScanRangesComplete: 4 (4) - ScannerThreadsInvoluntaryContextSwitches: 0 (0) - ScannerThreadsTotalWallClockTime: 229.995ms - ScannerThreadsSysTime: 0.000ns - ScannerThreadsUserTime: 16.738ms - ScannerThreadsVoluntaryContextSwitches: 12 (12) - TotalKuduScanRoundTrips: 4 (4) CodeGen:(Total: 1m42s, non-child: 1m42s, % non-child: 100.00%) - CodegenInvoluntaryContextSwitches: 6.37K (6368) - CodegenTotalWallClockTime: 1m42s - CodegenSysTime: 6.957ms - CodegenUserTime: 1m31s - CodegenVoluntaryContextSwitches: 0 (0) - CompileTime: 478.990ms - IrGenerationTime: 33.999ms - LoadTime: 0.000ns - ModuleBitcodeSize: 2.32 MB (2434748) - NumFunctions: 76 (76) - NumInstructions: 2.37K (2371) - OptimizationTime: 1m41s - PeakMemoryUsage: 1.16 MB (1213952) - PrepareTime: 191.996ms Instance 2b4a14d9933eb108:7565b86500000001 (host=downstream-jenkins-host:22000):(Total: 1m22s, non-child: 0.000ns, % non-child: 0.00%) Last report received time: 2019-01-18 00:10:45.600 Hdfs split stats (:<# splits>/): Fragment Instance Lifecycle Event Timeline: 1m22s - Prepare Finished: 5.999ms (5.999ms) - Open Finished: 1m22s (1m21s) - First Batch Produced: 1m22s (83.998ms) - First Batch Sent: 1m22s (0.000ns) - ExecInternal Finished: 1m22s (71.998ms) MemoryUsage(2s000ms): 921.12 KB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 628.77 KB ThreadUsage(2s000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.01 - BloomFilterBytes: 0 - PeakMemoryUsage: 1.19 MB (1246720) - PeakReservation: 0 - PeakUsedReservation: 0 - PerHostPeakMemUsage: 5.75 MB (6031104) - RowsProduced: 14 (14) - TotalNetworkReceiveTime: 0.000ns - TotalNetworkSendTime: 63.998ms - TotalStorageWaitTime: 146.997ms - TotalThreadsInvoluntaryContextSwitches: 5.49K (5486) - TotalThreadsTotalWallClockTime: 1m22s - TotalThreadsSysTime: 21.849ms - TotalThreadsUserTime: 1m16s - TotalThreadsVoluntaryContextSwitches: 53 (53) Buffer pool: - AllocTime: 0.000ns - CumulativeAllocationBytes: 0 - CumulativeAllocations: 0 (0) - PeakReservation: 0 - PeakUnpinnedBytes: 0 - PeakUsedReservation: 0 - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - ReservationLimit: 0 - SystemAllocTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns Fragment Instance Lifecycle Timings: - ExecTime: 154.997ms - ExecTreeExecTime: 88.998ms - OpenTime: 1m21s - ExecTreeOpenTime: 172.996ms - PrepareTime: 3.999ms - ExecTreePrepareTime: 999.981us KrpcDataStreamSender (dst_id=4):(Total: 66.998ms, non-child: 2.999ms, % non-child: 4.48%) ExecOption: Unpartitioned Sender Codegen Disabled: not needed BytesSent(2s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - NetworkThroughput: (Avg: 22.64 KB/sec ; Min: 6.60 KB/sec ; Max: 71.46 KB/sec ; Number of samples: 9) - EosSent: 3 (3) - PeakMemoryUsage: 24.00 KB (24576) - RowsSent: 14 (14) - RpcFailure: 0 (0) - RpcRetry: 0 (0) - SerializeBatchTime: 0.000ns - TotalBytesSent: 690.00 B (690) - UncompressedRowBatchSize: 1008.00 B (1008) KUDU_SCAN_NODE (id=1):(Total: 390.992ms, non-child: 390.992ms, % non-child: 100.00%) Node Lifecycle Event Timeline: 1m22s - Open Started: 1m21s (1m21s) - Open Finished: 1m22s (171.996ms) - First Batch Requested: 1m22s (0.000ns) - First Batch Returned: 1m22s (83.998ms) - Last Batch Returned: 1m22s (38.999ms) - Closed: 1m22s (31.999ms) - AverageScannerThreadConcurrency: 2.00 - KuduClientTime: 146.997ms - KuduRemoteScanTokens: 0 (0) - MaterializeTupleTime(*): 999.981us - NumScannerThreadMemUnavailable: 0 (0) - NumScannerThreadsStarted: 2 (2) - PeakMemoryUsage: 28.00 KB (28672) - PeakScannerThreadConcurrency: 2 (2) - RowBatchBytesEnqueued: 48.00 KB (49152) - RowBatchQueueGetWaitTime: 88.998ms - RowBatchQueuePeakMemoryUsage: 24.00 KB (24576) - RowBatchQueuePutWaitTime: 0.000ns - RowBatchesEnqueued: 3 (3) - RowsRead: 14 (14) - RowsReturned: 14 (14) - RowsReturnedRate: 35.00 /sec - ScanRangesComplete: 3 (3) - ScannerThreadsInvoluntaryContextSwitches: 0 (0) - ScannerThreadsTotalWallClockTime: 208.996ms - ScannerThreadsSysTime: 0.000ns - ScannerThreadsUserTime: 11.280ms - ScannerThreadsVoluntaryContextSwitches: 8 (8) - TotalKuduScanRoundTrips: 3 (3) CodeGen:(Total: 1m21s, non-child: 1m21s, % non-child: 100.00%) - CodegenInvoluntaryContextSwitches: 5.46K (5465) - CodegenTotalWallClockTime: 1m21s - CodegenSysTime: 10.924ms - CodegenUserTime: 1m16s - CodegenVoluntaryContextSwitches: 32 (32) - CompileTime: 750.985ms - IrGenerationTime: 36.999ms - LoadTime: 0.000ns - ModuleBitcodeSize: 2.32 MB (2434748) - NumFunctions: 76 (76) - NumInstructions: 2.37K (2371) - OptimizationTime: 1m20s - PeakMemoryUsage: 1.16 MB (1213952) - PrepareTime: 184.996ms Instance 2b4a14d9933eb108:7565b86500000002 (host=downstream-jenkins-host:22002):(Total: 58s701ms, non-child: 1.999ms, % non-child: 0.00%) Last report received time: 2019-01-18 00:10:20.313 Hdfs split stats (:<# splits>/): Fragment Instance Lifecycle Event Timeline: 58s703ms - Prepare Finished: 4.999ms (4.999ms) - Open Finished: 58s648ms (58s643ms) - First Batch Produced: 58s649ms (999.981us) - First Batch Sent: 58s649ms (0.000ns) - ExecInternal Finished: 58s703ms (53.998ms) MemoryUsage(1s000ms): 624.75 KB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB, 1.19 MB ThreadUsage(1s000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.00 - BloomFilterBytes: 0 - PeakMemoryUsage: 1.19 MB (1246720) - PeakReservation: 0 - PeakUsedReservation: 0 - PerHostPeakMemUsage: 5.69 MB (5969664) - RowsProduced: 13 (13) - TotalNetworkReceiveTime: 0.000ns - TotalNetworkSendTime: 28.999ms - TotalStorageWaitTime: 65.998ms - TotalThreadsInvoluntaryContextSwitches: 3.17K (3165) - TotalThreadsTotalWallClockTime: 58s814ms - TotalThreadsSysTime: 48.766ms - TotalThreadsUserTime: 55s831ms - TotalThreadsVoluntaryContextSwitches: 20 (20) Buffer pool: - AllocTime: 0.000ns - CumulativeAllocationBytes: 0 - CumulativeAllocations: 0 (0) - PeakReservation: 0 - PeakUnpinnedBytes: 0 - PeakUsedReservation: 0 - ReadIoBytes: 0 - ReadIoOps: 0 (0) - ReadIoWaitTime: 0.000ns - ReservationLimit: 0 - SystemAllocTime: 0.000ns - WriteIoBytes: 0 - WriteIoOps: 0 (0) - WriteIoWaitTime: 0.000ns Fragment Instance Lifecycle Timings: - ExecTime: 53.998ms - ExecTreeExecTime: 24.999ms - OpenTime: 58s643ms - ExecTreeOpenTime: 76.998ms - PrepareTime: 3.999ms - ExecTreePrepareTime: 999.980us KrpcDataStreamSender (dst_id=4):(Total: 29.999ms, non-child: 999.981us, % non-child: 3.33%) ExecOption: Unpartitioned Sender Codegen Disabled: not needed BytesSent(1s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - NetworkThroughput: (Avg: 31.78 KB/sec ; Min: 4.95 KB/sec ; Max: 132.40 KB/sec ; Number of samples: 9) - EosSent: 3 (3) - PeakMemoryUsage: 24.00 KB (24576) - RowsSent: 13 (13) - RpcFailure: 0 (0) - RpcRetry: 0 (0) - SerializeBatchTime: 0.000ns - TotalBytesSent: 627.00 B (627) - UncompressedRowBatchSize: 936.00 B (936) KUDU_SCAN_NODE (id=1):(Total: 103.998ms, non-child: 103.998ms, % non-child: 100.00%) Node Lifecycle Event Timeline: 58s702ms - Open Started: 58s571ms (58s571ms) - Open Finished: 58s648ms (76.998ms) - First Batch Requested: 58s648ms (0.000ns) - First Batch Returned: 58s649ms (999.981us) - Last Batch Returned: 58s673ms (23.999ms) - Closed: 58s702ms (28.999ms) - AverageScannerThreadConcurrency: 0.00 - KuduClientTime: 65.998ms - KuduRemoteScanTokens: 0 (0) - MaterializeTupleTime(*): 999.981us - NumScannerThreadMemUnavailable: 0 (0) - NumScannerThreadsStarted: 3 (3) - PeakMemoryUsage: 28.00 KB (28672) - PeakScannerThreadConcurrency: 3 (3) - RowBatchBytesEnqueued: 48.00 KB (49152) - RowBatchQueueGetWaitTime: 23.999ms - RowBatchQueuePeakMemoryUsage: 24.00 KB (24576) - RowBatchQueuePutWaitTime: 0.000ns - RowBatchesEnqueued: 3 (3) - RowsRead: 13 (13) - RowsReturned: 13 (13) - RowsReturnedRate: 125.00 /sec - ScanRangesComplete: 3 (3) - ScannerThreadsInvoluntaryContextSwitches: 0 (0) - ScannerThreadsTotalWallClockTime: 116.997ms - ScannerThreadsSysTime: 0.000ns - ScannerThreadsUserTime: 10.770ms - ScannerThreadsVoluntaryContextSwitches: 8 (8) - TotalKuduScanRoundTrips: 3 (3) CodeGen:(Total: 58s565ms, non-child: 58s565ms, % non-child: 100.00%) - CodegenInvoluntaryContextSwitches: 3.12K (3120) - CodegenTotalWallClockTime: 58s565ms - CodegenSysTime: 11.942ms - CodegenUserTime: 55s808ms - CodegenVoluntaryContextSwitches: 2 (2) - CompileTime: 322.993ms - IrGenerationTime: 48.999ms - LoadTime: 0.000ns - ModuleBitcodeSize: 2.32 MB (2434748) - NumFunctions: 76 (76) - NumInstructions: 2.37K (2371) - OptimizationTime: 58s033ms - PeakMemoryUsage: 1.16 MB (1213952) - PrepareTime: 154.997ms