impalad /backends /catalog /hadoop-varz /logs /memz /metrics /queries /rpcz /sessions /threadz /varz Query 1d450fc48c2dd820:5346b5ca90c9afbb Plan Query Text plan Summary Profile Query (id=1d450fc48c2dd820:5346b5ca90c9afbb): Summary: Session ID: 764827bb8577bed3:d878acda365848a0 Session Type: BEESWAX Start Time: 2015-10-01 01:39:39.305406000 End Time: 2015-10-01 01:41:01.353901000 Query Type: QUERY Query State: FINISHED Query Status: OK Impala Version: impalad version 2.3.0-cdh5-INTERNAL RELEASE (build a60edb19747b88833fd34028247d1345bbcaaa92) User: casey Connected User: casey Delegated User: Network Address: 172.20.86.26:49604 Default Db: tpch_300_parquet Sql Statement: select c_count, count(*) as custdist from ( select c_custkey, count(o_orderkey) as c_count from customer left outer join orders on ( c_custkey = o_custkey and o_comment not like '%special%requests%' ) group by c_custkey ) as c_orders group by c_count order by custdist desc, c_count desc Coordinator: c2118.hal.cloudera.com:22000 Plan: ---------------- Estimated Per-Host Requirements: Memory=1.25GB VCores=2 F05:PLAN FRAGMENT [UNPARTITIONED] 12:MERGING-EXCHANGE [UNPARTITIONED] order by: count(*) DESC, c_count DESC hosts=10 per-host-mem=unavailable tuple-ids=5 row-size=16B cardinality=53086384 F04:PLAN FRAGMENT [HASH(c_count)] DATASTREAM SINK [FRAGMENT=F05, EXCHANGE=12, UNPARTITIONED] 05:SORT | order by: count(*) DESC, c_count DESC | hosts=10 per-host-mem=88.00MB | tuple-ids=5 row-size=16B cardinality=53086384 | 11:AGGREGATE [FINALIZE] | output: count:merge(*) | group by: c_count | hosts=10 per-host-mem=389.85MB | tuple-ids=4 row-size=16B cardinality=53086384 | 10:EXCHANGE [HASH(c_count)] hosts=10 per-host-mem=0B tuple-ids=4 row-size=16B cardinality=53086384 F03:PLAN FRAGMENT [HASH(c_custkey)] DATASTREAM SINK [FRAGMENT=F04, EXCHANGE=10, HASH(c_count)] 04:AGGREGATE | output: count(*) | group by: count(o_orderkey) | hosts=10 per-host-mem=891.04MB | tuple-ids=4 row-size=16B cardinality=53086384 | 09:AGGREGATE [FINALIZE] | output: count:merge(o_orderkey) | group by: c_custkey | hosts=10 per-host-mem=89.10MB | tuple-ids=2 row-size=16B cardinality=53086384 | 08:EXCHANGE [HASH(c_custkey)] hosts=10 per-host-mem=0B tuple-ids=2 row-size=16B cardinality=53086384 F02:PLAN FRAGMENT [HASH(o_custkey)] DATASTREAM SINK [FRAGMENT=F03, EXCHANGE=08, HASH(c_custkey)] 03:AGGREGATE | output: count(o_orderkey) | group by: c_custkey | hosts=10 per-host-mem=891.04MB | tuple-ids=2 row-size=16B cardinality=53086384 | 02:HASH JOIN [RIGHT OUTER JOIN, PARTITIONED] | hash predicates: o_custkey = c_custkey | hosts=10 per-host-mem=37.77MB | tuple-ids=1N,0 row-size=88B cardinality=405000000 | |--07:EXCHANGE [HASH(c_custkey)] | hosts=10 per-host-mem=0B | tuple-ids=0 row-size=8B cardinality=45000000 | 06:EXCHANGE [HASH(o_custkey)] hosts=10 per-host-mem=0B tuple-ids=1 row-size=80B cardinality=405000000 F01:PLAN FRAGMENT [RANDOM] DATASTREAM SINK [FRAGMENT=F02, EXCHANGE=07, HASH(c_custkey)] 00:SCAN HDFS [tpch_300_parquet.customer, RANDOM] partitions=1/1 files=20 size=3.52GB table stats: 45000000 rows total column stats: all hosts=10 per-host-mem=88.00MB tuple-ids=0 row-size=8B cardinality=45000000 F00:PLAN FRAGMENT [RANDOM] DATASTREAM SINK [FRAGMENT=F02, EXCHANGE=06, HASH(o_custkey)] 01:SCAN HDFS [tpch_300_parquet.orders, RANDOM] partitions=1/1 files=80 size=18.82GB predicates: NOT o_comment LIKE '%special%requests%' table stats: 450000000 rows total column stats: all hosts=10 per-host-mem=264.00MB tuple-ids=1 row-size=80B cardinality=405000000 ---------------- Estimated Per-Host Mem: 1343111263 Estimated Per-Host VCores: 2 Request Pool: default-pool ExecSummary: Operator #Hosts Avg Time Max Time #Rows Est. #Rows Peak Mem Est. Peak Mem Detail --------------------------------------------------------------------------------------------------------------------------------- 12:MERGING-EXCHANGE 1 142.879us 142.879us 44 53.09M 0 -1.00 B UNPARTITIONED 05:SORT 10 100.973us 107.15us 44 53.09M 8.02 MB 88.00 MB 11:AGGREGATE 10 247.361ms 256.275ms 44 53.09M 3.30 MB 389.85 MB FINALIZE 10:EXCHANGE 10 277.773us 475.921us 418 53.09M 0 0 HASH(c_count) 04:AGGREGATE 10 441.752ms 448.553ms 418 53.09M 3.52 MB 891.04 MB 09:AGGREGATE 10 37s147ms 38s254ms 45.00M 53.09M 271.04 MB 89.10 MB FINALIZE 08:EXCHANGE 10 121.714ms 129.775ms 45.00M 53.09M 0 0 HASH(c_custkey) 03:AGGREGATE 10 14s829ms 15s482ms 45.00M 53.09M 271.02 MB 891.04 MB 02:HASH JOIN 10 19s071ms 20s276ms 460.15M 405.00M 267.02 MB 37.77 MB RIGHT OUTER JOIN, PARTITIONED |--07:EXCHANGE 10 149.142ms 158.266ms 45.00M 45.00M 0 0 HASH(c_custkey) | 00:SCAN HDFS 10 81.677ms 99.895ms 45.00M 45.00M 37.70 MB 88.00 MB tpch_300_parquet.customer 06:EXCHANGE 10 2s728ms 3s222ms 445.15M 405.00M 0 0 HASH(o_custkey) 01:SCAN HDFS 10 387.790ms 567.416ms 445.15M 405.00M 899.98 MB 264.00 MB tpch_300_parquet.orders Planner Timeline: 51.31ms - Analysis finished: 19.701ms (19.701ms) - Equivalence classes computed: 21.87ms (1.385ms) - Single node plan created: 30.844ms (9.756ms) - Distributed plan created: 35.41ms (4.197ms) - Lineage info computed: 37.356ms (2.314ms) - Planning finished: 51.31ms (13.675ms) Query Timeline: 1m22s - Start execution: 63.741us (63.741us) - Planning finished: 56.910ms (56.846ms) - Ready to start remote fragments: 58.200ms (1.289ms) - Remote fragments started: 862.997ms (804.797ms) - Rows available: 1m21s (1m20s) - First row fetched: 1m22s (939.661ms) - Unregister query: 1m22s (15.21ms) ImpalaServer: - ClientFetchWaitTimer: 948.759ms - RowMaterializationTimer: 101.450us Execution Profile 1d450fc48c2dd820:5346b5ca90c9afbb:(Total: 1m21s, non-child: 0ns, % non-child: 0.00%) Fragment start latencies: count: 50, last: 0.005215ns, min: 0.002279ns, max: 0.264837ns, mean: 0.154395ns, stddev: 0.123118ns Per Node Peak Memory Usage: c2134.hal.cloudera.com:22000(1.20 GB) c2136.hal.cloudera.com:22000(1.28 GB) c2122.hal.cloudera.com:22000(1.30 GB) c2124.hal.cloudera.com:22000(1.34 GB) c2128.hal.cloudera.com:22000(1.29 GB) c2126.hal.cloudera.com:22000(1.20 GB) c2132.hal.cloudera.com:22000(1.30 GB) c2130.hal.cloudera.com:22000(1.36 GB) c2120.hal.cloudera.com:22000(1.26 GB) c2118.hal.cloudera.com:22000(1.18 GB) - FinalizationTimer: 0ns Coordinator Fragment F05:(Total: 1m20s, non-child: 248.22us, % non-child: 0.00%) MemoryUsage(2s000ms): 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 28.17 KB ThreadUsage(500.0ms): 1, 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 48.34 KB (49504) - PerHostPeakMemUsage: 0 - PrepareTime: 34.130us - RowsProduced: 44 (44) - TotalCpuTime: 1m21s - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 0ns - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 288 (288) - BlocksRecycled: 49 (49) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 30.16 GB (32385830912) - PeakMemoryUsage: 456.75 MB (478937088) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns EXCHANGE_NODE (id=12):(Total: 1m20s, non-child: 142.879us, % non-child: 0.00%) 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, 515.00 B - BytesReceived: 1.01 KB (1030) - ConvertRowBatchTime: 0ns - DeserializeRowBatchTimer: 85.526us - FirstBatchArrivalWaitTime: 1m20s - MergeGetNext: 61.494us - MergeGetNextBatch: 34.693us - PeakMemoryUsage: 0 - RowsReturned: 44 (44) - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Averaged Fragment F04:(Total: 1m20s, non-child: 0ns, % non-child: 0.00%) split sizes: min: 0, max: 0, avg: 0, stddev: 0 completion times: min:1m20s max:1m20s mean: 1m20s stddev:4.717025.717.025407ms execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec num instances: 10 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 8.69 MB (9113321) - PerHostPeakMemUsage: 1.27 GB (1362296471) - PrepareTime: 246.959ms - RowsProduced: 4 (4) - TotalCpuTime: 660.895ms - TotalNetworkReceiveTime: 1m20s - TotalNetworkSendTime: 401.782us - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 288 (288) - BlocksRecycled: 49 (49) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 30.16 GB (32385830912) - PeakMemoryUsage: 456.75 MB (478937088) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 653.992ms, non-child: 653.992ms, % non-child: 100.00%) - CodegenTime: 4.131ms - CompileTime: 46.682ms - LoadTime: 103.252us - ModuleFileSize: 2.43 MB (2543720) - OptimizationTime: 364.718ms - PrepareTime: 240.886ms DataStreamSender (dst_id=12):(Total: 38.53us, non-child: 38.53us, % non-child: 100.00%) - BytesSent: 103.00 B (103) - NetworkThroughput(*): 352.76 KB/sec - OverallThroughput: 2.60 MB/sec - PeakMemoryUsage: 5.33 KB (5456) - SerializeBatchTime: 11.175us - ThriftTransmitTime(*): 297.354us - UncompressedRowBatchSize: 127.00 B (127) SORT_NODE (id=5):(Total: 1m20s, non-child: 100.973us, % non-child: 0.00%) - InMemorySortTime: 2.803us - InitialRunsCreated: 1 (1) - PeakMemoryUsage: 8.02 MB (8404992) - RowsReturned: 4 (4) - RowsReturnedRate: 0 - SortDataSize: 105.00 B (105) - TotalMergesPerformed: 0 (0) AGGREGATION_NODE (id=11):(Total: 1m20s, non-child: 247.361ms, % non-child: 0.31%) - BuildTime: 32.424us - GetNewBlockTime: 48.41us - GetResultsTime: 9.934us - HTResizeTime: 3.982us - HashBuckets: 3.38K (3379) - LargestPartitionPercent: 4 (4) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 3.30 MB (3456204) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 4 (4) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) - UnpinTime: 1.2us EXCHANGE_NODE (id=10):(Total: 1m20s, non-child: 1m20s, % non-child: 100.00%) - BytesReceived: 753.00 B (753) - ConvertRowBatchTime: 16.420us - DeserializeRowBatchTimer: 76.903us - FirstBatchArrivalWaitTime: 1m18s - PeakMemoryUsage: 0 - RowsReturned: 41 (41) - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Averaged Fragment F03:(Total: 1m19s, non-child: 0ns, % non-child: 0.00%) split sizes: min: 0, max: 0, avg: 0, stddev: 0 completion times: min:1m18s max:1m20s mean: 1m19s stddev:526.194365.194.364906ms execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec num instances: 10 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 276.92 MB (290372249) - PerHostPeakMemUsage: 1.27 GB (1362296471) - PrepareTime: 253.926ms - RowsProduced: 41 (41) - TotalCpuTime: 38s271ms - TotalNetworkReceiveTime: 41s400ms - TotalNetworkSendTime: 3.774ms - TotalStorageWaitTime: 0ns CodeGen:(Total: 821.111ms, non-child: 821.111ms, % non-child: 100.00%) - CodegenTime: 7.745ms - CompileTime: 97.646ms - LoadTime: 131.721us - ModuleFileSize: 2.43 MB (2543720) - OptimizationTime: 477.742ms - PrepareTime: 244.40ms DataStreamSender (dst_id=10):(Total: 55.358us, non-child: 55.358us, % non-child: 100.00%) - BytesSent: 753.00 B (753) - NetworkThroughput(*): 251.22 KB/sec - OverallThroughput: 13.10 MB/sec - PeakMemoryUsage: 93.28 KB (95520) - SerializeBatchTime: 90.895us - ThriftTransmitTime(*): 2.938ms - UncompressedRowBatchSize: 1.18 KB (1210) AGGREGATION_NODE (id=4):(Total: 1m19s, non-child: 441.752ms, % non-child: 0.56%) - BuildTime: 188.322ms - GetNewBlockTime: 62.627us - GetResultsTime: 37.147us - HTResizeTime: 4.83ms - HashBuckets: 16.38K (16384) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 3.52 MB (3694592) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 41 (41) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) - UnpinTime: 862ns AGGREGATION_NODE (id=9):(Total: 1m18s, non-child: 37s147ms, % non-child: 47.23%) - BuildTime: 36s921ms - GetNewBlockTime: 184.422us - GetResultsTime: 211.389ms - HTResizeTime: 187.135ms - HashBuckets: 8.39M (8388608) - LargestPartitionPercent: 6 (6) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 271.03 MB (284198476) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 4.50M (4500000) - RowsReturnedRate: 57.22 K/sec - SpilledPartitions: 0 (0) - UnpinTime: 978ns EXCHANGE_NODE (id=8):(Total: 41s499ms, non-child: 41s499ms, % non-child: 100.00%) - BytesReceived: 54.43 MB (57071558) - ConvertRowBatchTime: 90.900ms - DeserializeRowBatchTimer: 184.294ms - FirstBatchArrivalWaitTime: 41s376ms - PeakMemoryUsage: 0 - RowsReturned: 4.50M (4500000) - RowsReturnedRate: 108.43 K/sec - SendersBlockedTimer: 28s037ms - SendersBlockedTotalTimer(*): 28s038ms Averaged Fragment F02:(Total: 1m11s, non-child: 0ns, % non-child: 0.00%) split sizes: min: 0, max: 0, avg: 0, stddev: 0 completion times: min:1m11s max:1m12s mean: 1m11s stddev:439.678258.678.257859ms execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec num instances: 10 - AverageThreadTokens: 1.02 - PeakMemoryUsage: 481.33 MB (504714008) - PerHostPeakMemUsage: 1.27 GB (1362296471) - PrepareTime: 253.632ms - RowsProduced: 4.50M (4500000) - TotalCpuTime: 37s318ms - TotalNetworkReceiveTime: 8s090ms - TotalNetworkSendTime: 28s501ms - TotalStorageWaitTime: 0ns CodeGen:(Total: 846.438ms, non-child: 846.438ms, % non-child: 100.00%) - CodegenTime: 4.135ms - CompileTime: 78.986ms - LoadTime: 93.282us - ModuleFileSize: 2.43 MB (2543720) - OptimizationTime: 521.734ms - PrepareTime: 244.32ms DataStreamSender (dst_id=8):(Total: 29s880ms, non-child: 29s880ms, % non-child: 100.00%) - BytesSent: 54.43 MB (57071558) - NetworkThroughput(*): 1.86 MB/sec - OverallThroughput: 1.82 MB/sec - PeakMemoryUsage: 81.28 KB (83232) - SerializeBatchTime: 498.647ms - ThriftTransmitTime(*): 29s203ms - UncompressedRowBatchSize: 120.19 MB (126026394) AGGREGATION_NODE (id=3):(Total: 41s604ms, non-child: 14s829ms, % non-child: 35.65%) - BuildTime: 14s162ms - GetNewBlockTime: 216.665us - GetResultsTime: 259.22ms - HTResizeTime: 252.871ms - HashBuckets: 8.39M (8388608) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 271.02 MB (284180480) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 4.50M (4500000) - RowsReturnedRate: 108.16 K/sec - SpilledPartitions: 0 (0) - UnpinTime: 989ns HASH_JOIN_NODE (id=2):(Total: 26s774ms, non-child: 17s264ms, % non-child: 64.48%) - BuildPartitionTime: 318.479ms - BuildRows: 4.50M (4500000) - BuildRowsPartitioned: 4.50M (4500000) - BuildTime: 485.140ms - GetNewBlockTime: 230.864us - HashBuckets: 8.39M (8388608) - LargestPartitionPercent: 6 (6) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 267.02 MB (279994368) - PinTime: 0ns - ProbeRows: 44.51M (44514972) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 16s203ms - RowsReturned: 46.01M (46014994) - RowsReturnedRate: 1.72 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.371us EXCHANGE_NODE (id=7):(Total: 893.57ms, non-child: 893.57ms, % non-child: 100.00%) - BytesReceived: 53.11 MB (55684770) - ConvertRowBatchTime: 112.360ms - DeserializeRowBatchTimer: 167.220ms - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 4.50M (4500000) - RowsReturnedRate: 5.06 M/sec - SendersBlockedTimer: 257.311ms - SendersBlockedTotalTimer(*): 2s437ms EXCHANGE_NODE (id=6):(Total: 8s616ms, non-child: 8s616ms, % non-child: 100.00%) - BytesReceived: 2.16 GB (2320886471) - ConvertRowBatchTime: 1s150ms - DeserializeRowBatchTimer: 8s278ms - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 44.51M (44514972) - RowsReturnedRate: 5.22 M/sec - SendersBlockedTimer: 2s909ms - SendersBlockedTotalTimer(*): 23s055ms Averaged Fragment F01:(Total: 1s438ms, non-child: 7.869ms, % non-child: 0.55%) split sizes: min: 252.16 MB, max: 504.42 MB, avg: 360.22 MB, stddev: 88.09 MB completion times: min:1s190ms max:1s811ms mean: 1s458ms stddev:206.156789.156.788743ms execution rates: min:206.77 MB/sec max:283.41 MB/sec mean:243.49 MB/sec stddev:26.82 MB/sec num instances: 10 - AverageThreadTokens: 2.63 - PeakMemoryUsage: 29.59 MB (31028944) - PerHostPeakMemUsage: 1013.47 MB (1062700175) - PrepareTime: 96.234us - RowsProduced: 4.50M (4500000) - TotalCpuTime: 3s691ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 328.412ms - TotalStorageWaitTime: 90.799ms DataStreamSender (dst_id=7):(Total: 1s348ms, non-child: 1s348ms, % non-child: 100.00%) - BytesSent: 53.11 MB (55684770) - NetworkThroughput(*): 7.79 MB/sec - OverallThroughput: 38.79 MB/sec - PeakMemoryUsage: 360.00 KB (368640) - SerializeBatchTime: 495.299ms - ThriftTransmitTime(*): 6s717ms - UncompressedRowBatchSize: 85.85 MB (90017598) HDFS_SCAN_NODE (id=0):(Total: 81.677ms, non-child: 81.677ms, % non-child: 100.00%) - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 1.63 - BytesRead: 17.57 MB (18423838) - BytesReadDataNodeCache: 0 - BytesReadLocal: 17.57 MB (18423838) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 17.57 MB (18423838) - DecompressionTime: 85.254ms - MaxCompressedTextFileLength: 0 - NumColumns: 2 (2) - NumDisksAccessed: 2 (2) - NumScannerThreadsStarted: 2 (2) - PeakMemoryUsage: 29.29 MB (30708899) - PerReadThreadRawHdfsThroughput: 821.74 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 4.50M (4500000) - RowsReturned: 4.50M (4500000) - RowsReturnedRate: 55.35 M/sec - ScanRangesComplete: 2 (2) - ScannerThreadsInvoluntaryContextSwitches: 202 (202) - ScannerThreadsTotalWallClockTime: 2s650ms - MaterializeTupleTime(*): 2s464ms - ScannerThreadsSysTime: 25.295ms - ScannerThreadsUserTime: 428.534ms - ScannerThreadsVoluntaryContextSwitches: 4.10K (4101) - TotalRawHdfsReadTime(*): 22.279ms - TotalReadThroughput: 12.12 MB/sec Averaged Fragment F00:(Total: 38s068ms, non-child: 69.564ms, % non-child: 0.18%) split sizes: min: 1.73 GB, max: 2.02 GB, avg: 1.88 GB, stddev: 99.52 MB completion times: min:34s265ms max:41s050ms mean: 38s175ms stddev:2s060ms execution rates: min:49.60 MB/sec max:51.70 MB/sec mean:50.50 MB/sec stddev:699.07 KB/sec num instances: 10 - AverageThreadTokens: 8.53 - PeakMemoryUsage: 810.46 MB (849826822) - PerHostPeakMemUsage: 1.27 GB (1362296471) - PrepareTime: 135.506us - RowsProduced: 44.51M (44514972) - TotalCpuTime: 5m23s - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3s057ms - TotalStorageWaitTime: 662.793ms DataStreamSender (dst_id=6):(Total: 37s611ms, non-child: 37s611ms, % non-child: 100.00%) - BytesSent: 2.16 GB (2320886471) - NetworkThroughput(*): 15.87 MB/sec - OverallThroughput: 58.86 MB/sec - PeakMemoryUsage: 631.95 KB (647120) - SerializeBatchTime: 25s315ms - ThriftTransmitTime(*): 2m19s - UncompressedRowBatchSize: 3.83 GB (4112779191) HDFS_SCAN_NODE (id=1):(Total: 387.790ms, non-child: 387.790ms, % non-child: 100.00%) - AverageHdfsReadThreadConcurrency: 0.01 - AverageScannerThreadConcurrency: 7.54 - BytesRead: 1.27 GB (1359736348) - BytesReadDataNodeCache: 0 - BytesReadLocal: 1.27 GB (1359736348) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 1.27 GB (1359736348) - DecompressionTime: 6s448ms - MaxCompressedTextFileLength: 0 - NumColumns: 24 (24) - NumDisksAccessed: 6 (6) - NumScannerThreadsStarted: 7 (7) - PeakMemoryUsage: 809.95 MB (849291169) - PerReadThreadRawHdfsThroughput: 960.93 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 45.00M (45000000) - RowsReturned: 44.51M (44514972) - RowsReturnedRate: 117.21 M/sec - ScanRangesComplete: 8 (8) - ScannerThreadsInvoluntaryContextSwitches: 20.65K (20650) - ScannerThreadsTotalWallClockTime: 4m48s - MaterializeTupleTime(*): 4m41s - ScannerThreadsSysTime: 676.493ms - ScannerThreadsUserTime: 46s432ms - ScannerThreadsVoluntaryContextSwitches: 43.05K (43048) - TotalRawHdfsReadTime(*): 1s356ms - TotalReadThroughput: 34.05 MB/sec Fragment F04: Instance 1d450fc48c2dd820:5346b5ca90c9afc2 (host=c2128.hal.cloudera.com:22000):(Total: 1m20s, non-child: 0ns, % non-child: 0.00%) MemoryUsage(2s000ms): 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.27 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 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 8.63 MB (9049424) - PerHostPeakMemUsage: 1.29 GB (1381018072) - PrepareTime: 246.39ms - RowsProduced: 5 (5) - TotalCpuTime: 653.328ms - TotalNetworkReceiveTime: 1m20s - TotalNetworkSendTime: 412.925us - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 288 (288) - BlocksRecycled: 49 (49) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 30.16 GB (32385830912) - PeakMemoryUsage: 456.75 MB (478937088) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 646.710ms, non-child: 646.710ms, % non-child: 100.00%) - CodegenTime: 4.75ms - CompileTime: 46.130ms - LoadTime: 92.253us - ModuleFileSize: 2.43 MB (2543720) - OptimizationTime: 358.855ms - PrepareTime: 240.187ms DataStreamSender (dst_id=12):(Total: 34.882us, non-child: 34.882us, % non-child: 100.00%) - BytesSent: 105.00 B (105) - NetworkThroughput(*): 339.98 KB/sec - OverallThroughput: 2.87 MB/sec - PeakMemoryUsage: 5.33 KB (5456) - SerializeBatchTime: 8.380us - ThriftTransmitTime(*): 301.603us - UncompressedRowBatchSize: 144.00 B (144) SORT_NODE (id=5):(Total: 1m20s, non-child: 96.788us, % non-child: 0.00%) - InMemorySortTime: 3.175us - InitialRunsCreated: 1 (1) - PeakMemoryUsage: 8.02 MB (8404992) - RowsReturned: 5 (5) - RowsReturnedRate: 0 - SortDataSize: 120.00 B (120) - TotalMergesPerformed: 0 (0) AGGREGATION_NODE (id=11):(Total: 1m20s, non-child: 246.423ms, % non-child: 0.31%) ExecOption: Codegen Enabled - BuildTime: 20.15us - GetNewBlockTime: 51.995us - GetResultsTime: 10.399us - HTResizeTime: 3.718us - HashBuckets: 3.07K (3072) - LargestPartitionPercent: 4 (4) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 3.30 MB (3457024) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 5 (5) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) - UnpinTime: 955ns EXCHANGE_NODE (id=10):(Total: 1m20s, non-child: 197.73us, % non-child: 0.00%) 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, 161.00 B - BytesReceived: 920.00 B (920) - ConvertRowBatchTime: 14.249us - DeserializeRowBatchTimer: 75.799us - FirstBatchArrivalWaitTime: 1m18s - PeakMemoryUsage: 0 - RowsReturned: 50 (50) - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 1d450fc48c2dd820:5346b5ca90c9afbf (host=c2120.hal.cloudera.com:22000):(Total: 1m20s, non-child: 0ns, % non-child: 0.00%) MemoryUsage(2s000ms): 2.45 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.27 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 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 8.22 MB (8623440) - PerHostPeakMemUsage: 1.26 GB (1353256608) - PrepareTime: 249.285ms - RowsProduced: 1 (1) - TotalCpuTime: 659.609ms - TotalNetworkReceiveTime: 1m20s - TotalNetworkSendTime: 429.143us - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 288 (288) - BlocksRecycled: 49 (49) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 30.16 GB (32385830912) - PeakMemoryUsage: 456.75 MB (478937088) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 652.472ms, non-child: 652.472ms, % non-child: 100.00%) - CodegenTime: 4.206ms - CompileTime: 45.685ms - LoadTime: 118.921us - ModuleFileSize: 2.43 MB (2543720) - OptimizationTime: 361.943ms - PrepareTime: 243.118ms DataStreamSender (dst_id=12):(Total: 37.614us, non-child: 37.614us, % non-child: 100.00%) - BytesSent: 25.00 B (25) - NetworkThroughput(*): 73.54 KB/sec - OverallThroughput: 649.07 KB/sec - PeakMemoryUsage: 5.33 KB (5456) - SerializeBatchTime: 10.610us - ThriftTransmitTime(*): 331.962us - UncompressedRowBatchSize: 32.00 B (32) SORT_NODE (id=5):(Total: 1m20s, non-child: 101.367us, % non-child: 0.00%) - InMemorySortTime: 1.67us - InitialRunsCreated: 1 (1) - PeakMemoryUsage: 8.02 MB (8404992) - RowsReturned: 1 (1) - RowsReturnedRate: 0 - SortDataSize: 24.00 B (24) - TotalMergesPerformed: 0 (0) AGGREGATION_NODE (id=11):(Total: 1m20s, non-child: 249.918ms, % non-child: 0.31%) ExecOption: Codegen Enabled - BuildTime: 18.552us - GetNewBlockTime: 48.961us - GetResultsTime: 4.598us - HTResizeTime: 4.236us - HashBuckets: 1.02K (1024) - LargestPartitionPercent: 10 (10) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 3.30 MB (3457024) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 1 (1) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) - UnpinTime: 1.2us EXCHANGE_NODE (id=10):(Total: 1m20s, non-child: 255.772us, % non-child: 0.00%) 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, 56.00 B - BytesReceived: 250.00 B (250) - ConvertRowBatchTime: 15.378us - DeserializeRowBatchTimer: 71.290us - FirstBatchArrivalWaitTime: 1m18s - PeakMemoryUsage: 0 - RowsReturned: 10 (10) - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 1d450fc48c2dd820:5346b5ca90c9afc1 (host=c2126.hal.cloudera.com:22000):(Total: 1m20s, non-child: 0ns, % non-child: 0.00%) MemoryUsage(2s000ms): 2.45 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.27 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 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 8.83 MB (9262416) - PerHostPeakMemUsage: 1.20 GB (1285124280) - PrepareTime: 244.188ms - RowsProduced: 5 (5) - TotalCpuTime: 654.891ms - TotalNetworkReceiveTime: 1m20s - TotalNetworkSendTime: 514.151us - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 288 (288) - BlocksRecycled: 49 (49) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 30.16 GB (32385830912) - PeakMemoryUsage: 456.75 MB (478937088) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 647.746ms, non-child: 647.746ms, % non-child: 100.00%) - CodegenTime: 4.94ms - CompileTime: 46.376ms - LoadTime: 110.198us - ModuleFileSize: 2.43 MB (2543720) - OptimizationTime: 361.511ms - PrepareTime: 238.168ms DataStreamSender (dst_id=12):(Total: 37.323us, non-child: 37.323us, % non-child: 100.00%) - BytesSent: 116.00 B (116) - NetworkThroughput(*): 278.65 KB/sec - OverallThroughput: 2.96 MB/sec - PeakMemoryUsage: 5.33 KB (5456) - SerializeBatchTime: 10.842us - ThriftTransmitTime(*): 406.530us - UncompressedRowBatchSize: 144.00 B (144) SORT_NODE (id=5):(Total: 1m20s, non-child: 91.733us, % non-child: 0.00%) - InMemorySortTime: 2.507us - InitialRunsCreated: 1 (1) - PeakMemoryUsage: 8.02 MB (8404992) - RowsReturned: 5 (5) - RowsReturnedRate: 0 - SortDataSize: 120.00 B (120) - TotalMergesPerformed: 0 (0) AGGREGATION_NODE (id=11):(Total: 1m20s, non-child: 244.574ms, % non-child: 0.30%) ExecOption: Codegen Enabled - BuildTime: 126.78us - GetNewBlockTime: 44.516us - GetResultsTime: 7.578us - HTResizeTime: 3.488us - HashBuckets: 4.10K (4096) - LargestPartitionPercent: 4 (4) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 3.30 MB (3457024) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 5 (5) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) - UnpinTime: 997ns EXCHANGE_NODE (id=10):(Total: 1m20s, non-child: 475.921us, % non-child: 0.00%) 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, 234.00 B - BytesReceived: 846.00 B (846) - ConvertRowBatchTime: 17.459us - DeserializeRowBatchTimer: 78.977us - FirstBatchArrivalWaitTime: 1m18s - PeakMemoryUsage: 0 - RowsReturned: 49 (49) - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 1d450fc48c2dd820:5346b5ca90c9afc5 (host=c2136.hal.cloudera.com:22000):(Total: 1m20s, non-child: 0ns, % non-child: 0.00%) MemoryUsage(2s000ms): 2.45 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.27 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 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 8.83 MB (9262416) - PerHostPeakMemUsage: 1.28 GB (1373719144) - PrepareTime: 247.645ms - RowsProduced: 4 (4) - TotalCpuTime: 661.898ms - TotalNetworkReceiveTime: 1m20s - TotalNetworkSendTime: 334.232us - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 288 (288) - BlocksRecycled: 49 (49) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 30.16 GB (32385830912) - PeakMemoryUsage: 456.75 MB (478937088) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 655.63ms, non-child: 655.63ms, % non-child: 100.00%) - CodegenTime: 4.45ms - CompileTime: 47.44ms - LoadTime: 106.570us - ModuleFileSize: 2.43 MB (2543720) - OptimizationTime: 364.659ms - PrepareTime: 241.601ms DataStreamSender (dst_id=12):(Total: 38.286us, non-child: 38.286us, % non-child: 100.00%) - BytesSent: 103.00 B (103) - NetworkThroughput(*): 435.76 KB/sec - OverallThroughput: 2.57 MB/sec - PeakMemoryUsage: 5.33 KB (5456) - SerializeBatchTime: 12.297us - ThriftTransmitTime(*): 230.829us - UncompressedRowBatchSize: 116.00 B (116) SORT_NODE (id=5):(Total: 1m20s, non-child: 103.955us, % non-child: 0.00%) - InMemorySortTime: 2.925us - InitialRunsCreated: 1 (1) - PeakMemoryUsage: 8.02 MB (8404992) - RowsReturned: 4 (4) - RowsReturnedRate: 0 - SortDataSize: 96.00 B (96) - TotalMergesPerformed: 0 (0) AGGREGATION_NODE (id=11):(Total: 1m20s, non-child: 248.72ms, % non-child: 0.31%) ExecOption: Codegen Enabled - BuildTime: 21.675us - GetNewBlockTime: 43.919us - GetResultsTime: 10.968us - HTResizeTime: 4.365us - HashBuckets: 4.10K (4096) - LargestPartitionPercent: 3 (3) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 3.30 MB (3457024) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 4 (4) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) - UnpinTime: 966ns EXCHANGE_NODE (id=10):(Total: 1m20s, non-child: 268.485us, % non-child: 0.00%) 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, 130.00 B - BytesReceived: 510.00 B (510) - ConvertRowBatchTime: 15.274us - DeserializeRowBatchTimer: 71.475us - FirstBatchArrivalWaitTime: 1m18s - PeakMemoryUsage: 0 - RowsReturned: 27 (27) - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 1d450fc48c2dd820:5346b5ca90c9afc6 (host=c2134.hal.cloudera.com:22000):(Total: 1m20s, non-child: 0ns, % non-child: 0.00%) MemoryUsage(2s000ms): 2.45 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.27 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 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 8.83 MB (9262416) - PerHostPeakMemUsage: 1.20 GB (1285635640) - PrepareTime: 248.383ms - RowsProduced: 8 (8) - TotalCpuTime: 663.679ms - TotalNetworkReceiveTime: 1m20s - TotalNetworkSendTime: 413.416us - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 288 (288) - BlocksRecycled: 49 (49) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 30.16 GB (32385830912) - PeakMemoryUsage: 456.75 MB (478937088) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 656.614ms, non-child: 656.614ms, % non-child: 100.00%) - CodegenTime: 4.308ms - CompileTime: 46.120ms - LoadTime: 107.560us - ModuleFileSize: 2.43 MB (2543720) - OptimizationTime: 366.655ms - PrepareTime: 241.988ms DataStreamSender (dst_id=12):(Total: 38.80us, non-child: 38.80us, % non-child: 100.00%) - BytesSent: 185.00 B (185) - NetworkThroughput(*): 607.41 KB/sec - OverallThroughput: 4.63 MB/sec - PeakMemoryUsage: 5.33 KB (5456) - SerializeBatchTime: 11.227us - ThriftTransmitTime(*): 297.432us - UncompressedRowBatchSize: 228.00 B (228) SORT_NODE (id=5):(Total: 1m20s, non-child: 98.95us, % non-child: 0.00%) - InMemorySortTime: 3.650us - InitialRunsCreated: 1 (1) - PeakMemoryUsage: 8.02 MB (8404992) - RowsReturned: 8 (8) - RowsReturnedRate: 0 - SortDataSize: 192.00 B (192) - TotalMergesPerformed: 0 (0) AGGREGATION_NODE (id=11):(Total: 1m20s, non-child: 248.758ms, % non-child: 0.31%) ExecOption: Codegen Enabled - BuildTime: 28.291us - GetNewBlockTime: 61.75us - GetResultsTime: 13.839us - HTResizeTime: 5.439us - HashBuckets: 4.10K (4096) - LargestPartitionPercent: 3 (3) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 3.29 MB (3448832) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 8 (8) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) - UnpinTime: 1.91us EXCHANGE_NODE (id=10):(Total: 1m20s, non-child: 170.683us, % non-child: 0.00%) 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, 319.00 B - BytesReceived: 1.39 KB (1422) - ConvertRowBatchTime: 16.414us - DeserializeRowBatchTimer: 68.277us - FirstBatchArrivalWaitTime: 1m18s - PeakMemoryUsage: 0 - RowsReturned: 80 (80) - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 1d450fc48c2dd820:5346b5ca90c9afbd (host=c2130.hal.cloudera.com:22000):(Total: 1m20s, non-child: 0ns, % non-child: 0.00%) MemoryUsage(2s000ms): 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.27 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 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 9.44 MB (9901392) - PerHostPeakMemUsage: 1.36 GB (1456487736) - PrepareTime: 244.941ms - RowsProduced: 9 (9) - TotalCpuTime: 657.982ms - TotalNetworkReceiveTime: 1m20s - TotalNetworkSendTime: 443.952us - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 288 (288) - BlocksRecycled: 49 (49) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 30.16 GB (32385830912) - PeakMemoryUsage: 456.75 MB (478937088) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 651.211ms, non-child: 651.211ms, % non-child: 100.00%) - CodegenTime: 4.38ms - CompileTime: 46.504ms - LoadTime: 97.342us - ModuleFileSize: 2.43 MB (2543720) - OptimizationTime: 364.53ms - PrepareTime: 239.84ms DataStreamSender (dst_id=12):(Total: 37.171us, non-child: 37.171us, % non-child: 100.00%) - BytesSent: 199.00 B (199) - NetworkThroughput(*): 519.99 KB/sec - OverallThroughput: 5.11 MB/sec - PeakMemoryUsage: 5.33 KB (5456) - SerializeBatchTime: 10.783us - ThriftTransmitTime(*): 373.733us - UncompressedRowBatchSize: 256.00 B (256) SORT_NODE (id=5):(Total: 1m20s, non-child: 105.371us, % non-child: 0.00%) - InMemorySortTime: 4.472us - InitialRunsCreated: 1 (1) - PeakMemoryUsage: 8.02 MB (8404992) - RowsReturned: 9 (9) - RowsReturnedRate: 0 - SortDataSize: 216.00 B (216) - TotalMergesPerformed: 0 (0) AGGREGATION_NODE (id=11):(Total: 1m20s, non-child: 245.323ms, % non-child: 0.30%) ExecOption: Codegen Enabled - BuildTime: 27.404us - GetNewBlockTime: 42.837us - GetResultsTime: 19.184us - HTResizeTime: 3.311us - HashBuckets: 7.17K (7168) - LargestPartitionPercent: 2 (2) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 3.30 MB (3457024) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 9 (9) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) - UnpinTime: 951ns EXCHANGE_NODE (id=10):(Total: 1m20s, non-child: 184.149us, % non-child: 0.00%) 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, 246.00 B - BytesReceived: 1.38 KB (1413) - ConvertRowBatchTime: 18.262us - DeserializeRowBatchTimer: 82.217us - FirstBatchArrivalWaitTime: 1m18s - PeakMemoryUsage: 0 - RowsReturned: 90 (90) - RowsReturnedRate: 1.00 /sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 1d450fc48c2dd820:5346b5ca90c9afbe (host=c2132.hal.cloudera.com:22000):(Total: 1m20s, non-child: 0ns, % non-child: 0.00%) MemoryUsage(2s000ms): 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.27 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 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 8.63 MB (9049424) - PerHostPeakMemUsage: 1.30 GB (1391085808) - PrepareTime: 244.621ms - RowsProduced: 5 (5) - TotalCpuTime: 658.102ms - TotalNetworkReceiveTime: 1m20s - TotalNetworkSendTime: 470.804us - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 288 (288) - BlocksRecycled: 49 (49) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 30.16 GB (32385830912) - PeakMemoryUsage: 456.75 MB (478937088) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 651.365ms, non-child: 651.365ms, % non-child: 100.00%) - CodegenTime: 4.66ms - CompileTime: 46.342ms - LoadTime: 107.855us - ModuleFileSize: 2.43 MB (2543720) - OptimizationTime: 364.722ms - PrepareTime: 238.590ms DataStreamSender (dst_id=12):(Total: 39.204us, non-child: 39.204us, % non-child: 100.00%) - BytesSent: 109.00 B (109) - NetworkThroughput(*): 321.34 KB/sec - OverallThroughput: 2.65 MB/sec - PeakMemoryUsage: 5.33 KB (5456) - SerializeBatchTime: 11.788us - ThriftTransmitTime(*): 331.255us - UncompressedRowBatchSize: 144.00 B (144) SORT_NODE (id=5):(Total: 1m20s, non-child: 105.775us, % non-child: 0.00%) - InMemorySortTime: 2.522us - InitialRunsCreated: 1 (1) - PeakMemoryUsage: 8.02 MB (8404992) - RowsReturned: 5 (5) - RowsReturnedRate: 0 - SortDataSize: 120.00 B (120) - TotalMergesPerformed: 0 (0) AGGREGATION_NODE (id=11):(Total: 1m20s, non-child: 244.928ms, % non-child: 0.30%) ExecOption: Codegen Enabled - BuildTime: 22.100us - GetNewBlockTime: 48.127us - GetResultsTime: 9.244us - HTResizeTime: 4.62us - HashBuckets: 3.07K (3072) - LargestPartitionPercent: 4 (4) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 3.30 MB (3457024) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 5 (5) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) - UnpinTime: 1.21us EXCHANGE_NODE (id=10):(Total: 1m20s, non-child: 376.124us, % non-child: 0.00%) 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, 106.00 B - BytesReceived: 850.00 B (850) - ConvertRowBatchTime: 16.995us - DeserializeRowBatchTimer: 80.175us - FirstBatchArrivalWaitTime: 1m18s - PeakMemoryUsage: 0 - RowsReturned: 50 (50) - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 1d450fc48c2dd820:5346b5ca90c9afc3 (host=c2124.hal.cloudera.com:22000):(Total: 1m20s, non-child: 0ns, % non-child: 0.00%) MemoryUsage(2s000ms): 2.45 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.27 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 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 8.43 MB (8836432) - PerHostPeakMemUsage: 1.34 GB (1440650376) - PrepareTime: 238.723ms - RowsProduced: 2 (2) - TotalCpuTime: 655.286ms - TotalNetworkReceiveTime: 1m20s - TotalNetworkSendTime: 426.130us - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 288 (288) - BlocksRecycled: 49 (49) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 30.16 GB (32385830912) - PeakMemoryUsage: 456.75 MB (478937088) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 648.509ms, non-child: 648.509ms, % non-child: 100.00%) - CodegenTime: 4.9ms - CompileTime: 46.329ms - LoadTime: 118.6us - ModuleFileSize: 2.43 MB (2543720) - OptimizationTime: 367.688ms - PrepareTime: 232.681ms DataStreamSender (dst_id=12):(Total: 40.817us, non-child: 40.817us, % non-child: 100.00%) - BytesSent: 55.00 B (55) - NetworkThroughput(*): 158.33 KB/sec - OverallThroughput: 1.29 MB/sec - PeakMemoryUsage: 5.33 KB (5456) - SerializeBatchTime: 11.387us - ThriftTransmitTime(*): 339.223us - UncompressedRowBatchSize: 60.00 B (60) SORT_NODE (id=5):(Total: 1m20s, non-child: 102.392us, % non-child: 0.00%) - InMemorySortTime: 2.585us - InitialRunsCreated: 1 (1) - PeakMemoryUsage: 8.02 MB (8404992) - RowsReturned: 2 (2) - RowsReturnedRate: 0 - SortDataSize: 48.00 B (48) - TotalMergesPerformed: 0 (0) AGGREGATION_NODE (id=11):(Total: 1m20s, non-child: 239.131ms, % non-child: 0.30%) ExecOption: Codegen Enabled - BuildTime: 21.939us - GetNewBlockTime: 46.574us - GetResultsTime: 9.30us - HTResizeTime: 4.727us - HashBuckets: 2.05K (2048) - LargestPartitionPercent: 8 (8) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 3.30 MB (3457024) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 2 (2) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) - UnpinTime: 948ns EXCHANGE_NODE (id=10):(Total: 1m20s, non-child: 277.354us, % non-child: 0.00%) 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, 63.00 B - BytesReceived: 280.00 B (280) - ConvertRowBatchTime: 14.622us - DeserializeRowBatchTimer: 76.665us - FirstBatchArrivalWaitTime: 1m18s - PeakMemoryUsage: 0 - RowsReturned: 12 (12) - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 1d450fc48c2dd820:5346b5ca90c9afc0 (host=c2118.hal.cloudera.com:22000):(Total: 1m20s, non-child: 0ns, % non-child: 0.00%) MemoryUsage(2s000ms): 2.45 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.27 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 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 8.43 MB (8836432) - PerHostPeakMemUsage: 1.18 GB (1262776184) - PrepareTime: 255.893ms - RowsProduced: 2 (2) - TotalCpuTime: 672.26ms - TotalNetworkReceiveTime: 1m20s - TotalNetworkSendTime: 146.471us - TotalStorageWaitTime: 0ns CodeGen:(Total: 664.896ms, non-child: 664.896ms, % non-child: 100.00%) - CodegenTime: 4.361ms - CompileTime: 47.98ms - LoadTime: 74.32us - ModuleFileSize: 2.43 MB (2543720) - OptimizationTime: 366.527ms - PrepareTime: 249.511ms DataStreamSender (dst_id=12):(Total: 37.111us, non-child: 37.111us, % non-child: 100.00%) - BytesSent: 53.00 B (53) - NetworkThroughput(*): 485.44 KB/sec - OverallThroughput: 1.36 MB/sec - PeakMemoryUsage: 5.33 KB (5456) - SerializeBatchTime: 11.195us - ThriftTransmitTime(*): 106.620us - UncompressedRowBatchSize: 60.00 B (60) SORT_NODE (id=5):(Total: 1m20s, non-child: 97.241us, % non-child: 0.00%) - InMemorySortTime: 2.455us - InitialRunsCreated: 1 (1) - PeakMemoryUsage: 8.02 MB (8404992) - RowsReturned: 2 (2) - RowsReturnedRate: 0 - SortDataSize: 48.00 B (48) - TotalMergesPerformed: 0 (0) AGGREGATION_NODE (id=11):(Total: 1m20s, non-child: 256.275ms, % non-child: 0.32%) ExecOption: Codegen Enabled - BuildTime: 17.692us - GetNewBlockTime: 49.323us - GetResultsTime: 5.550us - HTResizeTime: 2.740us - HashBuckets: 2.05K (2048) - LargestPartitionPercent: 5 (5) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 3.30 MB (3457024) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 2 (2) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) - UnpinTime: 936ns EXCHANGE_NODE (id=10):(Total: 1m20s, non-child: 162.144us, % non-child: 0.00%) 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, 118.00 B - BytesReceived: 431.00 B (431) - ConvertRowBatchTime: 16.293us - DeserializeRowBatchTimer: 74.533us - FirstBatchArrivalWaitTime: 1m18s - PeakMemoryUsage: 0 - RowsReturned: 20 (20) - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 1d450fc48c2dd820:5346b5ca90c9afc4 (host=c2122.hal.cloudera.com:22000):(Total: 1m20s, non-child: 0ns, % non-child: 0.00%) MemoryUsage(2s000ms): 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.26 MB, 3.27 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 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 8.63 MB (9049424) - PerHostPeakMemUsage: 1.30 GB (1393210864) - PrepareTime: 249.877ms - RowsProduced: 3 (3) - TotalCpuTime: 672.148ms - TotalNetworkReceiveTime: 1m20s - TotalNetworkSendTime: 426.601us - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 288 (288) - BlocksRecycled: 49 (49) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 30.16 GB (32385830912) - PeakMemoryUsage: 456.75 MB (478937088) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 665.334ms, non-child: 665.334ms, % non-child: 100.00%) - CodegenTime: 4.112ms - CompileTime: 49.193ms - LoadTime: 99.790us - ModuleFileSize: 2.43 MB (2543720) - OptimizationTime: 370.566ms - PrepareTime: 243.936ms DataStreamSender (dst_id=12):(Total: 40.48us, non-child: 40.48us, % non-child: 100.00%) - BytesSent: 80.00 B (80) - NetworkThroughput(*): 307.14 KB/sec - OverallThroughput: 1.91 MB/sec - PeakMemoryUsage: 5.33 KB (5456) - SerializeBatchTime: 13.245us - ThriftTransmitTime(*): 254.362us - UncompressedRowBatchSize: 88.00 B (88) SORT_NODE (id=5):(Total: 1m20s, non-child: 107.15us, % non-child: 0.00%) - InMemorySortTime: 2.675us - InitialRunsCreated: 1 (1) - PeakMemoryUsage: 8.02 MB (8404992) - RowsReturned: 3 (3) - RowsReturnedRate: 0 - SortDataSize: 72.00 B (72) - TotalMergesPerformed: 0 (0) AGGREGATION_NODE (id=11):(Total: 1m20s, non-child: 250.206ms, % non-child: 0.31%) ExecOption: Codegen Enabled - BuildTime: 20.497us - GetNewBlockTime: 43.85us - GetResultsTime: 8.957us - HTResizeTime: 3.739us - HashBuckets: 3.07K (3072) - LargestPartitionPercent: 3 (3) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 3.30 MB (3457024) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 3 (3) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) - UnpinTime: 1.154us EXCHANGE_NODE (id=10):(Total: 1m20s, non-child: 410.25us, % non-child: 0.00%) 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, 60.00 B - BytesReceived: 608.00 B (608) - ConvertRowBatchTime: 19.263us - DeserializeRowBatchTimer: 89.623us - FirstBatchArrivalWaitTime: 1m18s - PeakMemoryUsage: 0 - RowsReturned: 30 (30) - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Fragment F03: Instance 1d450fc48c2dd820:5346b5ca90c9afcc (host=c2128.hal.cloudera.com:22000):(Total: 1m20s, non-child: 0ns, % non-child: 0.00%) MemoryUsage(2s000ms): 4.92 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 34.56 MB, 52.29 MB, 68.01 MB, 81.11 MB, 93.97 MB, 109.93 MB, 125.60 MB, 138.75 MB, 151.11 MB, 163.45 MB, 177.54 MB, 192.28 MB, 204.63 MB, 220.34 MB, 233.45 MB, 245.25 MB, 253.82 MB, 262.00 MB, 270.02 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 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 276.90 MB (290352032) - PerHostPeakMemUsage: 1.29 GB (1381018072) - PrepareTime: 258.187ms - RowsProduced: 41 (41) - TotalCpuTime: 39s337ms - TotalNetworkReceiveTime: 41s429ms - TotalNetworkSendTime: 4.635ms - TotalStorageWaitTime: 0ns CodeGen:(Total: 780.153ms, non-child: 780.153ms, % non-child: 100.00%) - CodegenTime: 7.846ms - CompileTime: 90.282ms - LoadTime: 92.311us - ModuleFileSize: 2.43 MB (2543720) - OptimizationTime: 440.66ms - PrepareTime: 248.53ms DataStreamSender (dst_id=10):(Total: 59.564us, non-child: 59.564us, % non-child: 100.00%) - BytesSent: 743.00 B (743) - NetworkThroughput(*): 212.05 KB/sec - OverallThroughput: 11.90 MB/sec - PeakMemoryUsage: 93.28 KB (95520) - SerializeBatchTime: 96.28us - ThriftTransmitTime(*): 3.421ms - UncompressedRowBatchSize: 1.16 KB (1188) AGGREGATION_NODE (id=4):(Total: 1m20s, non-child: 442.906ms, % non-child: 0.55%) ExecOption: Codegen Enabled - BuildTime: 185.342ms - GetNewBlockTime: 51.649us - GetResultsTime: 37.26us - HTResizeTime: 4.126ms - HashBuckets: 16.38K (16384) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 3.52 MB (3694592) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 41 (41) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) - UnpinTime: 874ns AGGREGATION_NODE (id=9):(Total: 1m19s, non-child: 38s254ms, % non-child: 47.95%) ExecOption: Codegen Enabled - BuildTime: 38s031ms - GetNewBlockTime: 188.894us - GetResultsTime: 209.881ms - HTResizeTime: 181.172ms - HashBuckets: 8.39M (8388608) - LargestPartitionPercent: 6 (6) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 271.04 MB (284205024) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 4.50M (4500951) - RowsReturnedRate: 56.41 K/sec - SpilledPartitions: 0 (0) - UnpinTime: 952ns EXCHANGE_NODE (id=8):(Total: 41s528ms, non-child: 121.835ms, % non-child: 0.29%) BytesReceived(2s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11.80 MB, 14.41 MB, 17.42 MB, 20.31 MB, 22.96 MB, 26.09 MB, 28.87 MB, 32.14 MB, 34.75 MB, 37.31 MB, 40.33 MB, 42.77 MB, 45.84 MB, 48.91 MB, 51.75 MB, 53.76 MB, 54.44 MB, 54.44 MB, 54.44 MB - BytesReceived: 54.44 MB (57086036) - ConvertRowBatchTime: 91.936ms - DeserializeRowBatchTimer: 177.32ms - FirstBatchArrivalWaitTime: 41s405ms - PeakMemoryUsage: 0 - RowsReturned: 4.50M (4500951) - RowsReturnedRate: 108.38 K/sec - SendersBlockedTimer: 28s845ms - SendersBlockedTotalTimer(*): 28s846ms Instance 1d450fc48c2dd820:5346b5ca90c9afc7 (host=c2130.hal.cloudera.com:22000):(Total: 1m19s, non-child: 0ns, % non-child: 0.00%) MemoryUsage(2s000ms): 4.92 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 33.97 MB, 52.29 MB, 65.46 MB, 81.12 MB, 93.97 MB, 109.94 MB, 126.40 MB, 138.76 MB, 151.10 MB, 167.10 MB, 179.93 MB, 192.78 MB, 208.75 MB, 221.10 MB, 237.57 MB, 248.33 MB, 258.23 MB, 263.81 MB, 269.63 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 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 276.97 MB (290419904) - PerHostPeakMemUsage: 1.36 GB (1456487736) - PrepareTime: 254.96ms - RowsProduced: 43 (43) - TotalCpuTime: 38s772ms - TotalNetworkReceiveTime: 41s395ms - TotalNetworkSendTime: 3.323ms - TotalStorageWaitTime: 0ns CodeGen:(Total: 850.171ms, non-child: 850.171ms, % non-child: 100.00%) - CodegenTime: 7.688ms - CompileTime: 115.855ms - LoadTime: 190.126us - ModuleFileSize: 2.43 MB (2543720) - OptimizationTime: 488.323ms - PrepareTime: 244.217ms DataStreamSender (dst_id=10):(Total: 55.828us, non-child: 55.828us, % non-child: 100.00%) - BytesSent: 772.00 B (772) - NetworkThroughput(*): 258.85 KB/sec - OverallThroughput: 13.19 MB/sec - PeakMemoryUsage: 93.28 KB (95520) - SerializeBatchTime: 75.494us - ThriftTransmitTime(*): 2.912ms - UncompressedRowBatchSize: 1.21 KB (1244) AGGREGATION_NODE (id=4):(Total: 1m19s, non-child: 448.553ms, % non-child: 0.56%) ExecOption: Codegen Enabled - BuildTime: 194.862ms - GetNewBlockTime: 46.42us - GetResultsTime: 35.892us - HTResizeTime: 3.940ms - HashBuckets: 16.38K (16384) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 3.52 MB (3694592) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 43 (43) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) - UnpinTime: 859ns AGGREGATION_NODE (id=9):(Total: 1m19s, non-child: 37s609ms, % non-child: 47.54%) ExecOption: Codegen Enabled - BuildTime: 37s381ms - GetNewBlockTime: 174.404us - GetResultsTime: 211.900ms - HTResizeTime: 204.170ms - HashBuckets: 8.39M (8388608) - LargestPartitionPercent: 6 (6) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 271.04 MB (284205024) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 4.50M (4503072) - RowsReturnedRate: 56.92 K/sec - SpilledPartitions: 0 (0) - UnpinTime: 945ns EXCHANGE_NODE (id=8):(Total: 41s500ms, non-child: 129.775ms, % non-child: 0.31%) BytesReceived(2s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11.56 MB, 14.42 MB, 17.19 MB, 20.35 MB, 23.00 MB, 26.30 MB, 29.10 MB, 32.22 MB, 34.83 MB, 37.88 MB, 40.73 MB, 43.38 MB, 46.15 MB, 49.31 MB, 52.59 MB, 54.15 MB, 54.47 MB, 54.47 MB - BytesReceived: 54.47 MB (57113300) - ConvertRowBatchTime: 95.259ms - DeserializeRowBatchTimer: 197.562ms - FirstBatchArrivalWaitTime: 41s369ms - PeakMemoryUsage: 0 - RowsReturned: 4.50M (4503072) - RowsReturnedRate: 108.51 K/sec - SendersBlockedTimer: 28s414ms - SendersBlockedTotalTimer(*): 28s415ms Instance 1d450fc48c2dd820:5346b5ca90c9afcb (host=c2126.hal.cloudera.com:22000):(Total: 1m19s, non-child: 0ns, % non-child: 0.00%) MemoryUsage(2s000ms): 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 43.07 MB, 56.40 MB, 72.13 MB, 85.22 MB, 97.57 MB, 114.04 MB, 126.90 MB, 142.87 MB, 158.59 MB, 171.68 MB, 187.41 MB, 200.51 MB, 212.86 MB, 225.71 MB, 241.68 MB, 252.06 MB, 258.20 MB, 266.04 MB, 215.50 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 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 276.92 MB (290375008) - PerHostPeakMemUsage: 1.20 GB (1285124280) - PrepareTime: 255.333ms - RowsProduced: 42 (42) - TotalCpuTime: 38s686ms - TotalNetworkReceiveTime: 41s365ms - TotalNetworkSendTime: 3.935ms - TotalStorageWaitTime: 0ns CodeGen:(Total: 822.985ms, non-child: 822.985ms, % non-child: 100.00%) - CodegenTime: 7.764ms - CompileTime: 92.854ms - LoadTime: 91.655us - ModuleFileSize: 2.43 MB (2543720) - OptimizationTime: 482.995ms - PrepareTime: 245.384ms DataStreamSender (dst_id=10):(Total: 67.767us, non-child: 67.767us, % non-child: 100.00%) - BytesSent: 755.00 B (755) - NetworkThroughput(*): 251.30 KB/sec - OverallThroughput: 10.62 MB/sec - PeakMemoryUsage: 93.28 KB (95520) - SerializeBatchTime: 81.337us - ThriftTransmitTime(*): 2.933ms - UncompressedRowBatchSize: 1.19 KB (1216) AGGREGATION_NODE (id=4):(Total: 1m19s, non-child: 445.698ms, % non-child: 0.56%) ExecOption: Codegen Enabled - BuildTime: 190.748ms - GetNewBlockTime: 50.71us - GetResultsTime: 36.991us - HTResizeTime: 4.42ms - HashBuckets: 16.38K (16384) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 3.52 MB (3694592) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 42 (42) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) - UnpinTime: 857ns AGGREGATION_NODE (id=9):(Total: 1m19s, non-child: 37s559ms, % non-child: 47.53%) ExecOption: Codegen Enabled - BuildTime: 37s332ms - GetNewBlockTime: 192.741us - GetResultsTime: 212.434ms - HTResizeTime: 190.355ms - HashBuckets: 8.39M (8388608) - LargestPartitionPercent: 6 (6) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 271.04 MB (284205024) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 4.50M (4499623) - RowsReturnedRate: 56.94 K/sec - SpilledPartitions: 0 (0) - UnpinTime: 992ns EXCHANGE_NODE (id=8):(Total: 41s462ms, non-child: 120.23ms, % non-child: 0.29%) BytesReceived(2s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11.37 MB, 14.41 MB, 17.40 MB, 20.30 MB, 22.96 MB, 26.26 MB, 29.10 MB, 32.22 MB, 35.27 MB, 38.22 MB, 41.20 MB, 44.06 MB, 46.76 MB, 49.53 MB, 52.60 MB, 54.31 MB, 54.42 MB, 54.42 MB - BytesReceived: 54.42 MB (57061748) - ConvertRowBatchTime: 89.225ms - DeserializeRowBatchTimer: 180.746ms - FirstBatchArrivalWaitTime: 41s342ms - PeakMemoryUsage: 0 - RowsReturned: 4.50M (4499623) - RowsReturnedRate: 108.52 K/sec - SendersBlockedTimer: 28s184ms - SendersBlockedTotalTimer(*): 28s185ms Instance 1d450fc48c2dd820:5346b5ca90c9afcf (host=c2136.hal.cloudera.com:22000):(Total: 1m19s, non-child: 0ns, % non-child: 0.00%) MemoryUsage(2s000ms): 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 40.78 MB, 56.41 MB, 68.76 MB, 81.11 MB, 94.91 MB, 109.93 MB, 123.52 MB, 138.76 MB, 155.22 MB, 167.49 MB, 179.92 MB, 192.77 MB, 208.75 MB, 225.21 MB, 240.93 MB, 251.23 MB, 258.18 MB, 265.97 MB, 202.11 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 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 276.89 MB (290343464) - PerHostPeakMemUsage: 1.28 GB (1373719144) - PrepareTime: 247.715ms - RowsProduced: 40 (40) - TotalCpuTime: 38s477ms - TotalNetworkReceiveTime: 41s441ms - TotalNetworkSendTime: 3.564ms - TotalStorageWaitTime: 0ns CodeGen:(Total: 782.686ms, non-child: 782.686ms, % non-child: 100.00%) - CodegenTime: 7.512ms - CompileTime: 92.698ms - LoadTime: 173.956us - ModuleFileSize: 2.43 MB (2543720) - OptimizationTime: 450.242ms - PrepareTime: 238.212ms DataStreamSender (dst_id=10):(Total: 45.571us, non-child: 45.571us, % non-child: 100.00%) - BytesSent: 727.00 B (727) - NetworkThroughput(*): 242.85 KB/sec - OverallThroughput: 15.21 MB/sec - PeakMemoryUsage: 93.28 KB (95520) - SerializeBatchTime: 92.224us - ThriftTransmitTime(*): 2.923ms - UncompressedRowBatchSize: 1.13 KB (1160) AGGREGATION_NODE (id=4):(Total: 1m19s, non-child: 436.361ms, % non-child: 0.55%) ExecOption: Codegen Enabled - BuildTime: 188.873ms - GetNewBlockTime: 53.18us - GetResultsTime: 39.110us - HTResizeTime: 4.48ms - HashBuckets: 16.38K (16384) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 3.52 MB (3694592) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 40 (40) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) - UnpinTime: 852ns AGGREGATION_NODE (id=9):(Total: 1m18s, non-child: 37s392ms, % non-child: 47.37%) ExecOption: Codegen Enabled - BuildTime: 37s166ms - GetNewBlockTime: 171.697us - GetResultsTime: 212.213ms - HTResizeTime: 185.225ms - HashBuckets: 8.39M (8388608) - LargestPartitionPercent: 6 (6) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 271.04 MB (284205024) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 4.50M (4501349) - RowsReturnedRate: 57.03 K/sec - SpilledPartitions: 0 (0) - UnpinTime: 959ns EXCHANGE_NODE (id=8):(Total: 41s540ms, non-child: 121.702ms, % non-child: 0.29%) BytesReceived(2s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10.45 MB, 14.41 MB, 16.98 MB, 19.58 MB, 22.55 MB, 25.43 MB, 28.42 MB, 31.44 MB, 34.78 MB, 37.24 MB, 40.00 MB, 42.78 MB, 45.94 MB, 49.24 MB, 52.32 MB, 54.13 MB, 54.45 MB, 54.45 MB - BytesReceived: 54.45 MB (57093027) - ConvertRowBatchTime: 90.33ms - DeserializeRowBatchTimer: 204.901ms - FirstBatchArrivalWaitTime: 41s417ms - PeakMemoryUsage: 0 - RowsReturned: 4.50M (4501349) - RowsReturnedRate: 108.36 K/sec - SendersBlockedTimer: 28s267ms - SendersBlockedTotalTimer(*): 28s268ms Instance 1d450fc48c2dd820:5346b5ca90c9afca (host=c2118.hal.cloudera.com:22000):(Total: 1m18s, non-child: 0ns, % non-child: 0.00%) MemoryUsage(2s000ms): 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 40.96 MB, 56.42 MB, 70.01 MB, 85.48 MB, 97.58 MB, 113.80 MB, 127.39 MB, 142.87 MB, 155.22 MB, 167.56 MB, 179.92 MB, 193.35 MB, 208.74 MB, 222.08 MB, 237.56 MB, 251.26 MB, 260.13 MB, 265.73 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 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 276.92 MB (290366976) - PerHostPeakMemUsage: 1.18 GB (1262776184) - PrepareTime: 257.494ms - RowsProduced: 41 (41) - TotalCpuTime: 38s244ms - TotalNetworkReceiveTime: 41s366ms - TotalNetworkSendTime: 4.31ms - TotalStorageWaitTime: 0ns CodeGen:(Total: 860.333ms, non-child: 860.333ms, % non-child: 100.00%) - CodegenTime: 8.82ms - CompileTime: 93.417ms - LoadTime: 192.148us - ModuleFileSize: 2.43 MB (2543720) - OptimizationTime: 518.60ms - PrepareTime: 247.104ms DataStreamSender (dst_id=10):(Total: 53.514us, non-child: 53.514us, % non-child: 100.00%) - BytesSent: 741.00 B (741) - NetworkThroughput(*): 246.00 KB/sec - OverallThroughput: 13.21 MB/sec - PeakMemoryUsage: 93.28 KB (95520) - SerializeBatchTime: 110.238us - ThriftTransmitTime(*): 2.941ms - UncompressedRowBatchSize: 1.16 KB (1188) AGGREGATION_NODE (id=4):(Total: 1m18s, non-child: 447.829ms, % non-child: 0.57%) ExecOption: Codegen Enabled - BuildTime: 190.869ms - GetNewBlockTime: 162.387us - GetResultsTime: 39.161us - HTResizeTime: 4.190ms - HashBuckets: 16.38K (16384) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 3.52 MB (3694592) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 41 (41) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) - UnpinTime: 891ns AGGREGATION_NODE (id=9):(Total: 1m18s, non-child: 37s079ms, % non-child: 47.21%) ExecOption: Codegen Enabled - BuildTime: 36s855ms - GetNewBlockTime: 175.257us - GetResultsTime: 211.10ms - HTResizeTime: 178.746ms - HashBuckets: 8.39M (8388608) - LargestPartitionPercent: 6 (6) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 271.04 MB (284205024) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 4.50M (4502100) - RowsReturnedRate: 57.32 K/sec - SpilledPartitions: 0 (0) - UnpinTime: 965ns EXCHANGE_NODE (id=8):(Total: 41s464ms, non-child: 118.318ms, % non-child: 0.29%) BytesReceived(2s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10.51 MB, 14.42 MB, 17.37 MB, 20.03 MB, 22.97 MB, 26.15 MB, 28.93 MB, 32.16 MB, 34.79 MB, 37.41 MB, 40.01 MB, 42.87 MB, 45.86 MB, 48.76 MB, 51.89 MB, 54.11 MB, 54.45 MB, 54.45 MB - BytesReceived: 54.45 MB (57097629) - ConvertRowBatchTime: 89.769ms - DeserializeRowBatchTimer: 183.648ms - FirstBatchArrivalWaitTime: 41s344ms - PeakMemoryUsage: 0 - RowsReturned: 4.50M (4502100) - RowsReturnedRate: 108.58 K/sec - SendersBlockedTimer: 28s355ms - SendersBlockedTotalTimer(*): 28s356ms Instance 1d450fc48c2dd820:5346b5ca90c9afc8 (host=c2132.hal.cloudera.com:22000):(Total: 1m18s, non-child: 0ns, % non-child: 0.00%) MemoryUsage(2s000ms): 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 43.87 MB, 56.41 MB, 72.88 MB, 89.34 MB, 101.70 MB, 114.06 MB, 130.27 MB, 143.37 MB, 159.34 MB, 175.81 MB, 188.15 MB, 201.25 MB, 216.23 MB, 229.33 MB, 242.18 MB, 254.17 MB, 262.29 MB, 268.05 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 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 276.93 MB (290385944) - PerHostPeakMemUsage: 1.30 GB (1391085808) - PrepareTime: 251.318ms - RowsProduced: 43 (43) - TotalCpuTime: 38s141ms - TotalNetworkReceiveTime: 41s378ms - TotalNetworkSendTime: 3.663ms - TotalStorageWaitTime: 0ns CodeGen:(Total: 799.609ms, non-child: 799.609ms, % non-child: 100.00%) - CodegenTime: 7.659ms - CompileTime: 99.739ms - LoadTime: 99.682us - ModuleFileSize: 2.43 MB (2543720) - OptimizationTime: 456.640ms - PrepareTime: 241.552ms DataStreamSender (dst_id=10):(Total: 51.957us, non-child: 51.957us, % non-child: 100.00%) - BytesSent: 768.00 B (768) - NetworkThroughput(*): 261.36 KB/sec - OverallThroughput: 14.10 MB/sec - PeakMemoryUsage: 93.28 KB (95520) - SerializeBatchTime: 83.889us - ThriftTransmitTime(*): 2.869ms - UncompressedRowBatchSize: 1.21 KB (1244) AGGREGATION_NODE (id=4):(Total: 1m18s, non-child: 432.629ms, % non-child: 0.55%) ExecOption: Codegen Enabled - BuildTime: 181.785ms - GetNewBlockTime: 46.116us - GetResultsTime: 36.887us - HTResizeTime: 4.104ms - HashBuckets: 16.38K (16384) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 3.52 MB (3694592) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 43 (43) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) - UnpinTime: 852ns AGGREGATION_NODE (id=9):(Total: 1m18s, non-child: 37s047ms, % non-child: 47.18%) ExecOption: Codegen Enabled - BuildTime: 36s823ms - GetNewBlockTime: 193.266us - GetResultsTime: 210.32ms - HTResizeTime: 191.393ms - HashBuckets: 8.39M (8388608) - LargestPartitionPercent: 6 (6) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 271.04 MB (284205024) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 4.50M (4497793) - RowsReturnedRate: 57.28 K/sec - SpilledPartitions: 0 (0) - UnpinTime: 990ns EXCHANGE_NODE (id=8):(Total: 41s475ms, non-child: 118.427ms, % non-child: 0.29%) BytesReceived(2s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11.73 MB, 14.48 MB, 17.83 MB, 21.16 MB, 23.76 MB, 26.36 MB, 29.52 MB, 32.47 MB, 35.66 MB, 38.92 MB, 41.54 MB, 44.28 MB, 47.17 MB, 50.07 MB, 52.87 MB, 54.40 MB, 54.40 MB, 54.40 MB - BytesReceived: 54.40 MB (57042937) - ConvertRowBatchTime: 89.378ms - DeserializeRowBatchTimer: 173.507ms - FirstBatchArrivalWaitTime: 41s355ms - PeakMemoryUsage: 0 - RowsReturned: 4.50M (4497793) - RowsReturnedRate: 108.44 K/sec - SendersBlockedTimer: 27s907ms - SendersBlockedTotalTimer(*): 27s909ms Instance 1d450fc48c2dd820:5346b5ca90c9afce (host=c2122.hal.cloudera.com:22000):(Total: 1m18s, non-child: 0ns, % non-child: 0.00%) MemoryUsage(2s000ms): 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 42.37 MB, 59.77 MB, 72.88 MB, 86.07 MB, 101.70 MB, 114.05 MB, 130.52 MB, 143.37 MB, 159.34 MB, 175.73 MB, 188.15 MB, 200.52 MB, 216.98 MB, 229.32 MB, 245.38 MB, 254.36 MB, 262.14 MB, 267.81 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 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 276.93 MB (290381200) - PerHostPeakMemUsage: 1.30 GB (1393210864) - PrepareTime: 252.797ms - RowsProduced: 41 (41) - TotalCpuTime: 37s965ms - TotalNetworkReceiveTime: 41s425ms - TotalNetworkSendTime: 3.856ms - TotalStorageWaitTime: 0ns CodeGen:(Total: 825.950ms, non-child: 825.950ms, % non-child: 100.00%) - CodegenTime: 7.512ms - CompileTime: 95.122ms - LoadTime: 147.213us - ModuleFileSize: 2.43 MB (2543720) - OptimizationTime: 486.2ms - PrepareTime: 243.125ms DataStreamSender (dst_id=10):(Total: 51.120us, non-child: 51.120us, % non-child: 100.00%) - BytesSent: 744.00 B (744) - NetworkThroughput(*): 248.78 KB/sec - OverallThroughput: 13.88 MB/sec - PeakMemoryUsage: 93.28 KB (95520) - SerializeBatchTime: 79.388us - ThriftTransmitTime(*): 2.920ms - UncompressedRowBatchSize: 1.16 KB (1188) AGGREGATION_NODE (id=4):(Total: 1m18s, non-child: 446.387ms, % non-child: 0.57%) ExecOption: Codegen Enabled - BuildTime: 194.117ms - GetNewBlockTime: 52.500us - GetResultsTime: 35.766us - HTResizeTime: 4.94ms - HashBuckets: 16.38K (16384) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 3.52 MB (3694592) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 41 (41) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) - UnpinTime: 859ns AGGREGATION_NODE (id=9):(Total: 1m18s, non-child: 36s831ms, % non-child: 47.01%) ExecOption: Codegen Enabled - BuildTime: 36s606ms - GetNewBlockTime: 182.945us - GetResultsTime: 211.398ms - HTResizeTime: 188.384ms - HashBuckets: 8.39M (8388608) - LargestPartitionPercent: 6 (6) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 271.02 MB (284188656) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 4.50M (4501010) - RowsReturnedRate: 57.44 K/sec - SpilledPartitions: 0 (0) - UnpinTime: 957ns EXCHANGE_NODE (id=8):(Total: 41s523ms, non-child: 121.482ms, % non-child: 0.29%) BytesReceived(2s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11.13 MB, 14.86 MB, 17.81 MB, 20.56 MB, 23.72 MB, 26.37 MB, 29.64 MB, 32.48 MB, 35.66 MB, 38.90 MB, 41.55 MB, 44.24 MB, 47.58 MB, 50.19 MB, 53.27 MB, 54.44 MB, 54.44 MB, 54.44 MB - BytesReceived: 54.44 MB (57082597) - ConvertRowBatchTime: 90.76ms - DeserializeRowBatchTimer: 187.362ms - FirstBatchArrivalWaitTime: 41s401ms - PeakMemoryUsage: 0 - RowsReturned: 4.50M (4501010) - RowsReturnedRate: 108.39 K/sec - SendersBlockedTimer: 27s608ms - SendersBlockedTotalTimer(*): 27s609ms Instance 1d450fc48c2dd820:5346b5ca90c9afcd (host=c2124.hal.cloudera.com:22000):(Total: 1m18s, non-child: 0ns, % non-child: 0.00%) MemoryUsage(2s000ms): 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 39.88 MB, 56.41 MB, 68.76 MB, 82.35 MB, 97.58 MB, 110.43 MB, 126.40 MB, 142.58 MB, 155.22 MB, 171.69 MB, 184.92 MB, 200.51 MB, 214.10 MB, 229.33 MB, 242.18 MB, 254.11 MB, 262.11 MB, 267.79 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 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 276.91 MB (290361968) - PerHostPeakMemUsage: 1.34 GB (1440650376) - PrepareTime: 253.158ms - RowsProduced: 43 (43) - TotalCpuTime: 37s848ms - TotalNetworkReceiveTime: 41s373ms - TotalNetworkSendTime: 3.242ms - TotalStorageWaitTime: 0ns CodeGen:(Total: 838.410ms, non-child: 838.410ms, % non-child: 100.00%) - CodegenTime: 7.838ms - CompileTime: 98.360ms - LoadTime: 112.505us - ModuleFileSize: 2.43 MB (2543720) - OptimizationTime: 495.84ms - PrepareTime: 243.452ms DataStreamSender (dst_id=10):(Total: 54.973us, non-child: 54.973us, % non-child: 100.00%) - BytesSent: 771.00 B (771) - NetworkThroughput(*): 281.21 KB/sec - OverallThroughput: 13.38 MB/sec - PeakMemoryUsage: 93.28 KB (95520) - SerializeBatchTime: 96.615us - ThriftTransmitTime(*): 2.677ms - UncompressedRowBatchSize: 1.21 KB (1244) AGGREGATION_NODE (id=4):(Total: 1m18s, non-child: 438.487ms, % non-child: 0.56%) ExecOption: Codegen Enabled - BuildTime: 185.997ms - GetNewBlockTime: 58.298us - GetResultsTime: 36.424us - HTResizeTime: 4.75ms - HashBuckets: 16.38K (16384) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 3.52 MB (3694592) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 43 (43) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) - UnpinTime: 869ns AGGREGATION_NODE (id=9):(Total: 1m18s, non-child: 36s708ms, % non-child: 46.95%) ExecOption: Codegen Enabled - BuildTime: 36s480ms - GetNewBlockTime: 174.527us - GetResultsTime: 213.610ms - HTResizeTime: 190.923ms - HashBuckets: 8.39M (8388608) - LargestPartitionPercent: 6 (6) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 271.02 MB (284188656) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 4.50M (4496317) - RowsReturnedRate: 57.51 K/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.23us EXCHANGE_NODE (id=8):(Total: 41s473ms, non-child: 124.206ms, % non-child: 0.30%) BytesReceived(2s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10.12 MB, 14.37 MB, 16.98 MB, 19.93 MB, 22.94 MB, 25.74 MB, 28.83 MB, 31.90 MB, 34.85 MB, 38.15 MB, 40.81 MB, 44.14 MB, 47.10 MB, 50.06 MB, 52.90 MB, 54.38 MB, 54.38 MB, 54.38 MB - BytesReceived: 54.38 MB (57024525) - ConvertRowBatchTime: 92.145ms - DeserializeRowBatchTimer: 192.726ms - FirstBatchArrivalWaitTime: 41s346ms - PeakMemoryUsage: 0 - RowsReturned: 4.50M (4496317) - RowsReturnedRate: 108.42 K/sec - SendersBlockedTimer: 27s678ms - SendersBlockedTotalTimer(*): 27s679ms Instance 1d450fc48c2dd820:5346b5ca90c9afc9 (host=c2120.hal.cloudera.com:22000):(Total: 1m18s, non-child: 0ns, % non-child: 0.00%) MemoryUsage(2s000ms): 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 39.45 MB, 56.27 MB, 68.76 MB, 84.98 MB, 97.59 MB, 113.80 MB, 126.89 MB, 142.87 MB, 155.22 MB, 171.58 MB, 187.72 MB, 200.51 MB, 216.22 MB, 229.33 MB, 245.38 MB, 253.86 MB, 262.09 MB, 268.14 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 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 276.93 MB (290382864) - PerHostPeakMemUsage: 1.26 GB (1353256608) - PrepareTime: 254.620ms - RowsProduced: 42 (42) - TotalCpuTime: 37s654ms - TotalNetworkReceiveTime: 41s403ms - TotalNetworkSendTime: 3.714ms - TotalStorageWaitTime: 0ns CodeGen:(Total: 826.241ms, non-child: 826.241ms, % non-child: 100.00%) - CodegenTime: 7.630ms - CompileTime: 97.410ms - LoadTime: 111.67us - ModuleFileSize: 2.43 MB (2543720) - OptimizationTime: 482.280ms - PrepareTime: 244.954ms DataStreamSender (dst_id=10):(Total: 53.702us, non-child: 53.702us, % non-child: 100.00%) - BytesSent: 757.00 B (757) - NetworkThroughput(*): 255.74 KB/sec - OverallThroughput: 13.44 MB/sec - PeakMemoryUsage: 93.28 KB (95520) - SerializeBatchTime: 112.217us - ThriftTransmitTime(*): 2.890ms - UncompressedRowBatchSize: 1.19 KB (1216) AGGREGATION_NODE (id=4):(Total: 1m18s, non-child: 444.245ms, % non-child: 0.57%) ExecOption: Codegen Enabled - BuildTime: 189.985ms - GetNewBlockTime: 59.744us - GetResultsTime: 37.538us - HTResizeTime: 4.95ms - HashBuckets: 16.38K (16384) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 3.52 MB (3694592) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 42 (42) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) - UnpinTime: 856ns AGGREGATION_NODE (id=9):(Total: 1m18s, non-child: 36s523ms, % non-child: 46.81%) ExecOption: Codegen Enabled - BuildTime: 36s299ms - GetNewBlockTime: 201.247us - GetResultsTime: 211.86ms - HTResizeTime: 179.935ms - HashBuckets: 8.39M (8388608) - LargestPartitionPercent: 6 (6) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 271.02 MB (284188656) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 4.50M (4499698) - RowsReturnedRate: 57.67 K/sec - SpilledPartitions: 0 (0) - UnpinTime: 988ns EXCHANGE_NODE (id=8):(Total: 41s502ms, non-child: 121.719ms, % non-child: 0.29%) BytesReceived(2s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9.94 MB, 14.11 MB, 16.96 MB, 20.15 MB, 22.94 MB, 26.15 MB, 29.09 MB, 32.20 MB, 34.82 MB, 38.07 MB, 41.26 MB, 44.17 MB, 47.19 MB, 50.16 MB, 53.25 MB, 54.42 MB, 54.42 MB, 54.42 MB - BytesReceived: 54.42 MB (57064510) - ConvertRowBatchTime: 89.758ms - DeserializeRowBatchTimer: 190.695ms - FirstBatchArrivalWaitTime: 41s379ms - PeakMemoryUsage: 0 - RowsReturned: 4.50M (4499698) - RowsReturnedRate: 108.42 K/sec - SendersBlockedTimer: 27s472ms - SendersBlockedTotalTimer(*): 27s473ms Instance 1d450fc48c2dd820:5346b5ca90c9afd0 (host=c2134.hal.cloudera.com:22000):(Total: 1m18s, non-child: 0ns, % non-child: 0.00%) MemoryUsage(2s000ms): 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 6.56 MB, 39.81 MB, 56.41 MB, 69.78 MB, 85.22 MB, 100.94 MB, 114.04 MB, 126.90 MB, 142.87 MB, 159.07 MB, 171.68 MB, 188.16 MB, 200.51 MB, 216.98 MB, 229.33 MB, 243.11 MB, 254.07 MB, 262.02 MB, 267.71 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 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 276.90 MB (290353136) - PerHostPeakMemUsage: 1.20 GB (1285635640) - PrepareTime: 254.539ms - RowsProduced: 42 (42) - TotalCpuTime: 37s586ms - TotalNetworkReceiveTime: 41s424ms - TotalNetworkSendTime: 3.778ms - TotalStorageWaitTime: 0ns CodeGen:(Total: 824.569ms, non-child: 824.569ms, % non-child: 100.00%) - CodegenTime: 7.920ms - CompileTime: 100.718ms - LoadTime: 106.551us - ModuleFileSize: 2.43 MB (2543720) - OptimizationTime: 477.725ms - PrepareTime: 244.351ms DataStreamSender (dst_id=10):(Total: 59.592us, non-child: 59.592us, % non-child: 100.00%) - BytesSent: 752.00 B (752) - NetworkThroughput(*): 254.10 KB/sec - OverallThroughput: 12.03 MB/sec - PeakMemoryUsage: 93.28 KB (95520) - SerializeBatchTime: 81.526us - ThriftTransmitTime(*): 2.890ms - UncompressedRowBatchSize: 1.19 KB (1216) AGGREGATION_NODE (id=4):(Total: 1m18s, non-child: 434.428ms, % non-child: 0.55%) ExecOption: Codegen Enabled - BuildTime: 180.644ms - GetNewBlockTime: 46.448us - GetResultsTime: 36.682us - HTResizeTime: 4.118ms - HashBuckets: 16.38K (16384) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 3.52 MB (3694592) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 42 (42) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) - UnpinTime: 854ns AGGREGATION_NODE (id=9):(Total: 1m17s, non-child: 36s465ms, % non-child: 46.76%) ExecOption: Codegen Enabled - BuildTime: 36s241ms - GetNewBlockTime: 189.250us - GetResultsTime: 210.323ms - HTResizeTime: 181.49ms - HashBuckets: 8.39M (8388608) - LargestPartitionPercent: 6 (6) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 271.02 MB (284188656) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 4.50M (4498087) - RowsReturnedRate: 57.67 K/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.16us EXCHANGE_NODE (id=8):(Total: 41s524ms, non-child: 119.653ms, % non-child: 0.29%) BytesReceived(2s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10.09 MB, 14.41 MB, 17.25 MB, 20.36 MB, 23.37 MB, 26.29 MB, 29.11 MB, 32.23 MB, 35.45 MB, 38.22 MB, 41.53 MB, 44.18 MB, 47.48 MB, 50.17 MB, 53.14 MB, 54.41 MB, 54.41 MB, 54.41 MB - BytesReceived: 54.41 MB (57049279) - ConvertRowBatchTime: 91.425ms - DeserializeRowBatchTimer: 154.762ms - FirstBatchArrivalWaitTime: 41s404ms - PeakMemoryUsage: 0 - RowsReturned: 4.50M (4498087) - RowsReturnedRate: 108.32 K/sec - SendersBlockedTimer: 27s644ms - SendersBlockedTotalTimer(*): 27s645ms Fragment F02: Instance 1d450fc48c2dd820:5346b5ca90c9afd6 (host=c2128.hal.cloudera.com:22000):(Total: 1m12s, non-child: 0ns, % non-child: 0.00%) MemoryUsage(2s000ms): 92.17 MB, 350.85 MB, 476.15 MB, 472.57 MB, 469.48 MB, 469.42 MB, 469.50 MB, 469.38 MB, 469.34 MB, 469.36 MB, 469.31 MB, 469.29 MB, 469.34 MB, 469.35 MB, 469.42 MB, 469.34 MB, 469.38 MB, 469.48 MB, 469.28 MB, 469.28 MB, 432.31 MB, 217.02 MB, 204.51 MB, 187.82 MB, 175.31 MB, 162.79 MB, 146.10 MB, 133.59 MB, 116.90 MB, 104.38 MB, 91.87 MB, 75.18 MB, 66.84 MB, 50.15 MB, 33.46 MB, 20.95 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 - AverageThreadTokens: 1.02 - PeakMemoryUsage: 489.80 MB (513589984) - PerHostPeakMemUsage: 1.29 GB (1381018072) - PrepareTime: 260.150ms - RowsProduced: 4.50M (4500951) - TotalCpuTime: 37s487ms - TotalNetworkReceiveTime: 7s976ms - TotalNetworkSendTime: 29s341ms - TotalStorageWaitTime: 0ns CodeGen:(Total: 868.588ms, non-child: 868.588ms, % non-child: 100.00%) - CodegenTime: 4.324ms - CompileTime: 78.492ms - LoadTime: 90.57us - ModuleFileSize: 2.43 MB (2543720) - OptimizationTime: 537.926ms - PrepareTime: 250.594ms DataStreamSender (dst_id=8):(Total: 30s727ms, non-child: 30s727ms, % non-child: 100.00%) - BytesSent: 54.44 MB (57086036) - NetworkThroughput(*): 1.82 MB/sec - OverallThroughput: 1.77 MB/sec - PeakMemoryUsage: 81.28 KB (83232) - SerializeBatchTime: 525.664ms - ThriftTransmitTime(*): 29s989ms - UncompressedRowBatchSize: 120.21 MB (126053028) AGGREGATION_NODE (id=3):(Total: 41s584ms, non-child: 15s472ms, % non-child: 37.21%) ExecOption: Codegen Enabled - BuildTime: 14s780ms - GetNewBlockTime: 195.605us - GetResultsTime: 266.88ms - HTResizeTime: 235.35ms - HashBuckets: 8.39M (8388608) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 271.02 MB (284180480) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 4.50M (4500951) - RowsReturnedRate: 108.24 K/sec - SpilledPartitions: 0 (0) - UnpinTime: 958ns HASH_JOIN_NODE (id=2):(Total: 26s111ms, non-child: 18s598ms, % non-child: 71.22%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildPartitionTime: 303.875ms - BuildRows: 4.50M (4500951) - BuildRowsPartitioned: 4.50M (4500951) - BuildTime: 549.900ms - GetNewBlockTime: 184.514us - HashBuckets: 8.39M (8388608) - LargestPartitionPercent: 6 (6) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 267.02 MB (279994368) - PinTime: 0ns - ProbeRows: 44.53M (44526041) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 15s617ms - RowsReturned: 46.03M (46026610) - RowsReturnedRate: 1.76 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.323us EXCHANGE_NODE (id=7):(Total: 885.178ms, non-child: 147.920ms, % non-child: 16.71%) BytesReceived(1s000ms): 5.05 MB, 39.91 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB - BytesReceived: 53.11 MB (55687197) - ConvertRowBatchTime: 105.977ms - DeserializeRowBatchTimer: 170.837ms - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 4.50M (4500951) - RowsReturnedRate: 5.08 M/sec - SendersBlockedTimer: 280.856ms - SendersBlockedTotalTimer(*): 2s551ms EXCHANGE_NODE (id=6):(Total: 8s485ms, non-child: 2s725ms, % non-child: 32.11%) BytesReceived(1s000ms): 5.09 MB, 10.21 MB, 11.77 MB, 54.14 MB, 113.05 MB, 174.28 MB, 236.16 MB, 297.97 MB, 360.91 MB, 424.34 MB, 487.82 MB, 551.31 MB, 614.84 MB, 678.58 MB, 741.87 MB, 805.35 MB, 869.55 MB, 932.80 MB, 996.41 MB, 1.04 GB, 1.10 GB, 1.15 GB, 1.21 GB, 1.26 GB, 1.32 GB, 1.37 GB, 1.42 GB, 1.48 GB, 1.54 GB, 1.60 GB, 1.66 GB, 1.73 GB, 1.79 GB, 1.86 GB, 1.92 GB, 1.97 GB, 2.02 GB, 2.07 GB, 2.11 GB, 2.14 GB, 2.16 GB, 2.16 GB - BytesReceived: 2.16 GB (2321519495) - ConvertRowBatchTime: 1s138ms - DeserializeRowBatchTimer: 8s068ms - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 44.53M (44526041) - RowsReturnedRate: 5.25 M/sec - SendersBlockedTimer: 3s726ms - SendersBlockedTotalTimer(*): 28s877ms Instance 1d450fc48c2dd820:5346b5ca90c9afd1 (host=c2130.hal.cloudera.com:22000):(Total: 1m11s, non-child: 0ns, % non-child: 0.00%) MemoryUsage(2s000ms): 92.17 MB, 343.27 MB, 463.81 MB, 469.90 MB, 469.38 MB, 469.38 MB, 469.37 MB, 469.31 MB, 469.37 MB, 469.58 MB, 469.47 MB, 469.35 MB, 469.30 MB, 469.35 MB, 469.36 MB, 469.42 MB, 469.34 MB, 469.32 MB, 469.34 MB, 469.25 MB, 435.51 MB, 221.20 MB, 204.51 MB, 191.99 MB, 175.31 MB, 162.79 MB, 146.10 MB, 133.59 MB, 116.90 MB, 104.38 MB, 87.69 MB, 75.18 MB, 62.67 MB, 50.15 MB, 33.46 MB, 16.77 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 - AverageThreadTokens: 1.02 - PeakMemoryUsage: 479.24 MB (502517152) - PerHostPeakMemUsage: 1.36 GB (1456487736) - PrepareTime: 254.612ms - RowsProduced: 4.50M (4503072) - TotalCpuTime: 37s335ms - TotalNetworkReceiveTime: 8s013ms - TotalNetworkSendTime: 29s005ms - TotalStorageWaitTime: 0ns CodeGen:(Total: 856.644ms, non-child: 856.644ms, % non-child: 100.00%) - CodegenTime: 4.235ms - CompileTime: 79.297ms - LoadTime: 101.609us - ModuleFileSize: 2.43 MB (2543720) - OptimizationTime: 530.886ms - PrepareTime: 244.925ms DataStreamSender (dst_id=8):(Total: 30s269ms, non-child: 30s269ms, % non-child: 100.00%) - BytesSent: 54.47 MB (57113300) - NetworkThroughput(*): 1.84 MB/sec - OverallThroughput: 1.80 MB/sec - PeakMemoryUsage: 81.28 KB (83232) - SerializeBatchTime: 450.172ms - ThriftTransmitTime(*): 29s650ms - UncompressedRowBatchSize: 120.27 MB (126112428) AGGREGATION_NODE (id=3):(Total: 41s591ms, non-child: 14s540ms, % non-child: 34.96%) ExecOption: Codegen Enabled - BuildTime: 13s901ms - GetNewBlockTime: 162.723us - GetResultsTime: 235.962ms - HTResizeTime: 269.686ms - HashBuckets: 8.39M (8388608) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 271.02 MB (284180480) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 4.50M (4503072) - RowsReturnedRate: 108.27 K/sec - SpilledPartitions: 0 (0) - UnpinTime: 960ns HASH_JOIN_NODE (id=2):(Total: 27s051ms, non-child: 19s499ms, % non-child: 72.08%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildPartitionTime: 321.982ms - BuildRows: 4.50M (4503072) - BuildRowsPartitioned: 4.50M (4503072) - BuildTime: 550.178ms - GetNewBlockTime: 199.511us - HashBuckets: 8.39M (8388608) - LargestPartitionPercent: 6 (6) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 267.02 MB (279994368) - PinTime: 0ns - ProbeRows: 44.55M (44545147) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 16s511ms - RowsReturned: 46.05M (46046981) - RowsReturnedRate: 1.70 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.243us EXCHANGE_NODE (id=7):(Total: 874.102ms, non-child: 144.410ms, % non-child: 16.52%) BytesReceived(1s000ms): 5.05 MB, 39.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB, 53.14 MB - BytesReceived: 53.14 MB (55725649) - ConvertRowBatchTime: 109.398ms - DeserializeRowBatchTimer: 156.150ms - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 4.50M (4503072) - RowsReturnedRate: 5.15 M/sec - SendersBlockedTimer: 267.606ms - SendersBlockedTotalTimer(*): 2s655ms EXCHANGE_NODE (id=6):(Total: 8s541ms, non-child: 2s649ms, % non-child: 31.02%) BytesReceived(1s000ms): 5.06 MB, 10.12 MB, 11.05 MB, 52.97 MB, 111.75 MB, 173.12 MB, 235.01 MB, 296.81 MB, 359.78 MB, 423.24 MB, 486.88 MB, 550.35 MB, 613.92 MB, 677.67 MB, 740.96 MB, 804.40 MB, 868.61 MB, 931.83 MB, 995.33 MB, 1.03 GB, 1.10 GB, 1.15 GB, 1.21 GB, 1.26 GB, 1.31 GB, 1.37 GB, 1.42 GB, 1.48 GB, 1.54 GB, 1.60 GB, 1.66 GB, 1.73 GB, 1.79 GB, 1.86 GB, 1.92 GB, 1.97 GB, 2.02 GB, 2.07 GB, 2.11 GB, 2.14 GB, 2.16 GB, 2.16 GB - BytesReceived: 2.16 GB (2322455958) - ConvertRowBatchTime: 1s131ms - DeserializeRowBatchTimer: 8s290ms - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 44.55M (44545147) - RowsReturnedRate: 5.22 M/sec - SendersBlockedTimer: 2s153ms - SendersBlockedTotalTimer(*): 13s522ms Instance 1d450fc48c2dd820:5346b5ca90c9afd4 (host=c2118.hal.cloudera.com:22000):(Total: 1m11s, non-child: 0ns, % non-child: 0.00%) MemoryUsage(2s000ms): 91.33 MB, 334.67 MB, 462.96 MB, 469.33 MB, 469.33 MB, 469.39 MB, 469.33 MB, 469.35 MB, 469.34 MB, 469.38 MB, 469.34 MB, 469.28 MB, 469.36 MB, 469.33 MB, 469.41 MB, 469.38 MB, 469.38 MB, 469.36 MB, 469.30 MB, 469.30 MB, 444.97 MB, 225.37 MB, 204.51 MB, 187.82 MB, 175.31 MB, 162.79 MB, 146.10 MB, 133.58 MB, 116.90 MB, 104.38 MB, 91.87 MB, 79.35 MB, 66.83 MB, 50.15 MB, 37.63 MB, 20.95 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 - AverageThreadTokens: 1.03 - PeakMemoryUsage: 478.02 MB (501240888) - PerHostPeakMemUsage: 1.18 GB (1262776184) - PrepareTime: 256.340ms - RowsProduced: 4.50M (4502100) - TotalCpuTime: 37s135ms - TotalNetworkReceiveTime: 8s249ms - TotalNetworkSendTime: 28s858ms - TotalStorageWaitTime: 0ns CodeGen:(Total: 865.903ms, non-child: 865.903ms, % non-child: 100.00%) - CodegenTime: 4.162ms - CompileTime: 79.383ms - LoadTime: 79.593us - ModuleFileSize: 2.43 MB (2543720) - OptimizationTime: 538.361ms - PrepareTime: 246.499ms DataStreamSender (dst_id=8):(Total: 30s240ms, non-child: 30s240ms, % non-child: 100.00%) - BytesSent: 54.45 MB (57097629) - NetworkThroughput(*): 1.84 MB/sec - OverallThroughput: 1.80 MB/sec - PeakMemoryUsage: 81.28 KB (83232) - SerializeBatchTime: 504.865ms - ThriftTransmitTime(*): 29s552ms - UncompressedRowBatchSize: 120.24 MB (126085208) AGGREGATION_NODE (id=3):(Total: 41s596ms, non-child: 14s819ms, % non-child: 35.63%) ExecOption: Codegen Enabled - BuildTime: 14s144ms - GetNewBlockTime: 722.245us - GetResultsTime: 261.950ms - HTResizeTime: 260.546ms - HashBuckets: 8.39M (8388608) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 271.02 MB (284180480) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 4.50M (4502100) - RowsReturnedRate: 108.23 K/sec - SpilledPartitions: 0 (0) - UnpinTime: 968ns HASH_JOIN_NODE (id=2):(Total: 26s777ms, non-child: 18s842ms, % non-child: 70.37%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildPartitionTime: 421.930ms - BuildRows: 4.50M (4502100) - BuildRowsPartitioned: 4.50M (4502100) - BuildTime: 472.197ms - GetNewBlockTime: 672.580us - HashBuckets: 8.39M (8388608) - LargestPartitionPercent: 6 (6) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 267.02 MB (279994368) - PinTime: 0ns - ProbeRows: 44.54M (44536918) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 15s922ms - RowsReturned: 46.04M (46037864) - RowsReturnedRate: 1.72 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.357us EXCHANGE_NODE (id=7):(Total: 767.617ms, non-child: 158.266ms, % non-child: 20.62%) BytesReceived(1s000ms): 16.03 MB, 49.55 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB, 53.13 MB - BytesReceived: 53.13 MB (55710270) - ConvertRowBatchTime: 122.80ms - DeserializeRowBatchTimer: 185.61ms - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 4.50M (4502100) - RowsReturnedRate: 5.87 M/sec - SendersBlockedTimer: 277.220ms - SendersBlockedTotalTimer(*): 2s516ms EXCHANGE_NODE (id=6):(Total: 8s937ms, non-child: 2s664ms, % non-child: 29.81%) BytesReceived(1s000ms): 10.17 MB, 10.18 MB, 21.42 MB, 74.18 MB, 134.89 MB, 196.24 MB, 257.87 MB, 320.02 MB, 383.32 MB, 446.84 MB, 510.32 MB, 573.81 MB, 637.58 MB, 701.25 MB, 764.56 MB, 828.14 MB, 892.10 MB, 955.14 MB, 1019.10 MB, 1.06 GB, 1.12 GB, 1.17 GB, 1.23 GB, 1.28 GB, 1.33 GB, 1.39 GB, 1.44 GB, 1.50 GB, 1.56 GB, 1.62 GB, 1.69 GB, 1.75 GB, 1.82 GB, 1.88 GB, 1.94 GB, 1.99 GB, 2.04 GB, 2.09 GB, 2.13 GB, 2.15 GB, 2.16 GB - BytesReceived: 2.16 GB (2321979887) - ConvertRowBatchTime: 1s173ms - DeserializeRowBatchTimer: 8s192ms - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 44.54M (44536918) - RowsReturnedRate: 4.98 M/sec - SendersBlockedTimer: 2s070ms - SendersBlockedTotalTimer(*): 18s613ms Instance 1d450fc48c2dd820:5346b5ca90c9afd9 (host=c2136.hal.cloudera.com:22000):(Total: 1m11s, non-child: 0ns, % non-child: 0.00%) MemoryUsage(2s000ms): 91.35 MB, 332.81 MB, 462.71 MB, 469.33 MB, 469.29 MB, 469.36 MB, 469.40 MB, 469.41 MB, 469.34 MB, 469.34 MB, 469.37 MB, 469.33 MB, 469.36 MB, 469.42 MB, 469.41 MB, 469.40 MB, 469.31 MB, 469.36 MB, 469.33 MB, 469.25 MB, 445.96 MB, 225.37 MB, 204.51 MB, 191.99 MB, 179.48 MB, 166.96 MB, 150.27 MB, 133.59 MB, 121.07 MB, 104.38 MB, 91.87 MB, 79.35 MB, 66.84 MB, 50.15 MB, 33.46 MB, 16.77 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 - AverageThreadTokens: 1.03 - PeakMemoryUsage: 477.38 MB (500573088) - PerHostPeakMemUsage: 1.28 GB (1373719144) - PrepareTime: 251.862ms - RowsProduced: 4.50M (4501349) - TotalCpuTime: 36s372ms - TotalNetworkReceiveTime: 9s086ms - TotalNetworkSendTime: 28s661ms - TotalStorageWaitTime: 0ns CodeGen:(Total: 902.537ms, non-child: 902.537ms, % non-child: 100.00%) - CodegenTime: 4.109ms - CompileTime: 79.379ms - LoadTime: 109.208us - ModuleFileSize: 2.43 MB (2543720) - OptimizationTime: 579.143ms - PrepareTime: 242.334ms DataStreamSender (dst_id=8):(Total: 30s133ms, non-child: 30s133ms, % non-child: 100.00%) - BytesSent: 54.45 MB (57093027) - NetworkThroughput(*): 1.85 MB/sec - OverallThroughput: 1.81 MB/sec - PeakMemoryUsage: 81.28 KB (83232) - SerializeBatchTime: 531.264ms - ThriftTransmitTime(*): 29s481ms - UncompressedRowBatchSize: 120.22 MB (126064176) AGGREGATION_NODE (id=3):(Total: 41s577ms, non-child: 14s323ms, % non-child: 34.45%) ExecOption: Codegen Enabled - BuildTime: 13s632ms - GetNewBlockTime: 146.804us - GetResultsTime: 285.911ms - HTResizeTime: 259.450ms - HashBuckets: 8.39M (8388608) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 271.02 MB (284180480) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 4.50M (4501349) - RowsReturnedRate: 108.27 K/sec - SpilledPartitions: 0 (0) - UnpinTime: 972ns HASH_JOIN_NODE (id=2):(Total: 27s253ms, non-child: 18s519ms, % non-child: 67.96%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildPartitionTime: 306.51ms - BuildRows: 4.50M (4501349) - BuildRowsPartitioned: 4.50M (4501349) - BuildTime: 465.885ms - GetNewBlockTime: 169.634us - HashBuckets: 8.39M (8388608) - LargestPartitionPercent: 6 (6) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 267.02 MB (279994368) - PinTime: 0ns - ProbeRows: 44.56M (44561601) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 15s765ms - RowsReturned: 46.06M (46060529) - RowsReturnedRate: 1.69 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.262us EXCHANGE_NODE (id=7):(Total: 854.262ms, non-child: 150.252ms, % non-child: 17.59%) BytesReceived(1s000ms): 15.88 MB, 49.43 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB - BytesReceived: 53.11 MB (55692231) - ConvertRowBatchTime: 104.332ms - DeserializeRowBatchTimer: 175.792ms - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 4.50M (4501349) - RowsReturnedRate: 5.27 M/sec - SendersBlockedTimer: 313.572ms - SendersBlockedTotalTimer(*): 3s119ms EXCHANGE_NODE (id=6):(Total: 9s612ms, non-child: 2s573ms, % non-child: 26.77%) BytesReceived(1s000ms): 10.20 MB, 10.21 MB, 21.29 MB, 73.93 MB, 134.59 MB, 195.92 MB, 257.58 MB, 319.71 MB, 382.98 MB, 446.53 MB, 510.11 MB, 573.62 MB, 637.34 MB, 700.95 MB, 764.32 MB, 827.99 MB, 892.11 MB, 955.23 MB, 1019.25 MB, 1.06 GB, 1.12 GB, 1.17 GB, 1.23 GB, 1.28 GB, 1.33 GB, 1.39 GB, 1.44 GB, 1.50 GB, 1.56 GB, 1.62 GB, 1.69 GB, 1.75 GB, 1.82 GB, 1.88 GB, 1.94 GB, 1.99 GB, 2.04 GB, 2.09 GB, 2.13 GB, 2.15 GB, 2.16 GB - BytesReceived: 2.16 GB (2323158173) - ConvertRowBatchTime: 1s122ms - DeserializeRowBatchTimer: 8s100ms - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 44.56M (44561601) - RowsReturnedRate: 4.64 M/sec - SendersBlockedTimer: 2s071ms - SendersBlockedTotalTimer(*): 20s678ms Instance 1d450fc48c2dd820:5346b5ca90c9afd5 (host=c2126.hal.cloudera.com:22000):(Total: 1m11s, non-child: 0ns, % non-child: 0.00%) MemoryUsage(2s000ms): 91.33 MB, 335.71 MB, 464.28 MB, 469.30 MB, 469.42 MB, 469.39 MB, 469.38 MB, 469.40 MB, 469.30 MB, 469.35 MB, 469.36 MB, 469.34 MB, 469.30 MB, 469.33 MB, 469.35 MB, 469.31 MB, 469.38 MB, 469.34 MB, 469.32 MB, 469.25 MB, 438.66 MB, 221.19 MB, 204.51 MB, 187.82 MB, 175.31 MB, 162.79 MB, 146.10 MB, 133.59 MB, 116.90 MB, 100.21 MB, 87.70 MB, 71.01 MB, 58.49 MB, 45.98 MB, 33.46 MB, 16.77 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 - AverageThreadTokens: 1.02 - PeakMemoryUsage: 479.60 MB (502892104) - PerHostPeakMemUsage: 1.20 GB (1285124280) - PrepareTime: 256.858ms - RowsProduced: 4.50M (4499623) - TotalCpuTime: 36s785ms - TotalNetworkReceiveTime: 8s631ms - TotalNetworkSendTime: 28s608ms - TotalStorageWaitTime: 0ns CodeGen:(Total: 827.112ms, non-child: 827.112ms, % non-child: 100.00%) - CodegenTime: 4.244ms - CompileTime: 78.772ms - LoadTime: 81.286us - ModuleFileSize: 2.43 MB (2543720) - OptimizationTime: 499.725ms - PrepareTime: 246.853ms DataStreamSender (dst_id=8):(Total: 30s032ms, non-child: 30s032ms, % non-child: 100.00%) - BytesSent: 54.42 MB (57061748) - NetworkThroughput(*): 1.85 MB/sec - OverallThroughput: 1.81 MB/sec - PeakMemoryUsage: 81.28 KB (83232) - SerializeBatchTime: 509.232ms - ThriftTransmitTime(*): 29s343ms - UncompressedRowBatchSize: 120.18 MB (126015836) AGGREGATION_NODE (id=3):(Total: 41s602ms, non-child: 14s599ms, % non-child: 35.09%) ExecOption: Codegen Enabled - BuildTime: 13s925ms - GetNewBlockTime: 155.345us - GetResultsTime: 267.10ms - HTResizeTime: 240.854ms - HashBuckets: 8.39M (8388608) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 271.02 MB (284180480) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 4.50M (4499623) - RowsReturnedRate: 108.16 K/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.44us HASH_JOIN_NODE (id=2):(Total: 27s002ms, non-child: 18s716ms, % non-child: 69.31%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildPartitionTime: 314.583ms - BuildRows: 4.50M (4499623) - BuildRowsPartitioned: 4.50M (4499623) - BuildTime: 458.68ms - GetNewBlockTime: 194.203us - HashBuckets: 8.39M (8388608) - LargestPartitionPercent: 6 (6) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 267.02 MB (279994368) - PinTime: 0ns - ProbeRows: 44.49M (44489813) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 15s891ms - RowsReturned: 45.99M (45991061) - RowsReturnedRate: 1.70 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.496us EXCHANGE_NODE (id=7):(Total: 914.738ms, non-child: 150.988ms, % non-child: 16.51%) BytesReceived(1s000ms): 17.47 MB, 50.40 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB - BytesReceived: 53.10 MB (55679911) - ConvertRowBatchTime: 113.435ms - DeserializeRowBatchTimer: 178.246ms - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 4.50M (4499623) - RowsReturnedRate: 4.92 M/sec - SendersBlockedTimer: 238.806ms - SendersBlockedTotalTimer(*): 2s373ms EXCHANGE_NODE (id=6):(Total: 9s164ms, non-child: 2s812ms, % non-child: 30.69%) BytesReceived(1s000ms): 10.17 MB, 10.18 MB, 22.85 MB, 77.24 MB, 137.80 MB, 199.41 MB, 260.97 MB, 323.14 MB, 386.37 MB, 449.82 MB, 513.20 MB, 576.64 MB, 640.16 MB, 703.69 MB, 767.04 MB, 830.71 MB, 894.63 MB, 957.68 MB, 1021.70 MB, 1.06 GB, 1.12 GB, 1.17 GB, 1.23 GB, 1.28 GB, 1.34 GB, 1.39 GB, 1.44 GB, 1.50 GB, 1.56 GB, 1.63 GB, 1.69 GB, 1.75 GB, 1.82 GB, 1.88 GB, 1.94 GB, 1.99 GB, 2.04 GB, 2.09 GB, 2.13 GB, 2.15 GB, 2.16 GB - BytesReceived: 2.16 GB (2319624342) - ConvertRowBatchTime: 1s177ms - DeserializeRowBatchTimer: 8s789ms - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 44.49M (44489813) - RowsReturnedRate: 4.85 M/sec - SendersBlockedTimer: 2s053ms - SendersBlockedTotalTimer(*): 18s382ms Instance 1d450fc48c2dd820:5346b5ca90c9afd2 (host=c2132.hal.cloudera.com:22000):(Total: 1m11s, non-child: 0ns, % non-child: 0.00%) MemoryUsage(2s000ms): 91.34 MB, 338.70 MB, 461.51 MB, 469.36 MB, 469.41 MB, 469.41 MB, 469.52 MB, 469.39 MB, 469.61 MB, 469.55 MB, 469.41 MB, 469.32 MB, 469.35 MB, 469.36 MB, 471.13 MB, 478.70 MB, 486.41 MB, 478.46 MB, 469.33 MB, 469.29 MB, 435.51 MB, 217.02 MB, 204.51 MB, 187.82 MB, 171.13 MB, 158.62 MB, 146.10 MB, 129.42 MB, 116.90 MB, 100.21 MB, 83.52 MB, 71.01 MB, 58.49 MB, 41.81 MB, 29.29 MB, 16.77 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 - AverageThreadTokens: 1.02 - PeakMemoryUsage: 487.80 MB (511491640) - PerHostPeakMemUsage: 1.30 GB (1391085808) - PrepareTime: 248.259ms - RowsProduced: 4.50M (4497793) - TotalCpuTime: 37s840ms - TotalNetworkReceiveTime: 7s342ms - TotalNetworkSendTime: 28s488ms - TotalStorageWaitTime: 0ns CodeGen:(Total: 832.282ms, non-child: 832.282ms, % non-child: 100.00%) - CodegenTime: 4.22ms - CompileTime: 78.718ms - LoadTime: 90.417us - ModuleFileSize: 2.43 MB (2543720) - OptimizationTime: 512.985ms - PrepareTime: 238.901ms DataStreamSender (dst_id=8):(Total: 29s719ms, non-child: 29s719ms, % non-child: 100.00%) - BytesSent: 54.40 MB (57042937) - NetworkThroughput(*): 1.87 MB/sec - OverallThroughput: 1.83 MB/sec - PeakMemoryUsage: 81.28 KB (83232) - SerializeBatchTime: 451.924ms - ThriftTransmitTime(*): 29s068ms - UncompressedRowBatchSize: 120.13 MB (125964588) AGGREGATION_NODE (id=3):(Total: 41s532ms, non-child: 15s081ms, % non-child: 36.31%) ExecOption: Codegen Enabled - BuildTime: 14s452ms - GetNewBlockTime: 162.904us - GetResultsTime: 221.973ms - HTResizeTime: 241.604ms - HashBuckets: 8.39M (8388608) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 271.02 MB (284180480) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 4.50M (4497793) - RowsReturnedRate: 108.29 K/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.21us HASH_JOIN_NODE (id=2):(Total: 26s451ms, non-child: 19s494ms, % non-child: 73.70%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildPartitionTime: 297.34ms - BuildRows: 4.50M (4497793) - BuildRowsPartitioned: 4.50M (4497793) - BuildTime: 479.332ms - GetNewBlockTime: 170.815us - HashBuckets: 8.39M (8388608) - LargestPartitionPercent: 6 (6) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 267.02 MB (279994368) - PinTime: 0ns - ProbeRows: 44.48M (44478467) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 16s645ms - RowsReturned: 45.98M (45977613) - RowsReturnedRate: 1.74 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.476us EXCHANGE_NODE (id=7):(Total: 924.888ms, non-child: 150.750ms, % non-child: 16.30%) BytesReceived(1s000ms): 18.33 MB, 50.77 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB, 53.08 MB - BytesReceived: 53.08 MB (55660904) - ConvertRowBatchTime: 118.192ms - DeserializeRowBatchTimer: 158.706ms - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 4.50M (4497793) - RowsReturnedRate: 4.86 M/sec - SendersBlockedTimer: 241.974ms - SendersBlockedTotalTimer(*): 1s927ms EXCHANGE_NODE (id=6):(Total: 7s842ms, non-child: 2s632ms, % non-child: 33.57%) BytesReceived(1s000ms): 10.19 MB, 10.20 MB, 23.62 MB, 79.22 MB, 139.48 MB, 201.43 MB, 262.97 MB, 325.27 MB, 388.45 MB, 451.84 MB, 515.26 MB, 578.68 MB, 642.21 MB, 705.71 MB, 769.03 MB, 832.70 MB, 896.50 MB, 959.47 MB, 1023.36 MB, 1.06 GB, 1.12 GB, 1.17 GB, 1.23 GB, 1.28 GB, 1.34 GB, 1.39 GB, 1.45 GB, 1.50 GB, 1.56 GB, 1.63 GB, 1.69 GB, 1.76 GB, 1.82 GB, 1.88 GB, 1.94 GB, 1.99 GB, 2.04 GB, 2.09 GB, 2.13 GB, 2.15 GB, 2.16 GB - BytesReceived: 2.16 GB (2319009747) - ConvertRowBatchTime: 1s152ms - DeserializeRowBatchTimer: 8s021ms - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 44.48M (44478467) - RowsReturnedRate: 5.67 M/sec - SendersBlockedTimer: 2s394ms - SendersBlockedTotalTimer(*): 22s306ms Instance 1d450fc48c2dd820:5346b5ca90c9afd7 (host=c2124.hal.cloudera.com:22000):(Total: 1m11s, non-child: 0ns, % non-child: 0.00%) MemoryUsage(2s000ms): 91.17 MB, 327.36 MB, 462.67 MB, 469.29 MB, 469.47 MB, 469.33 MB, 469.41 MB, 469.34 MB, 469.46 MB, 469.39 MB, 469.36 MB, 469.35 MB, 469.34 MB, 469.31 MB, 469.39 MB, 469.41 MB, 469.43 MB, 469.32 MB, 469.32 MB, 469.28 MB, 448.12 MB, 225.36 MB, 204.51 MB, 191.99 MB, 175.31 MB, 162.79 MB, 150.27 MB, 133.59 MB, 116.90 MB, 104.38 MB, 87.70 MB, 75.18 MB, 58.49 MB, 41.81 MB, 29.29 MB, 16.77 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 - AverageThreadTokens: 1.03 - PeakMemoryUsage: 477.08 MB (500258080) - PerHostPeakMemUsage: 1.34 GB (1440650376) - PrepareTime: 247.447ms - RowsProduced: 4.50M (4496317) - TotalCpuTime: 36s940ms - TotalNetworkReceiveTime: 8s354ms - TotalNetworkSendTime: 28s225ms - TotalStorageWaitTime: 0ns CodeGen:(Total: 846.621ms, non-child: 846.621ms, % non-child: 100.00%) - CodegenTime: 4.57ms - CompileTime: 79.401ms - LoadTime: 103.198us - ModuleFileSize: 2.43 MB (2543720) - OptimizationTime: 527.495ms - PrepareTime: 238.36ms DataStreamSender (dst_id=8):(Total: 29s552ms, non-child: 29s552ms, % non-child: 100.00%) - BytesSent: 54.38 MB (57024525) - NetworkThroughput(*): 1.88 MB/sec - OverallThroughput: 1.84 MB/sec - PeakMemoryUsage: 81.28 KB (83232) - SerializeBatchTime: 468.847ms - ThriftTransmitTime(*): 28s862ms - UncompressedRowBatchSize: 120.09 MB (125923248) AGGREGATION_NODE (id=3):(Total: 41s563ms, non-child: 14s751ms, % non-child: 35.49%) ExecOption: Codegen Enabled - BuildTime: 14s102ms - GetNewBlockTime: 145.79us - GetResultsTime: 236.885ms - HTResizeTime: 254.432ms - HashBuckets: 8.39M (8388608) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 271.02 MB (284180480) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 4.50M (4496317) - RowsReturnedRate: 108.18 K/sec - SpilledPartitions: 0 (0) - UnpinTime: 957ns HASH_JOIN_NODE (id=2):(Total: 26s812ms, non-child: 18s789ms, % non-child: 70.08%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildPartitionTime: 308.324ms - BuildRows: 4.50M (4496317) - BuildRowsPartitioned: 4.50M (4496317) - BuildTime: 457.100ms - GetNewBlockTime: 187.617us - HashBuckets: 8.39M (8388608) - LargestPartitionPercent: 6 (6) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 267.02 MB (279994368) - PinTime: 0ns - ProbeRows: 44.48M (44483615) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 15s969ms - RowsReturned: 45.98M (45981576) - RowsReturnedRate: 1.71 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.231us EXCHANGE_NODE (id=7):(Total: 904.775ms, non-child: 145.183ms, % non-child: 16.05%) BytesReceived(1s000ms): 14.54 MB, 48.59 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB, 53.07 MB - BytesReceived: 53.07 MB (55648536) - ConvertRowBatchTime: 108.704ms - DeserializeRowBatchTimer: 167.245ms - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 4.50M (4496317) - RowsReturnedRate: 4.97 M/sec - SendersBlockedTimer: 257.32ms - SendersBlockedTotalTimer(*): 2s554ms EXCHANGE_NODE (id=6):(Total: 8s898ms, non-child: 2s620ms, % non-child: 29.45%) BytesReceived(1s000ms): 10.17 MB, 10.18 MB, 20.02 MB, 71.23 MB, 131.72 MB, 193.02 MB, 254.46 MB, 316.57 MB, 379.73 MB, 443.06 MB, 506.57 MB, 570.04 MB, 633.58 MB, 697.14 MB, 760.49 MB, 824.07 MB, 888.12 MB, 951.20 MB, 1015.01 MB, 1.05 GB, 1.11 GB, 1.17 GB, 1.22 GB, 1.28 GB, 1.33 GB, 1.38 GB, 1.44 GB, 1.49 GB, 1.56 GB, 1.62 GB, 1.68 GB, 1.75 GB, 1.81 GB, 1.87 GB, 1.93 GB, 1.98 GB, 2.03 GB, 2.08 GB, 2.12 GB, 2.15 GB, 2.16 GB - BytesReceived: 2.16 GB (2319303334) - ConvertRowBatchTime: 1s191ms - DeserializeRowBatchTimer: 8s121ms - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 44.48M (44483615) - RowsReturnedRate: 5.00 M/sec - SendersBlockedTimer: 2s059ms - SendersBlockedTotalTimer(*): 18s517ms Instance 1d450fc48c2dd820:5346b5ca90c9afd8 (host=c2122.hal.cloudera.com:22000):(Total: 1m11s, non-child: 0ns, % non-child: 0.00%) MemoryUsage(2s000ms): 91.33 MB, 339.15 MB, 463.90 MB, 469.47 MB, 469.53 MB, 469.41 MB, 469.58 MB, 469.62 MB, 469.78 MB, 469.90 MB, 469.34 MB, 469.31 MB, 469.36 MB, 469.33 MB, 469.40 MB, 469.30 MB, 469.33 MB, 469.37 MB, 469.34 MB, 469.30 MB, 437.64 MB, 221.19 MB, 200.34 MB, 187.82 MB, 175.30 MB, 158.62 MB, 146.10 MB, 129.42 MB, 116.90 MB, 100.21 MB, 83.52 MB, 71.01 MB, 58.49 MB, 41.81 MB, 29.29 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 - AverageThreadTokens: 1.02 - PeakMemoryUsage: 479.26 MB (502543584) - PerHostPeakMemUsage: 1.30 GB (1393210864) - PrepareTime: 252.977ms - RowsProduced: 4.50M (4501010) - TotalCpuTime: 37s612ms - TotalNetworkReceiveTime: 7s862ms - TotalNetworkSendTime: 28s046ms - TotalStorageWaitTime: 0ns CodeGen:(Total: 829.535ms, non-child: 829.535ms, % non-child: 100.00%) - CodegenTime: 4.14ms - CompileTime: 79.30ms - LoadTime: 90.145us - ModuleFileSize: 2.43 MB (2543720) - OptimizationTime: 505.192ms - PrepareTime: 243.550ms DataStreamSender (dst_id=8):(Total: 29s451ms, non-child: 29s451ms, % non-child: 100.00%) - BytesSent: 54.44 MB (57082597) - NetworkThroughput(*): 1.89 MB/sec - OverallThroughput: 1.85 MB/sec - PeakMemoryUsage: 81.28 KB (83232) - SerializeBatchTime: 500.352ms - ThriftTransmitTime(*): 28s782ms - UncompressedRowBatchSize: 120.22 MB (126054680) AGGREGATION_NODE (id=3):(Total: 41s653ms, non-child: 14s916ms, % non-child: 35.81%) ExecOption: Codegen Enabled - BuildTime: 14s253ms - GetNewBlockTime: 163.272us - GetResultsTime: 262.588ms - HTResizeTime: 262.635ms - HashBuckets: 8.39M (8388608) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 271.02 MB (284180480) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 4.50M (4501010) - RowsReturnedRate: 108.06 K/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.3us HASH_JOIN_NODE (id=2):(Total: 26s737ms, non-child: 19s281ms, % non-child: 72.11%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildPartitionTime: 298.233ms - BuildRows: 4.50M (4501010) - BuildRowsPartitioned: 4.50M (4501010) - BuildTime: 473.213ms - GetNewBlockTime: 170.731us - HashBuckets: 8.39M (8388608) - LargestPartitionPercent: 6 (6) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 267.02 MB (279994368) - PinTime: 0ns - ProbeRows: 44.52M (44517465) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 16s446ms - RowsReturned: 46.02M (46018352) - RowsReturnedRate: 1.72 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.285us EXCHANGE_NODE (id=7):(Total: 933.448ms, non-child: 149.318ms, % non-child: 16.00%) BytesReceived(1s000ms): 18.24 MB, 50.76 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB, 53.11 MB - BytesReceived: 53.11 MB (55694922) - ConvertRowBatchTime: 115.482ms - DeserializeRowBatchTimer: 156.44ms - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 4.50M (4501010) - RowsReturnedRate: 4.82 M/sec - SendersBlockedTimer: 240.821ms - SendersBlockedTotalTimer(*): 2s390ms EXCHANGE_NODE (id=6):(Total: 8s335ms, non-child: 2s761ms, % non-child: 33.13%) BytesReceived(1s000ms): 10.18 MB, 10.18 MB, 23.57 MB, 79.01 MB, 139.27 MB, 201.32 MB, 262.82 MB, 325.14 MB, 388.40 MB, 451.95 MB, 515.40 MB, 578.82 MB, 642.44 MB, 705.96 MB, 769.31 MB, 833.06 MB, 896.93 MB, 960.01 MB, 1023.99 MB, 1.06 GB, 1.12 GB, 1.18 GB, 1.23 GB, 1.28 GB, 1.34 GB, 1.39 GB, 1.45 GB, 1.50 GB, 1.56 GB, 1.63 GB, 1.69 GB, 1.76 GB, 1.82 GB, 1.88 GB, 1.94 GB, 1.99 GB, 2.04 GB, 2.09 GB, 2.13 GB, 2.15 GB, 2.16 GB - BytesReceived: 2.16 GB (2321000003) - ConvertRowBatchTime: 1s138ms - DeserializeRowBatchTimer: 8s814ms - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 44.52M (44517465) - RowsReturnedRate: 5.34 M/sec - SendersBlockedTimer: 2s077ms - SendersBlockedTotalTimer(*): 18s933ms Instance 1d450fc48c2dd820:5346b5ca90c9afda (host=c2134.hal.cloudera.com:22000):(Total: 1m11s, non-child: 0ns, % non-child: 0.00%) MemoryUsage(2s000ms): 91.31 MB, 330.26 MB, 464.84 MB, 469.74 MB, 469.58 MB, 470.14 MB, 469.77 MB, 475.75 MB, 478.85 MB, 480.56 MB, 487.19 MB, 487.74 MB, 487.75 MB, 487.74 MB, 471.66 MB, 470.13 MB, 473.14 MB, 469.34 MB, 469.31 MB, 469.27 MB, 447.13 MB, 225.37 MB, 204.51 MB, 191.99 MB, 175.31 MB, 158.62 MB, 146.10 MB, 133.59 MB, 116.90 MB, 100.21 MB, 87.70 MB, 71.01 MB, 58.49 MB, 41.80 MB, 29.29 MB, 16.77 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 - AverageThreadTokens: 1.03 - PeakMemoryUsage: 487.80 MB (511499104) - PerHostPeakMemUsage: 1.20 GB (1285635640) - PrepareTime: 252.968ms - RowsProduced: 4.50M (4498087) - TotalCpuTime: 39s136ms - TotalNetworkReceiveTime: 6s336ms - TotalNetworkSendTime: 27s975ms - TotalStorageWaitTime: 0ns CodeGen:(Total: 810.363ms, non-child: 810.363ms, % non-child: 100.00%) - CodegenTime: 4.117ms - CompileTime: 78.826ms - LoadTime: 99.935us - ModuleFileSize: 2.43 MB (2543720) - OptimizationTime: 486.453ms - PrepareTime: 243.349ms DataStreamSender (dst_id=8):(Total: 29s377ms, non-child: 29s377ms, % non-child: 100.00%) - BytesSent: 54.41 MB (57049279) - NetworkThroughput(*): 1.90 MB/sec - OverallThroughput: 1.85 MB/sec - PeakMemoryUsage: 81.28 KB (83232) - SerializeBatchTime: 522.64ms - ThriftTransmitTime(*): 28s658ms - UncompressedRowBatchSize: 120.14 MB (125972820) AGGREGATION_NODE (id=3):(Total: 41s678ms, non-child: 15s482ms, % non-child: 37.15%) ExecOption: Codegen Enabled - BuildTime: 14s815ms - GetNewBlockTime: 157.694us - GetResultsTime: 265.253ms - HTResizeTime: 260.979ms - HashBuckets: 8.39M (8388608) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 271.02 MB (284180480) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 4.50M (4498087) - RowsReturnedRate: 107.92 K/sec - SpilledPartitions: 0 (0) - UnpinTime: 997ns HASH_JOIN_NODE (id=2):(Total: 26s196ms, non-child: 20s276ms, % non-child: 77.40%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildPartitionTime: 288.539ms - BuildRows: 4.50M (4498087) - BuildRowsPartitioned: 4.50M (4498087) - BuildTime: 451.937ms - GetNewBlockTime: 166.406us - HashBuckets: 8.39M (8388608) - LargestPartitionPercent: 6 (6) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 267.02 MB (279994368) - PinTime: 0ns - ProbeRows: 44.51M (44506005) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 17s475ms - RowsReturned: 46.00M (46004827) - RowsReturnedRate: 1.76 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.296us EXCHANGE_NODE (id=7):(Total: 966.47ms, non-child: 140.209ms, % non-child: 14.51%) BytesReceived(1s000ms): 15.01 MB, 48.77 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB, 53.09 MB - BytesReceived: 53.09 MB (55668260) - ConvertRowBatchTime: 109.228ms - DeserializeRowBatchTimer: 155.258ms - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 4.50M (4498087) - RowsReturnedRate: 4.66 M/sec - SendersBlockedTimer: 220.432ms - SendersBlockedTotalTimer(*): 2s186ms EXCHANGE_NODE (id=6):(Total: 6s764ms, non-child: 3s222ms, % non-child: 47.63%) BytesReceived(1s000ms): 10.17 MB, 10.18 MB, 20.24 MB, 71.82 MB, 132.39 MB, 193.77 MB, 255.36 MB, 317.40 MB, 380.71 MB, 444.18 MB, 507.67 MB, 571.08 MB, 634.70 MB, 698.30 MB, 761.66 MB, 825.14 MB, 889.24 MB, 952.26 MB, 1016.15 MB, 1.06 GB, 1.12 GB, 1.17 GB, 1.22 GB, 1.28 GB, 1.33 GB, 1.39 GB, 1.44 GB, 1.49 GB, 1.56 GB, 1.62 GB, 1.68 GB, 1.75 GB, 1.81 GB, 1.87 GB, 1.93 GB, 1.98 GB, 2.04 GB, 2.08 GB, 2.12 GB, 2.15 GB, 2.16 GB - BytesReceived: 2.16 GB (2320406932) - ConvertRowBatchTime: 1s118ms - DeserializeRowBatchTimer: 8s172ms - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 44.51M (44506005) - RowsReturnedRate: 6.58 M/sec - SendersBlockedTimer: 8s398ms - SendersBlockedTotalTimer(*): 51s652ms Instance 1d450fc48c2dd820:5346b5ca90c9afd3 (host=c2120.hal.cloudera.com:22000):(Total: 1m10s, non-child: 0ns, % non-child: 0.00%) MemoryUsage(2s000ms): 90.57 MB, 326.71 MB, 462.29 MB, 469.35 MB, 469.31 MB, 469.33 MB, 469.29 MB, 469.35 MB, 469.34 MB, 469.40 MB, 469.35 MB, 469.31 MB, 469.30 MB, 469.30 MB, 469.36 MB, 469.33 MB, 469.38 MB, 469.34 MB, 469.30 MB, 469.28 MB, 451.28 MB, 225.36 MB, 204.51 MB, 191.99 MB, 175.31 MB, 162.79 MB, 146.10 MB, 133.59 MB, 116.90 MB, 104.38 MB, 87.70 MB, 71.01 MB, 58.49 MB, 41.81 MB, 29.29 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 - AverageThreadTokens: 1.03 - PeakMemoryUsage: 477.35 MB (500534456) - PerHostPeakMemUsage: 1.26 GB (1353256608) - PrepareTime: 254.842ms - RowsProduced: 4.50M (4499698) - TotalCpuTime: 36s537ms - TotalNetworkReceiveTime: 9s052ms - TotalNetworkSendTime: 27s804ms - TotalStorageWaitTime: 0ns CodeGen:(Total: 824.792ms, non-child: 824.792ms, % non-child: 100.00%) - CodegenTime: 4.61ms - CompileTime: 78.562ms - LoadTime: 87.373us - ModuleFileSize: 2.43 MB (2543720) - OptimizationTime: 499.177ms - PrepareTime: 245.274ms DataStreamSender (dst_id=8):(Total: 29s298ms, non-child: 29s298ms, % non-child: 100.00%) - BytesSent: 54.42 MB (57064510) - NetworkThroughput(*): 1.90 MB/sec - OverallThroughput: 1.86 MB/sec - PeakMemoryUsage: 81.28 KB (83232) - SerializeBatchTime: 522.88ms - ThriftTransmitTime(*): 28s647ms - UncompressedRowBatchSize: 120.18 MB (126017936) AGGREGATION_NODE (id=3):(Total: 41s662ms, non-child: 14s312ms, % non-child: 34.35%) ExecOption: Codegen Enabled - BuildTime: 13s620ms - GetNewBlockTime: 154.986us - GetResultsTime: 286.601ms - HTResizeTime: 243.490ms - HashBuckets: 8.39M (8388608) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 271.02 MB (284180480) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 4.50M (4499698) - RowsReturnedRate: 108.00 K/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.14us HASH_JOIN_NODE (id=2):(Total: 27s350ms, non-child: 18s697ms, % non-child: 68.36%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildPartitionTime: 324.236ms - BuildRows: 4.50M (4499698) - BuildRowsPartitioned: 4.50M (4499698) - BuildTime: 493.590ms - GetNewBlockTime: 192.631us - HashBuckets: 8.39M (8388608) - LargestPartitionPercent: 6 (6) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 267.02 MB (279994368) - PinTime: 0ns - ProbeRows: 44.50M (44504653) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 15s784ms - RowsReturned: 46.00M (46004535) - RowsReturnedRate: 1.68 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.747us EXCHANGE_NODE (id=7):(Total: 905.513ms, non-child: 154.123ms, % non-child: 17.02%) BytesReceived(1s000ms): 13.54 MB, 48.24 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB, 53.10 MB - BytesReceived: 53.10 MB (55679827) - ConvertRowBatchTime: 116.774ms - DeserializeRowBatchTimer: 168.858ms - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 4.50M (4499698) - RowsReturnedRate: 4.97 M/sec - SendersBlockedTimer: 234.788ms - SendersBlockedTotalTimer(*): 2s101ms EXCHANGE_NODE (id=6):(Total: 9s581ms, non-child: 2s619ms, % non-child: 27.34%) BytesReceived(1s000ms): 9.95 MB, 10.19 MB, 19.74 MB, 70.06 MB, 130.50 MB, 191.89 MB, 253.49 MB, 315.54 MB, 378.74 MB, 442.09 MB, 505.67 MB, 569.08 MB, 632.79 MB, 696.45 MB, 759.81 MB, 823.29 MB, 887.37 MB, 950.39 MB, 1014.25 MB, 1.05 GB, 1.11 GB, 1.17 GB, 1.22 GB, 1.28 GB, 1.33 GB, 1.38 GB, 1.44 GB, 1.49 GB, 1.56 GB, 1.62 GB, 1.68 GB, 1.75 GB, 1.81 GB, 1.87 GB, 1.93 GB, 1.98 GB, 2.03 GB, 2.08 GB, 2.12 GB, 2.15 GB, 2.16 GB - BytesReceived: 2.16 GB (2320406848) - ConvertRowBatchTime: 1s162ms - DeserializeRowBatchTimer: 8s212ms - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 44.50M (44504653) - RowsReturnedRate: 4.64 M/sec - SendersBlockedTimer: 2s092ms - SendersBlockedTotalTimer(*): 19s074ms Fragment F01: Instance 1d450fc48c2dd820:5346b5ca90c9afe4 (host=c2132.hal.cloudera.com:22000):(Total: 1s791ms, non-child: 8.797ms, % non-child: 0.49%) Hdfs split stats (:<# splits>/): 9:1/252.20 MB 10:1/252.22 MB MemoryUsage(500.0ms): 37.45 MB, 37.42 MB, 21.53 MB ThreadUsage(500.0ms): 3, 3, 3 - AverageThreadTokens: 3.00 - PeakMemoryUsage: 37.60 MB (39422456) - PerHostPeakMemUsage: 1.03 GB (1100925344) - PrepareTime: 83.157us - RowsProduced: 6.31M (6305922) - TotalCpuTime: 4s914ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 329.995ms - TotalStorageWaitTime: 82.620ms DataStreamSender (dst_id=7):(Total: 1s697ms, non-child: 1s697ms, % non-child: 100.00%) - BytesSent: 75.06 MB (78709390) - NetworkThroughput(*): 9.11 MB/sec - OverallThroughput: 44.23 MB/sec - PeakMemoryUsage: 360.00 KB (368640) - SerializeBatchTime: 661.112ms - ThriftTransmitTime(*): 8s238ms - UncompressedRowBatchSize: 120.30 MB (126143092) HDFS_SCAN_NODE (id=0):(Total: 85.815ms, non-child: 85.815ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 9:1/252.20 MB 10:1/252.22 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:2 ExecOption: Codegen enabled: 0 out of 2 BytesRead(500.0ms): 24.48 MB, 24.48 MB, 24.48 MB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 2.00 - BytesRead: 24.48 MB (25670757) - BytesReadDataNodeCache: 0 - BytesReadLocal: 24.48 MB (25670757) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 24.48 MB (25670757) - DecompressionTime: 119.700ms - MaxCompressedTextFileLength: 0 - NumColumns: 2 (2) - NumDisksAccessed: 2 (2) - NumScannerThreadsStarted: 2 (2) - PeakMemoryUsage: 37.33 MB (39143928) - PerReadThreadRawHdfsThroughput: 1.04 GB/sec - RemoteScanRanges: 0 (0) - RowsRead: 6.31M (6305922) - RowsReturned: 6.31M (6305922) - RowsReturnedRate: 73.48 M/sec - ScanRangesComplete: 2 (2) - ScannerThreadsInvoluntaryContextSwitches: 249 (249) - ScannerThreadsTotalWallClockTime: 3s513ms - MaterializeTupleTime(*): 3s300ms - ScannerThreadsSysTime: 38.993ms - ScannerThreadsUserTime: 622.905ms - ScannerThreadsVoluntaryContextSwitches: 6.02K (6022) - TotalRawHdfsReadTime(*): 22.937ms - TotalReadThroughput: 16.32 MB/sec Instance 1d450fc48c2dd820:5346b5ca90c9afe1 (host=c2120.hal.cloudera.com:22000):(Total: 1s675ms, non-child: 9.686ms, % non-child: 0.58%) Hdfs split stats (:<# splits>/): 8:1/252.18 MB 1:1/96.04 MB 3:1/108.09 MB MemoryUsage(500.0ms): 37.82 MB, 37.85 MB, 21.30 MB ThreadUsage(500.0ms): 4, 4, 2 - AverageThreadTokens: 3.33 - PeakMemoryUsage: 37.99 MB (39839416) - PerHostPeakMemUsage: 1012.47 MB (1061648248) - PrepareTime: 101.381us - RowsProduced: 5.70M (5698005) - TotalCpuTime: 5s384ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 328.116ms - TotalStorageWaitTime: 141.549ms DataStreamSender (dst_id=7):(Total: 1s573ms, non-child: 1s573ms, % non-child: 100.00%) - BytesSent: 67.70 MB (70988165) - NetworkThroughput(*): 8.99 MB/sec - OverallThroughput: 43.02 MB/sec - PeakMemoryUsage: 360.00 KB (368640) - SerializeBatchTime: 608.206ms - ThriftTransmitTime(*): 7s532ms - UncompressedRowBatchSize: 108.70 MB (113982376) HDFS_SCAN_NODE (id=0):(Total: 92.501ms, non-child: 92.501ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 8:1/252.18 MB 1:1/96.04 MB 3:1/108.09 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:3 ExecOption: Codegen enabled: 0 out of 3 BytesRead(500.0ms): 22.33 MB, 22.33 MB, 22.33 MB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 2.33 - BytesRead: 22.33 MB (23414677) - BytesReadDataNodeCache: 0 - BytesReadLocal: 22.33 MB (23414677) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 22.33 MB (23414677) - DecompressionTime: 108.459ms - MaxCompressedTextFileLength: 0 - NumColumns: 3 (3) - NumDisksAccessed: 3 (3) - NumScannerThreadsStarted: 3 (3) - PeakMemoryUsage: 37.70 MB (39536312) - PerReadThreadRawHdfsThroughput: 690.47 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 5.70M (5698005) - RowsReturned: 5.70M (5698005) - RowsReturnedRate: 61.60 M/sec - ScanRangesComplete: 3 (3) - ScannerThreadsInvoluntaryContextSwitches: 204 (204) - ScannerThreadsTotalWallClockTime: 4s154ms - MaterializeTupleTime(*): 3s889ms - ScannerThreadsSysTime: 38.992ms - ScannerThreadsUserTime: 569.913ms - ScannerThreadsVoluntaryContextSwitches: 5.27K (5273) - TotalRawHdfsReadTime(*): 32.340ms - TotalReadThroughput: 14.89 MB/sec Instance 1d450fc48c2dd820:5346b5ca90c9afe3 (host=c2136.hal.cloudera.com:22000):(Total: 1s632ms, non-child: 7.159ms, % non-child: 0.44%) Hdfs split stats (:<# splits>/): 4:1/252.20 MB 9:1/108.07 MB 8:1/108.04 MB MemoryUsage(500.0ms): 37.84 MB, 37.78 MB, 21.03 MB ThreadUsage(500.0ms): 4, 4, 2 - AverageThreadTokens: 3.33 - PeakMemoryUsage: 38.03 MB (39872184) - PerHostPeakMemUsage: 1.02 GB (1090023912) - PrepareTime: 98.76us - RowsProduced: 5.85M (5847651) - TotalCpuTime: 5s254ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 333.756ms - TotalStorageWaitTime: 142.753ms DataStreamSender (dst_id=7):(Total: 1s531ms, non-child: 1s531ms, % non-child: 100.00%) - BytesSent: 69.41 MB (72777384) - NetworkThroughput(*): 8.52 MB/sec - OverallThroughput: 45.33 MB/sec - PeakMemoryUsage: 360.00 KB (368640) - SerializeBatchTime: 582.402ms - ThriftTransmitTime(*): 8s145ms - UncompressedRowBatchSize: 111.56 MB (116975884) HDFS_SCAN_NODE (id=0):(Total: 93.689ms, non-child: 93.689ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 4:1/252.20 MB 9:1/108.07 MB 8:1/108.04 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:3 ExecOption: Codegen enabled: 0 out of 3 BytesRead(500.0ms): 22.90 MB, 22.90 MB, 22.90 MB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 2.33 - BytesRead: 22.90 MB (24014328) - BytesReadDataNodeCache: 0 - BytesReadLocal: 22.90 MB (24014328) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 22.90 MB (24014328) - DecompressionTime: 95.334ms - MaxCompressedTextFileLength: 0 - NumColumns: 3 (3) - NumDisksAccessed: 3 (3) - NumScannerThreadsStarted: 3 (3) - PeakMemoryUsage: 37.67 MB (39495344) - PerReadThreadRawHdfsThroughput: 894.40 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 5.85M (5847651) - RowsReturned: 5.85M (5847651) - RowsReturnedRate: 62.42 M/sec - ScanRangesComplete: 3 (3) - ScannerThreadsInvoluntaryContextSwitches: 187 (187) - ScannerThreadsTotalWallClockTime: 4s077ms - MaterializeTupleTime(*): 3s825ms - ScannerThreadsSysTime: 17.996ms - ScannerThreadsUserTime: 490.924ms - ScannerThreadsVoluntaryContextSwitches: 5.43K (5433) - TotalRawHdfsReadTime(*): 25.605ms - TotalReadThroughput: 15.27 MB/sec Instance 1d450fc48c2dd820:5346b5ca90c9afdd (host=c2124.hal.cloudera.com:22000):(Total: 1s513ms, non-child: 9.978ms, % non-child: 0.66%) Hdfs split stats (:<# splits>/): 1:1/108.05 MB 0:1/252.19 MB MemoryUsage(500.0ms): 29.41 MB, 29.43 MB, 13.13 MB ThreadUsage(500.0ms): 3, 3, 2 - AverageThreadTokens: 2.67 - PeakMemoryUsage: 29.56 MB (30999720) - PerHostPeakMemUsage: 1.06 GB (1142471264) - PrepareTime: 83.994us - RowsProduced: 4.50M (4499686) - TotalCpuTime: 3s660ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 324.545ms - TotalStorageWaitTime: 75.292ms DataStreamSender (dst_id=7):(Total: 1s424ms, non-child: 1s424ms, % non-child: 100.00%) - BytesSent: 53.17 MB (55747965) - NetworkThroughput(*): 8.20 MB/sec - OverallThroughput: 37.33 MB/sec - PeakMemoryUsage: 360.00 KB (368640) - SerializeBatchTime: 536.750ms - ThriftTransmitTime(*): 6s487ms - UncompressedRowBatchSize: 85.84 MB (90011316) HDFS_SCAN_NODE (id=0):(Total: 78.825ms, non-child: 78.825ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 1:1/108.05 MB 0:1/252.19 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:2 ExecOption: Codegen enabled: 0 out of 2 BytesRead(500.0ms): 17.57 MB, 17.57 MB, 17.57 MB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 1.67 - BytesRead: 17.57 MB (18422206) - BytesReadDataNodeCache: 0 - BytesReadLocal: 17.57 MB (18422206) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 17.57 MB (18422206) - DecompressionTime: 79.311ms - MaxCompressedTextFileLength: 0 - NumColumns: 2 (2) - NumDisksAccessed: 2 (2) - NumScannerThreadsStarted: 2 (2) - PeakMemoryUsage: 29.27 MB (30696616) - PerReadThreadRawHdfsThroughput: 1022.93 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 4.50M (4499686) - RowsReturned: 4.50M (4499686) - RowsReturnedRate: 57.08 M/sec - ScanRangesComplete: 2 (2) - ScannerThreadsInvoluntaryContextSwitches: 223 (223) - ScannerThreadsTotalWallClockTime: 2s524ms - MaterializeTupleTime(*): 2s359ms - ScannerThreadsSysTime: 28.994ms - ScannerThreadsUserTime: 399.938ms - ScannerThreadsVoluntaryContextSwitches: 4.18K (4184) - TotalRawHdfsReadTime(*): 17.174ms - TotalReadThroughput: 11.71 MB/sec Instance 1d450fc48c2dd820:5346b5ca90c9afdb (host=c2126.hal.cloudera.com:22000):(Total: 1s427ms, non-child: 7.7ms, % non-child: 0.49%) Hdfs split stats (:<# splits>/): 9:1/119.96 MB 6:1/252.18 MB MemoryUsage(500.0ms): 29.42 MB, 29.44 MB, 676.51 KB ThreadUsage(500.0ms): 3, 3, 1 - AverageThreadTokens: 2.33 - PeakMemoryUsage: 29.59 MB (31024296) - PerHostPeakMemUsage: 940.53 MB (986214336) - PrepareTime: 86.719us - RowsProduced: 4.65M (4650000) - TotalCpuTime: 3s477ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 324.442ms - TotalStorageWaitTime: 93.214ms DataStreamSender (dst_id=7):(Total: 1s347ms, non-child: 1s347ms, % non-child: 100.00%) - BytesSent: 54.70 MB (57355663) - NetworkThroughput(*): 7.87 MB/sec - OverallThroughput: 40.59 MB/sec - PeakMemoryUsage: 360.00 KB (368640) - SerializeBatchTime: 498.949ms - ThriftTransmitTime(*): 6s952ms - UncompressedRowBatchSize: 88.71 MB (93018184) HDFS_SCAN_NODE (id=0):(Total: 72.361ms, non-child: 72.361ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 9:1/119.96 MB 6:1/252.18 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:2 ExecOption: Codegen enabled: 0 out of 2 BytesRead(500.0ms): 18.14 MB, 18.14 MB, 18.14 MB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 1.33 - BytesRead: 18.14 MB (19026187) - BytesReadDataNodeCache: 0 - BytesReadLocal: 18.14 MB (19026187) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 18.14 MB (19026187) - DecompressionTime: 77.955ms - MaxCompressedTextFileLength: 0 - NumColumns: 2 (2) - NumDisksAccessed: 2 (2) - NumScannerThreadsStarted: 2 (2) - PeakMemoryUsage: 29.27 MB (30696616) - PerReadThreadRawHdfsThroughput: 574.24 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 4.65M (4650000) - RowsReturned: 4.65M (4650000) - RowsReturnedRate: 64.26 M/sec - ScanRangesComplete: 2 (2) - ScannerThreadsInvoluntaryContextSwitches: 169 (169) - ScannerThreadsTotalWallClockTime: 2s446ms - MaterializeTupleTime(*): 2s265ms - ScannerThreadsSysTime: 17.996ms - ScannerThreadsUserTime: 425.935ms - ScannerThreadsVoluntaryContextSwitches: 4.27K (4266) - TotalRawHdfsReadTime(*): 31.597ms - TotalReadThroughput: 12.10 MB/sec Instance 1d450fc48c2dd820:5346b5ca90c9afdc (host=c2134.hal.cloudera.com:22000):(Total: 1s417ms, non-child: 7.863ms, % non-child: 0.55%) Hdfs split stats (:<# splits>/): 3:1/96.02 MB 1:1/252.20 MB MemoryUsage(500.0ms): 29.42 MB, 29.42 MB, 13.11 MB ThreadUsage(500.0ms): 3, 3, 2 - AverageThreadTokens: 2.67 - PeakMemoryUsage: 29.61 MB (31048872) - PerHostPeakMemUsage: 941.16 MB (986873760) - PrepareTime: 84.939us - RowsProduced: 4.35M (4349874) - TotalCpuTime: 3s361ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 330.156ms - TotalStorageWaitTime: 82.156ms DataStreamSender (dst_id=7):(Total: 1s341ms, non-child: 1s341ms, % non-child: 100.00%) - BytesSent: 50.87 MB (53345993) - NetworkThroughput(*): 7.88 MB/sec - OverallThroughput: 37.93 MB/sec - PeakMemoryUsage: 360.00 KB (368640) - SerializeBatchTime: 489.314ms - ThriftTransmitTime(*): 6s457ms - UncompressedRowBatchSize: 82.98 MB (87014496) HDFS_SCAN_NODE (id=0):(Total: 68.315ms, non-child: 68.315ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 3:1/96.02 MB 1:1/252.20 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:2 ExecOption: Codegen enabled: 0 out of 2 BytesRead(500.0ms): 16.99 MB, 16.99 MB, 16.99 MB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 1.67 - BytesRead: 16.99 MB (17820514) - BytesReadDataNodeCache: 0 - BytesReadLocal: 16.99 MB (17820514) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 16.99 MB (17820514) - DecompressionTime: 84.845ms - MaxCompressedTextFileLength: 0 - NumColumns: 2 (2) - NumDisksAccessed: 2 (2) - NumScannerThreadsStarted: 2 (2) - PeakMemoryUsage: 29.27 MB (30696616) - PerReadThreadRawHdfsThroughput: 1007.85 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 4.35M (4349874) - RowsReturned: 4.35M (4349874) - RowsReturnedRate: 63.67 M/sec - ScanRangesComplete: 2 (2) - ScannerThreadsInvoluntaryContextSwitches: 167 (167) - ScannerThreadsTotalWallClockTime: 2s335ms - MaterializeTupleTime(*): 2s158ms - ScannerThreadsSysTime: 15.997ms - ScannerThreadsUserTime: 411.936ms - ScannerThreadsVoluntaryContextSwitches: 4.00K (4005) - TotalRawHdfsReadTime(*): 16.862ms - TotalReadThroughput: 11.33 MB/sec Instance 1d450fc48c2dd820:5346b5ca90c9afe0 (host=c2118.hal.cloudera.com:22000):(Total: 1s374ms, non-child: 6.880ms, % non-child: 0.50%) Hdfs split stats (:<# splits>/): 8:1/108.00 MB 5:1/119.98 MB 6:1/108.02 MB MemoryUsage(500.0ms): 29.80 MB, 29.78 MB, 686.52 KB ThreadUsage(500.0ms): 4, 4, 1 - AverageThreadTokens: 3.00 - PeakMemoryUsage: 30.03 MB (31483576) - PerHostPeakMemUsage: 921.51 MB (966273640) - PrepareTime: 173.184us - RowsProduced: 4.19M (4190953) - TotalCpuTime: 4s913ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 330.79ms - TotalStorageWaitTime: 143.733ms DataStreamSender (dst_id=7):(Total: 1s282ms, non-child: 1s282ms, % non-child: 100.00%) - BytesSent: 49.52 MB (51922158) - NetworkThroughput(*): 7.50 MB/sec - OverallThroughput: 38.62 MB/sec - PeakMemoryUsage: 360.00 KB (368640) - SerializeBatchTime: 458.58ms - ThriftTransmitTime(*): 6s598ms - UncompressedRowBatchSize: 79.95 MB (83835448) HDFS_SCAN_NODE (id=0):(Total: 85.71ms, non-child: 85.71ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 8:1/108.00 MB 5:1/119.98 MB 6:1/108.02 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:3 ExecOption: Codegen enabled: 0 out of 3 BytesRead(500.0ms): 16.56 MB, 16.56 MB, 16.56 MB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 2.00 - BytesRead: 16.56 MB (17367956) - BytesReadDataNodeCache: 0 - BytesReadLocal: 16.56 MB (17367956) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 16.56 MB (17367956) - DecompressionTime: 81.556ms - MaxCompressedTextFileLength: 0 - NumColumns: 3 (3) - NumDisksAccessed: 3 (3) - NumScannerThreadsStarted: 3 (3) - PeakMemoryUsage: 29.70 MB (31147704) - PerReadThreadRawHdfsThroughput: 578.82 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 4.19M (4190953) - RowsReturned: 4.19M (4190953) - RowsReturnedRate: 49.26 M/sec - ScanRangesComplete: 3 (3) - ScannerThreadsInvoluntaryContextSwitches: 217 (217) - ScannerThreadsTotalWallClockTime: 3s992ms - MaterializeTupleTime(*): 3s749ms - ScannerThreadsSysTime: 51.990ms - ScannerThreadsUserTime: 404.938ms - ScannerThreadsVoluntaryContextSwitches: 4.03K (4030) - TotalRawHdfsReadTime(*): 28.615ms - TotalReadThroughput: 11.04 MB/sec Instance 1d450fc48c2dd820:5346b5ca90c9afdf (host=c2122.hal.cloudera.com:22000):(Total: 1s200ms, non-child: 7.735ms, % non-child: 0.64%) Hdfs split stats (:<# splits>/): 6:1/252.20 MB MemoryUsage(500.0ms): 21.09 MB, 13.11 MB ThreadUsage(500.0ms): 2, 2 - AverageThreadTokens: 2.00 - PeakMemoryUsage: 21.16 MB (22184600) - PerHostPeakMemUsage: 1.01 GB (1084317392) - PrepareTime: 76.644us - RowsProduced: 3.15M (3152576) - TotalCpuTime: 2s029ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 326.216ms - TotalStorageWaitTime: 35.53ms DataStreamSender (dst_id=7):(Total: 1s126ms, non-child: 1s126ms, % non-child: 100.00%) - BytesSent: 36.83 MB (38617189) - NetworkThroughput(*): 6.57 MB/sec - OverallThroughput: 32.71 MB/sec - PeakMemoryUsage: 360.00 KB (368640) - SerializeBatchTime: 379.500ms - ThriftTransmitTime(*): 5s607ms - UncompressedRowBatchSize: 60.14 MB (63063856) HDFS_SCAN_NODE (id=0):(Total: 66.228ms, non-child: 66.228ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 6:1/252.20 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:1 ExecOption: Codegen enabled: 0 out of 1 BytesRead(500.0ms): 12.24 MB, 12.24 MB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 1.00 - BytesRead: 12.24 MB (12833467) - BytesReadDataNodeCache: 0 - BytesReadLocal: 12.24 MB (12833467) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 12.24 MB (12833467) - DecompressionTime: 68.738ms - MaxCompressedTextFileLength: 0 - NumColumns: 1 (1) - NumDisksAccessed: 1 (1) - NumScannerThreadsStarted: 1 (1) - PeakMemoryUsage: 20.88 MB (21892320) - PerReadThreadRawHdfsThroughput: 998.32 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 3.15M (3152576) - RowsReturned: 3.15M (3152576) - RowsReturnedRate: 47.60 M/sec - ScanRangesComplete: 1 (1) - ScannerThreadsInvoluntaryContextSwitches: 246 (246) - ScannerThreadsTotalWallClockTime: 1s169ms - MaterializeTupleTime(*): 1s059ms - ScannerThreadsSysTime: 10.998ms - ScannerThreadsUserTime: 321.951ms - ScannerThreadsVoluntaryContextSwitches: 2.68K (2678) - TotalRawHdfsReadTime(*): 12.259ms - TotalReadThroughput: 12.24 MB/sec Instance 1d450fc48c2dd820:5346b5ca90c9afe2 (host=c2130.hal.cloudera.com:22000):(Total: 1s180ms, non-child: 6.396ms, % non-child: 0.54%) Hdfs split stats (:<# splits>/): 6:1/252.21 MB MemoryUsage(500.0ms): 240.00 KB, 21.06 MB, 13.10 MB ThreadUsage(500.0ms): 2, 2, 2 - AverageThreadTokens: 2.00 - PeakMemoryUsage: 21.18 MB (22211664) - PerHostPeakMemUsage: 1.07 GB (1146185072) - PrepareTime: 91.611us - RowsProduced: 3.15M (3152961) - TotalCpuTime: 1s970ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 328.600ms - TotalStorageWaitTime: 54.715ms DataStreamSender (dst_id=7):(Total: 1s100ms, non-child: 1s100ms, % non-child: 100.00%) - BytesSent: 36.93 MB (38722267) - NetworkThroughput(*): 6.68 MB/sec - OverallThroughput: 33.57 MB/sec - PeakMemoryUsage: 360.00 KB (368640) - SerializeBatchTime: 385.427ms - ThriftTransmitTime(*): 5s531ms - UncompressedRowBatchSize: 60.15 MB (63071556) HDFS_SCAN_NODE (id=0):(Total: 74.66ms, non-child: 74.66ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 6:1/252.21 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:1 ExecOption: Codegen enabled: 0 out of 1 BytesRead(500.0ms): 0, 12.24 MB, 12.24 MB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 1.00 - BytesRead: 12.24 MB (12835297) - BytesReadDataNodeCache: 0 - BytesReadLocal: 12.24 MB (12835297) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 12.24 MB (12835297) - DecompressionTime: 67.491ms - MaxCompressedTextFileLength: 0 - NumColumns: 1 (1) - NumDisksAccessed: 1 (1) - NumScannerThreadsStarted: 1 (1) - PeakMemoryUsage: 20.88 MB (21892176) - PerReadThreadRawHdfsThroughput: 699.22 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 3.15M (3152961) - RowsReturned: 3.15M (3152961) - RowsReturnedRate: 42.57 M/sec - ScanRangesComplete: 1 (1) - ScannerThreadsInvoluntaryContextSwitches: 276 (276) - ScannerThreadsTotalWallClockTime: 1s151ms - MaterializeTupleTime(*): 1s023ms - ScannerThreadsSysTime: 21.996ms - ScannerThreadsUserTime: 304.953ms - ScannerThreadsVoluntaryContextSwitches: 2.35K (2348) - TotalRawHdfsReadTime(*): 17.506ms - TotalReadThroughput: 8.16 MB/sec Instance 1d450fc48c2dd820:5346b5ca90c9afde (host=c2128.hal.cloudera.com:22000):(Total: 1s172ms, non-child: 7.187ms, % non-child: 0.61%) Hdfs split stats (:<# splits>/): 2:1/252.16 MB MemoryUsage(500.0ms): 112.00 KB, 21.04 MB, 13.04 MB ThreadUsage(500.0ms): 2, 2, 2 - AverageThreadTokens: 2.00 - PeakMemoryUsage: 21.17 MB (22202656) - PerHostPeakMemUsage: 1012.87 MB (1062068784) - PrepareTime: 82.636us - RowsProduced: 3.15M (3152372) - TotalCpuTime: 1s953ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 328.216ms - TotalStorageWaitTime: 56.903ms DataStreamSender (dst_id=7):(Total: 1s065ms, non-child: 1s065ms, % non-child: 100.00%) - BytesSent: 36.87 MB (38661533) - NetworkThroughput(*): 6.55 MB/sec - OverallThroughput: 34.60 MB/sec - PeakMemoryUsage: 360.00 KB (368640) - SerializeBatchTime: 353.269ms - ThriftTransmitTime(*): 5s625ms - UncompressedRowBatchSize: 60.14 MB (63059776) HDFS_SCAN_NODE (id=0):(Total: 99.895ms, non-child: 99.895ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 2:1/252.16 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:1 ExecOption: Codegen enabled: 0 out of 1 BytesRead(500.0ms): 100.00 KB, 12.24 MB, 12.24 MB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 1.00 - BytesRead: 12.24 MB (12832998) - BytesReadDataNodeCache: 0 - BytesReadLocal: 12.24 MB (12832998) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 12.24 MB (12832998) - DecompressionTime: 69.147ms - MaxCompressedTextFileLength: 0 - NumColumns: 1 (1) - NumDisksAccessed: 1 (1) - NumScannerThreadsStarted: 1 (1) - PeakMemoryUsage: 20.88 MB (21891360) - PerReadThreadRawHdfsThroughput: 683.80 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 3.15M (3152372) - RowsReturned: 3.15M (3152372) - RowsReturnedRate: 31.56 M/sec - ScanRangesComplete: 1 (1) - ScannerThreadsInvoluntaryContextSwitches: 85 (85) - ScannerThreadsTotalWallClockTime: 1s144ms - MaterializeTupleTime(*): 1s012ms - ScannerThreadsSysTime: 8.998ms - ScannerThreadsUserTime: 331.949ms - ScannerThreadsVoluntaryContextSwitches: 2.78K (2780) - TotalRawHdfsReadTime(*): 17.897ms - TotalReadThroughput: 8.16 MB/sec Fragment F00: Instance 1d450fc48c2dd820:5346b5ca90c9afe5 (host=c2130.hal.cloudera.com:22000):(Total: 40s940ms, non-child: 75.691ms, % non-child: 0.18%) Hdfs split stats (:<# splits>/): 9:1/253.09 MB 10:1/253.07 MB 3:2/408.34 MB 6:2/506.17 MB 0:1/253.08 MB 7:1/253.12 MB 1:1/140.08 MB MemoryUsage(1s000ms): 446.80 MB, 893.59 MB, 893.77 MB, 899.90 MB, 899.82 MB, 859.95 MB, 828.32 MB, 828.19 MB, 828.49 MB, 828.23 MB, 828.51 MB, 772.47 MB, 740.46 MB, 685.23 MB, 685.53 MB, 685.52 MB, 681.43 MB, 614.02 MB, 614.03 MB, 610.21 MB, 605.88 MB, 605.96 MB, 602.14 MB, 521.95 MB, 517.84 MB, 518.02 MB, 485.08 MB, 485.00 MB, 471.83 MB, 458.19 MB, 458.12 MB, 434.26 MB, 390.25 MB, 346.17 MB, 346.12 MB, 340.03 MB, 318.20 MB, 314.22 MB, 262.24 MB, 262.24 MB, 218.50 MB ThreadUsage(1s000ms): 5, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 9, 9, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8 - AverageThreadTokens: 9.12 - PeakMemoryUsage: 900.51 MB (944256976) - PerHostPeakMemUsage: 1.36 GB (1456487736) - PrepareTime: 159.639us - RowsProduced: 47.74M (47738453) - TotalCpuTime: 6m16s - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3s059ms - TotalStorageWaitTime: 784.728ms DataStreamSender (dst_id=6):(Total: 40s464ms, non-child: 40s464ms, % non-child: 100.00%) - BytesSent: 2.32 GB (2488266009) - NetworkThroughput(*): 16.15 MB/sec - OverallThroughput: 58.64 MB/sec - PeakMemoryUsage: 631.95 KB (647120) - SerializeBatchTime: 27s298ms - ThriftTransmitTime(*): 2m26s - UncompressedRowBatchSize: 4.11 GB (4410412008) HDFS_SCAN_NODE (id=1):(Total: 400.842ms, non-child: 400.842ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 9:1/253.09 MB 10:1/253.07 MB 3:2/408.34 MB 6:2/506.17 MB 0:1/253.08 MB 7:1/253.12 MB 1:1/140.08 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:27 ExecOption: Codegen enabled: 0 out of 9 BytesRead(1s000ms): 404.42 MB, 808.84 MB, 808.84 MB, 808.84 MB, 808.84 MB, 808.84 MB, 808.84 MB, 808.84 MB, 852.84 MB, 880.84 MB, 880.84 MB, 880.84 MB, 880.84 MB, 884.84 MB, 952.84 MB, 952.84 MB, 968.84 MB, 1.00 GB, 1.00 GB, 1.03 GB, 1.06 GB, 1.06 GB, 1.08 GB, 1.12 GB, 1.12 GB, 1.12 GB, 1.17 GB, 1.17 GB, 1.18 GB, 1.23 GB, 1.23 GB, 1.27 GB, 1.28 GB, 1.31 GB, 1.34 GB, 1.34 GB, 1.36 GB, 1.36 GB, 1.36 GB, 1.36 GB, 1.36 GB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 8.22 - BytesRead: 1.36 GB (1458288541) - BytesReadDataNodeCache: 0 - BytesReadLocal: 1.36 GB (1458288541) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 1.36 GB (1458288541) - DecompressionTime: 6s976ms - MaxCompressedTextFileLength: 0 - NumColumns: 27 (27) - NumDisksAccessed: 7 (7) - NumScannerThreadsStarted: 9 (9) - PeakMemoryUsage: 899.98 MB (943700000) - PerReadThreadRawHdfsThroughput: 951.79 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 48.26M (48258512) - RowsReturned: 47.74M (47738453) - RowsReturnedRate: 119.10 M/sec - ScanRangesComplete: 9 (9) - ScannerThreadsInvoluntaryContextSwitches: 23.06K (23057) - ScannerThreadsTotalWallClockTime: 5m39s - MaterializeTupleTime(*): 5m31s - ScannerThreadsSysTime: 714.888ms - ScannerThreadsUserTime: 50s179ms - ScannerThreadsVoluntaryContextSwitches: 46.58K (46582) - TotalRawHdfsReadTime(*): 1s461ms - TotalReadThroughput: 33.51 MB/sec Instance 1d450fc48c2dd820:5346b5ca90c9afe6 (host=c2132.hal.cloudera.com:22000):(Total: 40s157ms, non-child: 76.800ms, % non-child: 0.19%) Hdfs split stats (:<# splits>/): 9:1/253.08 MB 3:2/506.17 MB 1:1/253.09 MB 2:1/253.08 MB 6:2/506.17 MB 4:1/253.07 MB MemoryUsage(1s000ms): 834.24 MB, 834.24 MB, 836.99 MB, 839.23 MB, 823.42 MB, 775.76 MB, 775.99 MB, 775.60 MB, 775.51 MB, 775.91 MB, 711.48 MB, 664.39 MB, 648.73 MB, 648.66 MB, 648.69 MB, 593.25 MB, 585.16 MB, 585.00 MB, 585.35 MB, 585.30 MB, 549.37 MB, 521.23 MB, 521.22 MB, 521.10 MB, 521.24 MB, 520.88 MB, 521.23 MB, 521.22 MB, 521.30 MB, 481.33 MB, 437.05 MB, 393.24 MB, 393.18 MB, 390.84 MB, 361.25 MB, 361.23 MB, 325.05 MB, 297.04 MB, 293.51 MB, 197.37 MB ThreadUsage(1s000ms): 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 8 - AverageThreadTokens: 8.99 - PeakMemoryUsage: 840.04 MB (880844376) - PerHostPeakMemUsage: 1.30 GB (1391085808) - PrepareTime: 117.276us - RowsProduced: 46.77M (46767102) - TotalCpuTime: 5m57s - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3s030ms - TotalStorageWaitTime: 652.35ms DataStreamSender (dst_id=6):(Total: 39s697ms, non-child: 39s697ms, % non-child: 100.00%) - BytesSent: 2.27 GB (2437828907) - NetworkThroughput(*): 15.94 MB/sec - OverallThroughput: 58.57 MB/sec - PeakMemoryUsage: 631.95 KB (647120) - SerializeBatchTime: 26s841ms - ThriftTransmitTime(*): 2m25s - UncompressedRowBatchSize: 4.02 GB (4320830793) HDFS_SCAN_NODE (id=1):(Total: 383.482ms, non-child: 383.482ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 9:1/253.08 MB 3:2/506.17 MB 1:1/253.09 MB 2:1/253.08 MB 6:2/506.17 MB 4:1/253.07 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:24 ExecOption: Codegen enabled: 0 out of 8 BytesRead(1s000ms): 759.50 MB, 759.50 MB, 759.50 MB, 759.50 MB, 759.50 MB, 759.50 MB, 759.50 MB, 807.50 MB, 823.50 MB, 823.50 MB, 823.50 MB, 823.50 MB, 855.50 MB, 887.50 MB, 887.50 MB, 947.50 MB, 951.50 MB, 979.50 MB, 1015.50 MB, 1015.50 MB, 1.05 GB, 1.05 GB, 1.05 GB, 1.11 GB, 1.12 GB, 1.12 GB, 1.18 GB, 1.18 GB, 1.19 GB, 1.24 GB, 1.24 GB, 1.28 GB, 1.30 GB, 1.31 GB, 1.33 GB, 1.33 GB, 1.33 GB, 1.33 GB, 1.33 GB, 1.33 GB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 7.99 - BytesRead: 1.33 GB (1428419209) - BytesReadDataNodeCache: 0 - BytesReadLocal: 1.33 GB (1428419209) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 1.33 GB (1428419209) - DecompressionTime: 6s764ms - MaxCompressedTextFileLength: 0 - NumColumns: 24 (24) - NumDisksAccessed: 6 (6) - NumScannerThreadsStarted: 8 (8) - PeakMemoryUsage: 839.50 MB (880279176) - PerReadThreadRawHdfsThroughput: 1.07 GB/sec - RemoteScanRanges: 0 (0) - RowsRead: 47.28M (47277386) - RowsReturned: 46.77M (46767102) - RowsReturnedRate: 121.95 M/sec - ScanRangesComplete: 8 (8) - ScannerThreadsInvoluntaryContextSwitches: 22.09K (22093) - ScannerThreadsTotalWallClockTime: 5m20s - MaterializeTupleTime(*): 5m12s - ScannerThreadsSysTime: 636.900ms - ScannerThreadsUserTime: 48s665ms - ScannerThreadsVoluntaryContextSwitches: 45.60K (45602) - TotalRawHdfsReadTime(*): 1s243ms - TotalReadThroughput: 34.06 MB/sec Instance 1d450fc48c2dd820:5346b5ca90c9afec (host=c2122.hal.cloudera.com:22000):(Total: 39s479ms, non-child: 70.157ms, % non-child: 0.18%) Hdfs split stats (:<# splits>/): 1:1/253.08 MB 2:1/253.08 MB 3:2/506.16 MB 5:1/253.08 MB 7:2/506.18 MB 9:1/253.09 MB MemoryUsage(1s000ms): 834.84 MB, 834.84 MB, 837.08 MB, 839.34 MB, 815.62 MB, 775.71 MB, 775.57 MB, 775.77 MB, 775.71 MB, 772.00 MB, 711.66 MB, 672.41 MB, 648.69 MB, 648.91 MB, 648.80 MB, 593.24 MB, 585.28 MB, 585.34 MB, 585.43 MB, 585.21 MB, 553.08 MB, 521.09 MB, 521.21 MB, 521.17 MB, 521.36 MB, 521.36 MB, 521.30 MB, 521.14 MB, 517.18 MB, 461.27 MB, 409.15 MB, 392.99 MB, 393.20 MB, 377.11 MB, 361.11 MB, 357.21 MB, 297.11 MB, 297.24 MB, 253.22 MB ThreadUsage(1s000ms): 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9 - AverageThreadTokens: 8.91 - PeakMemoryUsage: 840.14 MB (880947344) - PerHostPeakMemUsage: 1.30 GB (1393210864) - PrepareTime: 140.726us - RowsProduced: 46.77M (46767436) - TotalCpuTime: 5m50s - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3s068ms - TotalStorageWaitTime: 635.499ms DataStreamSender (dst_id=6):(Total: 39s055ms, non-child: 39s055ms, % non-child: 100.00%) - BytesSent: 2.27 GB (2439064145) - NetworkThroughput(*): 16.02 MB/sec - OverallThroughput: 59.56 MB/sec - PeakMemoryUsage: 631.95 KB (647120) - SerializeBatchTime: 26s425ms - ThriftTransmitTime(*): 2m25s - UncompressedRowBatchSize: 4.02 GB (4321081938) HDFS_SCAN_NODE (id=1):(Total: 353.892ms, non-child: 353.892ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 1:1/253.08 MB 2:1/253.08 MB 3:2/506.16 MB 5:1/253.08 MB 7:2/506.18 MB 9:1/253.09 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:24 ExecOption: Codegen enabled: 0 out of 8 BytesRead(1s000ms): 759.49 MB, 759.49 MB, 759.49 MB, 759.49 MB, 759.49 MB, 759.49 MB, 759.49 MB, 795.49 MB, 823.49 MB, 823.49 MB, 823.49 MB, 823.49 MB, 859.49 MB, 887.49 MB, 891.49 MB, 947.49 MB, 951.49 MB, 983.49 MB, 1015.49 MB, 1015.49 MB, 1.05 GB, 1.05 GB, 1.06 GB, 1.11 GB, 1.12 GB, 1.13 GB, 1.18 GB, 1.18 GB, 1.21 GB, 1.24 GB, 1.25 GB, 1.30 GB, 1.30 GB, 1.32 GB, 1.33 GB, 1.33 GB, 1.33 GB, 1.33 GB, 1.33 GB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 7.91 - BytesRead: 1.33 GB (1428439484) - BytesReadDataNodeCache: 0 - BytesReadLocal: 1.33 GB (1428439484) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 1.33 GB (1428439484) - DecompressionTime: 6s837ms - MaxCompressedTextFileLength: 0 - NumColumns: 24 (24) - NumDisksAccessed: 6 (6) - NumScannerThreadsStarted: 8 (8) - PeakMemoryUsage: 839.58 MB (880365816) - PerReadThreadRawHdfsThroughput: 1000.50 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 47.28M (47276133) - RowsReturned: 46.77M (46767436) - RowsReturnedRate: 132.15 M/sec - ScanRangesComplete: 8 (8) - ScannerThreadsInvoluntaryContextSwitches: 20.57K (20575) - ScannerThreadsTotalWallClockTime: 5m14s - MaterializeTupleTime(*): 5m6s - ScannerThreadsSysTime: 684.892ms - ScannerThreadsUserTime: 49s849ms - ScannerThreadsVoluntaryContextSwitches: 45.53K (45532) - TotalRawHdfsReadTime(*): 1s361ms - TotalReadThroughput: 34.49 MB/sec Instance 1d450fc48c2dd820:5346b5ca90c9afeb (host=c2124.hal.cloudera.com:22000):(Total: 38s864ms, non-child: 67.995ms, % non-child: 0.17%) Hdfs split stats (:<# splits>/): 8:1/253.07 MB 2:1/253.09 MB 3:1/253.08 MB 6:1/171.35 MB 10:2/423.69 MB 7:2/391.46 MB 1:1/253.09 MB MemoryUsage(1s000ms): 881.84 MB, 881.87 MB, 884.64 MB, 887.59 MB, 887.43 MB, 823.68 MB, 815.87 MB, 816.05 MB, 816.09 MB, 816.05 MB, 812.19 MB, 743.82 MB, 704.70 MB, 673.10 MB, 673.03 MB, 673.18 MB, 657.33 MB, 605.55 MB, 601.88 MB, 597.77 MB, 593.58 MB, 593.81 MB, 585.57 MB, 521.92 MB, 513.70 MB, 504.48 MB, 472.81 MB, 472.89 MB, 464.92 MB, 456.77 MB, 413.68 MB, 355.14 MB, 307.26 MB, 299.27 MB, 289.13 MB, 275.16 MB, 239.24 MB, 227.17 MB, 130.35 MB ThreadUsage(1s000ms): 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 9, 9, 9, 9, 9, 7, 7, 7, 7, 7, 7, 7, 7, 5 - AverageThreadTokens: 9.15 - PeakMemoryUsage: 888.05 MB (931192648) - PerHostPeakMemUsage: 1.34 GB (1440650376) - PrepareTime: 147.207us - RowsProduced: 46.16M (46161205) - TotalCpuTime: 5m54s - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3s133ms - TotalStorageWaitTime: 850.403ms DataStreamSender (dst_id=6):(Total: 38s421ms, non-child: 38s421ms, % non-child: 100.00%) - BytesSent: 2.24 GB (2406393013) - NetworkThroughput(*): 15.68 MB/sec - OverallThroughput: 59.73 MB/sec - PeakMemoryUsage: 631.95 KB (647120) - SerializeBatchTime: 25s974ms - ThriftTransmitTime(*): 2m26s - UncompressedRowBatchSize: 3.97 GB (4264791004) HDFS_SCAN_NODE (id=1):(Total: 375.133ms, non-child: 375.133ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 8:1/253.07 MB 2:1/253.09 MB 3:1/253.08 MB 6:1/171.35 MB 10:2/423.69 MB 7:2/391.46 MB 1:1/253.09 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:27 ExecOption: Codegen enabled: 0 out of 9 BytesRead(1s000ms): 794.08 MB, 794.08 MB, 794.08 MB, 794.08 MB, 794.08 MB, 794.08 MB, 794.08 MB, 794.08 MB, 862.08 MB, 866.08 MB, 866.08 MB, 866.08 MB, 866.08 MB, 886.08 MB, 938.08 MB, 938.08 MB, 962.08 MB, 1009.10 MB, 1009.10 MB, 1.02 GB, 1.05 GB, 1.05 GB, 1.07 GB, 1.11 GB, 1.11 GB, 1.11 GB, 1.15 GB, 1.15 GB, 1.17 GB, 1.20 GB, 1.21 GB, 1.25 GB, 1.26 GB, 1.29 GB, 1.30 GB, 1.31 GB, 1.31 GB, 1.31 GB, 1.31 GB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 8.15 - BytesRead: 1.31 GB (1410275109) - BytesReadDataNodeCache: 0 - BytesReadLocal: 1.31 GB (1410275109) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 1.31 GB (1410275109) - DecompressionTime: 6s497ms - MaxCompressedTextFileLength: 0 - NumColumns: 27 (27) - NumDisksAccessed: 7 (7) - NumScannerThreadsStarted: 9 (9) - PeakMemoryUsage: 887.55 MB (930660688) - PerReadThreadRawHdfsThroughput: 962.04 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 46.66M (46664503) - RowsReturned: 46.16M (46161205) - RowsReturnedRate: 123.05 M/sec - ScanRangesComplete: 9 (9) - ScannerThreadsInvoluntaryContextSwitches: 21.32K (21317) - ScannerThreadsTotalWallClockTime: 5m19s - MaterializeTupleTime(*): 5m11s - ScannerThreadsSysTime: 641.898ms - ScannerThreadsUserTime: 46s922ms - ScannerThreadsVoluntaryContextSwitches: 45.01K (45008) - TotalRawHdfsReadTime(*): 1s398ms - TotalReadThroughput: 34.49 MB/sec Instance 1d450fc48c2dd820:5346b5ca90c9afe8 (host=c2118.hal.cloudera.com:22000):(Total: 38s624ms, non-child: 70.97ms, % non-child: 0.18%) Hdfs split stats (:<# splits>/): 1:1/253.10 MB 3:1/253.08 MB 0:1/253.08 MB 5:1/253.10 MB 10:1/253.07 MB 7:1/253.05 MB 8:1/253.09 MB 4:1/153.76 MB MemoryUsage(1s000ms): 710.84 MB, 710.84 MB, 713.56 MB, 716.17 MB, 688.60 MB, 660.73 MB, 660.40 MB, 660.43 MB, 660.60 MB, 604.60 MB, 569.03 MB, 549.48 MB, 549.90 MB, 541.69 MB, 493.93 MB, 493.84 MB, 494.08 MB, 494.05 MB, 462.02 MB, 429.95 MB, 425.91 MB, 421.96 MB, 450.90 MB, 498.01 MB, 497.98 MB, 490.14 MB, 446.07 MB, 414.18 MB, 394.16 MB, 393.80 MB, 363.71 MB, 354.06 MB, 322.05 MB, 305.91 MB, 281.97 MB, 167.00 MB, 67.00 MB, 51.58 MB ThreadUsage(1s000ms): 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 5, 2, 2 - AverageThreadTokens: 7.53 - PeakMemoryUsage: 716.74 MB (751552808) - PerHostPeakMemUsage: 1.18 GB (1262776184) - PrepareTime: 132.93us - RowsProduced: 44.47M (44468858) - TotalCpuTime: 4m47s - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3s017ms - TotalStorageWaitTime: 718.414ms DataStreamSender (dst_id=6):(Total: 37s987ms, non-child: 37s987ms, % non-child: 100.00%) - BytesSent: 2.16 GB (2319811611) - NetworkThroughput(*): 15.90 MB/sec - OverallThroughput: 58.24 MB/sec - PeakMemoryUsage: 631.95 KB (647120) - SerializeBatchTime: 25s330ms - ThriftTransmitTime(*): 2m19s - UncompressedRowBatchSize: 3.83 GB (4108680863) HDFS_SCAN_NODE (id=1):(Total: 567.416ms, non-child: 567.416ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 1:1/253.10 MB 3:1/253.08 MB 0:1/253.08 MB 5:1/253.10 MB 10:1/253.07 MB 7:1/253.05 MB 8:1/253.09 MB 4:1/153.76 MB Hdfs Read Thread Concurrency Bucket: 0:96.1% 1:3.896% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:24 ExecOption: Codegen enabled: 0 out of 8 BytesRead(1s000ms): 643.06 MB, 643.06 MB, 643.06 MB, 643.06 MB, 643.06 MB, 643.06 MB, 659.06 MB, 699.06 MB, 699.06 MB, 699.06 MB, 699.06 MB, 735.06 MB, 755.06 MB, 779.06 MB, 811.06 MB, 815.06 MB, 865.10 MB, 865.10 MB, 901.10 MB, 913.10 MB, 937.10 MB, 961.10 MB, 993.15 MB, 1.07 GB, 1.08 GB, 1.10 GB, 1.13 GB, 1.13 GB, 1.18 GB, 1.18 GB, 1.20 GB, 1.20 GB, 1.21 GB, 1.21 GB, 1.21 GB, 1.21 GB, 1.23 GB, 1.26 GB - AverageHdfsReadThreadConcurrency: 0.04 - AverageScannerThreadConcurrency: 6.53 - BytesRead: 1.27 GB (1358394018) - BytesReadDataNodeCache: 0 - BytesReadLocal: 1.27 GB (1358394018) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 1.27 GB (1358394018) - DecompressionTime: 6s241ms - MaxCompressedTextFileLength: 0 - NumColumns: 24 (24) - NumDisksAccessed: 8 (8) - NumScannerThreadsStarted: 7 (7) - PeakMemoryUsage: 716.28 MB (751077880) - PerReadThreadRawHdfsThroughput: 817.75 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 44.95M (44953869) - RowsReturned: 44.47M (44468858) - RowsReturnedRate: 78.37 M/sec - ScanRangesComplete: 8 (8) - ScannerThreadsInvoluntaryContextSwitches: 18.45K (18455) - ScannerThreadsTotalWallClockTime: 4m12s - MaterializeTupleTime(*): 4m5s - ScannerThreadsSysTime: 650.899ms - ScannerThreadsUserTime: 45s105ms - ScannerThreadsVoluntaryContextSwitches: 39.92K (39922) - TotalRawHdfsReadTime(*): 1s584ms - TotalReadThroughput: 33.65 MB/sec Instance 1d450fc48c2dd820:5346b5ca90c9afea (host=c2128.hal.cloudera.com:22000):(Total: 38s327ms, non-child: 72.360ms, % non-child: 0.19%) Hdfs split stats (:<# splits>/): 7:1/253.06 MB 4:1/253.08 MB 9:1/253.07 MB 0:1/253.07 MB 5:1/140.06 MB 3:1/253.09 MB 2:2/506.19 MB MemoryUsage(1s000ms): 410.36 MB, 811.23 MB, 812.12 MB, 817.47 MB, 817.25 MB, 757.45 MB, 753.51 MB, 753.47 MB, 753.58 MB, 753.55 MB, 721.48 MB, 689.59 MB, 626.53 MB, 626.51 MB, 626.54 MB, 622.66 MB, 563.04 MB, 563.23 MB, 555.05 MB, 555.35 MB, 551.22 MB, 502.95 MB, 483.15 MB, 473.81 MB, 458.42 MB, 458.34 MB, 458.24 MB, 458.13 MB, 458.26 MB, 406.38 MB, 362.19 MB, 346.04 MB, 346.34 MB, 318.17 MB, 318.08 MB, 274.19 MB, 262.46 MB, 238.15 MB ThreadUsage(1s000ms): 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8 - AverageThreadTokens: 8.61 - PeakMemoryUsage: 817.77 MB (857496920) - PerHostPeakMemUsage: 1.29 GB (1381018072) - PrepareTime: 151.334us - RowsProduced: 44.15M (44154255) - TotalCpuTime: 5m25s - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3s022ms - TotalStorageWaitTime: 643.714ms DataStreamSender (dst_id=6):(Total: 37s867ms, non-child: 37s867ms, % non-child: 100.00%) - BytesSent: 2.14 GB (2301906863) - NetworkThroughput(*): 15.81 MB/sec - OverallThroughput: 57.97 MB/sec - PeakMemoryUsage: 631.95 KB (647120) - SerializeBatchTime: 25s379ms - ThriftTransmitTime(*): 2m18s - UncompressedRowBatchSize: 3.80 GB (4079414536) HDFS_SCAN_NODE (id=1):(Total: 387.560ms, non-child: 387.560ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 7:1/253.06 MB 4:1/253.08 MB 9:1/253.07 MB 0:1/253.07 MB 5:1/140.06 MB 3:1/253.09 MB 2:2/506.19 MB Hdfs Read Thread Concurrency Bucket: 0:97.4% 1:2.597% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:24 ExecOption: Codegen enabled: 0 out of 8 BytesRead(1s000ms): 367.63 MB, 735.05 MB, 735.05 MB, 735.05 MB, 735.05 MB, 735.05 MB, 735.05 MB, 743.05 MB, 799.05 MB, 799.05 MB, 799.05 MB, 799.05 MB, 799.05 MB, 859.05 MB, 863.05 MB, 874.95 MB, 926.84 MB, 926.84 MB, 962.84 MB, 982.84 MB, 986.84 MB, 1.01 GB, 1.01 GB, 1.02 GB, 1.07 GB, 1.07 GB, 1.10 GB, 1.12 GB, 1.13 GB, 1.18 GB, 1.18 GB, 1.23 GB, 1.23 GB, 1.26 GB, 1.26 GB, 1.26 GB, 1.26 GB, 1.26 GB - AverageHdfsReadThreadConcurrency: 0.03 - AverageScannerThreadConcurrency: 7.61 - BytesRead: 1.26 GB (1348681892) - BytesReadDataNodeCache: 0 - BytesReadLocal: 1.26 GB (1348681892) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 1.26 GB (1348681892) - DecompressionTime: 6s464ms - MaxCompressedTextFileLength: 0 - NumColumns: 24 (24) - NumDisksAccessed: 7 (7) - NumScannerThreadsStarted: 8 (8) - PeakMemoryUsage: 817.17 MB (856866336) - PerReadThreadRawHdfsThroughput: 987.31 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 44.64M (44635182) - RowsReturned: 44.15M (44154255) - RowsReturnedRate: 113.93 M/sec - ScanRangesComplete: 8 (8) - ScannerThreadsInvoluntaryContextSwitches: 22.24K (22239) - ScannerThreadsTotalWallClockTime: 4m50s - MaterializeTupleTime(*): 4m43s - ScannerThreadsSysTime: 730.886ms - ScannerThreadsUserTime: 46s003ms - ScannerThreadsVoluntaryContextSwitches: 43.04K (43038) - TotalRawHdfsReadTime(*): 1s302ms - TotalReadThroughput: 33.41 MB/sec Instance 1d450fc48c2dd820:5346b5ca90c9afed (host=c2136.hal.cloudera.com:22000):(Total: 38s201ms, non-child: 74.125ms, % non-child: 0.19%) Hdfs split stats (:<# splits>/): 9:1/253.08 MB 10:1/160.55 MB 1:1/253.08 MB 0:1/253.08 MB 5:1/253.08 MB 8:1/253.07 MB 4:2/506.16 MB MemoryUsage(1s000ms): 817.72 MB, 817.71 MB, 820.36 MB, 823.31 MB, 799.22 MB, 759.62 MB, 759.38 MB, 759.42 MB, 759.56 MB, 751.53 MB, 695.43 MB, 644.67 MB, 632.56 MB, 632.74 MB, 632.37 MB, 568.97 MB, 569.00 MB, 568.80 MB, 569.49 MB, 569.06 MB, 511.10 MB, 499.16 MB, 499.03 MB, 490.91 MB, 491.01 MB, 490.88 MB, 461.50 MB, 458.18 MB, 430.20 MB, 386.05 MB, 345.94 MB, 346.25 MB, 334.04 MB, 318.03 MB, 318.22 MB, 262.18 MB, 262.50 MB, 206.07 MB ThreadUsage(1s000ms): 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8 - AverageThreadTokens: 8.68 - PeakMemoryUsage: 823.80 MB (863812352) - PerHostPeakMemUsage: 1.28 GB (1373719144) - PrepareTime: 130.335us - RowsProduced: 44.63M (44628064) - TotalCpuTime: 5m27s - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3s017ms - TotalStorageWaitTime: 654.517ms DataStreamSender (dst_id=6):(Total: 37s716ms, non-child: 37s716ms, % non-child: 100.00%) - BytesSent: 2.17 GB (2327035663) - NetworkThroughput(*): 15.75 MB/sec - OverallThroughput: 58.84 MB/sec - PeakMemoryUsage: 631.95 KB (647120) - SerializeBatchTime: 25s477ms - ThriftTransmitTime(*): 2m20s - UncompressedRowBatchSize: 3.84 GB (4123192305) HDFS_SCAN_NODE (id=1):(Total: 410.285ms, non-child: 410.285ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 9:1/253.08 MB 10:1/160.55 MB 1:1/253.08 MB 0:1/253.08 MB 5:1/253.08 MB 8:1/253.07 MB 4:2/506.16 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:24 ExecOption: Codegen enabled: 0 out of 8 BytesRead(1s000ms): 739.48 MB, 739.48 MB, 739.48 MB, 739.48 MB, 739.48 MB, 739.48 MB, 739.48 MB, 779.48 MB, 803.48 MB, 803.48 MB, 803.48 MB, 803.48 MB, 843.48 MB, 867.48 MB, 875.48 MB, 931.48 MB, 931.48 MB, 971.48 MB, 995.48 MB, 1007.48 MB, 1.03 GB, 1.03 GB, 1.04 GB, 1.08 GB, 1.08 GB, 1.11 GB, 1.14 GB, 1.14 GB, 1.18 GB, 1.19 GB, 1.22 GB, 1.25 GB, 1.26 GB, 1.27 GB, 1.27 GB, 1.27 GB, 1.27 GB, 1.27 GB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 7.68 - BytesRead: 1.27 GB (1363121206) - BytesReadDataNodeCache: 0 - BytesReadLocal: 1.27 GB (1363121206) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 1.27 GB (1363121206) - DecompressionTime: 6s609ms - MaxCompressedTextFileLength: 0 - NumColumns: 24 (24) - NumDisksAccessed: 7 (7) - NumScannerThreadsStarted: 8 (8) - PeakMemoryUsage: 823.33 MB (863320920) - PerReadThreadRawHdfsThroughput: 894.26 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 45.11M (45113631) - RowsReturned: 44.63M (44628064) - RowsReturnedRate: 108.77 M/sec - ScanRangesComplete: 8 (8) - ScannerThreadsInvoluntaryContextSwitches: 21.95K (21949) - ScannerThreadsTotalWallClockTime: 4m53s - MaterializeTupleTime(*): 4m45s - ScannerThreadsSysTime: 800.873ms - ScannerThreadsUserTime: 46s872ms - ScannerThreadsVoluntaryContextSwitches: 43.52K (43519) - TotalRawHdfsReadTime(*): 1s453ms - TotalReadThroughput: 34.21 MB/sec Instance 1d450fc48c2dd820:5346b5ca90c9afe7 (host=c2120.hal.cloudera.com:22000):(Total: 37s102ms, non-child: 69.293ms, % non-child: 0.19%) Hdfs split stats (:<# splits>/): 3:1/152.76 MB 7:1/253.09 MB 2:1/174.10 MB 1:1/253.11 MB 0:1/253.08 MB 4:2/506.17 MB 6:1/253.09 MB MemoryUsage(1s000ms): 796.40 MB, 796.39 MB, 799.54 MB, 802.80 MB, 795.02 MB, 739.37 MB, 739.16 MB, 739.15 MB, 739.18 MB, 739.49 MB, 675.11 MB, 639.64 MB, 612.42 MB, 612.27 MB, 612.65 MB, 572.80 MB, 549.00 MB, 549.09 MB, 548.89 MB, 548.76 MB, 512.90 MB, 476.99 MB, 476.84 MB, 464.81 MB, 460.81 MB, 447.72 MB, 426.20 MB, 426.01 MB, 398.44 MB, 347.19 MB, 299.16 MB, 299.24 MB, 287.19 MB, 275.06 MB, 251.11 MB, 227.26 MB, 183.24 MB ThreadUsage(1s000ms): 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 8, 8, 8, 7, 7, 7, 7, 7, 7, 7, 7, 7 - AverageThreadTokens: 8.45 - PeakMemoryUsage: 803.40 MB (842422136) - PerHostPeakMemUsage: 1.26 GB (1353256608) - PrepareTime: 114.834us - RowsProduced: 42.62M (42621803) - TotalCpuTime: 5m9s - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3s049ms - TotalStorageWaitTime: 683.845ms DataStreamSender (dst_id=6):(Total: 36s677ms, non-child: 36s677ms, % non-child: 100.00%) - BytesSent: 2.07 GB (2221949634) - NetworkThroughput(*): 15.95 MB/sec - OverallThroughput: 57.77 MB/sec - PeakMemoryUsage: 631.95 KB (647120) - SerializeBatchTime: 24s660ms - ThriftTransmitTime(*): 2m12s - UncompressedRowBatchSize: 3.67 GB (3937716147) HDFS_SCAN_NODE (id=1):(Total: 355.229ms, non-child: 355.229ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 3:1/152.76 MB 7:1/253.09 MB 2:1/174.10 MB 1:1/253.11 MB 0:1/253.08 MB 4:2/506.17 MB 6:1/253.09 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:24 ExecOption: Codegen enabled: 0 out of 8 BytesRead(1s000ms): 720.71 MB, 720.71 MB, 720.71 MB, 720.71 MB, 720.71 MB, 720.71 MB, 720.71 MB, 752.71 MB, 784.71 MB, 784.71 MB, 784.71 MB, 784.71 MB, 816.71 MB, 848.71 MB, 848.71 MB, 904.71 MB, 912.71 MB, 924.71 MB, 974.30 MB, 974.30 MB, 1013.61 MB, 1.01 GB, 1.01 GB, 1.03 GB, 1.05 GB, 1.05 GB, 1.10 GB, 1.10 GB, 1.12 GB, 1.15 GB, 1.17 GB, 1.19 GB, 1.20 GB, 1.21 GB, 1.21 GB, 1.21 GB, 1.21 GB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 7.45 - BytesRead: 1.21 GB (1301971547) - BytesReadDataNodeCache: 0 - BytesReadLocal: 1.21 GB (1301971547) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 1.21 GB (1301971547) - DecompressionTime: 6s336ms - MaxCompressedTextFileLength: 0 - NumColumns: 24 (24) - NumDisksAccessed: 7 (7) - NumScannerThreadsStarted: 8 (8) - PeakMemoryUsage: 802.94 MB (841947032) - PerReadThreadRawHdfsThroughput: 958.62 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 43.09M (43085926) - RowsReturned: 42.62M (42621803) - RowsReturnedRate: 119.98 M/sec - ScanRangesComplete: 8 (8) - ScannerThreadsInvoluntaryContextSwitches: 20.45K (20452) - ScannerThreadsTotalWallClockTime: 4m35s - MaterializeTupleTime(*): 4m28s - ScannerThreadsSysTime: 834.869ms - ScannerThreadsUserTime: 45s466ms - ScannerThreadsVoluntaryContextSwitches: 41.54K (41537) - TotalRawHdfsReadTime(*): 1s295ms - TotalReadThroughput: 33.56 MB/sec Instance 1d450fc48c2dd820:5346b5ca90c9afee (host=c2134.hal.cloudera.com:22000):(Total: 34s823ms, non-child: 61.399ms, % non-child: 0.18%) Hdfs split stats (:<# splits>/): 8:1/253.08 MB 4:2/506.17 MB 6:1/253.08 MB 5:1/253.08 MB 10:1/253.09 MB 3:1/253.09 MB MemoryUsage(1s000ms): 733.52 MB, 733.53 MB, 734.83 MB, 736.30 MB, 708.75 MB, 680.87 MB, 680.62 MB, 680.92 MB, 660.65 MB, 620.87 MB, 569.80 MB, 569.72 MB, 569.74 MB, 518.11 MB, 514.07 MB, 514.16 MB, 514.12 MB, 514.13 MB, 462.13 MB, 458.18 MB, 458.31 MB, 458.17 MB, 462.20 MB, 458.00 MB, 458.05 MB, 425.97 MB, 394.21 MB, 346.21 MB, 346.05 MB, 336.29 MB, 318.27 MB, 302.12 MB, 262.18 MB, 258.13 MB, 124.91 MB ThreadUsage(1s000ms): 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 4 - AverageThreadTokens: 7.90 - PeakMemoryUsage: 737.07 MB (772877592) - PerHostPeakMemUsage: 1.20 GB (1285635640) - PrepareTime: 134.742us - RowsProduced: 40.92M (40920525) - TotalCpuTime: 4m34s - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3s079ms - TotalStorageWaitTime: 507.682ms DataStreamSender (dst_id=6):(Total: 34s423ms, non-child: 34s423ms, % non-child: 100.00%) - BytesSent: 1.99 GB (2133257260) - NetworkThroughput(*): 15.65 MB/sec - OverallThroughput: 59.10 MB/sec - PeakMemoryUsage: 631.95 KB (647120) - SerializeBatchTime: 23s075ms - ThriftTransmitTime(*): 2m10s - UncompressedRowBatchSize: 3.52 GB (3780728428) HDFS_SCAN_NODE (id=1):(Total: 338.595ms, non-child: 338.595ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 8:1/253.08 MB 4:2/506.17 MB 6:1/253.08 MB 5:1/253.08 MB 10:1/253.09 MB 3:1/253.09 MB Hdfs Read Thread Concurrency Bucket: 0:97.14% 1:2.857% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:21 ExecOption: Codegen enabled: 0 out of 7 BytesRead(1s000ms): 664.56 MB, 664.56 MB, 664.56 MB, 664.56 MB, 664.56 MB, 664.56 MB, 684.56 MB, 720.56 MB, 720.56 MB, 720.56 MB, 724.56 MB, 776.56 MB, 776.56 MB, 832.56 MB, 832.56 MB, 860.56 MB, 888.56 MB, 904.56 MB, 944.56 MB, 944.56 MB, 996.56 MB, 1000.56 MB, 1.00 GB, 1.03 GB, 1.04 GB, 1.09 GB, 1.09 GB, 1.11 GB, 1.14 GB, 1.15 GB, 1.16 GB, 1.16 GB, 1.16 GB, 1.16 GB, 1.16 GB - AverageHdfsReadThreadConcurrency: 0.03 - AverageScannerThreadConcurrency: 6.90 - BytesRead: 1.16 GB (1249867809) - BytesReadDataNodeCache: 0 - BytesReadLocal: 1.16 GB (1249867809) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 1.16 GB (1249867809) - DecompressionTime: 5s934ms - MaxCompressedTextFileLength: 0 - NumColumns: 21 (21) - NumDisksAccessed: 6 (6) - NumScannerThreadsStarted: 7 (7) - PeakMemoryUsage: 736.57 MB (772345160) - PerReadThreadRawHdfsThroughput: 1020.09 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 41.37M (41367291) - RowsReturned: 40.92M (40920525) - RowsReturnedRate: 120.85 M/sec - ScanRangesComplete: 7 (7) - ScannerThreadsInvoluntaryContextSwitches: 18.05K (18053) - ScannerThreadsTotalWallClockTime: 4m3s - MaterializeTupleTime(*): 3m56s - ScannerThreadsSysTime: 463.926ms - ScannerThreadsUserTime: 42s919ms - ScannerThreadsVoluntaryContextSwitches: 39.89K (39887) - TotalRawHdfsReadTime(*): 1s168ms - TotalReadThroughput: 34.06 MB/sec Instance 1d450fc48c2dd820:5346b5ca90c9afe9 (host=c2126.hal.cloudera.com:22000):(Total: 34s167ms, non-child: 57.727ms, % non-child: 0.17%) Hdfs split stats (:<# splits>/): 9:1/253.10 MB 1:1/253.10 MB 6:1/253.10 MB 4:1/253.08 MB 2:1/253.07 MB 3:1/253.09 MB 7:1/253.07 MB MemoryUsage(1s000ms): 732.82 MB, 732.82 MB, 734.58 MB, 736.65 MB, 704.70 MB, 680.82 MB, 680.67 MB, 680.71 MB, 680.96 MB, 624.67 MB, 577.69 MB, 574.01 MB, 569.56 MB, 541.86 MB, 514.14 MB, 514.26 MB, 513.93 MB, 494.33 MB, 458.14 MB, 458.30 MB, 458.29 MB, 458.28 MB, 458.10 MB, 458.36 MB, 454.29 MB, 402.38 MB, 346.11 MB, 346.31 MB, 346.08 MB, 318.25 MB, 318.34 MB, 262.27 MB, 262.13 MB, 194.11 MB ThreadUsage(1s000ms): 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8 - AverageThreadTokens: 8.00 - PeakMemoryUsage: 737.06 MB (772865072) - PerHostPeakMemUsage: 1.20 GB (1285124280) - PrepareTime: 126.879us - RowsProduced: 40.92M (40922024) - TotalCpuTime: 4m29s - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3s090ms - TotalStorageWaitTime: 497.96ms DataStreamSender (dst_id=6):(Total: 33s804ms, non-child: 33s804ms, % non-child: 100.00%) - BytesSent: 1.99 GB (2133351614) - NetworkThroughput(*): 15.80 MB/sec - OverallThroughput: 60.18 MB/sec - PeakMemoryUsage: 631.95 KB (647120) - SerializeBatchTime: 22s695ms - ThriftTransmitTime(*): 2m8s - UncompressedRowBatchSize: 3.52 GB (3780943891) HDFS_SCAN_NODE (id=1):(Total: 305.469ms, non-child: 305.469ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 9:1/253.10 MB 1:1/253.10 MB 6:1/253.10 MB 4:1/253.08 MB 2:1/253.07 MB 3:1/253.09 MB 7:1/253.07 MB Hdfs Read Thread Concurrency Bucket: 0:97.06% 1:2.941% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% File Formats: PARQUET/SNAPPY:21 ExecOption: Codegen enabled: 0 out of 7 BytesRead(1s000ms): 664.56 MB, 664.56 MB, 664.56 MB, 664.56 MB, 664.56 MB, 664.56 MB, 672.56 MB, 720.56 MB, 720.56 MB, 720.56 MB, 720.56 MB, 768.56 MB, 776.56 MB, 808.56 MB, 832.56 MB, 860.56 MB, 888.56 MB, 916.56 MB, 944.56 MB, 972.56 MB, 1000.56 MB, 1004.56 MB, 1.03 GB, 1.03 GB, 1.06 GB, 1.09 GB, 1.11 GB, 1.14 GB, 1.14 GB, 1.16 GB, 1.16 GB, 1.16 GB, 1.16 GB, 1.16 GB - AverageHdfsReadThreadConcurrency: 0.03 - AverageScannerThreadConcurrency: 7.00 - BytesRead: 1.16 GB (1249904668) - BytesReadDataNodeCache: 0 - BytesReadLocal: 1.16 GB (1249904668) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 1.16 GB (1249904668) - DecompressionTime: 5s819ms - MaxCompressedTextFileLength: 0 - NumColumns: 21 (21) - NumDisksAccessed: 7 (7) - NumScannerThreadsStarted: 7 (7) - PeakMemoryUsage: 736.57 MB (772348688) - PerReadThreadRawHdfsThroughput: 921.74 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 41.37M (41367567) - RowsReturned: 40.92M (40922024) - RowsReturnedRate: 133.96 M/sec - ScanRangesComplete: 7 (7) - ScannerThreadsInvoluntaryContextSwitches: 18.31K (18314) - ScannerThreadsTotalWallClockTime: 3m58s - MaterializeTupleTime(*): 3m52s - ScannerThreadsSysTime: 604.905ms - ScannerThreadsUserTime: 42s337ms - ScannerThreadsVoluntaryContextSwitches: 39.85K (39853) - TotalRawHdfsReadTime(*): 1s293ms - TotalReadThroughput: 35.06 MB/sec