Query (id=e43a86abd98f0f3:8f14520bcb71acbe): Summary: Session ID: 2a439f4b0b8477db:8ba6f3b38e73538b Session Type: BEESWAX Start Time: 2016-06-03 07:55:40.560671000 End Time: 2016-06-03 07:57:23.858341000 Query Type: QUERY Query State: FINISHED Query Status: OK Impala Version: impalad version 2.5.0-cdh5-INTERNAL DEBUG (build 2916cc2eb503af075caf22bf8354e64430e967f9) User: mikeb Connected User: mikeb Delegated User: Network Address: ::ffff:127.0.0.1:39596 Default Db: default Sql Statement: select o_orderdate, o_custkey, o_comment from tpch.orders Coordinator: mikeb-desktop:22000 Query Options (non default): Plan: ---------------- Estimated Per-Host Requirements: Memory=120.00MB VCores=1 01:EXCHANGE [UNPARTITIONED] | hosts=3 per-host-mem=unavailable | tuple-ids=0 row-size=99B cardinality=1500000 | 00:SCAN HDFS [tpch.orders, RANDOM] partitions=1/1 files=1 size=162.56MB table stats: 1500000 rows total column stats: all hosts=3 per-host-mem=120.00MB tuple-ids=0 row-size=99B cardinality=1500000 ---------------- Estimated Per-Host Mem: 125829120 Estimated Per-Host VCores: 1 Request Pool: default-pool Admission result: Admitted immediately ExecSummary: Operator #Hosts Avg Time Max Time #Rows Est. #Rows Peak Mem Est. Peak Mem Detail ------------------------------------------------------------------------------------------------------- 01:EXCHANGE 1 183.022ms 183.022ms 1.50M 1.50M 0 -1.00 B UNPARTITIONED 00:SCAN HDFS 3 2s540ms 4s345ms 1.50M 1.50M 66.95 MB 120.00 MB tpch.orders Planner Timeline: 2.921ms - Analysis finished: 710.612us (710.612us) - Equivalence classes computed: 904.012us (193.400us) - Single node plan created: 1.577ms (673.877us) - Runtime filters computed: 1.592ms (14.916us) - Distributed plan created: 1.928ms (335.982us) - Planning finished: 2.921ms (992.427us) Query Timeline: 1m43s - Start execution: 34.540us (34.540us) - Planning finished: 3.690ms (3.655ms) - Submit for admission: 3.822ms (132.660us) - Completed admission: 3.859ms (37.056us) - Ready to start 3 remote fragments: 4.168ms (308.452us) - All 3 remote fragments started: 4.850ms (682.520us) - Rows available: 1s233ms (1s228ms) - First row fetched: 1s311ms (78.552ms) - Unregister query: 1m43s (1m41s) ImpalaServer: - ClientFetchWaitTimer: 1m39s - RowMaterializationTimer: 2s046ms Execution Profile e43a86abd98f0f3:8f14520bcb71acbe:(Total: 1s490ms, non-child: 0.000ns, % non-child: 0.00%) 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: 3, 25th %-ile: 0, 50th %-ile: 0, 75th %-ile: 0, 90th %-ile: 0, 95th %-ile: 0, 99.9th %-ile: 0 Per Node Peak Memory Usage: mikeb-desktop:22001(59.01 MB) mikeb-desktop:22002(26.85 MB) mikeb-desktop:22000(88.36 MB) - FiltersReceived: 0 (0) - FinalizationTimer: 0.000ns Coordinator Fragment F01:(Total: 1s413ms, non-child: 1.702ms, % non-child: 0.12%) MemoryUsage(2s000ms): 5.99 MB, 21.35 MB, 21.35 MB, 21.35 MB, 21.35 MB, 21.34 MB, 21.35 MB, 21.35 MB, 21.35 MB, 21.36 MB, 21.36 MB, 21.37 MB, 21.37 MB, 21.37 MB, 21.37 MB, 21.37 MB, 21.36 MB, 21.36 MB, 21.35 MB, 21.35 MB, 21.35 MB, 21.36 MB, 21.36 MB, 21.36 MB, 21.37 MB, 21.37 MB, 21.36 MB, 21.36 MB, 21.35 MB, 21.35 MB, 21.34 MB, 21.35 MB, 21.35 MB, 21.35 MB, 21.36 MB, 21.37 MB, 21.37 MB, 21.37 MB, 21.37 MB, 21.37 MB, 21.36 MB, 21.36 MB, 21.37 MB, 21.40 MB, 21.38 MB, 19.80 MB, 16.52 MB, 13.28 MB, 10.06 MB, 6.88 MB, 3.63 MB - AverageThreadTokens: 0.00 - BloomFilterBytes: 0 - PeakMemoryUsage: 21.48 MB (22527600) - PerHostPeakMemUsage: 0 - PrepareTime: 31.678us - RowsProduced: 1.50M (1500000) - TotalCpuTime: 1m41s - TotalNetworkReceiveTime: 1s237ms - 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: 6.68 GB (7171057152) - PeakMemoryUsage: 0 - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalIntegrityCheckTime: 0.000ns - TotalReadBlockTime: 0.000ns EXCHANGE_NODE (id=1):(Total: 1s411ms, non-child: 183.022ms, % non-child: 12.97%) BytesReceived(2s000ms): 2.90 MB, 11.29 MB, 12.74 MB, 14.17 MB, 15.66 MB, 17.19 MB, 18.70 MB, 20.24 MB, 21.78 MB, 23.30 MB, 24.83 MB, 26.36 MB, 27.88 MB, 29.41 MB, 30.90 MB, 32.41 MB, 33.94 MB, 35.46 MB, 36.98 MB, 38.51 MB, 40.04 MB, 41.57 MB, 43.09 MB, 44.62 MB, 46.15 MB, 47.68 MB, 49.19 MB, 50.71 MB, 52.22 MB, 53.75 MB, 55.23 MB, 56.76 MB, 58.28 MB, 59.81 MB, 61.34 MB, 62.87 MB, 64.40 MB, 65.92 MB, 67.43 MB, 68.95 MB, 70.47 MB, 71.98 MB, 73.47 MB, 75.00 MB, 76.56 MB, 77.30 MB, 77.30 MB, 77.30 MB, 77.30 MB, 77.30 MB, 77.30 MB - BytesReceived: 77.30 MB (81055241) - ConvertRowBatchTime: 168.038ms - DeserializeRowBatchTimer: 340.550ms - FirstBatchArrivalWaitTime: 1s228ms - PeakMemoryUsage: 0 - RowsReturned: 1.50M (1500000) - RowsReturnedRate: 1.06 M/sec - SendersBlockedTimer: 1m28s - SendersBlockedTotalTimer(*): 3m46s Averaged Fragment F00:(Total: 1m18s, non-child: 1m15s, % non-child: 96.00%) split sizes: min: 34.56 MB, max: 64.00 MB, avg: 54.19 MB, stddev: 13.88 MB completion times: min:1m max:1m30s mean: 1m18s stddev:12s951ms execution rates: min:586.27 KB/sec max:773.90 KB/sec mean:695.70 KB/sec stddev:79.72 KB/sec num instances: 3 - AverageThreadTokens: 2.41 - BloomFilterBytes: 0 - PeakMemoryUsage: 50.96 MB (53430952) - PerHostPeakMemUsage: 58.07 MB (60894866) - PrepareTime: 153.217ms - RowsProduced: 500.00K (500000) - TotalCpuTime: 1m56s - TotalNetworkReceiveTime: 0.000ns - TotalNetworkSendTime: 1m15s - TotalStorageWaitTime: 5s366ms BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 0 (0) - BlocksRecycled: 0 (0) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 6.68 GB (7171057152) - PeakMemoryUsage: 0 - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalIntegrityCheckTime: 0.000ns - TotalReadBlockTime: 0.000ns CodeGen:(Total: 222.987ms, non-child: 222.987ms, % non-child: 100.00%) - CodegenTime: 538.344us - CompileTime: 4.202ms - LoadTime: 0.000ns - ModuleBitcodeSize: 2.12 MB (2220000) - NumFunctions: 20 (20) - NumInstructions: 343 (343) - OptimizationTime: 66.122ms - PrepareTime: 152.236ms DataStreamSender (dst_id=1):(Total: 368.470ms, non-child: 368.470ms, % non-child: 100.00%) - BytesSent: 25.77 MB (27018413) - NetworkThroughput(*): 744.58 MB/sec - OverallThroughput: 69.38 MB/sec - PeakMemoryUsage: 2.66 KB (2728) - RowsReturned: 500.00K (500000) - SerializeBatchTime: 333.216ms - TransmitDataRPCTime: 35.057ms - UncompressedRowBatchSize: 52.70 MB (55258892) HDFS_SCAN_NODE (id=0):(Total: 2s540ms, non-child: 2s540ms, % non-child: 100.00%) - AverageHdfsReadThreadConcurrency: 0.08 - AverageScannerThreadConcurrency: 1.41 - BytesRead: 54.19 MB (56819093) - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0.000ns - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 1 (1) - NumScannerThreadsStarted: 2 (2) - PeakMemoryUsage: 50.90 MB (53370880) - PerReadThreadRawHdfsThroughput: 10.02 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 500.00K (500000) - RowsReturned: 500.00K (500000) - RowsReturnedRate: 236.87 K/sec - ScanRangesComplete: 2 (2) - ScannerThreadsInvoluntaryContextSwitches: 33 (33) - ScannerThreadsTotalWallClockTime: 1m56s - DelimiterParseTime: 184.879ms - MaterializeTupleTime(*): 22.478ms - ScannerThreadsSysTime: 0.000ns - ScannerThreadsUserTime: 220.000ms - ScannerThreadsVoluntaryContextSwitches: 385 (385) - TotalRawHdfsReadTime(*): 6s759ms - TotalReadThroughput: 697.85 KB/sec Fragment F00: Instance e43a86abd98f0f3:8f14520bcb71acc1 (host=mikeb-desktop:22001):(Total: 1m30s, non-child: 1m27s, % non-child: 97.59%) Hdfs split stats (:<# splits>/): -1:2/64.00 MB MemoryUsage(2s000ms): 20.85 MB, 49.01 MB, 59.01 MB, 59.01 MB, 59.01 MB, 54.96 MB, 50.91 MB, 50.91 MB, 50.91 MB, 50.91 MB, 50.91 MB, 50.91 MB, 50.91 MB, 50.91 MB, 50.91 MB, 50.91 MB, 50.91 MB, 50.91 MB, 50.91 MB, 50.91 MB, 50.92 MB, 50.92 MB, 50.92 MB, 48.92 MB, 42.92 MB, 42.92 MB, 42.92 MB, 34.92 MB, 34.92 MB, 34.92 MB, 34.92 MB, 34.92 MB, 34.92 MB, 34.89 MB, 34.93 MB, 34.96 MB, 34.96 MB, 24.92 MB, 18.85 MB, 18.85 MB, 18.85 MB, 18.85 MB, 14.85 MB, 10.39 MB, 8.85 MB ThreadUsage(2s000ms): 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 1 - AverageThreadTokens: 2.71 - BloomFilterBytes: 0 - PeakMemoryUsage: 59.01 MB (61872808) - PerHostPeakMemUsage: 59.01 MB (61872808) - PrepareTime: 173.117ms - RowsProduced: 589.55K (589553) - TotalCpuTime: 2m33s - TotalNetworkReceiveTime: 0.000ns - TotalNetworkSendTime: 1m28s - TotalStorageWaitTime: 3s996ms BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 0 (0) - BlocksRecycled: 0 (0) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 6.68 GB (7171057152) - PeakMemoryUsage: 0 - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalIntegrityCheckTime: 0.000ns - TotalReadBlockTime: 0.000ns CodeGen:(Total: 251.623ms, non-child: 251.623ms, % non-child: 100.00%) - CodegenTime: 602.270us - CompileTime: 4.749ms - LoadTime: 0.000ns - ModuleBitcodeSize: 2.12 MB (2220000) - NumFunctions: 20 (20) - NumInstructions: 343 (343) - OptimizationTime: 74.361ms - PrepareTime: 172.041ms DataStreamSender (dst_id=1):(Total: 429.967ms, non-child: 429.967ms, % non-child: 100.00%) - BytesSent: 30.39 MB (31862662) - NetworkThroughput(*): 750.40 MB/sec - OverallThroughput: 70.67 MB/sec - PeakMemoryUsage: 2.66 KB (2728) - RowsReturned: 589.55K (589553) - SerializeBatchTime: 389.267ms - TransmitDataRPCTime: 40.493ms - UncompressedRowBatchSize: 62.14 MB (65163107) HDFS_SCAN_NODE (id=0):(Total: 1s488ms, non-child: 1s488ms, % non-child: 100.00%) ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 2 out of 2 Hdfs split stats (:<# splits>/): -1:2/64.00 MB Hdfs Read Thread Concurrency Bucket: 0:96.11% 1:2.222% 2:1.667% 3:0% 4:0% 5:0% File Formats: TEXT/NONE:2 BytesRead(2s000ms): 6.00 MB, 46.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB - AverageHdfsReadThreadConcurrency: 0.06 - AverageScannerThreadConcurrency: 1.71 - BytesRead: 64.00 MB (67110912) - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0.000ns - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 1 (1) - NumScannerThreadsStarted: 2 (2) - PeakMemoryUsage: 58.95 MB (61812736) - PerReadThreadRawHdfsThroughput: 12.65 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 589.55K (589553) - RowsReturned: 589.55K (589553) - RowsReturnedRate: 396.12 K/sec - ScanRangesComplete: 2 (2) - ScannerThreadsInvoluntaryContextSwitches: 32 (32) - ScannerThreadsTotalWallClockTime: 2m33s - DelimiterParseTime: 213.735ms - MaterializeTupleTime(*): 26.149ms - ScannerThreadsSysTime: 0.000ns - ScannerThreadsUserTime: 256.000ms - ScannerThreadsVoluntaryContextSwitches: 439 (439) - TotalRawHdfsReadTime(*): 5s059ms - TotalReadThroughput: 728.20 KB/sec Instance e43a86abd98f0f3:8f14520bcb71acc2 (host=mikeb-desktop:22000):(Total: 1m24s, non-child: 1m19s, % non-child: 94.16%) Hdfs split stats (:<# splits>/): -1:2/64.00 MB MemoryUsage(2s000ms): 16.13 MB, 16.13 MB, 40.21 MB, 62.91 MB, 66.93 MB, 67.01 MB, 67.01 MB, 67.01 MB, 62.96 MB, 58.91 MB, 58.91 MB, 58.91 MB, 58.92 MB, 58.92 MB, 58.94 MB, 59.01 MB, 51.01 MB, 51.01 MB, 46.96 MB, 42.92 MB, 42.92 MB, 42.92 MB, 42.99 MB, 43.01 MB, 43.01 MB, 43.01 MB, 34.92 MB, 34.92 MB, 30.92 MB, 26.92 MB, 26.92 MB, 26.92 MB, 26.96 MB, 27.01 MB, 27.03 MB, 27.05 MB, 18.96 MB, 18.96 MB, 14.90 MB, 10.37 MB, 9.58 MB, 8.79 MB ThreadUsage(2s000ms): 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 2, 2, 2, 1, 1, 1, 1 - AverageThreadTokens: 2.75 - BloomFilterBytes: 0 - PeakMemoryUsage: 67.01 MB (70261416) - PerHostPeakMemUsage: 88.36 MB (92653160) - PrepareTime: 112.017ms - RowsProduced: 591.97K (591972) - TotalCpuTime: 2m27s - TotalNetworkReceiveTime: 0.000ns - TotalNetworkSendTime: 1m19s - TotalStorageWaitTime: 9s197ms CodeGen:(Total: 165.256ms, non-child: 165.256ms, % non-child: 100.00%) - CodegenTime: 472.356us - CompileTime: 3.367ms - LoadTime: 0.000ns - ModuleBitcodeSize: 2.12 MB (2220000) - NumFunctions: 20 (20) - NumInstructions: 343 (343) - OptimizationTime: 50.362ms - PrepareTime: 111.193ms DataStreamSender (dst_id=1):(Total: 426.918ms, non-child: 426.918ms, % non-child: 100.00%) - BytesSent: 30.51 MB (31988047) - NetworkThroughput(*): 695.79 MB/sec - OverallThroughput: 71.46 MB/sec - PeakMemoryUsage: 2.66 KB (2728) - RowsReturned: 591.97K (591972) - SerializeBatchTime: 382.924ms - TransmitDataRPCTime: 43.843ms - UncompressedRowBatchSize: 62.40 MB (65431451) HDFS_SCAN_NODE (id=0):(Total: 4s345ms, non-child: 4s345ms, % non-child: 100.00%) ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 2 out of 2 Hdfs split stats (:<# splits>/): -1:2/64.00 MB Hdfs Read Thread Concurrency Bucket: 0:91.72% 1:2.367% 2:5.917% 3:0% 4:0% 5:0% File Formats: TEXT/NONE:2 BytesRead(2s000ms): 0, 0, 24.00 MB, 54.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB, 64.00 MB - AverageHdfsReadThreadConcurrency: 0.14 - AverageScannerThreadConcurrency: 1.75 - BytesRead: 64.00 MB (67110912) - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0.000ns - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 1 (1) - NumScannerThreadsStarted: 2 (2) - PeakMemoryUsage: 66.95 MB (70201344) - PerReadThreadRawHdfsThroughput: 5.16 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 591.97K (591972) - RowsReturned: 591.97K (591972) - RowsReturnedRate: 136.21 K/sec - ScanRangesComplete: 2 (2) - ScannerThreadsInvoluntaryContextSwitches: 49 (49) - ScannerThreadsTotalWallClockTime: 2m27s - DelimiterParseTime: 220.969ms - MaterializeTupleTime(*): 25.892ms - ScannerThreadsSysTime: 0.000ns - ScannerThreadsUserTime: 264.000ms - ScannerThreadsVoluntaryContextSwitches: 538 (538) - TotalRawHdfsReadTime(*): 12s395ms - TotalReadThroughput: 775.60 KB/sec Instance e43a86abd98f0f3:8f14520bcb71acc0 (host=mikeb-desktop:22002):(Total: 1m, non-child: 57s987ms, % non-child: 96.21%) Hdfs split stats (:<# splits>/): -1:2/34.56 MB MemoryUsage(1s000ms): 12.13 MB, 12.07 MB, 26.85 MB, 26.85 MB, 26.85 MB, 26.85 MB, 26.85 MB, 26.85 MB, 26.85 MB, 26.85 MB, 26.85 MB, 26.85 MB, 26.85 MB, 26.85 MB, 26.85 MB, 26.85 MB, 26.85 MB, 26.85 MB, 26.85 MB, 26.85 MB, 18.85 MB, 18.85 MB, 18.85 MB, 18.85 MB, 18.85 MB, 18.85 MB, 18.85 MB, 18.85 MB, 18.85 MB, 18.85 MB, 18.85 MB, 18.85 MB, 18.85 MB, 18.85 MB, 18.85 MB, 18.85 MB, 18.85 MB, 18.85 MB, 18.85 MB, 18.85 MB, 10.85 MB, 10.85 MB, 10.85 MB, 10.85 MB, 10.85 MB, 10.85 MB, 10.75 MB, 10.55 MB, 10.36 MB, 10.14 MB, 9.95 MB, 9.76 MB, 9.54 MB, 9.38 MB, 9.16 MB, 8.97 MB, 8.78 MB, 8.56 MB, 8.39 MB, 8.18 MB ThreadUsage(1s000ms): 3, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.78 - BloomFilterBytes: 0 - PeakMemoryUsage: 26.85 MB (28158632) - PerHostPeakMemUsage: 26.85 MB (28158632) - PrepareTime: 174.517ms - RowsProduced: 318.48K (318475) - TotalCpuTime: 46s956ms - TotalNetworkReceiveTime: 0.000ns - TotalNetworkSendTime: 58s255ms - TotalStorageWaitTime: 2s904ms BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 0 (0) - BlocksRecycled: 0 (0) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 6.68 GB (7171057152) - PeakMemoryUsage: 0 - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalIntegrityCheckTime: 0.000ns - TotalReadBlockTime: 0.000ns CodeGen:(Total: 252.083ms, non-child: 252.083ms, % non-child: 100.00%) - CodegenTime: 540.406us - CompileTime: 4.490ms - LoadTime: 0.000ns - ModuleBitcodeSize: 2.12 MB (2220000) - NumFunctions: 20 (20) - NumInstructions: 343 (343) - OptimizationTime: 73.644ms - PrepareTime: 173.473ms DataStreamSender (dst_id=1):(Total: 248.526ms, non-child: 248.526ms, % non-child: 100.00%) - BytesSent: 16.41 MB (17204532) - NetworkThroughput(*): 787.54 MB/sec - OverallThroughput: 66.02 MB/sec - PeakMemoryUsage: 2.66 KB (2728) - RowsReturned: 318.48K (318475) - SerializeBatchTime: 227.459ms - TransmitDataRPCTime: 20.833ms - UncompressedRowBatchSize: 33.55 MB (35182118) HDFS_SCAN_NODE (id=0):(Total: 1s786ms, non-child: 1s786ms, % non-child: 100.00%) ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 2 out of 2 Hdfs split stats (:<# splits>/): -1:2/34.56 MB Hdfs Read Thread Concurrency Bucket: 0:96.67% 1:2.5% 2:0.8333% 3:0% 4:0% 5:0% File Formats: TEXT/NONE:2 BytesRead(1s000ms): 0, 6.56 MB, 30.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB, 34.56 MB - AverageHdfsReadThreadConcurrency: 0.04 - AverageScannerThreadConcurrency: 0.78 - BytesRead: 34.56 MB (36235457) - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0.000ns - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 1 (1) - NumScannerThreadsStarted: 2 (2) - PeakMemoryUsage: 26.80 MB (28098560) - PerReadThreadRawHdfsThroughput: 12.24 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 318.48K (318475) - RowsReturned: 318.48K (318475) - RowsReturnedRate: 178.29 K/sec - ScanRangesComplete: 2 (2) - ScannerThreadsInvoluntaryContextSwitches: 18 (18) - ScannerThreadsTotalWallClockTime: 46s956ms - DelimiterParseTime: 119.934ms - MaterializeTupleTime(*): 15.395ms - ScannerThreadsSysTime: 0.000ns - ScannerThreadsUserTime: 140.000ms - ScannerThreadsVoluntaryContextSwitches: 180 (180) - TotalRawHdfsReadTime(*): 2s823ms - TotalReadThroughput: 589.77 KB/sec