Query (id=3d44799788c4315e:ddd707e711cc5b9): Summary: Session ID: 604fd63b0bcdd21e:1e98c99d386f2a9 Session Type: BEESWAX Start Time: 2014-07-15 16:52:22.305087000 End Time: 2014-07-15 16:52:23.331282000 Query Type: QUERY Query State: FINISHED Query Status: OK Impala Version: impalad version 1.3.1-cdh5 RELEASE (build ) User: stephen Network Address: ::ffff:10.80.5.144:41257 Default Db: default Sql Statement: select COUNT(DISTINCT b.doc_id) FROM ( SELECT DISTINCT doc_id FROM `stats`.pmp_interactions ) a FULL OUTER JOIN ( SELECT DISTINCT doc_id FROM warehouse.pmp_interactions_read_times WHERE ds = '2014-07-09' ) b ON a.doc_id = b.doc_id WHERE a.doc_id IS NULL AND b.doc_id IS NOT NULL Plan: ---------------- Estimated Per-Host Requirements: Memory=257.75MB VCores=2 WARNING: The following tables are missing relevant table and/or column statistics. stats.pmp_interactions, warehouse.pmp_interactions_read_times F05:PLAN FRAGMENT [PARTITION=UNPARTITIONED] 14:AGGREGATE [MERGE FINALIZE] | output: sum(count(b.doc_id)) | hosts=10 per-host-mem=unavailable | tuple-ids=7 row-size=8B cardinality=1 | 13:EXCHANGE [PARTITION=UNPARTITIONED] hosts=10 per-host-mem=unavailable tuple-ids=7 row-size=8B cardinality=1 F04:PLAN FRAGMENT [PARTITION=HASH(b.doc_id)] DATASTREAM SINK [FRAGMENT=F05, EXCHANGE=13, PARTITION=UNPARTITIONED] 06:AGGREGATE [MERGE] | output: count(b.doc_id) | hosts=10 per-host-mem=10.00MB | tuple-ids=7 row-size=8B cardinality=1 | 12:AGGREGATE [MERGE] | group by: b.doc_id | hosts=10 per-host-mem=128.00MB | tuple-ids=6 row-size=8B cardinality=4239204 | 11:EXCHANGE [PARTITION=HASH(b.doc_id)] hosts=10 per-host-mem=0B tuple-ids=6 row-size=8B cardinality=4239204 F01:PLAN FRAGMENT [PARTITION=HASH(doc_id)] DATASTREAM SINK [FRAGMENT=F04, EXCHANGE=11, PARTITION=HASH(b.doc_id)] 05:AGGREGATE | group by: doc_id | hosts=10 per-host-mem=128.00MB | tuple-ids=6 row-size=8B cardinality=4239204 | 04:HASH JOIN [FULL OUTER JOIN, PARTITIONED] | hash predicates: doc_id = doc_id | other predicates: doc_id IS NULL, doc_id IS NOT NULL | hosts=10 per-host-mem=1.75MB | tuple-ids=1N,4N row-size=12B cardinality=4239204 | |--10:AGGREGATE [MERGE FINALIZE] | | group by: doc_id | | hosts=10 per-host-mem=128.00MB | | tuple-ids=4 row-size=8B cardinality=2089237 | | | 09:EXCHANGE [PARTITION=HASH(doc_id)] | hosts=10 per-host-mem=0B | tuple-ids=4 row-size=8B cardinality=2089237 | 08:AGGREGATE [MERGE FINALIZE] | group by: doc_id | hosts=10 per-host-mem=128.00MB | tuple-ids=1 row-size=4B cardinality=2149967 | 07:EXCHANGE [PARTITION=HASH(doc_id)] hosts=10 per-host-mem=0B tuple-ids=1 row-size=4B cardinality=2149967 F02:PLAN FRAGMENT [PARTITION=RANDOM] DATASTREAM SINK [FRAGMENT=F01, EXCHANGE=09, PARTITION=HASH(doc_id)] 03:AGGREGATE | group by: doc_id | hosts=10 per-host-mem=128.00MB | tuple-ids=4 row-size=8B cardinality=2089237 | 02:SCAN HDFS [warehouse.pmp_interactions_read_times, PARTITION=RANDOM] partitions=1/408 size=23.08MB predicates: warehouse.pmp_interactions_read_times.doc_id IS NOT NULL table stats: 283399104 rows total columns missing stats: doc_id hosts=10 per-host-mem=64.00MB tuple-ids=3 row-size=23B cardinality=2089237 F00:PLAN FRAGMENT [PARTITION=RANDOM] DATASTREAM SINK [FRAGMENT=F01, EXCHANGE=07, PARTITION=HASH(doc_id)] 01:AGGREGATE | group by: doc_id | hosts=10 per-host-mem=128.00MB | tuple-ids=1 row-size=4B cardinality=2149967 | 00:SCAN HDFS [stats.pmp_interactions, PARTITION=RANDOM] partitions=1/1 size=133.61MB table stats: 2149967 rows total column stats: unavailable hosts=10 per-host-mem=48.00MB tuple-ids=0 row-size=4B cardinality=2149967 ---------------- Estimated Per-Host Mem: 270273984 Estimated Per-Host VCores: 2 Tables Missing Stats: stats.pmp_interactions,warehouse.pmp_interactions_read_times Admission result: Admitted immediately Request Pool: root.stephen Query Timeline: 1s033ms - Start execution: 1.589ms (1.589ms) - Planning finished: 35.694ms (34.104ms) - Submit for admission: 36.787ms (1.93ms) - Completed admission: 36.797ms (9.931us) - Rows available: 943.698ms (906.900ms) - First row fetched: 1s012ms (68.545ms) - Unregister query: 1s026ms (13.960ms) ImpalaServer: - ClientFetchWaitTimer: 80.719ms - RowMaterializationTimer: 5.995us Execution Profile 3d44799788c4315e:ddd707e711cc5b9:(Total: 907.216ms, non-child: 0ns, % non-child: 0.00%) Per Node Peak Memory Usage: hadoop-slave05.local:22000(15.46 MB) hadoop-slave07.local:22000(16.43 MB) hadoop-slave06.local:22000(15.56 MB) hadoop-slave09.local:22000(29.27 MB) hadoop-slave01.local:22000(15.47 MB) hadoop-slave04.local:22000(29.68 MB) hadoop-slave08.local:22000(31.27 MB) hadoop-slave10.local:22000(15.54 MB) hadoop-slave03.local:22000(15.46 MB) hadoop-slave02.local:22000(15.55 MB) - FinalizationTimer: 0ns Coordinator Fragment:(Total: 248.83ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 44.00 KB, 44.00 KB ThreadUsage(500.0ms): 1, 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 92.02 KB - PrepareTime: 472.86us - RowsProduced: 1 - TotalCpuTime: 726.105ms - TotalNetworkReceiveTime: 248.33ms - TotalNetworkSendTime: 0ns - TotalStorageWaitTime: 0ns CodeGen:(Total: 82.374ms, non-child: 82.374ms, % non-child: 100.00%) - CodegenTime: 403.662us - CompileTime: 74.518ms - LoadTime: 7.33ms - ModuleFileSize: 105.51 KB AGGREGATION_NODE (id=14):(Total: 248.551ms, non-child: 493.860us, % non-child: 0.20%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 5.778us - GetResultsTime: 2.705us - LoadFactor: 0.00 - PeakMemoryUsage: 84.00 KB - RowsReturned: 1 - RowsReturnedRate: 4.00 /sec EXCHANGE_NODE (id=13):(Total: 248.57ms, non-child: 248.57ms, % non-child: 100.00%) BytesReceived(500.0ms): 0, 0 - BytesReceived: 160.00 B - ConvertRowBatchTime: 4.237us - DataArrivalWaitTime: 247.992ms - DeserializeRowBatchTimer: 38.227us - FirstBatchArrivalWaitTime: 244.398ms - PeakMemoryUsage: 4.02 KB - RowsReturned: 10 - RowsReturnedRate: 40.00 /sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Averaged Fragment 1:(Total: 697.911ms, non-child: 0ns, % non-child: 0.00%) split sizes: min: 0, max: 0, avg: 0, stddev: 0 completion times: min:686.622ms max:707.805ms mean: 698.703ms stddev:6.259ms execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec num instances: 10 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 474.91 KB - PrepareTime: 1.962ms - RowsProduced: 1 - TotalCpuTime: 107.315ms - TotalNetworkReceiveTime: 696.898ms - TotalNetworkSendTime: 159.935us - TotalStorageWaitTime: 0ns CodeGen:(Total: 103.450ms, non-child: 103.450ms, % non-child: 100.00%) - CodegenTime: 1.883ms - CompileTime: 96.833ms - LoadTime: 5.908ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=13):(Total: 22.132us, non-child: 22.132us, % non-child: 100.00%) - BytesSent: 16.00 B - NetworkThroughput(*): 140.34 KB/sec - OverallThroughput: 709.94 KB/sec - PeakMemoryUsage: 16.00 KB - SerializeBatchTime: 4.497us - ThriftTransmitTime(*): 141.65us - UncompressedRowBatchSize: 16.00 B AGGREGATION_NODE (id=6):(Total: 699.858ms, non-child: 269.525us, % non-child: 0.04%) - BuildBuckets: 1.02K (1024) - BuildTime: 18.496us - GetResultsTime: 2.223us - LoadFactor: 0.00 - PeakMemoryUsage: 44.00 KB - RowsReturned: 1 - RowsReturnedRate: 1.00 /sec AGGREGATION_NODE (id=12):(Total: 699.589ms, non-child: 2.561ms, % non-child: 0.37%) - BuildBuckets: 8.19K (8192) - BuildTime: 642.839us - GetResultsTime: 165.184us - LoadFactor: 0.52 - PeakMemoryUsage: 409.85 KB - RowsReturned: 6.37K (6369) - RowsReturnedRate: 9.10 K/sec EXCHANGE_NODE (id=11):(Total: 697.27ms, non-child: 697.27ms, % non-child: 100.00%) - BytesReceived: 67.64 KB - ConvertRowBatchTime: 106.684us - DataArrivalWaitTime: 696.843ms - DeserializeRowBatchTimer: 215.174us - FirstBatchArrivalWaitTime: 692.845ms - PeakMemoryUsage: 32.52 KB - RowsReturned: 6.75K (6753) - RowsReturnedRate: 9.69 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Averaged Fragment 2:(Total: 494.267ms, non-child: 0ns, % non-child: 0.00%) split sizes: min: 0, max: 0, avg: 0, stddev: 0 completion times: min:483.352ms max:508.845ms mean: 498.874ms stddev:7.172ms execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec num instances: 10 - AverageThreadTokens: 1.90 - PeakMemoryUsage: 2.08 MB - PrepareTime: 5.131ms - RowsProduced: 6.75K (6753) - TotalCpuTime: 488.528ms - TotalNetworkReceiveTime: 805.871ms - TotalNetworkSendTime: 2.265ms - TotalStorageWaitTime: 0ns CodeGen:(Total: 164.893ms, non-child: 164.893ms, % non-child: 100.00%) - CodegenTime: 4.548ms - CompileTime: 158.604ms - LoadTime: 5.701ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=11):(Total: 1.44ms, non-child: 1.44ms, % non-child: 100.00%) - BytesSent: 67.64 KB - NetworkThroughput(*): 24.70 MB/sec - OverallThroughput: 63.65 MB/sec - PeakMemoryUsage: 145.60 KB - SerializeBatchTime: 484.635us - ThriftTransmitTime(*): 2.691ms - UncompressedRowBatchSize: 131.96 KB AGGREGATION_NODE (id=5):(Total: 498.365ms, non-child: 2.926ms, % non-child: 0.59%) - BuildBuckets: 8.19K (8192) - BuildTime: 787.403us - GetResultsTime: 194.438us - LoadFactor: 0.54 - PeakMemoryUsage: 386.25 KB - RowsReturned: 6.75K (6753) - RowsReturnedRate: 13.55 K/sec HASH_JOIN_NODE (id=4):(Total: 495.438ms, non-child: 0ns, % non-child: 0.00%) - BuildBuckets: 16.38K (16384) - BuildRows: 15.42K (15420) - BuildTime: 787.511us - LeftChildRows: 15.57K (15568) - LeftChildTime: 3.165ms - LoadFactor: 0.61 - PeakMemoryUsage: 562.06 KB - RowsReturned: 11.38K (11380) - RowsReturnedRate: 22.98 K/sec AGGREGATION_NODE (id=10):(Total: 489.214ms, non-child: 3.479ms, % non-child: 0.71%) - BuildBuckets: 16.38K (16384) - BuildTime: 1.567ms - GetResultsTime: 394.680us - LoadFactor: 0.61 - PeakMemoryUsage: 822.65 KB - RowsReturned: 15.42K (15420) - RowsReturnedRate: 31.53 K/sec EXCHANGE_NODE (id=9):(Total: 485.735ms, non-child: 485.735ms, % non-child: 100.00%) - BytesReceived: 154.65 KB - ConvertRowBatchTime: 228.808us - DataArrivalWaitTime: 485.441ms - DeserializeRowBatchTimer: 319.377us - FirstBatchArrivalWaitTime: 459.173ms - PeakMemoryUsage: 32.00 KB - RowsReturned: 15.42K (15420) - RowsReturnedRate: 31.76 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns AGGREGATION_NODE (id=8):(Total: 326.211ms, non-child: 4.936ms, % non-child: 1.51%) - BuildBuckets: 16.38K (16384) - BuildTime: 2.891ms - GetResultsTime: 420.338us - LoadFactor: 0.61 - PeakMemoryUsage: 686.06 KB - RowsReturned: 15.57K (15568) - RowsReturnedRate: 47.74 K/sec EXCHANGE_NODE (id=7):(Total: 321.274ms, non-child: 321.274ms, % non-child: 100.00%) - BytesReceived: 525.51 KB - ConvertRowBatchTime: 835.775us - DataArrivalWaitTime: 320.237ms - DeserializeRowBatchTimer: 1.303ms - FirstBatchArrivalWaitTime: 292.799ms - PeakMemoryUsage: 72.98 KB - RowsReturned: 57.69K (57693) - RowsReturnedRate: 179.66 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Averaged Fragment 3:(Total: 360.744ms, non-child: 0ns, % non-child: 0.00%) split sizes: min: 23.08 MB, max: 23.08 MB, avg: 23.08 MB, stddev: 0 completion times: min:365.787ms max:365.787ms mean: 365.787ms stddev:0ns execution rates: min:63.09 MB/sec max:63.09 MB/sec mean:63.09 MB/sec stddev:0.00 /sec num instances: 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 31.27 MB - PrepareTime: 1.971ms - RowsProduced: 154.21K (154205) - TotalCpuTime: 793.448ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 2.373ms - TotalStorageWaitTime: 8.24ms CodeGen:(Total: 102.561ms, non-child: 102.561ms, % non-child: 100.00%) - CodegenTime: 1.879ms - CompileTime: 96.62ms - LoadTime: 5.829ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=9):(Total: 22.797ms, non-child: 22.797ms, % non-child: 100.00%) - BytesSent: 1.51 MB - NetworkThroughput(*): 29.93 MB/sec - OverallThroughput: 66.25 MB/sec - PeakMemoryUsage: 360.00 KB - SerializeBatchTime: 8.310ms - ThriftTransmitTime(*): 50.463ms - UncompressedRowBatchSize: 2.94 MB AGGREGATION_NODE (id=3):(Total: 339.782ms, non-child: 120.156ms, % non-child: 35.36%) - BuildBuckets: 131.07K (131072) - BuildTime: 111.703ms - GetResultsTime: 4.889ms - LoadFactor: 0.70 - PeakMemoryUsage: 10.28 MB - RowsReturned: 154.21K (154205) - RowsReturnedRate: 453.83 K/sec HDFS_SCAN_NODE (id=2):(Total: 219.626ms, non-child: 219.626ms, % non-child: 100.00%) - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 23.08 MB - BytesReadDataNodeCache: 0 - BytesReadLocal: 23.08 MB - BytesReadShortCircuit: 23.08 MB - BytesSkipped: 0 - DecompressionTime: 124.527ms - NumDisksAccessed: 2 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 25.12 MB - PerReadThreadRawHdfsThroughput: 2.10 GB/sec - RowsRead: 2.09M (2089237) - RowsReturned: 2.09M (2089237) - RowsReturnedRate: 9.51 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 4 - ScannerThreadsTotalWallClockTime: 332.668ms - MaterializeTupleTime(*): 199.581ms - ScannerThreadsSysTime: 2.999ms - ScannerThreadsUserTime: 319.951ms - ScannerThreadsVoluntaryContextSwitches: 5 - TotalRawHdfsReadTime(*): 10.709ms - TotalReadThroughput: 0.00 /sec Averaged Fragment 4:(Total: 65.544ms, non-child: 0ns, % non-child: 0.00%) split sizes: min: 10.89 MB, max: 22.58 MB, avg: 13.36 MB, stddev: 4.46 MB completion times: min:70.674ms max:79.349ms mean: 73.639ms stddev:2.605ms execution rates: min:146.14 MB/sec max:291.87 MB/sec mean:180.18 MB/sec stddev:54.19 MB/sec num instances: 10 - AverageThreadTokens: 0.70 - PeakMemoryUsage: 18.39 MB - PrepareTime: 1.715ms - RowsProduced: 57.69K (57693) - TotalCpuTime: 231.692ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 4.764ms - TotalStorageWaitTime: 5.750ms CodeGen:(Total: 99.201ms, non-child: 99.201ms, % non-child: 100.00%) - CodegenTime: 1.629ms - CompileTime: 92.729ms - LoadTime: 5.842ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=7):(Total: 7.636ms, non-child: 7.636ms, % non-child: 100.00%) - BytesSent: 525.51 KB - NetworkThroughput(*): 21.98 MB/sec - OverallThroughput: 67.26 MB/sec - PeakMemoryUsage: 440.00 KB - SerializeBatchTime: 3.216ms - ThriftTransmitTime(*): 23.547ms - UncompressedRowBatchSize: 676.22 KB AGGREGATION_NODE (id=1):(Total: 59.597ms, non-child: 18.740ms, % non-child: 31.45%) - BuildBuckets: 65.54K (65536) - BuildTime: 14.687ms - GetResultsTime: 1.782ms - LoadFactor: 0.58 - PeakMemoryUsage: 3.97 MB - RowsReturned: 57.69K (57693) - RowsReturnedRate: 966.47 K/sec HDFS_SCAN_NODE (id=0):(Total: 40.856ms, non-child: 40.856ms, % non-child: 100.00%) - AverageHdfsReadThreadConcurrency: 0.10 - AverageScannerThreadConcurrency: 0.20 - BytesRead: 13.36 MB - BytesReadDataNodeCache: 0 - BytesReadLocal: 13.36 MB - BytesReadShortCircuit: 13.36 MB - BytesSkipped: 0 - DecompressionTime: 31.821ms - NumDisksAccessed: 2 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 16.00 MB - PerReadThreadRawHdfsThroughput: 2.72 GB/sec - RowsRead: 215.00K (214996) - RowsReturned: 215.00K (214996) - RowsReturnedRate: 5.40 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 66.862ms - MaterializeTupleTime(*): 28.685ms - ScannerThreadsSysTime: 199.900us - ScannerThreadsUserTime: 59.590ms - ScannerThreadsVoluntaryContextSwitches: 6 - TotalRawHdfsReadTime(*): 4.833ms - TotalReadThroughput: 2.24 MB/sec Fragment 1: Instance 3d44799788c4315e:ddd707e711cc5bf (host=hadoop-slave01.local:22000):(Total: 707.103ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 92.00 KB, 92.00 KB ThreadUsage(500.0ms): 1, 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 476.25 KB - PrepareTime: 1.850ms - RowsProduced: 1 - TotalCpuTime: 104.379ms - TotalNetworkReceiveTime: 706.133ms - TotalNetworkSendTime: 62.576us - TotalStorageWaitTime: 0ns CodeGen:(Total: 100.599ms, non-child: 100.599ms, % non-child: 100.00%) - CodegenTime: 1.770ms - CompileTime: 94.39ms - LoadTime: 5.964ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=13):(Total: 20.685us, non-child: 20.685us, % non-child: 100.00%) - BytesSent: 16.00 B - NetworkThroughput(*): 334.64 KB/sec - OverallThroughput: 755.38 KB/sec - PeakMemoryUsage: 16.00 KB - SerializeBatchTime: 4.249us - ThriftTransmitTime(*): 46.692us - UncompressedRowBatchSize: 16.00 B AGGREGATION_NODE (id=6):(Total: 708.941ms, non-child: 255.395us, % non-child: 0.04%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 17.867us - GetResultsTime: 2.539us - LoadFactor: 0.00 - PeakMemoryUsage: 44.00 KB - RowsReturned: 1 - RowsReturnedRate: 1.00 /sec AGGREGATION_NODE (id=12):(Total: 708.686ms, non-child: 2.426ms, % non-child: 0.34%) ExecOption: Codegen Enabled - BuildBuckets: 8.19K (8192) - BuildTime: 609.774us - GetResultsTime: 160.426us - LoadFactor: 0.51 - PeakMemoryUsage: 410.25 KB - RowsReturned: 6.31K (6310) - RowsReturnedRate: 8.90 K/sec EXCHANGE_NODE (id=11):(Total: 706.260ms, non-child: 706.260ms, % non-child: 100.00%) BytesReceived(500.0ms): 0, 0 - BytesReceived: 67.59 KB - ConvertRowBatchTime: 103.193us - DataArrivalWaitTime: 706.74ms - DeserializeRowBatchTimer: 340.410us - FirstBatchArrivalWaitTime: 702.424ms - PeakMemoryUsage: 32.00 KB - RowsReturned: 6.75K (6747) - RowsReturnedRate: 9.55 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 3d44799788c4315e:ddd707e711cc5be (host=hadoop-slave09.local:22000):(Total: 704.361ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 92.00 KB ThreadUsage(500.0ms): 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 476.10 KB - PrepareTime: 1.697ms - RowsProduced: 1 - TotalCpuTime: 103.374ms - TotalNetworkReceiveTime: 703.327ms - TotalNetworkSendTime: 115.497us - TotalStorageWaitTime: 0ns CodeGen:(Total: 99.895ms, non-child: 99.895ms, % non-child: 100.00%) - CodegenTime: 1.631ms - CompileTime: 93.987ms - LoadTime: 5.242ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=13):(Total: 20.793us, non-child: 20.793us, % non-child: 100.00%) - BytesSent: 16.00 B - NetworkThroughput(*): 159.71 KB/sec - OverallThroughput: 751.45 KB/sec - PeakMemoryUsage: 16.00 KB - SerializeBatchTime: 4.522us - ThriftTransmitTime(*): 97.831us - UncompressedRowBatchSize: 16.00 B AGGREGATION_NODE (id=6):(Total: 706.45ms, non-child: 249.849us, % non-child: 0.04%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 18.884us - GetResultsTime: 2.359us - LoadFactor: 0.00 - PeakMemoryUsage: 44.00 KB - RowsReturned: 1 - RowsReturnedRate: 1.00 /sec AGGREGATION_NODE (id=12):(Total: 705.796ms, non-child: 2.331ms, % non-child: 0.33%) ExecOption: Codegen Enabled - BuildBuckets: 8.19K (8192) - BuildTime: 645.810us - GetResultsTime: 176.478us - LoadFactor: 0.54 - PeakMemoryUsage: 410.77 KB - RowsReturned: 6.52K (6521) - RowsReturnedRate: 9.24 K/sec EXCHANGE_NODE (id=11):(Total: 703.464ms, non-child: 703.464ms, % non-child: 100.00%) BytesReceived(500.0ms): 0 - BytesReceived: 69.06 KB - ConvertRowBatchTime: 114.124us - DataArrivalWaitTime: 703.273ms - DeserializeRowBatchTimer: 194.728us - FirstBatchArrivalWaitTime: 699.353ms - PeakMemoryUsage: 37.24 KB - RowsReturned: 6.88K (6883) - RowsReturnedRate: 9.78 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 3d44799788c4315e:ddd707e711cc5bd (host=hadoop-slave06.local:22000):(Total: 702.831ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 92.00 KB, 92.00 KB ThreadUsage(500.0ms): 1, 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 472.30 KB - PrepareTime: 2.444ms - RowsProduced: 1 - TotalCpuTime: 105.10ms - TotalNetworkReceiveTime: 701.705ms - TotalNetworkSendTime: 154.291us - TotalStorageWaitTime: 0ns CodeGen:(Total: 100.561ms, non-child: 100.561ms, % non-child: 100.00%) - CodegenTime: 2.357ms - CompileTime: 94.438ms - LoadTime: 5.464ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=13):(Total: 21.176us, non-child: 21.176us, % non-child: 100.00%) - BytesSent: 16.00 B - NetworkThroughput(*): 113.14 KB/sec - OverallThroughput: 737.86 KB/sec - PeakMemoryUsage: 16.00 KB - SerializeBatchTime: 4.692us - ThriftTransmitTime(*): 138.99us - UncompressedRowBatchSize: 16.00 B AGGREGATION_NODE (id=6):(Total: 705.261ms, non-child: 258.397us, % non-child: 0.04%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 18.256us - GetResultsTime: 2.43us - LoadFactor: 0.00 - PeakMemoryUsage: 44.00 KB - RowsReturned: 1 - RowsReturnedRate: 1.00 /sec AGGREGATION_NODE (id=12):(Total: 705.3ms, non-child: 3.153ms, % non-child: 0.45%) ExecOption: Codegen Enabled - BuildBuckets: 8.19K (8192) - BuildTime: 740.388us - GetResultsTime: 167.579us - LoadFactor: 0.53 - PeakMemoryUsage: 407.08 KB - RowsReturned: 6.54K (6543) - RowsReturnedRate: 9.28 K/sec EXCHANGE_NODE (id=11):(Total: 701.849ms, non-child: 701.849ms, % non-child: 100.00%) BytesReceived(500.0ms): 0, 0 - BytesReceived: 69.23 KB - ConvertRowBatchTime: 119.646us - DataArrivalWaitTime: 701.652ms - DeserializeRowBatchTimer: 191.508us - FirstBatchArrivalWaitTime: 697.844ms - PeakMemoryUsage: 32.00 KB - RowsReturned: 6.91K (6910) - RowsReturnedRate: 9.85 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 3d44799788c4315e:ddd707e711cc5c4 (host=hadoop-slave02.local:22000):(Total: 701.140ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 92.00 KB ThreadUsage(500.0ms): 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 454.81 KB - PrepareTime: 1.816ms - RowsProduced: 1 - TotalCpuTime: 104.535ms - TotalNetworkReceiveTime: 700.158ms - TotalNetworkSendTime: 118.245us - TotalStorageWaitTime: 0ns CodeGen:(Total: 100.901ms, non-child: 100.901ms, % non-child: 100.00%) - CodegenTime: 1.743ms - CompileTime: 94.748ms - LoadTime: 5.480ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=13):(Total: 22.417us, non-child: 22.417us, % non-child: 100.00%) - BytesSent: 16.00 B - NetworkThroughput(*): 158.55 KB/sec - OverallThroughput: 697.02 KB/sec - PeakMemoryUsage: 16.00 KB - SerializeBatchTime: 4.349us - ThriftTransmitTime(*): 98.546us - UncompressedRowBatchSize: 16.00 B AGGREGATION_NODE (id=6):(Total: 702.942ms, non-child: 275.962us, % non-child: 0.04%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 18.449us - GetResultsTime: 2.71us - LoadFactor: 0.00 - PeakMemoryUsage: 44.00 KB - RowsReturned: 1 - RowsReturnedRate: 1.00 /sec AGGREGATION_NODE (id=12):(Total: 702.666ms, non-child: 2.379ms, % non-child: 0.34%) ExecOption: Codegen Enabled - BuildBuckets: 8.19K (8192) - BuildTime: 610.600us - GetResultsTime: 172.720us - LoadFactor: 0.53 - PeakMemoryUsage: 394.81 KB - RowsReturned: 6.54K (6544) - RowsReturnedRate: 9.31 K/sec EXCHANGE_NODE (id=11):(Total: 700.287ms, non-child: 700.287ms, % non-child: 100.00%) BytesReceived(500.0ms): 0 - BytesReceived: 69.41 KB - ConvertRowBatchTime: 107.857us - DataArrivalWaitTime: 700.112ms - DeserializeRowBatchTimer: 203.886us - FirstBatchArrivalWaitTime: 696.109ms - PeakMemoryUsage: 32.00 KB - RowsReturned: 6.93K (6931) - RowsReturnedRate: 9.90 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 3d44799788c4315e:ddd707e711cc5c1 (host=hadoop-slave04.local:22000):(Total: 700.915ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 92.00 KB ThreadUsage(500.0ms): 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 484.13 KB - PrepareTime: 1.768ms - RowsProduced: 1 - TotalCpuTime: 104.288ms - TotalNetworkReceiveTime: 699.899ms - TotalNetworkSendTime: 124.807us - TotalStorageWaitTime: 0ns CodeGen:(Total: 100.758ms, non-child: 100.758ms, % non-child: 100.00%) - CodegenTime: 1.697ms - CompileTime: 94.746ms - LoadTime: 5.358ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=13):(Total: 21.721us, non-child: 21.721us, % non-child: 100.00%) - BytesSent: 16.00 B - NetworkThroughput(*): 150.18 KB/sec - OverallThroughput: 719.35 KB/sec - PeakMemoryUsage: 16.00 KB - SerializeBatchTime: 4.973us - ThriftTransmitTime(*): 104.38us - UncompressedRowBatchSize: 16.00 B AGGREGATION_NODE (id=6):(Total: 702.669ms, non-child: 273.549us, % non-child: 0.04%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 19.312us - GetResultsTime: 2.469us - LoadFactor: 0.00 - PeakMemoryUsage: 44.00 KB - RowsReturned: 1 - RowsReturnedRate: 1.00 /sec AGGREGATION_NODE (id=12):(Total: 702.395ms, non-child: 2.369ms, % non-child: 0.34%) ExecOption: Codegen Enabled - BuildBuckets: 8.19K (8192) - BuildTime: 645.223us - GetResultsTime: 168.318us - LoadFactor: 0.52 - PeakMemoryUsage: 418.25 KB - RowsReturned: 6.45K (6447) - RowsReturnedRate: 9.18 K/sec EXCHANGE_NODE (id=11):(Total: 700.25ms, non-child: 700.25ms, % non-child: 100.00%) BytesReceived(500.0ms): 0 - BytesReceived: 68.66 KB - ConvertRowBatchTime: 103.457us - DataArrivalWaitTime: 699.831ms - DeserializeRowBatchTimer: 186.649us - FirstBatchArrivalWaitTime: 695.404ms - PeakMemoryUsage: 32.00 KB - RowsReturned: 6.86K (6855) - RowsReturnedRate: 9.79 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 3d44799788c4315e:ddd707e711cc5bb (host=hadoop-slave05.local:22000):(Total: 697.328ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 92.00 KB, 92.00 KB ThreadUsage(500.0ms): 1, 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 484.04 KB - PrepareTime: 1.803ms - RowsProduced: 1 - TotalCpuTime: 104.366ms - TotalNetworkReceiveTime: 696.349ms - TotalNetworkSendTime: 117.598us - TotalStorageWaitTime: 0ns CodeGen:(Total: 100.800ms, non-child: 100.800ms, % non-child: 100.00%) - CodegenTime: 1.730ms - CompileTime: 94.813ms - LoadTime: 5.303ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=13):(Total: 27.120us, non-child: 27.120us, % non-child: 100.00%) - BytesSent: 16.00 B - NetworkThroughput(*): 157.77 KB/sec - OverallThroughput: 576.14 KB/sec - PeakMemoryUsage: 16.00 KB - SerializeBatchTime: 4.292us - ThriftTransmitTime(*): 99.36us - UncompressedRowBatchSize: 16.00 B AGGREGATION_NODE (id=6):(Total: 699.112ms, non-child: 250.796us, % non-child: 0.04%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 17.555us - GetResultsTime: 2.407us - LoadFactor: 0.00 - PeakMemoryUsage: 44.00 KB - RowsReturned: 1 - RowsReturnedRate: 1.00 /sec AGGREGATION_NODE (id=12):(Total: 698.861ms, non-child: 2.382ms, % non-child: 0.34%) ExecOption: Codegen Enabled - BuildBuckets: 8.19K (8192) - BuildTime: 607.690us - GetResultsTime: 161.575us - LoadFactor: 0.51 - PeakMemoryUsage: 418.25 KB - RowsReturned: 6.31K (6314) - RowsReturnedRate: 9.03 K/sec EXCHANGE_NODE (id=11):(Total: 696.478ms, non-child: 696.478ms, % non-child: 100.00%) BytesReceived(500.0ms): 0, 0 - BytesReceived: 67.08 KB - ConvertRowBatchTime: 107.170us - DataArrivalWaitTime: 696.286ms - DeserializeRowBatchTimer: 200.570us - FirstBatchArrivalWaitTime: 692.86ms - PeakMemoryUsage: 32.00 KB - RowsReturned: 6.71K (6705) - RowsReturnedRate: 9.63 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 3d44799788c4315e:ddd707e711cc5c3 (host=hadoop-slave03.local:22000):(Total: 695.687ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 92.00 KB, 92.00 KB ThreadUsage(500.0ms): 1, 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 480.21 KB - PrepareTime: 1.964ms - RowsProduced: 1 - TotalCpuTime: 109.164ms - TotalNetworkReceiveTime: 694.693ms - TotalNetworkSendTime: 240.559us - TotalStorageWaitTime: 0ns CodeGen:(Total: 105.300ms, non-child: 105.300ms, % non-child: 100.00%) - CodegenTime: 1.881ms - CompileTime: 98.222ms - LoadTime: 6.338ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=13):(Total: 22.565us, non-child: 22.565us, % non-child: 100.00%) - BytesSent: 16.00 B - NetworkThroughput(*): 71.24 KB/sec - OverallThroughput: 692.44 KB/sec - PeakMemoryUsage: 16.00 KB - SerializeBatchTime: 4.700us - ThriftTransmitTime(*): 219.331us - UncompressedRowBatchSize: 16.00 B AGGREGATION_NODE (id=6):(Total: 697.636ms, non-child: 265.887us, % non-child: 0.04%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 18.199us - GetResultsTime: 2.160us - LoadFactor: 0.00 - PeakMemoryUsage: 44.00 KB - RowsReturned: 1 - RowsReturnedRate: 1.00 /sec AGGREGATION_NODE (id=12):(Total: 697.370ms, non-child: 2.542ms, % non-child: 0.36%) ExecOption: Codegen Enabled - BuildBuckets: 8.19K (8192) - BuildTime: 623.325us - GetResultsTime: 158.294us - LoadFactor: 0.51 - PeakMemoryUsage: 414.25 KB - RowsReturned: 6.23K (6232) - RowsReturnedRate: 8.94 K/sec EXCHANGE_NODE (id=11):(Total: 694.827ms, non-child: 694.827ms, % non-child: 100.00%) BytesReceived(500.0ms): 0, 0 - BytesReceived: 66.18 KB - ConvertRowBatchTime: 111.142us - DataArrivalWaitTime: 694.637ms - DeserializeRowBatchTimer: 189.214us - FirstBatchArrivalWaitTime: 690.267ms - PeakMemoryUsage: 32.00 KB - RowsReturned: 6.61K (6614) - RowsReturnedRate: 9.52 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 3d44799788c4315e:ddd707e711cc5c0 (host=hadoop-slave08.local:22000):(Total: 694.132ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 92.00 KB ThreadUsage(500.0ms): 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 461.66 KB - PrepareTime: 1.960ms - RowsProduced: 1 - TotalCpuTime: 107.869ms - TotalNetworkReceiveTime: 693.184ms - TotalNetworkSendTime: 153.221us - TotalStorageWaitTime: 0ns CodeGen:(Total: 104.4ms, non-child: 104.4ms, % non-child: 100.00%) - CodegenTime: 1.870ms - CompileTime: 96.921ms - LoadTime: 6.305ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=13):(Total: 21.751us, non-child: 21.751us, % non-child: 100.00%) - BytesSent: 16.00 B - NetworkThroughput(*): 117.23 KB/sec - OverallThroughput: 718.36 KB/sec - PeakMemoryUsage: 16.00 KB - SerializeBatchTime: 4.438us - ThriftTransmitTime(*): 133.280us - UncompressedRowBatchSize: 16.00 B AGGREGATION_NODE (id=6):(Total: 696.78ms, non-child: 275.138us, % non-child: 0.04%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 19.34us - GetResultsTime: 1.807us - LoadFactor: 0.00 - PeakMemoryUsage: 44.00 KB - RowsReturned: 1 - RowsReturnedRate: 1.00 /sec AGGREGATION_NODE (id=12):(Total: 695.803ms, non-child: 2.500ms, % non-child: 0.36%) ExecOption: Codegen Enabled - BuildBuckets: 8.19K (8192) - BuildTime: 594.611us - GetResultsTime: 157.197us - LoadFactor: 0.50 - PeakMemoryUsage: 396.39 KB - RowsReturned: 6.00K (5999) - RowsReturnedRate: 8.62 K/sec EXCHANGE_NODE (id=11):(Total: 693.302ms, non-child: 693.302ms, % non-child: 100.00%) BytesReceived(500.0ms): 0 - BytesReceived: 63.20 KB - ConvertRowBatchTime: 95.685us - DataArrivalWaitTime: 693.134ms - DeserializeRowBatchTimer: 191.775us - FirstBatchArrivalWaitTime: 689.747ms - PeakMemoryUsage: 32.00 KB - RowsReturned: 6.31K (6309) - RowsReturnedRate: 9.10 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 3d44799788c4315e:ddd707e711cc5c2 (host=hadoop-slave10.local:22000):(Total: 690.178ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 92.00 KB, 92.00 KB ThreadUsage(500.0ms): 1, 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 480.19 KB - PrepareTime: 2.169ms - RowsProduced: 1 - TotalCpuTime: 114.83ms - TotalNetworkReceiveTime: 689.222ms - TotalNetworkSendTime: 195.647us - TotalStorageWaitTime: 0ns CodeGen:(Total: 109.970ms, non-child: 109.970ms, % non-child: 100.00%) - CodegenTime: 2.84ms - CompileTime: 102.220ms - LoadTime: 6.845ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=13):(Total: 20.968us, non-child: 20.968us, % non-child: 100.00%) - BytesSent: 16.00 B - NetworkThroughput(*): 88.23 KB/sec - OverallThroughput: 745.18 KB/sec - PeakMemoryUsage: 16.00 KB - SerializeBatchTime: 4.280us - ThriftTransmitTime(*): 177.94us - UncompressedRowBatchSize: 16.00 B AGGREGATION_NODE (id=6):(Total: 692.334ms, non-child: 307.855us, % non-child: 0.04%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 18.782us - GetResultsTime: 1.938us - LoadFactor: 0.00 - PeakMemoryUsage: 44.00 KB - RowsReturned: 1 - RowsReturnedRate: 1.00 /sec AGGREGATION_NODE (id=12):(Total: 692.26ms, non-child: 2.682ms, % non-child: 0.39%) ExecOption: Codegen Enabled - BuildBuckets: 8.19K (8192) - BuildTime: 598.705us - GetResultsTime: 161.475us - LoadFactor: 0.51 - PeakMemoryUsage: 414.25 KB - RowsReturned: 6.25K (6253) - RowsReturnedRate: 9.04 K/sec EXCHANGE_NODE (id=11):(Total: 689.343ms, non-child: 689.343ms, % non-child: 100.00%) BytesReceived(500.0ms): 0, 0 - BytesReceived: 66.76 KB - ConvertRowBatchTime: 101.208us - DataArrivalWaitTime: 689.171ms - DeserializeRowBatchTimer: 189.572us - FirstBatchArrivalWaitTime: 685.237ms - PeakMemoryUsage: 32.00 KB - RowsReturned: 6.66K (6662) - RowsReturnedRate: 9.66 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 3d44799788c4315e:ddd707e711cc5bc (host=hadoop-slave07.local:22000):(Total: 685.436ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 92.00 KB, 92.00 KB ThreadUsage(500.0ms): 1, 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 479.45 KB - PrepareTime: 2.146ms - RowsProduced: 1 - TotalCpuTime: 116.83ms - TotalNetworkReceiveTime: 684.308ms - TotalNetworkSendTime: 316.914us - TotalStorageWaitTime: 0ns CodeGen:(Total: 111.709ms, non-child: 111.709ms, % non-child: 100.00%) - CodegenTime: 2.64ms - CompileTime: 104.198ms - LoadTime: 6.780ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=13):(Total: 22.126us, non-child: 22.126us, % non-child: 100.00%) - BytesSent: 16.00 B - NetworkThroughput(*): 52.66 KB/sec - OverallThroughput: 706.18 KB/sec - PeakMemoryUsage: 16.00 KB - SerializeBatchTime: 4.477us - ThriftTransmitTime(*): 296.704us - UncompressedRowBatchSize: 16.00 B AGGREGATION_NODE (id=6):(Total: 687.566ms, non-child: 282.428us, % non-child: 0.04%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 18.623us - GetResultsTime: 2.445us - LoadFactor: 0.00 - PeakMemoryUsage: 44.00 KB - RowsReturned: 1 - RowsReturnedRate: 1.00 /sec AGGREGATION_NODE (id=12):(Total: 687.283ms, non-child: 2.849ms, % non-child: 0.41%) ExecOption: Codegen Enabled - BuildBuckets: 8.19K (8192) - BuildTime: 752.271us - GetResultsTime: 167.784us - LoadFactor: 0.53 - PeakMemoryUsage: 414.25 KB - RowsReturned: 6.53K (6529) - RowsReturnedRate: 9.50 K/sec EXCHANGE_NODE (id=11):(Total: 684.433ms, non-child: 684.433ms, % non-child: 100.00%) BytesReceived(500.0ms): 0, 0 - BytesReceived: 69.21 KB - ConvertRowBatchTime: 103.365us - DataArrivalWaitTime: 684.259ms - DeserializeRowBatchTimer: 263.436us - FirstBatchArrivalWaitTime: 679.978ms - PeakMemoryUsage: 32.00 KB - RowsReturned: 6.92K (6918) - RowsReturnedRate: 10.11 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Fragment 2: Instance 3d44799788c4315e:ddd707e711cc5c9 (host=hadoop-slave01.local:22000):(Total: 504.425ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 240.00 KB ThreadUsage(500.0ms): 2 - AverageThreadTokens: 2.00 - PeakMemoryUsage: 2.08 MB - PrepareTime: 5.45ms - RowsProduced: 6.63K (6635) - TotalCpuTime: 498.279ms - TotalNetworkReceiveTime: 825.446ms - TotalNetworkSendTime: 2.232ms - TotalStorageWaitTime: 0ns CodeGen:(Total: 162.378ms, non-child: 162.378ms, % non-child: 100.00%) - CodegenTime: 4.477ms - CompileTime: 155.517ms - LoadTime: 6.285ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=11):(Total: 1.197ms, non-child: 1.197ms, % non-child: 100.00%) - BytesSent: 66.46 KB - NetworkThroughput(*): 23.29 MB/sec - OverallThroughput: 54.18 MB/sec - PeakMemoryUsage: 144.00 KB - SerializeBatchTime: 476.700us - ThriftTransmitTime(*): 2.786ms - UncompressedRowBatchSize: 129.65 KB AGGREGATION_NODE (id=5):(Total: 508.283ms, non-child: 2.914ms, % non-child: 0.57%) ExecOption: Codegen Enabled - BuildBuckets: 8.19K (8192) - BuildTime: 785.752us - GetResultsTime: 207.952us - LoadFactor: 0.53 - PeakMemoryUsage: 386.25 KB - RowsReturned: 6.63K (6635) - RowsReturnedRate: 13.05 K/sec HASH_JOIN_NODE (id=4):(Total: 505.368ms, non-child: 168.907ms, % non-child: 33.42%) ExecOption: Build Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildBuckets: 16.38K (16384) - BuildRows: 15.36K (15359) - BuildTime: 742.780us - LeftChildRows: 15.54K (15538) - LeftChildTime: 3.440ms - LoadFactor: 0.61 - PeakMemoryUsage: 562.06 KB - RowsReturned: 10.67K (10670) - RowsReturnedRate: 21.11 K/sec AGGREGATION_NODE (id=10):(Total: 498.997ms, non-child: 3.406ms, % non-child: 0.68%) ExecOption: Codegen Enabled - BuildBuckets: 16.38K (16384) - BuildTime: 1.514ms - GetResultsTime: 390.684us - LoadFactor: 0.61 - PeakMemoryUsage: 830.05 KB - RowsReturned: 15.36K (15359) - RowsReturnedRate: 30.78 K/sec EXCHANGE_NODE (id=9):(Total: 495.590ms, non-child: 495.590ms, % non-child: 100.00%) BytesReceived(500.0ms): 0 - BytesReceived: 154.09 KB - ConvertRowBatchTime: 227.429us - DataArrivalWaitTime: 495.302ms - DeserializeRowBatchTimer: 339.772us - FirstBatchArrivalWaitTime: 469.174ms - PeakMemoryUsage: 32.00 KB - RowsReturned: 15.36K (15359) - RowsReturnedRate: 30.99 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns AGGREGATION_NODE (id=8):(Total: 335.742ms, non-child: 4.759ms, % non-child: 1.42%) ExecOption: Codegen Enabled - BuildBuckets: 16.38K (16384) - BuildTime: 2.777ms - GetResultsTime: 403.62us - LoadFactor: 0.62 - PeakMemoryUsage: 686.06 KB - RowsReturned: 15.54K (15538) - RowsReturnedRate: 46.28 K/sec EXCHANGE_NODE (id=7):(Total: 330.982ms, non-child: 330.982ms, % non-child: 100.00%) BytesReceived(500.0ms): 0 - BytesReceived: 521.37 KB - ConvertRowBatchTime: 815.990us - DataArrivalWaitTime: 329.979ms - DeserializeRowBatchTimer: 1.274ms - FirstBatchArrivalWaitTime: 302.845ms - PeakMemoryUsage: 64.00 KB - RowsReturned: 57.25K (57246) - RowsReturnedRate: 172.96 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 3d44799788c4315e:ddd707e711cc5c8 (host=hadoop-slave09.local:22000):(Total: 500.310ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 240.00 KB ThreadUsage(500.0ms): 2 - AverageThreadTokens: 2.00 - PeakMemoryUsage: 2.08 MB - PrepareTime: 4.868ms - RowsProduced: 6.71K (6708) - TotalCpuTime: 494.598ms - TotalNetworkReceiveTime: 817.795ms - TotalNetworkSendTime: 2.329ms - TotalStorageWaitTime: 0ns CodeGen:(Total: 160.638ms, non-child: 160.638ms, % non-child: 100.00%) - CodegenTime: 4.297ms - CompileTime: 154.873ms - LoadTime: 5.221ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=11):(Total: 957.242us, non-child: 957.242us, % non-child: 100.00%) - BytesSent: 67.37 KB - NetworkThroughput(*): 24.22 MB/sec - OverallThroughput: 68.73 MB/sec - PeakMemoryUsage: 144.00 KB - SerializeBatchTime: 472.853us - ThriftTransmitTime(*): 2.716ms - UncompressedRowBatchSize: 131.07 KB AGGREGATION_NODE (id=5):(Total: 504.236ms, non-child: 2.806ms, % non-child: 0.56%) ExecOption: Codegen Enabled - BuildBuckets: 8.19K (8192) - BuildTime: 763.734us - GetResultsTime: 177.197us - LoadFactor: 0.55 - PeakMemoryUsage: 386.25 KB - RowsReturned: 6.71K (6708) - RowsReturnedRate: 13.30 K/sec HASH_JOIN_NODE (id=4):(Total: 501.429ms, non-child: 169.85ms, % non-child: 33.72%) ExecOption: Build Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildBuckets: 16.38K (16384) - BuildRows: 15.29K (15294) - BuildTime: 736.224us - LeftChildRows: 15.49K (15492) - LeftChildTime: 3.264ms - LoadFactor: 0.61 - PeakMemoryUsage: 562.06 KB - RowsReturned: 11.66K (11664) - RowsReturnedRate: 23.26 K/sec AGGREGATION_NODE (id=10):(Total: 495.252ms, non-child: 3.305ms, % non-child: 0.67%) ExecOption: Codegen Enabled - BuildBuckets: 16.38K (16384) - BuildTime: 1.488ms - GetResultsTime: 389.38us - LoadFactor: 0.61 - PeakMemoryUsage: 829.03 KB - RowsReturned: 15.29K (15294) - RowsReturnedRate: 30.88 K/sec EXCHANGE_NODE (id=9):(Total: 491.946ms, non-child: 491.946ms, % non-child: 100.00%) BytesReceived(500.0ms): 0 - BytesReceived: 153.24 KB - ConvertRowBatchTime: 219.181us - DataArrivalWaitTime: 491.676ms - DeserializeRowBatchTimer: 308.107us - FirstBatchArrivalWaitTime: 465.836ms - PeakMemoryUsage: 32.00 KB - RowsReturned: 15.29K (15294) - RowsReturnedRate: 31.09 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns AGGREGATION_NODE (id=8):(Total: 331.689ms, non-child: 4.731ms, % non-child: 1.43%) ExecOption: Codegen Enabled - BuildBuckets: 16.38K (16384) - BuildTime: 2.793ms - GetResultsTime: 402.773us - LoadFactor: 0.61 - PeakMemoryUsage: 686.06 KB - RowsReturned: 15.49K (15492) - RowsReturnedRate: 46.71 K/sec EXCHANGE_NODE (id=7):(Total: 326.958ms, non-child: 326.958ms, % non-child: 100.00%) BytesReceived(500.0ms): 0 - BytesReceived: 520.87 KB - ConvertRowBatchTime: 820.246us - DataArrivalWaitTime: 325.947ms - DeserializeRowBatchTimer: 1.286ms - FirstBatchArrivalWaitTime: 299.837ms - PeakMemoryUsage: 80.00 KB - RowsReturned: 57.18K (57180) - RowsReturnedRate: 174.88 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 3d44799788c4315e:ddd707e711cc5c7 (host=hadoop-slave06.local:22000):(Total: 499.14ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 240.00 KB ThreadUsage(500.0ms): 2 - AverageThreadTokens: 2.00 - PeakMemoryUsage: 2.08 MB - PrepareTime: 4.879ms - RowsProduced: 6.69K (6694) - TotalCpuTime: 493.21ms - TotalNetworkReceiveTime: 814.430ms - TotalNetworkSendTime: 2.56ms - TotalStorageWaitTime: 0ns CodeGen:(Total: 161.843ms, non-child: 161.843ms, % non-child: 100.00%) - CodegenTime: 4.318ms - CompileTime: 156.7ms - LoadTime: 5.282ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=11):(Total: 1.140ms, non-child: 1.140ms, % non-child: 100.00%) - BytesSent: 67.11 KB - NetworkThroughput(*): 26.77 MB/sec - OverallThroughput: 57.45 MB/sec - PeakMemoryUsage: 144.00 KB - SerializeBatchTime: 572.144us - ThriftTransmitTime(*): 2.447ms - UncompressedRowBatchSize: 130.80 KB AGGREGATION_NODE (id=5):(Total: 502.761ms, non-child: 2.842ms, % non-child: 0.57%) ExecOption: Codegen Enabled - BuildBuckets: 8.19K (8192) - BuildTime: 797.931us - GetResultsTime: 196.874us - LoadFactor: 0.54 - PeakMemoryUsage: 386.25 KB - RowsReturned: 6.69K (6694) - RowsReturnedRate: 13.31 K/sec HASH_JOIN_NODE (id=4):(Total: 499.919ms, non-child: 169.268ms, % non-child: 33.86%) ExecOption: Build Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildBuckets: 16.38K (16384) - BuildRows: 15.31K (15314) - BuildTime: 748.46us - LeftChildRows: 15.67K (15674) - LeftChildTime: 3.322ms - LoadFactor: 0.61 - PeakMemoryUsage: 562.06 KB - RowsReturned: 11.76K (11764) - RowsReturnedRate: 23.53 K/sec AGGREGATION_NODE (id=10):(Total: 493.644ms, non-child: 3.323ms, % non-child: 0.67%) ExecOption: Codegen Enabled - BuildBuckets: 16.38K (16384) - BuildTime: 1.528ms - GetResultsTime: 384.954us - LoadFactor: 0.61 - PeakMemoryUsage: 829.34 KB - RowsReturned: 15.31K (15314) - RowsReturnedRate: 31.02 K/sec EXCHANGE_NODE (id=9):(Total: 490.320ms, non-child: 490.320ms, % non-child: 100.00%) BytesReceived(500.0ms): 0 - BytesReceived: 153.61 KB - ConvertRowBatchTime: 217.841us - DataArrivalWaitTime: 490.49ms - DeserializeRowBatchTimer: 307.186us - FirstBatchArrivalWaitTime: 464.447ms - PeakMemoryUsage: 32.00 KB - RowsReturned: 15.31K (15314) - RowsReturnedRate: 31.23 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns AGGREGATION_NODE (id=8):(Total: 330.26ms, non-child: 4.787ms, % non-child: 1.45%) ExecOption: Codegen Enabled - BuildBuckets: 16.38K (16384) - BuildTime: 2.816ms - GetResultsTime: 405.816us - LoadFactor: 0.62 - PeakMemoryUsage: 686.06 KB - RowsReturned: 15.67K (15674) - RowsReturnedRate: 47.49 K/sec EXCHANGE_NODE (id=7):(Total: 325.238ms, non-child: 325.238ms, % non-child: 100.00%) BytesReceived(500.0ms): 0 - BytesReceived: 528.03 KB - ConvertRowBatchTime: 837.275us - DataArrivalWaitTime: 324.191ms - DeserializeRowBatchTimer: 1.267ms - FirstBatchArrivalWaitTime: 298.892ms - PeakMemoryUsage: 64.00 KB - RowsReturned: 57.95K (57951) - RowsReturnedRate: 178.18 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 3d44799788c4315e:ddd707e711cc5c5 (host=hadoop-slave05.local:22000):(Total: 498.371ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 232.00 KB, 870.06 KB ThreadUsage(500.0ms): 1, 2 - AverageThreadTokens: 1.50 - PeakMemoryUsage: 2.08 MB - PrepareTime: 4.958ms - RowsProduced: 6.69K (6691) - TotalCpuTime: 492.540ms - TotalNetworkReceiveTime: 812.903ms - TotalNetworkSendTime: 2.70ms - TotalStorageWaitTime: 0ns CodeGen:(Total: 161.490ms, non-child: 161.490ms, % non-child: 100.00%) - CodegenTime: 4.388ms - CompileTime: 155.476ms - LoadTime: 5.458ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=11):(Total: 1.23ms, non-child: 1.23ms, % non-child: 100.00%) - BytesSent: 66.91 KB - NetworkThroughput(*): 26.64 MB/sec - OverallThroughput: 63.86 MB/sec - PeakMemoryUsage: 144.00 KB - SerializeBatchTime: 461.110us - ThriftTransmitTime(*): 2.452ms - UncompressedRowBatchSize: 130.74 KB AGGREGATION_NODE (id=5):(Total: 502.316ms, non-child: 2.897ms, % non-child: 0.58%) ExecOption: Codegen Enabled - BuildBuckets: 8.19K (8192) - BuildTime: 777.553us - GetResultsTime: 221.33us - LoadFactor: 0.54 - PeakMemoryUsage: 386.25 KB - RowsReturned: 6.69K (6691) - RowsReturnedRate: 13.32 K/sec HASH_JOIN_NODE (id=4):(Total: 499.419ms, non-child: 169.803ms, % non-child: 34.00%) ExecOption: Build Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildBuckets: 16.38K (16384) - BuildRows: 15.40K (15398) - BuildTime: 733.11us - LeftChildRows: 15.61K (15612) - LeftChildTime: 3.299ms - LoadFactor: 0.61 - PeakMemoryUsage: 562.06 KB - RowsReturned: 10.75K (10750) - RowsReturnedRate: 21.52 K/sec AGGREGATION_NODE (id=10):(Total: 493.214ms, non-child: 3.333ms, % non-child: 0.68%) ExecOption: Codegen Enabled - BuildBuckets: 16.38K (16384) - BuildTime: 1.498ms - GetResultsTime: 386.461us - LoadFactor: 0.61 - PeakMemoryUsage: 818.06 KB - RowsReturned: 15.40K (15398) - RowsReturnedRate: 31.22 K/sec EXCHANGE_NODE (id=9):(Total: 489.880ms, non-child: 489.880ms, % non-child: 100.00%) BytesReceived(500.0ms): 0, 0 - BytesReceived: 154.42 KB - ConvertRowBatchTime: 223.37us - DataArrivalWaitTime: 489.599ms - DeserializeRowBatchTimer: 323.721us - FirstBatchArrivalWaitTime: 465.659ms - PeakMemoryUsage: 32.00 KB - RowsReturned: 15.40K (15398) - RowsReturnedRate: 31.43 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns AGGREGATION_NODE (id=8):(Total: 328.940ms, non-child: 4.765ms, % non-child: 1.45%) ExecOption: Codegen Enabled - BuildBuckets: 16.38K (16384) - BuildTime: 2.778ms - GetResultsTime: 413.292us - LoadFactor: 0.62 - PeakMemoryUsage: 686.06 KB - RowsReturned: 15.61K (15612) - RowsReturnedRate: 47.46 K/sec EXCHANGE_NODE (id=7):(Total: 324.174ms, non-child: 324.174ms, % non-child: 100.00%) BytesReceived(500.0ms): 0 - BytesReceived: 528.42 KB - ConvertRowBatchTime: 852.816us - DataArrivalWaitTime: 323.151ms - DeserializeRowBatchTimer: 1.251ms - FirstBatchArrivalWaitTime: 298.459ms - PeakMemoryUsage: 83.64 KB - RowsReturned: 58.07K (58066) - RowsReturnedRate: 179.12 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 3d44799788c4315e:ddd707e711cc5ce (host=hadoop-slave02.local:22000):(Total: 497.168ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 240.00 KB ThreadUsage(500.0ms): 2 - AverageThreadTokens: 2.00 - PeakMemoryUsage: 2.08 MB - PrepareTime: 5.58ms - RowsProduced: 6.69K (6692) - TotalCpuTime: 491.354ms - TotalNetworkReceiveTime: 813.234ms - TotalNetworkSendTime: 2.87ms - TotalStorageWaitTime: 0ns CodeGen:(Total: 161.617ms, non-child: 161.617ms, % non-child: 100.00%) - CodegenTime: 4.477ms - CompileTime: 155.648ms - LoadTime: 5.410ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=11):(Total: 1.42ms, non-child: 1.42ms, % non-child: 100.00%) - BytesSent: 67.09 KB - NetworkThroughput(*): 25.11 MB/sec - OverallThroughput: 62.84 MB/sec - PeakMemoryUsage: 144.00 KB - SerializeBatchTime: 474.333us - ThriftTransmitTime(*): 2.609ms - UncompressedRowBatchSize: 130.76 KB AGGREGATION_NODE (id=5):(Total: 501.194ms, non-child: 2.940ms, % non-child: 0.59%) ExecOption: Codegen Enabled - BuildBuckets: 8.19K (8192) - BuildTime: 783.135us - GetResultsTime: 208.573us - LoadFactor: 0.54 - PeakMemoryUsage: 386.25 KB - RowsReturned: 6.69K (6692) - RowsReturnedRate: 13.35 K/sec HASH_JOIN_NODE (id=4):(Total: 498.253ms, non-child: 167.172ms, % non-child: 33.55%) ExecOption: Build Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildBuckets: 16.38K (16384) - BuildRows: 15.34K (15340) - BuildTime: 742.840us - LeftChildRows: 15.53K (15528) - LeftChildTime: 3.273ms - LoadFactor: 0.61 - PeakMemoryUsage: 562.06 KB - RowsReturned: 11.79K (11789) - RowsReturnedRate: 23.66 K/sec AGGREGATION_NODE (id=10):(Total: 492.37ms, non-child: 3.335ms, % non-child: 0.68%) ExecOption: Codegen Enabled - BuildBuckets: 16.38K (16384) - BuildTime: 1.484ms - GetResultsTime: 384.520us - LoadFactor: 0.61 - PeakMemoryUsage: 829.75 KB - RowsReturned: 15.34K (15340) - RowsReturnedRate: 31.18 K/sec EXCHANGE_NODE (id=9):(Total: 488.701ms, non-child: 488.701ms, % non-child: 100.00%) BytesReceived(500.0ms): 0 - BytesReceived: 153.82 KB - ConvertRowBatchTime: 218.346us - DataArrivalWaitTime: 488.437ms - DeserializeRowBatchTimer: 310.36us - FirstBatchArrivalWaitTime: 460.481ms - PeakMemoryUsage: 32.00 KB - RowsReturned: 15.34K (15340) - RowsReturnedRate: 31.39 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns AGGREGATION_NODE (id=8):(Total: 330.396ms, non-child: 4.741ms, % non-child: 1.44%) ExecOption: Codegen Enabled - BuildBuckets: 16.38K (16384) - BuildTime: 2.725ms - GetResultsTime: 403.469us - LoadFactor: 0.61 - PeakMemoryUsage: 686.06 KB - RowsReturned: 15.53K (15528) - RowsReturnedRate: 47.00 K/sec EXCHANGE_NODE (id=7):(Total: 325.655ms, non-child: 325.655ms, % non-child: 100.00%) BytesReceived(500.0ms): 0 - BytesReceived: 524.78 KB - ConvertRowBatchTime: 840.710us - DataArrivalWaitTime: 324.592ms - DeserializeRowBatchTimer: 1.307ms - FirstBatchArrivalWaitTime: 293.262ms - PeakMemoryUsage: 64.00 KB - RowsReturned: 57.64K (57641) - RowsReturnedRate: 177.00 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 3d44799788c4315e:ddd707e711cc5cb (host=hadoop-slave04.local:22000):(Total: 497.97ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 240.00 KB ThreadUsage(500.0ms): 2 - AverageThreadTokens: 2.00 - PeakMemoryUsage: 2.08 MB - PrepareTime: 4.888ms - RowsProduced: 6.67K (6670) - TotalCpuTime: 491.936ms - TotalNetworkReceiveTime: 813.271ms - TotalNetworkSendTime: 1.951ms - TotalStorageWaitTime: 0ns CodeGen:(Total: 160.624ms, non-child: 160.624ms, % non-child: 100.00%) - CodegenTime: 4.326ms - CompileTime: 154.711ms - LoadTime: 5.364ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=11):(Total: 966.514us, non-child: 966.514us, % non-child: 100.00%) - BytesSent: 67.04 KB - NetworkThroughput(*): 27.61 MB/sec - OverallThroughput: 67.74 MB/sec - PeakMemoryUsage: 144.00 KB - SerializeBatchTime: 458.27us - ThriftTransmitTime(*): 2.371ms - UncompressedRowBatchSize: 130.33 KB AGGREGATION_NODE (id=5):(Total: 501.31ms, non-child: 2.810ms, % non-child: 0.56%) ExecOption: Codegen Enabled - BuildBuckets: 8.19K (8192) - BuildTime: 796.286us - GetResultsTime: 175.694us - LoadFactor: 0.54 - PeakMemoryUsage: 386.25 KB - RowsReturned: 6.67K (6670) - RowsReturnedRate: 13.31 K/sec HASH_JOIN_NODE (id=4):(Total: 498.220ms, non-child: 167.468ms, % non-child: 33.61%) ExecOption: Build Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildBuckets: 16.38K (16384) - BuildRows: 15.38K (15375) - BuildTime: 813.275us - LeftChildRows: 15.71K (15712) - LeftChildTime: 2.644ms - LoadFactor: 0.60 - PeakMemoryUsage: 562.06 KB - RowsReturned: 11.72K (11725) - RowsReturnedRate: 23.53 K/sec AGGREGATION_NODE (id=10):(Total: 492.532ms, non-child: 3.322ms, % non-child: 0.67%) ExecOption: Codegen Enabled - BuildBuckets: 16.38K (16384) - BuildTime: 1.484ms - GetResultsTime: 391.647us - LoadFactor: 0.60 - PeakMemoryUsage: 818.06 KB - RowsReturned: 15.38K (15375) - RowsReturnedRate: 31.22 K/sec EXCHANGE_NODE (id=9):(Total: 489.209ms, non-child: 489.209ms, % non-child: 100.00%) BytesReceived(500.0ms): 0 - BytesReceived: 154.24 KB - ConvertRowBatchTime: 226.734us - DataArrivalWaitTime: 488.919ms - DeserializeRowBatchTimer: 304.865us - FirstBatchArrivalWaitTime: 461.527ms - PeakMemoryUsage: 32.00 KB - RowsReturned: 15.38K (15375) - RowsReturnedRate: 31.43 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns AGGREGATION_NODE (id=8):(Total: 330.154ms, non-child: 4.970ms, % non-child: 1.51%) ExecOption: Codegen Enabled - BuildBuckets: 16.38K (16384) - BuildTime: 2.992ms - GetResultsTime: 432.766us - LoadFactor: 0.62 - PeakMemoryUsage: 686.06 KB - RowsReturned: 15.71K (15712) - RowsReturnedRate: 47.59 K/sec EXCHANGE_NODE (id=7):(Total: 325.184ms, non-child: 325.184ms, % non-child: 100.00%) BytesReceived(500.0ms): 0 - BytesReceived: 528.50 KB - ConvertRowBatchTime: 831.667us - DataArrivalWaitTime: 324.158ms - DeserializeRowBatchTimer: 1.296ms - FirstBatchArrivalWaitTime: 296.5ms - PeakMemoryUsage: 84.30 KB - RowsReturned: 58.03K (58032) - RowsReturnedRate: 178.46 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 3d44799788c4315e:ddd707e711cc5cd (host=hadoop-slave03.local:22000):(Total: 492.44ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 240.00 KB ThreadUsage(500.0ms): 2 - AverageThreadTokens: 2.00 - PeakMemoryUsage: 2.08 MB - PrepareTime: 5.276ms - RowsProduced: 6.71K (6708) - TotalCpuTime: 486.498ms - TotalNetworkReceiveTime: 802.665ms - TotalNetworkSendTime: 2.428ms - TotalStorageWaitTime: 0ns CodeGen:(Total: 165.666ms, non-child: 165.666ms, % non-child: 100.00%) - CodegenTime: 4.685ms - CompileTime: 159.284ms - LoadTime: 5.816ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=11):(Total: 1.109ms, non-child: 1.109ms, % non-child: 100.00%) - BytesSent: 66.99 KB - NetworkThroughput(*): 23.11 MB/sec - OverallThroughput: 58.97 MB/sec - PeakMemoryUsage: 144.00 KB - SerializeBatchTime: 469.357us - ThriftTransmitTime(*): 2.831ms - UncompressedRowBatchSize: 131.07 KB AGGREGATION_NODE (id=5):(Total: 496.223ms, non-child: 2.964ms, % non-child: 0.60%) ExecOption: Codegen Enabled - BuildBuckets: 8.19K (8192) - BuildTime: 791.825us - GetResultsTime: 177.434us - LoadFactor: 0.54 - PeakMemoryUsage: 386.25 KB - RowsReturned: 6.71K (6708) - RowsReturnedRate: 13.52 K/sec HASH_JOIN_NODE (id=4):(Total: 493.259ms, non-child: 167.187ms, % non-child: 33.89%) ExecOption: Build Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildBuckets: 16.38K (16384) - BuildRows: 15.55K (15551) - BuildTime: 741.741us - LeftChildRows: 15.65K (15650) - LeftChildTime: 2.930ms - LoadFactor: 0.61 - PeakMemoryUsage: 562.06 KB - RowsReturned: 10.86K (10863) - RowsReturnedRate: 22.02 K/sec AGGREGATION_NODE (id=10):(Total: 487.273ms, non-child: 3.486ms, % non-child: 0.72%) ExecOption: Codegen Enabled - BuildBuckets: 16.38K (16384) - BuildTime: 1.512ms - GetResultsTime: 412.381us - LoadFactor: 0.61 - PeakMemoryUsage: 818.06 KB - RowsReturned: 15.55K (15551) - RowsReturnedRate: 31.91 K/sec EXCHANGE_NODE (id=9):(Total: 483.787ms, non-child: 483.787ms, % non-child: 100.00%) BytesReceived(500.0ms): 0 - BytesReceived: 155.97 KB - ConvertRowBatchTime: 227.773us - DataArrivalWaitTime: 483.494ms - DeserializeRowBatchTimer: 300.888us - FirstBatchArrivalWaitTime: 456.35ms - PeakMemoryUsage: 32.00 KB - RowsReturned: 15.55K (15551) - RowsReturnedRate: 32.14 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns AGGREGATION_NODE (id=8):(Total: 325.295ms, non-child: 5.233ms, % non-child: 1.61%) ExecOption: Codegen Enabled - BuildBuckets: 16.38K (16384) - BuildTime: 3.102ms - GetResultsTime: 430.259us - LoadFactor: 0.61 - PeakMemoryUsage: 686.06 KB - RowsReturned: 15.65K (15650) - RowsReturnedRate: 48.11 K/sec EXCHANGE_NODE (id=7):(Total: 320.61ms, non-child: 320.61ms, % non-child: 100.00%) BytesReceived(500.0ms): 0 - BytesReceived: 527.04 KB - ConvertRowBatchTime: 873.785us - DataArrivalWaitTime: 319.4ms - DeserializeRowBatchTimer: 1.343ms - FirstBatchArrivalWaitTime: 289.123ms - PeakMemoryUsage: 80.00 KB - RowsReturned: 57.86K (57859) - RowsReturnedRate: 180.77 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 3d44799788c4315e:ddd707e711cc5ca (host=hadoop-slave08.local:22000):(Total: 491.107ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 240.00 KB ThreadUsage(500.0ms): 2 - AverageThreadTokens: 2.00 - PeakMemoryUsage: 2.08 MB - PrepareTime: 5.353ms - RowsProduced: 7.23K (7232) - TotalCpuTime: 485.59ms - TotalNetworkReceiveTime: 798.270ms - TotalNetworkSendTime: 2.410ms - TotalStorageWaitTime: 0ns CodeGen:(Total: 166.141ms, non-child: 166.141ms, % non-child: 100.00%) - CodegenTime: 4.782ms - CompileTime: 159.536ms - LoadTime: 5.949ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=11):(Total: 929.838us, non-child: 929.838us, % non-child: 100.00%) - BytesSent: 72.04 KB - NetworkThroughput(*): 26.19 MB/sec - OverallThroughput: 75.66 MB/sec - PeakMemoryUsage: 160.00 KB - SerializeBatchTime: 491.69us - ThriftTransmitTime(*): 2.686ms - UncompressedRowBatchSize: 141.30 KB AGGREGATION_NODE (id=5):(Total: 495.543ms, non-child: 3.0ms, % non-child: 0.61%) ExecOption: Codegen Enabled - BuildBuckets: 8.19K (8192) - BuildTime: 852.651us - GetResultsTime: 192.662us - LoadFactor: 0.56 - PeakMemoryUsage: 386.25 KB - RowsReturned: 7.23K (7232) - RowsReturnedRate: 14.59 K/sec HASH_JOIN_NODE (id=4):(Total: 492.542ms, non-child: 168.754ms, % non-child: 34.26%) ExecOption: Build Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildBuckets: 16.38K (16384) - BuildRows: 15.47K (15475) - BuildTime: 820.653us - LeftChildRows: 15.76K (15757) - LeftChildTime: 3.370ms - LoadFactor: 0.61 - PeakMemoryUsage: 562.06 KB - RowsReturned: 11.78K (11783) - RowsReturnedRate: 23.92 K/sec AGGREGATION_NODE (id=10):(Total: 485.899ms, non-child: 3.986ms, % non-child: 0.82%) ExecOption: Codegen Enabled - BuildBuckets: 16.38K (16384) - BuildTime: 1.849ms - GetResultsTime: 414.535us - LoadFactor: 0.61 - PeakMemoryUsage: 818.06 KB - RowsReturned: 15.47K (15475) - RowsReturnedRate: 31.85 K/sec EXCHANGE_NODE (id=9):(Total: 481.913ms, non-child: 481.913ms, % non-child: 100.00%) BytesReceived(500.0ms): 0 - BytesReceived: 155.21 KB - ConvertRowBatchTime: 254.846us - DataArrivalWaitTime: 481.572ms - DeserializeRowBatchTimer: 322.587us - FirstBatchArrivalWaitTime: 454.863ms - PeakMemoryUsage: 32.00 KB - RowsReturned: 15.47K (15475) - RowsReturnedRate: 32.11 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns AGGREGATION_NODE (id=8):(Total: 322.946ms, non-child: 5.404ms, % non-child: 1.67%) ExecOption: Codegen Enabled - BuildBuckets: 16.38K (16384) - BuildTime: 3.233ms - GetResultsTime: 504.324us - LoadFactor: 0.62 - PeakMemoryUsage: 686.06 KB - RowsReturned: 15.76K (15757) - RowsReturnedRate: 48.79 K/sec EXCHANGE_NODE (id=7):(Total: 317.541ms, non-child: 317.541ms, % non-child: 100.00%) BytesReceived(500.0ms): 0 - BytesReceived: 537.06 KB - ConvertRowBatchTime: 850.699us - DataArrivalWaitTime: 316.503ms - DeserializeRowBatchTimer: 1.246ms - FirstBatchArrivalWaitTime: 287.977ms - PeakMemoryUsage: 65.83 KB - RowsReturned: 58.94K (58944) - RowsReturnedRate: 185.62 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 3d44799788c4315e:ddd707e711cc5cc (host=hadoop-slave10.local:22000):(Total: 484.805ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 405.00 KB ThreadUsage(500.0ms): 2 - AverageThreadTokens: 2.00 - PeakMemoryUsage: 2.08 MB - PrepareTime: 5.500ms - RowsProduced: 6.71K (6715) - TotalCpuTime: 478.924ms - TotalNetworkReceiveTime: 787.332ms - TotalNetworkSendTime: 2.361ms - TotalStorageWaitTime: 0ns CodeGen:(Total: 172.483ms, non-child: 172.483ms, % non-child: 100.00%) - CodegenTime: 4.893ms - CompileTime: 165.394ms - LoadTime: 6.397ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=11):(Total: 1.53ms, non-child: 1.53ms, % non-child: 100.00%) - BytesSent: 67.23 KB - NetworkThroughput(*): 22.95 MB/sec - OverallThroughput: 62.34 MB/sec - PeakMemoryUsage: 144.00 KB - SerializeBatchTime: 481.320us - ThriftTransmitTime(*): 2.861ms - UncompressedRowBatchSize: 131.21 KB AGGREGATION_NODE (id=5):(Total: 489.266ms, non-child: 3.60ms, % non-child: 0.63%) ExecOption: Codegen Enabled - BuildBuckets: 8.19K (8192) - BuildTime: 770.652us - GetResultsTime: 207.775us - LoadFactor: 0.54 - PeakMemoryUsage: 386.25 KB - RowsReturned: 6.71K (6715) - RowsReturnedRate: 13.72 K/sec HASH_JOIN_NODE (id=4):(Total: 486.205ms, non-child: 168.71ms, % non-child: 34.57%) ExecOption: Build Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildBuckets: 16.38K (16384) - BuildRows: 15.49K (15486) - BuildTime: 807.326us - LeftChildRows: 15.53K (15532) - LeftChildTime: 3.341ms - LoadFactor: 0.62 - PeakMemoryUsage: 562.06 KB - RowsReturned: 10.88K (10882) - RowsReturnedRate: 22.38 K/sec AGGREGATION_NODE (id=10):(Total: 479.629ms, non-child: 3.620ms, % non-child: 0.75%) ExecOption: Codegen Enabled - BuildBuckets: 16.38K (16384) - BuildTime: 1.655ms - GetResultsTime: 401.46us - LoadFactor: 0.62 - PeakMemoryUsage: 818.06 KB - RowsReturned: 15.49K (15486) - RowsReturnedRate: 32.29 K/sec EXCHANGE_NODE (id=9):(Total: 476.9ms, non-child: 476.9ms, % non-child: 100.00%) BytesReceived(500.0ms): 0 - BytesReceived: 155.34 KB - ConvertRowBatchTime: 244.633us - DataArrivalWaitTime: 475.688ms - DeserializeRowBatchTimer: 335.12us - FirstBatchArrivalWaitTime: 448.626ms - PeakMemoryUsage: 32.00 KB - RowsReturned: 15.49K (15486) - RowsReturnedRate: 32.53 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns AGGREGATION_NODE (id=8):(Total: 317.426ms, non-child: 4.959ms, % non-child: 1.56%) ExecOption: Codegen Enabled - BuildBuckets: 16.38K (16384) - BuildTime: 2.802ms - GetResultsTime: 405.373us - LoadFactor: 0.62 - PeakMemoryUsage: 686.06 KB - RowsReturned: 15.53K (15532) - RowsReturnedRate: 48.93 K/sec EXCHANGE_NODE (id=7):(Total: 312.467ms, non-child: 312.467ms, % non-child: 100.00%) BytesReceived(500.0ms): 56.00 KB - BytesReceived: 530.51 KB - ConvertRowBatchTime: 832.563us - DataArrivalWaitTime: 311.466ms - DeserializeRowBatchTimer: 1.306ms - FirstBatchArrivalWaitTime: 281.986ms - PeakMemoryUsage: 64.00 KB - RowsReturned: 58.22K (58217) - RowsReturnedRate: 186.31 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 3d44799788c4315e:ddd707e711cc5c6 (host=hadoop-slave07.local:22000):(Total: 478.324ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 232.00 KB, 870.06 KB ThreadUsage(500.0ms): 1, 2 - AverageThreadTokens: 1.50 - PeakMemoryUsage: 2.08 MB - PrepareTime: 5.489ms - RowsProduced: 6.79K (6789) - TotalCpuTime: 473.77ms - TotalNetworkReceiveTime: 773.364ms - TotalNetworkSendTime: 2.723ms - TotalStorageWaitTime: 0ns CodeGen:(Total: 176.47ms, non-child: 176.47ms, % non-child: 100.00%) - CodegenTime: 4.843ms - CompileTime: 169.595ms - LoadTime: 5.828ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=11):(Total: 1.27ms, non-child: 1.27ms, % non-child: 100.00%) - BytesSent: 68.12 KB - NetworkThroughput(*): 21.14 MB/sec - OverallThroughput: 64.73 MB/sec - PeakMemoryUsage: 144.00 KB - SerializeBatchTime: 489.443us - ThriftTransmitTime(*): 3.146ms - UncompressedRowBatchSize: 132.66 KB AGGREGATION_NODE (id=5):(Total: 482.793ms, non-child: 3.25ms, % non-child: 0.63%) ExecOption: Codegen Enabled - BuildBuckets: 8.19K (8192) - BuildTime: 754.515us - GetResultsTime: 179.187us - LoadFactor: 0.55 - PeakMemoryUsage: 386.25 KB - RowsReturned: 6.79K (6789) - RowsReturnedRate: 14.06 K/sec HASH_JOIN_NODE (id=4):(Total: 479.767ms, non-child: 169.688ms, % non-child: 35.37%) ExecOption: Build Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildBuckets: 16.38K (16384) - BuildRows: 15.61K (15613) - BuildTime: 989.221us - LeftChildRows: 15.19K (15194) - LeftChildTime: 2.770ms - LoadFactor: 0.62 - PeakMemoryUsage: 562.06 KB - RowsReturned: 11.91K (11912) - RowsReturnedRate: 24.83 K/sec AGGREGATION_NODE (id=10):(Total: 473.661ms, non-child: 3.670ms, % non-child: 0.77%) ExecOption: Codegen Enabled - BuildBuckets: 16.38K (16384) - BuildTime: 1.654ms - GetResultsTime: 391.537us - LoadFactor: 0.62 - PeakMemoryUsage: 818.06 KB - RowsReturned: 15.61K (15613) - RowsReturnedRate: 32.96 K/sec EXCHANGE_NODE (id=9):(Total: 469.990ms, non-child: 469.990ms, % non-child: 100.00%) BytesReceived(500.0ms): 0, 0 - BytesReceived: 156.54 KB - ConvertRowBatchTime: 228.260us - DataArrivalWaitTime: 469.677ms - DeserializeRowBatchTimer: 341.599us - FirstBatchArrivalWaitTime: 445.82ms - PeakMemoryUsage: 32.00 KB - RowsReturned: 15.61K (15613) - RowsReturnedRate: 33.22 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns AGGREGATION_NODE (id=8):(Total: 309.494ms, non-child: 5.13ms, % non-child: 1.62%) ExecOption: Codegen Enabled - BuildBuckets: 16.38K (16384) - BuildTime: 2.893ms - GetResultsTime: 402.247us - LoadFactor: 0.60 - PeakMemoryUsage: 686.06 KB - RowsReturned: 15.19K (15194) - RowsReturnedRate: 49.09 K/sec EXCHANGE_NODE (id=7):(Total: 304.480ms, non-child: 304.480ms, % non-child: 100.00%) BytesReceived(500.0ms): 0 - BytesReceived: 508.56 KB - ConvertRowBatchTime: 802.3us - DataArrivalWaitTime: 303.382ms - DeserializeRowBatchTimer: 1.455ms - FirstBatchArrivalWaitTime: 279.607ms - PeakMemoryUsage: 80.00 KB - RowsReturned: 55.80K (55801) - RowsReturnedRate: 183.27 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Fragment 3: Instance 3d44799788c4315e:ddd707e711cc5cf (host=hadoop-slave08.local:22000):(Total: 360.744ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 0:1/23.08 MB MemoryUsage(500.0ms): 120.00 KB ThreadUsage(500.0ms): 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 31.27 MB - PrepareTime: 1.971ms - RowsProduced: 154.21K (154205) - TotalCpuTime: 793.448ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 2.373ms - TotalStorageWaitTime: 8.24ms CodeGen:(Total: 102.561ms, non-child: 102.561ms, % non-child: 100.00%) - CodegenTime: 1.879ms - CompileTime: 96.62ms - LoadTime: 5.829ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=9):(Total: 22.797ms, non-child: 22.797ms, % non-child: 100.00%) - BytesSent: 1.51 MB - NetworkThroughput(*): 29.93 MB/sec - OverallThroughput: 66.25 MB/sec - PeakMemoryUsage: 360.00 KB - SerializeBatchTime: 8.310ms - ThriftTransmitTime(*): 50.463ms - UncompressedRowBatchSize: 2.94 MB AGGREGATION_NODE (id=3):(Total: 339.782ms, non-child: 120.156ms, % non-child: 35.36%) ExecOption: Codegen Enabled - BuildBuckets: 131.07K (131072) - BuildTime: 111.703ms - GetResultsTime: 4.889ms - LoadFactor: 0.70 - PeakMemoryUsage: 10.28 MB - RowsReturned: 154.21K (154205) - RowsReturnedRate: 453.83 K/sec HDFS_SCAN_NODE (id=2):(Total: 219.626ms, non-child: 219.626ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 0:1/23.08 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% File Formats: RC_FILE/DEFAULT:1 ExecOption: Codegen enabled: 0 out of 2 BytesRead(500.0ms): 0 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 23.08 MB - BytesReadDataNodeCache: 0 - BytesReadLocal: 23.08 MB - BytesReadShortCircuit: 23.08 MB - BytesSkipped: 0 - DecompressionTime: 124.527ms - NumDisksAccessed: 2 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 25.12 MB - PerReadThreadRawHdfsThroughput: 2.10 GB/sec - RowsRead: 2.09M (2089237) - RowsReturned: 2.09M (2089237) - RowsReturnedRate: 9.51 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 4 - ScannerThreadsTotalWallClockTime: 332.668ms - MaterializeTupleTime(*): 199.581ms - ScannerThreadsSysTime: 2.999ms - ScannerThreadsUserTime: 319.951ms - ScannerThreadsVoluntaryContextSwitches: 5 - TotalRawHdfsReadTime(*): 10.709ms - TotalReadThroughput: 0.00 /sec Fragment 4: Instance 3d44799788c4315e:ddd707e711cc5d3 (host=hadoop-slave09.local:22000):(Total: 71.894ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 4:1/11.04 MB 5:1/11.54 MB - AverageThreadTokens: 0.00 - PeakMemoryUsage: 29.27 MB - PrepareTime: 1.613ms - RowsProduced: 76.81K (76805) - TotalCpuTime: 280.267ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 4.226ms - TotalStorageWaitTime: 9.967ms CodeGen:(Total: 97.197ms, non-child: 97.197ms, % non-child: 100.00%) - CodegenTime: 1.531ms - CompileTime: 91.116ms - LoadTime: 5.536ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=7):(Total: 10.523ms, non-child: 10.523ms, % non-child: 100.00%) - BytesSent: 699.85 KB - NetworkThroughput(*): 24.49 MB/sec - OverallThroughput: 64.95 MB/sec - PeakMemoryUsage: 440.00 KB - SerializeBatchTime: 4.359ms - ThriftTransmitTime(*): 27.911ms - UncompressedRowBatchSize: 900.21 KB AGGREGATION_NODE (id=1):(Total: 62.937ms, non-child: 26.797ms, % non-child: 42.58%) ExecOption: Codegen Enabled - BuildBuckets: 65.54K (65536) - BuildTime: 22.358ms - GetResultsTime: 2.389ms - LoadFactor: 0.69 - PeakMemoryUsage: 4.41 MB - RowsReturned: 76.81K (76805) - RowsReturnedRate: 1.22 M/sec HDFS_SCAN_NODE (id=0):(Total: 36.139ms, non-child: 36.139ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 4:1/11.04 MB 5:1/11.54 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% File Formats: RC_FILE/DEFAULT:2 ExecOption: Codegen enabled: 0 out of 4 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 22.58 MB - BytesReadDataNodeCache: 0 - BytesReadLocal: 22.58 MB - BytesReadShortCircuit: 22.58 MB - BytesSkipped: 0 - DecompressionTime: 54.714ms - NumDisksAccessed: 3 - NumScannerThreadsStarted: 2 - PeakMemoryUsage: 26.07 MB - PerReadThreadRawHdfsThroughput: 2.91 GB/sec - RowsRead: 364.18K (364178) - RowsReturned: 364.18K (364178) - RowsReturnedRate: 10.08 M/sec - ScanRangesComplete: 2 - ScannerThreadsInvoluntaryContextSwitches: 4 - ScannerThreadsTotalWallClockTime: 115.584ms - MaterializeTupleTime(*): 49.997ms - ScannerThreadsSysTime: 0ns - ScannerThreadsUserTime: 103.983ms - ScannerThreadsVoluntaryContextSwitches: 15 - TotalRawHdfsReadTime(*): 7.568ms - TotalReadThroughput: 0.00 /sec Instance 3d44799788c4315e:ddd707e711cc5d7 (host=hadoop-slave10.local:22000):(Total: 68.704ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 0:1/11.20 MB MemoryUsage(500.0ms): 7.54 MB ThreadUsage(500.0ms): 2 - AverageThreadTokens: 2.00 - PeakMemoryUsage: 15.54 MB - PrepareTime: 1.782ms - RowsProduced: 52.86K (52856) - TotalCpuTime: 232.782ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 4.500ms - TotalStorageWaitTime: 4.156ms CodeGen:(Total: 105.271ms, non-child: 105.271ms, % non-child: 100.00%) - CodegenTime: 1.701ms - CompileTime: 98.222ms - LoadTime: 6.326ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=7):(Total: 7.87ms, non-child: 7.87ms, % non-child: 100.00%) - BytesSent: 481.35 KB - NetworkThroughput(*): 23.75 MB/sec - OverallThroughput: 66.32 MB/sec - PeakMemoryUsage: 440.00 KB - SerializeBatchTime: 3.77ms - ThriftTransmitTime(*): 19.790ms - UncompressedRowBatchSize: 619.52 KB AGGREGATION_NODE (id=1):(Total: 63.376ms, non-child: 19.473ms, % non-child: 30.73%) ExecOption: Codegen Enabled - BuildBuckets: 65.54K (65536) - BuildTime: 13.69ms - GetResultsTime: 1.642ms - LoadFactor: 0.55 - PeakMemoryUsage: 3.23 MB - RowsReturned: 52.86K (52856) - RowsReturnedRate: 834.00 K/sec HDFS_SCAN_NODE (id=0):(Total: 43.902ms, non-child: 43.902ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 0:1/11.20 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% File Formats: RC_FILE/DEFAULT:1 ExecOption: Codegen enabled: 0 out of 2 BytesRead(500.0ms): 11.20 MB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 1.00 - BytesRead: 11.20 MB - BytesReadDataNodeCache: 0 - BytesReadLocal: 11.20 MB - BytesReadShortCircuit: 11.20 MB - BytesSkipped: 0 - DecompressionTime: 27.529ms - NumDisksAccessed: 2 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 13.27 MB - PerReadThreadRawHdfsThroughput: 2.39 GB/sec - RowsRead: 180.84K (180843) - RowsReturned: 180.84K (180843) - RowsReturnedRate: 4.12 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 57.21ms - MaterializeTupleTime(*): 24.101ms - ScannerThreadsSysTime: 0ns - ScannerThreadsUserTime: 50.992ms - ScannerThreadsVoluntaryContextSwitches: 6 - TotalRawHdfsReadTime(*): 4.578ms - TotalReadThroughput: 22.41 MB/sec Instance 3d44799788c4315e:ddd707e711cc5d6 (host=hadoop-slave04.local:22000):(Total: 68.429ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 4:1/11.14 MB 5:1/10.84 MB MemoryUsage(500.0ms): 200.00 KB ThreadUsage(500.0ms): 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 29.68 MB - PrepareTime: 1.648ms - RowsProduced: 74.49K (74489) - TotalCpuTime: 272.421ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3.714ms - TotalStorageWaitTime: 10.468ms CodeGen:(Total: 97.52ms, non-child: 97.52ms, % non-child: 100.00%) - CodegenTime: 1.548ms - CompileTime: 90.928ms - LoadTime: 5.577ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=7):(Total: 9.509ms, non-child: 9.509ms, % non-child: 100.00%) - BytesSent: 678.50 KB - NetworkThroughput(*): 24.09 MB/sec - OverallThroughput: 69.68 MB/sec - PeakMemoryUsage: 440.00 KB - SerializeBatchTime: 3.889ms - ThriftTransmitTime(*): 27.499ms - UncompressedRowBatchSize: 873.07 KB AGGREGATION_NODE (id=1):(Total: 60.514ms, non-child: 24.906ms, % non-child: 41.16%) ExecOption: Codegen Enabled - BuildBuckets: 65.54K (65536) - BuildTime: 20.532ms - GetResultsTime: 2.283ms - LoadFactor: 0.68 - PeakMemoryUsage: 5.42 MB - RowsReturned: 74.49K (74489) - RowsReturnedRate: 1.23 M/sec HDFS_SCAN_NODE (id=0):(Total: 35.608ms, non-child: 35.608ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 4:1/11.14 MB 5:1/10.84 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% File Formats: RC_FILE/DEFAULT:2 ExecOption: Codegen enabled: 0 out of 4 BytesRead(500.0ms): 0 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 21.99 MB - BytesReadDataNodeCache: 0 - BytesReadLocal: 21.99 MB - BytesReadShortCircuit: 21.99 MB - BytesSkipped: 0 - DecompressionTime: 52.758ms - NumDisksAccessed: 4 - NumScannerThreadsStarted: 2 - PeakMemoryUsage: 27.16 MB - PerReadThreadRawHdfsThroughput: 2.46 GB/sec - RowsRead: 353.38K (353378) - RowsReturned: 353.38K (353378) - RowsReturnedRate: 9.92 M/sec - ScanRangesComplete: 2 - ScannerThreadsInvoluntaryContextSwitches: 1 - ScannerThreadsTotalWallClockTime: 111.889ms - MaterializeTupleTime(*): 47.836ms - ScannerThreadsSysTime: 0ns - ScannerThreadsUserTime: 99.984ms - ScannerThreadsVoluntaryContextSwitches: 12 - TotalRawHdfsReadTime(*): 8.720ms - TotalReadThroughput: 0.00 /sec Instance 3d44799788c4315e:ddd707e711cc5d1 (host=hadoop-slave07.local:22000):(Total: 65.264ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 4:1/10.92 MB - AverageThreadTokens: 0.00 - PeakMemoryUsage: 16.43 MB - PrepareTime: 2.18ms - RowsProduced: 52.64K (52637) - TotalCpuTime: 223.885ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 5.812ms - TotalStorageWaitTime: 4.903ms CodeGen:(Total: 101.68ms, non-child: 101.68ms, % non-child: 100.00%) - CodegenTime: 1.922ms - CompileTime: 94.380ms - LoadTime: 6.50ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=7):(Total: 7.210ms, non-child: 7.210ms, % non-child: 100.00%) - BytesSent: 479.42 KB - NetworkThroughput(*): 17.21 MB/sec - OverallThroughput: 64.93 MB/sec - PeakMemoryUsage: 440.00 KB - SerializeBatchTime: 3.190ms - ThriftTransmitTime(*): 27.212ms - UncompressedRowBatchSize: 616.96 KB AGGREGATION_NODE (id=1):(Total: 60.65ms, non-child: 18.790ms, % non-child: 31.28%) ExecOption: Codegen Enabled - BuildBuckets: 65.54K (65536) - BuildTime: 14.821ms - GetResultsTime: 1.697ms - LoadFactor: 0.55 - PeakMemoryUsage: 4.22 MB - RowsReturned: 52.64K (52637) - RowsReturnedRate: 876.33 K/sec HDFS_SCAN_NODE (id=0):(Total: 41.275ms, non-child: 41.275ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 4:1/10.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% File Formats: RC_FILE/DEFAULT:1 ExecOption: Codegen enabled: 0 out of 2 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 10.92 MB - BytesReadDataNodeCache: 0 - BytesReadLocal: 10.92 MB - BytesReadShortCircuit: 10.92 MB - BytesSkipped: 0 - DecompressionTime: 26.840ms - NumDisksAccessed: 2 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 14.17 MB - PerReadThreadRawHdfsThroughput: 2.57 GB/sec - RowsRead: 174.95K (174947) - RowsReturned: 174.95K (174947) - RowsReturnedRate: 4.24 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 56.78ms - MaterializeTupleTime(*): 23.673ms - ScannerThreadsSysTime: 0ns - ScannerThreadsUserTime: 49.992ms - ScannerThreadsVoluntaryContextSwitches: 5 - TotalRawHdfsReadTime(*): 4.140ms - TotalReadThroughput: 0.00 /sec Instance 3d44799788c4315e:ddd707e711cc5d0 (host=hadoop-slave05.local:22000):(Total: 64.81ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 2:1/11.27 MB - AverageThreadTokens: 0.00 - PeakMemoryUsage: 15.46 MB - PrepareTime: 1.680ms - RowsProduced: 53.80K (53797) - TotalCpuTime: 218.196ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 5.112ms - TotalStorageWaitTime: 4.905ms CodeGen:(Total: 98.16ms, non-child: 98.16ms, % non-child: 100.00%) - CodegenTime: 1.597ms - CompileTime: 91.766ms - LoadTime: 5.689ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=7):(Total: 6.966ms, non-child: 6.966ms, % non-child: 100.00%) - BytesSent: 489.96 KB - NetworkThroughput(*): 22.67 MB/sec - OverallThroughput: 68.68 MB/sec - PeakMemoryUsage: 440.00 KB - SerializeBatchTime: 2.959ms - ThriftTransmitTime(*): 21.106ms - UncompressedRowBatchSize: 630.55 KB AGGREGATION_NODE (id=1):(Total: 58.771ms, non-child: 16.547ms, % non-child: 28.16%) ExecOption: Codegen Enabled - BuildBuckets: 65.54K (65536) - BuildTime: 12.969ms - GetResultsTime: 1.645ms - LoadFactor: 0.56 - PeakMemoryUsage: 4.24 MB - RowsReturned: 53.80K (53797) - RowsReturnedRate: 915.36 K/sec HDFS_SCAN_NODE (id=0):(Total: 42.224ms, non-child: 42.224ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 2:1/11.27 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% File Formats: RC_FILE/DEFAULT:1 ExecOption: Codegen enabled: 0 out of 2 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 11.27 MB - BytesReadDataNodeCache: 0 - BytesReadLocal: 11.27 MB - BytesReadShortCircuit: 11.27 MB - BytesSkipped: 0 - DecompressionTime: 26.164ms - NumDisksAccessed: 2 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 13.20 MB - PerReadThreadRawHdfsThroughput: 2.88 GB/sec - RowsRead: 181.21K (181209) - RowsReturned: 181.21K (181209) - RowsReturnedRate: 4.29 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 55.238ms - MaterializeTupleTime(*): 23.737ms - ScannerThreadsSysTime: 0ns - ScannerThreadsUserTime: 48.992ms - ScannerThreadsVoluntaryContextSwitches: 5 - TotalRawHdfsReadTime(*): 3.822ms - TotalReadThroughput: 0.00 /sec Instance 3d44799788c4315e:ddd707e711cc5d4 (host=hadoop-slave01.local:22000):(Total: 63.873ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 3:1/11.20 MB MemoryUsage(500.0ms): 200.00 KB ThreadUsage(500.0ms): 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 15.47 MB - PrepareTime: 1.709ms - RowsProduced: 53.86K (53858) - TotalCpuTime: 217.283ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 4.585ms - TotalStorageWaitTime: 5.79ms CodeGen:(Total: 97.790ms, non-child: 97.790ms, % non-child: 100.00%) - CodegenTime: 1.628ms - CompileTime: 91.318ms - LoadTime: 5.849ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=7):(Total: 7.253ms, non-child: 7.253ms, % non-child: 100.00%) - BytesSent: 490.49 KB - NetworkThroughput(*): 23.37 MB/sec - OverallThroughput: 66.04 MB/sec - PeakMemoryUsage: 440.00 KB - SerializeBatchTime: 3.111ms - ThriftTransmitTime(*): 20.492ms - UncompressedRowBatchSize: 631.27 KB AGGREGATION_NODE (id=1):(Total: 58.321ms, non-child: 15.981ms, % non-child: 27.40%) ExecOption: Codegen Enabled - BuildBuckets: 65.54K (65536) - BuildTime: 12.389ms - GetResultsTime: 1.649ms - LoadFactor: 0.56 - PeakMemoryUsage: 3.24 MB - RowsReturned: 53.86K (53858) - RowsReturnedRate: 923.46 K/sec HDFS_SCAN_NODE (id=0):(Total: 42.340ms, non-child: 42.340ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 3:1/11.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% File Formats: RC_FILE/DEFAULT:1 ExecOption: Codegen enabled: 0 out of 2 BytesRead(500.0ms): 0 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 11.20 MB - BytesReadDataNodeCache: 0 - BytesReadLocal: 11.20 MB - BytesReadShortCircuit: 11.20 MB - BytesSkipped: 0 - DecompressionTime: 26.22ms - NumDisksAccessed: 2 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 13.20 MB - PerReadThreadRawHdfsThroughput: 2.61 GB/sec - RowsRead: 180.35K (180347) - RowsReturned: 180.35K (180347) - RowsReturnedRate: 4.26 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 54.783ms - MaterializeTupleTime(*): 23.384ms - ScannerThreadsSysTime: 0ns - ScannerThreadsUserTime: 47.992ms - ScannerThreadsVoluntaryContextSwitches: 5 - TotalRawHdfsReadTime(*): 4.185ms - TotalReadThroughput: 0.00 /sec Instance 3d44799788c4315e:ddd707e711cc5d2 (host=hadoop-slave06.local:22000):(Total: 63.495ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 2:1/11.23 MB MemoryUsage(500.0ms): 8.22 MB ThreadUsage(500.0ms): 2 - AverageThreadTokens: 2.00 - PeakMemoryUsage: 15.56 MB - PrepareTime: 1.564ms - RowsProduced: 53.16K (53164) - TotalCpuTime: 215.20ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 4.451ms - TotalStorageWaitTime: 4.754ms CodeGen:(Total: 96.558ms, non-child: 96.558ms, % non-child: 100.00%) - CodegenTime: 1.487ms - CompileTime: 90.491ms - LoadTime: 5.431ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=7):(Total: 6.945ms, non-child: 6.945ms, % non-child: 100.00%) - BytesSent: 484.28 KB - NetworkThroughput(*): 22.62 MB/sec - OverallThroughput: 68.10 MB/sec - PeakMemoryUsage: 440.00 KB - SerializeBatchTime: 2.775ms - ThriftTransmitTime(*): 20.911ms - UncompressedRowBatchSize: 623.13 KB AGGREGATION_NODE (id=1):(Total: 58.87ms, non-child: 15.788ms, % non-child: 27.18%) ExecOption: Codegen Enabled - BuildBuckets: 65.54K (65536) - BuildTime: 12.315ms - GetResultsTime: 1.663ms - LoadFactor: 0.56 - PeakMemoryUsage: 3.23 MB - RowsReturned: 53.16K (53164) - RowsReturnedRate: 915.24 K/sec HDFS_SCAN_NODE (id=0):(Total: 42.299ms, non-child: 42.299ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 2:1/11.23 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:100% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% File Formats: RC_FILE/DEFAULT:1 ExecOption: Codegen enabled: 0 out of 2 BytesRead(500.0ms): 1024.00 B - AverageHdfsReadThreadConcurrency: 1.00 - AverageScannerThreadConcurrency: 1.00 - BytesRead: 11.23 MB - BytesReadDataNodeCache: 0 - BytesReadLocal: 11.23 MB - BytesReadShortCircuit: 11.23 MB - BytesSkipped: 0 - DecompressionTime: 26.21ms - NumDisksAccessed: 2 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 13.29 MB - PerReadThreadRawHdfsThroughput: 2.77 GB/sec - RowsRead: 180.96K (180963) - RowsReturned: 180.96K (180963) - RowsReturnedRate: 4.28 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 54.674ms - MaterializeTupleTime(*): 23.582ms - ScannerThreadsSysTime: 0ns - ScannerThreadsUserTime: 48.992ms - ScannerThreadsVoluntaryContextSwitches: 5 - TotalRawHdfsReadTime(*): 3.966ms - TotalReadThroughput: 2.00 KB/sec Instance 3d44799788c4315e:ddd707e711cc5d5 (host=hadoop-slave08.local:22000):(Total: 63.482ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 5:1/10.89 MB - AverageThreadTokens: 0.00 - PeakMemoryUsage: 15.47 MB - PrepareTime: 1.760ms - RowsProduced: 52.49K (52493) - TotalCpuTime: 221.937ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 4.642ms - TotalStorageWaitTime: 4.373ms CodeGen:(Total: 101.193ms, non-child: 101.193ms, % non-child: 100.00%) - CodegenTime: 1.661ms - CompileTime: 94.96ms - LoadTime: 6.224ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=7):(Total: 6.718ms, non-child: 6.718ms, % non-child: 100.00%) - BytesSent: 478.26 KB - NetworkThroughput(*): 20.66 MB/sec - OverallThroughput: 69.52 MB/sec - PeakMemoryUsage: 440.00 KB - SerializeBatchTime: 2.842ms - ThriftTransmitTime(*): 22.609ms - UncompressedRowBatchSize: 615.27 KB AGGREGATION_NODE (id=1):(Total: 58.503ms, non-child: 16.273ms, % non-child: 27.82%) ExecOption: Codegen Enabled - BuildBuckets: 65.54K (65536) - BuildTime: 12.668ms - GetResultsTime: 1.602ms - LoadFactor: 0.55 - PeakMemoryUsage: 4.23 MB - RowsReturned: 52.49K (52493) - RowsReturnedRate: 897.27 K/sec HDFS_SCAN_NODE (id=0):(Total: 42.229ms, non-child: 42.229ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 5:1/10.89 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% File Formats: RC_FILE/DEFAULT:1 ExecOption: Codegen enabled: 0 out of 2 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 10.89 MB - BytesReadDataNodeCache: 0 - BytesReadLocal: 10.89 MB - BytesReadShortCircuit: 10.89 MB - BytesSkipped: 0 - DecompressionTime: 26.310ms - NumDisksAccessed: 2 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 13.20 MB - PerReadThreadRawHdfsThroughput: 2.80 GB/sec - RowsRead: 174.67K (174667) - RowsReturned: 174.67K (174667) - RowsReturnedRate: 4.14 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 2 - ScannerThreadsTotalWallClockTime: 54.945ms - MaterializeTupleTime(*): 23.655ms - ScannerThreadsSysTime: 1.999ms - ScannerThreadsUserTime: 47.992ms - ScannerThreadsVoluntaryContextSwitches: 6 - TotalRawHdfsReadTime(*): 3.796ms - TotalReadThroughput: 0.00 /sec Instance 3d44799788c4315e:ddd707e711cc5d9 (host=hadoop-slave02.local:22000):(Total: 63.305ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 4:1/11.22 MB - AverageThreadTokens: 0.00 - PeakMemoryUsage: 15.55 MB - PrepareTime: 1.689ms - RowsProduced: 53.38K (53377) - TotalCpuTime: 215.646ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 4.694ms - TotalStorageWaitTime: 4.354ms CodeGen:(Total: 96.807ms, non-child: 96.807ms, % non-child: 100.00%) - CodegenTime: 1.612ms - CompileTime: 90.572ms - LoadTime: 5.684ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=7):(Total: 7.210ms, non-child: 7.210ms, % non-child: 100.00%) - BytesSent: 486.08 KB - NetworkThroughput(*): 24.20 MB/sec - OverallThroughput: 65.83 MB/sec - PeakMemoryUsage: 440.00 KB - SerializeBatchTime: 3.128ms - ThriftTransmitTime(*): 19.616ms - UncompressedRowBatchSize: 625.63 KB AGGREGATION_NODE (id=1):(Total: 57.762ms, non-child: 16.800ms, % non-child: 29.09%) ExecOption: Codegen Enabled - BuildBuckets: 65.54K (65536) - BuildTime: 13.243ms - GetResultsTime: 1.637ms - LoadFactor: 0.56 - PeakMemoryUsage: 3.23 MB - RowsReturned: 53.38K (53377) - RowsReturnedRate: 924.07 K/sec HDFS_SCAN_NODE (id=0):(Total: 40.962ms, non-child: 40.962ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 4:1/11.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% File Formats: RC_FILE/DEFAULT:1 ExecOption: Codegen enabled: 0 out of 2 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 11.22 MB - BytesReadDataNodeCache: 0 - BytesReadLocal: 11.22 MB - BytesReadShortCircuit: 11.22 MB - BytesSkipped: 0 - DecompressionTime: 25.997ms - NumDisksAccessed: 2 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 13.28 MB - PerReadThreadRawHdfsThroughput: 2.90 GB/sec - RowsRead: 180.78K (180776) - RowsReturned: 180.78K (180776) - RowsReturnedRate: 4.41 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 54.262ms - MaterializeTupleTime(*): 23.581ms - ScannerThreadsSysTime: 0ns - ScannerThreadsUserTime: 48.992ms - ScannerThreadsVoluntaryContextSwitches: 5 - TotalRawHdfsReadTime(*): 3.778ms - TotalReadThroughput: 0.00 /sec Instance 3d44799788c4315e:ddd707e711cc5d8 (host=hadoop-slave03.local:22000):(Total: 62.914ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 2:1/11.12 MB MemoryUsage(500.0ms): 200.00 KB ThreadUsage(500.0ms): 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 15.46 MB - PrepareTime: 1.684ms - RowsProduced: 53.46K (53461) - TotalCpuTime: 219.481ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 5.906ms - TotalStorageWaitTime: 4.545ms CodeGen:(Total: 101.55ms, non-child: 101.55ms, % non-child: 100.00%) - CodegenTime: 1.598ms - CompileTime: 94.404ms - LoadTime: 6.56ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=7):(Total: 6.940ms, non-child: 6.940ms, % non-child: 100.00%) - BytesSent: 486.95 KB - NetworkThroughput(*): 16.79 MB/sec - OverallThroughput: 68.51 MB/sec - PeakMemoryUsage: 440.00 KB - SerializeBatchTime: 2.827ms - ThriftTransmitTime(*): 28.324ms - UncompressedRowBatchSize: 626.61 KB AGGREGATION_NODE (id=1):(Total: 57.629ms, non-child: 16.50ms, % non-child: 27.85%) ExecOption: Codegen Enabled - BuildBuckets: 65.54K (65536) - BuildTime: 12.505ms - GetResultsTime: 1.612ms - LoadFactor: 0.56 - PeakMemoryUsage: 4.23 MB - RowsReturned: 53.46K (53461) - RowsReturnedRate: 927.66 K/sec HDFS_SCAN_NODE (id=0):(Total: 41.579ms, non-child: 41.579ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 2:1/11.12 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% File Formats: RC_FILE/DEFAULT:1 ExecOption: Codegen enabled: 0 out of 2 BytesRead(500.0ms): 0 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 11.12 MB - BytesReadDataNodeCache: 0 - BytesReadLocal: 11.12 MB - BytesReadShortCircuit: 11.12 MB - BytesSkipped: 0 - DecompressionTime: 25.850ms - NumDisksAccessed: 2 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 13.19 MB - PerReadThreadRawHdfsThroughput: 2.87 GB/sec - RowsRead: 178.66K (178659) - RowsReturned: 178.66K (178659) - RowsReturnedRate: 4.30 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 54.142ms - MaterializeTupleTime(*): 23.301ms - ScannerThreadsSysTime: 0ns - ScannerThreadsUserTime: 47.992ms - ScannerThreadsVoluntaryContextSwitches: 5 - TotalRawHdfsReadTime(*): 3.779ms - TotalReadThroughput: 0.00 /sec