Query (id=9448ec37dcef4482:1b1f6848414313be): Summary: Session ID: 8647417c4c86ed5a:1cfbca8d115d9f8e Session Type: BEESWAX Start Time: 2015-01-27 11:36:21.582241000 End Time: Query Type: QUERY Query State: CREATED Query Status: OK Impala Version: impalad version 2.1.0-cdh5 RELEASE (build e48c2b48c53ea9601b8f47a39373aa83ff7ca6e2) User: dkumar Connected User: dkumar Delegated User: Network Address: 10.20.122.101:52711 Default Db: tpcds_15000_decimal_parquet Sql Statement: select distinct ca_country from customer_address, customer where c_birth_country = upper(ca_country) Coordinator: d2401.halxg.cloudera.com:22000 Plan: ---------------- Estimated Per-Host Requirements: Memory=50.79MB VCores=2 F04:PLAN FRAGMENT [UNPARTITIONED] 08:EXCHANGE [UNPARTITIONED] hosts=21 per-host-mem=unavailable tuple-ids=2 row-size=29B cardinality=1 F03:PLAN FRAGMENT [HASH(ca_country)] DATASTREAM SINK [FRAGMENT=F04, EXCHANGE=08, UNPARTITIONED] 07:AGGREGATE [FINALIZE] | group by: ca_country | hosts=21 per-host-mem=10.00MB | tuple-ids=2 row-size=29B cardinality=1 | 06:EXCHANGE [HASH(ca_country)] hosts=21 per-host-mem=0B tuple-ids=2 row-size=29B cardinality=1 F02:PLAN FRAGMENT [HASH(c_birth_country)] DATASTREAM SINK [FRAGMENT=F03, EXCHANGE=06, HASH(ca_country)] 03:AGGREGATE | group by: ca_country | hosts=21 per-host-mem=10.00MB | tuple-ids=2 row-size=29B cardinality=1 | 02:HASH JOIN [INNER JOIN, PARTITIONED] | hash predicates: c_birth_country = upper(ca_country) | hosts=21 per-host-mem=2.79MB | tuple-ids=1,0 row-size=54B cardinality=3850000 | |--05:EXCHANGE [HASH(upper(ca_country))] | hosts=21 per-host-mem=0B | tuple-ids=0 row-size=29B cardinality=1925000 | 04:EXCHANGE [HASH(c_birth_country)] hosts=21 per-host-mem=0B tuple-ids=1 row-size=25B cardinality=3850000 F01:PLAN FRAGMENT [RANDOM] DATASTREAM SINK [FRAGMENT=F02, EXCHANGE=05, HASH(upper(ca_country))] 00:SCAN HDFS [tpcds_15000_decimal_parquet.customer_address, RANDOM] partitions=1/1 files=21 size=208.55MB table stats: 1925000 rows total column stats: all hosts=21 per-host-mem=48.00MB tuple-ids=0 row-size=29B cardinality=1925000 F00:PLAN FRAGMENT [RANDOM] DATASTREAM SINK [FRAGMENT=F02, EXCHANGE=04, HASH(c_birth_country)] 01:SCAN HDFS [tpcds_15000_decimal_parquet.customer, RANDOM] partitions=1/1 files=21 size=214.42MB table stats: 3850000 rows total column stats: all hosts=21 per-host-mem=24.00MB tuple-ids=1 row-size=25B cardinality=3850000 ---------------- Estimated Per-Host Mem: 53255814 Estimated Per-Host VCores: 2 Request Pool: default-pool Query Timeline: 9m47s - Start execution: 61.579us (61.579us) - Planning finished: 8.8ms (7.946ms) - Ready to start remote fragments: 9.74ms (1.66ms) - Remote fragments started: 1s079ms (1s070ms) ImpalaServer: - ClientFetchWaitTimer: 0ns - RowMaterializationTimer: 0ns Execution Profile 9448ec37dcef4482:1b1f6848414313be:(Total: 1s071ms, non-child: 0ns, % non-child: 0.00%) Fragment start latencies: count: 71, last: 0.00461968, min: 0.00245262, max: 0.361522, mean: 0.138082, stddev: 0.0863525 - FinalizationTimer: 0ns Coordinator Fragment F04:(Total: 240.572us, non-child: 0ns, % non-child: 0.00%) MemoryUsage(16s000ms): 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 ThreadUsage(500.0ms): 1, 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 8.00 KB (8192) - PerHostPeakMemUsage: 0 - PrepareTime: 30.329us - RowsProduced: 0 - TotalCpuTime: 0ns - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 0ns - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 256 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 6871947776.00 GB (7378697739434983424) - PeakMemoryUsage: 512.00 KB (524288) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns EXCHANGE_NODE (id=8): BytesReceived(16s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 0ns - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Averaged Fragment F03:(Total: 185.232ms, non-child: 0ns, % non-child: 0.00%) split sizes: min: 0, max: 0, avg: 0, stddev: 0 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 6.26 MB (6567248) - PerHostPeakMemUsage: 74.47 MB (78087893) - PrepareTime: 184.786ms - RowsProduced: 0 - TotalCpuTime: 0ns - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 0ns - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 260 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 808464534.59 GB (868082184008082853) - PeakMemoryUsage: 39.09 MB (40986985) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 415.260ms, non-child: 415.260ms, % non-child: 100.00%) - CodegenTime: 2.219ms - CompileTime: 31.338ms - LoadTime: 84.552us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 202.92ms - PrepareTime: 180.183ms DataStreamSender (dst_id=8):(Total: 18.412us, non-child: 18.412us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 5.33 KB (5456) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=7):(Total: 184.785ms, non-child: 184.785ms, % non-child: 100.00%) - BuildTime: 0ns - GetNewBlockTime: 284.383us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 6.25 MB (6553600) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.969us EXCHANGE_NODE (id=6): - BytesReceived: 0 - ConvertRowBatchTime: 0ns - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Averaged Fragment F02:(Total: 706.42ms, non-child: 0ns, % non-child: 0.00%) split sizes: min: 0, max: 0, avg: 0, stddev: 0 - AverageThreadTokens: 1.45 - PeakMemoryUsage: 50.98 MB (53452637) - PerHostPeakMemUsage: 74.47 MB (78087893) - PrepareTime: 181.518ms - RowsProduced: 0 - TotalCpuTime: 877.777ms - TotalNetworkReceiveTime: 737.778ms - TotalNetworkSendTime: 3.912us - TotalStorageWaitTime: 0ns CodeGen:(Total: 515.926ms, non-child: 515.926ms, % non-child: 100.00%) - CodegenTime: 2.20ms - CompileTime: 83.118ms - LoadTime: 62.790us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 259.15ms - PrepareTime: 172.169ms DataStreamSender (dst_id=6):(Total: 36.69us, non-child: 36.69us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 95.91 KB (98208) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=3):(Total: 702.915ms, non-child: 0ns, % non-child: 0.00%) - BuildTime: 9s276ms - GetNewBlockTime: 282.287us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 8.23 MB (8625017) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.880us HASH_JOIN_NODE (id=2):(Total: 23s584ms, non-child: 22s840ms, % non-child: 96.85%) - BuildPartitionTime: 16.526ms - BuildRows: 106.94K (106944) - BuildRowsPartitioned: 106.94K (106944) - BuildTime: 15.777ms - GetNewBlockTime: 1.103ms - HashBuckets: 233.02K (233016) - LargestPartitionPercent: 5 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 36.05 MB (37802585) - PinTime: 0ns - ProbeRows: 199.54K (199543) - ProbeRowsPartitioned: 0 - ProbeTime: 22s101ms - RowsReturned: 251.80M (251801271) - RowsReturnedRate: 606.64 K/sec - SpilledPartitions: 0 - UnpinTime: 1.938us EXCHANGE_NODE (id=5):(Total: 525.657ms, non-child: 525.657ms, % non-child: 100.00%) - BytesReceived: 1.15 MB (1211026) - ConvertRowBatchTime: 1.938ms - DeserializeRowBatchTimer: 7.919ms - FirstBatchArrivalWaitTime: 498.216ms - PeakMemoryUsage: 0 - RowsReturned: 106.94K (106944) - RowsReturnedRate: 339.69 K/sec - SendersBlockedTimer: 6.393ms - SendersBlockedTotalTimer(*): 63.775ms EXCHANGE_NODE (id=4):(Total: 218.360ms, non-child: 218.360ms, % non-child: 100.00%) - BytesReceived: 2.75 MB (2886370) - ConvertRowBatchTime: 3.592ms - DeserializeRowBatchTimer: 15.783ms - FirstBatchArrivalWaitTime: 213.992ms - PeakMemoryUsage: 0 - RowsReturned: 199.54K (199543) - RowsReturnedRate: 2.10 M/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Averaged Fragment F01:(Total: 368.10ms, non-child: 0ns, % non-child: 0.00%) split sizes: min: 9.92 MB, max: 19.87 MB, avg: 12.27 MB, stddev: 4.21 MB - AverageThreadTokens: 1.00 - PeakMemoryUsage: 15.71 MB (16470620) - PerHostPeakMemUsage: 67.82 MB (71110273) - PrepareTime: 176.442ms - RowsProduced: 113.23K (113235) - TotalCpuTime: 394.410ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 147.673ms - TotalStorageWaitTime: 7.897ms CodeGen:(Total: 322.360ms, non-child: 322.360ms, % non-child: 100.00%) - CodegenTime: 702.281us - CompileTime: 4.595ms - LoadTime: 85.862us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 142.32ms - PrepareTime: 174.78ms DataStreamSender (dst_id=5):(Total: 182.475ms, non-child: 182.475ms, % non-child: 100.00%) - BytesSent: 1.22 MB (1282263) - NetworkThroughput(*): 8.60 MB/sec - OverallThroughput: 7.25 MB/sec - PeakMemoryUsage: 187.84 KB (192352) - SerializeBatchTime: 9.773ms - ThriftTransmitTime(*): 170.163ms - UncompressedRowBatchSize: 4.39 MB (4599203) HDFS_SCAN_NODE (id=0):(Total: 182.326ms, non-child: 182.326ms, % non-child: 100.00%) - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 12.27 MB (12863681) - BytesReadDataNodeCache: 0 - BytesReadLocal: 12.27 MB (12863681) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 12.27 MB (12863681) - DecompressionTime: 0ns - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 15.51 MB (16261059) - PerReadThreadRawHdfsThroughput: 2.35 GB/sec - RemoteScanRanges: 0 - RowsRead: 113.23K (113235) - RowsReturned: 113.23K (113235) - RowsReturnedRate: 643.73 K/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 29.788ms - DelimiterParseTime: 18.619ms - MaterializeTupleTime(*): 1.583ms - ScannerThreadsSysTime: 822.823us - ScannerThreadsUserTime: 19.819ms - ScannerThreadsVoluntaryContextSwitches: 5 - TotalRawHdfsReadTime(*): 5.152ms - TotalReadThroughput: 9.35 MB/sec BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 0 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 6871947776.00 GB (7378697739434983424) - PeakMemoryUsage: 0 - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns Averaged Fragment F00:(Total: 66.106ms, non-child: 2.761ms, % non-child: 4.18%) split sizes: min: 10.20 MB, max: 20.42 MB, avg: 11.91 MB, stddev: 3.80 MB - AverageThreadTokens: 0.28 - PeakMemoryUsage: 5.93 MB (6223140) - PerHostPeakMemUsage: 64.64 MB (67783925) - PrepareTime: 89.488us - RowsProduced: 213.89K (213888) - TotalCpuTime: 92.785ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3.265ms - TotalStorageWaitTime: 3.96ms DataStreamSender (dst_id=4):(Total: 59.259ms, non-child: 59.259ms, % non-child: 100.00%) - BytesSent: 2.75 MB (2886370) - NetworkThroughput(*): 37.01 MB/sec - OverallThroughput: 48.18 MB/sec - PeakMemoryUsage: 655.95 KB (671694) - SerializeBatchTime: 26.142ms - ThriftTransmitTime(*): 73.586ms - UncompressedRowBatchSize: 7.43 MB (7788031) HDFS_SCAN_NODE (id=1):(Total: 4.85ms, non-child: 4.85ms, % non-child: 100.00%) - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.11 - BytesRead: 335.48 KB (343533) - BytesReadDataNodeCache: 0 - BytesReadLocal: 335.48 KB (343533) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 335.48 KB (343533) - DecompressionTime: 158.462us - MaxCompressedTextFileLength: 0 - NumColumns: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 5.37 MB (5630368) - PerReadThreadRawHdfsThroughput: 751.52 MB/sec - RemoteScanRanges: 0 - RowsRead: 213.89K (213888) - RowsReturned: 213.89K (213888) - RowsReturnedRate: 52.59 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 1 - ScannerThreadsTotalWallClockTime: 25.445ms - MaterializeTupleTime(*): 21.396ms - ScannerThreadsSysTime: 4.221ms - ScannerThreadsUserTime: 11.719ms - ScannerThreadsVoluntaryContextSwitches: 18 - TotalRawHdfsReadTime(*): 443.585us - TotalReadThroughput: 95.82 KB/sec Fragment F03: Instance 9448ec37dcef4482:1b1f6848414313c1 (host=d2413.halxg.cloudera.com:22000):(Total: 176.894ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(16s000ms): 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB ThreadUsage(16s000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 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: 6.26 MB (6567248) - PerHostPeakMemUsage: 38.32 MB (40179976) - PrepareTime: 176.455ms - RowsProduced: 0 - TotalCpuTime: 0ns - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 0ns - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 256 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 6871947776.00 GB (7378697739434983424) - PeakMemoryUsage: 512.00 KB (524288) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 392.974ms, non-child: 392.974ms, % non-child: 100.00%) - CodegenTime: 2.62ms - CompileTime: 29.300ms - LoadTime: 62.346us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 189.979ms - PrepareTime: 172.101ms DataStreamSender (dst_id=8):(Total: 18.689us, non-child: 18.689us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 5.33 KB (5456) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=7):(Total: 176.454ms, non-child: 176.454ms, % non-child: 100.00%) ExecOption: Codegen Enabled - BuildTime: 0ns - GetNewBlockTime: 274.305us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 6.25 MB (6553600) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.668us EXCHANGE_NODE (id=6): BytesReceived(16s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 0ns - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313c4 (host=d2401.halxg.cloudera.com:22000):(Total: 177.161ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(16s000ms): 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB ThreadUsage(16s000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 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: 6.26 MB (6567248) - PerHostPeakMemUsage: 38.17 MB (40019480) - PrepareTime: 176.645ms - RowsProduced: 0 - TotalCpuTime: 0ns - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 0ns - TotalStorageWaitTime: 0ns CodeGen:(Total: 400.490ms, non-child: 400.490ms, % non-child: 100.00%) - CodegenTime: 2.300ms - CompileTime: 30.988ms - LoadTime: 127.543us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 195.917ms - PrepareTime: 171.949ms DataStreamSender (dst_id=8):(Total: 15.639us, non-child: 15.639us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 5.33 KB (5456) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=7):(Total: 176.643ms, non-child: 176.643ms, % non-child: 100.00%) ExecOption: Codegen Enabled - BuildTime: 0ns - GetNewBlockTime: 282.467us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 6.25 MB (6553600) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 2.191us EXCHANGE_NODE (id=6): BytesReceived(16s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 0ns - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313cc (host=d2412.halxg.cloudera.com:22000):(Total: 175.984ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(16s000ms): 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB ThreadUsage(16s000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 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: 6.26 MB (6567248) - PerHostPeakMemUsage: 43.73 MB (45853696) - PrepareTime: 175.569ms - RowsProduced: 0 - TotalCpuTime: 0ns - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 0ns - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 256 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 6871947776.00 GB (7378697739434983424) - PeakMemoryUsage: 512.00 KB (524288) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 394.900ms, non-child: 394.900ms, % non-child: 100.00%) - CodegenTime: 2.97ms - CompileTime: 29.952ms - LoadTime: 72.141us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 192.168ms - PrepareTime: 171.216ms DataStreamSender (dst_id=8):(Total: 19.461us, non-child: 19.461us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 5.33 KB (5456) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=7):(Total: 175.568ms, non-child: 175.568ms, % non-child: 100.00%) ExecOption: Codegen Enabled - BuildTime: 0ns - GetNewBlockTime: 269.625us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 6.25 MB (6553600) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.698us EXCHANGE_NODE (id=6): BytesReceived(16s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 0ns - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313d1 (host=d2414.halxg.cloudera.com:22000):(Total: 175.971ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(16s000ms): 6.07 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB ThreadUsage(16s000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 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: 6.26 MB (6567248) - PerHostPeakMemUsage: 32.67 MB (34252816) - PrepareTime: 175.550ms - RowsProduced: 0 - TotalCpuTime: 0ns - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 0ns - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 256 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 6871947776.00 GB (7378697739434983424) - PeakMemoryUsage: 512.00 KB (524288) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 392.318ms, non-child: 392.318ms, % non-child: 100.00%) - CodegenTime: 2.74ms - CompileTime: 29.289ms - LoadTime: 63.306us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 190.239ms - PrepareTime: 171.256ms DataStreamSender (dst_id=8):(Total: 18.138us, non-child: 18.138us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 5.33 KB (5456) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=7):(Total: 175.548ms, non-child: 175.548ms, % non-child: 100.00%) ExecOption: Codegen Enabled - BuildTime: 0ns - GetNewBlockTime: 267.31us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 6.25 MB (6553600) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.953us EXCHANGE_NODE (id=6): BytesReceived(16s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 0ns - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313c6 (host=d2417.halxg.cloudera.com:22000):(Total: 177.559ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(16s000ms): 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB ThreadUsage(16s000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 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: 6.26 MB (6567248) - PerHostPeakMemUsage: 748.11 MB (784445952) - PrepareTime: 177.129ms - RowsProduced: 0 - TotalCpuTime: 0ns - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 0ns - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 329 - BlocksRecycled: 8 - BufferedPins: 0 - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 6871947776.00 GB (7378697739434983424) - PeakMemoryUsage: 656.50 MB (688390144) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 395.70ms, non-child: 395.70ms, % non-child: 100.00%) - CodegenTime: 2.97ms - CompileTime: 29.158ms - LoadTime: 66.394us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 191.565ms - PrepareTime: 172.780ms DataStreamSender (dst_id=8):(Total: 18.271us, non-child: 18.271us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 5.33 KB (5456) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=7):(Total: 177.127ms, non-child: 177.127ms, % non-child: 100.00%) ExecOption: Codegen Enabled - BuildTime: 0ns - GetNewBlockTime: 265.177us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 6.25 MB (6553600) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.699us EXCHANGE_NODE (id=6): BytesReceived(16s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 0ns - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313c7 (host=d2402.halxg.cloudera.com:22000):(Total: 173.927ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(16s000ms): 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB ThreadUsage(16s000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 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: 6.26 MB (6567248) - PerHostPeakMemUsage: 30.83 MB (32327800) - PrepareTime: 173.524ms - RowsProduced: 0 - TotalCpuTime: 0ns - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 0ns - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 256 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 6871947776.00 GB (7378697739434983424) - PeakMemoryUsage: 512.00 KB (524288) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 391.460ms, non-child: 391.460ms, % non-child: 100.00%) - CodegenTime: 2.133ms - CompileTime: 29.371ms - LoadTime: 90.55us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 191.403ms - PrepareTime: 169.51ms DataStreamSender (dst_id=8):(Total: 16.467us, non-child: 16.467us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 5.33 KB (5456) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=7):(Total: 173.523ms, non-child: 173.523ms, % non-child: 100.00%) ExecOption: Codegen Enabled - BuildTime: 0ns - GetNewBlockTime: 264.683us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 6.25 MB (6553600) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.655us EXCHANGE_NODE (id=6): BytesReceived(16s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 0ns - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313c5 (host=d2411.halxg.cloudera.com:22000):(Total: 174.666ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(16s000ms): 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB ThreadUsage(16s000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 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: 6.26 MB (6567248) - PerHostPeakMemUsage: 30.63 MB (32121536) - PrepareTime: 174.257ms - RowsProduced: 0 - TotalCpuTime: 0ns - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 0ns - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 256 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 6871947776.00 GB (7378697739434983424) - PeakMemoryUsage: 512.00 KB (524288) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 390.418ms, non-child: 390.418ms, % non-child: 100.00%) - CodegenTime: 2.90ms - CompileTime: 29.253ms - LoadTime: 63.952us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 189.693ms - PrepareTime: 169.940ms DataStreamSender (dst_id=8):(Total: 16.137us, non-child: 16.137us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 5.33 KB (5456) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=7):(Total: 174.255ms, non-child: 174.255ms, % non-child: 100.00%) ExecOption: Codegen Enabled - BuildTime: 0ns - GetNewBlockTime: 272.77us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 6.25 MB (6553600) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.691us EXCHANGE_NODE (id=6): BytesReceived(16s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 0ns - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313c3 (host=d2419.halxg.cloudera.com:22000):(Total: 175.964ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(16s000ms): 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB ThreadUsage(16s000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 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: 6.26 MB (6567248) - PerHostPeakMemUsage: 38.12 MB (39974136) - PrepareTime: 175.547ms - RowsProduced: 0 - TotalCpuTime: 0ns - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 0ns - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 256 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 6871947776.00 GB (7378697739434983424) - PeakMemoryUsage: 512.00 KB (524288) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 391.693ms, non-child: 391.693ms, % non-child: 100.00%) - CodegenTime: 2.52ms - CompileTime: 29.766ms - LoadTime: 62.747us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 189.150ms - PrepareTime: 171.211ms DataStreamSender (dst_id=8):(Total: 16.386us, non-child: 16.386us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 5.33 KB (5456) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=7):(Total: 175.546ms, non-child: 175.546ms, % non-child: 100.00%) ExecOption: Codegen Enabled - BuildTime: 0ns - GetNewBlockTime: 270.743us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 6.25 MB (6553600) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.671us EXCHANGE_NODE (id=6): BytesReceived(16s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 0ns - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313c8 (host=d2403.halxg.cloudera.com:22000):(Total: 170.257ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(16s000ms): 6.07 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB ThreadUsage(16s000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 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: 6.26 MB (6567248) - PerHostPeakMemUsage: 43.53 MB (45641104) - PrepareTime: 169.810ms - RowsProduced: 0 - TotalCpuTime: 0ns - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 0ns - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 256 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 6871947776.00 GB (7378697739434983424) - PeakMemoryUsage: 512.00 KB (524288) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 386.540ms, non-child: 386.540ms, % non-child: 100.00%) - CodegenTime: 2.29ms - CompileTime: 29.162ms - LoadTime: 79.444us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 190.305ms - PrepareTime: 165.446ms DataStreamSender (dst_id=8):(Total: 17.748us, non-child: 17.748us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 5.33 KB (5456) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=7):(Total: 169.809ms, non-child: 169.809ms, % non-child: 100.00%) ExecOption: Codegen Enabled - BuildTime: 0ns - GetNewBlockTime: 266.78us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 6.25 MB (6553600) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.716us EXCHANGE_NODE (id=6): BytesReceived(16s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 0ns - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313c9 (host=d2408.halxg.cloudera.com:22000):(Total: 173.115ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(16s000ms): 6.07 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB ThreadUsage(16s000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 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: 6.26 MB (6567248) - PerHostPeakMemUsage: 23.55 MB (24696232) - PrepareTime: 172.636ms - RowsProduced: 0 - TotalCpuTime: 0ns - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 0ns - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 256 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 6871947776.00 GB (7378697739434983424) - PeakMemoryUsage: 512.00 KB (524288) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 389.642ms, non-child: 389.642ms, % non-child: 100.00%) - CodegenTime: 2.113ms - CompileTime: 29.501ms - LoadTime: 74.344us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 190.317ms - PrepareTime: 168.340ms DataStreamSender (dst_id=8):(Total: 16.625us, non-child: 16.625us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 5.33 KB (5456) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=7):(Total: 172.635ms, non-child: 172.635ms, % non-child: 100.00%) ExecOption: Codegen Enabled - BuildTime: 0ns - GetNewBlockTime: 261.622us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 6.25 MB (6553600) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.905us EXCHANGE_NODE (id=6): BytesReceived(16s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 0ns - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313c2 (host=d2409.halxg.cloudera.com:22000):(Total: 175.737ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(16s000ms): 6.07 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB ThreadUsage(16s000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 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: 6.26 MB (6567248) - PerHostPeakMemUsage: 30.87 MB (32368808) - PrepareTime: 175.324ms - RowsProduced: 0 - TotalCpuTime: 0ns - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 0ns - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 256 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 6871947776.00 GB (7378697739434983424) - PeakMemoryUsage: 512.00 KB (524288) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 391.736ms, non-child: 391.736ms, % non-child: 100.00%) - CodegenTime: 2.108ms - CompileTime: 29.504ms - LoadTime: 81.841us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 189.713ms - PrepareTime: 170.902ms DataStreamSender (dst_id=8):(Total: 17.998us, non-child: 17.998us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 5.33 KB (5456) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=7):(Total: 175.323ms, non-child: 175.323ms, % non-child: 100.00%) ExecOption: Codegen Enabled - BuildTime: 0ns - GetNewBlockTime: 277.953us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 6.25 MB (6553600) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.718us EXCHANGE_NODE (id=6): BytesReceived(16s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 0ns - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313cf (host=d2404.halxg.cloudera.com:22000):(Total: 178.415ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(16s000ms): 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB ThreadUsage(16s000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 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: 6.26 MB (6567248) - PerHostPeakMemUsage: 43.90 MB (46029880) - PrepareTime: 177.982ms - RowsProduced: 0 - TotalCpuTime: 0ns - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 0ns - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 256 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 6871947776.00 GB (7378697739434983424) - PeakMemoryUsage: 512.00 KB (524288) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 405.947ms, non-child: 405.947ms, % non-child: 100.00%) - CodegenTime: 2.78ms - CompileTime: 30.25ms - LoadTime: 104.605us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 200.727ms - PrepareTime: 173.602ms DataStreamSender (dst_id=8):(Total: 15.684us, non-child: 15.684us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 5.33 KB (5456) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=7):(Total: 177.981ms, non-child: 177.981ms, % non-child: 100.00%) ExecOption: Codegen Enabled - BuildTime: 0ns - GetNewBlockTime: 285.145us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 6.25 MB (6553600) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 2.107us EXCHANGE_NODE (id=6): BytesReceived(16s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 0ns - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313c0 (host=d2406.halxg.cloudera.com:22000):(Total: 176.659ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(16s000ms): 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB ThreadUsage(16s000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 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: 6.26 MB (6567248) - PerHostPeakMemUsage: 31.13 MB (32640864) - PrepareTime: 176.241ms - RowsProduced: 0 - TotalCpuTime: 0ns - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 0ns - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 256 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 6871947776.00 GB (7378697739434983424) - PeakMemoryUsage: 512.00 KB (524288) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 392.843ms, non-child: 392.843ms, % non-child: 100.00%) - CodegenTime: 2.68ms - CompileTime: 29.835ms - LoadTime: 66.242us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 189.651ms - PrepareTime: 171.792ms DataStreamSender (dst_id=8):(Total: 19.145us, non-child: 19.145us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 5.33 KB (5456) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=7):(Total: 176.240ms, non-child: 176.240ms, % non-child: 100.00%) ExecOption: Codegen Enabled - BuildTime: 0ns - GetNewBlockTime: 324.371us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 6.25 MB (6553600) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 2.559us EXCHANGE_NODE (id=6): BytesReceived(16s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 0ns - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313cb (host=d2407.halxg.cloudera.com:22000):(Total: 176.552ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(16s000ms): 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB ThreadUsage(16s000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 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: 6.26 MB (6567248) - PerHostPeakMemUsage: 31.30 MB (32821984) - PrepareTime: 176.159ms - RowsProduced: 0 - TotalCpuTime: 0ns - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 0ns - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 256 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 6871947776.00 GB (7378697739434983424) - PeakMemoryUsage: 512.00 KB (524288) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 391.425ms, non-child: 391.425ms, % non-child: 100.00%) - CodegenTime: 2.227ms - CompileTime: 29.256ms - LoadTime: 87.538us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 188.942ms - PrepareTime: 171.686ms DataStreamSender (dst_id=8):(Total: 16.468us, non-child: 16.468us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 5.33 KB (5456) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=7):(Total: 176.157ms, non-child: 176.157ms, % non-child: 100.00%) ExecOption: Codegen Enabled - BuildTime: 0ns - GetNewBlockTime: 267.630us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 6.25 MB (6553600) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 2.213us EXCHANGE_NODE (id=6): BytesReceived(16s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 0ns - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313ca (host=d2415.halxg.cloudera.com:22000):(Total: 177.189ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(16s000ms): 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB ThreadUsage(16s000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 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: 6.26 MB (6567248) - PerHostPeakMemUsage: 26.80 MB (28102960) - PrepareTime: 176.696ms - RowsProduced: 0 - TotalCpuTime: 0ns - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 0ns - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 256 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 6871947776.00 GB (7378697739434983424) - PeakMemoryUsage: 512.00 KB (524288) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 391.197ms, non-child: 391.197ms, % non-child: 100.00%) - CodegenTime: 2.151ms - CompileTime: 29.500ms - LoadTime: 66.583us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 187.884ms - PrepareTime: 172.302ms DataStreamSender (dst_id=8):(Total: 16.44us, non-child: 16.44us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 5.33 KB (5456) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=7):(Total: 176.694ms, non-child: 176.694ms, % non-child: 100.00%) ExecOption: Codegen Enabled - BuildTime: 0ns - GetNewBlockTime: 276.991us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 6.25 MB (6553600) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.682us EXCHANGE_NODE (id=6): BytesReceived(16s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 0ns - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313cd (host=d2410.halxg.cloudera.com:22000):(Total: 177.512ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(16s000ms): 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB ThreadUsage(16s000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 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: 6.26 MB (6567248) - PerHostPeakMemUsage: 33.65 MB (35282472) - PrepareTime: 177.99ms - RowsProduced: 0 - TotalCpuTime: 0ns - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 0ns - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 256 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 6871947776.00 GB (7378697739434983424) - PeakMemoryUsage: 512.00 KB (524288) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 392.679ms, non-child: 392.679ms, % non-child: 100.00%) - CodegenTime: 2.116ms - CompileTime: 29.431ms - LoadTime: 105.589us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 188.964ms - PrepareTime: 172.653ms DataStreamSender (dst_id=8):(Total: 18.161us, non-child: 18.161us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 5.33 KB (5456) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=7):(Total: 177.98ms, non-child: 177.98ms, % non-child: 100.00%) ExecOption: Codegen Enabled - BuildTime: 0ns - GetNewBlockTime: 267.394us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 6.25 MB (6553600) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.816us EXCHANGE_NODE (id=6): BytesReceived(16s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 0ns - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313d0 (host=d2416.halxg.cloudera.com:22000):(Total: 177.915ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(16s000ms): 6.07 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB ThreadUsage(16s000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 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: 6.26 MB (6567248) - PerHostPeakMemUsage: 47.05 MB (49338240) - PrepareTime: 177.505ms - RowsProduced: 0 - TotalCpuTime: 0ns - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 0ns - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 256 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 6871947776.00 GB (7378697739434983424) - PeakMemoryUsage: 512.00 KB (524288) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 393.194ms, non-child: 393.194ms, % non-child: 100.00%) - CodegenTime: 2.64ms - CompileTime: 29.380ms - LoadTime: 75.91us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 189.58ms - PrepareTime: 173.210ms DataStreamSender (dst_id=8):(Total: 18.142us, non-child: 18.142us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 5.33 KB (5456) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=7):(Total: 177.504ms, non-child: 177.504ms, % non-child: 100.00%) ExecOption: Codegen Enabled - BuildTime: 0ns - GetNewBlockTime: 264.164us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 6.25 MB (6553600) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.766us EXCHANGE_NODE (id=6): BytesReceived(16s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 0ns - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313ce (host=d2420.halxg.cloudera.com:22000):(Total: 342.698ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(16s000ms): 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB, 6.26 MB ThreadUsage(16s000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 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: 6.26 MB (6567248) - PerHostPeakMemUsage: 28.12 MB (29484144) - PrepareTime: 342.22ms - RowsProduced: 0 - TotalCpuTime: 0ns - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 0ns - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 256 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 6871947776.00 GB (7378697739434983424) - PeakMemoryUsage: 512.00 KB (524288) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 790.147ms, non-child: 790.147ms, % non-child: 100.00%) - CodegenTime: 4.77ms - CompileTime: 61.412ms - LoadTime: 172.177us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 391.982ms - PrepareTime: 333.851ms DataStreamSender (dst_id=8):(Total: 36.222us, non-child: 36.222us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 5.33 KB (5456) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=7):(Total: 342.20ms, non-child: 342.20ms, % non-child: 100.00%) ExecOption: Codegen Enabled - BuildTime: 0ns - GetNewBlockTime: 461.453us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 6.25 MB (6553600) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 3.740us EXCHANGE_NODE (id=6): BytesReceived(16s000ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 0ns - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Fragment F02: Instance 9448ec37dcef4482:1b1f6848414313d4 (host=d2409.halxg.cloudera.com:22000):(Total: 748.786ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 6.36 MB, 12.13 MB ThreadUsage(500.0ms): 1, 2 - AverageThreadTokens: 1.50 - PeakMemoryUsage: 17.28 MB (18120592) - PerHostPeakMemUsage: 30.87 MB (32368808) - PrepareTime: 168.424ms - RowsProduced: 0 - TotalCpuTime: 854.988ms - TotalNetworkReceiveTime: 793.368ms - TotalNetworkSendTime: 4.56us - TotalStorageWaitTime: 0ns CodeGen:(Total: 488.580ms, non-child: 488.580ms, % non-child: 100.00%) - CodegenTime: 1.926ms - CompileTime: 79.584ms - LoadTime: 94.665us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 247.872ms - PrepareTime: 159.497ms DataStreamSender (dst_id=6):(Total: 31.801us, non-child: 31.801us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 95.91 KB (98208) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=3):(Total: 745.614ms, non-child: 164.494ms, % non-child: 22.06%) ExecOption: Codegen Enabled - BuildTime: 391.140us - GetNewBlockTime: 268.25us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 7.61 MB (7984760) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.674us HASH_JOIN_NODE (id=2):(Total: 581.120ms, non-child: 351.273ms, % non-child: 60.45%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildPartitionTime: 1.705us - BuildRows: 0 - BuildRowsPartitioned: 0 - BuildTime: 0ns - GetNewBlockTime: 289.859us - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 4.02 MB (4210688) - PinTime: 0ns - ProbeRows: 175.27K (175270) - ProbeRowsPartitioned: 0 - ProbeTime: 5.363ms - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.764us EXCHANGE_NODE (id=5):(Total: 566.206ms, non-child: 5.777us, % non-child: 0.00%) BytesReceived(500.0ms): 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 992ns - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 566.200ms - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns EXCHANGE_NODE (id=4):(Total: 230.520ms, non-child: 3.635ms, % non-child: 1.58%) BytesReceived(500.0ms): 0, 1.87 MB - BytesReceived: 2.23 MB (2339377) - ConvertRowBatchTime: 2.981ms - DeserializeRowBatchTimer: 11.182ms - FirstBatchArrivalWaitTime: 226.884ms - PeakMemoryUsage: 0 - RowsReturned: 175.27K (175270) - RowsReturnedRate: 760.32 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313d2 (host=d2406.halxg.cloudera.com:22000):(Total: 750.872ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 0, 6.36 MB ThreadUsage(500.0ms): 1, 2 - AverageThreadTokens: 1.50 - PeakMemoryUsage: 17.84 MB (18705480) - PerHostPeakMemUsage: 31.13 MB (32640864) - PrepareTime: 169.953ms - RowsProduced: 0 - TotalCpuTime: 856.963ms - TotalNetworkReceiveTime: 791.642ms - TotalNetworkSendTime: 4.235us - TotalStorageWaitTime: 0ns CodeGen:(Total: 489.30ms, non-child: 489.30ms, % non-child: 100.00%) - CodegenTime: 1.909ms - CompileTime: 79.942ms - LoadTime: 97.425us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 246.427ms - PrepareTime: 161.161ms DataStreamSender (dst_id=6):(Total: 29.526us, non-child: 29.526us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 95.91 KB (98208) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=3):(Total: 747.722ms, non-child: 166.68ms, % non-child: 22.21%) ExecOption: Codegen Enabled - BuildTime: 453.204us - GetNewBlockTime: 267.353us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 8.20 MB (8594040) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.728us HASH_JOIN_NODE (id=2):(Total: 581.654ms, non-child: 352.512ms, % non-child: 60.61%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildPartitionTime: 1.892us - BuildRows: 0 - BuildRowsPartitioned: 0 - BuildTime: 0ns - GetNewBlockTime: 292.229us - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 4.02 MB (4210688) - PinTime: 0ns - ProbeRows: 193.53K (193532) - ProbeRowsPartitioned: 0 - ProbeTime: 6.228ms - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.742us EXCHANGE_NODE (id=5):(Total: 565.543ms, non-child: 6.877us, % non-child: 0.00%) BytesReceived(500.0ms): 0 - BytesReceived: 0 - ConvertRowBatchTime: 1.35us - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 565.535ms - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns EXCHANGE_NODE (id=4):(Total: 229.805ms, non-child: 3.993ms, % non-child: 1.74%) BytesReceived(500.0ms): 0 - BytesReceived: 2.52 MB (2638412) - ConvertRowBatchTime: 3.307ms - DeserializeRowBatchTimer: 12.939ms - FirstBatchArrivalWaitTime: 225.811ms - PeakMemoryUsage: 0 - RowsReturned: 193.53K (193532) - RowsReturnedRate: 842.15 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313da (host=d2403.halxg.cloudera.com:22000):(Total: 751.760ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 6.26 MB, 6.36 MB ThreadUsage(500.0ms): 1, 2 - AverageThreadTokens: 1.50 - PeakMemoryUsage: 16.46 MB (17258720) - PerHostPeakMemUsage: 43.53 MB (45641104) - PrepareTime: 167.960ms - RowsProduced: 0 - TotalCpuTime: 852.536ms - TotalNetworkReceiveTime: 800.869ms - TotalNetworkSendTime: 4.479us - TotalStorageWaitTime: 0ns CodeGen:(Total: 486.244ms, non-child: 486.244ms, % non-child: 100.00%) - CodegenTime: 1.817ms - CompileTime: 78.963ms - LoadTime: 80.323us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 246.378ms - PrepareTime: 159.356ms DataStreamSender (dst_id=6):(Total: 30.178us, non-child: 30.178us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 95.91 KB (98208) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=3):(Total: 748.893ms, non-child: 164.5ms, % non-child: 21.90%) ExecOption: Codegen Enabled - BuildTime: 372.351us - GetNewBlockTime: 248.814us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 8.28 MB (8679264) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.709us HASH_JOIN_NODE (id=2):(Total: 584.887ms, non-child: 352.431ms, % non-child: 60.26%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildPartitionTime: 2.335us - BuildRows: 0 - BuildRowsPartitioned: 0 - BuildTime: 0ns - GetNewBlockTime: 224.616us - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 4.02 MB (4210688) - PinTime: 0ns - ProbeRows: 158.28K (158279) - ProbeRowsPartitioned: 0 - ProbeTime: 4.809ms - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.817us EXCHANGE_NODE (id=5):(Total: 570.942ms, non-child: 6.111us, % non-child: 0.00%) BytesReceived(500.0ms): 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 1.72us - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 570.936ms - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns EXCHANGE_NODE (id=4):(Total: 233.52ms, non-child: 3.433ms, % non-child: 1.47%) BytesReceived(500.0ms): 0, 0 - BytesReceived: 1.99 MB (2084763) - ConvertRowBatchTime: 2.774ms - DeserializeRowBatchTimer: 9.431ms - FirstBatchArrivalWaitTime: 229.618ms - PeakMemoryUsage: 0 - RowsReturned: 158.28K (158279) - RowsReturnedRate: 679.15 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313d7 (host=d2411.halxg.cloudera.com:22000):(Total: 756.170ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 6.36 MB, 12.65 MB ThreadUsage(500.0ms): 1, 2 - AverageThreadTokens: 1.50 - PeakMemoryUsage: 16.69 MB (17502032) - PerHostPeakMemUsage: 30.63 MB (32121536) - PrepareTime: 169.687ms - RowsProduced: 0 - TotalCpuTime: 849.800ms - TotalNetworkReceiveTime: 806.421ms - TotalNetworkSendTime: 4.129us - TotalStorageWaitTime: 0ns CodeGen:(Total: 483.56ms, non-child: 483.56ms, % non-child: 100.00%) - CodegenTime: 1.892ms - CompileTime: 76.621ms - LoadTime: 39.864us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 244.47ms - PrepareTime: 160.870ms DataStreamSender (dst_id=6):(Total: 29.937us, non-child: 29.937us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 95.91 KB (98208) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=3):(Total: 753.406ms, non-child: 165.796ms, % non-child: 22.01%) ExecOption: Codegen Enabled - BuildTime: 428.808us - GetNewBlockTime: 269.247us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 7.82 MB (8200880) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.700us HASH_JOIN_NODE (id=2):(Total: 587.609ms, non-child: 351.971ms, % non-child: 59.90%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildPartitionTime: 2.211us - BuildRows: 0 - BuildRowsPartitioned: 0 - BuildTime: 0ns - GetNewBlockTime: 276.200us - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 4.02 MB (4210688) - PinTime: 0ns - ProbeRows: 158.38K (158377) - ProbeRowsPartitioned: 0 - ProbeTime: 5.272ms - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.838us EXCHANGE_NODE (id=5):(Total: 573.163ms, non-child: 18.564us, % non-child: 0.00%) BytesReceived(500.0ms): 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 961ns - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 573.144ms - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns EXCHANGE_NODE (id=4):(Total: 236.297ms, non-child: 3.269ms, % non-child: 1.38%) BytesReceived(500.0ms): 0, 2.01 MB - BytesReceived: 2.02 MB (2116002) - ConvertRowBatchTime: 2.699ms - DeserializeRowBatchTimer: 10.195ms - FirstBatchArrivalWaitTime: 233.26ms - PeakMemoryUsage: 0 - RowsReturned: 158.38K (158377) - RowsReturnedRate: 670.24 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313d9 (host=d2402.halxg.cloudera.com:22000):(Total: 754.285ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 0, 6.36 MB, 13.46 MB ThreadUsage(500.0ms): 1, 2, 2 - AverageThreadTokens: 1.67 - PeakMemoryUsage: 17.47 MB (18320888) - PerHostPeakMemUsage: 30.83 MB (32327800) - PrepareTime: 170.645ms - RowsProduced: 0 - TotalCpuTime: 857.479ms - TotalNetworkReceiveTime: 795.541ms - TotalNetworkSendTime: 3.887us - TotalStorageWaitTime: 0ns CodeGen:(Total: 487.224ms, non-child: 487.224ms, % non-child: 100.00%) - CodegenTime: 1.972ms - CompileTime: 77.524ms - LoadTime: 96.648us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 246.358ms - PrepareTime: 161.757ms DataStreamSender (dst_id=6):(Total: 31.456us, non-child: 31.456us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 95.91 KB (98208) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=3):(Total: 751.6ms, non-child: 166.799ms, % non-child: 22.21%) ExecOption: Codegen Enabled - BuildTime: 477.650us - GetNewBlockTime: 266.828us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 8.11 MB (8506472) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.781us HASH_JOIN_NODE (id=2):(Total: 584.207ms, non-child: 354.607ms, % non-child: 60.70%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildPartitionTime: 2.247us - BuildRows: 0 - BuildRowsPartitioned: 0 - BuildTime: 0ns - GetNewBlockTime: 302.910us - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 4.02 MB (4210688) - PinTime: 0ns - ProbeRows: 193.67K (193666) - ProbeRowsPartitioned: 0 - ProbeTime: 5.285ms - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.869us EXCHANGE_NODE (id=5):(Total: 568.970ms, non-child: 5.435us, % non-child: 0.00%) BytesReceived(500.0ms): 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 1.91us - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 568.963ms - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns EXCHANGE_NODE (id=4):(Total: 230.289ms, non-child: 4.28ms, % non-child: 1.75%) BytesReceived(500.0ms): 0, 2.50 MB - BytesReceived: 2.50 MB (2620294) - ConvertRowBatchTime: 3.319ms - DeserializeRowBatchTimer: 12.251ms - FirstBatchArrivalWaitTime: 226.260ms - PeakMemoryUsage: 0 - RowsReturned: 193.67K (193666) - RowsReturnedRate: 840.97 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313db (host=d2408.halxg.cloudera.com:22000):(Total: 763.99ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 6.36 MB, 11.02 MB ThreadUsage(500.0ms): 1, 2 - AverageThreadTokens: 1.50 - PeakMemoryUsage: 17.29 MB (18128984) - PerHostPeakMemUsage: 23.55 MB (24696232) - PrepareTime: 171.252ms - RowsProduced: 0 - TotalCpuTime: 848.604ms - TotalNetworkReceiveTime: 813.135ms - TotalNetworkSendTime: 3.381us - TotalStorageWaitTime: 0ns CodeGen:(Total: 479.222ms, non-child: 479.222ms, % non-child: 100.00%) - CodegenTime: 1.913ms - CompileTime: 75.217ms - LoadTime: 31.739us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 240.104ms - PrepareTime: 162.386ms DataStreamSender (dst_id=6):(Total: 33.252us, non-child: 33.252us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 95.91 KB (98208) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=3):(Total: 760.189ms, non-child: 167.196ms, % non-child: 21.99%) ExecOption: Codegen Enabled - BuildTime: 433.560us - GetNewBlockTime: 286.422us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 10.57 MB (11082184) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.805us HASH_JOIN_NODE (id=2):(Total: 592.992ms, non-child: 354.821ms, % non-child: 59.84%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildPartitionTime: 2.156us - BuildRows: 0 - BuildRowsPartitioned: 0 - BuildTime: 0ns - GetNewBlockTime: 296.293us - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 4.02 MB (4210688) - PinTime: 0ns - ProbeRows: 176.18K (176183) - ProbeRowsPartitioned: 0 - ProbeTime: 5.754ms - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.731us EXCHANGE_NODE (id=5):(Total: 577.674ms, non-child: 5.205us, % non-child: 0.00%) BytesReceived(500.0ms): 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 824ns - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 577.669ms - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns EXCHANGE_NODE (id=4):(Total: 238.809ms, non-child: 3.539ms, % non-child: 1.48%) BytesReceived(500.0ms): 0, 1.53 MB - BytesReceived: 2.24 MB (2353395) - ConvertRowBatchTime: 3.0ms - DeserializeRowBatchTimer: 11.664ms - FirstBatchArrivalWaitTime: 235.269ms - PeakMemoryUsage: 0 - RowsReturned: 176.18K (176183) - RowsReturnedRate: 737.76 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313d3 (host=d2413.halxg.cloudera.com:22000):(Total: 761.823ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 0, 6.36 MB ThreadUsage(500.0ms): 1, 2 - AverageThreadTokens: 1.50 - PeakMemoryUsage: 19.73 MB (20688216) - PerHostPeakMemUsage: 38.32 MB (40179976) - PrepareTime: 172.167ms - RowsProduced: 0 - TotalCpuTime: 856.579ms - TotalNetworkReceiveTime: 800.457ms - TotalNetworkSendTime: 4.25us - TotalStorageWaitTime: 0ns CodeGen:(Total: 484.12ms, non-child: 484.12ms, % non-child: 100.00%) - CodegenTime: 1.906ms - CompileTime: 77.503ms - LoadTime: 26.166us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 241.711ms - PrepareTime: 163.373ms DataStreamSender (dst_id=6):(Total: 32.443us, non-child: 32.443us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 95.91 KB (98208) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=3):(Total: 758.873ms, non-child: 168.411ms, % non-child: 22.19%) ExecOption: Codegen Enabled - BuildTime: 622.777us - GetNewBlockTime: 274.697us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 7.95 MB (8332600) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.709us HASH_JOIN_NODE (id=2):(Total: 590.461ms, non-child: 356.328ms, % non-child: 60.35%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildPartitionTime: 2.310us - BuildRows: 0 - BuildRowsPartitioned: 0 - BuildTime: 0ns - GetNewBlockTime: 304.826us - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 4.02 MB (4210688) - PinTime: 0ns - ProbeRows: 245.99K (245994) - ProbeRowsPartitioned: 0 - ProbeTime: 8.343ms - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.885us EXCHANGE_NODE (id=5):(Total: 570.556ms, non-child: 6.666us, % non-child: 0.00%) BytesReceived(500.0ms): 0 - BytesReceived: 0 - ConvertRowBatchTime: 1.64us - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 570.548ms - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns EXCHANGE_NODE (id=4):(Total: 234.808ms, non-child: 5.295ms, % non-child: 2.26%) BytesReceived(500.0ms): 0 - BytesReceived: 3.23 MB (3392106) - ConvertRowBatchTime: 4.389ms - DeserializeRowBatchTimer: 17.922ms - FirstBatchArrivalWaitTime: 229.512ms - PeakMemoryUsage: 0 - RowsReturned: 245.99K (245994) - RowsReturnedRate: 1.05 M/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313d6 (host=d2401.halxg.cloudera.com:22000):(Total: 755.601ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 6.36 MB, 15.62 MB ThreadUsage(500.0ms): 1, 2 - AverageThreadTokens: 1.50 - PeakMemoryUsage: 19.62 MB (20576808) - PerHostPeakMemUsage: 38.17 MB (40019480) - PrepareTime: 172.160ms - RowsProduced: 0 - TotalCpuTime: 861.989ms - TotalNetworkReceiveTime: 789.473ms - TotalNetworkSendTime: 3.681us - TotalStorageWaitTime: 0ns CodeGen:(Total: 490.256ms, non-child: 490.256ms, % non-child: 100.00%) - CodegenTime: 1.940ms - CompileTime: 77.703ms - LoadTime: 220.628us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 247.689ms - PrepareTime: 163.150ms DataStreamSender (dst_id=6):(Total: 28.743us, non-child: 28.743us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 95.91 KB (98208) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=3):(Total: 752.913ms, non-child: 168.342ms, % non-child: 22.36%) ExecOption: Codegen Enabled - BuildTime: 555.642us - GetNewBlockTime: 263.724us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 7.68 MB (8054760) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.711us HASH_JOIN_NODE (id=2):(Total: 584.570ms, non-child: 356.874ms, % non-child: 61.05%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildPartitionTime: 1.606us - BuildRows: 0 - BuildRowsPartitioned: 0 - BuildTime: 0ns - GetNewBlockTime: 248.890us - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 4.02 MB (4210688) - PinTime: 0ns - ProbeRows: 228.82K (228822) - ProbeRowsPartitioned: 0 - ProbeTime: 7.819ms - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.724us EXCHANGE_NODE (id=5):(Total: 565.762ms, non-child: 5.443us, % non-child: 0.00%) BytesReceived(500.0ms): 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 708ns - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 565.756ms - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns EXCHANGE_NODE (id=4):(Total: 228.319ms, non-child: 4.992ms, % non-child: 2.19%) BytesReceived(500.0ms): 0, 3.02 MB - BytesReceived: 3.02 MB (3171863) - ConvertRowBatchTime: 4.68ms - DeserializeRowBatchTimer: 17.308ms - FirstBatchArrivalWaitTime: 223.327ms - PeakMemoryUsage: 0 - RowsReturned: 228.82K (228822) - RowsReturnedRate: 1.00 M/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313de (host=d2412.halxg.cloudera.com:22000):(Total: 754.126ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 6.36 MB, 13.23 MB ThreadUsage(500.0ms): 1, 2 - AverageThreadTokens: 1.50 - PeakMemoryUsage: 17.23 MB (18071704) - PerHostPeakMemUsage: 43.73 MB (45853696) - PrepareTime: 171.62ms - RowsProduced: 0 - TotalCpuTime: 860.826ms - TotalNetworkReceiveTime: 792.568ms - TotalNetworkSendTime: 4.122us - TotalStorageWaitTime: 0ns CodeGen:(Total: 489.462ms, non-child: 489.462ms, % non-child: 100.00%) - CodegenTime: 1.911ms - CompileTime: 79.623ms - LoadTime: 19.373us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 246.36ms - PrepareTime: 162.303ms DataStreamSender (dst_id=6):(Total: 37.799us, non-child: 37.799us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 95.91 KB (98208) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=3):(Total: 751.14ms, non-child: 167.311ms, % non-child: 22.28%) ExecOption: Codegen Enabled - BuildTime: 540.887us - GetNewBlockTime: 267.564us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 8.14 MB (8535312) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.699us HASH_JOIN_NODE (id=2):(Total: 583.703ms, non-child: 356.133ms, % non-child: 61.01%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildPartitionTime: 1.935us - BuildRows: 0 - BuildRowsPartitioned: 0 - BuildTime: 0ns - GetNewBlockTime: 293.469us - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 4.02 MB (4210688) - PinTime: 0ns - ProbeRows: 176.35K (176346) - ProbeRowsPartitioned: 0 - ProbeTime: 6.175ms - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.727us EXCHANGE_NODE (id=5):(Total: 567.847ms, non-child: 5.979us, % non-child: 0.00%) BytesReceived(500.0ms): 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 744ns - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 567.841ms - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns EXCHANGE_NODE (id=4):(Total: 228.213ms, non-child: 3.757ms, % non-child: 1.65%) BytesReceived(500.0ms): 0, 2.22 MB - BytesReceived: 2.22 MB (2329666) - ConvertRowBatchTime: 3.103ms - DeserializeRowBatchTimer: 11.588ms - FirstBatchArrivalWaitTime: 224.456ms - PeakMemoryUsage: 0 - RowsReturned: 176.35K (176346) - RowsReturnedRate: 772.72 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313dd (host=d2407.halxg.cloudera.com:22000):(Total: 758.312ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 6.36 MB, 13.62 MB ThreadUsage(500.0ms): 1, 2 - AverageThreadTokens: 1.50 - PeakMemoryUsage: 17.63 MB (18481400) - PerHostPeakMemUsage: 31.30 MB (32821984) - PrepareTime: 172.664ms - RowsProduced: 0 - TotalCpuTime: 859.407ms - TotalNetworkReceiveTime: 796.380ms - TotalNetworkSendTime: 3.914us - TotalStorageWaitTime: 0ns CodeGen:(Total: 486.734ms, non-child: 486.734ms, % non-child: 100.00%) - CodegenTime: 1.947ms - CompileTime: 80.446ms - LoadTime: 21.239us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 241.121ms - PrepareTime: 163.761ms DataStreamSender (dst_id=6):(Total: 32.560us, non-child: 32.560us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 95.91 KB (98208) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=3):(Total: 755.59ms, non-child: 168.722ms, % non-child: 22.35%) ExecOption: Codegen Enabled - BuildTime: 522.700us - GetNewBlockTime: 283.771us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 7.93 MB (8312728) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 2.111us HASH_JOIN_NODE (id=2):(Total: 586.336ms, non-child: 356.870ms, % non-child: 60.86%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildPartitionTime: 2.22us - BuildRows: 0 - BuildRowsPartitioned: 0 - BuildTime: 0ns - GetNewBlockTime: 311.398us - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 4.02 MB (4210688) - PinTime: 0ns - ProbeRows: 194.05K (194049) - ProbeRowsPartitioned: 0 - ProbeTime: 6.208ms - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 2.75us EXCHANGE_NODE (id=5):(Total: 569.972ms, non-child: 5.630us, % non-child: 0.00%) BytesReceived(500.0ms): 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 1.5us - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 569.966ms - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns EXCHANGE_NODE (id=4):(Total: 230.166ms, non-child: 4.58ms, % non-child: 1.76%) BytesReceived(500.0ms): 0, 2.51 MB - BytesReceived: 2.51 MB (2628719) - ConvertRowBatchTime: 3.345ms - DeserializeRowBatchTimer: 13.227ms - FirstBatchArrivalWaitTime: 226.107ms - PeakMemoryUsage: 0 - RowsReturned: 194.05K (194049) - RowsReturnedRate: 843.08 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313e1 (host=d2404.halxg.cloudera.com:22000):(Total: 754.555ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 6.36 MB, 13.68 MB ThreadUsage(500.0ms): 1, 2 - AverageThreadTokens: 1.50 - PeakMemoryUsage: 17.69 MB (18546128) - PerHostPeakMemUsage: 43.90 MB (46029880) - PrepareTime: 177.599ms - RowsProduced: 0 - TotalCpuTime: 869.132ms - TotalNetworkReceiveTime: 777.507ms - TotalNetworkSendTime: 3.529us - TotalStorageWaitTime: 0ns CodeGen:(Total: 496.207ms, non-child: 496.207ms, % non-child: 100.00%) - CodegenTime: 1.930ms - CompileTime: 78.345ms - LoadTime: 32.650us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 247.769ms - PrepareTime: 168.559ms DataStreamSender (dst_id=6):(Total: 34.262us, non-child: 34.262us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 95.91 KB (98208) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=3):(Total: 751.317ms, non-child: 173.584ms, % non-child: 23.10%) ExecOption: Codegen Enabled - BuildTime: 513.743us - GetNewBlockTime: 267.114us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 8.57 MB (8985808) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 2.119us HASH_JOIN_NODE (id=2):(Total: 577.733ms, non-child: 358.137ms, % non-child: 61.99%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildPartitionTime: 1.465us - BuildRows: 0 - BuildRowsPartitioned: 0 - BuildTime: 0ns - GetNewBlockTime: 287.733us - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 4.02 MB (4210688) - PinTime: 0ns - ProbeRows: 193.77K (193768) - ProbeRowsPartitioned: 0 - ProbeTime: 6.215ms - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 2.102us EXCHANGE_NODE (id=5):(Total: 561.145ms, non-child: 5.721us, % non-child: 0.00%) BytesReceived(500.0ms): 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 850ns - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 561.138ms - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns EXCHANGE_NODE (id=4):(Total: 220.268ms, non-child: 4.186ms, % non-child: 1.90%) BytesReceived(500.0ms): 0, 2.49 MB - BytesReceived: 2.49 MB (2606083) - ConvertRowBatchTime: 3.485ms - DeserializeRowBatchTimer: 13.411ms - FirstBatchArrivalWaitTime: 216.82ms - PeakMemoryUsage: 0 - RowsReturned: 193.77K (193768) - RowsReturnedRate: 879.69 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313d5 (host=d2419.halxg.cloudera.com:22000):(Total: 758.967ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 6.36 MB, 21.31 MB ThreadUsage(500.0ms): 1, 2 - AverageThreadTokens: 1.50 - PeakMemoryUsage: 21.37 MB (22405704) - PerHostPeakMemUsage: 38.12 MB (39974136) - PrepareTime: 168.500ms - RowsProduced: 0 - TotalCpuTime: 863.134ms - TotalNetworkReceiveTime: 793.984ms - TotalNetworkSendTime: 3.979us - TotalStorageWaitTime: 0ns CodeGen:(Total: 485.572ms, non-child: 485.572ms, % non-child: 100.00%) - CodegenTime: 1.920ms - CompileTime: 78.928ms - LoadTime: 33.971us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 245.424ms - PrepareTime: 159.745ms DataStreamSender (dst_id=6):(Total: 44.776us, non-child: 44.776us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 95.91 KB (98208) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=3):(Total: 755.933ms, non-child: 164.750ms, % non-child: 21.79%) ExecOption: Codegen Enabled - BuildTime: 516.567us - GetNewBlockTime: 256.488us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 7.65 MB (8020960) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.772us HASH_JOIN_NODE (id=2):(Total: 591.182ms, non-child: 359.683ms, % non-child: 60.84%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildPartitionTime: 484.221us - BuildRows: 57.69K (57686) - BuildRowsPartitioned: 57.69K (57686) - BuildTime: 0ns - GetNewBlockTime: 336.915us - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 4.07 MB (4270720) - PinTime: 0ns - ProbeRows: 310.68K (310681) - ProbeRowsPartitioned: 0 - ProbeTime: 9.236ms - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.761us EXCHANGE_NODE (id=5):(Total: 568.603ms, non-child: 2.195ms, % non-child: 0.39%) BytesReceived(500.0ms): 0, 428.60 KB - BytesReceived: 487.49 KB (499191) - ConvertRowBatchTime: 1.206ms - DeserializeRowBatchTimer: 3.74ms - FirstBatchArrivalWaitTime: 210.73ms - PeakMemoryUsage: 0 - RowsReturned: 57.69K (57686) - RowsReturnedRate: 101.45 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns EXCHANGE_NODE (id=4):(Total: 232.904ms, non-child: 6.458ms, % non-child: 2.77%) BytesReceived(500.0ms): 0, 3.54 MB - BytesReceived: 3.54 MB (3707777) - ConvertRowBatchTime: 5.350ms - DeserializeRowBatchTimer: 24.46ms - FirstBatchArrivalWaitTime: 226.445ms - PeakMemoryUsage: 0 - RowsReturned: 310.68K (310681) - RowsReturnedRate: 1.33 M/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313dc (host=d2415.halxg.cloudera.com:22000):(Total: 763.976ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 0, 6.36 MB ThreadUsage(500.0ms): 1, 2 - AverageThreadTokens: 1.50 - PeakMemoryUsage: 20.34 MB (21332848) - PerHostPeakMemUsage: 26.80 MB (28102960) - PrepareTime: 170.886ms - RowsProduced: 0 - TotalCpuTime: 859.383ms - TotalNetworkReceiveTime: 803.310ms - TotalNetworkSendTime: 3.734us - TotalStorageWaitTime: 0ns CodeGen:(Total: 482.762ms, non-child: 482.762ms, % non-child: 100.00%) - CodegenTime: 1.910ms - CompileTime: 79.754ms - LoadTime: 18.177us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 239.443ms - PrepareTime: 162.156ms DataStreamSender (dst_id=6):(Total: 28.530us, non-child: 28.530us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 95.91 KB (98208) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=3):(Total: 760.663ms, non-child: 167.20ms, % non-child: 21.96%) ExecOption: Codegen Enabled - BuildTime: 548.155us - GetNewBlockTime: 275.115us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 8.54 MB (8953368) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.780us HASH_JOIN_NODE (id=2):(Total: 593.643ms, non-child: 360.33ms, % non-child: 60.65%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildPartitionTime: 2.352us - BuildRows: 0 - BuildRowsPartitioned: 0 - BuildTime: 0ns - GetNewBlockTime: 278.453us - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 4.02 MB (4210688) - PinTime: 0ns - ProbeRows: 246.26K (246263) - ProbeRowsPartitioned: 0 - ProbeTime: 8.692ms - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 2.130us EXCHANGE_NODE (id=5):(Total: 573.816ms, non-child: 6.640us, % non-child: 0.00%) BytesReceived(500.0ms): 0 - BytesReceived: 0 - ConvertRowBatchTime: 857ns - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 573.809ms - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns EXCHANGE_NODE (id=4):(Total: 234.254ms, non-child: 5.47ms, % non-child: 2.15%) BytesReceived(500.0ms): 0 - BytesReceived: 3.23 MB (3389414) - ConvertRowBatchTime: 4.308ms - DeserializeRowBatchTimer: 18.612ms - FirstBatchArrivalWaitTime: 229.206ms - PeakMemoryUsage: 0 - RowsReturned: 246.26K (246263) - RowsReturnedRate: 1.05 M/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313e0 (host=d2420.halxg.cloudera.com:22000):(Total: 410.614ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 0, 6.36 MB ThreadUsage(500.0ms): 1, 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 14.50 MB (15204608) - PerHostPeakMemUsage: 28.12 MB (29484144) - PrepareTime: 356.764ms - RowsProduced: 0 - TotalCpuTime: 1s088ms - TotalNetworkReceiveTime: 36.359ms - TotalNetworkSendTime: 7.420us - TotalStorageWaitTime: 0ns CodeGen:(Total: 1s013ms, non-child: 1s013ms, % non-child: 100.00%) - CodegenTime: 3.724ms - CompileTime: 165.96ms - LoadTime: 175.157us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 505.990ms - PrepareTime: 339.45ms DataStreamSender (dst_id=6):(Total: 60.456us, non-child: 60.456us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 95.91 KB (98208) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=3):(Total: 406.861ms, non-child: 348.667ms, % non-child: 85.70%) ExecOption: Codegen Enabled - BuildTime: 532.771us - GetNewBlockTime: 496.127us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 6.84 MB (7175952) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 3.483us HASH_JOIN_NODE (id=2):(Total: 58.193ms, non-child: 54.875ms, % non-child: 94.30%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildPartitionTime: 3.549us - BuildRows: 0 - BuildRowsPartitioned: 0 - BuildTime: 0ns - GetNewBlockTime: 650.48us - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 4.02 MB (4210688) - PinTime: 0ns - ProbeRows: 105.56K (105565) - ProbeRowsPartitioned: 0 - ProbeTime: 6.111ms - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 3.761us EXCHANGE_NODE (id=5):(Total: 35.981ms, non-child: 9.852us, % non-child: 0.03%) BytesReceived(500.0ms): 0 - BytesReceived: 0 - ConvertRowBatchTime: 1.454us - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 35.970ms - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns EXCHANGE_NODE (id=4):(Total: 4.658ms, non-child: 4.658ms, % non-child: 100.00%) BytesReceived(500.0ms): 0 - BytesReceived: 1.31 MB (1378327) - ConvertRowBatchTime: 3.776ms - DeserializeRowBatchTimer: 14.846ms - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 105.56K (105565) - RowsReturnedRate: 22.66 M/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313e3 (host=d2414.halxg.cloudera.com:22000):(Total: 761.108ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 6.36 MB, 6.82 MB ThreadUsage(500.0ms): 1, 2 - AverageThreadTokens: 1.50 - PeakMemoryUsage: 20.15 MB (21124096) - PerHostPeakMemUsage: 32.67 MB (34252816) - PrepareTime: 172.669ms - RowsProduced: 0 - TotalCpuTime: 865.750ms - TotalNetworkReceiveTime: 792.361ms - TotalNetworkSendTime: 4.144us - TotalStorageWaitTime: 0ns CodeGen:(Total: 488.447ms, non-child: 488.447ms, % non-child: 100.00%) - CodegenTime: 1.946ms - CompileTime: 78.206ms - LoadTime: 24.152us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 245.11ms - PrepareTime: 163.706ms DataStreamSender (dst_id=6):(Total: 54.961us, non-child: 54.961us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 95.91 KB (98208) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=3):(Total: 757.706ms, non-child: 168.827ms, % non-child: 22.28%) ExecOption: Codegen Enabled - BuildTime: 494.254us - GetNewBlockTime: 277.607us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 8.50 MB (8909256) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.728us HASH_JOIN_NODE (id=2):(Total: 588.879ms, non-child: 361.703ms, % non-child: 61.42%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildPartitionTime: 1.576us - BuildRows: 0 - BuildRowsPartitioned: 0 - BuildTime: 0ns - GetNewBlockTime: 291.993us - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 4.02 MB (4210688) - PinTime: 0ns - ProbeRows: 246.08K (246078) - ProbeRowsPartitioned: 0 - ProbeTime: 8.113ms - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.723us EXCHANGE_NODE (id=5):(Total: 569.394ms, non-child: 6.475us, % non-child: 0.00%) BytesReceived(500.0ms): 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 1.96us - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 569.387ms - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns EXCHANGE_NODE (id=4):(Total: 227.800ms, non-child: 5.296ms, % non-child: 2.32%) BytesReceived(500.0ms): 0, 201.12 KB - BytesReceived: 3.24 MB (3392260) - ConvertRowBatchTime: 4.272ms - DeserializeRowBatchTimer: 17.334ms - FirstBatchArrivalWaitTime: 222.503ms - PeakMemoryUsage: 0 - RowsReturned: 246.08K (246078) - RowsReturnedRate: 1.08 M/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313df (host=d2410.halxg.cloudera.com:22000):(Total: 764.749ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 6.36 MB, 16.70 MB ThreadUsage(500.0ms): 1, 2 - AverageThreadTokens: 1.50 - PeakMemoryUsage: 20.71 MB (21713824) - PerHostPeakMemUsage: 33.65 MB (35282472) - PrepareTime: 171.767ms - RowsProduced: 0 - TotalCpuTime: 864.318ms - TotalNetworkReceiveTime: 799.435ms - TotalNetworkSendTime: 3.891us - TotalStorageWaitTime: 0ns CodeGen:(Total: 484.769ms, non-child: 484.769ms, % non-child: 100.00%) - CodegenTime: 1.948ms - CompileTime: 78.447ms - LoadTime: 71.358us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 241.987ms - PrepareTime: 162.722ms DataStreamSender (dst_id=6):(Total: 29.224us, non-child: 29.224us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 95.91 KB (98208) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=3):(Total: 761.720ms, non-child: 168.12ms, % non-child: 22.06%) ExecOption: Codegen Enabled - BuildTime: 611.294us - GetNewBlockTime: 269.84us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 8.16 MB (8551272) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.817us HASH_JOIN_NODE (id=2):(Total: 593.707ms, non-child: 362.530ms, % non-child: 61.06%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildPartitionTime: 1.695us - BuildRows: 0 - BuildRowsPartitioned: 0 - BuildTime: 0ns - GetNewBlockTime: 295.202us - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 4.02 MB (4210688) - PinTime: 0ns - ProbeRows: 264.51K (264506) - ProbeRowsPartitioned: 0 - ProbeTime: 9.281ms - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.682us EXCHANGE_NODE (id=5):(Total: 572.762ms, non-child: 5.918us, % non-child: 0.00%) BytesReceived(500.0ms): 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 1.28us - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 572.756ms - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns EXCHANGE_NODE (id=4):(Total: 231.826ms, non-child: 5.501ms, % non-child: 2.37%) BytesReceived(500.0ms): 0, 3.49 MB - BytesReceived: 3.49 MB (3663589) - ConvertRowBatchTime: 4.594ms - DeserializeRowBatchTimer: 19.775ms - FirstBatchArrivalWaitTime: 226.324ms - PeakMemoryUsage: 0 - RowsReturned: 264.51K (264506) - RowsReturnedRate: 1.14 M/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313e2 (host=d2416.halxg.cloudera.com:22000):(Total: 766.993ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 6.36 MB, 7.01 MB ThreadUsage(500.0ms): 1, 2 - AverageThreadTokens: 1.50 - PeakMemoryUsage: 21.68 MB (22731736) - PerHostPeakMemUsage: 47.05 MB (49338240) - PrepareTime: 173.448ms - RowsProduced: 0 - TotalCpuTime: 864.658ms - TotalNetworkReceiveTime: 799.296ms - TotalNetworkSendTime: 3.824us - TotalStorageWaitTime: 0ns CodeGen:(Total: 485.172ms, non-child: 485.172ms, % non-child: 100.00%) - CodegenTime: 1.885ms - CompileTime: 77.121ms - LoadTime: 18.810us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 241.849ms - PrepareTime: 164.709ms DataStreamSender (dst_id=6):(Total: 40.872us, non-child: 40.872us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 95.91 KB (98208) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=3):(Total: 763.850ms, non-child: 169.713ms, % non-child: 22.22%) ExecOption: Codegen Enabled - BuildTime: 575.103us - GetNewBlockTime: 271.377us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 11.19 MB (11736864) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.781us HASH_JOIN_NODE (id=2):(Total: 594.137ms, non-child: 362.902ms, % non-child: 61.08%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildPartitionTime: 1.663us - BuildRows: 0 - BuildRowsPartitioned: 0 - BuildTime: 0ns - GetNewBlockTime: 283.829us - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 4.02 MB (4210688) - PinTime: 0ns - ProbeRows: 282.12K (282121) - ProbeRowsPartitioned: 0 - ProbeTime: 9.28ms - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.815us EXCHANGE_NODE (id=5):(Total: 572.938ms, non-child: 6.896us, % non-child: 0.00%) BytesReceived(500.0ms): 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 912ns - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 572.930ms - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns EXCHANGE_NODE (id=4):(Total: 231.890ms, non-child: 6.30ms, % non-child: 2.60%) BytesReceived(500.0ms): 0, 284.99 KB - BytesReceived: 3.76 MB (3939768) - ConvertRowBatchTime: 4.964ms - DeserializeRowBatchTimer: 20.881ms - FirstBatchArrivalWaitTime: 225.858ms - PeakMemoryUsage: 0 - RowsReturned: 282.12K (282121) - RowsReturnedRate: 1.22 M/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 9448ec37dcef4482:1b1f6848414313d8 (host=d2417.halxg.cloudera.com:22000):(Total: 172.953ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(16s000ms): 231.95 MB, 235.12 MB, 235.07 MB, 235.02 MB, 234.98 MB, 234.94 MB, 234.89 MB, 234.83 MB, 234.80 MB, 234.75 MB, 234.71 MB, 234.66 MB, 234.62 MB, 234.59 MB, 234.53 MB, 234.49 MB, 234.43 MB, 234.39 MB, 234.35 MB, 234.31 MB, 234.27 MB, 234.22 MB, 234.19 MB, 234.12 MB, 234.07 MB, 234.03 MB, 233.99 MB, 233.95 MB, 233.91 MB, 233.88 MB, 233.82 MB, 233.79 MB, 233.74 MB, 233.71 MB, 233.65 MB, 233.60 MB ThreadUsage(16s000ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 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: 603.90 MB (633233712) - PerHostPeakMemUsage: 748.11 MB (784445952) - PrepareTime: 169.722ms - RowsProduced: 0 - TotalCpuTime: 966.97ms - TotalNetworkReceiveTime: 497.902ms - TotalNetworkSendTime: 0ns - TotalStorageWaitTime: 0ns CodeGen:(Total: 486.390ms, non-child: 486.390ms, % non-child: 100.00%) - CodegenTime: 1.961ms - CompileTime: 77.102ms - LoadTime: 27.876us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 247.56ms - PrepareTime: 160.783ms DataStreamSender (dst_id=6):(Total: 38.483us, non-child: 38.483us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 95.91 KB (98208) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=3):(Total: 169.721ms, non-child: 0ns, % non-child: 0.00%) ExecOption: Codegen Enabled - BuildTime: 2m46s - GetNewBlockTime: 271.817us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 6.33 MB (6633840) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 1.749us HASH_JOIN_NODE (id=2):(Total: 6m55s, non-child: 6m55s, % non-child: 100.00%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildPartitionTime: 296.952ms - BuildRows: 1.87M (1867314) - BuildRowsPartitioned: 1.87M (1867314) - BuildTime: 283.990ms - GetNewBlockTime: 14.590ms - HashBuckets: 4.19M (4194304) - LargestPartitionPercent: 100 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 580.60 MB (608804816) - PinTime: 0ns - ProbeRows: 42.28K (42284) - ProbeRowsPartitioned: 0 - ProbeTime: 6m37s - RowsReturned: 4.53B (4532422882) - RowsReturnedRate: 10.92 M/sec - SpilledPartitions: 0 - UnpinTime: 1.742us EXCHANGE_NODE (id=5):(Total: 310.546ms, non-child: 135.6ms, % non-child: 43.47%) BytesReceived(16s000ms): 19.67 MB, 20.31 MB, 20.31 MB, 20.31 MB, 20.31 MB, 20.31 MB, 20.31 MB, 20.31 MB, 20.31 MB, 20.31 MB, 20.31 MB, 20.31 MB, 20.31 MB, 20.31 MB, 20.31 MB, 20.31 MB, 20.31 MB, 20.31 MB, 20.31 MB, 20.31 MB, 20.31 MB, 20.31 MB, 20.31 MB, 20.31 MB, 20.31 MB, 20.31 MB, 20.31 MB, 20.31 MB, 20.31 MB, 20.31 MB, 20.31 MB, 20.31 MB, 20.31 MB, 20.31 MB, 20.31 MB, 20.31 MB - BytesReceived: 20.31 MB (21299282) - ConvertRowBatchTime: 33.675ms - DeserializeRowBatchTimer: 139.479ms - FirstBatchArrivalWaitTime: 175.260ms - PeakMemoryUsage: 0 - RowsReturned: 1.87M (1867314) - RowsReturnedRate: 6.01 M/sec - SendersBlockedTimer: 115.84ms - SendersBlockedTotalTimer(*): 1s147ms EXCHANGE_NODE (id=4):(Total: 226.599ms, non-child: 1.424ms, % non-child: 0.63%) BytesReceived(16s000ms): 3.88 MB, 4.01 MB, 4.01 MB, 4.01 MB, 4.01 MB, 4.01 MB, 4.01 MB, 4.01 MB, 4.01 MB, 4.01 MB, 4.01 MB, 4.01 MB, 4.01 MB, 4.01 MB, 4.01 MB, 4.01 MB, 4.01 MB, 4.01 MB, 4.01 MB, 4.01 MB, 4.01 MB, 4.01 MB, 4.01 MB, 4.01 MB, 4.01 MB, 4.01 MB, 4.01 MB, 4.01 MB, 4.01 MB, 4.01 MB, 4.01 MB, 4.01 MB, 4.01 MB, 4.01 MB, 4.01 MB, 4.01 MB - BytesReceived: 4.01 MB (4202852) - ConvertRowBatchTime: 929.990us - DeserializeRowBatchTimer: 27.490ms - FirstBatchArrivalWaitTime: 225.174ms - PeakMemoryUsage: 0 - RowsReturned: 42.28K (42284) - RowsReturnedRate: 186.60 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Fragment F01: Instance 9448ec37dcef4482:1b1f6848414313f2 (host=d2411.halxg.cloudera.com:22000):(Total: 336.833ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 6:1/9.93 MB MemoryUsage(500.0ms): 2.35 MB ThreadUsage(500.0ms): 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 12.75 MB (13372960) - PerHostPeakMemUsage: 30.63 MB (32121536) - PrepareTime: 163.48ms - RowsProduced: 91.63K (91630) - TotalCpuTime: 353.121ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 141.737ms - TotalStorageWaitTime: 6.220ms CodeGen:(Total: 298.634ms, non-child: 298.634ms, % non-child: 100.00%) - CodegenTime: 627.898us - CompileTime: 4.275ms - LoadTime: 45.377us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 131.949ms - PrepareTime: 160.810ms DataStreamSender (dst_id=5):(Total: 165.750ms, non-child: 165.750ms, % non-child: 100.00%) - BytesSent: 1.03 MB (1080407) - NetworkThroughput(*): 6.50 MB/sec - OverallThroughput: 6.22 MB/sec - PeakMemoryUsage: 187.84 KB (192352) - SerializeBatchTime: 7.388ms - ThriftTransmitTime(*): 158.489ms - UncompressedRowBatchSize: 3.55 MB (3721702) HDFS_SCAN_NODE (id=0):(Total: 168.436ms, non-child: 168.436ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 6:1/9.93 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% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: TEXT/NONE:1 ExecOption: Codegen enabled: 1 out of 1 BytesRead(500.0ms): 9.93 MB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 9.93 MB (10412696) - BytesReadDataNodeCache: 0 - BytesReadLocal: 9.93 MB (10412696) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 9.93 MB (10412696) - DecompressionTime: 0ns - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 12.58 MB (13193216) - PerReadThreadRawHdfsThroughput: 2.74 GB/sec - RemoteScanRanges: 0 - RowsRead: 91.63K (91630) - RowsReturned: 91.63K (91630) - RowsReturnedRate: 544.00 K/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 22.296ms - DelimiterParseTime: 14.15ms - MaterializeTupleTime(*): 1.174ms - ScannerThreadsSysTime: 0ns - ScannerThreadsUserTime: 14.997ms - ScannerThreadsVoluntaryContextSwitches: 3 - TotalRawHdfsReadTime(*): 3.538ms - TotalReadThroughput: 19.86 MB/sec Instance 9448ec37dcef4482:1b1f6848414313e7 (host=d2413.halxg.cloudera.com:22000):(Total: 342.977ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 1:1/9.93 MB MemoryUsage(500.0ms): 103.91 KB ThreadUsage(500.0ms): 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 12.68 MB (13291040) - PerHostPeakMemUsage: 38.32 MB (40179976) - PrepareTime: 163.314ms - RowsProduced: 91.63K (91629) - TotalCpuTime: 357.48ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 144.24ms - TotalStorageWaitTime: 6.62ms CodeGen:(Total: 299.406ms, non-child: 299.406ms, % non-child: 100.00%) - CodegenTime: 627.780us - CompileTime: 4.338ms - LoadTime: 52.434us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 132.395ms - PrepareTime: 161.145ms DataStreamSender (dst_id=5):(Total: 171.592ms, non-child: 171.592ms, % non-child: 100.00%) - BytesSent: 1.04 MB (1087337) - NetworkThroughput(*): 6.49 MB/sec - OverallThroughput: 6.04 MB/sec - PeakMemoryUsage: 187.84 KB (192352) - SerializeBatchTime: 7.847ms - ThriftTransmitTime(*): 159.892ms - UncompressedRowBatchSize: 3.55 MB (3722541) HDFS_SCAN_NODE (id=0):(Total: 168.579ms, non-child: 168.579ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 1:1/9.93 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: TEXT/NONE:1 ExecOption: Codegen enabled: 1 out of 1 BytesRead(500.0ms): 0 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 9.93 MB (10411544) - BytesReadDataNodeCache: 0 - BytesReadLocal: 9.93 MB (10411544) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 9.93 MB (10411544) - DecompressionTime: 0ns - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 12.47 MB (13079552) - PerReadThreadRawHdfsThroughput: 2.55 GB/sec - RemoteScanRanges: 0 - RowsRead: 91.63K (91629) - RowsReturned: 91.63K (91629) - RowsReturnedRate: 543.53 K/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 1 - ScannerThreadsTotalWallClockTime: 21.993ms - DelimiterParseTime: 13.999ms - MaterializeTupleTime(*): 1.163ms - ScannerThreadsSysTime: 0ns - ScannerThreadsUserTime: 14.997ms - ScannerThreadsVoluntaryContextSwitches: 2 - TotalRawHdfsReadTime(*): 3.799ms - TotalReadThroughput: 0.00 /sec Instance 9448ec37dcef4482:1b1f6848414313f4 (host=d2417.halxg.cloudera.com:22000):(Total: 345.679ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 8:1/9.92 MB MemoryUsage(500.0ms): 103.91 KB ThreadUsage(500.0ms): 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 12.61 MB (13224480) - PerHostPeakMemUsage: 598.16 MB (627213904) - PrepareTime: 166.230ms - RowsProduced: 91.63K (91630) - TotalCpuTime: 375.770ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 136.878ms - TotalStorageWaitTime: 6.797ms CodeGen:(Total: 301.692ms, non-child: 301.692ms, % non-child: 100.00%) - CodegenTime: 696.177us - CompileTime: 4.291ms - LoadTime: 84.588us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 131.837ms - PrepareTime: 163.999ms DataStreamSender (dst_id=5):(Total: 169.761ms, non-child: 169.761ms, % non-child: 100.00%) - BytesSent: 1.04 MB (1090955) - NetworkThroughput(*): 6.58 MB/sec - OverallThroughput: 6.13 MB/sec - PeakMemoryUsage: 187.84 KB (192352) - SerializeBatchTime: 8.220ms - ThriftTransmitTime(*): 158.124ms - UncompressedRowBatchSize: 3.55 MB (3720740) HDFS_SCAN_NODE (id=0):(Total: 172.588ms, non-child: 172.588ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 8:1/9.92 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: TEXT/NONE:1 ExecOption: Codegen enabled: 1 out of 1 BytesRead(500.0ms): 0 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 9.92 MB (10406548) - BytesReadDataNodeCache: 0 - BytesReadLocal: 9.92 MB (10406548) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 9.92 MB (10406548) - DecompressionTime: 0ns - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 12.41 MB (13012992) - PerReadThreadRawHdfsThroughput: 2.00 GB/sec - RemoteScanRanges: 0 - RowsRead: 91.63K (91630) - RowsReturned: 91.63K (91630) - RowsReturnedRate: 530.92 K/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 4 - ScannerThreadsTotalWallClockTime: 33.142ms - DelimiterParseTime: 16.334ms - MaterializeTupleTime(*): 1.404ms - ScannerThreadsSysTime: 0ns - ScannerThreadsUserTime: 18.997ms - ScannerThreadsVoluntaryContextSwitches: 38 - TotalRawHdfsReadTime(*): 4.844ms - TotalReadThroughput: 0.00 /sec Instance 9448ec37dcef4482:1b1f6848414313ee (host=d2414.halxg.cloudera.com:22000):(Total: 345.511ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 6:1/9.93 MB MemoryUsage(500.0ms): 12.15 MB ThreadUsage(500.0ms): 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 12.80 MB (13426208) - PerHostPeakMemUsage: 32.67 MB (34252816) - PrepareTime: 165.29ms - RowsProduced: 91.63K (91628) - TotalCpuTime: 364.283ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 140.318ms - TotalStorageWaitTime: 6.315ms CodeGen:(Total: 302.478ms, non-child: 302.478ms, % non-child: 100.00%) - CodegenTime: 669.326us - CompileTime: 4.299ms - LoadTime: 68.615us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 133.813ms - PrepareTime: 162.830ms DataStreamSender (dst_id=5):(Total: 170.863ms, non-child: 170.863ms, % non-child: 100.00%) - BytesSent: 995.04 KB (1018924) - NetworkThroughput(*): 5.99 MB/sec - OverallThroughput: 5.69 MB/sec - PeakMemoryUsage: 187.84 KB (192352) - SerializeBatchTime: 7.321ms - ThriftTransmitTime(*): 162.340ms - UncompressedRowBatchSize: 3.55 MB (3721802) HDFS_SCAN_NODE (id=0):(Total: 170.624ms, non-child: 170.624ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 6:1/9.93 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% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: TEXT/NONE:1 ExecOption: Codegen enabled: 1 out of 1 BytesRead(500.0ms): 9.93 MB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 9.93 MB (10407397) - BytesReadDataNodeCache: 0 - BytesReadLocal: 9.93 MB (10407397) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 9.93 MB (10407397) - DecompressionTime: 0ns - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 12.60 MB (13214720) - PerReadThreadRawHdfsThroughput: 2.40 GB/sec - RemoteScanRanges: 0 - RowsRead: 91.63K (91628) - RowsReturned: 91.63K (91628) - RowsReturnedRate: 537.01 K/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 22.99ms - DelimiterParseTime: 13.718ms - MaterializeTupleTime(*): 1.207ms - ScannerThreadsSysTime: 999.0us - ScannerThreadsUserTime: 13.997ms - ScannerThreadsVoluntaryContextSwitches: 2 - TotalRawHdfsReadTime(*): 4.45ms - TotalReadThroughput: 19.85 MB/sec Instance 9448ec37dcef4482:1b1f6848414313f3 (host=d2402.halxg.cloudera.com:22000):(Total: 347.549ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 8:1/9.93 MB MemoryUsage(500.0ms): 0 ThreadUsage(500.0ms): 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 12.77 MB (13389344) - PerHostPeakMemUsage: 30.83 MB (32327800) - PrepareTime: 163.57ms - RowsProduced: 91.63K (91630) - TotalCpuTime: 356.549ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 149.461ms - TotalStorageWaitTime: 6.51ms CodeGen:(Total: 298.649ms, non-child: 298.649ms, % non-child: 100.00%) - CodegenTime: 739.517us - CompileTime: 4.344ms - LoadTime: 106.653us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 132.13ms - PrepareTime: 160.767ms DataStreamSender (dst_id=5):(Total: 175.607ms, non-child: 175.607ms, % non-child: 100.00%) - BytesSent: 1.01 MB (1056034) - NetworkThroughput(*): 6.05 MB/sec - OverallThroughput: 5.74 MB/sec - PeakMemoryUsage: 187.84 KB (192352) - SerializeBatchTime: 8.297ms - ThriftTransmitTime(*): 166.367ms - UncompressedRowBatchSize: 3.55 MB (3721442) HDFS_SCAN_NODE (id=0):(Total: 168.834ms, non-child: 168.834ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 8:1/9.93 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: TEXT/NONE:1 ExecOption: Codegen enabled: 1 out of 1 BytesRead(500.0ms): 0 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 9.93 MB (10411642) - BytesReadDataNodeCache: 0 - BytesReadLocal: 9.93 MB (10411642) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 9.93 MB (10411642) - DecompressionTime: 0ns - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 12.57 MB (13177856) - PerReadThreadRawHdfsThroughput: 2.16 GB/sec - RemoteScanRanges: 0 - RowsRead: 91.63K (91630) - RowsReturned: 91.63K (91630) - RowsReturnedRate: 542.72 K/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 1 - ScannerThreadsTotalWallClockTime: 22.613ms - DelimiterParseTime: 14.374ms - MaterializeTupleTime(*): 1.229ms - ScannerThreadsSysTime: 999.0us - ScannerThreadsUserTime: 14.997ms - ScannerThreadsVoluntaryContextSwitches: 3 - TotalRawHdfsReadTime(*): 4.482ms - TotalReadThroughput: 0.00 /sec Instance 9448ec37dcef4482:1b1f6848414313e8 (host=d2406.halxg.cloudera.com:22000):(Total: 351.764ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 0:1/9.94 MB MemoryUsage(500.0ms): 103.91 KB ThreadUsage(500.0ms): 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 12.83 MB (13454880) - PerHostPeakMemUsage: 31.13 MB (32640864) - PrepareTime: 166.200ms - RowsProduced: 91.76K (91759) - TotalCpuTime: 365.84ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 146.978ms - TotalStorageWaitTime: 5.855ms CodeGen:(Total: 303.618ms, non-child: 303.618ms, % non-child: 100.00%) - CodegenTime: 646.684us - CompileTime: 4.349ms - LoadTime: 95.334us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 133.733ms - PrepareTime: 163.897ms DataStreamSender (dst_id=5):(Total: 176.994ms, non-child: 176.994ms, % non-child: 100.00%) - BytesSent: 1.01 MB (1054322) - NetworkThroughput(*): 6.00 MB/sec - OverallThroughput: 5.68 MB/sec - PeakMemoryUsage: 187.84 KB (192352) - SerializeBatchTime: 8.138ms - ThriftTransmitTime(*): 167.716ms - UncompressedRowBatchSize: 3.55 MB (3726835) HDFS_SCAN_NODE (id=0):(Total: 171.435ms, non-child: 171.435ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 0:1/9.94 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: TEXT/NONE:1 ExecOption: Codegen enabled: 1 out of 1 BytesRead(500.0ms): 0 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 9.94 MB (10425425) - BytesReadDataNodeCache: 0 - BytesReadLocal: 9.94 MB (10425425) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 9.94 MB (10425425) - DecompressionTime: 0ns - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 12.63 MB (13243392) - PerReadThreadRawHdfsThroughput: 2.46 GB/sec - RemoteScanRanges: 0 - RowsRead: 91.76K (91759) - RowsReturned: 91.76K (91759) - RowsReturnedRate: 535.24 K/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 22.521ms - DelimiterParseTime: 14.578ms - MaterializeTupleTime(*): 1.224ms - ScannerThreadsSysTime: 0ns - ScannerThreadsUserTime: 15.997ms - ScannerThreadsVoluntaryContextSwitches: 2 - TotalRawHdfsReadTime(*): 3.954ms - TotalReadThroughput: 0.00 /sec Instance 9448ec37dcef4482:1b1f6848414313eb (host=d2410.halxg.cloudera.com:22000):(Total: 353.425ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 8:1/9.93 MB MemoryUsage(500.0ms): 2.49 MB ThreadUsage(500.0ms): 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 12.84 MB (13458976) - PerHostPeakMemUsage: 33.65 MB (35282472) - PrepareTime: 163.713ms - RowsProduced: 91.63K (91630) - TotalCpuTime: 359.993ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 153.96ms - TotalStorageWaitTime: 5.534ms CodeGen:(Total: 302.249ms, non-child: 302.249ms, % non-child: 100.00%) - CodegenTime: 613.863us - CompileTime: 4.244ms - LoadTime: 63.703us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 134.917ms - PrepareTime: 161.497ms DataStreamSender (dst_id=5):(Total: 181.653ms, non-child: 181.653ms, % non-child: 100.00%) - BytesSent: 1.02 MB (1068807) - NetworkThroughput(*): 6.02 MB/sec - OverallThroughput: 5.61 MB/sec - PeakMemoryUsage: 187.84 KB (192352) - SerializeBatchTime: 8.652ms - ThriftTransmitTime(*): 169.458ms - UncompressedRowBatchSize: 3.55 MB (3721611) HDFS_SCAN_NODE (id=0):(Total: 168.399ms, non-child: 168.399ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 8:1/9.93 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% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: TEXT/NONE:1 ExecOption: Codegen enabled: 1 out of 1 BytesRead(500.0ms): 9.93 MB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 9.93 MB (10410948) - BytesReadDataNodeCache: 0 - BytesReadLocal: 9.93 MB (10410948) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 9.93 MB (10410948) - DecompressionTime: 0ns - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 12.63 MB (13247488) - PerReadThreadRawHdfsThroughput: 2.72 GB/sec - RemoteScanRanges: 0 - RowsRead: 91.63K (91630) - RowsReturned: 91.63K (91630) - RowsReturnedRate: 544.12 K/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 21.491ms - DelimiterParseTime: 13.899ms - MaterializeTupleTime(*): 1.282ms - ScannerThreadsSysTime: 999.0us - ScannerThreadsUserTime: 13.997ms - ScannerThreadsVoluntaryContextSwitches: 2 - TotalRawHdfsReadTime(*): 3.570ms - TotalReadThroughput: 19.86 MB/sec Instance 9448ec37dcef4482:1b1f6848414313ed (host=d2407.halxg.cloudera.com:22000):(Total: 352.924ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 4:1/9.94 MB MemoryUsage(500.0ms): 0 ThreadUsage(500.0ms): 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 12.80 MB (13422112) - PerHostPeakMemUsage: 31.30 MB (32821984) - PrepareTime: 164.932ms - RowsProduced: 91.76K (91758) - TotalCpuTime: 359.300ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 154.748ms - TotalStorageWaitTime: 6.331ms CodeGen:(Total: 302.68ms, non-child: 302.68ms, % non-child: 100.00%) - CodegenTime: 685.411us - CompileTime: 4.384ms - LoadTime: 83.464us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 133.439ms - PrepareTime: 162.819ms DataStreamSender (dst_id=5):(Total: 179.575ms, non-child: 179.575ms, % non-child: 100.00%) - BytesSent: 1014.19 KB (1038531) - NetworkThroughput(*): 5.80 MB/sec - OverallThroughput: 5.52 MB/sec - PeakMemoryUsage: 187.84 KB (192352) - SerializeBatchTime: 7.656ms - ThriftTransmitTime(*): 170.694ms - UncompressedRowBatchSize: 3.55 MB (3727206) HDFS_SCAN_NODE (id=0):(Total: 170.668ms, non-child: 170.668ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 4:1/9.94 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: TEXT/NONE:1 ExecOption: Codegen enabled: 1 out of 1 BytesRead(500.0ms): 0 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 9.94 MB (10425041) - BytesReadDataNodeCache: 0 - BytesReadLocal: 9.94 MB (10425041) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 9.94 MB (10425041) - DecompressionTime: 0ns - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 12.60 MB (13210624) - PerReadThreadRawHdfsThroughput: 2.34 GB/sec - RemoteScanRanges: 0 - RowsRead: 91.76K (91758) - RowsReturned: 91.76K (91758) - RowsReturnedRate: 537.64 K/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 23.62ms - DelimiterParseTime: 14.407ms - MaterializeTupleTime(*): 1.330ms - ScannerThreadsSysTime: 999.0us - ScannerThreadsUserTime: 14.997ms - ScannerThreadsVoluntaryContextSwitches: 3 - TotalRawHdfsReadTime(*): 4.148ms - TotalReadThroughput: 0.00 /sec Instance 9448ec37dcef4482:1b1f6848414313e5 (host=d2419.halxg.cloudera.com:22000):(Total: 357.308ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 2:1/9.94 MB MemoryUsage(500.0ms): 0 ThreadUsage(500.0ms): 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 12.87 MB (13491744) - PerHostPeakMemUsage: 38.12 MB (39974136) - PrepareTime: 164.267ms - RowsProduced: 91.76K (91759) - TotalCpuTime: 362.979ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 154.461ms - TotalStorageWaitTime: 6.591ms CodeGen:(Total: 302.289ms, non-child: 302.289ms, % non-child: 100.00%) - CodegenTime: 670.417us - CompileTime: 4.301ms - LoadTime: 91.437us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 134.404ms - PrepareTime: 161.997ms DataStreamSender (dst_id=5):(Total: 184.130ms, non-child: 184.130ms, % non-child: 100.00%) - BytesSent: 1.01 MB (1058683) - NetworkThroughput(*): 5.77 MB/sec - OverallThroughput: 5.48 MB/sec - PeakMemoryUsage: 187.84 KB (192352) - SerializeBatchTime: 7.889ms - ThriftTransmitTime(*): 175.119ms - UncompressedRowBatchSize: 3.55 MB (3726874) HDFS_SCAN_NODE (id=0):(Total: 170.199ms, non-child: 170.199ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 2:1/9.94 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: TEXT/NONE:1 ExecOption: Codegen enabled: 1 out of 1 BytesRead(500.0ms): 0 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 9.94 MB (10418452) - BytesReadDataNodeCache: 0 - BytesReadLocal: 9.94 MB (10418452) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 9.94 MB (10418452) - DecompressionTime: 0ns - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 12.67 MB (13280256) - PerReadThreadRawHdfsThroughput: 2.28 GB/sec - RemoteScanRanges: 0 - RowsRead: 91.76K (91759) - RowsReturned: 91.76K (91759) - RowsReturnedRate: 539.13 K/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 22.628ms - DelimiterParseTime: 13.836ms - MaterializeTupleTime(*): 1.284ms - ScannerThreadsSysTime: 1.999ms - ScannerThreadsUserTime: 12.998ms - ScannerThreadsVoluntaryContextSwitches: 3 - TotalRawHdfsReadTime(*): 4.261ms - TotalReadThroughput: 0.00 /sec Instance 9448ec37dcef4482:1b1f6848414313e6 (host=d2409.halxg.cloudera.com:22000):(Total: 360.272ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 3:1/9.94 MB MemoryUsage(500.0ms): 11.30 MB ThreadUsage(500.0ms): 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 12.80 MB (13422112) - PerHostPeakMemUsage: 30.87 MB (32368808) - PrepareTime: 170.19ms - RowsProduced: 91.76K (91757) - TotalCpuTime: 362.573ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 155.75ms - TotalStorageWaitTime: 6.696ms CodeGen:(Total: 305.879ms, non-child: 305.879ms, % non-child: 100.00%) - CodegenTime: 639.636us - CompileTime: 4.307ms - LoadTime: 130.647us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 132.216ms - PrepareTime: 167.692ms DataStreamSender (dst_id=5):(Total: 181.77ms, non-child: 181.77ms, % non-child: 100.00%) - BytesSent: 1022.62 KB (1047168) - NetworkThroughput(*): 5.78 MB/sec - OverallThroughput: 5.52 MB/sec - PeakMemoryUsage: 187.84 KB (192352) - SerializeBatchTime: 8.116ms - ThriftTransmitTime(*): 172.736ms - UncompressedRowBatchSize: 3.55 MB (3727490) HDFS_SCAN_NODE (id=0):(Total: 175.960ms, non-child: 175.960ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 3:1/9.94 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% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: TEXT/NONE:1 ExecOption: Codegen enabled: 1 out of 1 BytesRead(500.0ms): 9.94 MB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 9.94 MB (10420798) - BytesReadDataNodeCache: 0 - BytesReadLocal: 9.94 MB (10420798) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 9.94 MB (10420798) - DecompressionTime: 0ns - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 12.60 MB (13210624) - PerReadThreadRawHdfsThroughput: 2.38 GB/sec - RemoteScanRanges: 0 - RowsRead: 91.76K (91757) - RowsReturned: 91.76K (91757) - RowsReturnedRate: 521.46 K/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 22.947ms - DelimiterParseTime: 14.106ms - MaterializeTupleTime(*): 1.162ms - ScannerThreadsSysTime: 1.999ms - ScannerThreadsUserTime: 13.997ms - ScannerThreadsVoluntaryContextSwitches: 3 - TotalRawHdfsReadTime(*): 4.83ms - TotalReadThroughput: 19.88 MB/sec Instance 9448ec37dcef4482:1b1f6848414313f0 (host=d2421.halxg.cloudera.com:22000):(Total: 362.258ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 9:1/9.94 MB MemoryUsage(500.0ms): 103.91 KB ThreadUsage(500.0ms): 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 12.71 MB (13323808) - PerHostPeakMemUsage: 12.71 MB (13323808) - PrepareTime: 176.123ms - RowsProduced: 91.76K (91758) - TotalCpuTime: 371.271ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 148.513ms - TotalStorageWaitTime: 8.197ms BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 0 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 6871947776.00 GB (7378697739434983424) - PeakMemoryUsage: 0 - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 310.984ms, non-child: 310.984ms, % non-child: 100.00%) - CodegenTime: 673.633us - CompileTime: 4.341ms - LoadTime: 89.358us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 131.187ms - PrepareTime: 173.886ms DataStreamSender (dst_id=5):(Total: 175.758ms, non-child: 175.758ms, % non-child: 100.00%) - BytesSent: 1.15 MB (1205175) - NetworkThroughput(*): 7.09 MB/sec - OverallThroughput: 6.54 MB/sec - PeakMemoryUsage: 187.84 KB (192352) - SerializeBatchTime: 10.184ms - ThriftTransmitTime(*): 162.32ms - UncompressedRowBatchSize: 3.55 MB (3727054) HDFS_SCAN_NODE (id=0):(Total: 183.731ms, non-child: 183.731ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 9:1/9.94 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: TEXT/NONE:1 ExecOption: Codegen enabled: 1 out of 1 BytesRead(500.0ms): 0 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 9.94 MB (10426939) - BytesReadDataNodeCache: 0 - BytesReadLocal: 9.94 MB (10426939) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 9.94 MB (10426939) - DecompressionTime: 0ns - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 12.50 MB (13112320) - PerReadThreadRawHdfsThroughput: 2.20 GB/sec - RemoteScanRanges: 0 - RowsRead: 91.76K (91758) - RowsReturned: 91.76K (91758) - RowsReturnedRate: 499.41 K/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 1 - ScannerThreadsTotalWallClockTime: 24.797ms - DelimiterParseTime: 14.555ms - MaterializeTupleTime(*): 1.168ms - ScannerThreadsSysTime: 0ns - ScannerThreadsUserTime: 15.997ms - ScannerThreadsVoluntaryContextSwitches: 3 - TotalRawHdfsReadTime(*): 4.419ms - TotalReadThroughput: 0.00 /sec Instance 9448ec37dcef4482:1b1f6848414313e4 (host=d2401.halxg.cloudera.com:22000):(Total: 359.869ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 5:1/9.93 MB MemoryUsage(500.0ms): 0 ThreadUsage(500.0ms): 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 12.77 MB (13393440) - PerHostPeakMemUsage: 38.17 MB (40019480) - PrepareTime: 166.57ms - RowsProduced: 91.63K (91633) - TotalCpuTime: 368.530ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 157.897ms - TotalStorageWaitTime: 5.936ms CodeGen:(Total: 309.811ms, non-child: 309.811ms, % non-child: 100.00%) - CodegenTime: 636.421us - CompileTime: 4.448ms - LoadTime: 106.413us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 139.949ms - PrepareTime: 163.762ms DataStreamSender (dst_id=5):(Total: 184.587ms, non-child: 184.587ms, % non-child: 100.00%) - BytesSent: 951.70 KB (974542) - NetworkThroughput(*): 5.38 MB/sec - OverallThroughput: 5.03 MB/sec - PeakMemoryUsage: 187.84 KB (192352) - SerializeBatchTime: 7.452ms - ThriftTransmitTime(*): 172.657ms - UncompressedRowBatchSize: 3.55 MB (3723394) HDFS_SCAN_NODE (id=0):(Total: 171.305ms, non-child: 171.305ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 5:1/9.93 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: TEXT/NONE:1 ExecOption: Codegen enabled: 1 out of 1 BytesRead(500.0ms): 0 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 9.93 MB (10414160) - BytesReadDataNodeCache: 0 - BytesReadLocal: 9.93 MB (10414160) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 9.93 MB (10414160) - DecompressionTime: 0ns - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 12.57 MB (13181952) - PerReadThreadRawHdfsThroughput: 2.69 GB/sec - RemoteScanRanges: 0 - RowsRead: 91.63K (91633) - RowsReturned: 91.63K (91633) - RowsReturnedRate: 534.91 K/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 23.632ms - DelimiterParseTime: 15.167ms - MaterializeTupleTime(*): 1.523ms - ScannerThreadsSysTime: 999.0us - ScannerThreadsUserTime: 15.997ms - ScannerThreadsVoluntaryContextSwitches: 3 - TotalRawHdfsReadTime(*): 3.606ms - TotalReadThroughput: 0.00 /sec Instance 9448ec37dcef4482:1b1f6848414313ef (host=d2416.halxg.cloudera.com:22000):(Total: 402.703ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 4:1/9.93 MB 2:1/9.94 MB MemoryUsage(500.0ms): 24.87 MB ThreadUsage(500.0ms): 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 25.59 MB (26829344) - PerHostPeakMemUsage: 47.05 MB (49338240) - PrepareTime: 164.128ms - RowsProduced: 183.39K (183391) - TotalCpuTime: 395.905ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 182.132ms - TotalStorageWaitTime: 12.795ms CodeGen:(Total: 298.871ms, non-child: 298.871ms, % non-child: 100.00%) - CodegenTime: 689.154us - CompileTime: 4.248ms - LoadTime: 51.726us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 131.166ms - PrepareTime: 161.762ms DataStreamSender (dst_id=5):(Total: 229.991ms, non-child: 229.991ms, % non-child: 100.00%) - BytesSent: 1.84 MB (1933086) - NetworkThroughput(*): 8.53 MB/sec - OverallThroughput: 8.02 MB/sec - PeakMemoryUsage: 187.84 KB (192352) - SerializeBatchTime: 12.197ms - ThriftTransmitTime(*): 216.27ms - UncompressedRowBatchSize: 7.10 MB (7446713) HDFS_SCAN_NODE (id=0):(Total: 170.5ms, non-child: 170.5ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 4:1/9.93 MB 2:1/9.94 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% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: TEXT/NONE:2 ExecOption: Codegen enabled: 2 out of 2 BytesRead(500.0ms): 19.86 MB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 19.86 MB (20828367) - BytesReadDataNodeCache: 0 - BytesReadLocal: 19.86 MB (20828367) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 19.86 MB (20828367) - DecompressionTime: 0ns - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 2 - NumScannerThreadsStarted: 2 - PeakMemoryUsage: 25.38 MB (26617856) - PerReadThreadRawHdfsThroughput: 2.36 GB/sec - RemoteScanRanges: 0 - RowsRead: 183.39K (183391) - RowsReturned: 183.39K (183391) - RowsReturnedRate: 1.08 M/sec - ScanRangesComplete: 2 - ScannerThreadsInvoluntaryContextSwitches: 1 - ScannerThreadsTotalWallClockTime: 46.815ms - DelimiterParseTime: 29.105ms - MaterializeTupleTime(*): 2.687ms - ScannerThreadsSysTime: 999.0us - ScannerThreadsUserTime: 30.994ms - ScannerThreadsVoluntaryContextSwitches: 7 - TotalRawHdfsReadTime(*): 8.231ms - TotalReadThroughput: 39.73 MB/sec Instance 9448ec37dcef4482:1b1f6848414313e9 (host=d2412.halxg.cloudera.com:22000):(Total: 408.920ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 6:1/9.93 MB 9:1/9.90 MB MemoryUsage(500.0ms): 0 ThreadUsage(500.0ms): 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 25.62 MB (26861088) - PerHostPeakMemUsage: 43.73 MB (45853696) - PrepareTime: 164.974ms - RowsProduced: 183.00K (183002) - TotalCpuTime: 398.625ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 185.861ms - TotalStorageWaitTime: 11.878ms CodeGen:(Total: 300.534ms, non-child: 300.534ms, % non-child: 100.00%) - CodegenTime: 691.717us - CompileTime: 4.284ms - LoadTime: 47.986us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 132.33ms - PrepareTime: 162.674ms DataStreamSender (dst_id=5):(Total: 235.369ms, non-child: 235.369ms, % non-child: 100.00%) - BytesSent: 1.81 MB (1901775) - NetworkThroughput(*): 8.30 MB/sec - OverallThroughput: 7.71 MB/sec - PeakMemoryUsage: 187.84 KB (192352) - SerializeBatchTime: 13.357ms - ThriftTransmitTime(*): 218.488ms - UncompressedRowBatchSize: 7.09 MB (7432220) HDFS_SCAN_NODE (id=0):(Total: 170.628ms, non-child: 170.628ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 6:1/9.93 MB 9:1/9.90 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: TEXT/NONE:2 ExecOption: Codegen enabled: 2 out of 2 BytesRead(500.0ms): 0 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 19.83 MB (20791970) - BytesReadDataNodeCache: 0 - BytesReadLocal: 19.83 MB (20791970) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 19.83 MB (20791970) - DecompressionTime: 0ns - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 2 - NumScannerThreadsStarted: 2 - PeakMemoryUsage: 25.42 MB (26650624) - PerReadThreadRawHdfsThroughput: 2.19 GB/sec - RemoteScanRanges: 0 - RowsRead: 183.00K (183002) - RowsReturned: 183.00K (183002) - RowsReturnedRate: 1.07 M/sec - ScanRangesComplete: 2 - ScannerThreadsInvoluntaryContextSwitches: 1 - ScannerThreadsTotalWallClockTime: 44.964ms - DelimiterParseTime: 28.280ms - MaterializeTupleTime(*): 2.667ms - ScannerThreadsSysTime: 999.0us - ScannerThreadsUserTime: 30.994ms - ScannerThreadsVoluntaryContextSwitches: 7 - TotalRawHdfsReadTime(*): 8.847ms - TotalReadThroughput: 0.00 /sec Instance 9448ec37dcef4482:1b1f6848414313ec (host=d2404.halxg.cloudera.com:22000):(Total: 406.981ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 0:1/9.94 MB 10:1/9.92 MB MemoryUsage(500.0ms): 23.23 MB ThreadUsage(500.0ms): 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 25.62 MB (26862112) - PerHostPeakMemUsage: 43.90 MB (46029880) - PrepareTime: 165.945ms - RowsProduced: 183.39K (183389) - TotalCpuTime: 407.636ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 180.748ms - TotalStorageWaitTime: 11.185ms CodeGen:(Total: 306.797ms, non-child: 306.797ms, % non-child: 100.00%) - CodegenTime: 671.969us - CompileTime: 4.396ms - LoadTime: 67.640us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 137.131ms - PrepareTime: 163.754ms DataStreamSender (dst_id=5):(Total: 232.563ms, non-child: 232.563ms, % non-child: 100.00%) - BytesSent: 1.79 MB (1872166) - NetworkThroughput(*): 8.29 MB/sec - OverallThroughput: 7.68 MB/sec - PeakMemoryUsage: 187.84 KB (192352) - SerializeBatchTime: 13.476ms - ThriftTransmitTime(*): 215.430ms - UncompressedRowBatchSize: 7.10 MB (7449049) HDFS_SCAN_NODE (id=0):(Total: 171.297ms, non-child: 171.297ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 0:1/9.94 MB 10:1/9.92 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% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: TEXT/NONE:2 ExecOption: Codegen enabled: 2 out of 2 BytesRead(500.0ms): 19.86 MB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 19.86 MB (20826261) - BytesReadDataNodeCache: 0 - BytesReadLocal: 19.86 MB (20826261) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 19.86 MB (20826261) - DecompressionTime: 0ns - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 2 - NumScannerThreadsStarted: 2 - PeakMemoryUsage: 25.42 MB (26650624) - PerReadThreadRawHdfsThroughput: 2.55 GB/sec - RemoteScanRanges: 0 - RowsRead: 183.39K (183389) - RowsReturned: 183.39K (183389) - RowsReturnedRate: 1.07 M/sec - ScanRangesComplete: 2 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 45.507ms - DelimiterParseTime: 29.311ms - MaterializeTupleTime(*): 2.816ms - ScannerThreadsSysTime: 1.998ms - ScannerThreadsUserTime: 30.994ms - ScannerThreadsVoluntaryContextSwitches: 8 - TotalRawHdfsReadTime(*): 7.614ms - TotalReadThroughput: 39.72 MB/sec Instance 9448ec37dcef4482:1b1f6848414313f1 (host=d2403.halxg.cloudera.com:22000):(Total: 412.938ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 9:1/9.94 MB 10:1/9.93 MB MemoryUsage(500.0ms): 103.91 KB ThreadUsage(500.0ms): 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 25.62 MB (26862112) - PerHostPeakMemUsage: 43.53 MB (45641104) - PrepareTime: 168.389ms - RowsProduced: 183.39K (183388) - TotalCpuTime: 410.427ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 176.782ms - TotalStorageWaitTime: 12.387ms CodeGen:(Total: 303.700ms, non-child: 303.700ms, % non-child: 100.00%) - CodegenTime: 691.131us - CompileTime: 4.382ms - LoadTime: 105.839us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 131.612ms - PrepareTime: 166.79ms DataStreamSender (dst_id=5):(Total: 234.991ms, non-child: 234.991ms, % non-child: 100.00%) - BytesSent: 2.02 MB (2115766) - NetworkThroughput(*): 9.28 MB/sec - OverallThroughput: 8.59 MB/sec - PeakMemoryUsage: 187.84 KB (192352) - SerializeBatchTime: 14.339ms - ThriftTransmitTime(*): 217.473ms - UncompressedRowBatchSize: 7.10 MB (7448748) HDFS_SCAN_NODE (id=0):(Total: 174.418ms, non-child: 174.418ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 9:1/9.94 MB 10:1/9.93 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: TEXT/NONE:2 ExecOption: Codegen enabled: 2 out of 2 BytesRead(500.0ms): 0 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 19.87 MB (20838161) - BytesReadDataNodeCache: 0 - BytesReadLocal: 19.87 MB (20838161) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 19.87 MB (20838161) - DecompressionTime: 0ns - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 2 - NumScannerThreadsStarted: 2 - PeakMemoryUsage: 25.42 MB (26650624) - PerReadThreadRawHdfsThroughput: 2.43 GB/sec - RemoteScanRanges: 0 - RowsRead: 183.39K (183388) - RowsReturned: 183.39K (183388) - RowsReturnedRate: 1.05 M/sec - ScanRangesComplete: 2 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 44.910ms - DelimiterParseTime: 27.899ms - MaterializeTupleTime(*): 2.96ms - ScannerThreadsSysTime: 999.0us - ScannerThreadsUserTime: 30.994ms - ScannerThreadsVoluntaryContextSwitches: 9 - TotalRawHdfsReadTime(*): 7.996ms - TotalReadThroughput: 0.00 /sec Instance 9448ec37dcef4482:1b1f6848414313ea (host=d2420.halxg.cloudera.com:22000):(Total: 408.252ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 3:1/9.92 MB MemoryUsage(500.0ms): 0 ThreadUsage(500.0ms): 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 11.36 MB (11914784) - PerHostPeakMemUsage: 28.12 MB (29484144) - PrepareTime: 344.84ms - RowsProduced: 91.63K (91629) - TotalCpuTime: 735.872ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 1.730ms - TotalStorageWaitTime: 9.423ms CodeGen:(Total: 632.452ms, non-child: 632.452ms, % non-child: 100.00%) - CodegenTime: 1.268ms - CompileTime: 8.890ms - LoadTime: 168.450us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 280.757ms - PrepareTime: 339.959ms DataStreamSender (dst_id=5):(Total: 51.815ms, non-child: 51.815ms, % non-child: 100.00%) - BytesSent: 1.14 MB (1194795) - NetworkThroughput(*): 38.33 MB/sec - OverallThroughput: 21.99 MB/sec - PeakMemoryUsage: 187.84 KB (192352) - SerializeBatchTime: 15.617ms - ThriftTransmitTime(*): 29.727ms - UncompressedRowBatchSize: 3.55 MB (3721037) HDFS_SCAN_NODE (id=0):(Total: 352.434ms, non-child: 352.434ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 3:1/9.92 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: TEXT/NONE:1 ExecOption: Codegen enabled: 1 out of 1 BytesRead(500.0ms): 0 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 9.92 MB (10406238) - BytesReadDataNodeCache: 0 - BytesReadLocal: 9.92 MB (10406238) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 9.92 MB (10406238) - DecompressionTime: 0ns - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 11.16 MB (11703296) - PerReadThreadRawHdfsThroughput: 1.58 GB/sec - RemoteScanRanges: 0 - RowsRead: 91.63K (91629) - RowsReturned: 91.63K (91629) - RowsReturnedRate: 259.99 K/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 40.977ms - DelimiterParseTime: 28.940ms - MaterializeTupleTime(*): 1.498ms - ScannerThreadsSysTime: 0ns - ScannerThreadsUserTime: 30.995ms - ScannerThreadsVoluntaryContextSwitches: 2 - TotalRawHdfsReadTime(*): 6.140ms - TotalReadThroughput: 0.00 /sec Fragment F00: Instance 9448ec37dcef4482:1b1f6848414313fa (host=d2411.halxg.cloudera.com:22000):(Total: 50.160ms, non-child: 2.388ms, % non-child: 4.76%) Hdfs split stats (:<# splits>/): 4:1/10.22 MB - AverageThreadTokens: 0.00 - PeakMemoryUsage: 5.30 MB (5559024) - PerHostPeakMemUsage: 30.63 MB (32121536) - PrepareTime: 68.914us - RowsProduced: 183.52K (183517) - TotalCpuTime: 66.24ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3.18ms - TotalStorageWaitTime: 2.318ms DataStreamSender (dst_id=4):(Total: 44.379ms, non-child: 44.379ms, % non-child: 100.00%) - BytesSent: 2.34 MB (2458030) - NetworkThroughput(*): 36.69 MB/sec - OverallThroughput: 52.82 MB/sec - PeakMemoryUsage: 650.03 KB (665632) - SerializeBatchTime: 19.663ms - ThriftTransmitTime(*): 63.897ms - UncompressedRowBatchSize: 6.37 MB (6678760) HDFS_SCAN_NODE (id=1):(Total: 3.391ms, non-child: 3.391ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 4:1/10.22 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: PARQUET/SNAPPY:1 ExecOption: Codegen enabled: 0 out of 1 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 287.81 KB (294715) - BytesReadDataNodeCache: 0 - BytesReadLocal: 287.81 KB (294715) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 287.81 KB (294715) - DecompressionTime: 83.7us - MaxCompressedTextFileLength: 0 - NumColumns: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 4.75 MB (4983376) - PerReadThreadRawHdfsThroughput: 827.97 MB/sec - RemoteScanRanges: 0 - RowsRead: 183.52K (183517) - RowsReturned: 183.52K (183517) - RowsReturnedRate: 54.11 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 14.590ms - MaterializeTupleTime(*): 11.689ms - ScannerThreadsSysTime: 2.999ms - ScannerThreadsUserTime: 8.998ms - ScannerThreadsVoluntaryContextSwitches: 4 - TotalRawHdfsReadTime(*): 339.458us - TotalReadThroughput: 0.00 /sec Instance 9448ec37dcef4482:1b1f6848414313f7 (host=d2409.halxg.cloudera.com:22000):(Total: 51.199ms, non-child: 2.374ms, % non-child: 4.64%) Hdfs split stats (:<# splits>/): 0:1/10.22 MB - AverageThreadTokens: 0.00 - PeakMemoryUsage: 5.15 MB (5395344) - PerHostPeakMemUsage: 30.87 MB (32368808) - PrepareTime: 72.797us - RowsProduced: 183.52K (183517) - TotalCpuTime: 68.913ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3.238ms - TotalStorageWaitTime: 2.400ms DataStreamSender (dst_id=4):(Total: 45.244ms, non-child: 45.244ms, % non-child: 100.00%) - BytesSent: 2.34 MB (2453887) - NetworkThroughput(*): 34.37 MB/sec - OverallThroughput: 51.72 MB/sec - PeakMemoryUsage: 650.03 KB (665632) - SerializeBatchTime: 19.604ms - ThriftTransmitTime(*): 68.89ms - UncompressedRowBatchSize: 6.37 MB (6681315) HDFS_SCAN_NODE (id=1):(Total: 3.580ms, non-child: 3.580ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 0:1/10.22 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: PARQUET/SNAPPY:1 ExecOption: Codegen enabled: 0 out of 1 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 287.74 KB (294641) - BytesReadDataNodeCache: 0 - BytesReadLocal: 287.74 KB (294641) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 287.74 KB (294641) - DecompressionTime: 82.549us - MaxCompressedTextFileLength: 0 - NumColumns: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 4.66 MB (4885168) - PerReadThreadRawHdfsThroughput: 811.54 MB/sec - RemoteScanRanges: 0 - RowsRead: 183.52K (183517) - RowsReturned: 183.52K (183517) - RowsReturnedRate: 51.26 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 1 - ScannerThreadsTotalWallClockTime: 15.896ms - MaterializeTupleTime(*): 12.838ms - ScannerThreadsSysTime: 999.0us - ScannerThreadsUserTime: 10.998ms - ScannerThreadsVoluntaryContextSwitches: 4 - TotalRawHdfsReadTime(*): 346.246us - TotalReadThroughput: 0.00 /sec Instance 9448ec37dcef4482:1b1f6848414313fc (host=d2402.halxg.cloudera.com:22000):(Total: 51.235ms, non-child: 2.518ms, % non-child: 4.92%) Hdfs split stats (:<# splits>/): 1:1/10.20 MB - AverageThreadTokens: 0.00 - PeakMemoryUsage: 5.12 MB (5373232) - PerHostPeakMemUsage: 30.83 MB (32327800) - PrepareTime: 73.189us - RowsProduced: 183.26K (183259) - TotalCpuTime: 68.874ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 2.876ms - TotalStorageWaitTime: 2.518ms DataStreamSender (dst_id=4):(Total: 45.74ms, non-child: 45.74ms, % non-child: 100.00%) - BytesSent: 2.36 MB (2472228) - NetworkThroughput(*): 37.19 MB/sec - OverallThroughput: 52.31 MB/sec - PeakMemoryUsage: 650.03 KB (665632) - SerializeBatchTime: 20.364ms - ThriftTransmitTime(*): 63.396ms - UncompressedRowBatchSize: 6.37 MB (6675147) HDFS_SCAN_NODE (id=1):(Total: 3.642ms, non-child: 3.642ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 1:1/10.20 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: PARQUET/SNAPPY:1 ExecOption: Codegen enabled: 0 out of 1 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 287.51 KB (294406) - BytesReadDataNodeCache: 0 - BytesReadLocal: 287.51 KB (294406) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 287.51 KB (294406) - DecompressionTime: 156.533us - MaxCompressedTextFileLength: 0 - NumColumns: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 4.53 MB (4753936) - PerReadThreadRawHdfsThroughput: 809.38 MB/sec - RemoteScanRanges: 0 - RowsRead: 183.26K (183259) - RowsReturned: 183.26K (183259) - RowsReturnedRate: 50.31 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 1 - ScannerThreadsTotalWallClockTime: 16.260ms - MaterializeTupleTime(*): 13.121ms - ScannerThreadsSysTime: 4.999ms - ScannerThreadsUserTime: 7.998ms - ScannerThreadsVoluntaryContextSwitches: 4 - TotalRawHdfsReadTime(*): 346.894us - TotalReadThroughput: 0.00 /sec Instance 9448ec37dcef4482:1b1f6848414313f8 (host=d2419.halxg.cloudera.com:22000):(Total: 51.707ms, non-child: 2.442ms, % non-child: 4.72%) Hdfs split stats (:<# splits>/): 2:1/10.21 MB - AverageThreadTokens: 0.00 - PeakMemoryUsage: 5.02 MB (5263704) - PerHostPeakMemUsage: 36.85 MB (38641648) - PrepareTime: 67.118us - RowsProduced: 183.26K (183260) - TotalCpuTime: 70.204ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3.207ms - TotalStorageWaitTime: 2.488ms DataStreamSender (dst_id=4):(Total: 45.566ms, non-child: 45.566ms, % non-child: 100.00%) - BytesSent: 2.39 MB (2505147) - NetworkThroughput(*): 34.85 MB/sec - OverallThroughput: 52.43 MB/sec - PeakMemoryUsage: 650.03 KB (665632) - SerializeBatchTime: 20.483ms - ThriftTransmitTime(*): 68.555ms - UncompressedRowBatchSize: 6.36 MB (6673220) HDFS_SCAN_NODE (id=1):(Total: 3.698ms, non-child: 3.698ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 2:1/10.21 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: PARQUET/SNAPPY:1 ExecOption: Codegen enabled: 0 out of 1 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 287.46 KB (294361) - BytesReadDataNodeCache: 0 - BytesReadLocal: 287.46 KB (294361) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 287.46 KB (294361) - DecompressionTime: 221.975us - MaxCompressedTextFileLength: 0 - NumColumns: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 4.47 MB (4688056) - PerReadThreadRawHdfsThroughput: 785.29 MB/sec - RemoteScanRanges: 0 - RowsRead: 183.26K (183260) - RowsReturned: 183.26K (183260) - RowsReturnedRate: 49.55 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 1 - ScannerThreadsTotalWallClockTime: 17.111ms - MaterializeTupleTime(*): 13.853ms - ScannerThreadsSysTime: 5.999ms - ScannerThreadsUserTime: 7.998ms - ScannerThreadsVoluntaryContextSwitches: 3 - TotalRawHdfsReadTime(*): 357.477us - TotalReadThroughput: 0.00 /sec Instance 9448ec37dcef4482:1b1f6848414313fd (host=d2403.halxg.cloudera.com:22000):(Total: 51.407ms, non-child: 2.720ms, % non-child: 5.29%) Hdfs split stats (:<# splits>/): 10:1/10.22 MB - AverageThreadTokens: 0.00 - PeakMemoryUsage: 5.45 MB (5711816) - PerHostPeakMemUsage: 43.53 MB (45641104) - PrepareTime: 139.712us - RowsProduced: 183.52K (183517) - TotalCpuTime: 66.699ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3.241ms - TotalStorageWaitTime: 2.333ms DataStreamSender (dst_id=4):(Total: 45.87ms, non-child: 45.87ms, % non-child: 100.00%) - BytesSent: 2.46 MB (2583151) - NetworkThroughput(*): 38.37 MB/sec - OverallThroughput: 54.64 MB/sec - PeakMemoryUsage: 650.03 KB (665632) - SerializeBatchTime: 20.766ms - ThriftTransmitTime(*): 64.201ms - UncompressedRowBatchSize: 6.37 MB (6681783) HDFS_SCAN_NODE (id=1):(Total: 3.598ms, non-child: 3.598ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 10:1/10.22 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: PARQUET/SNAPPY:1 ExecOption: Codegen enabled: 0 out of 1 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 287.71 KB (294616) - BytesReadDataNodeCache: 0 - BytesReadLocal: 287.71 KB (294616) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 287.71 KB (294616) - DecompressionTime: 122.615us - MaxCompressedTextFileLength: 0 - NumColumns: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 4.81 MB (5048872) - PerReadThreadRawHdfsThroughput: 839.53 MB/sec - RemoteScanRanges: 0 - RowsRead: 183.52K (183517) - RowsReturned: 183.52K (183517) - RowsReturnedRate: 50.99 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 13.732ms - MaterializeTupleTime(*): 10.779ms - ScannerThreadsSysTime: 1.999ms - ScannerThreadsUserTime: 7.998ms - ScannerThreadsVoluntaryContextSwitches: 5 - TotalRawHdfsReadTime(*): 334.672us - TotalReadThroughput: 0.00 /sec Instance 9448ec37dcef4482:1b1f6848414313fe (host=d2408.halxg.cloudera.com:22000):(Total: 51.929ms, non-child: 3.315ms, % non-child: 6.39%) Hdfs split stats (:<# splits>/): 10:1/10.21 MB MemoryUsage(500.0ms): 1.02 MB ThreadUsage(500.0ms): 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 5.27 MB (5526072) - PerHostPeakMemUsage: 19.01 MB (19934200) - PrepareTime: 67.530us - RowsProduced: 183.26K (183260) - TotalCpuTime: 68.748ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3.236ms - TotalStorageWaitTime: 2.982ms DataStreamSender (dst_id=4):(Total: 44.383ms, non-child: 44.383ms, % non-child: 100.00%) - BytesSent: 2.47 MB (2589625) - NetworkThroughput(*): 36.46 MB/sec - OverallThroughput: 55.64 MB/sec - PeakMemoryUsage: 650.03 KB (665632) - SerializeBatchTime: 21.29ms - ThriftTransmitTime(*): 67.736ms - UncompressedRowBatchSize: 6.36 MB (6672374) HDFS_SCAN_NODE (id=1):(Total: 4.229ms, non-child: 4.229ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 10:1/10.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% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: PARQUET/SNAPPY:1 ExecOption: Codegen enabled: 0 out of 1 BytesRead(500.0ms): 287.47 KB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 287.47 KB (294365) - BytesReadDataNodeCache: 0 - BytesReadLocal: 287.47 KB (294365) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 287.47 KB (294365) - DecompressionTime: 135.859us - MaxCompressedTextFileLength: 0 - NumColumns: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 4.72 MB (4950424) - PerReadThreadRawHdfsThroughput: 752.17 MB/sec - RemoteScanRanges: 0 - RowsRead: 183.26K (183260) - RowsReturned: 183.26K (183260) - RowsReturnedRate: 43.33 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 3 - ScannerThreadsTotalWallClockTime: 15.921ms - MaterializeTupleTime(*): 12.185ms - ScannerThreadsSysTime: 0ns - ScannerThreadsUserTime: 11.998ms - ScannerThreadsVoluntaryContextSwitches: 5 - TotalRawHdfsReadTime(*): 373.227us - TotalReadThroughput: 574.93 KB/sec Instance 9448ec37dcef4482:1b1f684841431401 (host=d2412.halxg.cloudera.com:22000):(Total: 52.1ms, non-child: 3.171ms, % non-child: 6.10%) Hdfs split stats (:<# splits>/): 2:1/10.21 MB - AverageThreadTokens: 0.00 - PeakMemoryUsage: 5.40 MB (5657168) - PerHostPeakMemUsage: 43.73 MB (45853696) - PrepareTime: 77.27us - RowsProduced: 183.26K (183260) - TotalCpuTime: 68.256ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3.299ms - TotalStorageWaitTime: 2.461ms DataStreamSender (dst_id=4):(Total: 45.276ms, non-child: 45.276ms, % non-child: 100.00%) - BytesSent: 2.35 MB (2460255) - NetworkThroughput(*): 36.60 MB/sec - OverallThroughput: 51.82 MB/sec - PeakMemoryUsage: 650.03 KB (665632) - SerializeBatchTime: 20.116ms - ThriftTransmitTime(*): 64.100ms - UncompressedRowBatchSize: 6.36 MB (6670800) HDFS_SCAN_NODE (id=1):(Total: 3.554ms, non-child: 3.554ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 2:1/10.21 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: PARQUET/SNAPPY:1 ExecOption: Codegen enabled: 0 out of 1 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 287.52 KB (294425) - BytesReadDataNodeCache: 0 - BytesReadLocal: 287.52 KB (294425) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 287.52 KB (294425) - DecompressionTime: 169.952us - MaxCompressedTextFileLength: 0 - NumColumns: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 4.78 MB (5016048) - PerReadThreadRawHdfsThroughput: 816.26 MB/sec - RemoteScanRanges: 0 - RowsRead: 183.26K (183260) - RowsReturned: 183.26K (183260) - RowsReturnedRate: 51.56 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 14.762ms - MaterializeTupleTime(*): 11.636ms - ScannerThreadsSysTime: 5.999ms - ScannerThreadsUserTime: 4.999ms - ScannerThreadsVoluntaryContextSwitches: 5 - TotalRawHdfsReadTime(*): 343.991us - TotalReadThroughput: 0.00 /sec Instance 9448ec37dcef4482:1b1f684841431402 (host=d2410.halxg.cloudera.com:22000):(Total: 51.213ms, non-child: 2.975ms, % non-child: 5.81%) Hdfs split stats (:<# splits>/): 6:1/10.21 MB - AverageThreadTokens: 0.00 - PeakMemoryUsage: 5.07 MB (5318584) - PerHostPeakMemUsage: 32.56 MB (34138456) - PrepareTime: 66.793us - RowsProduced: 183.26K (183260) - TotalCpuTime: 68.772ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3.928ms - TotalStorageWaitTime: 2.441ms DataStreamSender (dst_id=4):(Total: 44.558ms, non-child: 44.558ms, % non-child: 100.00%) - BytesSent: 2.32 MB (2427598) - NetworkThroughput(*): 36.80 MB/sec - OverallThroughput: 51.96 MB/sec - PeakMemoryUsage: 650.03 KB (665632) - SerializeBatchTime: 19.700ms - ThriftTransmitTime(*): 62.917ms - UncompressedRowBatchSize: 6.36 MB (6670899) HDFS_SCAN_NODE (id=1):(Total: 3.680ms, non-child: 3.680ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 6:1/10.21 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: PARQUET/SNAPPY:1 ExecOption: Codegen enabled: 0 out of 1 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 287.57 KB (294472) - BytesReadDataNodeCache: 0 - BytesReadLocal: 287.57 KB (294472) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 287.57 KB (294472) - DecompressionTime: 96.259us - MaxCompressedTextFileLength: 0 - NumColumns: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 4.60 MB (4819352) - PerReadThreadRawHdfsThroughput: 774.36 MB/sec - RemoteScanRanges: 0 - RowsRead: 183.26K (183260) - RowsReturned: 183.26K (183260) - RowsReturnedRate: 49.80 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 15.818ms - MaterializeTupleTime(*): 12.687ms - ScannerThreadsSysTime: 2.999ms - ScannerThreadsUserTime: 8.998ms - ScannerThreadsVoluntaryContextSwitches: 4 - TotalRawHdfsReadTime(*): 362.659us - TotalReadThroughput: 0.00 /sec Instance 9448ec37dcef4482:1b1f684841431404 (host=d2404.halxg.cloudera.com:22000):(Total: 50.890ms, non-child: 2.152ms, % non-child: 4.23%) Hdfs split stats (:<# splits>/): 7:1/10.22 MB - AverageThreadTokens: 0.00 - PeakMemoryUsage: 5.03 MB (5275136) - PerHostPeakMemUsage: 43.90 MB (46029880) - PrepareTime: 73.750us - RowsProduced: 183.52K (183517) - TotalCpuTime: 70.104ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3.379ms - TotalStorageWaitTime: 2.462ms DataStreamSender (dst_id=4):(Total: 44.941ms, non-child: 44.941ms, % non-child: 100.00%) - BytesSent: 2.37 MB (2483100) - NetworkThroughput(*): 36.42 MB/sec - OverallThroughput: 52.69 MB/sec - PeakMemoryUsage: 650.03 KB (665632) - SerializeBatchTime: 20.283ms - ThriftTransmitTime(*): 65.27ms - UncompressedRowBatchSize: 6.37 MB (6683203) HDFS_SCAN_NODE (id=1):(Total: 3.796ms, non-child: 3.796ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 7:1/10.22 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: PARQUET/SNAPPY:1 ExecOption: Codegen enabled: 0 out of 1 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 287.77 KB (294672) - BytesReadDataNodeCache: 0 - BytesReadLocal: 287.77 KB (294672) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 287.77 KB (294672) - DecompressionTime: 83.923us - MaxCompressedTextFileLength: 0 - NumColumns: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 4.50 MB (4721312) - PerReadThreadRawHdfsThroughput: 812.55 MB/sec - RemoteScanRanges: 0 - RowsRead: 183.52K (183517) - RowsReturned: 183.52K (183517) - RowsReturnedRate: 48.34 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 4 - ScannerThreadsTotalWallClockTime: 16.657ms - MaterializeTupleTime(*): 13.416ms - ScannerThreadsSysTime: 2.999ms - ScannerThreadsUserTime: 9.998ms - ScannerThreadsVoluntaryContextSwitches: 3 - TotalRawHdfsReadTime(*): 345.850us - TotalReadThroughput: 0.00 /sec Instance 9448ec37dcef4482:1b1f684841431406 (host=d2414.halxg.cloudera.com:22000):(Total: 55.230ms, non-child: 2.70ms, % non-child: 3.75%) Hdfs split stats (:<# splits>/): 7:1/10.21 MB MemoryUsage(500.0ms): 2.07 MB ThreadUsage(500.0ms): 2 - AverageThreadTokens: 2.00 - PeakMemoryUsage: 5.41 MB (5668000) - PerHostPeakMemUsage: 32.42 MB (33993784) - PrepareTime: 116.595us - RowsProduced: 183.26K (183260) - TotalCpuTime: 71.894ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 2.980ms - TotalStorageWaitTime: 2.353ms DataStreamSender (dst_id=4):(Total: 49.415ms, non-child: 49.415ms, % non-child: 100.00%) - BytesSent: 2.34 MB (2458709) - NetworkThroughput(*): 35.75 MB/sec - OverallThroughput: 47.45 MB/sec - PeakMemoryUsage: 671.34 KB (687456) - SerializeBatchTime: 21.865ms - ThriftTransmitTime(*): 65.597ms - UncompressedRowBatchSize: 6.37 MB (6675080) HDFS_SCAN_NODE (id=1):(Total: 3.745ms, non-child: 3.745ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 7:1/10.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% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: PARQUET/SNAPPY:1 ExecOption: Codegen enabled: 0 out of 1 BytesRead(500.0ms): 287.50 KB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 1.00 - BytesRead: 287.50 KB (294401) - BytesReadDataNodeCache: 0 - BytesReadLocal: 287.50 KB (294401) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 287.50 KB (294401) - DecompressionTime: 97.10us - MaxCompressedTextFileLength: 0 - NumColumns: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 4.81 MB (5048704) - PerReadThreadRawHdfsThroughput: 675.66 MB/sec - RemoteScanRanges: 0 - RowsRead: 183.26K (183260) - RowsReturned: 183.26K (183260) - RowsReturnedRate: 48.93 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 2 - ScannerThreadsTotalWallClockTime: 14.963ms - MaterializeTupleTime(*): 11.918ms - ScannerThreadsSysTime: 999.0us - ScannerThreadsUserTime: 10.998ms - ScannerThreadsVoluntaryContextSwitches: 4 - TotalRawHdfsReadTime(*): 415.541us - TotalReadThroughput: 575.00 KB/sec Instance 9448ec37dcef4482:1b1f6848414313f5 (host=d2406.halxg.cloudera.com:22000):(Total: 59.308ms, non-child: 2.520ms, % non-child: 4.25%) Hdfs split stats (:<# splits>/): 5:1/10.21 MB - AverageThreadTokens: 0.00 - PeakMemoryUsage: 5.43 MB (5689856) - PerHostPeakMemUsage: 31.13 MB (32640864) - PrepareTime: 118.367us - RowsProduced: 183.26K (183260) - TotalCpuTime: 77.79ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 2.687ms - TotalStorageWaitTime: 2.433ms DataStreamSender (dst_id=4):(Total: 53.45ms, non-child: 53.45ms, % non-child: 100.00%) - BytesSent: 2.33 MB (2446601) - NetworkThroughput(*): 36.97 MB/sec - OverallThroughput: 43.99 MB/sec - PeakMemoryUsage: 650.03 KB (665632) - SerializeBatchTime: 22.672ms - ThriftTransmitTime(*): 63.113ms - UncompressedRowBatchSize: 6.36 MB (6671778) HDFS_SCAN_NODE (id=1):(Total: 3.742ms, non-child: 3.742ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 5:1/10.21 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: PARQUET/SNAPPY:1 ExecOption: Codegen enabled: 0 out of 1 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 287.47 KB (294370) - BytesReadDataNodeCache: 0 - BytesReadLocal: 287.47 KB (294370) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 287.47 KB (294370) - DecompressionTime: 115.904us - MaxCompressedTextFileLength: 0 - NumColumns: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 4.81 MB (5048736) - PerReadThreadRawHdfsThroughput: 819.81 MB/sec - RemoteScanRanges: 0 - RowsRead: 183.26K (183260) - RowsReturned: 183.26K (183260) - RowsReturnedRate: 48.96 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 1 - ScannerThreadsTotalWallClockTime: 15.935ms - MaterializeTupleTime(*): 12.928ms - ScannerThreadsSysTime: 2.999ms - ScannerThreadsUserTime: 8.998ms - ScannerThreadsVoluntaryContextSwitches: 4 - TotalRawHdfsReadTime(*): 342.438us - TotalReadThroughput: 0.00 /sec Instance 9448ec37dcef4482:1b1f684841431405 (host=d2416.halxg.cloudera.com:22000):(Total: 56.681ms, non-child: 2.639ms, % non-child: 4.66%) Hdfs split stats (:<# splits>/): 3:1/10.21 MB MemoryUsage(500.0ms): 2.29 MB ThreadUsage(500.0ms): 2 - AverageThreadTokens: 2.00 - PeakMemoryUsage: 5.19 MB (5438648) - PerHostPeakMemUsage: 46.48 MB (48735576) - PrepareTime: 73.131us - RowsProduced: 183.26K (183260) - TotalCpuTime: 74.934ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3.62ms - TotalStorageWaitTime: 2.541ms DataStreamSender (dst_id=4):(Total: 50.281ms, non-child: 50.281ms, % non-child: 100.00%) - BytesSent: 2.35 MB (2466865) - NetworkThroughput(*): 38.18 MB/sec - OverallThroughput: 46.79 MB/sec - PeakMemoryUsage: 650.03 KB (665632) - SerializeBatchTime: 22.187ms - ThriftTransmitTime(*): 61.620ms - UncompressedRowBatchSize: 6.36 MB (6673849) HDFS_SCAN_NODE (id=1):(Total: 3.760ms, non-child: 3.760ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 3:1/10.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% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: PARQUET/SNAPPY:1 ExecOption: Codegen enabled: 0 out of 1 BytesRead(500.0ms): 287.43 KB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 1.00 - BytesRead: 287.43 KB (294329) - BytesReadDataNodeCache: 0 - BytesReadLocal: 287.43 KB (294329) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 287.43 KB (294329) - DecompressionTime: 94.939us - MaxCompressedTextFileLength: 0 - NumColumns: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 4.67 MB (4893016) - PerReadThreadRawHdfsThroughput: 546.04 MB/sec - RemoteScanRanges: 0 - RowsRead: 183.26K (183260) - RowsReturned: 183.26K (183260) - RowsReturnedRate: 48.73 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 16.776ms - MaterializeTupleTime(*): 13.609ms - ScannerThreadsSysTime: 2.999ms - ScannerThreadsUserTime: 10.998ms - ScannerThreadsVoluntaryContextSwitches: 5 - TotalRawHdfsReadTime(*): 514.56us - TotalReadThroughput: 574.86 KB/sec Instance 9448ec37dcef4482:1b1f684841431400 (host=d2407.halxg.cloudera.com:22000):(Total: 58.448ms, non-child: 2.278ms, % non-child: 3.90%) Hdfs split stats (:<# splits>/): 9:1/10.22 MB - AverageThreadTokens: 0.00 - PeakMemoryUsage: 5.60 MB (5875976) - PerHostPeakMemUsage: 31.30 MB (32821984) - PrepareTime: 75.45us - RowsProduced: 183.52K (183517) - TotalCpuTime: 75.414ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 2.873ms - TotalStorageWaitTime: 2.298ms DataStreamSender (dst_id=4):(Total: 52.654ms, non-child: 52.654ms, % non-child: 100.00%) - BytesSent: 2.38 MB (2492881) - NetworkThroughput(*): 37.02 MB/sec - OverallThroughput: 45.15 MB/sec - PeakMemoryUsage: 671.34 KB (687456) - SerializeBatchTime: 23.332ms - ThriftTransmitTime(*): 64.218ms - UncompressedRowBatchSize: 6.37 MB (6682224) HDFS_SCAN_NODE (id=1):(Total: 3.516ms, non-child: 3.516ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 9:1/10.22 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: PARQUET/SNAPPY:1 ExecOption: Codegen enabled: 0 out of 1 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 287.67 KB (294570) - BytesReadDataNodeCache: 0 - BytesReadLocal: 287.67 KB (294570) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 287.67 KB (294570) - DecompressionTime: 105.523us - MaxCompressedTextFileLength: 0 - NumColumns: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 5.10 MB (5343976) - PerReadThreadRawHdfsThroughput: 800.24 MB/sec - RemoteScanRanges: 0 - RowsRead: 183.52K (183517) - RowsReturned: 183.52K (183517) - RowsReturnedRate: 52.19 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 1 - ScannerThreadsTotalWallClockTime: 15.255ms - MaterializeTupleTime(*): 12.382ms - ScannerThreadsSysTime: 2.999ms - ScannerThreadsUserTime: 8.998ms - ScannerThreadsVoluntaryContextSwitches: 4 - TotalRawHdfsReadTime(*): 351.48us - TotalReadThroughput: 0.00 /sec Instance 9448ec37dcef4482:1b1f6848414313fb (host=d2417.halxg.cloudera.com:22000):(Total: 64.25ms, non-child: 2.484ms, % non-child: 3.88%) Hdfs split stats (:<# splits>/): 10:1/10.22 MB - AverageThreadTokens: 0.00 - PeakMemoryUsage: 4.69 MB (4914544) - PerHostPeakMemUsage: 586.91 MB (615419728) - PrepareTime: 69.891us - RowsProduced: 183.52K (183517) - TotalCpuTime: 90.586ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3.222ms - TotalStorageWaitTime: 2.626ms DataStreamSender (dst_id=4):(Total: 56.987ms, non-child: 56.987ms, % non-child: 100.00%) - BytesSent: 2.33 MB (2444353) - NetworkThroughput(*): 35.00 MB/sec - OverallThroughput: 40.91 MB/sec - PeakMemoryUsage: 650.03 KB (665632) - SerializeBatchTime: 24.288ms - ThriftTransmitTime(*): 66.607ms - UncompressedRowBatchSize: 6.37 MB (6682770) HDFS_SCAN_NODE (id=1):(Total: 4.552ms, non-child: 4.552ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 10:1/10.22 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: PARQUET/SNAPPY:1 ExecOption: Codegen enabled: 0 out of 1 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 287.73 KB (294634) - BytesReadDataNodeCache: 0 - BytesReadLocal: 287.73 KB (294634) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 287.73 KB (294634) - DecompressionTime: 177.906us - MaxCompressedTextFileLength: 0 - NumColumns: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 4.10 MB (4295248) - PerReadThreadRawHdfsThroughput: 684.97 MB/sec - RemoteScanRanges: 0 - RowsRead: 183.52K (183517) - RowsReturned: 183.52K (183517) - RowsReturnedRate: 40.31 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 6 - ScannerThreadsTotalWallClockTime: 24.889ms - MaterializeTupleTime(*): 21.209ms - ScannerThreadsSysTime: 7.998ms - ScannerThreadsUserTime: 12.998ms - ScannerThreadsVoluntaryContextSwitches: 4 - TotalRawHdfsReadTime(*): 410.217us - TotalReadThroughput: 0.00 /sec Instance 9448ec37dcef4482:1b1f6848414313ff (host=d2415.halxg.cloudera.com:22000):(Total: 97.402ms, non-child: 3.364ms, % non-child: 3.45%) Hdfs split stats (:<# splits>/): 6:1/10.22 MB 4:1/10.20 MB - AverageThreadTokens: 0.00 - PeakMemoryUsage: 9.41 MB (9864712) - PerHostPeakMemUsage: 26.80 MB (28102960) - PrepareTime: 81.130us - RowsProduced: 366.78K (366777) - TotalCpuTime: 155.630ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3.53ms - TotalStorageWaitTime: 6.185ms DataStreamSender (dst_id=4):(Total: 89.42ms, non-child: 89.42ms, % non-child: 100.00%) - BytesSent: 4.75 MB (4979773) - NetworkThroughput(*): 41.63 MB/sec - OverallThroughput: 53.34 MB/sec - PeakMemoryUsage: 671.34 KB (687456) - SerializeBatchTime: 39.794ms - ThriftTransmitTime(*): 114.79ms - UncompressedRowBatchSize: 12.74 MB (13356060) HDFS_SCAN_NODE (id=1):(Total: 4.995ms, non-child: 4.995ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 6:1/10.22 MB 4:1/10.20 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: PARQUET/SNAPPY:2 ExecOption: Codegen enabled: 0 out of 2 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 575.12 KB (588920) - BytesReadDataNodeCache: 0 - BytesReadLocal: 575.12 KB (588920) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 575.12 KB (588920) - DecompressionTime: 276.797us - MaxCompressedTextFileLength: 0 - NumColumns: 0 - NumDisksAccessed: 2 - NumScannerThreadsStarted: 2 - PeakMemoryUsage: 8.75 MB (9179944) - PerReadThreadRawHdfsThroughput: 765.70 MB/sec - RemoteScanRanges: 0 - RowsRead: 366.78K (366777) - RowsReturned: 366.78K (366777) - RowsReturnedRate: 73.42 M/sec - ScanRangesComplete: 2 - ScannerThreadsInvoluntaryContextSwitches: 4 - ScannerThreadsTotalWallClockTime: 60.278ms - MaterializeTupleTime(*): 52.19ms - ScannerThreadsSysTime: 5.998ms - ScannerThreadsUserTime: 23.996ms - ScannerThreadsVoluntaryContextSwitches: 81 - TotalRawHdfsReadTime(*): 733.500us - TotalReadThroughput: 0.00 /sec Instance 9448ec37dcef4482:1b1f6848414313f9 (host=d2401.halxg.cloudera.com:22000):(Total: 108.229ms, non-child: 3.240ms, % non-child: 2.99%) Hdfs split stats (:<# splits>/): 10:1/10.20 MB 0:1/10.21 MB - AverageThreadTokens: 0.00 - PeakMemoryUsage: 9.41 MB (9864376) - PerHostPeakMemUsage: 38.17 MB (40019480) - PrepareTime: 119.813us - RowsProduced: 366.26K (366263) - TotalCpuTime: 173.787ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3.648ms - TotalStorageWaitTime: 5.660ms DataStreamSender (dst_id=4):(Total: 100.356ms, non-child: 100.356ms, % non-child: 100.00%) - BytesSent: 4.65 MB (4872202) - NetworkThroughput(*): 39.90 MB/sec - OverallThroughput: 46.30 MB/sec - PeakMemoryUsage: 671.34 KB (687456) - SerializeBatchTime: 43.316ms - ThriftTransmitTime(*): 116.460ms - UncompressedRowBatchSize: 12.72 MB (13336395) HDFS_SCAN_NODE (id=1):(Total: 4.631ms, non-child: 4.631ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 10:1/10.20 MB 0:1/10.21 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: PARQUET/SNAPPY:2 ExecOption: Codegen enabled: 0 out of 2 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 574.77 KB (588566) - BytesReadDataNodeCache: 0 - BytesReadLocal: 574.77 KB (588566) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 574.77 KB (588566) - DecompressionTime: 282.145us - MaxCompressedTextFileLength: 0 - NumColumns: 0 - NumDisksAccessed: 2 - NumScannerThreadsStarted: 2 - PeakMemoryUsage: 8.75 MB (9179608) - PerReadThreadRawHdfsThroughput: 776.51 MB/sec - RemoteScanRanges: 0 - RowsRead: 366.26K (366263) - RowsReturned: 366.26K (366263) - RowsReturnedRate: 79.08 M/sec - ScanRangesComplete: 2 - ScannerThreadsInvoluntaryContextSwitches: 1 - ScannerThreadsTotalWallClockTime: 66.526ms - MaterializeTupleTime(*): 58.494ms - ScannerThreadsSysTime: 9.998ms - ScannerThreadsUserTime: 14.996ms - ScannerThreadsVoluntaryContextSwitches: 90 - TotalRawHdfsReadTime(*): 722.854us - TotalReadThroughput: 0.00 /sec Instance 9448ec37dcef4482:1b1f6848414313f6 (host=d2413.halxg.cloudera.com:22000):(Total: 110.238ms, non-child: 2.798ms, % non-child: 2.54%) Hdfs split stats (:<# splits>/): 3:1/10.21 MB 0:1/10.19 MB - AverageThreadTokens: 0.00 - PeakMemoryUsage: 9.39 MB (9842632) - PerHostPeakMemUsage: 38.32 MB (40179976) - PrepareTime: 113.195us - RowsProduced: 366.26K (366262) - TotalCpuTime: 183.700ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3.189ms - TotalStorageWaitTime: 4.976ms DataStreamSender (dst_id=4):(Total: 102.778ms, non-child: 102.778ms, % non-child: 100.00%) - BytesSent: 4.62 MB (4840836) - NetworkThroughput(*): 41.67 MB/sec - OverallThroughput: 44.92 MB/sec - PeakMemoryUsage: 671.34 KB (687456) - SerializeBatchTime: 44.607ms - ThriftTransmitTime(*): 110.795ms - UncompressedRowBatchSize: 12.72 MB (13335508) HDFS_SCAN_NODE (id=1):(Total: 4.661ms, non-child: 4.661ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 3:1/10.21 MB 0:1/10.19 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: PARQUET/SNAPPY:2 ExecOption: Codegen enabled: 0 out of 2 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 574.71 KB (588504) - BytesReadDataNodeCache: 0 - BytesReadLocal: 574.71 KB (588504) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 574.71 KB (588504) - DecompressionTime: 227.300us - MaxCompressedTextFileLength: 0 - NumColumns: 0 - NumDisksAccessed: 2 - NumScannerThreadsStarted: 2 - PeakMemoryUsage: 8.75 MB (9179688) - PerReadThreadRawHdfsThroughput: 779.15 MB/sec - RemoteScanRanges: 0 - RowsRead: 366.26K (366262) - RowsReturned: 366.26K (366262) - RowsReturnedRate: 78.58 M/sec - ScanRangesComplete: 2 - ScannerThreadsInvoluntaryContextSwitches: 2 - ScannerThreadsTotalWallClockTime: 73.988ms - MaterializeTupleTime(*): 67.284ms - ScannerThreadsSysTime: 5.998ms - ScannerThreadsUserTime: 22.996ms - ScannerThreadsVoluntaryContextSwitches: 94 - TotalRawHdfsReadTime(*): 720.322us - TotalReadThroughput: 0.00 /sec Instance 9448ec37dcef4482:1b1f684841431403 (host=d2420.halxg.cloudera.com:22000):(Total: 118.600ms, non-child: 4.242ms, % non-child: 3.58%) Hdfs split stats (:<# splits>/): 2:1/10.22 MB - AverageThreadTokens: 0.00 - PeakMemoryUsage: 5.51 MB (5777704) - PerHostPeakMemUsage: 20.16 MB (21139184) - PrepareTime: 136.797us - RowsProduced: 183.52K (183517) - TotalCpuTime: 150.521ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 4.642ms - TotalStorageWaitTime: 4.254ms DataStreamSender (dst_id=4):(Total: 107.593ms, non-child: 107.593ms, % non-child: 100.00%) - BytesSent: 2.40 MB (2519426) - NetworkThroughput(*): 32.41 MB/sec - OverallThroughput: 22.33 MB/sec - PeakMemoryUsage: 650.03 KB (665632) - SerializeBatchTime: 46.491ms - ThriftTransmitTime(*): 74.133ms - UncompressedRowBatchSize: 6.37 MB (6683403) HDFS_SCAN_NODE (id=1):(Total: 6.764ms, non-child: 6.764ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 2:1/10.22 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% File Formats: PARQUET/SNAPPY:1 ExecOption: Codegen enabled: 0 out of 1 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 287.73 KB (294632) - BytesReadDataNodeCache: 0 - BytesReadLocal: 287.73 KB (294632) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 287.73 KB (294632) - DecompressionTime: 322.120us - MaxCompressedTextFileLength: 0 - NumColumns: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 5.07 MB (5311176) - PerReadThreadRawHdfsThroughput: 450.23 MB/sec - RemoteScanRanges: 0 - RowsRead: 183.52K (183517) - RowsReturned: 183.52K (183517) - RowsReturnedRate: 27.13 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 28.654ms - MaterializeTupleTime(*): 23.81ms - ScannerThreadsSysTime: 6.998ms - ScannerThreadsUserTime: 15.997ms - ScannerThreadsVoluntaryContextSwitches: 6 - TotalRawHdfsReadTime(*): 624.83us - TotalReadThroughput: 0.00 /sec