Query (id=e14dcaddc926f92f:278d6a6effcbde81): Summary: Session ID: b14531643e1c320e:5130a87118df9084 Session Type: BEESWAX Start Time: 2015-01-21 23:57:54.240971000 End Time: Query Type: QUERY Query State: CREATED Query Status: OK Impala Version: impalad version 2.1.0-cdh5 RELEASE (build e48c2b48c53ea9601b8f47a39373aa83ff7ca6e2) User: jenkins Connected User: jenkins Delegated User: Network Address: 10.20.128.120:60999 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: e1221.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: 11s243ms - Start execution: 45.682us (45.682us) - Planning finished: 64.890ms (64.844ms) - Ready to start remote fragments: 67.809ms (2.919ms) - Remote fragments started: 1s425ms (1s358ms) - Rows available: 11s205ms (9s779ms) - First row fetched: 11s239ms (33.596ms) ImpalaServer: - ClientFetchWaitTimer: 34.189ms - RowMaterializationTimer: 54.373us Execution Profile e14dcaddc926f92f:278d6a6effcbde81:(Total: 11s141ms, non-child: 0ns, % non-child: 0.00%) Fragment start latencies: count: 34, last: 0.00463413, min: 0.0026356, max: 0.366176, mean: 0.170875, stddev: 0.0975145 Per Node Peak Memory Usage: e1319.halxg.cloudera.com:22000(107.53 MB) e1219.halxg.cloudera.com:22000(1005.21 MB) e1118.halxg.cloudera.com:22000(996.38 MB) e1119.halxg.cloudera.com:22000(116.99 MB) e1120.halxg.cloudera.com:22000(122.98 MB) e1218.halxg.cloudera.com:22000(113.57 MB) e1318.halxg.cloudera.com:22000(101.72 MB) e1121.halxg.cloudera.com:22000(107.52 MB) e1220.halxg.cloudera.com:22000(104.40 MB) e1221.halxg.cloudera.com:22000(116.87 MB) - FinalizationTimer: 0ns Coordinator Fragment F08:(Total: 9s779ms, non-child: 556.608us, % non-child: 0.01%) MemoryUsage(500.0ms): 0, 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, 1 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 32.00 KB (32768) - PerHostPeakMemUsage: 0 - PrepareTime: 45.758us - RowsProduced: 9 - TotalCpuTime: 11s172ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 0ns - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 310 - BlocksRecycled: 50 - BufferedPins: 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: 9s778ms, non-child: 104.110us, % 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 - BytesReceived: 356.00 B (356) - ConvertRowBatchTime: 0ns - DeserializeRowBatchTimer: 24.388us - FirstBatchArrivalWaitTime: 9s778ms - MergeGetNext: 21.646us - MergeGetNextBatch: 17.116us - PeakMemoryUsage: 0 - RowsReturned: 9 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Averaged Fragment F07:(Total: 10s858ms, non-child: 0ns, % non-child: 0.00%) split sizes: min: 0, max: 0, avg: 0, stddev: 0 completion times: min:10s767ms max:10s925ms mean: 10s898ms stddev:47.81ms 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 (6600704) - PerHostPeakMemUsage: 289.32 MB (303371588) - PrepareTime: 230.634ms - RowsProduced: 0 - TotalCpuTime: 503.160ms - TotalNetworkReceiveTime: 10s626ms - TotalNetworkSendTime: 286.202us - TotalStorageWaitTime: 0ns CodeGen:(Total: 497.312ms, non-child: 497.312ms, % non-child: 100.00%) - CodegenTime: 2.886ms - CompileTime: 35.556ms - LoadTime: 100.923us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 234.491ms - PrepareTime: 225.521ms DataStreamSender (dst_id=21):(Total: 44.757us, non-child: 44.757us, % non-child: 100.00%) - BytesSent: 37.00 B (37) - NetworkThroughput(*): 216.95 KB/sec - OverallThroughput: 768.50 KB/sec - PeakMemoryUsage: 4.00 KB (4096) - SerializeBatchTime: 12.275us - ThriftTransmitTime(*): 193.817us - UncompressedRowBatchSize: 47.00 B (47) SORT_NODE (id=11):(Total: 10s857ms, non-child: 66.625us, % non-child: 0.00%) - PeakMemoryUsage: 12.00 KB (12288) - RowsReturned: 0 - RowsReturnedRate: 0 AGGREGATION_NODE (id=20):(Total: 10s857ms, non-child: 231.337ms, % non-child: 2.13%) - BuildTime: 14.346us - GetNewBlockTime: 129.63us - GetResultsTime: 2.163us - HashBuckets: 819 - LargestPartitionPercent: 3 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 6.28 MB (6581862) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 2.185us EXCHANGE_NODE (id=19):(Total: 10s626ms, non-child: 10s626ms, % non-child: 100.00%) - BytesReceived: 284.00 B (284) - ConvertRowBatchTime: 14.409us - DeserializeRowBatchTimer: 39.569us - FirstBatchArrivalWaitTime: 10s421ms - PeakMemoryUsage: 0 - RowsReturned: 9 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 395 - BlocksRecycled: 85 - BufferedPins: 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: 10s164ms, non-child: 0ns, % non-child: 0.00%) split sizes: min: 544.88 MB, max: 606.98 MB, avg: 580.50 MB, stddev: 26.59 MB completion times: min:10s159ms max:10s562ms mean: 10s397ms stddev:135.997ms execution rates: min:52.35 MB/sec max:58.91 MB/sec mean:55.83 MB/sec stddev:2.33 MB/sec num instances: 10 - AverageThreadTokens: 10.01 - PeakMemoryUsage: 103.50 MB (108526509) - PerHostPeakMemUsage: 289.32 MB (303371588) - PrepareTime: 204.210ms - RowsProduced: 9 - TotalCpuTime: 1m36s - TotalNetworkReceiveTime: 8s894ms - TotalNetworkSendTime: 1.422ms - TotalStorageWaitTime: 198.227ms CodeGen:(Total: 624.23ms, non-child: 624.23ms, % non-child: 100.00%) - CodegenTime: 2.405ms - CompileTime: 107.374ms - LoadTime: 78.917us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 324.960ms - PrepareTime: 190.61ms DataStreamSender (dst_id=19):(Total: 45.916us, non-child: 45.916us, % non-child: 100.00%) - BytesSent: 284.00 B (284) - NetworkThroughput(*): 248.10 KB/sec - OverallThroughput: 6.19 MB/sec - PeakMemoryUsage: 40.00 KB (40960) - SerializeBatchTime: 64.407us - ThriftTransmitTime(*): 1.127ms - UncompressedRowBatchSize: 452.00 B (452) AGGREGATION_NODE (id=10):(Total: 10s161ms, non-child: 435.739ms, % non-child: 4.29%) - BuildTime: 234.918ms - GetNewBlockTime: 121.509us - GetResultsTime: 9.785us - HashBuckets: 8.19K (8192) - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 6.91 MB (7248433) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 9 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 2.34us HASH_JOIN_NODE (id=9):(Total: 9s725ms, non-child: 204.497ms, % non-child: 2.10%) - BuildPartitionTime: 17.2us - BuildRows: 21 - BuildRowsPartitioned: 21 - BuildTime: 17.675us - GetNewBlockTime: 311.942us - HashBuckets: 44 - LargestPartitionPercent: 19 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 4.03 MB (4227072) - PinTime: 0ns - ProbeRows: 12.23M (12234548) - ProbeRowsPartitioned: 0 - ProbeTime: 529.324ms - RowsReturned: 4.41M (4405739) - RowsReturnedRate: 452.95 K/sec - SpilledPartitions: 0 - UnpinTime: 3.166us EXCHANGE_NODE (id=18):(Total: 8s547ms, non-child: 8s547ms, % non-child: 100.00%) - BytesReceived: 511.00 B (511) - ConvertRowBatchTime: 4.296us - DeserializeRowBatchTimer: 24.734us - FirstBatchArrivalWaitTime: 8s544ms - PeakMemoryUsage: 0 - RowsReturned: 21 - RowsReturnedRate: 2.00 /sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns HASH_JOIN_NODE (id=8):(Total: 974.181ms, non-child: 555.254ms, % non-child: 57.00%) - BuildPartitionTime: 25.599us - BuildRows: 98 - BuildRowsPartitioned: 98 - BuildTime: 35.732us - GetNewBlockTime: 208.369us - HashBuckets: 198 - LargestPartitionPercent: 4 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 5.09 MB (5334576) - PinTime: 0ns - ProbeRows: 12.53M (12529812) - ProbeRowsPartitioned: 0 - ProbeTime: 526.921ms - RowsReturned: 12.23M (12234548) - RowsReturnedRate: 12.60 M/sec - SpilledPartitions: 0 - UnpinTime: 2.924us EXCHANGE_NODE (id=12):(Total: 347.393ms, non-child: 347.393ms, % non-child: 100.00%) - BytesReceived: 2.55 KB (2614) - ConvertRowBatchTime: 4.643us - DeserializeRowBatchTimer: 23.565us - FirstBatchArrivalWaitTime: 346.241ms - PeakMemoryUsage: 0 - RowsReturned: 98 - RowsReturnedRate: 289.00 /sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns HDFS_SCAN_NODE (id=0):(Total: 71.532ms, non-child: 71.532ms, % non-child: 100.00%) - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 8.70 - BytesRead: 56.97 MB (59737624) - BytesReadDataNodeCache: 0 - BytesReadLocal: 56.97 MB (59737624) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 56.97 MB (59737624) - DecompressionTime: 40.895ms - MaxCompressedTextFileLength: 0 - NumColumns: 0 - NumDisksAccessed: 6 - NumScannerThreadsStarted: 9 - PeakMemoryUsage: 90.65 MB (95058248) - PerReadThreadRawHdfsThroughput: 1.24 GB/sec - RemoteScanRanges: 0 - RowsRead: 12.53M (12529812) - RowsReturned: 12.53M (12529812) - RowsReturnedRate: 177.66 M/sec - ScanRangesComplete: 9 - ScannerThreadsInvoluntaryContextSwitches: 892 - ScannerThreadsTotalWallClockTime: 1m25s - MaterializeTupleTime(*): 1m24s - ScannerThreadsSysTime: 1s035ms - ScannerThreadsUserTime: 2s129ms - ScannerThreadsVoluntaryContextSwitches: 31.76K (31756) - TotalRawHdfsReadTime(*): 46.756ms - TotalReadThroughput: 5.45 MB/sec Averaged Fragment F06:(Total: 8s501ms, non-child: 0ns, % non-child: 0.00%) split sizes: min: 0, max: 0, avg: 0, stddev: 0 completion times: min:8s714ms max:8s745ms mean: 8s730ms stddev:15.659ms execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec num instances: 2 - AverageThreadTokens: 1.11 - PeakMemoryUsage: 10.31 MB (10813440) - PerHostPeakMemUsage: 1000.80 MB (1049411452) - PrepareTime: 206.50ms - RowsProduced: 10 - TotalCpuTime: 1s070ms - TotalNetworkReceiveTime: 9s357ms - TotalNetworkSendTime: 263.92us - TotalStorageWaitTime: 0ns CodeGen:(Total: 630.438ms, non-child: 630.438ms, % non-child: 100.00%) - CodegenTime: 2.341ms - CompileTime: 123.930ms - LoadTime: 72.730us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 308.470ms - PrepareTime: 196.511ms DataStreamSender (dst_id=18):(Total: 361.262us, non-child: 361.262us, % non-child: 100.00%) - BytesSent: 2.53 KB (2595) - NetworkThroughput(*): 390.80 KB/sec - OverallThroughput: 8.84 MB/sec - PeakMemoryUsage: 40.00 KB (40960) - SerializeBatchTime: 20.680us - ThriftTransmitTime(*): 6.790ms - UncompressedRowBatchSize: 4.28 KB (4385) HASH_JOIN_NODE (id=7):(Total: 8s502ms, non-child: 0ns, % non-child: 0.00%) - BuildPartitionTime: 267.247us - BuildRows: 2.00K (2003) - BuildRowsPartitioned: 2.00K (2003) - BuildTime: 209.825us - GetNewBlockTime: 127.458us - HashBuckets: 5.82K (5824) - LargestPartitionPercent: 4 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 6.07 MB (6362624) - PinTime: 0ns - ProbeRows: 7.15K (7148) - ProbeRowsPartitioned: 0 - ProbeTime: 820.216us - RowsReturned: 10 - RowsReturnedRate: 1.00 /sec - SpilledPartitions: 0 - UnpinTime: 2.919us AGGREGATION_NODE (id=16):(Total: 1s072ms, non-child: 5.480ms, % non-child: 0.51%) - BuildTime: 1.195ms - GetNewBlockTime: 199.102us - GetResultsTime: 440.165us - HashBuckets: 32.77K (32768) - LargestPartitionPercent: 2 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 6.32 MB (6629308) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 2.00K (2003) - RowsReturnedRate: 1.87 K/sec - SpilledPartitions: 0 - UnpinTime: 1.912us EXCHANGE_NODE (id=15):(Total: 1s066ms, non-child: 1s066ms, % non-child: 100.00%) - BytesReceived: 123.36 KB (126319) - ConvertRowBatchTime: 226.565us - DeserializeRowBatchTimer: 529.854us - FirstBatchArrivalWaitTime: 960.910ms - PeakMemoryUsage: 0 - RowsReturned: 7.14K (7145) - RowsReturnedRate: 6.71 K/sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns EXCHANGE_NODE (id=17):(Total: 8s291ms, non-child: 8s291ms, % non-child: 100.00%) - BytesReceived: 112.35 KB (115051) - ConvertRowBatchTime: 242.349us - DeserializeRowBatchTimer: 547.843us - FirstBatchArrivalWaitTime: 2s623ms - PeakMemoryUsage: 0 - RowsReturned: 7.15K (7148) - RowsReturnedRate: 862.00 /sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Averaged Fragment F05:(Total: 1s015ms, non-child: 0ns, % non-child: 0.00%) split sizes: min: 0, max: 0, avg: 0, stddev: 0 completion times: min:1s202ms max:1s266ms mean: 1s234ms stddev:31.897ms execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec num instances: 2 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 868.40 MB (910586840) - PerHostPeakMemUsage: 1000.80 MB (1049411452) - PrepareTime: 196.960ms - RowsProduced: 7.14K (7145) - TotalCpuTime: 1s637ms - TotalNetworkReceiveTime: 30.357ms - TotalNetworkSendTime: 591.933us - TotalStorageWaitTime: 0ns CodeGen:(Total: 603.773ms, non-child: 603.773ms, % non-child: 100.00%) - CodegenTime: 2.175ms - CompileTime: 68.830ms - LoadTime: 60.897us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 345.319ms - PrepareTime: 187.982ms DataStreamSender (dst_id=15):(Total: 2.346ms, non-child: 2.346ms, % non-child: 100.00%) - BytesSent: 123.36 KB (126319) - NetworkThroughput(*): 37.18 MB/sec - OverallThroughput: 51.36 MB/sec - PeakMemoryUsage: 56.00 KB (57344) - SerializeBatchTime: 1.111ms - ThriftTransmitTime(*): 3.355ms - UncompressedRowBatchSize: 286.13 KB (293000) AGGREGATION_NODE (id=5):(Total: 1s012ms, non-child: 313.888ms, % non-child: 31.00%) - BuildTime: 117.32ms - GetNewBlockTime: 209.493us - GetResultsTime: 491.358us - HashBuckets: 32.77K (32768) - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 6.39 MB (6697928) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 7.14K (7145) - RowsReturnedRate: 7.09 K/sec - SpilledPartitions: 0 - UnpinTime: 1.800us HASH_JOIN_NODE (id=4):(Total: 698.500ms, non-child: 612.637ms, % non-child: 87.71%) - BuildPartitionTime: 85.36ms - BuildRows: 1.09M (1087587) - BuildRowsPartitioned: 1.09M (1087587) - BuildTime: 77.209ms - GetNewBlockTime: 681.425us - HashBuckets: 4.19M (4194304) - LargestPartitionPercent: 3 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 838.02 MB (878731264) - PinTime: 0ns - ProbeRows: 1.15M (1150000) - ProbeRowsPartitioned: 0 - ProbeTime: 403.15ms - RowsReturned: 1.09M (1087587) - RowsReturnedRate: 1.57 M/sec - SpilledPartitions: 0 - UnpinTime: 2.86us EXCHANGE_NODE (id=14):(Total: 37.292ms, non-child: 37.292ms, % non-child: 100.00%) - BytesReceived: 15.90 MB (16675967) - ConvertRowBatchTime: 21.710ms - DeserializeRowBatchTimer: 69.861ms - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 1.09M (1087587) - RowsReturnedRate: 29.28 M/sec - SendersBlockedTimer: 284.712ms - SendersBlockedTotalTimer(*): 1s422ms EXCHANGE_NODE (id=13):(Total: 48.569ms, non-child: 48.569ms, % non-child: 100.00%) - BytesReceived: 20.43 MB (21425601) - ConvertRowBatchTime: 26.424ms - DeserializeRowBatchTimer: 89.374ms - FirstBatchArrivalWaitTime: 0ns - PeakMemoryUsage: 0 - RowsReturned: 1.15M (1150000) - RowsReturnedRate: 24.59 M/sec - SendersBlockedTimer: 493.984ms - SendersBlockedTotalTimer(*): 957.305ms Averaged Fragment F04:(Total: 441.502ms, non-child: 3.123ms, % non-child: 0.71%) split sizes: min: 32.03 MB, max: 51.90 MB, avg: 47.67 MB, stddev: 7.82 MB completion times: min:399.379ms max:456.645ms mean: 441.698ms stddev:21.323ms execution rates: min:80.19 MB/sec max:115.28 MB/sec mean:107.28 MB/sec stddev:13.57 MB/sec num instances: 5 - AverageThreadTokens: 2.00 - PeakMemoryUsage: 9.49 MB (9952616) - PerHostPeakMemUsage: 130.52 MB (136862544) - PrepareTime: 158.863us - RowsProduced: 435.03K (435034) - TotalCpuTime: 479.755ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 305.885ms - TotalStorageWaitTime: 9.489ms DataStreamSender (dst_id=14):(Total: 422.375ms, non-child: 422.375ms, % non-child: 100.00%) - BytesSent: 6.36 MB (6670386) - NetworkThroughput(*): 8.70 MB/sec - OverallThroughput: 14.99 MB/sec - PeakMemoryUsage: 74.59 KB (76384) - SerializeBatchTime: 46.7ms - ThriftTransmitTime(*): 728.778ms - UncompressedRowBatchSize: 12.03 MB (12618564) HDFS_SCAN_NODE (id=3):(Total: 16.4ms, non-child: 16.4ms, % 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.571ms - MaxCompressedTextFileLength: 0 - NumColumns: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 9.35 MB (9800310) - PerReadThreadRawHdfsThroughput: 1.14 GB/sec - RemoteScanRanges: 0 - RowsRead: 920.00K (920000) - RowsReturned: 435.03K (435034) - RowsReturnedRate: 29.01 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 14 - ScannerThreadsTotalWallClockTime: 351.59ms - MaterializeTupleTime(*): 338.391ms - ScannerThreadsSysTime: 1.199ms - ScannerThreadsUserTime: 123.380ms - ScannerThreadsVoluntaryContextSwitches: 10 - TotalRawHdfsReadTime(*): 3.396ms - TotalReadThroughput: 7.91 MB/sec Averaged Fragment F03:(Total: 960.236ms, non-child: 3.340ms, % non-child: 0.35%) split sizes: min: 20.13 MB, max: 22.54 MB, avg: 21.34 MB, stddev: 1.21 MB completion times: min:954.207ms max:976.144ms mean: 965.175ms stddev:10.968ms execution rates: min:20.62 MB/sec max:23.63 MB/sec mean:22.12 MB/sec stddev:1.50 MB/sec num instances: 2 - AverageThreadTokens: 2.00 - PeakMemoryUsage: 17.70 MB (18560984) - PerHostPeakMemUsage: 1000.80 MB (1049411452) - PrepareTime: 55.23us - RowsProduced: 1.15M (1150000) - TotalCpuTime: 1s264ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 592.936ms - TotalStorageWaitTime: 6.438ms DataStreamSender (dst_id=13):(Total: 941.692ms, non-child: 941.692ms, % non-child: 100.00%) - BytesSent: 20.43 MB (21425601) - NetworkThroughput(*): 15.04 MB/sec - OverallThroughput: 21.70 MB/sec - PeakMemoryUsage: 56.00 KB (57344) - SerializeBatchTime: 178.556ms - ThriftTransmitTime(*): 1s359ms - UncompressedRowBatchSize: 44.81 MB (46984575) HDFS_SCAN_NODE (id=2):(Total: 15.203ms, non-child: 15.203ms, % 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.468ms - MaxCompressedTextFileLength: 0 - NumColumns: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 17.60 MB (18454488) - PerReadThreadRawHdfsThroughput: 1.83 GB/sec - RemoteScanRanges: 0 - RowsRead: 1.15M (1150000) - RowsReturned: 1.15M (1150000) - RowsReturnedRate: 76.54 M/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 57 - ScannerThreadsTotalWallClockTime: 899.553ms - MaterializeTupleTime(*): 867.567ms - ScannerThreadsSysTime: 999.500us - ScannerThreadsUserTime: 136.979ms - ScannerThreadsVoluntaryContextSwitches: 950 - TotalRawHdfsReadTime(*): 3.439ms - TotalReadThroughput: 6.44 MB/sec Averaged Fragment F02:(Total: 7s485ms, non-child: 0ns, % non-child: 0.00%) split sizes: min: 20.13 MB, max: 22.54 MB, avg: 21.34 MB, stddev: 1.21 MB completion times: min:7s175ms max:8s209ms mean: 7s692ms stddev:517.156ms execution rates: min:2.75 MB/sec max:2.80 MB/sec mean:2.78 MB/sec stddev:30.16 KB/sec num instances: 2 - AverageThreadTokens: 1.90 - PeakMemoryUsage: 2.62 MB (2743456) - PerHostPeakMemUsage: 1000.80 MB (1049411452) - PrepareTime: 254.210ms - RowsProduced: 7.15K (7148) - TotalCpuTime: 15s173ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 982.458us - TotalStorageWaitTime: 2.943ms CodeGen:(Total: 687.246ms, non-child: 687.246ms, % non-child: 100.00%) - CodegenTime: 0ns - CompileTime: 126.242ms - LoadTime: 106.429us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 333.272ms - PrepareTime: 225.451ms DataStreamSender (dst_id=17):(Total: 2.12ms, non-child: 2.12ms, % non-child: 100.00%) - BytesSent: 112.35 KB (115051) - NetworkThroughput(*): 27.19 MB/sec - OverallThroughput: 54.47 MB/sec - PeakMemoryUsage: 74.59 KB (76384) - SerializeBatchTime: 965.27us - ThriftTransmitTime(*): 4.33ms - UncompressedRowBatchSize: 230.42 KB (235946) HDFS_SCAN_NODE (id=6):(Total: 7s723ms, non-child: 7s723ms, % 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: 654.253us - MaxCompressedTextFileLength: 0 - NumColumns: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 2.54 MB (2658880) - PerReadThreadRawHdfsThroughput: 2.08 GB/sec - RemoteScanRanges: 0 - RowsRead: 1.15M (1150000) - RowsReturned: 7.15K (7148) - RowsReturnedRate: 926.00 /sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 734 - ScannerThreadsTotalWallClockTime: 7s229ms - MaterializeTupleTime(*): 7s224ms - ScannerThreadsSysTime: 0ns - ScannerThreadsUserTime: 7s216ms - ScannerThreadsVoluntaryContextSwitches: 4 - TotalRawHdfsReadTime(*): 902.255us - TotalReadThroughput: 254.25 KB/sec Averaged Fragment F01:(Total: 7.426ms, non-child: 2.794ms, % non-child: 37.63%) split sizes: min: 15.12 KB, max: 15.12 KB, avg: 15.12 KB, stddev: 0 completion times: min:7.303ms max:7.303ms mean: 7.303ms stddev:0ns execution rates: min:2.02 MB/sec max:2.02 MB/sec mean:2.02 MB/sec stddev:0.00 /sec num instances: 1 - AverageThreadTokens: 0.00 - PeakMemoryUsage: 139.00 KB (142336) - PerHostPeakMemUsage: 102.05 MB (107010840) - PrepareTime: 62.223us - RowsProduced: 98 - TotalCpuTime: 10.116ms - TotalNetworkReceiveTime: 0ns - TotalNetworkSendTime: 556.436us - TotalStorageWaitTime: 2.561ms DataStreamSender (dst_id=12):(Total: 951.587us, non-child: 951.587us, % non-child: 100.00%) - BytesSent: 25.57 KB (26180) - NetworkThroughput(*): 5.98 MB/sec - OverallThroughput: 26.24 MB/sec - PeakMemoryUsage: 40.00 KB (40960) - SerializeBatchTime: 54.521us - ThriftTransmitTime(*): 4.172ms - UncompressedRowBatchSize: 58.41 KB (59810) HDFS_SCAN_NODE (id=1):(Total: 3.680ms, non-child: 3.680ms, % 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: 6.855us - MaxCompressedTextFileLength: 0 - NumColumns: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 1 - PeakMemoryUsage: 91.00 KB (93184) - PerReadThreadRawHdfsThroughput: 576.88 MB/sec - RemoteScanRanges: 0 - RowsRead: 98 - RowsReturned: 98 - RowsReturnedRate: 26.62 K/sec - ScanRangesComplete: 1 - ScannerThreadsInvoluntaryContextSwitches: 1 - ScannerThreadsTotalWallClockTime: 3.472ms - MaterializeTupleTime(*): 22.86us - ScannerThreadsSysTime: 0ns - ScannerThreadsUserTime: 0ns - ScannerThreadsVoluntaryContextSwitches: 6 - TotalRawHdfsReadTime(*): 27.287us - TotalReadThroughput: 0.00 /sec Fragment F07: Instance e14dcaddc926f92f:278d6a6effcbde85 (host=e1220.halxg.cloudera.com:22000):(Total: 10s894ms, 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 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 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 6.27 MB (6578176) - PerHostPeakMemUsage: 104.40 MB (109472152) - PrepareTime: 212.965ms - RowsProduced: 0 - TotalCpuTime: 448.366ms - TotalNetworkReceiveTime: 10s680ms - TotalNetworkSendTime: 312.94us - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 310 - BlocksRecycled: 50 - BufferedPins: 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: 442.729ms, non-child: 442.729ms, % non-child: 100.00%) - CodegenTime: 2.766ms - CompileTime: 31.191ms - LoadTime: 95.382us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 201.806ms - PrepareTime: 207.958ms DataStreamSender (dst_id=21):(Total: 29.643us, non-child: 29.643us, % non-child: 100.00%) - BytesSent: 4.00 B (4) - NetworkThroughput(*): 16.06 KB/sec - OverallThroughput: 131.78 KB/sec - PeakMemoryUsage: 4.00 KB (4096) - SerializeBatchTime: 3.172us - ThriftTransmitTime(*): 243.264us - UncompressedRowBatchSize: 4.00 B (4) SORT_NODE (id=11):(Total: 10s893ms, non-child: 53.129us, % non-child: 0.00%) - PeakMemoryUsage: 12.00 KB (12288) - RowsReturned: 0 - RowsReturnedRate: 0 AGGREGATION_NODE (id=20):(Total: 10s893ms, non-child: 213.557ms, % non-child: 1.96%) ExecOption: Codegen Enabled - BuildTime: 3.264us - GetNewBlockTime: 113.413us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 6.26 MB (6561792) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 2.199us EXCHANGE_NODE (id=19):(Total: 10s680ms, non-child: 8.707us, % 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 - BytesReceived: 0 - ConvertRowBatchTime: 1.628us - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 10s680ms - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance e14dcaddc926f92f:278d6a6effcbde83 (host=e1121.halxg.cloudera.com:22000):(Total: 10s888ms, 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 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 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 6.27 MB (6578176) - PerHostPeakMemUsage: 107.52 MB (112747032) - PrepareTime: 211.521ms - RowsProduced: 0 - TotalCpuTime: 453.556ms - TotalNetworkReceiveTime: 10s674ms - TotalNetworkSendTime: 344.650us - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 310 - BlocksRecycled: 50 - BufferedPins: 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: 447.568ms, non-child: 447.568ms, % non-child: 100.00%) - CodegenTime: 2.820ms - CompileTime: 31.261ms - LoadTime: 109.509us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 208.59ms - PrepareTime: 206.625ms DataStreamSender (dst_id=21):(Total: 36.997us, non-child: 36.997us, % non-child: 100.00%) - BytesSent: 4.00 B (4) - NetworkThroughput(*): 17.16 KB/sec - OverallThroughput: 105.58 KB/sec - PeakMemoryUsage: 4.00 KB (4096) - SerializeBatchTime: 4.872us - ThriftTransmitTime(*): 227.694us - UncompressedRowBatchSize: 4.00 B (4) SORT_NODE (id=11):(Total: 10s887ms, non-child: 54.970us, % non-child: 0.00%) - PeakMemoryUsage: 12.00 KB (12288) - RowsReturned: 0 - RowsReturnedRate: 0 AGGREGATION_NODE (id=20):(Total: 10s887ms, non-child: 212.378ms, % non-child: 1.95%) ExecOption: Codegen Enabled - BuildTime: 4.562us - GetNewBlockTime: 107.498us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 6.26 MB (6561792) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 2.178us EXCHANGE_NODE (id=19):(Total: 10s674ms, non-child: 10.425us, % 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 - BytesReceived: 0 - ConvertRowBatchTime: 1.744us - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 10s674ms - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance e14dcaddc926f92f:278d6a6effcbde8c (host=e1319.halxg.cloudera.com:22000):(Total: 10s873ms, 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 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 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 6.27 MB (6578176) - PerHostPeakMemUsage: 107.53 MB (112749352) - PrepareTime: 206.306ms - RowsProduced: 0 - TotalCpuTime: 465.20ms - TotalNetworkReceiveTime: 10s665ms - TotalNetworkSendTime: 250.178us - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 310 - BlocksRecycled: 50 - BufferedPins: 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: 459.516ms, non-child: 459.516ms, % non-child: 100.00%) - CodegenTime: 2.758ms - CompileTime: 31.56ms - LoadTime: 109.671us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 225.336ms - PrepareTime: 201.441ms DataStreamSender (dst_id=21):(Total: 35.655us, non-child: 35.655us, % non-child: 100.00%) - BytesSent: 4.00 B (4) - NetworkThroughput(*): 22.89 KB/sec - OverallThroughput: 109.56 KB/sec - PeakMemoryUsage: 4.00 KB (4096) - SerializeBatchTime: 2.420us - ThriftTransmitTime(*): 170.624us - UncompressedRowBatchSize: 4.00 B (4) SORT_NODE (id=11):(Total: 10s872ms, non-child: 49.77us, % non-child: 0.00%) - PeakMemoryUsage: 12.00 KB (12288) - RowsReturned: 0 - RowsReturnedRate: 0 AGGREGATION_NODE (id=20):(Total: 10s872ms, non-child: 206.949ms, % non-child: 1.90%) ExecOption: Codegen Enabled - BuildTime: 3.595us - GetNewBlockTime: 103.284us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 6.26 MB (6561792) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 2.89us EXCHANGE_NODE (id=19):(Total: 10s665ms, non-child: 8.109us, % 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 - BytesReceived: 0 - ConvertRowBatchTime: 1.584us - DeserializeRowBatchTimer: 0ns - FirstBatchArrivalWaitTime: 10s665ms - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance e14dcaddc926f92f:278d6a6effcbde87 (host=e1218.halxg.cloudera.com:22000):(Total: 10s854ms, 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.31 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 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 6.32 MB (6623232) - PerHostPeakMemUsage: 113.57 MB (119090344) - PrepareTime: 209.219ms - RowsProduced: 2 - TotalCpuTime: 485.973ms - TotalNetworkReceiveTime: 10s643ms - TotalNetworkSendTime: 320.299us - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 310 - BlocksRecycled: 50 - BufferedPins: 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: 480.156ms, non-child: 480.156ms, % non-child: 100.00%) - CodegenTime: 2.833ms - CompileTime: 33.738ms - LoadTime: 118.625us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 240.457ms - PrepareTime: 204.263ms DataStreamSender (dst_id=21):(Total: 44.288us, non-child: 44.288us, % non-child: 100.00%) - BytesSent: 80.00 B (80) - NetworkThroughput(*): 328.12 KB/sec - OverallThroughput: 1.72 MB/sec - PeakMemoryUsage: 4.00 KB (4096) - SerializeBatchTime: 12.135us - ThriftTransmitTime(*): 238.97us - UncompressedRowBatchSize: 100.00 B (100) SORT_NODE (id=11):(Total: 10s853ms, non-child: 77.147us, % non-child: 0.00%) - PeakMemoryUsage: 12.00 KB (12288) - RowsReturned: 2 - RowsReturnedRate: 0 AGGREGATION_NODE (id=20):(Total: 10s853ms, non-child: 209.847ms, % non-child: 1.93%) ExecOption: Codegen Enabled - BuildTime: 21.756us - GetNewBlockTime: 101.909us - GetResultsTime: 3.536us - HashBuckets: 1.02K (1024) - LargestPartitionPercent: 10 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 6.29 MB (6598656) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 2 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 2.198us EXCHANGE_NODE (id=19):(Total: 10s643ms, non-child: 149.101us, % 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, 567.00 B - BytesReceived: 630.00 B (630) - ConvertRowBatchTime: 28.194us - DeserializeRowBatchTimer: 91.557us - FirstBatchArrivalWaitTime: 10s233ms - PeakMemoryUsage: 0 - RowsReturned: 20 - RowsReturnedRate: 1.00 /sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance e14dcaddc926f92f:278d6a6effcbde88 (host=e1120.halxg.cloudera.com:22000):(Total: 10s851ms, 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.31 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 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 6.32 MB (6623232) - PerHostPeakMemUsage: 122.98 MB (128950344) - PrepareTime: 209.41ms - RowsProduced: 1 - TotalCpuTime: 488.638ms - TotalNetworkReceiveTime: 10s640ms - TotalNetworkSendTime: 327.98us - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 310 - BlocksRecycled: 50 - BufferedPins: 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: 483.178ms, non-child: 483.178ms, % non-child: 100.00%) - CodegenTime: 2.703ms - CompileTime: 37.573ms - LoadTime: 119.762us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 239.677ms - PrepareTime: 204.270ms DataStreamSender (dst_id=21):(Total: 40.809us, non-child: 40.809us, % non-child: 100.00%) - BytesSent: 44.00 B (44) - NetworkThroughput(*): 174.74 KB/sec - OverallThroughput: 1.03 MB/sec - PeakMemoryUsage: 4.00 KB (4096) - SerializeBatchTime: 9.837us - ThriftTransmitTime(*): 245.897us - UncompressedRowBatchSize: 53.00 B (53) SORT_NODE (id=11):(Total: 10s850ms, non-child: 63.888us, % non-child: 0.00%) - PeakMemoryUsage: 12.00 KB (12288) - RowsReturned: 1 - RowsReturnedRate: 0 AGGREGATION_NODE (id=20):(Total: 10s850ms, non-child: 209.648ms, % non-child: 1.93%) ExecOption: Codegen Enabled - BuildTime: 13.944us - GetNewBlockTime: 101.309us - GetResultsTime: 2.721us - HashBuckets: 1.02K (1024) - LargestPartitionPercent: 10 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 6.30 MB (6602752) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 1 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 2.21us EXCHANGE_NODE (id=19):(Total: 10s641ms, non-child: 153.329us, % 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, 315.00 B - BytesReceived: 350.00 B (350) - ConvertRowBatchTime: 27.305us - DeserializeRowBatchTimer: 87.778us - FirstBatchArrivalWaitTime: 10s231ms - PeakMemoryUsage: 0 - RowsReturned: 10 - RowsReturnedRate: 0 - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance e14dcaddc926f92f:278d6a6effcbde8b (host=e1219.halxg.cloudera.com:22000):(Total: 10s851ms, 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 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 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 6.32 MB (6623232) - PerHostPeakMemUsage: 1005.21 MB (1054039288) - PrepareTime: 210.143ms - RowsProduced: 2 - TotalCpuTime: 491.466ms - TotalNetworkReceiveTime: 10s639ms - TotalNetworkSendTime: 242.723us - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 694 - BlocksRecycled: 210 - BufferedPins: 0 - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 40.24 GB (43209306112) - PeakMemoryUsage: 801.00 MB (839910960) - TotalBufferWaitTime: 0ns - TotalEncryptionTime: 0ns - TotalIntegrityCheckTime: 0ns - TotalReadBlockTime: 0ns CodeGen:(Total: 485.765ms, non-child: 485.765ms, % non-child: 100.00%) - CodegenTime: 2.763ms - CompileTime: 37.551ms - LoadTime: 113.678us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 241.313ms - PrepareTime: 205.171ms DataStreamSender (dst_id=21):(Total: 42.103us, non-child: 42.103us, % non-child: 100.00%) - BytesSent: 80.00 B (80) - NetworkThroughput(*): 774.53 KB/sec - OverallThroughput: 1.81 MB/sec - PeakMemoryUsage: 4.00 KB (4096) - SerializeBatchTime: 12.173us - ThriftTransmitTime(*): 100.867us - UncompressedRowBatchSize: 99.00 B (99) SORT_NODE (id=11):(Total: 10s850ms, non-child: 78.80us, % non-child: 0.00%) - PeakMemoryUsage: 12.00 KB (12288) - RowsReturned: 2 - RowsReturnedRate: 0 AGGREGATION_NODE (id=20):(Total: 10s850ms, non-child: 210.901ms, % non-child: 1.94%) ExecOption: Codegen Enabled - BuildTime: 33.411us - GetNewBlockTime: 111.265us - GetResultsTime: 4.876us - HashBuckets: 2.05K (2048) - LargestPartitionPercent: 5 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 32 - PeakMemoryUsage: 6.30 MB (6602752) - PinTime: 0ns - RowsRepartitioned: 0 - RowsReturned: 2 - RowsReturnedRate: 0 - SpilledPartitions: 0 - UnpinTime: 2.126us EXCHANGE_NODE (id=19):(Total: 10s639ms, non-child: 108.214us, % 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 - BytesReceived: 629.00 B (629) - ConvertRowBatchTime: 19.473us - DeserializeRowBatchTimer: 65.967us - FirstBatchArrivalWaitTime: 10s228ms - PeakMemoryUsage: 0 - RowsReturned: 20 - RowsReturnedRate: 1.00 /sec - SendersBlockedTimer: 0ns - SendersBlockedTotalTimer(*): 0ns Instance e14dcaddc926f92f:278d6a6effcbde86 (host=e1318.halxg.cloudera.com:22000):(Total: 10s847ms, 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 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 - AverageThreadTokens: 1.00 - PeakMemoryUsage: 6.27 MB (6578176) - PerHostPeakMemUsage: 101.72 MB (106657360) - PrepareTime: 204.24ms - RowsProduced: 0 - TotalCpuTime: 487.431ms - TotalNetworkReceiveTime: 10s642ms - TotalNetworkSendTime: 260.551us - TotalStorageWaitTime: 0ns BlockMgr: - BlockWritesOutstanding: 0 - BlocksCreated: 310 - BlocksRecycled: 50 - BufferedPins: 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: 482.266ms, non-child: 482.266ms, % non-child: 100.00%) - CodegenTime: 2.369ms - CompileTime: 37.869ms - LoadTime: 79.173us - ModuleFileSize: 1.96 MB (2054956) - OptimizationTime: 243.134ms - PrepareTime: 199.474ms DataStreamSender (dst_id=21):(Total: 31.74us, non-child: 31.74us, % non-child: 100.00%) - BytesSent: 4.00 B (4) - NetworkThroughput(*): 21.89 KB/sec - OverallThroughput: 125.71 KB/sec - PeakMemoryUsage: 4.00 KB (4096) - SerializeBatchTime: 3.719us - ThriftTransmitTime(*): 178.419us - UncompressedRowBatchSize: 4.00 B (4) SORT_NODE (id=11):(Total: 10s846ms, non-child: 50.770us, % non-child: 0.00%) - PeakMemoryUsage: 12.00 KB (12288) - RowsReturned: 0 - RowsReturnedRate: 0 AGGREGATION_NODE (id=20):(Total: 10s846ms, non-child: 204.735ms, % non-child: 1.89%) ExecOption: Codegen Enabled - BuildTime: 3.796us - GetNewBlockTime: 106.327us - GetResultsTime: 0ns - HashBuckets: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 3