Query (id=e14657a44694bcce:497373fa27d84a4) Summary Session ID: 94468faee8a0f606:19f4d8b7c474cb6 Session Type: BEESWAX Start Time: 2016-05-05 22:25:48.304828000 End Time: 2016-05-05 22:30:03.110180000 Query Type: QUERY Query State: FINISHED Query Status: OK Impala Version: impalad version 2.6.0-cdh5-INTERNAL RELEASE (build e2998c52c37e669606583727793b40d984eb6085) User: systest Connected User: systest Delegated User: Network Address: ::ffff:172.26.8.98:35381 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: the ---------------- 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 3s393ms 4s836ms 10 1 8.94 MB 10.00 MB 00:SCAN HDFS 10 3m3s 4m10s 7.69K -1 87.18 MB 88.00 MB tpcds_1000_parquet.store_sales Planner Timeline Analysis finished: 14321598 Equivalence classes computed: 14578980 Single node plan created: 37092513 Runtime filters computed: 37126990 Distributed plan created: 38266424 Lineage info computed: 38921399 Planning finished: 76971445 Query Timeline Start execution: 0 Planning finished: 136997032 Submit for admission: 141996923 Completed admission: 141996923 Ready to start 10 remote fragments: 313993196 All 10 remote fragments started: 438990488 Rows available: 253881499648 First row fetched: 254802479700 Unregister query: 254804479658 ImpalaServer - ClientFetchWaitTimer: 922980010 - InactiveTotalTime: 0 - RowMaterializationTimer: 0 - TotalTime: 0 Execution Profile e14657a44694bcce:497373fa27d84a4 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: 30ms, 50th %-ile: 32ms, 75th %-ile: 37ms, 90th %-ile: 41ms, 95th %-ile: 59ms, 99.9th %-ile: 59ms Per Node Peak Memory Usage: impala-sailesh-s3-10.vpc.cloudera.com:22000(81.76 MB) impala-sailesh-s3-3.vpc.cloudera.com:22000(81.68 MB) impala-sailesh-s3-8.vpc.cloudera.com:22000(82.82 MB) impala-sailesh-s3-9.vpc.cloudera.com:22000(87.90 MB) impala-sailesh-s3-6.vpc.cloudera.com:22000(87.32 MB) impala-sailesh-s3-7.vpc.cloudera.com:22000(82.20 MB) impala-sailesh-s3-5.vpc.cloudera.com:22000(83.31 MB) impala-sailesh-s3-4.vpc.cloudera.com:22000(89.07 MB) impala-sailesh-s3-11.vpc.cloudera.com:22000(86.68 MB) impala-sailesh-s3-2.vpc.cloudera.com:22000(44.52 MB) - FiltersReceived: 0 - FinalizationTimer: 0 - InactiveTotalTime: 0 - TotalTime: 253732502878 Coordinator Fragment F01 - AverageThreadTokens: 1.0 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 61456 - PerHostPeakMemUsage: 0 - PrepareTime: 168996338 - RowsProduced: 1 - TotalCpuTime: 1281972230 - TotalNetworkReceiveTime: 253375510612 - TotalNetworkSendTime: 0 - TotalStorageWaitTime: 0 - TotalTime: 253545506928 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: 999979 - CompileTime: 6999849 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294268 - NumFunctions: 4 - NumInstructions: 56 - OptimizationTime: 54998809 - PrepareTime: 166996381 - TotalTime: 229995017 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: 253545506928 EXCHANGE_NODE (id=2) - BytesReceived: 160 - ConvertRowBatchTime: 0 - DeserializeRowBatchTimer: 0 - FirstBatchArrivalWaitTime: 161884492513 - InactiveTotalTime: 253375510612 - PeakMemoryUsage: 0 - RowsReturned: 10 - RowsReturnedRate: 0 - SendersBlockedTimer: 0 - SendersBlockedTotalTimer(*): 0 - TotalTime: 253375510612 Averaged Fragment F00 split sizes: min: 18.04 GB, max: 24.69 GB, avg: 18.92 GB, stddev: 1.93 GB completion times: min:2m41s max:4m13s mean: 3m7s stddev:28s652ms execution rates: min:72.89 MB/sec max:114.91 MB/sec mean:104.89 MB/sec stddev:11.07 MB/sec num instances: 10 - AverageThreadTokens: 5.549741582721818 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 84646386 - PerHostPeakMemUsage: 84647615 - PrepareTime: 170697872 - RowsProduced: 1 - TotalCpuTime: 826295180389 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 999990 - TotalStorageWaitTime: 809618992926 - TotalTime: 187053813573 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: 5699934 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294268 - NumFunctions: 7 - NumInstructions: 104 - OptimizationTime: 39599494 - PrepareTime: 168497903 - TotalTime: 214697318 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: 3217258638 - GetResultsTime: 0 - HTResizeTime: 0 - HashBuckets: 0 - InactiveTotalTime: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 0 - PeakMemoryUsage: 8593959 - RowsRepartitioned: 0 - RowsReturned: 1 - RowsReturnedRate: 0 - SpilledPartitions: 0 - TotalTime: 187048113644 HDFS_SCAN_NODE (id=0) - AverageHdfsReadThreadConcurrency: 3.606126288690058 - AverageScannerThreadConcurrency: 4.549741582721819 - BytesRead: 2206054355 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 1 - NumRowGroups: 264 - NumScannerThreadsStarted: 4 - PeakMemoryUsage: 83042765 - PerReadThreadRawHdfsThroughput: 3475960 - RemoteScanRanges: 0 - RowsRead: 287998799 - RowsReturned: 769 - RowsReturnedRate: 3 - ScanRangesComplete: 182 - ScannerThreadsInvoluntaryContextSwitches: 8501 - ScannerThreadsTotalWallClockTime: 826295180389 - MaterializeTupleTime(*): 14842209958 - ScannerThreadsSysTime: 4489115100 - ScannerThreadsUserTime: 9113812100 - ScannerThreadsVoluntaryContextSwitches: 1458 - TotalRawHdfsReadTime(*): 653523627138 - TotalReadThroughput: 11882225 - TotalTime: 183655057183 Fragment F00 Instance e14657a44694bcce:497373fa27d84ae (host=impala-sailesh-s3-2.vpc.cloudera.com:22000) Hdfs split stats (:<# splits>/): -1:183/18.04 GB - AverageThreadTokens: 2.998027613412229 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 46672536 - PerHostPeakMemUsage: 46684824 - PrepareTime: 185995971 - RowsProduced: 1 - TotalCpuTime: 506310030784 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 0 - TotalStorageWaitTime: 491816344854 - TotalTime: 253393510222 CodeGen - CodegenTime: 0 - CompileTime: 2999936 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294268 - NumFunctions: 7 - NumInstructions: 104 - OptimizationTime: 44999024 - PrepareTime: 183996014 - TotalTime: 232994952 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: 2995935120 - 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: 253388510332 HDFS_SCAN_NODE (id=0) ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 183 Hdfs split stats (:<# splits>/): -1:183/18.04 GB Hdfs Read Thread Concurrency Bucket: 0:7.692% 1:39.05% 2:53.25% 3:0% 4:0% File Formats: PARQUET/NONE:183 - AverageHdfsReadThreadConcurrency: 1.455621301775148 - AverageScannerThreadConcurrency: 1.9980276134122288 - BytesRead: 2073033231 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 1 - NumRowGroups: 258 - NumScannerThreadsStarted: 2 - PeakMemoryUsage: 44613744 - PerReadThreadRawHdfsThroughput: 5560846 - RemoteScanRanges: 0 - RowsRead: 271242276 - RowsReturned: 742 - RowsReturnedRate: 2 - ScanRangesComplete: 183 - ScannerThreadsInvoluntaryContextSwitches: 4367 - ScannerThreadsTotalWallClockTime: 506310030784 - MaterializeTupleTime(*): 12836721863 - ScannerThreadsSysTime: 4127372000 - ScannerThreadsUserTime: 8574696000 - ScannerThreadsVoluntaryContextSwitches: 1446 - TotalRawHdfsReadTime(*): 372790923146 - TotalReadThroughput: 8152312 - TotalTime: 250200579373 Instance e14657a44694bcce:497373fa27d84a6 (host=impala-sailesh-s3-11.vpc.cloudera.com:22000) Hdfs split stats (:<# splits>/): -1:182/24.69 GB - AverageThreadTokens: 4.93304535637149 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 90888976 - PerHostPeakMemUsage: 90888976 - PrepareTime: 164995097 - RowsProduced: 1 - TotalCpuTime: 910156955020 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 999970 - TotalStorageWaitTime: 886393661195 - TotalTime: 231661116115 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: 4999851 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294268 - NumFunctions: 7 - NumInstructions: 104 - OptimizationTime: 38998842 - PrepareTime: 161995185 - TotalTime: 206993849 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: 4669861247 - GetResultsTime: 0 - HTResizeTime: 0 - HashBuckets: 0 - InactiveTotalTime: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 0 - PeakMemoryUsage: 9159744 - RowsRepartitioned: 0 - RowsReturned: 1 - RowsReturnedRate: 0 - SpilledPartitions: 0 - TotalTime: 231654116323 HDFS_SCAN_NODE (id=0) ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 182 Hdfs split stats (:<# splits>/): -1:182/24.69 GB Hdfs Read Thread Concurrency Bucket: 0:10.8% 1:16.2% 2:4.752% 3:16.85% 4:51.4% File Formats: PARQUET/NONE:182 - AverageHdfsReadThreadConcurrency: 3.0323974082073435 - AverageScannerThreadConcurrency: 3.9330453563714904 - BytesRead: 3150463526 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 1 - NumRowGroups: 311 - NumScannerThreadsStarted: 5 - PeakMemoryUsage: 89787152 - PerReadThreadRawHdfsThroughput: 4473183 - RemoteScanRanges: 0 - RowsRead: 405996048 - RowsReturned: 1091 - RowsReturnedRate: 4 - ScanRangesComplete: 182 - ScannerThreadsInvoluntaryContextSwitches: 11058 - ScannerThreadsTotalWallClockTime: 910156955020 - MaterializeTupleTime(*): 21753353626 - ScannerThreadsSysTime: 6594995000 - ScannerThreadsUserTime: 13266980000 - ScannerThreadsVoluntaryContextSwitches: 1774 - TotalRawHdfsReadTime(*): 704300071871 - TotalReadThroughput: 13570690 - TotalTime: 226817260039 Instance e14657a44694bcce:497373fa27d84aa (host=impala-sailesh-s3-6.vpc.cloudera.com:22000) Hdfs split stats (:<# splits>/): -1:182/18.47 GB - AverageThreadTokens: 5.9805013927576605 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 91560712 - PerHostPeakMemUsage: 91560712 - PrepareTime: 168004004 - RowsProduced: 1 - TotalCpuTime: 893340279804 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 0 - TotalStorageWaitTime: 876371875675 - TotalTime: 179639279088 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: 6000144 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294268 - NumFunctions: 7 - NumInstructions: 104 - OptimizationTime: 39000929 - PrepareTime: 166003955 - TotalTime: 212005053 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: 3225076822 - 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: 179635278991 HDFS_SCAN_NODE (id=0) ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 182 Hdfs split stats (:<# splits>/): -1:182/18.47 GB Hdfs Read Thread Concurrency Bucket: 0:0.2786% 1:0.2786% 2:5.571% 3:18.38% 4:75.49% File Formats: PARQUET/NONE:182 - AverageHdfsReadThreadConcurrency: 4.011142061281337 - AverageScannerThreadConcurrency: 4.9805013927576605 - BytesRead: 2123227662 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 1 - NumRowGroups: 260 - NumScannerThreadsStarted: 5 - PeakMemoryUsage: 89418504 - PerReadThreadRawHdfsThroughput: 2957071 - RemoteScanRanges: 0 - RowsRead: 277732726 - RowsReturned: 692 - RowsReturnedRate: 3 - ScanRangesComplete: 182 - ScannerThreadsInvoluntaryContextSwitches: 9306 - ScannerThreadsTotalWallClockTime: 893340279804 - MaterializeTupleTime(*): 15084359259 - ScannerThreadsSysTime: 4382331000 - ScannerThreadsUserTime: 8961635000 - ScannerThreadsVoluntaryContextSwitches: 1390 - TotalRawHdfsReadTime(*): 718017103582 - TotalReadThroughput: 11782828 - TotalTime: 176233197953 Instance e14657a44694bcce:497373fa27d84ab (host=impala-sailesh-s3-9.vpc.cloudera.com:22000) Hdfs split stats (:<# splits>/): -1:183/18.59 GB - AverageThreadTokens: 5.92436974789916 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 92171928 - PerHostPeakMemUsage: 92171928 - PrepareTime: 168997518 - RowsProduced: 1 - TotalCpuTime: 878491071800 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 0 - TotalStorageWaitTime: 862583305969 - TotalTime: 178419374254 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: 6999897 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294268 - NumFunctions: 7 - NumInstructions: 104 - OptimizationTime: 36999455 - PrepareTime: 166997548 - TotalTime: 211996885 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: 3142953709 - GetResultsTime: 0 - HTResizeTime: 0 - HashBuckets: 0 - InactiveTotalTime: 0 - LargestPartitionPercent: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 0 - PeakMemoryUsage: 9375008 - RowsRepartitioned: 0 - RowsReturned: 1 - RowsReturnedRate: 0 - SpilledPartitions: 0 - TotalTime: 178415374314 HDFS_SCAN_NODE (id=0) ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 183 Hdfs split stats (:<# splits>/): -1:183/18.59 GB Hdfs Read Thread Concurrency Bucket: 0:0.8403% 1:1.401% 2:5.602% 3:19.89% 4:72.27% File Formats: PARQUET/NONE:183 - AverageHdfsReadThreadConcurrency: 3.9271708683473388 - AverageScannerThreadConcurrency: 4.92436974789916 - BytesRead: 2136617154 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 1 - NumRowGroups: 262 - NumScannerThreadsStarted: 5 - PeakMemoryUsage: 90209944 - PerReadThreadRawHdfsThroughput: 3029534 - RemoteScanRanges: 0 - RowsRead: 279473581 - RowsReturned: 773 - RowsReturnedRate: 4 - ScanRangesComplete: 183 - ScannerThreadsInvoluntaryContextSwitches: 7369 - ScannerThreadsTotalWallClockTime: 878491071800 - MaterializeTupleTime(*): 14000793909 - ScannerThreadsSysTime: 4279347000 - ScannerThreadsUserTime: 8696676000 - ScannerThreadsVoluntaryContextSwitches: 1526 - TotalRawHdfsReadTime(*): 705262621278 - TotalReadThroughput: 11969642 - TotalTime: 175088423307 Instance e14657a44694bcce:497373fa27d84ac (host=impala-sailesh-s3-8.vpc.cloudera.com:22000) Hdfs split stats (:<# splits>/): -1:182/18.32 GB - AverageThreadTokens: 5.99438202247191 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 86841424 - PerHostPeakMemUsage: 86841424 - PrepareTime: 167002116 - RowsProduced: 1 - TotalCpuTime: 888728228606 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 1000012 - TotalStorageWaitTime: 872524024017 - TotalTime: 178186251284 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: 6000076 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294268 - NumFunctions: 7 - NumInstructions: 104 - OptimizationTime: 38000482 - PrepareTime: 166002103 - TotalTime: 210002661 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: 3150039773 - 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: 178180251208 HDFS_SCAN_NODE (id=0) ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 182 Hdfs split stats (:<# splits>/): -1:182/18.32 GB Hdfs Read Thread Concurrency Bucket: 0:0.2809% 1:0.8427% 2:4.213% 3:15.73% 4:78.93% File Formats: PARQUET/NONE:182 - AverageHdfsReadThreadConcurrency: 4.087078651685394 - AverageScannerThreadConcurrency: 4.99438202247191 - BytesRead: 2105735738 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 1 - NumRowGroups: 259 - NumScannerThreadsStarted: 5 - PeakMemoryUsage: 86192392 - PerReadThreadRawHdfsThroughput: 2930709 - RemoteScanRanges: 0 - RowsRead: 275474765 - RowsReturned: 760 - RowsReturnedRate: 4 - ScanRangesComplete: 182 - ScannerThreadsInvoluntaryContextSwitches: 9821 - ScannerThreadsTotalWallClockTime: 888728228606 - MaterializeTupleTime(*): 14323180837 - ScannerThreadsSysTime: 4396329000 - ScannerThreadsUserTime: 8675679000 - ScannerThreadsVoluntaryContextSwitches: 1389 - TotalRawHdfsReadTime(*): 718507078411 - TotalReadThroughput: 11721821 - TotalTime: 174861209295 Instance e14657a44694bcce:497373fa27d84af (host=impala-sailesh-s3-10.vpc.cloudera.com:22000) Hdfs split stats (:<# splits>/): -1:183/18.39 GB - AverageThreadTokens: 5.968926553672317 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 85733920 - PerHostPeakMemUsage: 85733920 - PrepareTime: 168002955 - RowsProduced: 1 - TotalCpuTime: 879564458553 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 3000053 - TotalStorageWaitTime: 863635178616 - TotalTime: 177374117384 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: 6000106 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294268 - NumFunctions: 7 - NumInstructions: 104 - OptimizationTime: 37000650 - PrepareTime: 165002900 - TotalTime: 209003674 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: 2925051436 - 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: 177367117262 HDFS_SCAN_NODE (id=0) ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 183 Hdfs split stats (:<# splits>/): -1:183/18.39 GB Hdfs Read Thread Concurrency Bucket: 0:0.565% 1:0.8475% 2:7.062% 3:19.21% 4:72.32% File Formats: PARQUET/NONE:183 - AverageHdfsReadThreadConcurrency: 3.994350282485876 - AverageScannerThreadConcurrency: 4.968926553672317 - BytesRead: 2113679124 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 1 - NumRowGroups: 260 - NumScannerThreadsStarted: 5 - PeakMemoryUsage: 84189728 - PerReadThreadRawHdfsThroughput: 2992691 - RemoteScanRanges: 0 - RowsRead: 276522297 - RowsReturned: 746 - RowsReturnedRate: 4 - ScanRangesComplete: 183 - ScannerThreadsInvoluntaryContextSwitches: 9873 - ScannerThreadsTotalWallClockTime: 879564458553 - MaterializeTupleTime(*): 14222249950 - ScannerThreadsSysTime: 4029385000 - ScannerThreadsUserTime: 8785661000 - ScannerThreadsVoluntaryContextSwitches: 1345 - TotalRawHdfsReadTime(*): 706280413107 - TotalReadThroughput: 11937175 - TotalTime: 174270062803 Instance e14657a44694bcce:497373fa27d84a8 (host=impala-sailesh-s3-5.vpc.cloudera.com:22000) Hdfs split stats (:<# splits>/): -1:182/18.05 GB - AverageThreadTokens: 5.898550724637682 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 87358480 - PerHostPeakMemUsage: 87358480 - PrepareTime: 174995986 - RowsProduced: 1 - TotalCpuTime: 844349611591 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 999977 - TotalStorageWaitTime: 828619972905 - TotalTime: 172453039956 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: 5999860 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294268 - NumFunctions: 7 - NumInstructions: 104 - OptimizationTime: 40999061 - PrepareTime: 172996033 - TotalTime: 220994930 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: 3047930030 - 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: 172449040048 HDFS_SCAN_NODE (id=0) ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 182 Hdfs split stats (:<# splits>/): -1:182/18.05 GB Hdfs Read Thread Concurrency Bucket: 0:0.8696% 1:1.449% 2:5.217% 3:23.19% 4:69.28% File Formats: PARQUET/NONE:182 - AverageHdfsReadThreadConcurrency: 3.8550724637681157 - AverageScannerThreadConcurrency: 4.898550724637682 - BytesRead: 2073508418 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 1 - NumRowGroups: 257 - NumScannerThreadsStarted: 5 - PeakMemoryUsage: 86232080 - PerReadThreadRawHdfsThroughput: 3110029 - RemoteScanRanges: 0 - RowsRead: 271313937 - RowsReturned: 719 - RowsReturnedRate: 4 - ScanRangesComplete: 182 - ScannerThreadsInvoluntaryContextSwitches: 8668 - ScannerThreadsTotalWallClockTime: 844349611591 - MaterializeTupleTime(*): 13784683379 - ScannerThreadsSysTime: 4394330000 - ScannerThreadsUserTime: 8381724000 - ScannerThreadsVoluntaryContextSwitches: 1483 - TotalRawHdfsReadTime(*): 666716690589 - TotalReadThroughput: 12016938 - TotalTime: 169223114102 Instance e14657a44694bcce:497373fa27d84a7 (host=impala-sailesh-s3-4.vpc.cloudera.com:22000) Hdfs split stats (:<# splits>/): -1:182/18.12 GB - AverageThreadTokens: 5.882005899705015 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 93391824 - PerHostPeakMemUsage: 93391824 - PrepareTime: 167997199 - RowsProduced: 1 - TotalCpuTime: 827489293326 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 1999968 - TotalStorageWaitTime: 811668555408 - TotalTime: 169513192160 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: 5999900 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294268 - NumFunctions: 7 - NumInstructions: 104 - OptimizationTime: 39999333 - PrepareTime: 165997231 - TotalTime: 212996448 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: 3061949262 - 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: 169505192293 HDFS_SCAN_NODE (id=0) ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 182 Hdfs split stats (:<# splits>/): -1:182/18.12 GB Hdfs Read Thread Concurrency Bucket: 0:0.59% 1:2.065% 2:6.785% 3:19.17% 4:71.39% File Formats: PARQUET/NONE:182 - AverageHdfsReadThreadConcurrency: 3.8790560471976403 - AverageScannerThreadConcurrency: 4.882005899705015 - BytesRead: 2081476127 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 1 - NumRowGroups: 257 - NumScannerThreadsStarted: 5 - PeakMemoryUsage: 91413456 - PerReadThreadRawHdfsThroughput: 3193803 - RemoteScanRanges: 0 - RowsRead: 272377640 - RowsReturned: 672 - RowsReturnedRate: 4 - ScanRangesComplete: 182 - ScannerThreadsInvoluntaryContextSwitches: 7833 - ScannerThreadsTotalWallClockTime: 827489293326 - MaterializeTupleTime(*): 13980768394 - ScannerThreadsSysTime: 4269348000 - ScannerThreadsUserTime: 8546698000 - ScannerThreadsVoluntaryContextSwitches: 1392 - TotalRawHdfsReadTime(*): 651723205179 - TotalReadThroughput: 12231571 - TotalTime: 166270245914 Instance e14657a44694bcce:497373fa27d84a9 (host=impala-sailesh-s3-7.vpc.cloudera.com:22000) Hdfs split stats (:<# splits>/): -1:182/18.39 GB - AverageThreadTokens: 5.970238095238095 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 86191592 - PerHostPeakMemUsage: 86191592 - PrepareTime: 172995869 - RowsProduced: 1 - TotalCpuTime: 835034016812 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 999976 - TotalStorageWaitTime: 818717407360 - TotalTime: 167971980589 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: 5999857 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294268 - NumFunctions: 7 - NumInstructions: 104 - OptimizationTime: 40999021 - PrepareTime: 170995916 - TotalTime: 218994770 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: 3071926505 - 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: 167964980750 HDFS_SCAN_NODE (id=0) ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 182 Hdfs split stats (:<# splits>/): -1:182/18.39 GB Hdfs Read Thread Concurrency Bucket: 0:0.2976% 1:0.8929% 2:5.952% 3:20.24% 4:72.62% File Formats: PARQUET/NONE:182 - AverageHdfsReadThreadConcurrency: 3.949404761904762 - AverageScannerThreadConcurrency: 4.970238095238095 - BytesRead: 2113687727 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 1 - NumRowGroups: 259 - NumScannerThreadsStarted: 5 - PeakMemoryUsage: 85343720 - PerReadThreadRawHdfsThroughput: 3183805 - RemoteScanRanges: 0 - RowsRead: 276542004 - RowsReturned: 748 - RowsReturnedRate: 4 - ScanRangesComplete: 182 - ScannerThreadsInvoluntaryContextSwitches: 9148 - ScannerThreadsTotalWallClockTime: 835034016812 - MaterializeTupleTime(*): 14511652715 - ScannerThreadsSysTime: 4533307000 - ScannerThreadsUserTime: 8566694000 - ScannerThreadsVoluntaryContextSwitches: 1370 - TotalRawHdfsReadTime(*): 663887113743 - TotalReadThroughput: 12543143 - TotalTime: 164720058378 Instance e14657a44694bcce:497373fa27d84ad (host=impala-sailesh-s3-3.vpc.cloudera.com:22000) Hdfs split stats (:<# splits>/): -1:183/18.18 GB - AverageThreadTokens: 5.947368421052632 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 85652472 - PerHostPeakMemUsage: 85652472 - PrepareTime: 167992006 - RowsProduced: 1 - TotalCpuTime: 799487857603 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 999953 - TotalStorageWaitTime: 783859603267 - TotalTime: 161926274683 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: 5999713 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294268 - NumFunctions: 7 - NumInstructions: 104 - OptimizationTime: 38998146 - PrepareTime: 164992150 - TotalTime: 210989961 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: 2881862477 - 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: 161921274919 HDFS_SCAN_NODE (id=0) ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 183 Hdfs split stats (:<# splits>/): -1:183/18.18 GB Hdfs Read Thread Concurrency Bucket: 0:0.3096% 1:1.548% 2:4.954% 3:25.39% 4:67.8% File Formats: PARQUET/NONE:183 - AverageHdfsReadThreadConcurrency: 3.869969040247678 - AverageScannerThreadConcurrency: 4.947368421052632 - BytesRead: 2089114843 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 1 - NumRowGroups: 259 - NumScannerThreadsStarted: 5 - PeakMemoryUsage: 83026936 - PerReadThreadRawHdfsThroughput: 3327935 - RemoteScanRanges: 0 - RowsRead: 273312725 - RowsReturned: 751 - RowsReturnedRate: 4 - ScanRangesComplete: 183 - ScannerThreadsInvoluntaryContextSwitches: 7572 - ScannerThreadsTotalWallClockTime: 799487857603 - MaterializeTupleTime(*): 13924335651 - ScannerThreadsSysTime: 3884407000 - ScannerThreadsUserTime: 8681678000 - ScannerThreadsVoluntaryContextSwitches: 1472 - TotalRawHdfsReadTime(*): 627751050480 - TotalReadThroughput: 12896138 - TotalTime: 158866420674