Query (id=334a8aa14f3dd18b:1272da4a8181958d): Summary: Session ID: 9d4e5bc4be47472b:7aff732f57e0debc Session Type: BEESWAX Start Time: 2014-07-15 16:59:53.762671000 End Time: 2014-07-15 17:00:01.048057000 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:55403 Default Db: default Sql Statement: select COUNT(DISTINCT b.doc_id) FROM ( SELECT doc_id FROM `stats`.pmp_interactions ) a FULL OUTER JOIN ( SELECT 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=256.00MB VCores=2 WARNING: The following tables are missing relevant table and/or column statistics. stats.pmp_interactions, warehouse.pmp_interactions_read_times F04:PLAN FRAGMENT [PARTITION=UNPARTITIONED] 10:AGGREGATE [MERGE FINALIZE] | output: sum(count(b.doc_id)) | hosts=10 per-host-mem=unavailable | tuple-ids=5 row-size=8B cardinality=1 | 09:EXCHANGE [PARTITION=UNPARTITIONED] hosts=10 per-host-mem=unavailable tuple-ids=5 row-size=8B cardinality=1 F03:PLAN FRAGMENT [PARTITION=HASH(b.doc_id)] DATASTREAM SINK [FRAGMENT=F04, EXCHANGE=09, PARTITION=UNPARTITIONED] 04:AGGREGATE [MERGE] | output: count(b.doc_id) | hosts=10 per-host-mem=10.00MB | tuple-ids=5 row-size=8B cardinality=1 | 08:AGGREGATE [MERGE] | group by: b.doc_id | hosts=10 per-host-mem=128.00MB | tuple-ids=4 row-size=8B cardinality=4239204 | 07:EXCHANGE [PARTITION=HASH(b.doc_id)] hosts=10 per-host-mem=0B tuple-ids=4 row-size=8B cardinality=4239204 F02:PLAN FRAGMENT [PARTITION=HASH(doc_id)] DATASTREAM SINK [FRAGMENT=F03, EXCHANGE=07, PARTITION=HASH(b.doc_id)] 03:AGGREGATE | group by: doc_id | hosts=10 per-host-mem=128.00MB | tuple-ids=4 row-size=8B cardinality=4239204 | 02: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=5.04MB | tuple-ids=0N,2N row-size=27B cardinality=4239204 | |--06:EXCHANGE [PARTITION=HASH(doc_id)] | hosts=10 per-host-mem=0B | tuple-ids=2 row-size=23B cardinality=2089237 | 05:EXCHANGE [PARTITION=HASH(doc_id)] hosts=10 per-host-mem=0B tuple-ids=0 row-size=4B cardinality=2149967 F01:PLAN FRAGMENT [PARTITION=RANDOM] DATASTREAM SINK [FRAGMENT=F02, EXCHANGE=06, PARTITION=HASH(doc_id)] 01: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=2 row-size=23B cardinality=2089237 F00:PLAN FRAGMENT [PARTITION=RANDOM] DATASTREAM SINK [FRAGMENT=F02, EXCHANGE=05, PARTITION=HASH(doc_id)] 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: 268435456 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: 7s290ms - Start execution: 1.526ms (1.526ms) - Planning finished: 198.892ms (197.365ms) - Submit for admission: 199.940ms (1.48ms) - Completed admission: 199.980ms (40.223us) - Rows available: 7s242ms (7s042ms) - First row fetched: 7s271ms (29.180ms) - Unregister query: 7s285ms (13.963ms) ImpalaServer: - ClientFetchWaitTimer: 41.568ms - RowMaterializationTimer: 4.955us Execution Profile 334a8aa14f3dd18b:1272da4a8181958d:(Total: 7s042ms, non-child: 0ns, % non-child: 0.00%) Per Node Peak Memory Usage: hadoop-slave05.local:22000(13.59 MB) hadoop-slave07.local:22000(14.52 MB) hadoop-slave06.local:22000(13.91 MB) hadoop-slave09.local:22000(26.44 MB) hadoop-slave01.local:22000(13.53 MB) hadoop-slave04.local:22000(26.92 MB) hadoop-slave08.local:22000(26.49 MB) hadoop-slave10.local:22000(13.63 MB) hadoop-slave03.local:22000(13.62 MB) hadoop-slave02.local:22000(13.57 MB) - FinalizationTimer: 0ns Coordinator Fragment:(Total: 6s533ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 44.00 KB, 44.00 KB, 44.00 KB, 44.00 KB, 44.00 KB, 44.00 KB, 44.00 KB, 44.00 KB, 44.00 KB, 44.00 KB, 44.00 KB, 44.00 KB, 44.00 KB, 44.00 KB ThreadUsage(500.0ms): 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 92.02 KB - PrepareTime: 289.861us - RowsProduced: 1 - TotalCpuTime: 537.300ms - TotalNetworkReceiveTime: 6s533ms - TotalNetworkSendTime: 0ns - TotalStorageWaitTime: 0ns CodeGen:(Total: 71.530ms, non-child: 71.530ms, % non-child: 100.00%) - CodegenTime: 241.905us - CompileTime: 65.540ms - LoadTime: 5.384ms - ModuleFileSize: 105.51 KB AGGREGATION_NODE (id=10):(Total: 6s533ms, non-child: 316.161us, % non-child: 0.00%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 6.272us - GetResultsTime: 2.168us - LoadFactor: 0.00 - PeakMemoryUsage: 84.00 KB - RowsReturned: 1 - RowsReturnedRate: 0 EXCHANGE_NODE (id=9):(Total: 6s533ms, non-child: 6s533ms, % non-child: 100.00%) BytesReceived(500.0ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - BytesReceived: 160.00 B - ConvertRowBatchTime: 3.699us - DataArrivalWaitTime: 6s533ms - DeserializeRowBatchTimer: 36.290us - FirstBatchArrivalWaitTime: 6s531ms - PeakMemoryUsage: 4.02 KB - RowsReturned: 10 - RowsReturnedRate: 1.00 /sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Averaged Fragment 1:(Total: 6s851ms, non-child: 0ns, % non-child: 0.00%) split sizes: min: 0, max: 0, avg: 0, stddev: 0 completion times: min:6s846ms max:6s862ms mean: 6s852ms stddev:5.80ms 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: 108.00 KB - PrepareTime: 1.942ms - RowsProduced: 1 - TotalCpuTime: 103.239ms - TotalNetworkReceiveTime: 6s851ms - TotalNetworkSendTime: 142.135us - TotalStorageWaitTime: 0ns CodeGen:(Total: 100.265ms, non-child: 100.265ms, % non-child: 100.00%) - CodegenTime: 1.851ms - CompileTime: 93.729ms - LoadTime: 5.651ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=9):(Total: 27.952us, non-child: 27.952us, % non-child: 100.00%) - BytesSent: 16.00 B - NetworkThroughput(*): 137.97 KB/sec - OverallThroughput: 563.98 KB/sec - PeakMemoryUsage: 16.00 KB - SerializeBatchTime: 8.989us - ThriftTransmitTime(*): 120.18us - UncompressedRowBatchSize: 16.00 B AGGREGATION_NODE (id=4):(Total: 6s853ms, non-child: 238.409us, % non-child: 0.00%) - BuildBuckets: 1.02K (1024) - BuildTime: 1.272us - GetResultsTime: 2.339us - LoadFactor: 0.00 - PeakMemoryUsage: 44.00 KB - RowsReturned: 1 - RowsReturnedRate: 0 AGGREGATION_NODE (id=8):(Total: 6s853ms, non-child: 1.753ms, % non-child: 0.03%) - BuildBuckets: 1.02K (1024) - BuildTime: 15.492us - GetResultsTime: 4.240us - LoadFactor: 0.08 - PeakMemoryUsage: 48.00 KB - RowsReturned: 88 - RowsReturnedRate: 12.00 /sec EXCHANGE_NODE (id=7):(Total: 6s851ms, non-child: 6s851ms, % non-child: 100.00%) - BytesReceived: 962.00 B - ConvertRowBatchTime: 2.395us - DataArrivalWaitTime: 6s851ms - DeserializeRowBatchTimer: 9.379us - FirstBatchArrivalWaitTime: 4s282ms - PeakMemoryUsage: 4.69 KB - RowsReturned: 88 - RowsReturnedRate: 12.00 /sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Averaged Fragment 2:(Total: 4s150ms, non-child: 0ns, % non-child: 0.00%) split sizes: min: 0, max: 0, avg: 0, stddev: 0 completion times: min:3s272ms max:6s727ms mean: 4s153ms stddev:1s003ms execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec num instances: 10 - AverageThreadTokens: 1.15 - PeakMemoryUsage: 13.37 MB - PrepareTime: 2.219ms - RowsProduced: 88 - TotalCpuTime: 4s107ms - TotalNetworkReceiveTime: 690.801ms - TotalNetworkSendTime: 125.607us - TotalStorageWaitTime: 0ns CodeGen:(Total: 106.394ms, non-child: 106.394ms, % non-child: 100.00%) - CodegenTime: 1.663ms - CompileTime: 100.689ms - LoadTime: 5.153ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=7):(Total: 29.476us, non-child: 29.476us, % non-child: 100.00%) - BytesSent: 962.00 B - NetworkThroughput(*): 9.08 MB/sec - OverallThroughput: 31.53 MB/sec - PeakMemoryUsage: 84.00 KB - SerializeBatchTime: 22.576us - ThriftTransmitTime(*): 101.621us - UncompressedRowBatchSize: 1.73 KB AGGREGATION_NODE (id=3):(Total: 4s153ms, non-child: 2.295ms, % non-child: 0.06%) - BuildBuckets: 1.02K (1024) - BuildTime: 98.555us - GetResultsTime: 5.151us - LoadFactor: 0.08 - PeakMemoryUsage: 1.70 MB - RowsReturned: 88 - RowsReturnedRate: 21.00 /sec HASH_JOIN_NODE (id=2):(Total: 4s150ms, non-child: 3s453ms, % non-child: 83.19%) - BuildBuckets: 16.38K (16384) - BuildRows: 208.92K (208923) - BuildTime: 19.21ms - LeftChildRows: 215.00K (214996) - LeftChildTime: 3s610ms - LoadFactor: 0.61 - PeakMemoryUsage: 9.96 MB - RowsReturned: 112 - RowsReturnedRate: 27.00 /sec EXCHANGE_NODE (id=6):(Total: 517.225ms, non-child: 517.225ms, % non-child: 100.00%) - BytesReceived: 1.97 MB - ConvertRowBatchTime: 3.324ms - DataArrivalWaitTime: 513.220ms - DeserializeRowBatchTimer: 6.771ms - FirstBatchArrivalWaitTime: 205.331ms - PeakMemoryUsage: 76.80 KB - RowsReturned: 208.92K (208923) - RowsReturnedRate: 404.02 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns EXCHANGE_NODE (id=5):(Total: 180.403ms, non-child: 180.403ms, % non-child: 100.00%) - BytesReceived: 2.18 MB - ConvertRowBatchTime: 3.116ms - DataArrivalWaitTime: 176.858ms - DeserializeRowBatchTimer: 5.498ms - FirstBatchArrivalWaitTime: 176.858ms - PeakMemoryUsage: 3.28 MB - RowsReturned: 215.00K (214996) - RowsReturnedRate: 1.19 M/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Averaged Fragment 3:(Total: 454.350ms, 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:460.700ms max:460.700ms mean: 460.700ms stddev:0ns execution rates: min:50.09 MB/sec max:50.09 MB/sec mean:50.09 MB/sec stddev:0.00 /sec num instances: 1 - AverageThreadTokens: 1.50 - PeakMemoryUsage: 26.49 MB - PrepareTime: 161.896us - RowsProduced: 2.09M (2089237) - TotalCpuTime: 859.746ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 8.640ms - TotalStorageWaitTime: 117.72ms CodeGen:(Total: 69.853ms, non-child: 69.853ms, % non-child: 100.00%) - CodegenTime: 106.240us - CompileTime: 63.993ms - LoadTime: 5.239ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=6):(Total: 292.300ms, non-child: 292.300ms, % non-child: 100.00%) - BytesSent: 19.73 MB - NetworkThroughput(*): 30.27 MB/sec - OverallThroughput: 67.50 MB/sec - PeakMemoryUsage: 360.00 KB - SerializeBatchTime: 130.977ms - ThriftTransmitTime(*): 651.707ms - UncompressedRowBatchSize: 39.86 MB HDFS_SCAN_NODE (id=1):(Total: 160.273ms, non-child: 160.273ms, % non-child: 100.00%) - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 1.00 - BytesRead: 23.08 MB - BytesReadDataNodeCache: 0 - BytesReadLocal: 23.08 MB - BytesReadShortCircuit: 23.08 MB - BytesSkipped: 0 - DecompressionTime: 126.728ms - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 26.27 MB - PerReadThreadRawHdfsThroughput: 1.69 GB/sec - RowsRead: 2.09M (2089237) - RowsReturned: 2.09M (2089237) - RowsReturnedRate: 13.04 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 453.943ms - MaterializeTupleTime(*): 209.390ms - ScannerThreadsSysTime: 999.0us - ScannerThreadsUserTime: 333.949ms - ScannerThreadsVoluntaryContextSwitches: 11 - TotalRawHdfsReadTime(*): 13.356ms - TotalReadThroughput: 23.08 MB/sec Averaged Fragment 4:(Total: 118.577ms, 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:64.121ms max:193.841ms mean: 124.960ms stddev:45.450ms execution rates: min:58.14 MB/sec max:190.82 MB/sec mean:117.96 MB/sec stddev:44.04 MB/sec num instances: 10 - AverageThreadTokens: 0.40 - PeakMemoryUsage: 16.28 MB - PrepareTime: 6.644ms - RowsProduced: 215.00K (214996) - TotalCpuTime: 262.817ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3.274ms - TotalStorageWaitTime: 80.344ms CodeGen:(Total: 69.61ms, non-child: 69.61ms, % non-child: 100.00%) - CodegenTime: 0ns - CompileTime: 63.230ms - LoadTime: 5.252ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=5):(Total: 31.18ms, non-child: 31.18ms, % non-child: 100.00%) - BytesSent: 2.18 MB - NetworkThroughput(*): 37.20 MB/sec - OverallThroughput: 69.94 MB/sec - PeakMemoryUsage: 440.00 KB - SerializeBatchTime: 14.497ms - ThriftTransmitTime(*): 58.987ms - UncompressedRowBatchSize: 2.46 MB HDFS_SCAN_NODE (id=0):(Total: 87.294ms, non-child: 87.294ms, % non-child: 100.00%) - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 13.36 MB - BytesReadDataNodeCache: 0 - BytesReadLocal: 13.36 MB - BytesReadShortCircuit: 13.36 MB - BytesSkipped: 0 - DecompressionTime: 32.569ms - NumDisksAccessed: 2 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 15.95 MB - PerReadThreadRawHdfsThroughput: 1.59 GB/sec - RowsRead: 215.00K (214996) - RowsReturned: 215.00K (214996) - RowsReturnedRate: 3.17 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 144.978ms - MaterializeTupleTime(*): 29.441ms - ScannerThreadsSysTime: 599.700us - ScannerThreadsUserTime: 61.90ms - ScannerThreadsVoluntaryContextSwitches: 10 - TotalRawHdfsReadTime(*): 8.558ms - TotalReadThroughput: 0.00 /sec Fragment 1: Instance 334a8aa14f3dd18b:1272da4a81819590 (host=hadoop-slave07.local:22000):(Total: 6s859ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB ThreadUsage(500.0ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 108.00 KB - PrepareTime: 1.730ms - RowsProduced: 1 - TotalCpuTime: 100.370ms - TotalNetworkReceiveTime: 6s859ms - TotalNetworkSendTime: 166.312us - TotalStorageWaitTime: 0ns CodeGen:(Total: 97.627ms, non-child: 97.627ms, % non-child: 100.00%) - CodegenTime: 1.660ms - CompileTime: 91.542ms - LoadTime: 5.489ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=9):(Total: 24.792us, non-child: 24.792us, % non-child: 100.00%) - BytesSent: 16.00 B - NetworkThroughput(*): 108.00 KB/sec - OverallThroughput: 630.24 KB/sec - PeakMemoryUsage: 16.00 KB - SerializeBatchTime: 8.669us - ThriftTransmitTime(*): 144.669us - UncompressedRowBatchSize: 16.00 B AGGREGATION_NODE (id=4):(Total: 6s861ms, non-child: 230.467us, % non-child: 0.00%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 1.399us - GetResultsTime: 2.296us - LoadFactor: 0.00 - PeakMemoryUsage: 44.00 KB - RowsReturned: 1 - RowsReturnedRate: 0 AGGREGATION_NODE (id=8):(Total: 6s861ms, non-child: 1.543ms, % non-child: 0.02%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 12.849us - GetResultsTime: 4.174us - LoadFactor: 0.08 - PeakMemoryUsage: 48.00 KB - RowsReturned: 92 - RowsReturnedRate: 13.00 /sec EXCHANGE_NODE (id=7):(Total: 6s859ms, non-child: 6s859ms, % non-child: 100.00%) BytesReceived(500.0ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - BytesReceived: 994.00 B - ConvertRowBatchTime: 1.865us - DataArrivalWaitTime: 6s859ms - DeserializeRowBatchTimer: 10.909us - FirstBatchArrivalWaitTime: 6s859ms - PeakMemoryUsage: 4.72 KB - RowsReturned: 92 - RowsReturnedRate: 13.00 /sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 334a8aa14f3dd18b:1272da4a81819593 (host=hadoop-slave01.local:22000):(Total: 6s857ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 104.73 KB, 104.73 KB, 104.73 KB, 104.73 KB, 104.73 KB, 104.73 KB, 104.73 KB ThreadUsage(500.0ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 108.00 KB - PrepareTime: 1.788ms - RowsProduced: 1 - TotalCpuTime: 101.495ms - TotalNetworkReceiveTime: 6s857ms - TotalNetworkSendTime: 80.707us - TotalStorageWaitTime: 0ns CodeGen:(Total: 98.822ms, non-child: 98.822ms, % non-child: 100.00%) - CodegenTime: 1.705ms - CompileTime: 92.572ms - LoadTime: 5.630ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=9):(Total: 24.713us, non-child: 24.713us, % non-child: 100.00%) - BytesSent: 16.00 B - NetworkThroughput(*): 261.15 KB/sec - OverallThroughput: 632.26 KB/sec - PeakMemoryUsage: 16.00 KB - SerializeBatchTime: 7.274us - ThriftTransmitTime(*): 59.831us - UncompressedRowBatchSize: 16.00 B AGGREGATION_NODE (id=4):(Total: 6s859ms, non-child: 231.968us, % non-child: 0.00%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 1.152us - GetResultsTime: 2.69us - LoadFactor: 0.00 - PeakMemoryUsage: 44.00 KB - RowsReturned: 1 - RowsReturnedRate: 0 AGGREGATION_NODE (id=8):(Total: 6s859ms, non-child: 1.602ms, % non-child: 0.02%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 15.323us - GetResultsTime: 4.86us - LoadFactor: 0.08 - PeakMemoryUsage: 48.00 KB - RowsReturned: 94 - RowsReturnedRate: 13.00 /sec EXCHANGE_NODE (id=7):(Total: 6s857ms, non-child: 6s857ms, % non-child: 100.00%) BytesReceived(500.0ms): 0, 0, 0, 0, 0, 0, 0, 1.00 KB, 1.00 KB, 1.00 KB, 1.00 KB, 1.00 KB, 1.00 KB, 1.00 KB - BytesReceived: 1.00 KB - ConvertRowBatchTime: 2.648us - DataArrivalWaitTime: 6s857ms - DeserializeRowBatchTimer: 9.460us - FirstBatchArrivalWaitTime: 3s700ms - PeakMemoryUsage: 4.73 KB - RowsReturned: 94 - RowsReturnedRate: 13.00 /sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 334a8aa14f3dd18b:1272da4a8181958f (host=hadoop-slave05.local:22000):(Total: 6s857ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 104.70 KB, 104.70 KB, 104.70 KB, 104.70 KB, 104.70 KB, 104.70 KB ThreadUsage(500.0ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 108.00 KB - PrepareTime: 1.831ms - RowsProduced: 1 - TotalCpuTime: 101.932ms - TotalNetworkReceiveTime: 6s857ms - TotalNetworkSendTime: 144.380us - TotalStorageWaitTime: 0ns CodeGen:(Total: 99.92ms, non-child: 99.92ms, % non-child: 100.00%) - CodegenTime: 1.754ms - CompileTime: 92.983ms - LoadTime: 5.504ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=9):(Total: 23.643us, non-child: 23.643us, % non-child: 100.00%) - BytesSent: 16.00 B - NetworkThroughput(*): 127.41 KB/sec - OverallThroughput: 660.87 KB/sec - PeakMemoryUsage: 16.00 KB - SerializeBatchTime: 6.801us - ThriftTransmitTime(*): 122.632us - UncompressedRowBatchSize: 16.00 B AGGREGATION_NODE (id=4):(Total: 6s859ms, non-child: 225.21us, % non-child: 0.00%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 1.717us - GetResultsTime: 2.251us - LoadFactor: 0.00 - PeakMemoryUsage: 44.00 KB - RowsReturned: 1 - RowsReturnedRate: 0 AGGREGATION_NODE (id=8):(Total: 6s858ms, non-child: 1.653ms, % non-child: 0.02%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 13.979us - GetResultsTime: 4.345us - LoadFactor: 0.08 - PeakMemoryUsage: 48.00 KB - RowsReturned: 89 - RowsReturnedRate: 12.00 /sec EXCHANGE_NODE (id=7):(Total: 6s857ms, non-child: 6s857ms, % non-child: 100.00%) BytesReceived(500.0ms): 0, 0, 0, 0, 0, 0, 0, 0, 969.00 B, 969.00 B, 969.00 B, 969.00 B, 969.00 B, 969.00 B - BytesReceived: 969.00 B - ConvertRowBatchTime: 2.670us - DataArrivalWaitTime: 6s857ms - DeserializeRowBatchTimer: 9.145us - FirstBatchArrivalWaitTime: 3s845ms - PeakMemoryUsage: 4.70 KB - RowsReturned: 89 - RowsReturnedRate: 12.00 /sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 334a8aa14f3dd18b:1272da4a81819591 (host=hadoop-slave06.local:22000):(Total: 6s850ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 104.66 KB, 104.66 KB, 104.66 KB, 104.66 KB, 104.66 KB ThreadUsage(500.0ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 108.00 KB - PrepareTime: 1.963ms - RowsProduced: 1 - TotalCpuTime: 103.420ms - TotalNetworkReceiveTime: 6s849ms - TotalNetworkSendTime: 159.109us - TotalStorageWaitTime: 0ns CodeGen:(Total: 100.448ms, non-child: 100.448ms, % non-child: 100.00%) - CodegenTime: 1.872ms - CompileTime: 93.881ms - LoadTime: 5.593ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=9):(Total: 32.85us, non-child: 32.85us, % non-child: 100.00%) - BytesSent: 16.00 B - NetworkThroughput(*): 114.79 KB/sec - OverallThroughput: 486.99 KB/sec - PeakMemoryUsage: 16.00 KB - SerializeBatchTime: 10.543us - ThriftTransmitTime(*): 136.123us - UncompressedRowBatchSize: 16.00 B AGGREGATION_NODE (id=4):(Total: 6s852ms, non-child: 237.23us, % non-child: 0.00%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 1.107us - GetResultsTime: 2.391us - LoadFactor: 0.00 - PeakMemoryUsage: 44.00 KB - RowsReturned: 1 - RowsReturnedRate: 0 AGGREGATION_NODE (id=8):(Total: 6s851ms, non-child: 1.776ms, % non-child: 0.03%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 15.192us - GetResultsTime: 4.485us - LoadFactor: 0.08 - PeakMemoryUsage: 48.00 KB - RowsReturned: 84 - RowsReturnedRate: 12.00 /sec EXCHANGE_NODE (id=7):(Total: 6s849ms, non-child: 6s849ms, % non-child: 100.00%) BytesReceived(500.0ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 918.00 B, 918.00 B, 918.00 B, 918.00 B, 918.00 B - BytesReceived: 918.00 B - ConvertRowBatchTime: 2.405us - DataArrivalWaitTime: 6s849ms - DeserializeRowBatchTimer: 10.11us - FirstBatchArrivalWaitTime: 4s722ms - PeakMemoryUsage: 4.66 KB - RowsReturned: 84 - RowsReturnedRate: 12.00 /sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 334a8aa14f3dd18b:1272da4a81819592 (host=hadoop-slave09.local:22000):(Total: 6s849ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 104.66 KB, 104.66 KB, 104.66 KB ThreadUsage(500.0ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 108.00 KB - PrepareTime: 1.991ms - RowsProduced: 1 - TotalCpuTime: 104.48ms - TotalNetworkReceiveTime: 6s849ms - TotalNetworkSendTime: 161.813us - TotalStorageWaitTime: 0ns CodeGen:(Total: 101.22ms, non-child: 101.22ms, % non-child: 100.00%) - CodegenTime: 1.899ms - CompileTime: 94.397ms - LoadTime: 5.630ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=9):(Total: 28.718us, non-child: 28.718us, % non-child: 100.00%) - BytesSent: 16.00 B - NetworkThroughput(*): 111.75 KB/sec - OverallThroughput: 544.08 KB/sec - PeakMemoryUsage: 16.00 KB - SerializeBatchTime: 8.57us - ThriftTransmitTime(*): 139.818us - UncompressedRowBatchSize: 16.00 B AGGREGATION_NODE (id=4):(Total: 6s851ms, non-child: 258.511us, % non-child: 0.00%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 1.529us - GetResultsTime: 2.643us - LoadFactor: 0.00 - PeakMemoryUsage: 44.00 KB - RowsReturned: 1 - RowsReturnedRate: 0 AGGREGATION_NODE (id=8):(Total: 6s851ms, non-child: 1.782ms, % non-child: 0.03%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 14.118us - GetResultsTime: 3.910us - LoadFactor: 0.08 - PeakMemoryUsage: 48.00 KB - RowsReturned: 84 - RowsReturnedRate: 12.00 /sec EXCHANGE_NODE (id=7):(Total: 6s849ms, non-child: 6s849ms, % non-child: 100.00%) BytesReceived(500.0ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 917.00 B, 917.00 B, 917.00 B - BytesReceived: 917.00 B - ConvertRowBatchTime: 2.439us - DataArrivalWaitTime: 6s849ms - DeserializeRowBatchTimer: 10.119us - FirstBatchArrivalWaitTime: 5s159ms - PeakMemoryUsage: 4.66 KB - RowsReturned: 84 - RowsReturnedRate: 12.00 /sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 334a8aa14f3dd18b:1272da4a81819595 (host=hadoop-slave04.local:22000):(Total: 6s848ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 104.74 KB, 104.74 KB, 104.74 KB, 104.74 KB, 104.74 KB, 104.74 KB, 104.74 KB ThreadUsage(500.0ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 108.00 KB - PrepareTime: 1.996ms - RowsProduced: 1 - TotalCpuTime: 102.836ms - TotalNetworkReceiveTime: 6s848ms - TotalNetworkSendTime: 144.664us - TotalStorageWaitTime: 0ns CodeGen:(Total: 99.854ms, non-child: 99.854ms, % non-child: 100.00%) - CodegenTime: 1.907ms - CompileTime: 93.239ms - LoadTime: 5.643ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=9):(Total: 28.202us, non-child: 28.202us, % non-child: 100.00%) - BytesSent: 16.00 B - NetworkThroughput(*): 127.66 KB/sec - OverallThroughput: 554.04 KB/sec - PeakMemoryUsage: 16.00 KB - SerializeBatchTime: 9.842us - ThriftTransmitTime(*): 122.399us - UncompressedRowBatchSize: 16.00 B AGGREGATION_NODE (id=4):(Total: 6s850ms, non-child: 232.657us, % non-child: 0.00%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 1.369us - GetResultsTime: 2.417us - LoadFactor: 0.00 - PeakMemoryUsage: 44.00 KB - RowsReturned: 1 - RowsReturnedRate: 0 AGGREGATION_NODE (id=8):(Total: 6s850ms, non-child: 1.816ms, % non-child: 0.03%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 16.612us - GetResultsTime: 4.481us - LoadFactor: 0.09 - PeakMemoryUsage: 48.00 KB - RowsReturned: 95 - RowsReturnedRate: 13.00 /sec EXCHANGE_NODE (id=7):(Total: 6s848ms, non-child: 6s848ms, % non-child: 100.00%) BytesReceived(500.0ms): 0, 0, 0, 0, 0, 0, 0, 1.00 KB, 1.00 KB, 1.00 KB, 1.00 KB, 1.00 KB, 1.00 KB, 1.00 KB - BytesReceived: 1.00 KB - ConvertRowBatchTime: 2.297us - DataArrivalWaitTime: 6s848ms - DeserializeRowBatchTimer: 7.189us - FirstBatchArrivalWaitTime: 3s540ms - PeakMemoryUsage: 4.74 KB - RowsReturned: 95 - RowsReturnedRate: 13.00 /sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 334a8aa14f3dd18b:1272da4a81819596 (host=hadoop-slave10.local:22000):(Total: 6s848ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 104.68 KB, 104.68 KB, 104.68 KB, 104.68 KB, 104.68 KB, 104.68 KB, 104.68 KB ThreadUsage(500.0ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 108.00 KB - PrepareTime: 1.981ms - RowsProduced: 1 - TotalCpuTime: 104.469ms - TotalNetworkReceiveTime: 6s848ms - TotalNetworkSendTime: 154.127us - TotalStorageWaitTime: 0ns CodeGen:(Total: 101.451ms, non-child: 101.451ms, % non-child: 100.00%) - CodegenTime: 1.890ms - CompileTime: 94.720ms - LoadTime: 5.740ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=9):(Total: 29.843us, non-child: 29.843us, % non-child: 100.00%) - BytesSent: 16.00 B - NetworkThroughput(*): 120.05 KB/sec - OverallThroughput: 523.57 KB/sec - PeakMemoryUsage: 16.00 KB - SerializeBatchTime: 10.839us - ThriftTransmitTime(*): 130.156us - UncompressedRowBatchSize: 16.00 B AGGREGATION_NODE (id=4):(Total: 6s850ms, non-child: 238.456us, % non-child: 0.00%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 1.80us - GetResultsTime: 2.588us - LoadFactor: 0.00 - PeakMemoryUsage: 44.00 KB - RowsReturned: 1 - RowsReturnedRate: 0 AGGREGATION_NODE (id=8):(Total: 6s850ms, non-child: 1.800ms, % non-child: 0.03%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 18.762us - GetResultsTime: 4.757us - LoadFactor: 0.08 - PeakMemoryUsage: 48.00 KB - RowsReturned: 87 - RowsReturnedRate: 12.00 /sec EXCHANGE_NODE (id=7):(Total: 6s848ms, non-child: 6s848ms, % non-child: 100.00%) BytesReceived(500.0ms): 0, 0, 0, 0, 0, 0, 0, 954.00 B, 954.00 B, 954.00 B, 954.00 B, 954.00 B, 954.00 B, 954.00 B - BytesReceived: 954.00 B - ConvertRowBatchTime: 2.563us - DataArrivalWaitTime: 6s848ms - DeserializeRowBatchTimer: 6.746us - FirstBatchArrivalWaitTime: 3s671ms - PeakMemoryUsage: 4.68 KB - RowsReturned: 87 - RowsReturnedRate: 12.00 /sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 334a8aa14f3dd18b:1272da4a81819598 (host=hadoop-slave02.local:22000):(Total: 6s848ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 104.75 KB, 104.75 KB, 104.75 KB, 104.75 KB, 104.75 KB, 104.75 KB, 104.75 KB ThreadUsage(500.0ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 108.00 KB - PrepareTime: 1.991ms - RowsProduced: 1 - TotalCpuTime: 103.732ms - TotalNetworkReceiveTime: 6s848ms - TotalNetworkSendTime: 129.719us - TotalStorageWaitTime: 0ns CodeGen:(Total: 100.727ms, non-child: 100.727ms, % non-child: 100.00%) - CodegenTime: 1.894ms - CompileTime: 94.78ms - LoadTime: 5.664ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=9):(Total: 30.271us, non-child: 30.271us, % non-child: 100.00%) - BytesSent: 16.00 B - NetworkThroughput(*): 144.89 KB/sec - OverallThroughput: 516.17 KB/sec - PeakMemoryUsage: 16.00 KB - SerializeBatchTime: 9.907us - ThriftTransmitTime(*): 107.841us - UncompressedRowBatchSize: 16.00 B AGGREGATION_NODE (id=4):(Total: 6s850ms, non-child: 234.204us, % non-child: 0.00%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 1.241us - GetResultsTime: 2.584us - LoadFactor: 0.00 - PeakMemoryUsage: 44.00 KB - RowsReturned: 1 - RowsReturnedRate: 0 AGGREGATION_NODE (id=8):(Total: 6s850ms, non-child: 1.809ms, % non-child: 0.03%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 16.678us - GetResultsTime: 4.66us - LoadFactor: 0.09 - PeakMemoryUsage: 48.00 KB - RowsReturned: 96 - RowsReturnedRate: 14.00 /sec EXCHANGE_NODE (id=7):(Total: 6s848ms, non-child: 6s848ms, % non-child: 100.00%) BytesReceived(500.0ms): 0, 0, 0, 0, 0, 0, 0, 1.01 KB, 1.01 KB, 1.01 KB, 1.01 KB, 1.01 KB, 1.01 KB, 1.01 KB - BytesReceived: 1.01 KB - ConvertRowBatchTime: 2.913us - DataArrivalWaitTime: 6s848ms - DeserializeRowBatchTimer: 9.636us - FirstBatchArrivalWaitTime: 3s400ms - PeakMemoryUsage: 4.75 KB - RowsReturned: 96 - RowsReturnedRate: 14.00 /sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 334a8aa14f3dd18b:1272da4a81819597 (host=hadoop-slave03.local:22000):(Total: 6s847ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 104.64 KB, 104.64 KB, 104.64 KB, 104.64 KB, 104.64 KB, 104.64 KB ThreadUsage(500.0ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 108.00 KB - PrepareTime: 2.59ms - RowsProduced: 1 - TotalCpuTime: 103.811ms - TotalNetworkReceiveTime: 6s847ms - TotalNetworkSendTime: 138.655us - TotalStorageWaitTime: 0ns CodeGen:(Total: 100.499ms, non-child: 100.499ms, % non-child: 100.00%) - CodegenTime: 1.946ms - CompileTime: 93.833ms - LoadTime: 5.646ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=9):(Total: 28.364us, non-child: 28.364us, % non-child: 100.00%) - BytesSent: 16.00 B - NetworkThroughput(*): 131.82 KB/sec - OverallThroughput: 550.87 KB/sec - PeakMemoryUsage: 16.00 KB - SerializeBatchTime: 9.89us - ThriftTransmitTime(*): 118.531us - UncompressedRowBatchSize: 16.00 B AGGREGATION_NODE (id=4):(Total: 6s849ms, non-child: 250.890us, % non-child: 0.00%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 1.144us - GetResultsTime: 2.186us - LoadFactor: 0.00 - PeakMemoryUsage: 44.00 KB - RowsReturned: 1 - RowsReturnedRate: 0 AGGREGATION_NODE (id=8):(Total: 6s849ms, non-child: 1.855ms, % non-child: 0.03%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 15.959us - GetResultsTime: 4.239us - LoadFactor: 0.08 - PeakMemoryUsage: 48.00 KB - RowsReturned: 82 - RowsReturnedRate: 11.00 /sec EXCHANGE_NODE (id=7):(Total: 6s847ms, non-child: 6s847ms, % non-child: 100.00%) BytesReceived(500.0ms): 0, 0, 0, 0, 0, 0, 0, 0, 904.00 B, 904.00 B, 904.00 B, 904.00 B, 904.00 B, 904.00 B - BytesReceived: 904.00 B - ConvertRowBatchTime: 2.314us - DataArrivalWaitTime: 6s847ms - DeserializeRowBatchTimer: 10.400us - FirstBatchArrivalWaitTime: 3s822ms - PeakMemoryUsage: 4.64 KB - RowsReturned: 82 - RowsReturnedRate: 11.00 /sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 334a8aa14f3dd18b:1272da4a81819594 (host=hadoop-slave08.local:22000):(Total: 6s845ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 92.00 KB, 104.62 KB, 104.62 KB, 104.62 KB, 104.62 KB, 104.62 KB, 104.62 KB ThreadUsage(500.0ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 108.00 KB - PrepareTime: 2.94ms - RowsProduced: 1 - TotalCpuTime: 106.280ms - TotalNetworkReceiveTime: 6s845ms - TotalNetworkSendTime: 141.864us - TotalStorageWaitTime: 0ns CodeGen:(Total: 103.112ms, non-child: 103.112ms, % non-child: 100.00%) - CodegenTime: 1.987ms - CompileTime: 96.48ms - LoadTime: 5.967ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=9):(Total: 28.895us, non-child: 28.895us, % non-child: 100.00%) - BytesSent: 16.00 B - NetworkThroughput(*): 132.21 KB/sec - OverallThroughput: 540.75 KB/sec - PeakMemoryUsage: 16.00 KB - SerializeBatchTime: 8.869us - ThriftTransmitTime(*): 118.183us - UncompressedRowBatchSize: 16.00 B AGGREGATION_NODE (id=4):(Total: 6s847ms, non-child: 244.891us, % non-child: 0.00%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 989ns - GetResultsTime: 1.968us - LoadFactor: 0.00 - PeakMemoryUsage: 44.00 KB - RowsReturned: 1 - RowsReturnedRate: 0 AGGREGATION_NODE (id=8):(Total: 6s847ms, non-child: 1.894ms, % non-child: 0.03%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 15.451us - GetResultsTime: 3.864us - LoadFactor: 0.07 - PeakMemoryUsage: 48.00 KB - RowsReturned: 79 - RowsReturnedRate: 11.00 /sec EXCHANGE_NODE (id=7):(Total: 6s845ms, non-child: 6s845ms, % non-child: 100.00%) BytesReceived(500.0ms): 0, 0, 0, 0, 0, 0, 0, 0, 871.00 B, 871.00 B, 871.00 B, 871.00 B, 871.00 B, 871.00 B - BytesReceived: 871.00 B - ConvertRowBatchTime: 1.844us - DataArrivalWaitTime: 6s845ms - DeserializeRowBatchTimer: 10.178us - FirstBatchArrivalWaitTime: 4s097ms - PeakMemoryUsage: 4.62 KB - RowsReturned: 79 - RowsReturnedRate: 11.00 /sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Fragment 2: Instance 334a8aa14f3dd18b:1272da4a8181959a (host=hadoop-slave07.local:22000):(Total: 6s725ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 176.00 KB, 13.45 MB, 13.33 MB, 13.19 MB, 13.03 MB, 12.91 MB, 12.80 MB, 12.67 MB, 12.56 MB, 12.43 MB, 12.26 MB, 12.14 MB, 12.02 MB, 11.88 MB ThreadUsage(500.0ms): 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.07 - PeakMemoryUsage: 13.47 MB - PrepareTime: 2.145ms - RowsProduced: 92 - TotalCpuTime: 6s675ms - TotalNetworkReceiveTime: 699.712ms - TotalNetworkSendTime: 133.667us - TotalStorageWaitTime: 0ns CodeGen:(Total: 104.892ms, non-child: 104.892ms, % non-child: 100.00%) - CodegenTime: 1.617ms - CompileTime: 99.148ms - LoadTime: 5.174ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=7):(Total: 28.736us, non-child: 28.736us, % non-child: 100.00%) - BytesSent: 994.00 B - NetworkThroughput(*): 9.16 MB/sec - OverallThroughput: 32.99 MB/sec - PeakMemoryUsage: 84.00 KB - SerializeBatchTime: 22.375us - ThriftTransmitTime(*): 103.483us - UncompressedRowBatchSize: 1.80 KB AGGREGATION_NODE (id=3):(Total: 6s727ms, non-child: 2.201ms, % non-child: 0.03%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 87.205us - GetResultsTime: 5.404us - LoadFactor: 0.08 - PeakMemoryUsage: 1.66 MB - RowsReturned: 92 - RowsReturnedRate: 13.00 /sec HASH_JOIN_NODE (id=2):(Total: 6s725ms, non-child: 6s558ms, % non-child: 97.53%) ExecOption: Build Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildBuckets: 16.38K (16384) - BuildRows: 205.31K (205309) - BuildTime: 18.8ms - LeftChildRows: 211.16K (211155) - LeftChildTime: 6s181ms - LoadFactor: 0.62 - PeakMemoryUsage: 10.14 MB - RowsReturned: 141 - RowsReturnedRate: 20.00 /sec EXCHANGE_NODE (id=6):(Total: 521.884ms, non-child: 521.884ms, % non-child: 100.00%) BytesReceived(500.0ms): 0 - BytesReceived: 1.93 MB - ConvertRowBatchTime: 2.922ms - DataArrivalWaitTime: 518.469ms - DeserializeRowBatchTimer: 6.935ms - FirstBatchArrivalWaitTime: 209.257ms - PeakMemoryUsage: 72.00 KB - RowsReturned: 205.31K (205309) - RowsReturnedRate: 393.40 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns EXCHANGE_NODE (id=5):(Total: 184.191ms, non-child: 184.191ms, % non-child: 100.00%) BytesReceived(500.0ms): 0, 2.14 MB, 2.14 MB, 2.14 MB, 2.14 MB, 2.14 MB, 2.14 MB, 2.14 MB, 2.14 MB, 2.14 MB, 2.14 MB, 2.14 MB, 2.14 MB, 2.14 MB - BytesReceived: 2.14 MB - ConvertRowBatchTime: 3.84ms - DataArrivalWaitTime: 180.667ms - DeserializeRowBatchTimer: 6.42ms - FirstBatchArrivalWaitTime: 180.666ms - PeakMemoryUsage: 3.22 MB - RowsReturned: 211.16K (211155) - RowsReturnedRate: 1.15 M/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 334a8aa14f3dd18b:1272da4a8181959c (host=hadoop-slave09.local:22000):(Total: 5s029ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 168.00 KB, 10.94 MB, 13.66 MB, 13.48 MB, 13.28 MB, 13.09 MB, 12.90 MB, 12.72 MB, 12.51 MB, 12.32 MB, 12.15 MB ThreadUsage(500.0ms): 1, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.09 - PeakMemoryUsage: 13.82 MB - PrepareTime: 2.167ms - RowsProduced: 84 - TotalCpuTime: 4s987ms - TotalNetworkReceiveTime: 687.763ms - TotalNetworkSendTime: 127.982us - TotalStorageWaitTime: 0ns CodeGen:(Total: 105.897ms, non-child: 105.897ms, % non-child: 100.00%) - CodegenTime: 1.619ms - CompileTime: 100.343ms - LoadTime: 5.36ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=7):(Total: 30.191us, non-child: 30.191us, % non-child: 100.00%) - BytesSent: 917.00 B - NetworkThroughput(*): 8.32 MB/sec - OverallThroughput: 28.97 MB/sec - PeakMemoryUsage: 84.00 KB - SerializeBatchTime: 23.603us - ThriftTransmitTime(*): 105.133us - UncompressedRowBatchSize: 1.64 KB AGGREGATION_NODE (id=3):(Total: 5s031ms, non-child: 2.283ms, % non-child: 0.05%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 117.740us - GetResultsTime: 5.146us - LoadFactor: 0.08 - PeakMemoryUsage: 1.76 MB - RowsReturned: 84 - RowsReturnedRate: 16.00 /sec HASH_JOIN_NODE (id=2):(Total: 5s029ms, non-child: 4s869ms, % non-child: 96.83%) ExecOption: Build Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildBuckets: 16.38K (16384) - BuildRows: 216.20K (216201) - BuildTime: 20.792ms - LeftChildRows: 222.18K (222183) - LeftChildTime: 4s489ms - LoadFactor: 0.61 - PeakMemoryUsage: 10.30 MB - RowsReturned: 99 - RowsReturnedRate: 19.00 /sec EXCHANGE_NODE (id=6):(Total: 514.335ms, non-child: 514.335ms, % non-child: 100.00%) BytesReceived(500.0ms): 0, 1.68 MB - BytesReceived: 2.03 MB - ConvertRowBatchTime: 3.435ms - DataArrivalWaitTime: 510.231ms - DeserializeRowBatchTimer: 6.655ms - FirstBatchArrivalWaitTime: 206.456ms - PeakMemoryUsage: 96.00 KB - RowsReturned: 216.20K (216201) - RowsReturnedRate: 420.35 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns EXCHANGE_NODE (id=5):(Total: 180.533ms, non-child: 180.533ms, % non-child: 100.00%) BytesReceived(500.0ms): 0, 2.25 MB, 2.25 MB, 2.25 MB, 2.25 MB, 2.25 MB, 2.25 MB, 2.25 MB, 2.25 MB, 2.25 MB, 2.25 MB - BytesReceived: 2.25 MB - ConvertRowBatchTime: 3.255ms - DataArrivalWaitTime: 176.820ms - DeserializeRowBatchTimer: 5.804ms - FirstBatchArrivalWaitTime: 176.819ms - PeakMemoryUsage: 3.40 MB - RowsReturned: 222.18K (222183) - RowsReturnedRate: 1.23 M/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 334a8aa14f3dd18b:1272da4a8181959b (host=hadoop-slave06.local:22000):(Total: 4s590ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 176.00 KB, 13.86 MB, 13.67 MB, 13.43 MB, 13.21 MB, 13.01 MB, 12.80 MB, 12.57 MB, 12.36 MB ThreadUsage(500.0ms): 2, 1, 1, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.11 - PeakMemoryUsage: 13.91 MB - PrepareTime: 2.294ms - RowsProduced: 84 - TotalCpuTime: 4s549ms - TotalNetworkReceiveTime: 684.387ms - TotalNetworkSendTime: 138.152us - TotalStorageWaitTime: 0ns CodeGen:(Total: 105.846ms, non-child: 105.846ms, % non-child: 100.00%) - CodegenTime: 1.729ms - CompileTime: 100.289ms - LoadTime: 5.42ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=7):(Total: 26.26us, non-child: 26.26us, % non-child: 100.00%) - BytesSent: 918.00 B - NetworkThroughput(*): 7.96 MB/sec - OverallThroughput: 33.64 MB/sec - PeakMemoryUsage: 84.00 KB - SerializeBatchTime: 23.379us - ThriftTransmitTime(*): 109.961us - UncompressedRowBatchSize: 1.64 KB AGGREGATION_NODE (id=3):(Total: 4s592ms, non-child: 2.419ms, % non-child: 0.05%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 119.340us - GetResultsTime: 5.599us - LoadFactor: 0.08 - PeakMemoryUsage: 1.78 MB - RowsReturned: 84 - RowsReturnedRate: 18.00 /sec HASH_JOIN_NODE (id=2):(Total: 4s590ms, non-child: 4s432ms, % non-child: 96.56%) ExecOption: Build Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildBuckets: 16.38K (16384) - BuildRows: 219.29K (219295) - BuildTime: 20.446ms - LeftChildRows: 225.21K (225206) - LeftChildTime: 4s052ms - LoadFactor: 0.61 - PeakMemoryUsage: 10.35 MB - RowsReturned: 105 - RowsReturnedRate: 22.00 /sec EXCHANGE_NODE (id=6):(Total: 512.675ms, non-child: 512.675ms, % non-child: 100.00%) BytesReceived(500.0ms): 0 - BytesReceived: 2.06 MB - ConvertRowBatchTime: 3.345ms - DataArrivalWaitTime: 508.717ms - DeserializeRowBatchTimer: 6.661ms - FirstBatchArrivalWaitTime: 205.62ms - PeakMemoryUsage: 96.00 KB - RowsReturned: 219.29K (219295) - RowsReturnedRate: 427.75 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns EXCHANGE_NODE (id=5):(Total: 178.709ms, non-child: 178.709ms, % non-child: 100.00%) BytesReceived(500.0ms): 0, 2.28 MB, 2.28 MB, 2.28 MB, 2.28 MB, 2.28 MB, 2.28 MB, 2.28 MB, 2.28 MB - BytesReceived: 2.28 MB - ConvertRowBatchTime: 3.257ms - DataArrivalWaitTime: 175.16ms - DeserializeRowBatchTimer: 5.824ms - FirstBatchArrivalWaitTime: 175.15ms - PeakMemoryUsage: 3.44 MB - RowsReturned: 225.21K (225206) - RowsReturnedRate: 1.26 M/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 334a8aa14f3dd18b:1272da4a8181959e (host=hadoop-slave08.local:22000):(Total: 3s969ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 176.00 KB, 13.72 MB, 13.59 MB, 13.32 MB, 13.07 MB, 12.82 MB, 12.59 MB, 12.34 MB ThreadUsage(500.0ms): 2, 2, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.25 - PeakMemoryUsage: 13.81 MB - PrepareTime: 2.186ms - RowsProduced: 79 - TotalCpuTime: 3s930ms - TotalNetworkReceiveTime: 683.991ms - TotalNetworkSendTime: 120.11us - TotalStorageWaitTime: 0ns CodeGen:(Total: 106.876ms, non-child: 106.876ms, % non-child: 100.00%) - CodegenTime: 1.604ms - CompileTime: 101.164ms - LoadTime: 5.162ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=7):(Total: 25.617us, non-child: 25.617us, % non-child: 100.00%) - BytesSent: 871.00 B - NetworkThroughput(*): 8.48 MB/sec - OverallThroughput: 32.43 MB/sec - PeakMemoryUsage: 84.00 KB - SerializeBatchTime: 20.912us - ThriftTransmitTime(*): 97.988us - UncompressedRowBatchSize: 1.55 KB AGGREGATION_NODE (id=3):(Total: 3s971ms, non-child: 2.209ms, % non-child: 0.06%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 82.528us - GetResultsTime: 4.229us - LoadFactor: 0.07 - PeakMemoryUsage: 1.76 MB - RowsReturned: 79 - RowsReturnedRate: 19.00 /sec HASH_JOIN_NODE (id=2):(Total: 3s969ms, non-child: 3s811ms, % non-child: 96.02%) ExecOption: Build Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildBuckets: 16.38K (16384) - BuildRows: 215.47K (215475) - BuildTime: 19.136ms - LeftChildRows: 222.04K (222044) - LeftChildTime: 3s432ms - LoadFactor: 0.61 - PeakMemoryUsage: 10.29 MB - RowsReturned: 111 - RowsReturnedRate: 27.00 /sec EXCHANGE_NODE (id=6):(Total: 514.51ms, non-child: 514.51ms, % non-child: 100.00%) BytesReceived(500.0ms): 0, 1.98 MB - BytesReceived: 2.04 MB - ConvertRowBatchTime: 3.819ms - DataArrivalWaitTime: 509.416ms - DeserializeRowBatchTimer: 6.656ms - FirstBatchArrivalWaitTime: 201.62ms - PeakMemoryUsage: 96.00 KB - RowsReturned: 215.47K (215475) - RowsReturnedRate: 419.17 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns EXCHANGE_NODE (id=5):(Total: 177.437ms, non-child: 177.437ms, % non-child: 100.00%) BytesReceived(500.0ms): 0, 2.26 MB, 2.26 MB, 2.26 MB, 2.26 MB, 2.26 MB, 2.26 MB, 2.26 MB - BytesReceived: 2.26 MB - ConvertRowBatchTime: 3.212ms - DataArrivalWaitTime: 173.750ms - DeserializeRowBatchTimer: 5.627ms - FirstBatchArrivalWaitTime: 173.750ms - PeakMemoryUsage: 3.40 MB - RowsReturned: 222.04K (222044) - RowsReturnedRate: 1.25 M/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 334a8aa14f3dd18b:1272da4a81819599 (host=hadoop-slave05.local:22000):(Total: 3s708ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 4.57 MB, 13.48 MB, 13.20 MB, 12.95 MB, 12.69 MB, 12.43 MB, 12.17 MB ThreadUsage(500.0ms): 2, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.14 - PeakMemoryUsage: 13.59 MB - PrepareTime: 2.250ms - RowsProduced: 89 - TotalCpuTime: 3s668ms - TotalNetworkReceiveTime: 688.211ms - TotalNetworkSendTime: 130.228us - TotalStorageWaitTime: 0ns CodeGen:(Total: 108.621ms, non-child: 108.621ms, % non-child: 100.00%) - CodegenTime: 1.688ms - CompileTime: 102.762ms - LoadTime: 5.261ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=7):(Total: 27.673us, non-child: 27.673us, % non-child: 100.00%) - BytesSent: 969.00 B - NetworkThroughput(*): 8.76 MB/sec - OverallThroughput: 33.39 MB/sec - PeakMemoryUsage: 84.00 KB - SerializeBatchTime: 24.41us - ThriftTransmitTime(*): 105.505us - UncompressedRowBatchSize: 1.74 KB AGGREGATION_NODE (id=3):(Total: 3s710ms, non-child: 2.310ms, % non-child: 0.06%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 99.795us - GetResultsTime: 4.711us - LoadFactor: 0.08 - PeakMemoryUsage: 1.69 MB - RowsReturned: 89 - RowsReturnedRate: 23.00 /sec HASH_JOIN_NODE (id=2):(Total: 3s708ms, non-child: 3s548ms, % non-child: 95.69%) ExecOption: Build Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildBuckets: 16.38K (16384) - BuildRows: 208.74K (208741) - BuildTime: 19.464ms - LeftChildRows: 215.22K (215221) - LeftChildTime: 3s169ms - LoadFactor: 0.61 - PeakMemoryUsage: 10.18 MB - RowsReturned: 110 - RowsReturnedRate: 29.00 /sec EXCHANGE_NODE (id=6):(Total: 515.305ms, non-child: 515.305ms, % non-child: 100.00%) BytesReceived(500.0ms): 552.98 KB - BytesReceived: 1.98 MB - ConvertRowBatchTime: 3.39ms - DataArrivalWaitTime: 511.721ms - DeserializeRowBatchTimer: 7.850ms - FirstBatchArrivalWaitTime: 204.379ms - PeakMemoryUsage: 72.00 KB - RowsReturned: 208.74K (208741) - RowsReturnedRate: 405.08 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns EXCHANGE_NODE (id=5):(Total: 179.416ms, non-child: 179.416ms, % non-child: 100.00%) BytesReceived(500.0ms): 1.45 MB, 2.19 MB, 2.19 MB, 2.19 MB, 2.19 MB, 2.19 MB, 2.19 MB - BytesReceived: 2.19 MB - ConvertRowBatchTime: 3.114ms - DataArrivalWaitTime: 175.871ms - DeserializeRowBatchTimer: 5.401ms - FirstBatchArrivalWaitTime: 175.871ms - PeakMemoryUsage: 3.28 MB - RowsReturned: 215.22K (215221) - RowsReturnedRate: 1.20 M/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 334a8aa14f3dd18b:1272da4a818195a1 (host=hadoop-slave03.local:22000):(Total: 3s691ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 176.00 KB, 13.50 MB, 13.38 MB, 13.09 MB, 12.84 MB, 12.60 MB, 12.30 MB, 12.07 MB ThreadUsage(500.0ms): 2, 2, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.25 - PeakMemoryUsage: 13.62 MB - PrepareTime: 2.258ms - RowsProduced: 82 - TotalCpuTime: 3s653ms - TotalNetworkReceiveTime: 685.269ms - TotalNetworkSendTime: 122.833us - TotalStorageWaitTime: 0ns CodeGen:(Total: 106.555ms, non-child: 106.555ms, % non-child: 100.00%) - CodegenTime: 1.712ms - CompileTime: 100.857ms - LoadTime: 5.162ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=7):(Total: 26.463us, non-child: 26.463us, % non-child: 100.00%) - BytesSent: 904.00 B - NetworkThroughput(*): 8.65 MB/sec - OverallThroughput: 32.58 MB/sec - PeakMemoryUsage: 84.00 KB - SerializeBatchTime: 24.728us - ThriftTransmitTime(*): 99.625us - UncompressedRowBatchSize: 1.61 KB AGGREGATION_NODE (id=3):(Total: 3s693ms, non-child: 2.312ms, % non-child: 0.06%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 84.620us - GetResultsTime: 5.224us - LoadFactor: 0.08 - PeakMemoryUsage: 1.70 MB - RowsReturned: 82 - RowsReturnedRate: 22.00 /sec HASH_JOIN_NODE (id=2):(Total: 3s691ms, non-child: 3s534ms, % non-child: 95.74%) ExecOption: Build Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildBuckets: 16.38K (16384) - BuildRows: 209.78K (209781) - BuildTime: 20.596ms - LeftChildRows: 215.86K (215861) - LeftChildTime: 3s152ms - LoadFactor: 0.61 - PeakMemoryUsage: 10.20 MB - RowsReturned: 95 - RowsReturnedRate: 25.00 /sec EXCHANGE_NODE (id=6):(Total: 514.37ms, non-child: 514.37ms, % non-child: 100.00%) BytesReceived(500.0ms): 0, 1.92 MB - BytesReceived: 1.98 MB - ConvertRowBatchTime: 3.212ms - DataArrivalWaitTime: 509.629ms - DeserializeRowBatchTimer: 9.238ms - FirstBatchArrivalWaitTime: 201.100ms - PeakMemoryUsage: 48.00 KB - RowsReturned: 209.78K (209781) - RowsReturnedRate: 408.10 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns EXCHANGE_NODE (id=5):(Total: 177.905ms, non-child: 177.905ms, % non-child: 100.00%) BytesReceived(500.0ms): 0, 2.19 MB, 2.19 MB, 2.19 MB, 2.19 MB, 2.19 MB, 2.19 MB, 2.19 MB - BytesReceived: 2.19 MB - ConvertRowBatchTime: 3.102ms - DataArrivalWaitTime: 174.375ms - DeserializeRowBatchTimer: 5.908ms - FirstBatchArrivalWaitTime: 174.374ms - PeakMemoryUsage: 3.29 MB - RowsReturned: 215.86K (215861) - RowsReturnedRate: 1.21 M/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 334a8aa14f3dd18b:1272da4a8181959d (host=hadoop-slave01.local:22000):(Total: 3s570ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 176.00 KB, 13.41 MB, 13.14 MB, 12.87 MB, 12.62 MB, 12.33 MB, 12.06 MB ThreadUsage(500.0ms): 2, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.14 - PeakMemoryUsage: 13.43 MB - PrepareTime: 2.202ms - RowsProduced: 94 - TotalCpuTime: 3s520ms - TotalNetworkReceiveTime: 705.256ms - TotalNetworkSendTime: 105.365us - TotalStorageWaitTime: 0ns CodeGen:(Total: 105.379ms, non-child: 105.379ms, % non-child: 100.00%) - CodegenTime: 1.628ms - CompileTime: 99.576ms - LoadTime: 5.231ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=7):(Total: 41.730us, non-child: 41.730us, % non-child: 100.00%) - BytesSent: 1.00 KB - NetworkThroughput(*): 11.37 MB/sec - OverallThroughput: 23.52 MB/sec - PeakMemoryUsage: 84.00 KB - SerializeBatchTime: 23.669us - ThriftTransmitTime(*): 86.340us - UncompressedRowBatchSize: 1.84 KB AGGREGATION_NODE (id=3):(Total: 3s572ms, non-child: 2.222ms, % non-child: 0.06%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 76.58us - GetResultsTime: 4.862us - LoadFactor: 0.08 - PeakMemoryUsage: 1.65 MB - RowsReturned: 94 - RowsReturnedRate: 26.00 /sec HASH_JOIN_NODE (id=2):(Total: 3s570ms, non-child: 3s403ms, % non-child: 95.31%) ExecOption: Build Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildBuckets: 16.38K (16384) - BuildRows: 203.72K (203719) - BuildTime: 18.603ms - LeftChildRows: 209.53K (209533) - LeftChildTime: 3s022ms - LoadFactor: 0.61 - PeakMemoryUsage: 10.11 MB - RowsReturned: 98 - RowsReturnedRate: 27.00 /sec EXCHANGE_NODE (id=6):(Total: 525.262ms, non-child: 525.262ms, % non-child: 100.00%) BytesReceived(500.0ms): 0 - BytesReceived: 1.93 MB - ConvertRowBatchTime: 2.933ms - DataArrivalWaitTime: 521.710ms - DeserializeRowBatchTimer: 5.688ms - FirstBatchArrivalWaitTime: 214.828ms - PeakMemoryUsage: 72.00 KB - RowsReturned: 203.72K (203719) - RowsReturnedRate: 387.84 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns EXCHANGE_NODE (id=5):(Total: 186.307ms, non-child: 186.307ms, % non-child: 100.00%) BytesReceived(500.0ms): 0, 2.13 MB, 2.13 MB, 2.13 MB, 2.13 MB, 2.13 MB, 2.13 MB - BytesReceived: 2.13 MB - ConvertRowBatchTime: 3.15ms - DataArrivalWaitTime: 182.931ms - DeserializeRowBatchTimer: 4.450ms - FirstBatchArrivalWaitTime: 182.931ms - PeakMemoryUsage: 3.20 MB - RowsReturned: 209.53K (209533) - RowsReturnedRate: 1.12 M/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 334a8aa14f3dd18b:1272da4a818195a0 (host=hadoop-slave10.local:22000):(Total: 3s543ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 176.00 KB, 13.47 MB, 13.20 MB, 12.92 MB, 12.65 MB, 12.38 MB, 12.10 MB ThreadUsage(500.0ms): 2, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.14 - PeakMemoryUsage: 13.49 MB - PrepareTime: 2.272ms - RowsProduced: 87 - TotalCpuTime: 3s502ms - TotalNetworkReceiveTime: 692.18ms - TotalNetworkSendTime: 121.818us - TotalStorageWaitTime: 0ns CodeGen:(Total: 107.970ms, non-child: 107.970ms, % non-child: 100.00%) - CodegenTime: 1.688ms - CompileTime: 102.207ms - LoadTime: 5.201ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=7):(Total: 29.155us, non-child: 29.155us, % non-child: 100.00%) - BytesSent: 954.00 B - NetworkThroughput(*): 9.20 MB/sec - OverallThroughput: 31.21 MB/sec - PeakMemoryUsage: 84.00 KB - SerializeBatchTime: 18.812us - ThriftTransmitTime(*): 98.844us - UncompressedRowBatchSize: 1.70 KB AGGREGATION_NODE (id=3):(Total: 3s545ms, non-child: 2.383ms, % non-child: 0.07%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 103.66us - GetResultsTime: 5.597us - LoadFactor: 0.08 - PeakMemoryUsage: 1.66 MB - RowsReturned: 87 - RowsReturnedRate: 24.00 /sec HASH_JOIN_NODE (id=2):(Total: 3s543ms, non-child: 3s381ms, % non-child: 95.43%) ExecOption: Build Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildBuckets: 16.38K (16384) - BuildRows: 205.70K (205704) - BuildTime: 19.684ms - LeftChildRows: 211.49K (211488) - LeftChildTime: 3s001ms - LoadFactor: 0.62 - PeakMemoryUsage: 10.14 MB - RowsReturned: 125 - RowsReturnedRate: 35.00 /sec EXCHANGE_NODE (id=6):(Total: 517.912ms, non-child: 517.912ms, % non-child: 100.00%) BytesReceived(500.0ms): 0 - BytesReceived: 1.94 MB - ConvertRowBatchTime: 4.74ms - DataArrivalWaitTime: 513.115ms - DeserializeRowBatchTimer: 6.256ms - FirstBatchArrivalWaitTime: 204.563ms - PeakMemoryUsage: 96.00 KB - RowsReturned: 205.70K (205704) - RowsReturnedRate: 397.18 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns EXCHANGE_NODE (id=5):(Total: 181.658ms, non-child: 181.658ms, % non-child: 100.00%) BytesReceived(500.0ms): 0, 2.15 MB, 2.15 MB, 2.15 MB, 2.15 MB, 2.15 MB, 2.15 MB - BytesReceived: 2.15 MB - ConvertRowBatchTime: 3.59ms - DataArrivalWaitTime: 178.184ms - DeserializeRowBatchTimer: 5.797ms - FirstBatchArrivalWaitTime: 178.184ms - PeakMemoryUsage: 3.23 MB - RowsReturned: 211.49K (211488) - RowsReturnedRate: 1.16 M/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 334a8aa14f3dd18b:1272da4a8181959f (host=hadoop-slave04.local:22000):(Total: 3s409ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 176.00 KB, 13.53 MB, 13.27 MB, 12.97 MB, 12.68 MB, 12.39 MB, 12.11 MB ThreadUsage(500.0ms): 2, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.14 - PeakMemoryUsage: 13.54 MB - PrepareTime: 2.186ms - RowsProduced: 95 - TotalCpuTime: 3s365ms - TotalNetworkReceiveTime: 689.225ms - TotalNetworkSendTime: 118.764us - TotalStorageWaitTime: 0ns CodeGen:(Total: 105.833ms, non-child: 105.833ms, % non-child: 100.00%) - CodegenTime: 1.649ms - CompileTime: 100.69ms - LoadTime: 5.191ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=7):(Total: 29.699us, non-child: 29.699us, % non-child: 100.00%) - BytesSent: 1.00 KB - NetworkThroughput(*): 10.18 MB/sec - OverallThroughput: 33.04 MB/sec - PeakMemoryUsage: 84.00 KB - SerializeBatchTime: 20.68us - ThriftTransmitTime(*): 96.416us - UncompressedRowBatchSize: 1.86 KB AGGREGATION_NODE (id=3):(Total: 3s412ms, non-child: 2.270ms, % non-child: 0.07%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 106.339us - GetResultsTime: 5.255us - LoadFactor: 0.09 - PeakMemoryUsage: 1.68 MB - RowsReturned: 95 - RowsReturnedRate: 27.00 /sec HASH_JOIN_NODE (id=2):(Total: 3s409ms, non-child: 3s248ms, % non-child: 95.27%) ExecOption: Build Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildBuckets: 16.38K (16384) - BuildRows: 207.13K (207129) - BuildTime: 17.502ms - LeftChildRows: 213.57K (213570) - LeftChildTime: 2s871ms - LoadFactor: 0.60 - PeakMemoryUsage: 10.17 MB - RowsReturned: 118 - RowsReturnedRate: 34.00 /sec EXCHANGE_NODE (id=6):(Total: 517.115ms, non-child: 517.115ms, % non-child: 100.00%) BytesReceived(500.0ms): 0 - BytesReceived: 1.96 MB - ConvertRowBatchTime: 3.410ms - DataArrivalWaitTime: 513.137ms - DeserializeRowBatchTimer: 5.618ms - FirstBatchArrivalWaitTime: 202.23ms - PeakMemoryUsage: 72.00 KB - RowsReturned: 207.13K (207129) - RowsReturnedRate: 400.55 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns EXCHANGE_NODE (id=5):(Total: 179.2ms, non-child: 179.2ms, % non-child: 100.00%) BytesReceived(500.0ms): 0, 2.17 MB, 2.17 MB, 2.17 MB, 2.17 MB, 2.17 MB, 2.17 MB - BytesReceived: 2.17 MB - ConvertRowBatchTime: 3.99ms - DataArrivalWaitTime: 175.441ms - DeserializeRowBatchTimer: 5.8ms - FirstBatchArrivalWaitTime: 175.441ms - PeakMemoryUsage: 3.26 MB - RowsReturned: 213.57K (213570) - RowsReturnedRate: 1.19 M/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 334a8aa14f3dd18b:1272da4a818195a2 (host=hadoop-slave02.local:22000):(Total: 3s270ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 168.00 KB, 10.25 MB, 10.75 MB, 10.46 MB, 10.18 MB, 9.88 MB, 9.60 MB ThreadUsage(500.0ms): 1, 2, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.14 - PeakMemoryUsage: 10.97 MB - PrepareTime: 2.234ms - RowsProduced: 96 - TotalCpuTime: 3s224ms - TotalNetworkReceiveTime: 692.173ms - TotalNetworkSendTime: 137.258us - TotalStorageWaitTime: 0ns CodeGen:(Total: 106.73ms, non-child: 106.73ms, % non-child: 100.00%) - CodegenTime: 1.694ms - CompileTime: 100.479ms - LoadTime: 5.66ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=7):(Total: 29.471us, non-child: 29.471us, % non-child: 100.00%) - BytesSent: 1.01 KB - NetworkThroughput(*): 8.77 MB/sec - OverallThroughput: 33.59 MB/sec - PeakMemoryUsage: 84.00 KB - SerializeBatchTime: 24.173us - ThriftTransmitTime(*): 112.924us - UncompressedRowBatchSize: 1.88 KB AGGREGATION_NODE (id=3):(Total: 3s272ms, non-child: 2.339ms, % non-child: 0.07%) ExecOption: Codegen Enabled - BuildBuckets: 1.02K (1024) - BuildTime: 108.866us - GetResultsTime: 5.492us - LoadFactor: 0.09 - PeakMemoryUsage: 1.61 MB - RowsReturned: 96 - RowsReturnedRate: 29.00 /sec HASH_JOIN_NODE (id=2):(Total: 3s270ms, non-child: 3s107ms, % non-child: 95.02%) ExecOption: Build Side Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildBuckets: 16.38K (16384) - BuildRows: 197.88K (197883) - BuildTime: 15.982ms - LeftChildRows: 203.71K (203706) - LeftChildTime: 2s730ms - LoadFactor: 0.61 - PeakMemoryUsage: 7.74 MB - RowsReturned: 120 - RowsReturnedRate: 36.00 /sec EXCHANGE_NODE (id=6):(Total: 519.674ms, non-child: 519.674ms, % non-child: 100.00%) BytesReceived(500.0ms): 0, 1.45 MB - BytesReceived: 1.88 MB - ConvertRowBatchTime: 3.47ms - DataArrivalWaitTime: 516.58ms - DeserializeRowBatchTimer: 6.155ms - FirstBatchArrivalWaitTime: 204.585ms - PeakMemoryUsage: 48.00 KB - RowsReturned: 197.88K (197883) - RowsReturnedRate: 380.78 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns EXCHANGE_NODE (id=5):(Total: 178.867ms, non-child: 178.867ms, % non-child: 100.00%) BytesReceived(500.0ms): 0, 2.08 MB, 2.08 MB, 2.08 MB, 2.08 MB, 2.08 MB, 2.08 MB - BytesReceived: 2.08 MB - ConvertRowBatchTime: 2.960ms - DataArrivalWaitTime: 175.529ms - DeserializeRowBatchTimer: 5.116ms - FirstBatchArrivalWaitTime: 175.528ms - PeakMemoryUsage: 3.12 MB - RowsReturned: 203.71K (203706) - RowsReturnedRate: 1.14 M/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Fragment 3: Instance 334a8aa14f3dd18b:1272da4a818195a3 (host=hadoop-slave08.local:22000):(Total: 454.350ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 0:1/23.08 MB MemoryUsage(500.0ms): 88.00 KB, 9.38 MB ThreadUsage(500.0ms): 1, 2 - AverageThreadTokens: 1.50 - PeakMemoryUsage: 26.49 MB - PrepareTime: 161.896us - RowsProduced: 2.09M (2089237) - TotalCpuTime: 859.746ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 8.640ms - TotalStorageWaitTime: 117.72ms CodeGen:(Total: 69.853ms, non-child: 69.853ms, % non-child: 100.00%) - CodegenTime: 106.240us - CompileTime: 63.993ms - LoadTime: 5.239ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=6):(Total: 292.300ms, non-child: 292.300ms, % non-child: 100.00%) - BytesSent: 19.73 MB - NetworkThroughput(*): 30.27 MB/sec - OverallThroughput: 67.50 MB/sec - PeakMemoryUsage: 360.00 KB - SerializeBatchTime: 130.977ms - ThriftTransmitTime(*): 651.707ms - UncompressedRowBatchSize: 39.86 MB HDFS_SCAN_NODE (id=1):(Total: 160.273ms, non-child: 160.273ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 0:1/23.08 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% File Formats: RC_FILE/DEFAULT:1 ExecOption: Codegen enabled: 0 out of 2 BytesRead(500.0ms): 0, 23.08 MB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 1.00 - BytesRead: 23.08 MB - BytesReadDataNodeCache: 0 - BytesReadLocal: 23.08 MB - BytesReadShortCircuit: 23.08 MB - BytesSkipped: 0 - DecompressionTime: 126.728ms - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 26.27 MB - PerReadThreadRawHdfsThroughput: 1.69 GB/sec - RowsRead: 2.09M (2089237) - RowsReturned: 2.09M (2089237) - RowsReturnedRate: 13.04 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 453.943ms - MaterializeTupleTime(*): 209.390ms - ScannerThreadsSysTime: 999.0us - ScannerThreadsUserTime: 333.949ms - ScannerThreadsVoluntaryContextSwitches: 11 - TotalRawHdfsReadTime(*): 13.356ms - TotalReadThroughput: 23.08 MB/sec Fragment 4: Instance 334a8aa14f3dd18b:1272da4a818195a7 (host=hadoop-slave09.local:22000):(Total: 187.670ms, 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: 26.44 MB - PrepareTime: 22.50ms - RowsProduced: 364.18K (364178) - TotalCpuTime: 398.87ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3.148ms - TotalStorageWaitTime: 256.72ms CodeGen:(Total: 69.578ms, non-child: 69.578ms, % non-child: 100.00%) - CodegenTime: 0ns - CompileTime: 63.990ms - LoadTime: 5.70ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=5):(Total: 50.789ms, non-child: 50.789ms, % non-child: 100.00%) - BytesSent: 3.73 MB - NetworkThroughput(*): 41.23 MB/sec - OverallThroughput: 73.43 MB/sec - PeakMemoryUsage: 440.00 KB - SerializeBatchTime: 23.105ms - ThriftTransmitTime(*): 90.469ms - UncompressedRowBatchSize: 4.17 MB HDFS_SCAN_NODE (id=0):(Total: 136.452ms, non-child: 136.452ms, % 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: 58.703ms - NumDisksAccessed: 4 - NumScannerThreadsStarted: 2 - PeakMemoryUsage: 26.10 MB - PerReadThreadRawHdfsThroughput: 1.52 GB/sec - RowsRead: 364.18K (364178) - RowsReturned: 364.18K (364178) - RowsReturnedRate: 2.67 M/sec - ScanRangesComplete: 2 - ScannerThreadsInvoluntaryContextSwitches: 2 - ScannerThreadsTotalWallClockTime: 371.31ms - MaterializeTupleTime(*): 54.702ms - ScannerThreadsSysTime: 1.999ms - ScannerThreadsUserTime: 111.982ms - ScannerThreadsVoluntaryContextSwitches: 24 - TotalRawHdfsReadTime(*): 14.484ms - TotalReadThroughput: 0.00 /sec Instance 334a8aa14f3dd18b:1272da4a818195ad (host=hadoop-slave02.local:22000):(Total: 186.568ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 4:1/11.22 MB - AverageThreadTokens: 0.00 - PeakMemoryUsage: 13.57 MB - PrepareTime: 22.191ms - RowsProduced: 180.78K (180776) - TotalCpuTime: 333.97ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3.382ms - TotalStorageWaitTime: 135.168ms CodeGen:(Total: 69.405ms, non-child: 69.405ms, % non-child: 100.00%) - CodegenTime: 0ns - CompileTime: 63.820ms - LoadTime: 5.86ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=5):(Total: 25.66ms, non-child: 25.66ms, % non-child: 100.00%) - BytesSent: 1.85 MB - NetworkThroughput(*): 32.99 MB/sec - OverallThroughput: 73.70 MB/sec - PeakMemoryUsage: 440.00 KB - SerializeBatchTime: 11.695ms - ThriftTransmitTime(*): 55.996ms - UncompressedRowBatchSize: 2.07 MB HDFS_SCAN_NODE (id=0):(Total: 161.282ms, non-child: 161.282ms, % 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: 26.561ms - NumDisksAccessed: 2 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 13.28 MB - PerReadThreadRawHdfsThroughput: 1.56 GB/sec - RowsRead: 180.78K (180776) - RowsReturned: 180.78K (180776) - RowsReturnedRate: 1.12 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 186.318ms - MaterializeTupleTime(*): 23.920ms - ScannerThreadsSysTime: 0ns - ScannerThreadsUserTime: 50.992ms - ScannerThreadsVoluntaryContextSwitches: 4 - TotalRawHdfsReadTime(*): 7.0ms - TotalReadThroughput: 0.00 /sec Instance 334a8aa14f3dd18b:1272da4a818195a6 (host=hadoop-slave06.local:22000):(Total: 169.2ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 2:1/11.23 MB MemoryUsage(500.0ms): 168.00 KB ThreadUsage(500.0ms): 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 13.64 MB - PrepareTime: 21.844ms - RowsProduced: 180.96K (180963) - TotalCpuTime: 315.938ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3.30ms - TotalStorageWaitTime: 116.153ms CodeGen:(Total: 68.930ms, non-child: 68.930ms, % non-child: 100.00%) - CodegenTime: 0ns - CompileTime: 63.315ms - LoadTime: 5.94ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=5):(Total: 25.614ms, non-child: 25.614ms, % non-child: 100.00%) - BytesSent: 1.83 MB - NetworkThroughput(*): 40.11 MB/sec - OverallThroughput: 71.56 MB/sec - PeakMemoryUsage: 440.00 KB - SerializeBatchTime: 11.813ms - ThriftTransmitTime(*): 45.701ms - UncompressedRowBatchSize: 2.07 MB HDFS_SCAN_NODE (id=0):(Total: 143.169ms, non-child: 143.169ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 2:1/11.23 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.23 MB - BytesReadDataNodeCache: 0 - BytesReadLocal: 11.23 MB - BytesReadShortCircuit: 11.23 MB - BytesSkipped: 0 - DecompressionTime: 27.52ms - NumDisksAccessed: 2 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 13.29 MB - PerReadThreadRawHdfsThroughput: 1.29 GB/sec - RowsRead: 180.96K (180963) - RowsReturned: 180.96K (180963) - RowsReturnedRate: 1.26 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 1 - ScannerThreadsTotalWallClockTime: 168.772ms - MaterializeTupleTime(*): 24.772ms - ScannerThreadsSysTime: 999.0us - ScannerThreadsUserTime: 50.992ms - ScannerThreadsVoluntaryContextSwitches: 5 - TotalRawHdfsReadTime(*): 8.490ms - TotalReadThroughput: 0.00 /sec Instance 334a8aa14f3dd18b:1272da4a818195ac (host=hadoop-slave03.local:22000):(Total: 116.486ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 2:1/11.12 MB - AverageThreadTokens: 0.00 - PeakMemoryUsage: 13.51 MB - PrepareTime: 48.779us - RowsProduced: 178.66K (178659) - TotalCpuTime: 243.392ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 2.791ms - TotalStorageWaitTime: 62.116ms CodeGen:(Total: 69.169ms, non-child: 69.169ms, % non-child: 100.00%) - CodegenTime: 0ns - CompileTime: 63.320ms - LoadTime: 5.274ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=5):(Total: 28.702ms, non-child: 28.702ms, % non-child: 100.00%) - BytesSent: 1.81 MB - NetworkThroughput(*): 37.41 MB/sec - OverallThroughput: 62.95 MB/sec - PeakMemoryUsage: 440.00 KB - SerializeBatchTime: 13.972ms - ThriftTransmitTime(*): 48.297ms - UncompressedRowBatchSize: 2.04 MB HDFS_SCAN_NODE (id=0):(Total: 87.499ms, non-child: 87.499ms, % 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 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 11.12 MB - BytesReadDataNodeCache: 0 - BytesReadLocal: 11.12 MB - BytesReadShortCircuit: 11.12 MB - BytesSkipped: 0 - DecompressionTime: 28.268ms - NumDisksAccessed: 2 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 13.19 MB - PerReadThreadRawHdfsThroughput: 1.17 GB/sec - RowsRead: 178.66K (178659) - RowsReturned: 178.66K (178659) - RowsReturnedRate: 2.04 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 2 - ScannerThreadsTotalWallClockTime: 116.141ms - MaterializeTupleTime(*): 25.228ms - ScannerThreadsSysTime: 0ns - ScannerThreadsUserTime: 51.992ms - ScannerThreadsVoluntaryContextSwitches: 12 - TotalRawHdfsReadTime(*): 9.251ms - TotalReadThroughput: 0.00 /sec Instance 334a8aa14f3dd18b:1272da4a818195ab (host=hadoop-slave10.local:22000):(Total: 113.567ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 0:1/11.20 MB MemoryUsage(500.0ms): 168.00 KB ThreadUsage(500.0ms): 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 13.63 MB - PrepareTime: 50.930us - RowsProduced: 180.84K (180843) - TotalCpuTime: 238.318ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3.165ms - TotalStorageWaitTime: 61.817ms CodeGen:(Total: 69.251ms, non-child: 69.251ms, % non-child: 100.00%) - CodegenTime: 0ns - CompileTime: 63.247ms - LoadTime: 5.403ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=5):(Total: 26.653ms, non-child: 26.653ms, % non-child: 100.00%) - BytesSent: 1.84 MB - NetworkThroughput(*): 35.88 MB/sec - OverallThroughput: 68.92 MB/sec - PeakMemoryUsage: 440.00 KB - SerializeBatchTime: 12.665ms - ThriftTransmitTime(*): 51.200ms - UncompressedRowBatchSize: 2.07 MB HDFS_SCAN_NODE (id=0):(Total: 86.672ms, non-child: 86.672ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 0: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.747ms - NumDisksAccessed: 2 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 13.27 MB - PerReadThreadRawHdfsThroughput: 1.48 GB/sec - RowsRead: 180.84K (180843) - RowsReturned: 180.84K (180843) - RowsReturnedRate: 2.09 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 113.487ms - MaterializeTupleTime(*): 23.935ms - ScannerThreadsSysTime: 0ns - ScannerThreadsUserTime: 49.992ms - ScannerThreadsVoluntaryContextSwitches: 9 - TotalRawHdfsReadTime(*): 7.415ms - TotalReadThroughput: 0.00 /sec Instance 334a8aa14f3dd18b:1272da4a818195aa (host=hadoop-slave04.local:22000):(Total: 108.311ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 4:1/11.14 MB 5:1/10.84 MB - AverageThreadTokens: 0.00 - PeakMemoryUsage: 26.92 MB - PrepareTime: 49.679us - RowsProduced: 353.38K (353378) - TotalCpuTime: 301.792ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3.476ms - TotalStorageWaitTime: 70.51ms CodeGen:(Total: 68.234ms, non-child: 68.234ms, % non-child: 100.00%) - CodegenTime: 0ns - CompileTime: 62.574ms - LoadTime: 5.105ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=5):(Total: 49.26ms, non-child: 49.26ms, % non-child: 100.00%) - BytesSent: 3.62 MB - NetworkThroughput(*): 40.05 MB/sec - OverallThroughput: 73.80 MB/sec - PeakMemoryUsage: 440.00 KB - SerializeBatchTime: 22.617ms - ThriftTransmitTime(*): 90.334ms - UncompressedRowBatchSize: 4.04 MB HDFS_SCAN_NODE (id=0):(Total: 58.861ms, non-child: 58.861ms, % 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 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 21.99 MB - BytesReadDataNodeCache: 0 - BytesReadLocal: 21.99 MB - BytesReadShortCircuit: 21.99 MB - BytesSkipped: 0 - DecompressionTime: 53.177ms - NumDisksAccessed: 4 - NumScannerThreadsStarted: 2 - PeakMemoryUsage: 26.62 MB - PerReadThreadRawHdfsThroughput: 1.49 GB/sec - RowsRead: 353.38K (353378) - RowsReturned: 353.38K (353378) - RowsReturnedRate: 6.00 M/sec - ScanRangesComplete: 2 - ScannerThreadsInvoluntaryContextSwitches: 1 - ScannerThreadsTotalWallClockTime: 191.37ms - MaterializeTupleTime(*): 48.267ms - ScannerThreadsSysTime: 0ns - ScannerThreadsUserTime: 100.984ms - ScannerThreadsVoluntaryContextSwitches: 24 - TotalRawHdfsReadTime(*): 14.419ms - TotalReadThroughput: 0.00 /sec Instance 334a8aa14f3dd18b:1272da4a818195a8 (host=hadoop-slave01.local:22000):(Total: 105.56ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 3:1/11.20 MB MemoryUsage(500.0ms): 168.00 KB ThreadUsage(500.0ms): 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 13.53 MB - PrepareTime: 58.92us - RowsProduced: 180.35K (180347) - TotalCpuTime: 227.989ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3.107ms - TotalStorageWaitTime: 54.695ms CodeGen:(Total: 69.56ms, non-child: 69.56ms, % non-child: 100.00%) - CodegenTime: 0ns - CompileTime: 63.126ms - LoadTime: 5.371ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=5):(Total: 26.958ms, non-child: 26.958ms, % non-child: 100.00%) - BytesSent: 1.81 MB - NetworkThroughput(*): 41.74 MB/sec - OverallThroughput: 67.17 MB/sec - PeakMemoryUsage: 440.00 KB - SerializeBatchTime: 12.707ms - ThriftTransmitTime(*): 43.378ms - UncompressedRowBatchSize: 2.06 MB HDFS_SCAN_NODE (id=0):(Total: 77.887ms, non-child: 77.887ms, % 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.14ms - NumDisksAccessed: 2 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 13.20 MB - PerReadThreadRawHdfsThroughput: 1.84 GB/sec - RowsRead: 180.35K (180347) - RowsReturned: 180.35K (180347) - RowsReturnedRate: 2.32 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 104.756ms - MaterializeTupleTime(*): 23.517ms - ScannerThreadsSysTime: 0ns - ScannerThreadsUserTime: 48.992ms - ScannerThreadsVoluntaryContextSwitches: 5 - TotalRawHdfsReadTime(*): 5.930ms - TotalReadThroughput: 0.00 /sec Instance 334a8aa14f3dd18b:1272da4a818195a9 (host=hadoop-slave08.local:22000):(Total: 83.647ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 5:1/10.89 MB - AverageThreadTokens: 0.00 - PeakMemoryUsage: 13.53 MB - PrepareTime: 45.374us - RowsProduced: 174.67K (174667) - TotalCpuTime: 207.612ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3.966ms - TotalStorageWaitTime: 33.123ms CodeGen:(Total: 69.144ms, non-child: 69.144ms, % non-child: 100.00%) - CodegenTime: 0ns - CompileTime: 63.229ms - LoadTime: 5.268ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=5):(Total: 26.671ms, non-child: 26.671ms, % non-child: 100.00%) - BytesSent: 1.73 MB - NetworkThroughput(*): 24.31 MB/sec - OverallThroughput: 64.91 MB/sec - PeakMemoryUsage: 440.00 KB - SerializeBatchTime: 12.454ms - ThriftTransmitTime(*): 71.226ms - UncompressedRowBatchSize: 2.00 MB HDFS_SCAN_NODE (id=0):(Total: 56.754ms, non-child: 56.754ms, % 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.64ms - NumDisksAccessed: 2 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 13.20 MB - PerReadThreadRawHdfsThroughput: 1.26 GB/sec - RowsRead: 174.67K (174667) - RowsReturned: 174.67K (174667) - RowsReturnedRate: 3.08 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 83.328ms - MaterializeTupleTime(*): 23.501ms - ScannerThreadsSysTime: 0ns - ScannerThreadsUserTime: 48.992ms - ScannerThreadsVoluntaryContextSwitches: 11 - TotalRawHdfsReadTime(*): 8.429ms - TotalReadThroughput: 0.00 /sec Instance 334a8aa14f3dd18b:1272da4a818195a4 (host=hadoop-slave05.local:22000):(Total: 58.3ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 2:1/11.27 MB - AverageThreadTokens: 0.00 - PeakMemoryUsage: 13.53 MB - PrepareTime: 54.145us - RowsProduced: 181.21K (181209) - TotalCpuTime: 182.773ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3.259ms - TotalStorageWaitTime: 6.344ms CodeGen:(Total: 69.345ms, non-child: 69.345ms, % non-child: 100.00%) - CodegenTime: 0ns - CompileTime: 63.192ms - LoadTime: 5.486ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=5):(Total: 26.28ms, non-child: 26.28ms, % non-child: 100.00%) - BytesSent: 1.85 MB - NetworkThroughput(*): 36.06 MB/sec - OverallThroughput: 71.00 MB/sec - PeakMemoryUsage: 440.00 KB - SerializeBatchTime: 12.313ms - ThriftTransmitTime(*): 51.245ms - UncompressedRowBatchSize: 2.07 MB HDFS_SCAN_NODE (id=0):(Total: 31.760ms, non-child: 31.760ms, % 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: 27.123ms - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 13.20 MB - PerReadThreadRawHdfsThroughput: 2.17 GB/sec - RowsRead: 181.21K (181209) - RowsReturned: 181.21K (181209) - RowsReturnedRate: 5.71 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 57.836ms - MaterializeTupleTime(*): 23.882ms - ScannerThreadsSysTime: 2.999ms - ScannerThreadsUserTime: 47.992ms - ScannerThreadsVoluntaryContextSwitches: 5 - TotalRawHdfsReadTime(*): 5.84ms - TotalReadThroughput: 0.00 /sec Instance 334a8aa14f3dd18b:1272da4a818195a5 (host=hadoop-slave07.local:22000):(Total: 57.462ms, non-child: 0ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 4:1/10.92 MB MemoryUsage(500.0ms): 168.00 KB ThreadUsage(500.0ms): 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 14.52 MB - PrepareTime: 54.213us - RowsProduced: 174.95K (174947) - TotalCpuTime: 179.173ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 3.416ms - TotalStorageWaitTime: 7.905ms CodeGen:(Total: 68.498ms, non-child: 68.498ms, % non-child: 100.00%) - CodegenTime: 0ns - CompileTime: 62.485ms - LoadTime: 5.365ms - ModuleFileSize: 105.51 KB DataStreamSender (dst_id=5):(Total: 24.672ms, non-child: 24.672ms, % non-child: 100.00%) - BytesSent: 1.78 MB - NetworkThroughput(*): 42.24 MB/sec - OverallThroughput: 71.95 MB/sec - PeakMemoryUsage: 440.00 KB - SerializeBatchTime: 11.628ms - ThriftTransmitTime(*): 42.25ms - UncompressedRowBatchSize: 2.00 MB HDFS_SCAN_NODE (id=0):(Total: 32.600ms, non-child: 32.600ms, % 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 BytesRead(500.0ms): 0 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 10.92 MB - BytesReadDataNodeCache: 0 - BytesReadLocal: 10.92 MB - BytesReadShortCircuit: 10.92 MB - BytesSkipped: 0 - DecompressionTime: 25.980ms - NumDisksAccessed: 2 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 14.17 MB - PerReadThreadRawHdfsThroughput: 2.10 GB/sec - RowsRead: 174.95K (174947) - RowsReturned: 174.95K (174947) - RowsReturnedRate: 5.37 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 57.73ms - MaterializeTupleTime(*): 22.691ms - ScannerThreadsSysTime: 0ns - ScannerThreadsUserTime: 47.992ms - ScannerThreadsVoluntaryContextSwitches: 5 - TotalRawHdfsReadTime(*): 5.83ms - TotalReadThroughput: 0.00 /sec