Query (id=75449469b5ff32b7:f5c96092b94d2489): Summary: Session ID: 5a48c8530286ef9f:6a4a95a9b2914ebe Session Type: BEESWAX Start Time: 2015-01-22 23:57:33.415110000 End Time: Query Type: QUERY Query State: CREATED Query Status: OK Impala Version: impalad version 2.2.0-cdh5-INTERNAL RELEASE (build 880c11a47984a34afc06cb13ec25b493a8b55b7d) User: jenkins Connected User: jenkins Delegated User: Network Address: 10.20.128.120:55721 Default Db: tpcds500gb_parquet Sql Statement: select s_store_name, sum(ss_net_profit) from store_sales join store on (store_sales.ss_store_sk = store.s_store_sk) join (select a.ca_zip from (select substr(ca_zip, 1, 5) ca_zip, count( *) cnt from customer_address join customer on (customer_address.ca_address_sk = customer.c_current_addr_sk) where c_preferred_cust_flag = 'Y' group by ca_zip having count(*) > 10 ) a left semi join (select substr(ca_zip, 1, 5) ca_zip from customer_address where substr(ca_zip, 1, 5) in ('89436', '30868', '65085', '22977', '83927', '77557', '58429', '40697', '80614', '10502', '32779', '91137', '61265', '98294', '17921', '18427', '21203', '59362', '87291', '84093', '21505', '17184', '10866', '67898', '25797', '28055', '18377', '80332', '74535', '21757', '29742', '90885', '29898', '17819', '40811', '25990', '47513', '89531', '91068', '10391', '18846', '99223', '82637', '41368', '83658', '86199', '81625', '26696', '89338', '88425', '32200', '81427', '19053', '77471', '36610', '99823', '43276', '41249', '48584', '83550', '82276', '18842', '78890', '14090', '38123', '40936', '34425', '19850', '43286', '80072', '79188', '54191', '11395', '50497', '84861', '90733', '21068', '57666', '37119', '25004', '57835', '70067', '62878', '95806', '19303', '18840', '19124', '29785', '16737', '16022', '49613', '89977', '68310', '60069', '98360', '48649', '39050', '41793', '25002', '27413', '39736', '47208', '16515', '94808', '57648', '15009', '80015', '42961', '63982', '21744', '71853', '81087', '67468', '34175', '64008', '20261', '11201', '51799', '48043', '45645', '61163', '48375', '36447', '57042', '21218', '41100', '89951', '22745', '35851', '83326', '61125', '78298', '80752', '49858', '52940', '96976', '63792', '11376', '53582', '18717', '90226', '50530', '94203', '99447', '27670', '96577', '57856', '56372', '16165', '23427', '54561', '28806', '44439', '22926', '30123', '61451', '92397', '56979', '92309', '70873', '13355', '21801', '46346', '37562', '56458', '28286', '47306', '99555', '69399', '26234', '47546', '49661', '88601', '35943', '39936', '25632', '24611', '44166', '56648', '30379', '59785', '11110', '14329', '93815', '52226', '71381', '13842', '25612', '63294', '14664', '21077', '82626', '18799', '60915', '81020', '56447', '76619', '11433', '13414', '42548', '92713', '70467', '30884', '47484', '16072', '38936', '13036', '88376', '45539', '35901', '19506', '65690', '73957', '71850', '49231', '14276', '20005', '18384', '76615', '11635', '38177', '55607', '41369', '95447', '58581', '58149', '91946', '33790', '76232', '75692', '95464', '22246', '51061', '56692', '53121', '77209', '15482', '10688', '14868', '45907', '73520', '72666', '25734', '17959', '24677', '66446', '94627', '53535', '15560', '41967', '69297', '11929', '59403', '33283', '52232', '57350', '43933', '40921', '36635', '10827', '71286', '19736', '80619', '25251', '95042', '15526', '36496', '55854', '49124', '81980', '35375', '49157', '63512', '28944', '14946', '36503', '54010', '18767', '23969', '43905', '66979', '33113', '21286', '58471', '59080', '13395', '79144', '70373', '67031', '38360', '26705', '50906', '52406', '26066', '73146', '15884', '31897', '30045', '61068', '45550', '92454', '13376', '14354', '19770', '22928', '97790', '50723', '46081', '30202', '14410', '20223', '88500', '67298', '13261', '14172', '81410', '93578', '83583', '46047', '94167', '82564', '21156', '15799', '86709', '37931', '74703', '83103', '23054', '70470', '72008', '49247', '91911', '69998', '20961', '70070', '63197', '54853', '88191', '91830', '49521', '19454', '81450', '89091', '62378', '25683', '61869', '51744', '36580', '85778', '36871', '48121', '28810', '83712', '45486', '67393', '26935', '42393', '20132', '55349', '86057', '21309', '80218', '10094', '11357', '48819', '39734', '40758', '30432', '21204', '29467', '30214', '61024', '55307', '74621', '11622', '68908', '33032', '52868', '99194', '99900', '84936', '69036', '99149', '45013', '32895', '59004', '32322', '14933', '32936', '33562', '72550', '27385', '58049', '58200', '16808', '21360', '32961', '18586', '79307', '15492') ) b on (a.ca_zip = b.ca_zip) ) v1 on (substr(store.s_zip, 1, 2) = substr(v1.ca_zip, 1, 2)) where ss_sold_date_sk between 2452276 and 2452366 group by s_store_name order by s_store_name limit 100 Coordinator: e1120.halxg.cloudera.com:22000 Plan: ---------------- Estimated Per-Host Requirements: Memory=170.02MB VCores=4 F08:PLAN FRAGMENT [UNPARTITIONED] 21:MERGING-EXCHANGE [UNPARTITIONED] order by: s_store_name ASC limit: 100 hosts=10 per-host-mem=unavailable tuple-ids=10 row-size=36B cardinality=10 F07:PLAN FRAGMENT [HASH(s_store_name)] DATASTREAM SINK [FRAGMENT=F08, EXCHANGE=21, UNPARTITIONED] 11:TOP-N [LIMIT=100] | order by: s_store_name ASC | hosts=10 per-host-mem=360B | tuple-ids=10 row-size=36B cardinality=10 | 20:AGGREGATE [FINALIZE] | output: sum:merge(ss_net_profit) | group by: s_store_name | hosts=10 per-host-mem=10.00MB | tuple-ids=9 row-size=36B cardinality=10 | 19:EXCHANGE [HASH(s_store_name)] hosts=10 per-host-mem=0B tuple-ids=9 row-size=36B cardinality=10 F00:PLAN FRAGMENT [RANDOM] DATASTREAM SINK [FRAGMENT=F07, EXCHANGE=19, HASH(s_store_name)] 10:AGGREGATE | output: sum(ss_net_profit) | group by: s_store_name | hosts=10 per-host-mem=10.00MB | tuple-ids=9 row-size=36B cardinality=10 | 09:HASH JOIN [INNER JOIN, BROADCAST] | hash predicates: substr(store.s_zip, 1, 2) = substr(substr(ca_zip, 1, 5), 1, 2) | hosts=10 per-host-mem=18.30KB | tuple-ids=0,1,4 row-size=85B cardinality=125298127 | |--18:EXCHANGE [BROADCAST] | hosts=6 per-host-mem=0B | tuple-ids=4 row-size=24B cardinality=710 | 08:HASH JOIN [INNER JOIN, BROADCAST] | hash predicates: store_sales.ss_store_sk = store.s_store_sk | hosts=10 per-host-mem=5.15KB | tuple-ids=0,1 row-size=61B cardinality=125298127 | |--12:EXCHANGE [BROADCAST] | hosts=3 per-host-mem=0B | tuple-ids=1 row-size=49B cardinality=98 | 00:SCAN HDFS [tpcds500gb_parquet.store_sales, RANDOM] partitions=90/1823 files=90 size=5.67GB table stats: 4125561494 rows total column stats: all hosts=10 per-host-mem=160.00MB tuple-ids=0 row-size=12B cardinality=125298127 F06:PLAN FRAGMENT [HASH(substr(ca_zip, 1, 5))] DATASTREAM SINK [FRAGMENT=F00, EXCHANGE=18, BROADCAST] 07:HASH JOIN [RIGHT SEMI JOIN, PARTITIONED] | hash predicates: substr(ca_zip, 1, 5) = substr(ca_zip, 1, 5) | hosts=6 per-host-mem=3.05KB | tuple-ids=4 row-size=24B cardinality=710 | |--16:AGGREGATE [FINALIZE] | | output: count:merge(*) | | group by: substr(ca_zip, 1, 5) | | having: count(*) > 10 | | hosts=6 per-host-mem=10.00MB | | tuple-ids=4 row-size=24B cardinality=710 | | | 15:EXCHANGE [HASH(substr(ca_zip, 1, 5))] | hosts=6 per-host-mem=0B | tuple-ids=4 row-size=24B cardinality=7097 | 17:EXCHANGE [HASH(substr(ca_zip, 1, 5))] hosts=6 per-host-mem=0B tuple-ids=6 row-size=21B cardinality=230000 F05:PLAN FRAGMENT [HASH(customer_address.ca_address_sk)] DATASTREAM SINK [FRAGMENT=F06, EXCHANGE=15, HASH(substr(ca_zip, 1, 5))] 05:AGGREGATE | output: count(*) | group by: substr(ca_zip, 1, 5) | hosts=6 per-host-mem=10.00MB | tuple-ids=4 row-size=24B cardinality=7097 | 04:HASH JOIN [INNER JOIN, PARTITIONED] | hash predicates: customer_address.ca_address_sk = customer.c_current_addr_sk | hosts=6 per-host-mem=5.62MB | tuple-ids=2,3 row-size=50B cardinality=2300000 | |--14:EXCHANGE [HASH(customer.c_current_addr_sk)] | hosts=10 per-host-mem=0B | tuple-ids=3 row-size=21B cardinality=1533333 | 13:EXCHANGE [HASH(customer_address.ca_address_sk)] hosts=6 per-host-mem=0B tuple-ids=2 row-size=29B cardinality=2300000 F04:PLAN FRAGMENT [RANDOM] DATASTREAM SINK [FRAGMENT=F05, EXCHANGE=14, HASH(customer.c_current_addr_sk)] 03:SCAN HDFS [tpcds500gb_parquet.customer, RANDOM] partitions=1/1 files=5 size=238.35MB predicates: c_preferred_cust_flag = 'Y' table stats: 4600000 rows total column stats: all hosts=10 per-host-mem=112.00MB tuple-ids=3 row-size=21B cardinality=1533333 F03:PLAN FRAGMENT [RANDOM] DATASTREAM SINK [FRAGMENT=F05, EXCHANGE=13, HASH(customer_address.ca_address_sk)] 02:SCAN HDFS [tpcds500gb_parquet.customer_address, RANDOM] partitions=1/1 files=2 size=42.67MB table stats: 2300000 rows total column stats: all hosts=6 per-host-mem=64.00MB tuple-ids=2 row-size=29B cardinality=2300000 F02:PLAN FRAGMENT [RANDOM] DATASTREAM SINK [FRAGMENT=F06, EXCHANGE=17, HASH(substr(ca_zip, 1, 5))] 06:SCAN HDFS [tpcds500gb_parquet.customer_address, RANDOM] partitions=1/1 files=2 size=42.67MB predicates: substr(ca_zip, 1, 5) IN ('89436', '30868', '65085', '22977', '83927', '77557', '58429', '40697', '80614', '10502', '32779', '91137', '61265', '98294', '17921', '18427', '21203', '59362', '87291', '84093', '21505', '17184', '10866', '67898', '25797', '28055', '18377', '80332', '74535', '21757', '29742', '90885', '29898', '17819', '40811', '25990', '47513', '89531', '91068', '10391', '18846', '99223', '82637', '41368', '83658', '86199', '81625', '26696', '89338', '88425', '32200', '81427', '19053', '77471', '36610', '99823', '43276', '41249', '48584', '83550', '82276', '18842', '78890', '14090', '38123', '40936', '34425', '19850', '43286', '80072', '79188', '54191', '11395', '50497', '84861', '90733', '21068', '57666', '37119', '25004', '57835', '70067', '62878', '95806', '19303', '18840', '19124', '29785', '16737', '16022', '49613', '89977', '68310', '60069', '98360', '48649', '39050', '41793', '25002', '27413', '39736', '47208', '16515', '94808', '57648', '15009', '80015', '42961', '63982', '21744', '71853', '81087', '67468', '34175', '64008', '20261', '11201', '51799', '48043', '45645', '61163', '48375', '36447', '57042', '21218', '41100', '89951', '22745', '35851', '83326', '61125', '78298', '80752', '49858', '52940', '96976', '63792', '11376', '53582', '18717', '90226', '50530', '94203', '99447', '27670', '96577', '57856', '56372', '16165', '23427', '54561', '28806', '44439', '22926', '30123', '61451', '92397', '56979', '92309', '70873', '13355', '21801', '46346', '37562', '56458', '28286', '47306', '99555', '69399', '26234', '47546', '49661', '88601', '35943', '39936', '25632', '24611', '44166', '56648', '30379', '59785', '11110', '14329', '93815', '52226', '71381', '13842', '25612', '63294', '14664', '21077', '82626', '18799', '60915', '81020', '56447', '76619', '11433', '13414', '42548', '92713', '70467', '30884', '47484', '16072', '38936', '13036', '88376', '45539', '35901', '19506', '65690', '73957', '71850', '49231', '14276', '20005', '18384', '76615', '11635', '38177', '55607', '41369', '95447', '58581', '58149', '91946', '33790', '76232', '75692', '95464', '22246', '51061', '56692', '53121', '77209', '15482', '10688', '14868', '45907', '73520', '72666', '25734', '17959', '24677', '66446', '94627', '53535', '15560', '41967', '69297', '11929', '59403', '33283', '52232', '57350', '43933', '40921', '36635', '10827', '71286', '19736', '80619', '25251', '95042', '15526', '36496', '55854', '49124', '81980', '35375', '49157', '63512', '28944', '14946', '36503', '54010', '18767', '23969', '43905', '66979', '33113', '21286', '58471', '59080', '13395', '79144', '70373', '67031', '38360', '26705', '50906', '52406', '26066', '73146', '15884', '31897', '30045', '61068', '45550', '92454', '13376', '14354', '19770', '22928', '97790', '50723', '46081', '30202', '14410', '20223', '88500', '67298', '13261', '14172', '81410', '93578', '83583', '46047', '94167', '82564', '21156', '15799', '86709', '37931', '74703', '83103', '23054', '70470', '72008', '49247', '91911', '69998', '20961', '70070', '63197', '54853', '88191', '91830', '49521', '19454', '81450', '89091', '62378', '25683', '61869', '51744', '36580', '85778', '36871', '48121', '28810', '83712', '45486', '67393', '26935', '42393', '20132', '55349', '86057', '21309', '80218', '10094', '11357', '48819', '39734', '40758', '30432', '21204', '29467', '30214', '61024', '55307', '74621', '11622', '68908', '33032', '52868', '99194', '99900', '84936', '69036', '99149', '45013', '32895', '59004', '32322', '14933', '32936', '33562', '72550', '27385', '58049', '58200', '16808', '21360', '32961', '18586', '79307', '15492') table stats: 2300000 rows total column stats: all hosts=6 per-host-mem=32.00MB tuple-ids=6 row-size=21B cardinality=230000 F01:PLAN FRAGMENT [RANDOM] DATASTREAM SINK [FRAGMENT=F00, EXCHANGE=12, BROADCAST] 01:SCAN HDFS [tpcds500gb_parquet.store, RANDOM] partitions=1/1 files=1 size=15.12KB table stats: 98 rows total column stats: all hosts=3 per-host-mem=48.00MB tuple-ids=1 row-size=49B cardinality=98 ---------------- Estimated Per-Host Mem: 178281941 Estimated Per-Host VCores: 4 Request Pool: root.default Query Timeline: 20s945ms - Start execution: 68.457us (68.457us) - Planning finished: 60.258ms (60.190ms) - Ready to start remote fragments: 63.37ms (2.778ms) - Remote fragments started: 1s040ms (977.835ms) - Rows available: 20s906ms (19s865ms) - First row fetched: 20s937ms (30.713ms) ImpalaServer: - ClientFetchWaitTimer: 31.503ms - RowMaterializationTimer: 111.71us Execution Profile 75449469b5ff32b7:f5c96092b94d2489:(Total: 20s849ms, non-child: 0ns, % non-child: 0.00%) Fragment start latencies: count: 34, last: 0.005255ns, min: 0.003398ns, max: 0.244758ns, mean: 0.157636ns, stddev: 0.098426ns Per Node Peak Memory Usage: e1118.halxg.cloudera.com:22000(996.44 MB) e1219.halxg.cloudera.com:22000(1005.77 MB) e1121.halxg.cloudera.com:22000(107.52 MB) e1221.halxg.cloudera.com:22000(107.52 MB) e1220.halxg.cloudera.com:22000(113.89 MB) e1218.halxg.cloudera.com:22000(113.58 MB) e1318.halxg.cloudera.com:22000(111.12 MB) e1119.halxg.cloudera.com:22000(107.46 MB) e1319.halxg.cloudera.com:22000(110.17 MB) e1120.halxg.cloudera.com:22000(122.99 MB) - FinalizationTimer: 0ns Coordinator Fragment F08:(Total: 19s864ms, non-child: 515.110us, % non-child: 0.00%) MemoryUsage(500.0ms): 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB, 8.00 KB ThreadUsage(500.0ms): 1, 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 32.00 KB (32768) - PerHostPeakMemUsage: 0 - PrepareTime: 43.578us - RowsProduced: 9 (9) - TotalCpuTime: 20s875ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 0ns - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 310 (310) - BlocksRecycled: 50 (50) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 40.24 GB (43209306112) - PeakMemoryUsage: 513.89 KB (526224) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns EXCHANGE_NODE (id=21):(Total: 19s864ms, non-child: 147.328us, % non-child: 0.00%) BytesReceived(500.0ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - BytesReceived: 360.00 B (360) - ConvertRowBatchTime: 0ns - DeserializeRowBatchTimer: 44.296us - FirstBatchArrivalWaitTime: 19s863ms - MergeGetNext: 47.465us - MergeGetNextBatch: 32.529us - PeakMemoryUsage: 0 - RowsReturned: 9 (9) - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Averaged Fragment F07:(Total: 20s550ms, non-child: 0ns, % non-child: 0.00%) split sizes: min: 0, max: 0, avg: 0, stddev: 0 completion times: min:20s619ms max:20s626ms mean: 20s622ms stddev:2.333631.333.630593ms 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: 6.29 MB (6594969) - PerHostPeakMemUsage: 289.65 MB (303715441) - PrepareTime: 213.958ms - RowsProduced: 0 (0) - TotalCpuTime: 502.169ms - TotalNetworkReceiveTime: 20s334ms - TotalNetworkSendTime: 181.489us - TotalStorageWaitTime: 0ns CodeGen:(Total: 495.921ms, non-child: 495.921ms, % non-child: 100.00%) - CodegenTime: 2.836ms - CompileTime: 36.733ms - LoadTime: 153.798us - ModuleFileSize: 1.96 MB (2056856) - OptimizationTime: 248.540ms - PrepareTime: 208.784ms DataStreamSender (dst_id=21):(Total: 34.357us, non-child: 34.357us, % non-child: 100.00%) - BytesSent: 36.00 B (36) - NetworkThroughput(*): 129.37 KB/sec - OverallThroughput: 701.65 KB/sec - PeakMemoryUsage: 4.00 KB (4096) - SerializeBatchTime: 7.425us - ThriftTransmitTime(*): 141.385us - UncompressedRowBatchSize: 45.00 B (45) SORT_NODE (id=11):(Total: 20s549ms, non-child: 72.413us, % non-child: 0.00%) - PeakMemoryUsage: 12.00 KB (12288) - RowsReturned: 0 (0) - RowsReturnedRate: 0 AGGREGATION_NODE (id=20):(Total: 20s549ms, non-child: 214.774ms, % non-child: 1.05%) - BuildTime: 28.91us - GetNewBlockTime: 119.627us - GetResultsTime: 2.299us - HashBuckets: 819 (819) - LargestPartitionPercent: 3 (3) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 32 (32) - PeakMemoryUsage: 6.27 MB (6574899) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 0 (0) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) - UnpinTime: 2.691us EXCHANGE_NODE (id=19):(Total: 20s334ms, non-child: 20s334ms, % non-child: 100.00%) - BytesReceived: 285.00 B (285) - ConvertRowBatchTime: 16.185us - DeserializeRowBatchTimer: 46.12us - FirstBatchArrivalWaitTime: 20s205ms - PeakMemoryUsage: 0 - RowsReturned: 9 (9) - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 395 (395) - BlocksRecycled: 85 (85) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 40.24 GB (43209306112) - PeakMemoryUsage: 178.39 MB (187056165) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns Averaged Fragment F00:(Total: 19s991ms, non-child: 0ns, % non-child: 0.00%) split sizes: min: 544.88 MB, max: 630.06 MB, avg: 580.50 MB, stddev: 35.79 MB completion times: min:20s129ms max:20s393ms mean: 20s212ms stddev:91.511435.511.434596ms execution rates: min:27.06 MB/sec max:30.99 MB/sec mean:28.71 MB/sec stddev:1.66 MB/sec num instances: 10 - AverageThreadTokens: 10.41 - PeakMemoryUsage: 103.49 MB (108519944) - PerHostPeakMemUsage: 289.65 MB (303715441) - PrepareTime: 222.239ms - RowsProduced: 9 (9) - TotalCpuTime: 3m14s - TotalNetworkReceiveTime: 18s317ms - TotalNetworkSendTime: 1.685ms - TotalStorageWaitTime: 190.842ms CodeGen:(Total: 647.285ms, non-child: 647.285ms, % non-child: 100.00%) - CodegenTime: 2.643ms - CompileTime: 108.398ms - LoadTime: 103.92us - ModuleFileSize: 1.96 MB (2056856) - OptimizationTime: 330.263ms - PrepareTime: 206.915ms DataStreamSender (dst_id=19):(Total: 47.17us, non-child: 47.17us, % non-child: 100.00%) - BytesSent: 285.00 B (285) - NetworkThroughput(*): 210.11 KB/sec - OverallThroughput: 6.00 MB/sec - PeakMemoryUsage: 40.00 KB (40960) - SerializeBatchTime: 87.875us - ThriftTransmitTime(*): 1.345ms - UncompressedRowBatchSize: 452.00 B (452) AGGREGATION_NODE (id=10):(Total: 19s988ms, non-child: 477.867ms, % non-child: 2.39%) - BuildTime: 258.213ms - GetNewBlockTime: 112.785us - GetResultsTime: 10.249us - HashBuckets: 8.19K (8192) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 32 (32) - PeakMemoryUsage: 6.91 MB (7247288) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 9 (9) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) - UnpinTime: 2.573us HASH_JOIN_NODE (id=9):(Total: 19s511ms, non-child: 515.275ms, % non-child: 2.64%) - BuildPartitionTime: 34.307us - BuildRows: 21 (21) - BuildRowsPartitioned: 21 (21) - BuildTime: 24.738us - GetNewBlockTime: 213.401us - HashBuckets: 44 (44) - LargestPartitionPercent: 19 (19) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 32 (32) - PeakMemoryUsage: 4.03 MB (4227072) - PinTime: 0ns - ProbeRows: 12.23M (12234548) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 577.115ms - RowsReturned: 4.41M (4405739) - RowsReturnedRate: 225.78 K/sec - SpilledPartitions: 0 (0) - UnpinTime: 4.194us EXCHANGE_NODE (id=18):(Total: 18s228ms, non-child: 18s228ms, % non-child: 100.00%) - BytesReceived: 511.00 B (511) - ConvertRowBatchTime: 7.929us - DeserializeRowBatchTimer: 32.174us - FirstBatchArrivalWaitTime: 7s036ms - PeakMemoryUsage: 0 - RowsReturned: 21 (21) - RowsReturnedRate: 1.00 /sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns HASH_JOIN_NODE (id=8):(Total: 767.290ms, non-child: 606.187ms, % non-child: 79.00%) - BuildPartitionTime: 29.165us - BuildRows: 98 (98) - BuildRowsPartitioned: 98 (98) - BuildTime: 43.402us - GetNewBlockTime: 188.230us - HashBuckets: 198 (198) - LargestPartitionPercent: 4 (4) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 32 (32) - PeakMemoryUsage: 5.09 MB (5334576) - PinTime: 0ns - ProbeRows: 12.53M (12529812) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 573.628ms - RowsReturned: 12.23M (12234548) - RowsReturnedRate: 15.99 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 3.572us EXCHANGE_NODE (id=12):(Total: 88.832ms, non-child: 88.832ms, % non-child: 100.00%) - BytesReceived: 3.32 KB (3403) - ConvertRowBatchTime: 4.774us - DeserializeRowBatchTimer: 26.89us - FirstBatchArrivalWaitTime: 87.987ms - PeakMemoryUsage: 0 - RowsReturned: 98 (98) - RowsReturnedRate: 677.55 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns HDFS_SCAN_NODE (id=0):(Total: 72.269ms, non-child: 72.269ms, % non-child: 100.00%) - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 8.77 - BytesRead: 56.97 MB (59737624) - BytesReadDataNodeCache: 0 - BytesReadLocal: 56.97 MB (59737624) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 56.97 MB (59737624) - DecompressionTime: 40.324ms - MaxCompressedTextFileLength: 0 - NumColumns: 0 (0) - NumDisksAccessed: 6 (6) - NumScannerThreadsStarted: 9 (9) - PeakMemoryUsage: 90.62 MB (95020751) - PerReadThreadRawHdfsThroughput: 1.09 GB/sec - RemoteScanRanges: 0 (0) - RowsRead: 12.53M (12529812) - RowsReturned: 12.53M (12529812) - RowsReturnedRate: 174.40 M/sec - ScanRangesComplete: 9 (9) - ScannerThreadsInvoluntaryContextSwitches: 863 (863) - ScannerThreadsTotalWallClockTime: 2m54s - MaterializeTupleTime(*): 2m53s - ScannerThreadsSysTime: 149.272ms - ScannerThreadsUserTime: 1s930ms - ScannerThreadsVoluntaryContextSwitches: 13.53K (13531) - TotalRawHdfsReadTime(*): 52.92ms - TotalReadThroughput: 2.80 MB/sec Averaged Fragment F06:(Total: 18s176ms, non-child: 0ns, % non-child: 0.00%) split sizes: min: 0, max: 0, avg: 0, stddev: 0 completion times: min:18s425ms max:18s450ms mean: 18s437ms stddev:12.795283.795.283000ms execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec num instances: 2 - AverageThreadTokens: 1.05 - PeakMemoryUsage: 10.31 MB (10813440) - PerHostPeakMemUsage: 1001.10 MB (1049733856) - PrepareTime: 209.87ms - RowsProduced: 10 (10) - TotalCpuTime: 988.704ms - TotalNetworkReceiveTime: 18s947ms - TotalNetworkSendTime: 7.44us - TotalStorageWaitTime: 0ns CodeGen:(Total: 667.708ms, non-child: 667.708ms, % non-child: 100.00%) - CodegenTime: 2.471ms - CompileTime: 104.906ms - LoadTime: 79.125us - ModuleFileSize: 1.96 MB (2056856) - OptimizationTime: 361.765ms - PrepareTime: 199.430ms DataStreamSender (dst_id=18):(Total: 114.395us, non-child: 114.395us, % non-child: 100.00%) - BytesSent: 2.50 KB (2555) - NetworkThroughput(*): 811.94 KB/sec - OverallThroughput: 21.31 MB/sec - PeakMemoryUsage: 40.00 KB (40960) - SerializeBatchTime: 18.470us - ThriftTransmitTime(*): 3.71ms - UncompressedRowBatchSize: 4.24 KB (4345) HASH_JOIN_NODE (id=7):(Total: 18s177ms, non-child: 0ns, % non-child: 0.00%) - BuildPartitionTime: 337.132us - BuildRows: 2.00K (2003) - BuildRowsPartitioned: 2.00K (2003) - BuildTime: 276.616us - GetNewBlockTime: 139.22us - HashBuckets: 5.82K (5824) - LargestPartitionPercent: 4 (4) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 32 (32) - PeakMemoryUsage: 6.07 MB (6362624) - PinTime: 0ns - ProbeRows: 7.15K (7148) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 966.116us - RowsReturned: 10 (10) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) - UnpinTime: 4.595us AGGREGATION_NODE (id=16):(Total: 990.273ms, non-child: 5.719ms, % non-child: 0.58%) - BuildTime: 1.195ms - GetNewBlockTime: 131.707us - GetResultsTime: 568.120us - HashBuckets: 32.77K (32768) - LargestPartitionPercent: 2 (2) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 32 (32) - PeakMemoryUsage: 6.31 MB (6620184) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 2.00K (2003) - RowsReturnedRate: 2.02 K/sec - SpilledPartitions: 0 (0) - UnpinTime: 2.452us EXCHANGE_NODE (id=15):(Total: 984.553ms, non-child: 984.553ms, % non-child: 100.00%) - BytesReceived: 123.36 KB (126316) - ConvertRowBatchTime: 274.937us - DeserializeRowBatchTimer: 582.371us - FirstBatchArrivalWaitTime: 973.528ms - PeakMemoryUsage: 0 - RowsReturned: 7.14K (7145) - RowsReturnedRate: 7.26 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns EXCHANGE_NODE (id=17):(Total: 17s963ms, non-child: 17s963ms, % non-child: 100.00%) - BytesReceived: 121.03 KB (123935) - ConvertRowBatchTime: 253.191us - DeserializeRowBatchTimer: 597.844us - FirstBatchArrivalWaitTime: 4s595ms - PeakMemoryUsage: 0 - RowsReturned: 7.15K (7148) - RowsReturnedRate: 397.00 /sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Averaged Fragment F05:(Total: 1s034ms, non-child: 0ns, % non-child: 0.00%) split sizes: min: 0, max: 0, avg: 0, stddev: 0 completion times: min:1s193ms max:1s260ms mean: 1s226ms stddev:33.339005.339.005500ms execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec num instances: 2 - AverageThreadTokens: 1.17 - PeakMemoryUsage: 866.75 MB (908852896) - PerHostPeakMemUsage: 1001.10 MB (1049733856) - PrepareTime: 206.858ms - RowsProduced: 7.14K (7145) - TotalCpuTime: 1s693ms - TotalNetworkReceiveTime: 36.187ms - TotalNetworkSendTime: 875.742us - TotalStorageWaitTime: 0ns CodeGen:(Total: 596.509ms, non-child: 596.509ms, % non-child: 100.00%) - CodegenTime: 2.340ms - CompileTime: 70.756ms - LoadTime: 59.522us - ModuleFileSize: 1.96 MB (2056856) - OptimizationTime: 326.532ms - PrepareTime: 197.618ms DataStreamSender (dst_id=15):(Total: 2.531ms, non-child: 2.531ms, % non-child: 100.00%) - BytesSent: 123.36 KB (126316) - NetworkThroughput(*): 31.18 MB/sec - OverallThroughput: 47.62 MB/sec - PeakMemoryUsage: 56.00 KB (57344) - SerializeBatchTime: 1.114ms - ThriftTransmitTime(*): 3.870ms - UncompressedRowBatchSize: 286.13 KB (293000) AGGREGATION_NODE (id=5):(Total: 1s031ms, non-child: 320.479ms, % non-child: 31.08%) - BuildTime: 113.670ms - GetNewBlockTime: 131.457us - GetResultsTime: 466.467us - HashBuckets: 32.77K (32768) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 32 (32) - PeakMemoryUsage: 6.39 MB (6697892) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 7.14K (7145) - RowsReturnedRate: 6.93 K/sec - SpilledPartitions: 0 (0) - UnpinTime: 2.423us HASH_JOIN_NODE (id=4):(Total: 710.661ms, non-child: 608.216ms, % non-child: 85.58%) - BuildPartitionTime: 125.564ms - BuildRows: 1.09M (1087587) - BuildRowsPartitioned: 1.09M (1087587) - BuildTime: 88.507ms - GetNewBlockTime: 960.344us - HashBuckets: 4.19M (4194304) - LargestPartitionPercent: 3 (3) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 32 (32) - PeakMemoryUsage: 838.02 MB (878731264) - PinTime: 0ns - ProbeRows: 1.15M (1150000) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 350.50ms - RowsReturned: 1.09M (1087587) - RowsReturnedRate: 1.53 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 4.548us EXCHANGE_NODE (id=14):(Total: 49.352ms, non-child: 49.352ms, % non-child: 100.00%) - BytesReceived: 16.59 MB (17394388) - ConvertRowBatchTime: 30.375ms - DeserializeRowBatchTimer: 86.132ms - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 1.09M (1087587) - RowsReturnedRate: 22.04 M/sec - SendersBlockedTimer: 250.795ms - SendersBlockedTotalTimer(*): 1s210ms EXCHANGE_NODE (id=13):(Total: 53.91ms, non-child: 53.91ms, % non-child: 100.00%) - BytesReceived: 22.00 MB (23063950) - ConvertRowBatchTime: 26.664ms - DeserializeRowBatchTimer: 104.298ms - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 1.15M (1150000) - RowsReturnedRate: 22.29 M/sec - SendersBlockedTimer: 462.720ms - SendersBlockedTotalTimer(*): 715.208ms Averaged Fragment F04:(Total: 459.217ms, non-child: 3.626ms, % non-child: 0.79%) split sizes: min: 32.03 MB, max: 51.90 MB, avg: 47.67 MB, stddev: 7.82 MB completion times: min:400.322ms max:489.804ms mean: 459.500614.500.613600ms stddev:31.465293.465.292509ms execution rates: min:80.00 MB/sec max:111.42 MB/sec mean:103.05 MB/sec stddev:11.73 MB/sec num instances: 5 - AverageThreadTokens: 2.00 - PeakMemoryUsage: 9.44 MB (9898019) - PerHostPeakMemUsage: 134.02 MB (140528993) - PrepareTime: 142.704us - RowsProduced: 435.03K (435034) - TotalCpuTime: 525.96ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 290.895ms - TotalStorageWaitTime: 10.230ms DataStreamSender (dst_id=14):(Total: 436.891ms, non-child: 436.891ms, % non-child: 100.00%) - BytesSent: 6.64 MB (6957755) - NetworkThroughput(*): 9.66 MB/sec - OverallThroughput: 15.08 MB/sec - PeakMemoryUsage: 74.59 KB (76384) - SerializeBatchTime: 56.645ms - ThriftTransmitTime(*): 682.870ms - UncompressedRowBatchSize: 12.03 MB (12618564) HDFS_SCAN_NODE (id=3):(Total: 18.699ms, non-child: 18.699ms, % non-child: 100.00%) - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 1.00 - BytesRead: 3.95 MB (4146486) - BytesReadDataNodeCache: 0 - BytesReadLocal: 3.95 MB (4146486) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 3.95 MB (4146486) - DecompressionTime: 1.430ms - MaxCompressedTextFileLength: 0 - NumColumns: 0 (0) - NumDisksAccessed: 1 (1) - NumScannerThreadsStarted: 1 (1) - PeakMemoryUsage: 9.32 MB (9767566) - PerReadThreadRawHdfsThroughput: 1.19 GB/sec - RemoteScanRanges: 0 (0) - RowsRead: 920.00K (920000) - RowsReturned: 435.03K (435034) - RowsReturnedRate: 24.37 M/sec - ScanRangesComplete: 1 (1) - ScannerThreadsInvoluntaryContextSwitches: 22 (22) - ScannerThreadsTotalWallClockTime: 364.161ms - MaterializeTupleTime(*): 350.790ms - ScannerThreadsSysTime: 2.199ms - ScannerThreadsUserTime: 159.975ms - ScannerThreadsVoluntaryContextSwitches: 29 (29) - TotalRawHdfsReadTime(*): 3.247ms - TotalReadThroughput: 7.91 MB/sec Averaged Fragment F03:(Total: 948.633ms, non-child: 3.944ms, % non-child: 0.42%) split sizes: min: 20.13 MB, max: 22.54 MB, avg: 21.34 MB, stddev: 1.21 MB completion times: min:926.628ms max:976.947ms mean: 951.788076.788.076000ms stddev:25.159851.159.851000ms execution rates: min:21.72 MB/sec max:23.08 MB/sec mean:22.40 MB/sec stddev:694.25 KB/sec num instances: 2 - AverageThreadTokens: 2.00 - PeakMemoryUsage: 17.70 MB (18560984) - PerHostPeakMemUsage: 1001.10 MB (1049733856) - PrepareTime: 106.125us - RowsProduced: 1.15M (1150000) - TotalCpuTime: 1s295ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 547.506ms - TotalStorageWaitTime: 8.510ms DataStreamSender (dst_id=13):(Total: 927.659ms, non-child: 927.659ms, % non-child: 100.00%) - BytesSent: 22.00 MB (23063950) - NetworkThroughput(*): 18.28 MB/sec - OverallThroughput: 23.67 MB/sec - PeakMemoryUsage: 56.00 KB (57344) - SerializeBatchTime: 204.74ms - ThriftTransmitTime(*): 1s208ms - UncompressedRowBatchSize: 44.81 MB (46984575) HDFS_SCAN_NODE (id=2):(Total: 17.29ms, non-child: 17.29ms, % non-child: 100.00%) - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 1.00 - BytesRead: 6.44 MB (6750158) - BytesReadDataNodeCache: 0 - BytesReadLocal: 6.44 MB (6750158) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 6.44 MB (6750158) - DecompressionTime: 20.709ms - MaxCompressedTextFileLength: 0 - NumColumns: 0 (0) - NumDisksAccessed: 1 (1) - NumScannerThreadsStarted: 1 (1) - PeakMemoryUsage: 17.60 MB (18454488) - PerReadThreadRawHdfsThroughput: 1.39 GB/sec - RemoteScanRanges: 0 (0) - RowsRead: 1.15M (1150000) - RowsReturned: 1.15M (1150000) - RowsReturnedRate: 69.19 M/sec - ScanRangesComplete: 1 (1) - ScannerThreadsInvoluntaryContextSwitches: 51 (51) - ScannerThreadsTotalWallClockTime: 898.2ms - MaterializeTupleTime(*): 864.970ms - ScannerThreadsSysTime: 3.499ms - ScannerThreadsUserTime: 142.478ms - ScannerThreadsVoluntaryContextSwitches: 980 (980) - TotalRawHdfsReadTime(*): 4.626ms - TotalReadThroughput: 6.44 MB/sec Averaged Fragment F02:(Total: 16s713ms, non-child: 1.930ms, % non-child: 0.01%) split sizes: min: 20.13 MB, max: 22.54 MB, avg: 21.34 MB, stddev: 1.21 MB completion times: min:15s271ms max:18s157ms mean: 16s714ms stddev:1s443ms execution rates: min:1.24 MB/sec max:1.32 MB/sec mean:1.28 MB/sec stddev:39.10 KB/sec num instances: 2 - AverageThreadTokens: 2.00 - PeakMemoryUsage: 2.62 MB (2743456) - PerHostPeakMemUsage: 1001.10 MB (1049733856) - PrepareTime: 525.816us - RowsProduced: 7.15K (7148) - TotalCpuTime: 33s423ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 1.150ms - TotalStorageWaitTime: 3.60ms DataStreamSender (dst_id=17):(Total: 2.713ms, non-child: 2.713ms, % non-child: 100.00%) - BytesSent: 121.03 KB (123935) - NetworkThroughput(*): 25.53 MB/sec - OverallThroughput: 43.34 MB/sec - PeakMemoryUsage: 74.59 KB (76384) - SerializeBatchTime: 1.134ms - ThriftTransmitTime(*): 4.763ms - UncompressedRowBatchSize: 230.42 KB (235946) HDFS_SCAN_NODE (id=6):(Total: 16s709ms, non-child: 16s709ms, % non-child: 100.00%) - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 1.00 - BytesRead: 1.92 MB (2009330) - BytesReadDataNodeCache: 0 - BytesReadLocal: 1.92 MB (2009330) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 1.92 MB (2009330) - DecompressionTime: 674.636us - MaxCompressedTextFileLength: 0 - NumColumns: 0 (0) - NumDisksAccessed: 1 (1) - NumScannerThreadsStarted: 1 (1) - PeakMemoryUsage: 2.54 MB (2658880) - PerReadThreadRawHdfsThroughput: 1.84 GB/sec - RemoteScanRanges: 0 (0) - RowsRead: 1.15M (1150000) - RowsReturned: 7.15K (7148) - RowsReturnedRate: 428.00 /sec - ScanRangesComplete: 1 (1) - ScannerThreadsInvoluntaryContextSwitches: 1.70K (1701) - ScannerThreadsTotalWallClockTime: 16s710ms - MaterializeTupleTime(*): 16s705ms - ScannerThreadsSysTime: 2.999ms - ScannerThreadsUserTime: 16s683ms - ScannerThreadsVoluntaryContextSwitches: 6 (6) - TotalRawHdfsReadTime(*): 1.21ms - TotalReadThroughput: 115.78 KB/sec Averaged Fragment F01:(Total: 6.685ms, non-child: 2.811ms, % non-child: 42.06%) split sizes: min: 15.12 KB, max: 15.12 KB, avg: 15.12 KB, stddev: 0 completion times: min:8.75ms max:8.75ms mean: 8.075377.75.377000ms stddev:0.000000ns execution rates: min:1.83 MB/sec max:1.83 MB/sec mean:1.83 MB/sec stddev:0.00 /sec num instances: 1 - AverageThreadTokens: 0.00 - PeakMemoryUsage: 139.00 KB (142336) - PerHostPeakMemUsage: 54.60 MB (57250680) - PrepareTime: 118.374us - RowsProduced: 98 (98) - TotalCpuTime: 10.824ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 35.336us - TotalStorageWaitTime: 2.825ms DataStreamSender (dst_id=12):(Total: 230.601us, non-child: 230.601us, % non-child: 100.00%) - BytesSent: 33.23 KB (34030) - NetworkThroughput(*): 12.82 MB/sec - OverallThroughput: 140.73 MB/sec - PeakMemoryUsage: 40.00 KB (40960) - SerializeBatchTime: 55.277us - ThriftTransmitTime(*): 2.531ms - UncompressedRowBatchSize: 58.37 KB (59770) HDFS_SCAN_NODE (id=1):(Total: 3.642ms, non-child: 3.642ms, % non-child: 100.00%) - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 16.12 KB (16506) - BytesReadDataNodeCache: 0 - BytesReadLocal: 16.12 KB (16506) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 16.12 KB (16506) - DecompressionTime: 9.377us - MaxCompressedTextFileLength: 0 - NumColumns: 0 (0) - NumDisksAccessed: 1 (1) - NumScannerThreadsStarted: 1 (1) - PeakMemoryUsage: 91.00 KB (93184) - PerReadThreadRawHdfsThroughput: 474.78 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 98 (98) - RowsReturned: 98 (98) - RowsReturnedRate: 26.90 K/sec - ScanRangesComplete: 1 (1) - ScannerThreadsInvoluntaryContextSwitches: 0 (0) - ScannerThreadsTotalWallClockTime: 3.250ms - MaterializeTupleTime(*): 37.230us - ScannerThreadsSysTime: 0ns - ScannerThreadsUserTime: 0ns - ScannerThreadsVoluntaryContextSwitches: 10 (10) - TotalRawHdfsReadTime(*): 33.155us - TotalReadThroughput: 0.00 /sec Fragment F07: Instance 75449469b5ff32b7:f5c96092b94d2491 (host=e1221.halxg.cloudera.com:22000):(Total: 20s568ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB ThreadUsage(500.0ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 6.31 MB (6619136) - PerHostPeakMemUsage: 107.52 MB (112746368) - PrepareTime: 211.205ms - RowsProduced: 2 (2) - TotalCpuTime: 481.792ms - TotalNetworkReceiveTime: 20s355ms - TotalNetworkSendTime: 469.182us - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 310 (310) - BlocksRecycled: 50 (50) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 40.24 GB (43209306112) - PeakMemoryUsage: 513.89 KB (526224) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 475.493ms, non-child: 475.493ms, % non-child: 100.00%) - CodegenTime: 2.790ms - CompileTime: 30.885ms - LoadTime: 129.604us - ModuleFileSize: 1.96 MB (2056856) - OptimizationTime: 236.673ms - PrepareTime: 206.191ms DataStreamSender (dst_id=21):(Total: 50.137us, non-child: 50.137us, % non-child: 100.00%) - BytesSent: 84.00 B (84) - NetworkThroughput(*): 222.01 KB/sec - OverallThroughput: 1.60 MB/sec - PeakMemoryUsage: 4.00 KB (4096) - SerializeBatchTime: 17.169us - ThriftTransmitTime(*): 369.495us - UncompressedRowBatchSize: 100.00 B (100) SORT_NODE (id=11):(Total: 20s567ms, non-child: 87.549us, % non-child: 0.00%) - PeakMemoryUsage: 12.00 KB (12288) - RowsReturned: 2 (2) - RowsReturnedRate: 0 AGGREGATION_NODE (id=20):(Total: 20s567ms, non-child: 212.24ms, % non-child: 1.03%) ExecOption: Codegen Enabled - BuildTime: 28.638us - GetNewBlockTime: 117.216us - GetResultsTime: 6.28us - HashBuckets: 2.05K (2048) - LargestPartitionPercent: 5 (5) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 32 (32) - PeakMemoryUsage: 6.29 MB (6594560) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 2 (2) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) - UnpinTime: 3.89us EXCHANGE_NODE (id=19):(Total: 20s355ms, non-child: 203.404us, % non-child: 0.00%) BytesReceived(500.0ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - BytesReceived: 630.00 B (630) - ConvertRowBatchTime: 27.887us - DeserializeRowBatchTimer: 82.986us - FirstBatchArrivalWaitTime: 20s098ms - PeakMemoryUsage: 0 - RowsReturned: 20 (20) - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 75449469b5ff32b7:f5c96092b94d248d (host=e1318.halxg.cloudera.com:22000):(Total: 20s563ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB ThreadUsage(500.0ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 6.27 MB (6578176) - PerHostPeakMemUsage: 111.12 MB (116516336) - PrepareTime: 215.779ms - RowsProduced: 0 (0) - TotalCpuTime: 490.136ms - TotalNetworkReceiveTime: 20s345ms - TotalNetworkSendTime: 365ns - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 310 (310) - BlocksRecycled: 50 (50) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 40.24 GB (43209306112) - PeakMemoryUsage: 513.89 KB (526224) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 484.75ms, non-child: 484.75ms, % non-child: 100.00%) - CodegenTime: 2.813ms - CompileTime: 30.516ms - LoadTime: 134.124us - ModuleFileSize: 1.96 MB (2056856) - OptimizationTime: 241.41ms - PrepareTime: 210.746ms DataStreamSender (dst_id=21):(Total: 19.23us, non-child: 19.23us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 4.00 KB (4096) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 SORT_NODE (id=11):(Total: 20s562ms, non-child: 55.905us, % non-child: 0.00%) - PeakMemoryUsage: 12.00 KB (12288) - RowsReturned: 0 (0) - RowsReturnedRate: 0 AGGREGATION_NODE (id=20):(Total: 20s562ms, non-child: 216.537ms, % non-child: 1.05%) ExecOption: Codegen Enabled - BuildTime: 5.43us - GetNewBlockTime: 108.814us - GetResultsTime: 0ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 32 (32) - PeakMemoryUsage: 6.26 MB (6561792) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 0 (0) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) - UnpinTime: 2.937us EXCHANGE_NODE (id=19):(Total: 20s345ms, non-child: 8.765us, % non-child: 0.00%) BytesReceived(500.0ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 1.340us - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 20s345ms - PeakMemoryUsage: 0 - RowsReturned: 0 (0) - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 75449469b5ff32b7:f5c96092b94d2490 (host=e1220.halxg.cloudera.com:22000):(Total: 20s556ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 0, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.29 MB ThreadUsage(500.0ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 6.30 MB (6606848) - PerHostPeakMemUsage: 113.89 MB (119419336) - PrepareTime: 214.917ms - RowsProduced: 1 (1) - TotalCpuTime: 495.707ms - TotalNetworkReceiveTime: 20s340ms - TotalNetworkSendTime: 268.282us - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 310 (310) - BlocksRecycled: 50 (50) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 40.24 GB (43209306112) - PeakMemoryUsage: 513.89 KB (526224) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 489.819ms, non-child: 489.819ms, % non-child: 100.00%) - CodegenTime: 2.809ms - CompileTime: 37.549ms - LoadTime: 387.47us - ModuleFileSize: 1.96 MB (2056856) - OptimizationTime: 240.665ms - PrepareTime: 209.96ms DataStreamSender (dst_id=21):(Total: 40.367us, non-child: 40.367us, % non-child: 100.00%) - BytesSent: 47.00 B (47) - NetworkThroughput(*): 217.13 KB/sec - OverallThroughput: 1.11 MB/sec - PeakMemoryUsage: 4.00 KB (4096) - SerializeBatchTime: 6.569us - ThriftTransmitTime(*): 211.389us - UncompressedRowBatchSize: 53.00 B (53) SORT_NODE (id=11):(Total: 20s555ms, non-child: 64.409us, % non-child: 0.00%) - PeakMemoryUsage: 12.00 KB (12288) - RowsReturned: 1 (1) - RowsReturnedRate: 0 AGGREGATION_NODE (id=20):(Total: 20s555ms, non-child: 215.525ms, % non-child: 1.05%) ExecOption: Codegen Enabled - BuildTime: 30.163us - GetNewBlockTime: 129.577us - GetResultsTime: 1.997us - HashBuckets: 1.02K (1024) - LargestPartitionPercent: 10 (10) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 32 (32) - PeakMemoryUsage: 6.28 MB (6582272) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 1 (1) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) - UnpinTime: 2.544us EXCHANGE_NODE (id=19):(Total: 20s340ms, non-child: 196.446us, % non-child: 0.00%) BytesReceived(500.0ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 245.00 B - BytesReceived: 350.00 B (350) - ConvertRowBatchTime: 47.621us - DeserializeRowBatchTimer: 99.970us - FirstBatchArrivalWaitTime: 20s083ms - PeakMemoryUsage: 0 - RowsReturned: 10 (10) - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 75449469b5ff32b7:f5c96092b94d248f (host=e1120.halxg.cloudera.com:22000):(Total: 20s548ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 0, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.29 MB ThreadUsage(500.0ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 6.30 MB (6610944) - PerHostPeakMemUsage: 122.99 MB (128963968) - PrepareTime: 210.669ms - RowsProduced: 2 (2) - TotalCpuTime: 501.463ms - TotalNetworkReceiveTime: 20s335ms - TotalNetworkSendTime: 252.843us - TotalStorageWaitTime: 0ns CodeGen:(Total: 495.92ms, non-child: 495.92ms, % non-child: 100.00%) - CodegenTime: 2.847ms - CompileTime: 38.250ms - LoadTime: 112.173us - ModuleFileSize: 1.96 MB (2056856) - OptimizationTime: 249.484ms - PrepareTime: 205.684ms DataStreamSender (dst_id=21):(Total: 48.496us, non-child: 48.496us, % non-child: 100.00%) - BytesSent: 78.00 B (78) - NetworkThroughput(*): 372.56 KB/sec - OverallThroughput: 1.53 MB/sec - PeakMemoryUsage: 4.00 KB (4096) - SerializeBatchTime: 17.158us - ThriftTransmitTime(*): 204.455us - UncompressedRowBatchSize: 100.00 B (100) SORT_NODE (id=11):(Total: 20s547ms, non-child: 94.691us, % non-child: 0.00%) - PeakMemoryUsage: 12.00 KB (12288) - RowsReturned: 2 (2) - RowsReturnedRate: 0 AGGREGATION_NODE (id=20):(Total: 20s547ms, non-child: 211.605ms, % non-child: 1.03%) ExecOption: Codegen Enabled - BuildTime: 104.930us - GetNewBlockTime: 124.372us - GetResultsTime: 4.113us - HashBuckets: 1.02K (1024) - LargestPartitionPercent: 10 (10) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 32 (32) - PeakMemoryUsage: 6.28 MB (6586368) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 2 (2) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) - UnpinTime: 2.583us EXCHANGE_NODE (id=19):(Total: 20s335ms, non-child: 201.197us, % non-child: 0.00%) BytesReceived(500.0ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 126.00 B - BytesReceived: 630.00 B (630) - ConvertRowBatchTime: 25.190us - DeserializeRowBatchTimer: 74.792us - FirstBatchArrivalWaitTime: 20s078ms - PeakMemoryUsage: 0 - RowsReturned: 20 (20) - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 75449469b5ff32b7:f5c96092b94d248b (host=e1319.halxg.cloudera.com:22000):(Total: 20s548ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 0, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB ThreadUsage(500.0ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 6.27 MB (6578176) - PerHostPeakMemUsage: 110.17 MB (115522032) - PrepareTime: 215.265ms - RowsProduced: 0 (0) - TotalCpuTime: 503.622ms - TotalNetworkReceiveTime: 20s331ms - TotalNetworkSendTime: 354ns - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 310 (310) - BlocksRecycled: 50 (50) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 40.24 GB (43209306112) - PeakMemoryUsage: 513.89 KB (526224) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 497.355ms, non-child: 497.355ms, % non-child: 100.00%) - CodegenTime: 2.845ms - CompileTime: 38.87ms - LoadTime: 126.418us - ModuleFileSize: 1.96 MB (2056856) - OptimizationTime: 247.314ms - PrepareTime: 210.94ms DataStreamSender (dst_id=21):(Total: 18.720us, non-child: 18.720us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 4.00 KB (4096) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 SORT_NODE (id=11):(Total: 20s547ms, non-child: 62.571us, % non-child: 0.00%) - PeakMemoryUsage: 12.00 KB (12288) - RowsReturned: 0 (0) - RowsReturnedRate: 0 AGGREGATION_NODE (id=20):(Total: 20s547ms, non-child: 216.36ms, % non-child: 1.05%) ExecOption: Codegen Enabled - BuildTime: 4.718us - GetNewBlockTime: 117.957us - GetResultsTime: 0ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 32 (32) - PeakMemoryUsage: 6.26 MB (6561792) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 0 (0) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) - UnpinTime: 2.472us EXCHANGE_NODE (id=19):(Total: 20s331ms, non-child: 8.524us, % non-child: 0.00%) BytesReceived(500.0ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 1.67us - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 20s331ms - PeakMemoryUsage: 0 - RowsReturned: 0 (0) - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 75449469b5ff32b7:f5c96092b94d248e (host=e1218.halxg.cloudera.com:22000):(Total: 20s548ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 0, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB ThreadUsage(500.0ms): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 6.27 MB (6578176) - PerHostPeakMemUsage: 113.58 MB (119093464) - PrepareTime: 213.308ms - RowsProduced: 0 (0) - TotalCpuTime: 503.56ms - TotalNetworkReceiveTime: 20s332ms - TotalNetworkSendTime: 356ns - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 310 (310) - BlocksRecycled: 50 (50) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 40.24 GB (43209306112) - PeakMemoryUsage: 513.89 KB (526224) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 496.775ms, non-child: 496.775ms, % non-child: 100.00%) - CodegenTime: 2.797ms - CompileTime: 37.779ms - LoadTime: 122.458us - ModuleFileSize: 1.96 MB (2056856) - OptimizationTime: 248.956ms - PrepareTime: 208.253ms DataStreamSender (dst_id=21):(Total: 18.557us, non-child: 18.557us, % non-child: 100.00%) - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 4.00 KB (4096) - SerializeBatchTime: 0ns - ThriftTransmitTime(*): 0ns - UncompressedRowBatchSize: 0 SORT_NODE (id=11):(Total: 20s547ms, non-child: 61.661us, % non-child: 0.00%) - PeakMemoryUsage: 12.00 KB (12288) - RowsReturned: 0 (0) - RowsReturnedRate: 0 AGGREGATION_NODE (id=20):(Total: 20s547ms, non-child: 214.201ms, % non-child: 1.04%) ExecOption: Codegen Enabled - BuildTime: 4.815us - GetNewBlockTime: 113.185us - GetResultsTime: 0ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 32 (32) - PeakMemoryUsage: 6.26 MB (6561792) - PinTime: 0ns - RowsRepartitioned: 0 (0) - RowsReturned: 0 (0) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) - UnpinTime: 2.745us EXCHANGE_NODE (id=19):(Total: 20s332ms, non-child: 9.261us, % non-child: 0.00%) BytesReceived(500.0ms): 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 - BytesReceived: 0 - ConvertRowBatchTime: 1.310us - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 20s332ms - PeakMemoryUsage: 0 - RowsReturned: 0 (0) - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance 75449469b5ff32b7:f5c96092b94d2493 (host=e1219.halxg.cloudera.com:22000):(Total: 20s546ms, non-child: 0ns, % non-child: 0.00%) MemoryUsage(500.0ms): 0, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27 MB, 6.27