Query (id=d044245554d166fb:2c648907a827669f) Summary Session ID: 794f9c5774bd839d:736f47fef188f1ba Session Type: BEESWAX Start Time: 2016-05-06 00:23:33.234745000 End Time: 2016-05-06 00:28:09.172819000 Query Type: QUERY Query State: FINISHED Query Status: OK Impala Version: impalad version 2.6.0-cdh5-INTERNAL RELEASE (build 318433b461516307f98e880f85fbd05802ac44f2) User: systest Connected User: systest Delegated User: Network Address: ::ffff:172.26.8.98:44606 Default Db: tpcds_1000_parquet Sql Statement: select count(*) from store_sales where ss_item_sk = 10 Coordinator: impala-sailesh-s3-2.vpc.cloudera.com:22000 Query Options (non default): Plan: ---------------- Estimated Per-Host Requirements: Memory=98.00MB VCores=1 WARNING: The following tables are missing relevant table and/or column statistics. tpcds_1000_parquet.store_sales 03:AGGREGATE [FINALIZE] | output: count:merge(*) | hosts=10 per-host-mem=unavailable | tuple-ids=1 row-size=8B cardinality=1 | 02:EXCHANGE [UNPARTITIONED] | hosts=10 per-host-mem=unavailable | tuple-ids=1 row-size=8B cardinality=1 | 01:AGGREGATE | output: count(*) | hosts=10 per-host-mem=10.00MB | tuple-ids=1 row-size=8B cardinality=1 | 00:SCAN HDFS [tpcds_1000_parquet.store_sales, RANDOM] partitions=1824/1824 files=1824 size=189.24GB predicates: ss_item_sk = 10 table stats: unavailable column stats: unavailable hosts=10 per-host-mem=88.00MB tuple-ids=0 row-size=8B cardinality=unavailable ---------------- Estimated Per-Host Mem: 102760448 Estimated Per-Host VCores: 1 Tables Missing Stats: tpcds_1000_parquet.store_sales Request Pool: root.systest Admission result: Admitted immediately ExecSummary: Operator #Hosts Avg Time Max Time #Rows Est. #Rows Peak Mem Est. Peak Mem Detail ------------------------------------------------------------------------------------------------------------------------ 03:AGGREGATE 1 169.996ms 169.996ms 1 1 52.00 KB -1.00 B FINALIZE 02:EXCHANGE 1 0.000ns 0.000ns 10 1 0 -1.00 B UNPARTITIONED 01:AGGREGATE 10 3s416ms 3s531ms 10 1 8.08 MB 10.00 MB 00:SCAN HDFS 10 3m6s 4m31s 7.69K -1 99.71 MB 88.00 MB tpcds_1000_parquet.store_sales Planner Timeline Analysis finished: 12722882 Equivalence classes computed: 12962193 Single node plan created: 56269150 Runtime filters computed: 56323409 Distributed plan created: 57907582 Lineage info computed: 58728777 Planning finished: 149150220 Query Timeline Start execution: 0 Planning finished: 234994779 Submit for admission: 241994623 Completed admission: 241994623 Ready to start 10 remote fragments: 416990734 All 10 remote fragments started: 529988223 Rows available: 275477882052 First row fetched: 275934871909 Unregister query: 275937871843 ImpalaServer - ClientFetchWaitTimer: 457989835 - InactiveTotalTime: 0 - RowMaterializationTimer: 0 - TotalTime: 0 Execution Profile d044245554d166fb:2c648907a827669f Number of filters: 0 Filter routing table: ID Src. Node Tgt. Node Targets Type Partition filter Pending First arrived Completed ---------------------------------------------------------------------------------------------- Fragment start latencies: Count: 10, 25th %-ile: 31ms, 50th %-ile: 33ms, 75th %-ile: 38ms, 90th %-ile: 41ms, 95th %-ile: 45ms, 99.9th %-ile: 45ms Per Node Peak Memory Usage: impala-sailesh-s3-11.vpc.cloudera.com:22000(93.74 MB) impala-sailesh-s3-4.vpc.cloudera.com:22000(94.42 MB) impala-sailesh-s3-5.vpc.cloudera.com:22000(83.11 MB) impala-sailesh-s3-7.vpc.cloudera.com:22000(86.24 MB) impala-sailesh-s3-6.vpc.cloudera.com:22000(83.37 MB) impala-sailesh-s3-8.vpc.cloudera.com:22000(99.74 MB) impala-sailesh-s3-3.vpc.cloudera.com:22000(85.90 MB) impala-sailesh-s3-10.vpc.cloudera.com:22000(92.34 MB) impala-sailesh-s3-9.vpc.cloudera.com:22000(91.40 MB) impala-sailesh-s3-2.vpc.cloudera.com:22000(44.35 MB) - FiltersReceived: 0 - FinalizationTimer: 0 - InactiveTotalTime: 0 - TotalTime: 275223887697 Coordinator Fragment F01 - AverageThreadTokens: 1.0 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 61456 - PerHostPeakMemUsage: 0 - PrepareTime: 169996223 - RowsProduced: 1 - TotalCpuTime: 812981948 - TotalNetworkReceiveTime: 274875895428 - TotalNetworkSendTime: 0 - TotalStorageWaitTime: 0 - TotalTime: 275045891651 BlockMgr - BlockWritesOutstanding: 0 - BlocksCreated: 0 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - InactiveTotalTime: 0 - MaxBlockSize: 8388608 - MemoryLimit: 11484461056 - PeakMemoryUsage: 0 - TotalBufferWaitTime: 0 - TotalEncryptionTime: 0 - TotalIntegrityCheckTime: 0 - TotalReadBlockTime: 0 - TotalTime: 0 CodeGen - CodegenTime: 0 - CompileTime: 6999846 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294144 - NumFunctions: 4 - NumInstructions: 56 - OptimizationTime: 54998777 - PrepareTime: 168996245 - TotalTime: 231994846 AGGREGATION_NODE (id=3) ExecOption: Codegen Enabled - BuildTime: 0 - GetResultsTime: 0 - HTResizeTime: 0 - HashBuckets: 0 - InactiveTotalTime: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 0 - PeakMemoryUsage: 53248 - RowsRepartitioned: 0 - RowsReturned: 1 - RowsReturnedRate: 0 - SpilledPartitions: 0 - TotalTime: 275045891651 EXCHANGE_NODE (id=2) - BytesReceived: 160 - ConvertRowBatchTime: 0 - DeserializeRowBatchTimer: 999978 - FirstBatchArrivalWaitTime: 160349438045 - InactiveTotalTime: 274875895428 - PeakMemoryUsage: 0 - RowsReturned: 10 - RowsReturnedRate: 0 - SendersBlockedTimer: 0 - SendersBlockedTotalTimer(*): 0 - TotalTime: 274875895428 Averaged Fragment F00 split sizes: min: 18.65 GB, max: 19.28 GB, avg: 18.92 GB, stddev: 189.10 MB completion times: min:2m40s max:4m34s mean: 3m10s stddev:29s246ms execution rates: min:69.47 MB/sec max:122.66 MB/sec mean:103.68 MB/sec stddev:12.73 MB/sec num instances: 10 - AverageThreadTokens: 5.643134433516236 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 89607572 - PerHostPeakMemUsage: 89613308 - PrepareTime: 170297854 - RowsProduced: 1 - TotalCpuTime: 860201618571 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 1299976 - TotalStorageWaitTime: 843084929581 - TotalTime: 190381986537 BlockMgr - BlockWritesOutstanding: 0 - BlocksCreated: 0 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - InactiveTotalTime: 0 - MaxBlockSize: 8388608 - MemoryLimit: 11484461056 - PeakMemoryUsage: 0 - TotalBufferWaitTime: 0 - TotalEncryptionTime: 0 - TotalIntegrityCheckTime: 0 - TotalReadBlockTime: 0 - TotalTime: 0 CodeGen - CodegenTime: 199996 - CompileTime: 5499933 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294144 - NumFunctions: 7 - NumInstructions: 104 - OptimizationTime: 39599508 - PrepareTime: 168297884 - TotalTime: 214197313 DataStreamSender (dst_id=2) - BytesSent: 16 - InactiveTotalTime: 0 - NetworkThroughput(*): 0 - OverallThroughput: 0 - PeakMemoryUsage: 16384 - RowsReturned: 1 - SerializeBatchTime: 0 - TotalTime: 0 - TransmitDataRPCTime: 0 - UncompressedRowBatchSize: 16 AGGREGATION_NODE (id=1) - BuildTime: 3244459922 - GetResultsTime: 0 - HTResizeTime: 0 - HashBuckets: 0 - InactiveTotalTime: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 0 - PeakMemoryUsage: 8432220 - RowsRepartitioned: 0 - RowsReturned: 1 - RowsReturnedRate: 0 - SpilledPartitions: 0 - TotalTime: 190376186619 HDFS_SCAN_NODE (id=0) - AverageHdfsReadThreadConcurrency: 3.6734290775731573 - AverageScannerThreadConcurrency: 4.654132493575493 - BytesRead: 2206341075 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 1 - NumRowGroups: 264 - NumScannerThreadsStarted: 4 - PeakMemoryUsage: 88470280 - PerReadThreadRawHdfsThroughput: 3367300 - RemoteScanRanges: 0 - RowsRead: 287998799 - RowsReturned: 769 - RowsReturnedRate: 3 - ScanRangesComplete: 185 - ScannerThreadsInvoluntaryContextSwitches: 8774 - ScannerThreadsTotalWallClockTime: 860201618571 - MaterializeTupleTime(*): 15267811660 - ScannerThreadsSysTime: 4527909000 - ScannerThreadsUserTime: 9294085000 - ScannerThreadsVoluntaryContextSwitches: 1480 - TotalRawHdfsReadTime(*): 678313613595 - TotalReadThroughput: 11805905 - TotalTime: 186959328876 Fragment F00 Instance d044245554d166fb:2c648907a82766aa (host=impala-sailesh-s3-2.vpc.cloudera.com:22000) Hdfs split stats (:<# splits>/): -1:186/18.65 GB - AverageThreadTokens: 2.9854280510018216 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 46449392 - PerHostPeakMemUsage: 46506744 - PrepareTime: 189995779 - RowsProduced: 1 - TotalCpuTime: 545363888261 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 999978 - TotalStorageWaitTime: 528711258084 - TotalTime: 274901894851 CodeGen - CodegenTime: 0 - CompileTime: 3999912 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294144 - NumFunctions: 7 - NumInstructions: 104 - OptimizationTime: 39999110 - PrepareTime: 187995823 - TotalTime: 232994823 DataStreamSender (dst_id=2) - BytesSent: 16 - InactiveTotalTime: 0 - NetworkThroughput(*): 0 - OverallThroughput: 0 - PeakMemoryUsage: 16384 - RowsReturned: 1 - SerializeBatchTime: 0 - TotalTime: 0 - TransmitDataRPCTime: 0 - UncompressedRowBatchSize: 16 AGGREGATION_NODE (id=1) ExecOption: Codegen Enabled - BuildTime: 3193929049 - GetResultsTime: 0 - HTResizeTime: 0 - HashBuckets: 0 - InactiveTotalTime: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 0 - PeakMemoryUsage: 8474872 - RowsRepartitioned: 0 - RowsReturned: 1 - RowsReturnedRate: 0 - SpilledPartitions: 0 - TotalTime: 274895894985 HDFS_SCAN_NODE (id=0) ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 186 Hdfs split stats (:<# splits>/): -1:186/18.65 GB Hdfs Read Thread Concurrency Bucket: 0:9.654% 1:40.26% 2:50.09% 3:0% 4:0% File Formats: PARQUET/NONE:186 - AverageHdfsReadThreadConcurrency: 1.4043715846994536 - AverageScannerThreadConcurrency: 1.9854280510018214 - BytesRead: 2170949547 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 1 - NumRowGroups: 263 - NumScannerThreadsStarted: 2 - PeakMemoryUsage: 45306384 - PerReadThreadRawHdfsThroughput: 5525165 - RemoteScanRanges: 0 - RowsRead: 283506114 - RowsReturned: 771 - RowsReturnedRate: 2 - ScanRangesComplete: 186 - ScannerThreadsInvoluntaryContextSwitches: 5095 - ScannerThreadsTotalWallClockTime: 545363888261 - MaterializeTupleTime(*): 14810671136 - ScannerThreadsSysTime: 4590301000 - ScannerThreadsUserTime: 9285588000 - ScannerThreadsVoluntaryContextSwitches: 1471 - TotalRawHdfsReadTime(*): 392920273560 - TotalReadThroughput: 7906581 - TotalTime: 271503970336 Instance d044245554d166fb:2c648907a82766a6 (host=impala-sailesh-s3-7.vpc.cloudera.com:22000) Hdfs split stats (:<# splits>/): -1:185/18.91 GB - AverageThreadTokens: 5.966057441253263 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 90433672 - PerHostPeakMemUsage: 90433672 - PrepareTime: 169995497 - RowsProduced: 1 - TotalCpuTime: 951683781352 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 1999946 - TotalStorageWaitTime: 934336241067 - TotalTime: 191506925251 BlockMgr - BlockWritesOutstanding: 0 - BlocksCreated: 0 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - InactiveTotalTime: 0 - MaxBlockSize: 8388608 - MemoryLimit: 11484461056 - PeakMemoryUsage: 0 - TotalBufferWaitTime: 0 - TotalEncryptionTime: 0 - TotalIntegrityCheckTime: 0 - TotalReadBlockTime: 0 - TotalTime: 0 CodeGen - CodegenTime: 0 - CompileTime: 4999866 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294144 - NumFunctions: 7 - NumInstructions: 104 - OptimizationTime: 41998889 - PrepareTime: 167995551 - TotalTime: 215994279 DataStreamSender (dst_id=2) - BytesSent: 16 - InactiveTotalTime: 0 - NetworkThroughput(*): 0 - OverallThroughput: 0 - PeakMemoryUsage: 16384 - RowsReturned: 1 - SerializeBatchTime: 0 - TotalTime: 0 - TransmitDataRPCTime: 0 - UncompressedRowBatchSize: 16 AGGREGATION_NODE (id=1) ExecOption: Codegen Enabled - BuildTime: 3363910845 - GetResultsTime: 0 - HTResizeTime: 0 - HashBuckets: 0 - InactiveTotalTime: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 0 - PeakMemoryUsage: 8475120 - RowsRepartitioned: 0 - RowsReturned: 1 - RowsReturnedRate: 0 - SpilledPartitions: 0 - TotalTime: 191499925437 HDFS_SCAN_NODE (id=0) ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 185 Hdfs split stats (:<# splits>/): -1:185/18.91 GB Hdfs Read Thread Concurrency Bucket: 0:0.2618% 1:0.7853% 2:5.236% 3:18.59% 4:75.13% File Formats: PARQUET/NONE:185 - AverageHdfsReadThreadConcurrency: 4.028795811518324 - AverageScannerThreadConcurrency: 4.979057591623037 - BytesRead: 2198807141 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 1 - NumRowGroups: 265 - NumScannerThreadsStarted: 5 - PeakMemoryUsage: 87578312 - PerReadThreadRawHdfsThroughput: 2849013 - RemoteScanRanges: 0 - RowsRead: 287072000 - RowsReturned: 802 - RowsReturnedRate: 4 - ScanRangesComplete: 185 - ScannerThreadsInvoluntaryContextSwitches: 7343 - ScannerThreadsTotalWallClockTime: 951683781352 - MaterializeTupleTime(*): 15466590093 - ScannerThreadsSysTime: 4446321000 - ScannerThreadsUserTime: 9353576000 - ScannerThreadsVoluntaryContextSwitches: 1527 - TotalRawHdfsReadTime(*): 771778548785 - TotalReadThroughput: 11474992 - TotalTime: 187968019040 Instance d044245554d166fb:2c648907a82766a4 (host=impala-sailesh-s3-8.vpc.cloudera.com:22000) Hdfs split stats (:<# splits>/): -1:185/18.77 GB - AverageThreadTokens: 5.940700808625337 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 104588888 - PerHostPeakMemUsage: 104588888 - PrepareTime: 169002274 - RowsProduced: 1 - TotalCpuTime: 916799324473 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 1000014 - TotalStorageWaitTime: 899402090672 - TotalTime: 185807497740 BlockMgr - BlockWritesOutstanding: 0 - BlocksCreated: 0 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - InactiveTotalTime: 0 - MaxBlockSize: 8388608 - MemoryLimit: 11484461056 - PeakMemoryUsage: 0 - TotalBufferWaitTime: 0 - TotalEncryptionTime: 0 - TotalIntegrityCheckTime: 0 - TotalReadBlockTime: 0 - TotalTime: 0 CodeGen - CodegenTime: 0 - CompileTime: 6000084 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294144 - NumFunctions: 7 - NumInstructions: 104 - OptimizationTime: 40000537 - PrepareTime: 167002247 - TotalTime: 214002881 DataStreamSender (dst_id=2) - BytesSent: 16 - InactiveTotalTime: 0 - NetworkThroughput(*): 0 - OverallThroughput: 0 - PeakMemoryUsage: 16384 - RowsReturned: 1 - SerializeBatchTime: 0 - TotalTime: 0 - TransmitDataRPCTime: 0 - UncompressedRowBatchSize: 16 AGGREGATION_NODE (id=1) ExecOption: Codegen Enabled - BuildTime: 3287044162 - GetResultsTime: 0 - HTResizeTime: 0 - HashBuckets: 0 - InactiveTotalTime: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 0 - PeakMemoryUsage: 8456848 - RowsRepartitioned: 0 - RowsReturned: 1 - RowsReturnedRate: 0 - SpilledPartitions: 0 - TotalTime: 185801497656 HDFS_SCAN_NODE (id=0) ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 185 Hdfs split stats (:<# splits>/): -1:185/18.77 GB Hdfs Read Thread Concurrency Bucket: 0:0.8086% 1:1.348% 2:4.852% 3:20.22% 4:72.78% File Formats: PARQUET/NONE:185 - AverageHdfsReadThreadConcurrency: 3.9514824797843664 - AverageScannerThreadConcurrency: 4.940700808625337 - BytesRead: 2194541052 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 1 - NumRowGroups: 262 - NumScannerThreadsStarted: 5 - PeakMemoryUsage: 104552024 - PerReadThreadRawHdfsThroughput: 3004468 - RemoteScanRanges: 0 - RowsRead: 286405498 - RowsReturned: 775 - RowsReturnedRate: 4 - ScanRangesComplete: 185 - ScannerThreadsInvoluntaryContextSwitches: 9953 - ScannerThreadsTotalWallClockTime: 916799324473 - MaterializeTupleTime(*): 15576209337 - ScannerThreadsSysTime: 4661289000 - ScannerThreadsUserTime: 9195599000 - ScannerThreadsVoluntaryContextSwitches: 1489 - TotalRawHdfsReadTime(*): 730425819239 - TotalReadThroughput: 11786204 - TotalTime: 182344451208 Instance d044245554d166fb:2c648907a82766a2 (host=impala-sailesh-s3-10.vpc.cloudera.com:22000) Hdfs split stats (:<# splits>/): -1:185/18.81 GB - AverageThreadTokens: 5.967567567567568 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 96822048 - PerHostPeakMemUsage: 96822048 - PrepareTime: 162002689 - RowsProduced: 1 - TotalCpuTime: 919876223960 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 1000016 - TotalStorageWaitTime: 903095946241 - TotalTime: 184850059264 BlockMgr - BlockWritesOutstanding: 0 - BlocksCreated: 0 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - InactiveTotalTime: 0 - MaxBlockSize: 8388608 - MemoryLimit: 11484461056 - PeakMemoryUsage: 0 - TotalBufferWaitTime: 0 - TotalEncryptionTime: 0 - TotalIntegrityCheckTime: 0 - TotalReadBlockTime: 0 - TotalTime: 0 CodeGen - CodegenTime: 0 - CompileTime: 5000083 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294144 - NumFunctions: 7 - NumInstructions: 104 - OptimizationTime: 38000630 - PrepareTime: 161002671 - TotalTime: 204003384 DataStreamSender (dst_id=2) - BytesSent: 16 - InactiveTotalTime: 0 - NetworkThroughput(*): 0 - OverallThroughput: 0 - PeakMemoryUsage: 16384 - RowsReturned: 1 - SerializeBatchTime: 0 - TotalTime: 0 - TransmitDataRPCTime: 0 - UncompressedRowBatchSize: 16 AGGREGATION_NODE (id=1) ExecOption: Codegen Enabled - BuildTime: 3080050957 - GetResultsTime: 0 - HTResizeTime: 0 - HashBuckets: 0 - InactiveTotalTime: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 0 - PeakMemoryUsage: 8400896 - RowsRepartitioned: 0 - RowsReturned: 1 - RowsReturnedRate: 0 - SpilledPartitions: 0 - TotalTime: 184845059183 HDFS_SCAN_NODE (id=0) ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 185 Hdfs split stats (:<# splits>/): -1:185/18.81 GB Hdfs Read Thread Concurrency Bucket: 0:0% 1:2.439% 2:7.046% 3:16.26% 4:74.25% File Formats: PARQUET/NONE:185 - AverageHdfsReadThreadConcurrency: 3.948509485094851 - AverageScannerThreadConcurrency: 4.981029810298103 - BytesRead: 2199344430 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 1 - NumRowGroups: 263 - NumScannerThreadsStarted: 5 - PeakMemoryUsage: 96177216 - PerReadThreadRawHdfsThroughput: 3004798 - RemoteScanRanges: 0 - RowsRead: 287007472 - RowsReturned: 747 - RowsReturnedRate: 4 - ScanRangesComplete: 185 - ScannerThreadsInvoluntaryContextSwitches: 10934 - ScannerThreadsTotalWallClockTime: 919876223960 - MaterializeTupleTime(*): 15016248506 - ScannerThreadsSysTime: 4265348000 - ScannerThreadsUserTime: 9281586000 - ScannerThreadsVoluntaryContextSwitches: 1348 - TotalRawHdfsReadTime(*): 731944113335 - TotalReadThroughput: 11917314 - TotalTime: 181600005489 Instance d044245554d166fb:2c648907a82766a5 (host=impala-sailesh-s3-6.vpc.cloudera.com:22000) Hdfs split stats (:<# splits>/): -1:185/18.86 GB - AverageThreadTokens: 5.967302452316076 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 87423600 - PerHostPeakMemUsage: 87423600 - PrepareTime: 173004310 - RowsProduced: 1 - TotalCpuTime: 912398266274 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 1000025 - TotalStorageWaitTime: 895066823933 - TotalTime: 183583681525 BlockMgr - BlockWritesOutstanding: 0 - BlocksCreated: 0 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - InactiveTotalTime: 0 - MaxBlockSize: 8388608 - MemoryLimit: 11484461056 - PeakMemoryUsage: 0 - TotalBufferWaitTime: 0 - TotalEncryptionTime: 0 - TotalIntegrityCheckTime: 0 - TotalReadBlockTime: 0 - TotalTime: 0 CodeGen - CodegenTime: 0 - CompileTime: 6000149 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294144 - NumFunctions: 7 - NumInstructions: 104 - OptimizationTime: 41001023 - PrepareTime: 171004261 - TotalTime: 219005458 DataStreamSender (dst_id=2) - BytesSent: 16 - InactiveTotalTime: 0 - NetworkThroughput(*): 0 - OverallThroughput: 0 - PeakMemoryUsage: 16384 - RowsReturned: 1 - SerializeBatchTime: 0 - TotalTime: 0 - TransmitDataRPCTime: 0 - UncompressedRowBatchSize: 16 AGGREGATION_NODE (id=1) ExecOption: Codegen Enabled - BuildTime: 3329084965 - GetResultsTime: 0 - HTResizeTime: 0 - HashBuckets: 0 - InactiveTotalTime: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 0 - PeakMemoryUsage: 8400896 - RowsRepartitioned: 0 - RowsReturned: 1 - RowsReturnedRate: 0 - SpilledPartitions: 0 - TotalTime: 183578681401 HDFS_SCAN_NODE (id=0) ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 185 Hdfs split stats (:<# splits>/): -1:185/18.86 GB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0.2732% 2:4.645% 3:24.04% 4:71.04% File Formats: PARQUET/NONE:185 - AverageHdfsReadThreadConcurrency: 3.978142076502732 - AverageScannerThreadConcurrency: 4.98087431693989 - BytesRead: 2204427667 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 1 - NumRowGroups: 263 - NumScannerThreadsStarted: 5 - PeakMemoryUsage: 86084208 - PerReadThreadRawHdfsThroughput: 3046854 - RemoteScanRanges: 0 - RowsRead: 287702863 - RowsReturned: 762 - RowsReturnedRate: 4 - ScanRangesComplete: 185 - ScannerThreadsInvoluntaryContextSwitches: 10853 - ScannerThreadsTotalWallClockTime: 912398266274 - MaterializeTupleTime(*): 15395393005 - ScannerThreadsSysTime: 4710281000 - ScannerThreadsUserTime: 9335579000 - ScannerThreadsVoluntaryContextSwitches: 1432 - TotalRawHdfsReadTime(*): 723509447144 - TotalReadThroughput: 12006712 - TotalTime: 180075592098 Instance d044245554d166fb:2c648907a82766a7 (host=impala-sailesh-s3-5.vpc.cloudera.com:22000) Hdfs split stats (:<# splits>/): -1:185/18.95 GB - AverageThreadTokens: 5.959016393442623 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 87145928 - PerHostPeakMemUsage: 87145928 - PrepareTime: 170996100 - RowsProduced: 1 - TotalCpuTime: 908435698348 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 999978 - TotalStorageWaitTime: 891014087793 - TotalTime: 182957911266 BlockMgr - BlockWritesOutstanding: 0 - BlocksCreated: 0 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - InactiveTotalTime: 0 - MaxBlockSize: 8388608 - MemoryLimit: 11484461056 - PeakMemoryUsage: 0 - TotalBufferWaitTime: 0 - TotalEncryptionTime: 0 - TotalIntegrityCheckTime: 0 - TotalReadBlockTime: 0 - TotalTime: 0 CodeGen - CodegenTime: 0 - CompileTime: 5999864 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294144 - NumFunctions: 7 - NumInstructions: 104 - OptimizationTime: 41999041 - PrepareTime: 167996169 - TotalTime: 216995051 DataStreamSender (dst_id=2) - BytesSent: 16 - InactiveTotalTime: 0 - NetworkThroughput(*): 0 - OverallThroughput: 0 - PeakMemoryUsage: 16384 - RowsReturned: 1 - SerializeBatchTime: 0 - TotalTime: 0 - TransmitDataRPCTime: 0 - UncompressedRowBatchSize: 16 AGGREGATION_NODE (id=1) ExecOption: Codegen Enabled - BuildTime: 3345925180 - GetResultsTime: 0 - HTResizeTime: 0 - HashBuckets: 0 - InactiveTotalTime: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 0 - PeakMemoryUsage: 8442496 - RowsRepartitioned: 0 - RowsReturned: 1 - RowsReturnedRate: 0 - SpilledPartitions: 0 - TotalTime: 182953911355 HDFS_SCAN_NODE (id=0) ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 185 Hdfs split stats (:<# splits>/): -1:185/18.95 GB Hdfs Read Thread Concurrency Bucket: 0:0% 1:1.644% 2:5.753% 3:20.27% 4:72.33% File Formats: PARQUET/NONE:185 - AverageHdfsReadThreadConcurrency: 3.96986301369863 - AverageScannerThreadConcurrency: 4.972602739726027 - BytesRead: 2203176851 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 1 - NumRowGroups: 265 - NumScannerThreadsStarted: 5 - PeakMemoryUsage: 86044104 - PerReadThreadRawHdfsThroughput: 3055003 - RemoteScanRanges: 0 - RowsRead: 287621772 - RowsReturned: 729 - RowsReturnedRate: 4 - ScanRangesComplete: 185 - ScannerThreadsInvoluntaryContextSwitches: 10185 - ScannerThreadsTotalWallClockTime: 908435698348 - MaterializeTupleTime(*): 15481653973 - ScannerThreadsSysTime: 4693284000 - ScannerThreadsUserTime: 9248592000 - ScannerThreadsVoluntaryContextSwitches: 1536 - TotalRawHdfsReadTime(*): 721169884600 - TotalReadThroughput: 12023222 - TotalTime: 179434990117 Instance d044245554d166fb:2c648907a82766a3 (host=impala-sailesh-s3-3.vpc.cloudera.com:22000) Hdfs split stats (:<# splits>/): -1:185/18.82 GB - AverageThreadTokens: 5.906849315068493 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 90072880 - PerHostPeakMemUsage: 90072880 - PrepareTime: 164992063 - RowsProduced: 1 - TotalCpuTime: 896708866249 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 1999904 - TotalStorageWaitTime: 880278656615 - TotalTime: 182418225274 BlockMgr - BlockWritesOutstanding: 0 - BlocksCreated: 0 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - InactiveTotalTime: 0 - MaxBlockSize: 8388608 - MemoryLimit: 11484461056 - PeakMemoryUsage: 0 - TotalBufferWaitTime: 0 - TotalEncryptionTime: 0 - TotalIntegrityCheckTime: 0 - TotalReadBlockTime: 0 - TotalTime: 0 CodeGen - CodegenTime: 0 - CompileTime: 5999712 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294144 - NumFunctions: 7 - NumInstructions: 104 - OptimizationTime: 37998173 - PrepareTime: 162992159 - TotalTime: 207989996 DataStreamSender (dst_id=2) - BytesSent: 16 - InactiveTotalTime: 0 - NetworkThroughput(*): 0 - OverallThroughput: 0 - PeakMemoryUsage: 16384 - RowsReturned: 1 - SerializeBatchTime: 0 - TotalTime: 0 - TransmitDataRPCTime: 0 - UncompressedRowBatchSize: 16 AGGREGATION_NODE (id=1) ExecOption: Codegen Enabled - BuildTime: 3103850672 - GetResultsTime: 0 - HTResizeTime: 0 - HashBuckets: 0 - InactiveTotalTime: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 0 - PeakMemoryUsage: 8443880 - RowsRepartitioned: 0 - RowsReturned: 1 - RowsReturnedRate: 0 - SpilledPartitions: 0 - TotalTime: 182411225610 HDFS_SCAN_NODE (id=0) ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 185 Hdfs split stats (:<# splits>/): -1:185/18.82 GB Hdfs Read Thread Concurrency Bucket: 0:0.2747% 1:1.099% 2:5.769% 3:21.7% 4:71.15% File Formats: PARQUET/NONE:185 - AverageHdfsReadThreadConcurrency: 3.9423076923076925 - AverageScannerThreadConcurrency: 4.920329670329671 - BytesRead: 2200440144 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 1 - NumRowGroups: 264 - NumScannerThreadsStarted: 5 - PeakMemoryUsage: 89790256 - PerReadThreadRawHdfsThroughput: 3075940 - RemoteScanRanges: 0 - RowsRead: 287079496 - RowsReturned: 756 - RowsReturnedRate: 4 - ScanRangesComplete: 185 - ScannerThreadsInvoluntaryContextSwitches: 8477 - ScannerThreadsTotalWallClockTime: 896708866249 - MaterializeTupleTime(*): 14721291854 - ScannerThreadsSysTime: 4139367000 - ScannerThreadsUserTime: 9176603000 - ScannerThreadsVoluntaryContextSwitches: 1452 - TotalRawHdfsReadTime(*): 715371589018 - TotalReadThroughput: 12086662 - TotalTime: 179139383019 Instance d044245554d166fb:2c648907a82766a1 (host=impala-sailesh-s3-9.vpc.cloudera.com:22000) Hdfs split stats (:<# splits>/): -1:185/19.28 GB - AverageThreadTokens: 5.93956043956044 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 95841000 - PerHostPeakMemUsage: 95841000 - PrepareTime: 168997620 - RowsProduced: 1 - TotalCpuTime: 899681333090 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 0 - TotalStorageWaitTime: 882419576134 - TotalTime: 181760440924 BlockMgr - BlockWritesOutstanding: 0 - BlocksCreated: 0 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - InactiveTotalTime: 0 - MaxBlockSize: 8388608 - MemoryLimit: 11484461056 - PeakMemoryUsage: 0 - TotalBufferWaitTime: 0 - TotalEncryptionTime: 0 - TotalIntegrityCheckTime: 0 - TotalReadBlockTime: 0 - TotalTime: 0 CodeGen - CodegenTime: 0 - CompileTime: 5999915 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294144 - NumFunctions: 7 - NumInstructions: 104 - OptimizationTime: 38999451 - PrepareTime: 167997635 - TotalTime: 212997001 DataStreamSender (dst_id=2) - BytesSent: 16 - InactiveTotalTime: 0 - NetworkThroughput(*): 0 - OverallThroughput: 0 - PeakMemoryUsage: 16384 - RowsReturned: 1 - SerializeBatchTime: 0 - TotalTime: 0 - TransmitDataRPCTime: 0 - UncompressedRowBatchSize: 16 AGGREGATION_NODE (id=1) ExecOption: Codegen Enabled - BuildTime: 3292953567 - GetResultsTime: 0 - HTResizeTime: 0 - HashBuckets: 0 - InactiveTotalTime: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 0 - PeakMemoryUsage: 8400896 - RowsRepartitioned: 0 - RowsReturned: 1 - RowsReturnedRate: 0 - SpilledPartitions: 0 - TotalTime: 181756440972 HDFS_SCAN_NODE (id=0) ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 185 Hdfs split stats (:<# splits>/): -1:185/19.28 GB Hdfs Read Thread Concurrency Bucket: 0:0.551% 1:0.8264% 2:5.51% 3:22.87% 4:70.25% File Formats: PARQUET/NONE:185 - AverageHdfsReadThreadConcurrency: 3.9421487603305785 - AverageScannerThreadConcurrency: 4.953168044077135 - BytesRead: 2252566663 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 1 - NumRowGroups: 266 - NumScannerThreadsStarted: 5 - PeakMemoryUsage: 94288616 - PerReadThreadRawHdfsThroughput: 3156566 - RemoteScanRanges: 0 - RowsRead: 293856481 - RowsReturned: 765 - RowsReturnedRate: 4 - ScanRangesComplete: 185 - ScannerThreadsInvoluntaryContextSwitches: 8031 - ScannerThreadsTotalWallClockTime: 899681333090 - MaterializeTupleTime(*): 15369783600 - ScannerThreadsSysTime: 4616295000 - ScannerThreadsUserTime: 9464559000 - ScannerThreadsVoluntaryContextSwitches: 1510 - TotalRawHdfsReadTime(*): 713612952691 - TotalReadThroughput: 12406877 - TotalTime: 178292489813 Instance d044245554d166fb:2c648907a82766a8 (host=impala-sailesh-s3-4.vpc.cloudera.com:22000) Hdfs split stats (:<# splits>/): -1:185/18.97 GB - AverageThreadTokens: 5.889204545454546 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 99004128 - PerHostPeakMemUsage: 99004128 - PrepareTime: 169997128 - RowsProduced: 1 - TotalCpuTime: 861740450164 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 1999966 - TotalStorageWaitTime: 844647738851 - TotalTime: 175626034700 BlockMgr - BlockWritesOutstanding: 0 - BlocksCreated: 0 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - InactiveTotalTime: 0 - MaxBlockSize: 8388608 - MemoryLimit: 11484461056 - PeakMemoryUsage: 0 - TotalBufferWaitTime: 0 - TotalEncryptionTime: 0 - TotalIntegrityCheckTime: 0 - TotalReadBlockTime: 0 - TotalTime: 0 CodeGen - CodegenTime: 1999966 - CompileTime: 5999899 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294144 - NumFunctions: 7 - NumInstructions: 104 - OptimizationTime: 38999341 - PrepareTime: 166997179 - TotalTime: 212996402 DataStreamSender (dst_id=2) - BytesSent: 16 - InactiveTotalTime: 0 - NetworkThroughput(*): 0 - OverallThroughput: 0 - PeakMemoryUsage: 16384 - RowsReturned: 1 - SerializeBatchTime: 0 - TotalTime: 0 - TransmitDataRPCTime: 0 - UncompressedRowBatchSize: 16 AGGREGATION_NODE (id=1) ExecOption: Codegen Enabled - BuildTime: 3288944485 - GetResultsTime: 0 - HTResizeTime: 0 - HashBuckets: 0 - InactiveTotalTime: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 0 - PeakMemoryUsage: 8400896 - RowsRepartitioned: 0 - RowsReturned: 1 - RowsReturnedRate: 0 - SpilledPartitions: 0 - TotalTime: 175619034816 HDFS_SCAN_NODE (id=0) ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 185 Hdfs split stats (:<# splits>/): -1:185/18.97 GB Hdfs Read Thread Concurrency Bucket: 0:0.5698% 1:1.994% 2:4.558% 3:24.5% 4:68.38% File Formats: PARQUET/NONE:185 - AverageHdfsReadThreadConcurrency: 3.871794871794872 - AverageScannerThreadConcurrency: 4.903133903133903 - BytesRead: 2205421323 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 1 - NumRowGroups: 265 - NumScannerThreadsStarted: 5 - PeakMemoryUsage: 98402016 - PerReadThreadRawHdfsThroughput: 3230352 - RemoteScanRanges: 0 - RowsRead: 287961996 - RowsReturned: 809 - RowsReturnedRate: 4 - ScanRangesComplete: 185 - ScannerThreadsInvoluntaryContextSwitches: 7880 - ScannerThreadsTotalWallClockTime: 861740450164 - MaterializeTupleTime(*): 15229742794 - ScannerThreadsSysTime: 4694284000 - ScannerThreadsUserTime: 9145608000 - ScannerThreadsVoluntaryContextSwitches: 1492 - TotalRawHdfsReadTime(*): 682718472783 - TotalReadThroughput: 12566503 - TotalTime: 172160093203 Instance d044245554d166fb:2c648907a82766a9 (host=impala-sailesh-s3-11.vpc.cloudera.com:22000) Hdfs split stats (:<# splits>/): -1:186/19.22 GB - AverageThreadTokens: 5.909657320872274 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 98294192 - PerHostPeakMemUsage: 98294192 - PrepareTime: 163995086 - RowsProduced: 1 - TotalCpuTime: 789328353542 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 1999942 - TotalStorageWaitTime: 771876876426 - TotalTime: 160407194575 BlockMgr - BlockWritesOutstanding: 0 - BlocksCreated: 0 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - InactiveTotalTime: 0 - MaxBlockSize: 8388608 - MemoryLimit: 11484461056 - PeakMemoryUsage: 0 - TotalBufferWaitTime: 0 - TotalEncryptionTime: 0 - TotalIntegrityCheckTime: 0 - TotalReadBlockTime: 0 - TotalTime: 0 CodeGen - CodegenTime: 0 - CompileTime: 4999850 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294144 - NumFunctions: 7 - NumInstructions: 104 - OptimizationTime: 36998892 - PrepareTime: 161995145 - TotalTime: 204993858 DataStreamSender (dst_id=2) - BytesSent: 16 - InactiveTotalTime: 0 - NetworkThroughput(*): 0 - OverallThroughput: 0 - PeakMemoryUsage: 16384 - RowsReturned: 1 - SerializeBatchTime: 0 - TotalTime: 0 - TransmitDataRPCTime: 0 - UncompressedRowBatchSize: 16 AGGREGATION_NODE (id=1) ExecOption: Codegen Enabled - BuildTime: 3158905346 - GetResultsTime: 0 - HTResizeTime: 0 - HashBuckets: 0 - InactiveTotalTime: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 0 - PeakMemoryUsage: 8425408 - RowsRepartitioned: 0 - RowsReturned: 1 - RowsReturnedRate: 0 - SpilledPartitions: 0 - TotalTime: 160400194781 HDFS_SCAN_NODE (id=0) ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 186 Hdfs split stats (:<# splits>/): -1:186/19.22 GB Hdfs Read Thread Concurrency Bucket: 0:0.3125% 1:3.75% 2:7.812% 3:26.25% 4:61.88% File Formats: PARQUET/NONE:186 - AverageHdfsReadThreadConcurrency: 3.696875 - AverageScannerThreadConcurrency: 4.925 - BytesRead: 2233735932 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 1 - NumRowGroups: 266 - NumScannerThreadsStarted: 5 - PeakMemoryUsage: 96479664 - PerReadThreadRawHdfsThroughput: 3724848 - RemoteScanRanges: 0 - RowsRead: 291774307 - RowsReturned: 778 - RowsReturnedRate: 4 - ScanRangesComplete: 186 - ScannerThreadsInvoluntaryContextSwitches: 8992 - ScannerThreadsTotalWallClockTime: 789328353542 - MaterializeTupleTime(*): 15610532304 - ScannerThreadsSysTime: 4462320000 - ScannerThreadsUserTime: 9453560000 - ScannerThreadsVoluntaryContextSwitches: 1551 - TotalRawHdfsReadTime(*): 599685034803 - TotalReadThroughput: 13883985 - TotalTime: 157074294439