Query (id=2741408ceb48bb8d:bc2055fdb6ed9fa0): Summary: Session ID: e5499476db360fb0:6fd0898bd868689c Session Type: BEESWAX Start Time: 2016-02-16 13:12:18.946772000 End Time: 2016-02-16 13:12:19.766698000 Query Type: QUERY Query State: FINISHED Query Status: OK Impala Version: impalad version 2.5.0-cdh5-INTERNAL RELEASE (build 6e414261d589ed73c58aad9dfe299288703b9730) User: mmokhtar Connected User: mmokhtar Delegated User: Network Address: 10.20.122.102:53271 Default Db: tpch_1000_decimal_parquet Sql Statement: select count(*) from nation n1, region where n1.n_regionkey = r_regionkey and r_name = 'AMERICA' Coordinator: d2402.halxg.cloudera.com:22000 Query Options (non default): EXPLAIN_LEVEL=2,NUM_SCANNER_THREADS=24,ENABLE_RUNTIME_FILTER_PROPAGATION=1,RUNTIME_FILTER_WAIT_TIME_MS=10000000 Plan: ---------------- Estimated Per-Host Requirements: Memory=32.00MB VCores=2 06:AGGREGATE [FINALIZE] | output: count:merge(*) | hosts=1 per-host-mem=unavailable | tuple-ids=2 row-size=8B cardinality=1 | 05:EXCHANGE [UNPARTITIONED] | hosts=1 per-host-mem=unavailable | tuple-ids=2 row-size=8B cardinality=1 | 03:AGGREGATE | output: count(*) | hosts=1 per-host-mem=10.00MB | tuple-ids=2 row-size=8B cardinality=1 | 02:HASH JOIN [INNER JOIN, BROADCAST] | hash predicates: n1.n_regionkey = r_regionkey | runtime filters: RF000 <- r_regionkey | hosts=1 per-host-mem=34B | tuple-ids=0,1 row-size=39B cardinality=5 | |--04:EXCHANGE [BROADCAST] | | hosts=1 per-host-mem=0B | | tuple-ids=1 row-size=31B cardinality=1 | | | 01:SCAN HDFS [tpch_1000_decimal_parquet.region, RANDOM] | partitions=1/1 files=1 size=910B | predicates: r_name = 'AMERICA' | table stats: 5 rows total | column stats: all | hosts=1 per-host-mem=32.00MB | tuple-ids=1 row-size=31B cardinality=1 | 00:SCAN HDFS [tpch_1000_decimal_parquet.nation n1, RANDOM] partitions=1/1 files=1 size=2.19KB runtime filters: RF000 -> n1.n_regionkey table stats: 25 rows total column stats: all hosts=1 per-host-mem=16.00MB tuple-ids=0 row-size=8B cardinality=25 ---------------- Estimated Per-Host Mem: 33554466 Estimated Per-Host VCores: 2 Request Pool: default-pool ExecSummary: Operator #Hosts Avg Time Max Time #Rows Est. #Rows Peak Mem Est. Peak Mem Detail --------------------------------------------------------------------------------------------------------------------------- 06:AGGREGATE 1 194.380ms 194.380ms 1 1 16.00 KB -1.00 B FINALIZE 05:EXCHANGE 1 39.432us 39.432us 1 1 0 -1.00 B UNPARTITIONED 03:AGGREGATE 1 185.255ms 185.255ms 1 1 44.00 KB 10.00 MB 02:HASH JOIN 1 12.790ms 12.790ms 5 5 2.02 MB 34.00 B INNER JOIN, BROADCAST |--04:EXCHANGE 1 9.718us 9.718us 1 1 0 0 BROADCAST | 01:SCAN HDFS 1 8.343ms 8.343ms 1 1 55.00 KB 32.00 MB tpch_1000_decimal_parquet.r... 00:SCAN HDFS 1 8.706ms 8.706ms 5 25 33.00 KB 16.00 MB tpch_1000_decimal_parquet.n... Planner Timeline: 16.717ms - Analysis finished: 2.855ms (2.855ms) - Equivalence classes computed: 3.254ms (399.157us) - Single node plan created: 6.740ms (3.486ms) - Runtime filters computed: 6.865ms (124.780us) - Distributed plan created: 8.915ms (2.049ms) - Lineage info computed: 9.559ms (644.664us) - Planning finished: 16.717ms (7.157ms) Query Timeline: 821.888ms - Start execution: 55.068us (55.068us) - Planning finished: 18.563ms (18.508ms) - Ready to start 2 remote fragments: 212.391ms (193.828ms) - All 2 remote fragments started: 213.706ms (1.314ms) - First dynamic filter received: 770.030ms (556.323ms) - Rows available: 778.931ms (8.901ms) - First row fetched: 817.642ms (38.710ms) - Unregister query: 819.943ms (2.300ms) ImpalaServer: - ClientFetchWaitTimer: 40.019ms - RowMaterializationTimer: 9.006us Execution Profile 2741408ceb48bb8d:bc2055fdb6ed9fa0:(Total: 760.813ms, non-child: 0.000ns, % non-child: 0.00%) Number of filters: 1 Filter routing table: ------ Filter routing table ------ id: 0 src: 2 dst: 0 num. destinations: 1 num. pending: 1 Fragment start latencies: Count: 2, 25th %-ile: 1ms, 50th %-ile: 1ms, 75th %-ile: 1ms, 90th %-ile: 1ms, 95th %-ile: 1ms, 99.9th %-ile: 1ms Final filter table: ------ Filter routing table ------ id: 0 src: 2 dst: 0 num. destinations: 1 num. pending: 0 Per Node Peak Memory Usage: d2409.halxg.cloudera.com:22000(67.00 KB) d2403.halxg.cloudera.com:22000(3.05 MB) d2402.halxg.cloudera.com:22000(0) - FiltersReceived: 1 (1) - FinalizationTimer: 0.000ns Coordinator Fragment F02:(Total: 477.847ms, non-child: 0.000ns, % non-child: 0.00%) MemoryUsage(500.000ms): 0, 12.00 KB ThreadUsage(500.000ms): 1 - AverageThreadTokens: 1.00 - BloomFilterBytes: 0 - PeakMemoryUsage: 24.01 KB (24584) - PerHostPeakMemUsage: 0 - PrepareTime: 192.935ms - RowsProduced: 1 (1) - TotalCpuTime: 515.861ms - TotalNetworkReceiveTime: 283.230ms - TotalNetworkSendTime: 0.000ns - TotalStorageWaitTime: 0.000ns BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 0 (0) - BlocksRecycled: 0 (0) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 242.23 GB (260091396096) - PeakMemoryUsage: 0 - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalIntegrityCheckTime: 0.000ns - TotalReadBlockTime: 0.000ns CodeGen:(Total: 471.770ms, non-child: 471.770ms, % non-child: 100.00%) - CodegenTime: 534.480us - CompileTime: 2.099ms - LoadTime: 0.000ns - ModuleBitcodeSize: 1.98 MB (2080424) - OptimizationTime: 277.260ms - PrepareTime: 190.539ms AGGREGATION_NODE (id=6):(Total: 477.617ms, non-child: 194.380ms, % non-child: 40.70%) ExecOption: Codegen Enabled - BuildTime: 1.102us - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 0 (0) - PeakMemoryUsage: 16.00 KB (16384) - RowsRepartitioned: 0 (0) - RowsReturned: 1 (1) - RowsReturnedRate: 2.00 /sec - SpilledPartitions: 0 (0) EXCHANGE_NODE (id=5):(Total: 283.237ms, non-child: 39.432us, % non-child: 0.01%) BytesReceived(500.000ms): 0 - BytesReceived: 16.00 B (16) - ConvertRowBatchTime: 1.456us - DeserializeRowBatchTimer: 7.402us - FirstBatchArrivalWaitTime: 283.059ms - PeakMemoryUsage: 0 - RowsReturned: 1 (1) - RowsReturnedRate: 3.00 /sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns Averaged Fragment F00:(Total: 207.492ms, non-child: 0.000ns, % non-child: 0.00%) split sizes: min: 2.19 KB, max: 2.19 KB, avg: 2.19 KB, stddev: 0 completion times: min:565.197ms max:565.197ms mean: 565.197ms stddev:0.000ns execution rates: min:3.87 KB/sec max:3.87 KB/sec mean:3.87 KB/sec stddev:0.00 /sec num instances: 1 - AverageThreadTokens: 1.00 - BloomFilterBytes: 2.00 MB (2097152) - PeakMemoryUsage: 2.05 MB (2146312) - PerHostPeakMemUsage: 3.05 MB (3194888) - PrepareTime: 186.558ms - RowsProduced: 1 (1) - TotalCpuTime: 574.300ms - TotalNetworkReceiveTime: 3.576us - TotalNetworkSendTime: 152.772us - TotalStorageWaitTime: 8.054ms BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 32 (32) - BlocksRecycled: 0 (0) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 242.23 GB (260091396096) - PeakMemoryUsage: 16.00 B (16) - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalIntegrityCheckTime: 0.000ns - TotalReadBlockTime: 0.000ns CodeGen:(Total: 538.979ms, non-child: 538.979ms, % non-child: 100.00%) - CodegenTime: 189.672us - CompileTime: 36.755ms - LoadTime: 0.000ns - ModuleBitcodeSize: 1.98 MB (2080424) - OptimizationTime: 318.496ms - PrepareTime: 181.899ms DataStreamSender (dst_id=5):(Total: 29.090us, non-child: 29.090us, % non-child: 100.00%) - BytesSent: 16.00 B (16) - NetworkThroughput(*): 119.80 KB/sec - OverallThroughput: 537.13 KB/sec - PeakMemoryUsage: 16.00 KB (16384) - SerializeBatchTime: 8.866us - ThriftTransmitTime(*): 130.428us - UncompressedRowBatchSize: 16.00 B (16) AGGREGATION_NODE (id=3):(Total: 206.762ms, non-child: 185.255ms, % non-child: 89.60%) - BuildTime: 4.638us - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 0 (0) - PeakMemoryUsage: 44.00 KB (45056) - RowsRepartitioned: 0 (0) - RowsReturned: 1 (1) - RowsReturnedRate: 4.00 /sec - SpilledPartitions: 0 (0) HASH_JOIN_NODE (id=2):(Total: 21.507ms, non-child: 12.790ms, % non-child: 59.47%) - BuildPartitionTime: 3.750us - BuildRows: 1 (1) - BuildRowsPartitioned: 1 (1) - BuildTime: 3.966us - GetNewBlockTime: 103.240us - HashBuckets: 1 (1) - HashCollisions: 0 (0) - LargestPartitionPercent: 100 (100) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.02 MB (2117632) - PinTime: 0.000ns - ProbeRows: 5 (5) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 3.906us - RowsReturned: 5 (5) - RowsReturnedRate: 232.00 /sec - SpilledPartitions: 0 (0) - UnpinTime: 1.074us EXCHANGE_NODE (id=4):(Total: 9.718us, non-child: 9.718us, % non-child: 100.00%) - BytesReceived: 32.00 B (32) - ConvertRowBatchTime: 1.110us - DeserializeRowBatchTimer: 8.292us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 1 (1) - RowsReturnedRate: 102.90 K/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HDFS_SCAN_NODE (id=0):(Total: 8.706ms, non-child: 8.706ms, % non-child: 100.00%) - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 2.27 KB (2324) - BytesReadDataNodeCache: 0 - BytesReadLocal: 2.27 KB (2324) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 2.27 KB (2324) - DecompressionTime: 1.292us - MaxCompressedTextFileLength: 0 - NumColumns: 1 (1) - NumDisksAccessed: 1 (1) - NumRowGroups: 1 (1) - NumScannerThreadsStarted: 1 (1) - PeakMemoryUsage: 33.00 KB (33792) - PerReadThreadRawHdfsThroughput: 110.73 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 25 (25) - RowsReturned: 5 (5) - RowsReturnedRate: 574.00 /sec - ScanRangesComplete: 1 (1) - ScannerThreadsInvoluntaryContextSwitches: 0 (0) - ScannerThreadsTotalWallClockTime: 8.380ms - MaterializeTupleTime(*): 7.192us - ScannerThreadsSysTime: 0.000ns - ScannerThreadsUserTime: 0.000ns - ScannerThreadsVoluntaryContextSwitches: 6 (6) - TotalRawHdfsReadTime(*): 20.016us - TotalReadThroughput: 0.00 /sec Filter 0: - Rows processed: 25 (25) - Rows rejected: 20 (20) - Rows total: 25 (25) Averaged Fragment F01:(Total: 8.947ms, non-child: 550.562us, % non-child: 6.15%) split sizes: min: 910.00 B, max: 910.00 B, avg: 910.00 B, stddev: 0 completion times: min:185.778ms max:185.778ms mean: 185.778ms stddev:0.000ns execution rates: min:4.78 KB/sec max:4.78 KB/sec mean:4.78 KB/sec stddev:0.00 /sec num instances: 1 - AverageThreadTokens: 1.00 - BloomFilterBytes: 0 - PeakMemoryUsage: 67.00 KB (68608) - PerHostPeakMemUsage: 67.00 KB (68608) - PrepareTime: 85.060us - RowsProduced: 1 (1) - TotalCpuTime: 10.563ms - TotalNetworkReceiveTime: 0.000ns - TotalNetworkSendTime: 175.158ms - TotalStorageWaitTime: 7.618ms BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 0 (0) - BlocksRecycled: 0 (0) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 242.23 GB (260091396096) - PeakMemoryUsage: 0 - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalIntegrityCheckTime: 0.000ns - TotalReadBlockTime: 0.000ns DataStreamSender (dst_id=4):(Total: 53.288us, non-child: 53.288us, % non-child: 100.00%) - BytesSent: 32.00 B (32) - NetworkThroughput(*): 182.00 B/sec - OverallThroughput: 586.44 KB/sec - PeakMemoryUsage: 4.00 KB (4096) - SerializeBatchTime: 27.286us - ThriftTransmitTime(*): 175.124ms - UncompressedRowBatchSize: 47.00 B (47) HDFS_SCAN_NODE (id=1):(Total: 8.343ms, non-child: 8.343ms, % non-child: 100.00%) - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 1.05 KB (1078) - BytesReadDataNodeCache: 0 - BytesReadLocal: 1.05 KB (1078) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 1.05 KB (1078) - DecompressionTime: 2.264us - MaxCompressedTextFileLength: 0 - NumColumns: 2 (2) - NumDisksAccessed: 1 (1) - NumRowGroups: 1 (1) - NumScannerThreadsStarted: 1 (1) - PeakMemoryUsage: 55.00 KB (56320) - PerReadThreadRawHdfsThroughput: 53.56 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 5 (5) - RowsReturned: 1 (1) - RowsReturnedRate: 119.00 /sec - ScanRangesComplete: 1 (1) - ScannerThreadsInvoluntaryContextSwitches: 0 (0) - ScannerThreadsTotalWallClockTime: 7.992ms - MaterializeTupleTime(*): 12.934us - ScannerThreadsSysTime: 0.000ns - ScannerThreadsUserTime: 0.000ns - ScannerThreadsVoluntaryContextSwitches: 9 (9) - TotalRawHdfsReadTime(*): 19.196us - TotalReadThroughput: 0.00 /sec Fragment F00: Instance 2741408ceb48bb8d:bc2055fdb6ed9fa2 (host=d2403.halxg.cloudera.com:22000):(Total: 207.492ms, non-child: 0.000ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 7:1/2.19 KB MemoryUsage(500.000ms): 0, 40.01 KB ThreadUsage(500.000ms): 1, 1 - AverageThreadTokens: 1.00 - BloomFilterBytes: 2.00 MB (2097152) - PeakMemoryUsage: 2.05 MB (2146312) - PerHostPeakMemUsage: 3.05 MB (3194888) - PrepareTime: 186.558ms - RowsProduced: 1 (1) - TotalCpuTime: 574.300ms - TotalNetworkReceiveTime: 3.576us - TotalNetworkSendTime: 152.772us - TotalStorageWaitTime: 8.054ms BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 32 (32) - BlocksRecycled: 0 (0) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 242.23 GB (260091396096) - PeakMemoryUsage: 16.00 B (16) - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalIntegrityCheckTime: 0.000ns - TotalReadBlockTime: 0.000ns CodeGen:(Total: 538.979ms, non-child: 538.979ms, % non-child: 100.00%) - CodegenTime: 189.672us - CompileTime: 36.755ms - LoadTime: 0.000ns - ModuleBitcodeSize: 1.98 MB (2080424) - OptimizationTime: 318.496ms - PrepareTime: 181.899ms DataStreamSender (dst_id=5):(Total: 29.090us, non-child: 29.090us, % non-child: 100.00%) - BytesSent: 16.00 B (16) - NetworkThroughput(*): 119.80 KB/sec - OverallThroughput: 537.13 KB/sec - PeakMemoryUsage: 16.00 KB (16384) - SerializeBatchTime: 8.866us - ThriftTransmitTime(*): 130.428us - UncompressedRowBatchSize: 16.00 B (16) AGGREGATION_NODE (id=3):(Total: 206.762ms, non-child: 185.255ms, % non-child: 89.60%) ExecOption: Codegen Enabled - BuildTime: 4.638us - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 0 (0) - PeakMemoryUsage: 44.00 KB (45056) - RowsRepartitioned: 0 (0) - RowsReturned: 1 (1) - RowsReturnedRate: 4.00 /sec - SpilledPartitions: 0 (0) HASH_JOIN_NODE (id=2):(Total: 21.507ms, non-child: 12.790ms, % non-child: 59.47%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 3.750us - BuildRows: 1 (1) - BuildRowsPartitioned: 1 (1) - BuildTime: 3.966us - GetNewBlockTime: 103.240us - HashBuckets: 1 (1) - HashCollisions: 0 (0) - LargestPartitionPercent: 100 (100) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.02 MB (2117632) - PinTime: 0.000ns - ProbeRows: 5 (5) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 3.906us - RowsReturned: 5 (5) - RowsReturnedRate: 232.00 /sec - SpilledPartitions: 0 (0) - UnpinTime: 1.074us EXCHANGE_NODE (id=4):(Total: 9.718us, non-child: 9.718us, % non-child: 100.00%) BytesReceived(500.000ms): 32.00 B - BytesReceived: 32.00 B (32) - ConvertRowBatchTime: 1.110us - DeserializeRowBatchTimer: 8.292us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 1 (1) - RowsReturnedRate: 102.90 K/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HDFS_SCAN_NODE (id=0):(Total: 8.706ms, non-child: 8.706ms, % non-child: 100.00%) ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 0 out of 1 Hdfs split stats (:<# splits>/): 7:1/2.19 KB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% 26:0% 27:0% File Formats: PARQUET/SNAPPY:1 BytesRead(500.000ms): 0 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 2.27 KB (2324) - BytesReadDataNodeCache: 0 - BytesReadLocal: 2.27 KB (2324) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 2.27 KB (2324) - DecompressionTime: 1.292us - MaxCompressedTextFileLength: 0 - NumColumns: 1 (1) - NumDisksAccessed: 1 (1) - NumRowGroups: 1 (1) - NumScannerThreadsStarted: 1 (1) - PeakMemoryUsage: 33.00 KB (33792) - PerReadThreadRawHdfsThroughput: 110.73 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 25 (25) - RowsReturned: 5 (5) - RowsReturnedRate: 574.00 /sec - ScanRangesComplete: 1 (1) - ScannerThreadsInvoluntaryContextSwitches: 0 (0) - ScannerThreadsTotalWallClockTime: 8.380ms - MaterializeTupleTime(*): 7.192us - ScannerThreadsSysTime: 0.000ns - ScannerThreadsUserTime: 0.000ns - ScannerThreadsVoluntaryContextSwitches: 6 (6) - TotalRawHdfsReadTime(*): 20.016us - TotalReadThroughput: 0.00 /sec Filter 0: - Rows processed: 25 (25) - Rows rejected: 20 (20) - Rows total: 25 (25) Fragment F01: Instance 2741408ceb48bb8d:bc2055fdb6ed9fa3 (host=d2409.halxg.cloudera.com:22000):(Total: 8.947ms, non-child: 550.562us, % non-child: 6.15%) Hdfs split stats (:<# splits>/): 10:1/910.00 B MemoryUsage(500.000ms): 12.00 KB ThreadUsage(500.000ms): 1 - AverageThreadTokens: 1.00 - BloomFilterBytes: 0 - PeakMemoryUsage: 67.00 KB (68608) - PerHostPeakMemUsage: 67.00 KB (68608) - PrepareTime: 85.060us - RowsProduced: 1 (1) - TotalCpuTime: 10.563ms - TotalNetworkReceiveTime: 0.000ns - TotalNetworkSendTime: 175.158ms - TotalStorageWaitTime: 7.618ms BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 0 (0) - BlocksRecycled: 0 (0) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 242.23 GB (260091396096) - PeakMemoryUsage: 0 - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalIntegrityCheckTime: 0.000ns - TotalReadBlockTime: 0.000ns DataStreamSender (dst_id=4):(Total: 53.288us, non-child: 53.288us, % non-child: 100.00%) - BytesSent: 32.00 B (32) - NetworkThroughput(*): 182.00 B/sec - OverallThroughput: 586.44 KB/sec - PeakMemoryUsage: 4.00 KB (4096) - SerializeBatchTime: 27.286us - ThriftTransmitTime(*): 175.124ms - UncompressedRowBatchSize: 47.00 B (47) HDFS_SCAN_NODE (id=1):(Total: 8.343ms, non-child: 8.343ms, % non-child: 100.00%) ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 0 out of 1 Hdfs split stats (:<# splits>/): 10:1/910.00 B Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% 26:0% 27:0% File Formats: PARQUET/SNAPPY:2 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 1.05 KB (1078) - BytesReadDataNodeCache: 0 - BytesReadLocal: 1.05 KB (1078) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 1.05 KB (1078) - DecompressionTime: 2.264us - MaxCompressedTextFileLength: 0 - NumColumns: 2 (2) - NumDisksAccessed: 1 (1) - NumRowGroups: 1 (1) - NumScannerThreadsStarted: 1 (1) - PeakMemoryUsage: 55.00 KB (56320) - PerReadThreadRawHdfsThroughput: 53.56 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 5 (5) - RowsReturned: 1 (1) - RowsReturnedRate: 119.00 /sec - ScanRangesComplete: 1 (1) - ScannerThreadsInvoluntaryContextSwitches: 0 (0) - ScannerThreadsTotalWallClockTime: 7.992ms - MaterializeTupleTime(*): 12.934us - ScannerThreadsSysTime: 0.000ns - ScannerThreadsUserTime: 0.000ns - ScannerThreadsVoluntaryContextSwitches: 9 (9) - TotalRawHdfsReadTime(*): 19.196us - TotalReadThroughput: 0.00 /sec