Query (id=5a402efcc9e56cd3:f36c23323c1b1180) Summary Session ID: c46abb6661d4ec7:77357b516f691cbf Session Type: HIVESERVER2 HiveServer2 Protocol Version: V6 Start Time: 2016-11-15 10:51:26.590780000 End Time: 2016-11-15 10:52:52.957993000 Query Type: QUERY Query State: EXCEPTION Query Status: Session expired due to inactivity Impala Version: impalad version 2.6.0-cdh5.8.3 RELEASE (build c644f476b774db9db87a619628f7a6ecc5f843e0) User: cloudera@HADOOP.COM Connected User: cloudera@HADOOP.COM Delegated User: Network Address: xxx.xxx.xxx.xxx:59653 Default Db: default Sql Statement: SELECT COUNT(*) AS `cnt` FROM `default`.`web_logs` `a` , `default`.`web_logs` `b` , `default`.`web_logs` `c` CROSS JOIN `default`.`web_logs` `d` Coordinator: impalad-host-1.cloudera.com:22000 Query Options (non default): Plan: ---------------- Estimated Per-Host Requirements: Memory=6.20GB VCores=4 WARNING: The following tables are missing relevant table and/or column statistics. default.web_logs 12:AGGREGATE [FINALIZE] | output: count:merge(*) | hosts=2 per-host-mem=unavailable | tuple-ids=4 row-size=8B cardinality=1 | 11:EXCHANGE [UNPARTITIONED] | hosts=2 per-host-mem=unavailable | tuple-ids=4 row-size=8B cardinality=1 | 07:AGGREGATE | output: count(*) | hosts=2 per-host-mem=10.00MB | tuple-ids=4 row-size=8B cardinality=1 | 06:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] | hosts=2 per-host-mem=2.00GB | tuple-ids=0,1,2,3 row-size=0B cardinality=unavailable | |--10:EXCHANGE [BROADCAST] | | hosts=2 per-host-mem=0B | | tuple-ids=3 row-size=0B cardinality=unavailable | | | 03:SCAN HDFS [default.web_logs d, RANDOM] | partitions=4/4 files=4 size=404.45KB | table stats: unavailable | column stats: all | hosts=2 per-host-mem=48.00MB | tuple-ids=3 row-size=0B cardinality=unavailable | 05:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] | hosts=2 per-host-mem=2.00GB | tuple-ids=0,1,2 row-size=0B cardinality=unavailable | |--09:EXCHANGE [BROADCAST] | | hosts=2 per-host-mem=0B | | tuple-ids=2 row-size=0B cardinality=unavailable | | | 02:SCAN HDFS [default.web_logs c, RANDOM] | partitions=4/4 files=4 size=404.45KB | table stats: unavailable | column stats: all | hosts=2 per-host-mem=48.00MB | tuple-ids=2 row-size=0B cardinality=unavailable | 04:NESTED LOOP JOIN [CROSS JOIN, BROADCAST] | hosts=2 per-host-mem=2.00GB | tuple-ids=0,1 row-size=0B cardinality=unavailable | |--08:EXCHANGE [BROADCAST] | | hosts=2 per-host-mem=0B | | tuple-ids=1 row-size=0B cardinality=unavailable | | | 01:SCAN HDFS [default.web_logs b, RANDOM] | partitions=4/4 files=4 size=404.45KB | table stats: unavailable | column stats: all | hosts=2 per-host-mem=48.00MB | tuple-ids=1 row-size=0B cardinality=unavailable | 00:SCAN HDFS [default.web_logs a, RANDOM] partitions=4/4 files=4 size=404.45KB table stats: unavailable column stats: all hosts=2 per-host-mem=48.00MB tuple-ids=0 row-size=0B cardinality=unavailable ---------------- Estimated Per-Host Mem: 6654263296 Estimated Per-Host VCores: 4 Tables Missing Stats: default.web_logs Request Pool: root.cloudera Admission result: Admitted immediately ExecSummary: Operator #Hosts Avg Time Max Time #Rows Est. #Rows Peak Mem Est. Peak Mem Detail ------------------------------------------------------------------------------------------------------------------------ 12:AGGREGATE 1 291.999ms 291.999ms 0 1 4.00 KB -1.00 B FINALIZE 11:EXCHANGE 1 1m25s 1m25s 0 1 0 -1.00 B UNPARTITIONED 07:AGGREGATE 2 0.000ns 0.000ns 0 1 36.00 KB 10.00 MB 06:NESTED LOOP JOIN 2 1m19s 1m19s 9.64B -1 32.00 KB 2.00 GB CROSS JOIN, BROADCAST |--10:EXCHANGE 2 0.000ns 0.000ns 1.00K -1 0 0 BROADCAST | 03:SCAN HDFS 2 356.499ms 395.999ms 1.00K -1 272.00 KB 48.00 MB default.web_logs d 05:NESTED LOOP JOIN 2 88.999ms 91.999ms 9.64M -1 24.00 KB 2.00 GB CROSS JOIN, BROADCAST |--09:EXCHANGE 2 0.000ns 0.000ns 1.00K -1 0 0 BROADCAST | 02:SCAN HDFS 2 341.499ms 378.999ms 1.00K -1 272.00 KB 48.00 MB default.web_logs c 04:NESTED LOOP JOIN 2 1.499ms 1.999ms 13.95K -1 16.00 KB 2.00 GB CROSS JOIN, BROADCAST |--08:EXCHANGE 2 0.000ns 0.000ns 1.00K -1 0 0 BROADCAST | 01:SCAN HDFS 2 368.499ms 373.999ms 1.00K -1 272.00 KB 48.00 MB default.web_logs b 00:SCAN HDFS 2 6.999ms 7.999ms 500 -1 272.00 KB 48.00 MB default.web_logs a Planner Timeline Analysis finished: 5609570 Equivalence classes computed: 5831215 Single node plan created: 12090543 Runtime filters computed: 12154224 Distributed plan created: 13832001 Lineage info computed: 15131652 Planning finished: 23904126 Query Timeline Start execution: 0 Planning finished: 26999972 Submit for admission: 28999969 Completed admission: 28999969 Ready to start 8 remote fragments: 321999673 All 8 remote fragments started: 419999573 Cancelled: 86358912411 Rows available: 86365912404 Unregister query: 86366912403 ImpalaServer - ClientFetchWaitTimer: 0 - InactiveTotalTime: 0 - RowMaterializationTimer: 0 - TotalTime: 0 Execution Profile 5a402efcc9e56cd3:f36c23323c1b1180 Number of filters: 0 Filter routing table: ID Src. Node Tgt. Node(s) Targets Target type Partition filter Pending (Expected) First arrived Completed ------------------------------------------------------------------------------------------------------------------- Fragment start latencies: Count: 8, 25th %-ile: 1ms, 50th %-ile: 1ms, 75th %-ile: 3ms, 90th %-ile: 75ms, 95th %-ile: 96ms, 99.9th %-ile: 96ms Per Node Peak Memory Usage: impalad-host-2.cloudera.com:22000(1.12 MB) impalad-host-1.cloudera.com:22000(888.00 KB) - FiltersReceived: 0 - FinalizationTimer: 0 - InactiveTotalTime: 0 - TotalTime: 86331912439 Coordinator Fragment F04 - AverageThreadTokens: 1.0 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 12288 - PerHostPeakMemUsage: 0 - PrepareTime: 291999704 - RowsProduced: 0 - TotalCpuTime: 0 - TotalNetworkReceiveTime: 85809912970 - TotalNetworkSendTime: 0 - TotalStorageWaitTime: 0 - TotalTime: 86102912674 BlockMgr - BlockWritesOutstanding: 0 - BlocksCreated: 0 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - InactiveTotalTime: 0 - MaxBlockSize: 8388608 - MemoryLimit: 1105618560 - PeakMemoryUsage: 0 - TotalBufferWaitTime: 0 - TotalEncryptionTime: 0 - TotalIntegrityCheckTime: 0 - TotalReadBlockTime: 0 - TotalTime: 0 CodeGen - CodegenTime: 0 - CompileTime: 3999994 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2254648 - NumFunctions: 7 - NumInstructions: 96 - OptimizationTime: 113999885 - PrepareTime: 290999705 - TotalTime: 409999583 AGGREGATION_NODE (id=12) ExecOption: Codegen Enabled - BuildTime: 0 - GetResultsTime: 0 - HTResizeTime: 0 - HashBuckets: 0 - InactiveTotalTime: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 0 - PeakMemoryUsage: 4096 - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - TotalTime: 86101912674 EXCHANGE_NODE (id=11) - BytesReceived: 0 - ConvertRowBatchTime: 0 - DeserializeRowBatchTimer: 0 - FirstBatchArrivalWaitTime: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0 - SendersBlockedTotalTimer(*): 0 - TotalTime: 85809912970 Averaged Fragment F00 split sizes: min: 185.86 KB, max: 218.59 KB, avg: 202.23 KB, stddev: 16.37 KB completion times: min:1m26s max:1m26s mean: 1m26s stddev:999.999us execution rates: min:2.16 KB/sec max:2.54 KB/sec mean:2.35 KB/sec stddev:195.23 B/sec num instances: 2 - AverageThreadTokens: 1.0 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 380928 - PerHostPeakMemUsage: 1042336 - PrepareTime: 326499698 - RowsProduced: 0 - TotalCpuTime: 157499843 - TotalNetworkReceiveTime: 225999772 - TotalNetworkSendTime: 0 - TotalStorageWaitTime: 13999986 - TotalTime: 330999694 CodeGen - CodegenTime: 999999 - CompileTime: 11499990 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2254648 - NumFunctions: 9 - NumInstructions: 144 - OptimizationTime: 93499915 - PrepareTime: 323999701 - TotalTime: 429999604 DataStreamSender (dst_id=11) - BytesSent: 0 - InactiveTotalTime: 0 - NetworkThroughput(*): 0 - OverallThroughput: 0 - PeakMemoryUsage: 16384 - RowsReturned: 0 - SerializeBatchTime: 0 - TotalTime: 0 - TransmitDataRPCTime: 0 - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=7) - BuildTime: 2190497903 - GetResultsTime: 0 - HTResizeTime: 0 - HashBuckets: 0 - InactiveTotalTime: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 0 - PeakMemoryUsage: 36864 - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - TotalTime: 326499698 NESTED_LOOP_JOIN_NODE (id=6) - BuildRows: 1000 - BuildTime: 0 - InactiveTotalTime: 0 - LocalTime: 79406925759 - PeakMemoryUsage: 32768 - ProbeRows: 1024 - ProbeTime: 0 - RowsReturned: 4819854084 - RowsReturnedRate: 60569890 - TotalTime: 79614925559 EXCHANGE_NODE (id=10) - BytesReceived: 4016 - ConvertRowBatchTime: 0 - DeserializeRowBatchTimer: 499999 - FirstBatchArrivalWaitTime: 5499994 - InactiveTotalTime: 0 - PeakMemoryUsage: 0 - RowsReturned: 1000 - RowsReturnedRate: 75493 - SendersBlockedTimer: 0 - SendersBlockedTotalTimer(*): 0 - TotalTime: 64999932 NESTED_LOOP_JOIN_NODE (id=5) - BuildRows: 1000 - BuildTime: 0 - InactiveTotalTime: 0 - LocalTime: 88999915 - PeakMemoryUsage: 24576 - ProbeRows: 1024 - ProbeTime: 0 - RowsReturned: 4821952 - RowsReturnedRate: 26949264 - TotalTime: 207999799 EXCHANGE_NODE (id=9) - BytesReceived: 4016 - ConvertRowBatchTime: 0 - DeserializeRowBatchTimer: 0 - FirstBatchArrivalWaitTime: 18499981 - InactiveTotalTime: 0 - PeakMemoryUsage: 0 - RowsReturned: 1000 - RowsReturnedRate: 4950 - SendersBlockedTimer: 0 - SendersBlockedTotalTimer(*): 0 - TotalTime: 50499949 NESTED_LOOP_JOIN_NODE (id=4) - BuildRows: 1000 - BuildTime: 0 - InactiveTotalTime: 0 - LocalTime: 1499998 - PeakMemoryUsage: 16384 - ProbeRows: 250 - ProbeTime: 0 - RowsReturned: 6976 - RowsReturnedRate: 81174 - TotalTime: 118999884 EXCHANGE_NODE (id=8) - BytesReceived: 4016 - ConvertRowBatchTime: 0 - DeserializeRowBatchTimer: 500000 - FirstBatchArrivalWaitTime: 72999926 - InactiveTotalTime: 0 - PeakMemoryUsage: 0 - RowsReturned: 1000 - RowsReturnedRate: 12573 - SendersBlockedTimer: 0 - SendersBlockedTotalTimer(*): 0 - TotalTime: 110499891 HDFS_SCAN_NODE (id=0) - AverageHdfsReadThreadConcurrency: 0.0 - AverageScannerThreadConcurrency: 0.0 - BytesRead: 207078 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 0 - NumScannerThreadsStarted: 2 - PeakMemoryUsage: 278528 - PerReadThreadRawHdfsThroughput: 0 - RemoteScanRanges: 0 - RowsRead: 498 - RowsReturned: 250 - RowsReturnedRate: 36458 - ScanRangesComplete: 2 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 15999984 - DelimiterParseTime: 999999 - MaterializeTupleTime(*): 0 - ScannerThreadsSysTime: 0 - ScannerThreadsUserTime: 0 - ScannerThreadsVoluntaryContextSwitches: 7 - TotalRawHdfsReadTime(*): 0 - TotalReadThroughput: 2511 - TotalTime: 6999994 Averaged Fragment F03 split sizes: min: 185.86 KB, max: 218.59 KB, avg: 202.23 KB, stddev: 16.37 KB completion times: min:400.999ms max:505.999ms mean: 453.499ms stddev:52.499ms execution rates: min:432.00 KB/sec max:463.49 KB/sec mean:447.74 KB/sec stddev:15.75 KB/sec num instances: 2 - AverageThreadTokens: 1.0 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 483328 - PerHostPeakMemUsage: 1042336 - PrepareTime: 301499721 - RowsProduced: 500 - TotalCpuTime: 497999538 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 0 - TotalStorageWaitTime: 52999950 - TotalTime: 363999660 CodeGen - CodegenTime: 0 - CompileTime: 6999994 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2254648 - NumFunctions: 6 - NumInstructions: 71 - OptimizationTime: 80999926 - PrepareTime: 300499722 - TotalTime: 389499641 DataStreamSender (dst_id=10) - BytesSent: 4016 - InactiveTotalTime: 0 - NetworkThroughput(*): 0 - OverallThroughput: 0 - PeakMemoryUsage: 262144 - RowsReturned: 500 - SerializeBatchTime: 0 - TotalTime: 0 - TransmitDataRPCTime: 0 - UncompressedRowBatchSize: 4016 HDFS_SCAN_NODE (id=3) - AverageHdfsReadThreadConcurrency: 0.0 - AverageScannerThreadConcurrency: 0.0 - BytesRead: 207078 - BytesReadDataNodeCache: 0 - BytesReadLocal: 207078 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 207078 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 2 - PeakMemoryUsage: 212992 - PerReadThreadRawHdfsThroughput: 47580047 - RemoteScanRanges: 0 - RowsRead: 498 - RowsReturned: 500 - RowsReturnedRate: 1419 - ScanRangesComplete: 2 - ScannerThreadsInvoluntaryContextSwitches: 2 - ScannerThreadsTotalWallClockTime: 98499907 - DelimiterParseTime: 0 - MaterializeTupleTime(*): 0 - ScannerThreadsSysTime: 0 - ScannerThreadsUserTime: 0 - ScannerThreadsVoluntaryContextSwitches: 8 - TotalRawHdfsReadTime(*): 999999 - TotalReadThroughput: 0 - TotalTime: 356499668 Averaged Fragment F02 split sizes: min: 185.86 KB, max: 218.59 KB, avg: 202.23 KB, stddev: 16.37 KB completion times: min:424.999ms max:483.999ms mean: 454.499ms stddev:29.499ms execution rates: min:437.32 KB/sec max:451.63 KB/sec mean:444.48 KB/sec stddev:7.16 KB/sec num instances: 2 - AverageThreadTokens: 1.0 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 548864 - PerHostPeakMemUsage: 1042336 - PrepareTime: 309999711 - RowsProduced: 500 - TotalCpuTime: 457499574 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 499999 - TotalStorageWaitTime: 51499955 - TotalTime: 345499679 CodeGen - CodegenTime: 0 - CompileTime: 6999993 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2254648 - NumFunctions: 6 - NumInstructions: 71 - OptimizationTime: 96499909 - PrepareTime: 308999712 - TotalTime: 413499614 DataStreamSender (dst_id=9) - BytesSent: 4016 - InactiveTotalTime: 0 - NetworkThroughput(*): 2007997 - OverallThroughput: 2007997 - PeakMemoryUsage: 262144 - RowsReturned: 500 - SerializeBatchTime: 0 - TotalTime: 500000 - TransmitDataRPCTime: 500000 - UncompressedRowBatchSize: 4016 HDFS_SCAN_NODE (id=2) - AverageHdfsReadThreadConcurrency: 0.0 - AverageScannerThreadConcurrency: 0.0 - BytesRead: 207078 - BytesReadDataNodeCache: 0 - BytesReadLocal: 207078 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 207078 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 2 - PeakMemoryUsage: 278528 - PerReadThreadRawHdfsThroughput: 0 - RemoteScanRanges: 0 - RowsRead: 498 - RowsReturned: 500 - RowsReturnedRate: 1481 - ScanRangesComplete: 2 - ScannerThreadsInvoluntaryContextSwitches: 1 - ScannerThreadsTotalWallClockTime: 55999950 - DelimiterParseTime: 0 - MaterializeTupleTime(*): 0 - ScannerThreadsSysTime: 0 - ScannerThreadsUserTime: 0 - ScannerThreadsVoluntaryContextSwitches: 6 - TotalRawHdfsReadTime(*): 0 - TotalReadThroughput: 0 - TotalTime: 341499683 BlockMgr - BlockWritesOutstanding: 0 - BlocksCreated: 0 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - InactiveTotalTime: 0 - MaxBlockSize: 8388608 - MemoryLimit: 1105618560 - PeakMemoryUsage: 0 - TotalBufferWaitTime: 0 - TotalEncryptionTime: 0 - TotalIntegrityCheckTime: 0 - TotalReadBlockTime: 0 - TotalTime: 0 Averaged Fragment F01 split sizes: min: 185.86 KB, max: 218.59 KB, avg: 202.23 KB, stddev: 16.37 KB completion times: min:423.999ms max:477.999ms mean: 450.999ms stddev:26.999ms execution rates: min:438.35 KB/sec max:457.30 KB/sec mean:447.83 KB/sec stddev:9.48 KB/sec num instances: 2 - AverageThreadTokens: 1.0 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 548864 - PerHostPeakMemUsage: 1042336 - PrepareTime: 358499665 - RowsProduced: 500 - TotalCpuTime: 451999580 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 499999 - TotalStorageWaitTime: 12499986 - TotalTime: 368999655 CodeGen - CodegenTime: 500000 - CompileTime: 5999996 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2254648 - NumFunctions: 6 - NumInstructions: 71 - OptimizationTime: 73999932 - PrepareTime: 356499667 - TotalTime: 437499594 DataStreamSender (dst_id=8) - BytesSent: 4016 - InactiveTotalTime: 0 - NetworkThroughput(*): 2008000000000 - OverallThroughput: 2008000000000 - PeakMemoryUsage: 262144 - RowsReturned: 500 - SerializeBatchTime: 0 - TotalTime: 0 - TransmitDataRPCTime: 0 - UncompressedRowBatchSize: 4016 HDFS_SCAN_NODE (id=1) - AverageHdfsReadThreadConcurrency: 0.0 - AverageScannerThreadConcurrency: 0.0 - BytesRead: 207078 - BytesReadDataNodeCache: 0 - BytesReadLocal: 207078 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 207078 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 2 - PeakMemoryUsage: 278528 - PerReadThreadRawHdfsThroughput: 95160111918611 - RemoteScanRanges: 0 - RowsRead: 498 - RowsReturned: 500 - RowsReturnedRate: 1356 - ScanRangesComplete: 2 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 14499984 - DelimiterParseTime: 0 - MaterializeTupleTime(*): 0 - ScannerThreadsSysTime: 0 - ScannerThreadsUserTime: 0 - ScannerThreadsVoluntaryContextSwitches: 6 - TotalRawHdfsReadTime(*): 500000 - TotalReadThroughput: 0 - TotalTime: 368499654 Fragment F00 Instance 5a402efcc9e56cd3:f36c23323c1b1183 (host=impalad-host-2.cloudera.com:22000) Hdfs split stats (:<# splits>/): 0:2/218.59 KB - AverageThreadTokens: 1.0 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 380928 - PerHostPeakMemUsage: 1175360 - PrepareTime: 359999692 - RowsProduced: 0 - TotalCpuTime: 76999929 - TotalNetworkReceiveTime: 58999946 - TotalNetworkSendTime: 0 - TotalStorageWaitTime: 13999987 - TotalTime: 368999684 CodeGen - CodegenTime: 999999 - CompileTime: 11999992 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2254648 - NumFunctions: 9 - NumInstructions: 144 - OptimizationTime: 114999902 - PrepareTime: 357999695 - TotalTime: 485999587 DataStreamSender (dst_id=11) - BytesSent: 0 - InactiveTotalTime: 0 - NetworkThroughput(*): 0 - OverallThroughput: 0 - PeakMemoryUsage: 16384 - RowsReturned: 0 - SerializeBatchTime: 0 - TotalTime: 0 - TransmitDataRPCTime: 0 - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=7) ExecOption: Codegen Enabled - BuildTime: 1871998331 - GetResultsTime: 0 - HTResizeTime: 0 - HashBuckets: 0 - InactiveTotalTime: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 0 - PeakMemoryUsage: 36864 - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - TotalTime: 359999692 NESTED_LOOP_JOIN_NODE (id=6) ExecOption: Join Build-Side Prepared Asynchronously - BuildRows: 1000 - BuildTime: 0 - InactiveTotalTime: 0 - LocalTime: 79293932201 - PeakMemoryUsage: 32768 - ProbeRows: 1024 - ProbeTime: 0 - RowsReturned: 5920023976 - RowsReturnedRate: 74520140 - TotalTime: 79441932067 EXCHANGE_NODE (id=10) - BytesReceived: 4016 - ConvertRowBatchTime: 0 - DeserializeRowBatchTimer: 999998 - FirstBatchArrivalWaitTime: 0 - InactiveTotalTime: 6999990 - PeakMemoryUsage: 0 - RowsReturned: 1000 - RowsReturnedRate: 142857 - SendersBlockedTimer: 0 - SendersBlockedTotalTimer(*): 0 - TotalTime: 6999990 NESTED_LOOP_JOIN_NODE (id=5) ExecOption: Join Build-Side Prepared Asynchronously - BuildRows: 1000 - BuildTime: 0 - InactiveTotalTime: 0 - LocalTime: 85999921 - PeakMemoryUsage: 24576 - ProbeRows: 1024 - ProbeTime: 0 - RowsReturned: 5921096 - RowsReturnedRate: 40007441 - TotalTime: 147999866 EXCHANGE_NODE (id=9) - BytesReceived: 4016 - ConvertRowBatchTime: 0 - DeserializeRowBatchTimer: 0 - FirstBatchArrivalWaitTime: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 0 - RowsReturned: 1000 - RowsReturnedRate: 0 - SendersBlockedTimer: 0 - SendersBlockedTotalTimer(*): 0 - TotalTime: 0 NESTED_LOOP_JOIN_NODE (id=4) ExecOption: Join Build-Side Prepared Asynchronously - BuildRows: 1000 - BuildTime: 0 - InactiveTotalTime: 0 - LocalTime: 1999997 - PeakMemoryUsage: 16384 - ProbeRows: 250 - ProbeTime: 0 - RowsReturned: 7952 - RowsReturnedRate: 128258 - TotalTime: 61999945 EXCHANGE_NODE (id=8) - BytesReceived: 4016 - ConvertRowBatchTime: 0 - DeserializeRowBatchTimer: 1000000 - FirstBatchArrivalWaitTime: 14999986 - InactiveTotalTime: 51999956 - PeakMemoryUsage: 0 - RowsReturned: 1000 - RowsReturnedRate: 19230 - SendersBlockedTimer: 0 - SendersBlockedTotalTimer(*): 0 - TotalTime: 51999956 HDFS_SCAN_NODE (id=0) ExecOption: Expr Evaluation Codegen Disabled Hdfs split stats (:<# splits>/): 0:2/218.59 KB - AverageHdfsReadThreadConcurrency: 0.0 - AverageScannerThreadConcurrency: 0.0 - BytesRead: 223837 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 0 - NumScannerThreadsStarted: 2 - PeakMemoryUsage: 278528 - PerReadThreadRawHdfsThroughput: 0 - RemoteScanRanges: 0 - RowsRead: 498 - RowsReturned: 250 - RowsReturnedRate: 31250 - ScanRangesComplete: 2 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 17999983 - DelimiterParseTime: 1999998 - MaterializeTupleTime(*): 0 - ScannerThreadsSysTime: 0 - ScannerThreadsUserTime: 0 - ScannerThreadsVoluntaryContextSwitches: 6 - TotalRawHdfsReadTime(*): 0 - TotalReadThroughput: 2729 - TotalTime: 7999992 Instance 5a402efcc9e56cd3:f36c23323c1b1182 (host=impalad-host-1.cloudera.com:22000) Hdfs split stats (:<# splits>/): 0:2/185.86 KB - AverageThreadTokens: 1.0 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 380928 - PerHostPeakMemUsage: 909312 - PrepareTime: 292999704 - RowsProduced: 0 - TotalCpuTime: 237999758 - TotalNetworkReceiveTime: 392999599 - TotalNetworkSendTime: 0 - TotalStorageWaitTime: 13999986 - TotalTime: 292999704 CodeGen - CodegenTime: 1000000 - CompileTime: 10999988 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2254648 - NumFunctions: 9 - NumInstructions: 144 - OptimizationTime: 71999929 - PrepareTime: 289999707 - TotalTime: 373999622 DataStreamSender (dst_id=11) - BytesSent: 0 - InactiveTotalTime: 0 - NetworkThroughput(*): 0 - OverallThroughput: 0 - PeakMemoryUsage: 16384 - RowsReturned: 0 - SerializeBatchTime: 0 - TotalTime: 0 - TransmitDataRPCTime: 0 - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=7) ExecOption: Codegen Enabled - BuildTime: 2508997475 - GetResultsTime: 0 - HTResizeTime: 0 - HashBuckets: 0 - InactiveTotalTime: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 0 - PeakMemoryUsage: 36864 - RowsRepartitioned: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - TotalTime: 292999704 NESTED_LOOP_JOIN_NODE (id=6) ExecOption: Join Build-Side Prepared Asynchronously - BuildRows: 1000 - BuildTime: 0 - InactiveTotalTime: 0 - LocalTime: 79519919318 - PeakMemoryUsage: 32768 - ProbeRows: 1024 - ProbeTime: 0 - RowsReturned: 3719684192 - RowsReturnedRate: 46619641 - TotalTime: 79787919051 EXCHANGE_NODE (id=10) - BytesReceived: 4016 - ConvertRowBatchTime: 0 - DeserializeRowBatchTimer: 0 - FirstBatchArrivalWaitTime: 10999988 - InactiveTotalTime: 122999874 - PeakMemoryUsage: 0 - RowsReturned: 1000 - RowsReturnedRate: 8130 - SendersBlockedTimer: 0 - SendersBlockedTotalTimer(*): 0 - TotalTime: 122999874 NESTED_LOOP_JOIN_NODE (id=5) ExecOption: Join Build-Side Prepared Asynchronously - BuildRows: 1000 - BuildTime: 0 - InactiveTotalTime: 0 - LocalTime: 91999909 - PeakMemoryUsage: 24576 - ProbeRows: 1024 - ProbeTime: 0 - RowsReturned: 3722808 - RowsReturnedRate: 13891088 - TotalTime: 267999733 EXCHANGE_NODE (id=9) - BytesReceived: 4016 - ConvertRowBatchTime: 0 - DeserializeRowBatchTimer: 0 - FirstBatchArrivalWaitTime: 36999962 - InactiveTotalTime: 100999898 - PeakMemoryUsage: 0 - RowsReturned: 1000 - RowsReturnedRate: 9901 - SendersBlockedTimer: 0 - SendersBlockedTotalTimer(*): 0 - TotalTime: 100999898 NESTED_LOOP_JOIN_NODE (id=4) - BuildRows: 1000 - BuildTime: 0 - InactiveTotalTime: 0 - LocalTime: 1000000 - PeakMemoryUsage: 16384 - ProbeRows: 250 - ProbeTime: 0 - RowsReturned: 6000 - RowsReturnedRate: 34090 - TotalTime: 175999824 EXCHANGE_NODE (id=8) - BytesReceived: 4016 - ConvertRowBatchTime: 0 - DeserializeRowBatchTimer: 0 - FirstBatchArrivalWaitTime: 130999867 - InactiveTotalTime: 168999827 - PeakMemoryUsage: 0 - RowsReturned: 1000 - RowsReturnedRate: 5917 - SendersBlockedTimer: 0 - SendersBlockedTotalTimer(*): 0 - TotalTime: 168999827 HDFS_SCAN_NODE (id=0) ExecOption: Expr Evaluation Codegen Disabled Hdfs split stats (:<# splits>/): 0:2/185.86 KB - AverageHdfsReadThreadConcurrency: 0.0 - AverageScannerThreadConcurrency: 0.0 - BytesRead: 190320 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 0 - NumScannerThreadsStarted: 2 - PeakMemoryUsage: 278528 - PerReadThreadRawHdfsThroughput: 0 - RemoteScanRanges: 0 - RowsRead: 498 - RowsReturned: 250 - RowsReturnedRate: 41666 - ScanRangesComplete: 2 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 13999986 - DelimiterParseTime: 0 - MaterializeTupleTime(*): 0 - ScannerThreadsSysTime: 0 - ScannerThreadsUserTime: 0 - ScannerThreadsVoluntaryContextSwitches: 8 - TotalRawHdfsReadTime(*): 0 - TotalReadThroughput: 2293 - TotalTime: 5999997 Fragment F03 Instance 5a402efcc9e56cd3:f36c23323c1b1185 (host=impalad-host-2.cloudera.com:22000) Hdfs split stats (:<# splits>/): 0:2/218.59 KB - AverageThreadTokens: 1.0 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 417792 - PerHostPeakMemUsage: 1175360 - PrepareTime: 331999715 - RowsProduced: 500 - TotalCpuTime: 591999488 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 0 - TotalStorageWaitTime: 25999982 - TotalTime: 397999656 CodeGen - CodegenTime: 0 - CompileTime: 6999995 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2254648 - NumFunctions: 6 - NumInstructions: 71 - OptimizationTime: 98999916 - PrepareTime: 330999715 - TotalTime: 437999626 DataStreamSender (dst_id=10) - BytesSent: 4016 - InactiveTotalTime: 0 - NetworkThroughput(*): 0 - OverallThroughput: 0 - PeakMemoryUsage: 262144 - RowsReturned: 500 - SerializeBatchTime: 0 - TotalTime: 0 - TransmitDataRPCTime: 0 - UncompressedRowBatchSize: 4016 HDFS_SCAN_NODE (id=3) ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 2 out of 2 Hdfs split stats (:<# splits>/): 0:2/218.59 KB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% File Formats: TEXT/NONE:2 - AverageHdfsReadThreadConcurrency: 0.0 - AverageScannerThreadConcurrency: 0.0 - BytesRead: 223837 - BytesReadDataNodeCache: 0 - BytesReadLocal: 223837 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 223837 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 2 - PeakMemoryUsage: 147456 - PerReadThreadRawHdfsThroughput: 0 - RemoteScanRanges: 0 - RowsRead: 498 - RowsReturned: 500 - RowsReturnedRate: 1262 - ScanRangesComplete: 2 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 112999902 - DelimiterParseTime: 0 - MaterializeTupleTime(*): 0 - ScannerThreadsSysTime: 0 - ScannerThreadsUserTime: 0 - ScannerThreadsVoluntaryContextSwitches: 10 - TotalRawHdfsReadTime(*): 0 - TotalReadThroughput: 0 - TotalTime: 395999657 Instance 5a402efcc9e56cd3:f36c23323c1b1184 (host=impalad-host-1.cloudera.com:22000) Hdfs split stats (:<# splits>/): 0:2/185.86 KB - AverageThreadTokens: 1.0 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 548864 - PerHostPeakMemUsage: 909312 - PrepareTime: 270999728 - RowsProduced: 500 - TotalCpuTime: 403999588 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 0 - TotalStorageWaitTime: 79999918 - TotalTime: 329999665 CodeGen - CodegenTime: 0 - CompileTime: 6999993 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2254648 - NumFunctions: 6 - NumInstructions: 71 - OptimizationTime: 62999936 - PrepareTime: 269999729 - TotalTime: 340999657 DataStreamSender (dst_id=10) - BytesSent: 4016 - InactiveTotalTime: 0 - NetworkThroughput(*): 0 - OverallThroughput: 0 - PeakMemoryUsage: 262144 - RowsReturned: 500 - SerializeBatchTime: 0 - TotalTime: 0 - TransmitDataRPCTime: 0 - UncompressedRowBatchSize: 4016 HDFS_SCAN_NODE (id=3) ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 2 out of 2 Hdfs split stats (:<# splits>/): 0:2/185.86 KB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% File Formats: TEXT/NONE:2 - AverageHdfsReadThreadConcurrency: 0.0 - AverageScannerThreadConcurrency: 0.0 - BytesRead: 190320 - BytesReadDataNodeCache: 0 - BytesReadLocal: 190320 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 190320 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 2 - PeakMemoryUsage: 278528 - PerReadThreadRawHdfsThroughput: 95160095 - RemoteScanRanges: 0 - RowsRead: 498 - RowsReturned: 500 - RowsReturnedRate: 1577 - ScanRangesComplete: 2 - ScannerThreadsInvoluntaryContextSwitches: 5 - ScannerThreadsTotalWallClockTime: 83999912 - DelimiterParseTime: 0 - MaterializeTupleTime(*): 0 - ScannerThreadsSysTime: 0 - ScannerThreadsUserTime: 0 - ScannerThreadsVoluntaryContextSwitches: 7 - TotalRawHdfsReadTime(*): 1999998 - TotalReadThroughput: 0 - TotalTime: 316999680 Fragment F02 Instance 5a402efcc9e56cd3:f36c23323c1b1187 (host=impalad-host-2.cloudera.com:22000) Hdfs split stats (:<# splits>/): 0:2/218.59 KB - AverageThreadTokens: 1.0 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 548864 - PerHostPeakMemUsage: 1175360 - PrepareTime: 322999723 - RowsProduced: 500 - TotalCpuTime: 490999577 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 999998 - TotalStorageWaitTime: 90999922 - TotalTime: 383999669 BlockMgr - BlockWritesOutstanding: 0 - BlocksCreated: 0 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - InactiveTotalTime: 0 - MaxBlockSize: 8388608 - MemoryLimit: 1105618560 - PeakMemoryUsage: 0 - TotalBufferWaitTime: 0 - TotalEncryptionTime: 0 - TotalIntegrityCheckTime: 0 - TotalReadBlockTime: 0 - TotalTime: 0 CodeGen - CodegenTime: 0 - CompileTime: 7999993 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2254648 - NumFunctions: 6 - NumInstructions: 71 - OptimizationTime: 90999922 - PrepareTime: 321999724 - TotalTime: 421999638 DataStreamSender (dst_id=9) - BytesSent: 4016 - InactiveTotalTime: 0 - NetworkThroughput(*): 4015995 - OverallThroughput: 4015995 - PeakMemoryUsage: 262144 - RowsReturned: 500 - SerializeBatchTime: 0 - TotalTime: 1000001 - TransmitDataRPCTime: 1000001 - UncompressedRowBatchSize: 4016 HDFS_SCAN_NODE (id=2) ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 2 out of 2 Hdfs split stats (:<# splits>/): 0:2/218.59 KB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% File Formats: TEXT/NONE:2 - AverageHdfsReadThreadConcurrency: 0.0 - AverageScannerThreadConcurrency: 0.0 - BytesRead: 223837 - BytesReadDataNodeCache: 0 - BytesReadLocal: 223837 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 223837 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 2 - PeakMemoryUsage: 278528 - PerReadThreadRawHdfsThroughput: 0 - RemoteScanRanges: 0 - RowsRead: 498 - RowsReturned: 500 - RowsReturnedRate: 1319 - ScanRangesComplete: 2 - ScannerThreadsInvoluntaryContextSwitches: 3 - ScannerThreadsTotalWallClockTime: 99999913 - DelimiterParseTime: 0 - MaterializeTupleTime(*): 0 - ScannerThreadsSysTime: 0 - ScannerThreadsUserTime: 0 - ScannerThreadsVoluntaryContextSwitches: 6 - TotalRawHdfsReadTime(*): 0 - TotalReadThroughput: 0 - TotalTime: 378999674 Instance 5a402efcc9e56cd3:f36c23323c1b1186 (host=impalad-host-1.cloudera.com:22000) Hdfs split stats (:<# splits>/): 0:2/185.86 KB - AverageThreadTokens: 1.0 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 548864 - PerHostPeakMemUsage: 909312 - PrepareTime: 296999700 - RowsProduced: 500 - TotalCpuTime: 423999571 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 0 - TotalStorageWaitTime: 11999988 - TotalTime: 306999689 CodeGen - CodegenTime: 0 - CompileTime: 5999994 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2254648 - NumFunctions: 6 - NumInstructions: 71 - OptimizationTime: 101999897 - PrepareTime: 295999700 - TotalTime: 404999591 DataStreamSender (dst_id=9) - BytesSent: 4016 - InactiveTotalTime: 0 - NetworkThroughput(*): 0 - OverallThroughput: 0 - PeakMemoryUsage: 262144 - RowsReturned: 500 - SerializeBatchTime: 0 - TotalTime: 0 - TransmitDataRPCTime: 0 - UncompressedRowBatchSize: 4016 HDFS_SCAN_NODE (id=2) ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 2 out of 2 Hdfs split stats (:<# splits>/): 0:2/185.86 KB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% File Formats: TEXT/NONE:2 - AverageHdfsReadThreadConcurrency: 0.0 - AverageScannerThreadConcurrency: 0.0 - BytesRead: 190320 - BytesReadDataNodeCache: 0 - BytesReadLocal: 190320 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 190320 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 2 - PeakMemoryUsage: 278528 - PerReadThreadRawHdfsThroughput: 0 - RemoteScanRanges: 0 - RowsRead: 498 - RowsReturned: 500 - RowsReturnedRate: 1644 - ScanRangesComplete: 2 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 11999988 - DelimiterParseTime: 0 - MaterializeTupleTime(*): 0 - ScannerThreadsSysTime: 0 - ScannerThreadsUserTime: 0 - ScannerThreadsVoluntaryContextSwitches: 6 - TotalRawHdfsReadTime(*): 0 - TotalReadThroughput: 0 - TotalTime: 303999693 Fragment F01 Instance 5a402efcc9e56cd3:f36c23323c1b1189 (host=impalad-host-2.cloudera.com:22000) Hdfs split stats (:<# splits>/): 0:2/218.59 KB - AverageThreadTokens: 1.0 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 548864 - PerHostPeakMemUsage: 1175360 - PrepareTime: 362999690 - RowsProduced: 500 - TotalCpuTime: 479999591 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 0 - TotalStorageWaitTime: 14999986 - TotalTime: 373999682 CodeGen - CodegenTime: 1000000 - CompileTime: 6999995 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2254648 - NumFunctions: 6 - NumInstructions: 71 - OptimizationTime: 94999918 - PrepareTime: 360999691 - TotalTime: 463999603 DataStreamSender (dst_id=8) - BytesSent: 4016 - InactiveTotalTime: 0 - NetworkThroughput(*): 4016000000000 - OverallThroughput: 4016000000000 - PeakMemoryUsage: 262144 - RowsReturned: 500 - SerializeBatchTime: 0 - TotalTime: 1 - TransmitDataRPCTime: 1 - UncompressedRowBatchSize: 4016 HDFS_SCAN_NODE (id=1) ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 2 out of 2 Hdfs split stats (:<# splits>/): 0:2/218.59 KB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% File Formats: TEXT/NONE:2 - AverageHdfsReadThreadConcurrency: 0.0 - AverageScannerThreadConcurrency: 0.0 - BytesRead: 223837 - BytesReadDataNodeCache: 0 - BytesReadLocal: 223837 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 223837 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 2 - PeakMemoryUsage: 278528 - PerReadThreadRawHdfsThroughput: 223837223 - RemoteScanRanges: 0 - RowsRead: 498 - RowsReturned: 500 - RowsReturnedRate: 1336 - ScanRangesComplete: 2 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 16999984 - DelimiterParseTime: 0 - MaterializeTupleTime(*): 0 - ScannerThreadsSysTime: 0 - ScannerThreadsUserTime: 0 - ScannerThreadsVoluntaryContextSwitches: 6 - TotalRawHdfsReadTime(*): 999999 - TotalReadThroughput: 0 - TotalTime: 373999680 Instance 5a402efcc9e56cd3:f36c23323c1b1188 (host=impalad-host-1.cloudera.com:22000) Hdfs split stats (:<# splits>/): 0:2/185.86 KB - AverageThreadTokens: 1.0 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 548864 - PerHostPeakMemUsage: 909312 - PrepareTime: 353999641 - RowsProduced: 500 - TotalCpuTime: 423999569 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 999999 - TotalStorageWaitTime: 9999987 - TotalTime: 363999629 CodeGen - CodegenTime: 0 - CompileTime: 4999997 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2254648 - NumFunctions: 6 - NumInstructions: 71 - OptimizationTime: 52999946 - PrepareTime: 351999644 - TotalTime: 410999586 DataStreamSender (dst_id=8) - BytesSent: 4016 - InactiveTotalTime: 0 - NetworkThroughput(*): 0 - OverallThroughput: 0 - PeakMemoryUsage: 262144 - RowsReturned: 500 - SerializeBatchTime: 0 - TotalTime: 0 - TransmitDataRPCTime: 0 - UncompressedRowBatchSize: 4016 HDFS_SCAN_NODE (id=1) ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 2 out of 2 Hdfs split stats (:<# splits>/): 0:2/185.86 KB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% File Formats: TEXT/NONE:2 - AverageHdfsReadThreadConcurrency: 0.0 - AverageScannerThreadConcurrency: 0.0 - BytesRead: 190320 - BytesReadDataNodeCache: 0 - BytesReadLocal: 190320 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 190320 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 1 - NumScannerThreadsStarted: 2 - PeakMemoryUsage: 278528 - PerReadThreadRawHdfsThroughput: 190320000000000 - RemoteScanRanges: 0 - RowsRead: 498 - RowsReturned: 500 - RowsReturnedRate: 1377 - ScanRangesComplete: 2 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 11999984 - DelimiterParseTime: 0 - MaterializeTupleTime(*): 0 - ScannerThreadsSysTime: 0 - ScannerThreadsUserTime: 0 - ScannerThreadsVoluntaryContextSwitches: 7 - TotalRawHdfsReadTime(*): 1 - TotalReadThroughput: 0 - TotalTime: 362999629