Query (id=9a46183118493373:ea67bd3b607007b5) Summary Session ID: 77418689a3293e2f:52d367771e4aeaa4 Session Type: BEESWAX Start Time: 2016-05-05 23:54:53.179289000 End Time: 2016-05-05 23:59:12.084553000 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:41525 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 183.995ms 183.995ms 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 3s442ms 3s792ms 10 1 8.01 MB 10.00 MB 00:SCAN HDFS 10 2m59s 4m14s 7.69K -1 88.66 MB 88.00 MB tpcds_1000_parquet.store_sales Planner Timeline Analysis finished: 12945430 Equivalence classes computed: 13197167 Single node plan created: 62768371 Runtime filters computed: 62833027 Distributed plan created: 64508515 Lineage info computed: 65449192 Planning finished: 137399471 Query Timeline Start execution: 0 Planning finished: 212995224 Submit for admission: 219995067 Completed admission: 219995067 Ready to start 10 remote fragments: 406990875 All 10 remote fragments started: 525988202 Rows available: 258457209152 First row fetched: 258902199180 Unregister query: 258905199124 ImpalaServer - ClientFetchWaitTimer: 445990009 - InactiveTotalTime: 0 - RowMaterializationTimer: 0 - TotalTime: 0 Execution Profile 9a46183118493373:ea67bd3b607007b5 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: 26ms, 50th %-ile: 32ms, 75th %-ile: 36ms, 90th %-ile: 38ms, 95th %-ile: 46ms, 99.9th %-ile: 46ms Per Node Peak Memory Usage: impala-sailesh-s3-10.vpc.cloudera.com:22000(85.77 MB) impala-sailesh-s3-6.vpc.cloudera.com:22000(89.79 MB) impala-sailesh-s3-8.vpc.cloudera.com:22000(85.77 MB) impala-sailesh-s3-3.vpc.cloudera.com:22000(84.01 MB) impala-sailesh-s3-11.vpc.cloudera.com:22000(87.81 MB) impala-sailesh-s3-4.vpc.cloudera.com:22000(79.77 MB) impala-sailesh-s3-5.vpc.cloudera.com:22000(89.63 MB) impala-sailesh-s3-7.vpc.cloudera.com:22000(78.24 MB) impala-sailesh-s3-9.vpc.cloudera.com:22000(78.72 MB) impala-sailesh-s3-2.vpc.cloudera.com:22000(50.09 MB) - FiltersReceived: 0 - FinalizationTimer: 0 - InactiveTotalTime: 0 - TotalTime: 258232214199 Coordinator Fragment F01 - AverageThreadTokens: 0.0 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 61456 - PerHostPeakMemUsage: 0 - PrepareTime: 183995876 - RowsProduced: 1 - TotalCpuTime: 814981737 - TotalNetworkReceiveTime: 257865222424 - TotalNetworkSendTime: 0 - TotalStorageWaitTime: 0 - TotalTime: 258049218301 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: 6999844 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294144 - NumFunctions: 4 - NumInstructions: 56 - OptimizationTime: 54998764 - PrepareTime: 181995918 - TotalTime: 244994505 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: 258049218301 EXCHANGE_NODE (id=2) - BytesReceived: 160 - ConvertRowBatchTime: 0 - DeserializeRowBatchTimer: 0 - FirstBatchArrivalWaitTime: 168503223566 - InactiveTotalTime: 257865222424 - PeakMemoryUsage: 0 - RowsReturned: 10 - RowsReturnedRate: 0 - SendersBlockedTimer: 0 - SendersBlockedTotalTimer(*): 0 - TotalTime: 257865222424 Averaged Fragment F00 split sizes: min: 18.05 GB, max: 19.82 GB, avg: 18.92 GB, stddev: 728.82 MB completion times: min:2m48s max:4m17s mean: 3m3s stddev:25s142ms execution rates: min:77.20 MB/sec max:114.14 MB/sec mean:107.18 MB/sec stddev:10.42 MB/sec num instances: 10 - AverageThreadTokens: 5.648394520131978 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 84886664 - PerHostPeakMemUsage: 84892399 - PrepareTime: 174097861 - RowsProduced: 1 - TotalCpuTime: 828721676062 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 1199981 - TotalStorageWaitTime: 811346685534 - TotalTime: 183048844708 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: 599985 - CompileTime: 5599932 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294144 - NumFunctions: 7 - NumInstructions: 104 - OptimizationTime: 39399527 - PrepareTime: 171397899 - TotalTime: 217197352 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: 3265061202 - 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: 183042844790 HDFS_SCAN_NODE (id=0) - AverageHdfsReadThreadConcurrency: 3.6120701309282857 - AverageScannerThreadConcurrency: 4.651635263104713 - BytesRead: 2214430675 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 1 - NumRowGroups: 264 - NumScannerThreadsStarted: 4 - PeakMemoryUsage: 83778940 - PerReadThreadRawHdfsThroughput: 3567124 - RemoteScanRanges: 0 - RowsRead: 287998799 - RowsReturned: 769 - RowsReturnedRate: 3 - ScanRangesComplete: 264 - ScannerThreadsInvoluntaryContextSwitches: 9083 - ScannerThreadsTotalWallClockTime: 828721676062 - MaterializeTupleTime(*): 15358714596 - ScannerThreadsSysTime: 4595399200 - ScannerThreadsUserTime: 9367873900 - ScannerThreadsVoluntaryContextSwitches: 1622 - TotalRawHdfsReadTime(*): 643010837093 - TotalReadThroughput: 12195094 - TotalTime: 179599985758 Fragment F00 Instance 9a46183118493373:ea67bd3b607007bc (host=impala-sailesh-s3-2.vpc.cloudera.com:22000) Hdfs split stats (:<# splits>/): -1:264/19.45 GB - AverageThreadTokens: 2.994186046511628 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 52466120 - PerHostPeakMemUsage: 52523472 - PrepareTime: 190995715 - RowsProduced: 1 - TotalCpuTime: 515109458759 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 0 - TotalStorageWaitTime: 497660849608 - TotalTime: 257895221753 CodeGen - CodegenTime: 999979 - CompileTime: 3999912 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294144 - NumFunctions: 7 - NumInstructions: 104 - OptimizationTime: 37999146 - PrepareTime: 187995780 - TotalTime: 230994815 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: 3319925588 - 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: 257886221952 HDFS_SCAN_NODE (id=0) ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 264 Hdfs split stats (:<# splits>/): -1:264/19.45 GB Hdfs Read Thread Concurrency Bucket: 0:10.68% 1:35.92% 2:53.4% 3:0% 4:0% File Formats: PARQUET/NONE:264 - AverageHdfsReadThreadConcurrency: 1.4271844660194175 - AverageScannerThreadConcurrency: 1.9980582524271844 - BytesRead: 2277145135 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 1 - NumRowGroups: 264 - NumScannerThreadsStarted: 2 - PeakMemoryUsage: 50357352 - PerReadThreadRawHdfsThroughput: 6161211 - RemoteScanRanges: 0 - RowsRead: 296189104 - RowsReturned: 479 - RowsReturnedRate: 1 - ScanRangesComplete: 264 - ScannerThreadsInvoluntaryContextSwitches: 5460 - ScannerThreadsTotalWallClockTime: 515109458759 - MaterializeTupleTime(*): 15427654449 - ScannerThreadsSysTime: 4944248000 - ScannerThreadsUserTime: 9715522000 - ScannerThreadsVoluntaryContextSwitches: 1795 - TotalRawHdfsReadTime(*): 369593718755 - TotalReadThroughput: 8785982 - TotalTime: 254374300673 Instance 9a46183118493373:ea67bd3b607007b8 (host=impala-sailesh-s3-7.vpc.cloudera.com:22000) Hdfs split stats (:<# splits>/): -1:264/19.42 GB - AverageThreadTokens: 5.980392156862745 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 82039872 - PerHostPeakMemUsage: 82039872 - PrepareTime: 175995414 - RowsProduced: 1 - TotalCpuTime: 890144724013 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 1999948 - TotalStorageWaitTime: 872701180239 - TotalTime: 178602329793 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: 999974 - CompileTime: 5999844 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294144 - NumFunctions: 7 - NumInstructions: 104 - OptimizationTime: 41998905 - PrepareTime: 172995492 - TotalTime: 221994215 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: 3384911447 - 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: 178595329976 HDFS_SCAN_NODE (id=0) ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 264 Hdfs split stats (:<# splits>/): -1:264/19.42 GB Hdfs Read Thread Concurrency Bucket: 0:0.2809% 1:0.5618% 2:5.337% 3:22.47% 4:71.35% File Formats: PARQUET/NONE:264 - AverageHdfsReadThreadConcurrency: 3.9297752808988764 - AverageScannerThreadConcurrency: 4.99438202247191 - BytesRead: 2275838781 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 1 - NumRowGroups: 264 - NumScannerThreadsStarted: 5 - PeakMemoryUsage: 80433888 - PerReadThreadRawHdfsThroughput: 3243022 - RemoteScanRanges: 0 - RowsRead: 296024943 - RowsReturned: 504 - RowsReturnedRate: 2 - ScanRangesComplete: 264 - ScannerThreadsInvoluntaryContextSwitches: 8198 - ScannerThreadsTotalWallClockTime: 890144724013 - MaterializeTupleTime(*): 15522593985 - ScannerThreadsSysTime: 4752275000 - ScannerThreadsUserTime: 9404569000 - ScannerThreadsVoluntaryContextSwitches: 1633 - TotalRawHdfsReadTime(*): 701764650775 - TotalReadThroughput: 12583774 - TotalTime: 175027423299 Instance 9a46183118493373:ea67bd3b607007bf (host=impala-sailesh-s3-6.vpc.cloudera.com:22000) Hdfs split stats (:<# splits>/): -1:265/19.82 GB - AverageThreadTokens: 5.980337078651686 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 94151704 - PerHostPeakMemUsage: 94151704 - PrepareTime: 172004350 - RowsProduced: 1 - TotalCpuTime: 885627365010 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 1000026 - TotalStorageWaitTime: 866892892013 - TotalTime: 177907492735 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: 6000151 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294144 - NumFunctions: 7 - NumInstructions: 104 - OptimizationTime: 41001038 - PrepareTime: 170004301 - TotalTime: 218005514 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: 3610091125 - 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: 177901492584 HDFS_SCAN_NODE (id=0) ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 265 Hdfs split stats (:<# splits>/): -1:265/19.82 GB Hdfs Read Thread Concurrency Bucket: 0:0.5618% 1:0.5618% 2:7.584% 3:22.47% 4:68.82% File Formats: PARQUET/NONE:265 - AverageHdfsReadThreadConcurrency: 3.896067415730337 - AverageScannerThreadConcurrency: 4.980337078651686 - BytesRead: 2320096547 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 1 - NumRowGroups: 265 - NumScannerThreadsStarted: 5 - PeakMemoryUsage: 92967960 - PerReadThreadRawHdfsThroughput: 3337670 - RemoteScanRanges: 0 - RowsRead: 301684724 - RowsReturned: 509 - RowsReturnedRate: 2 - ScanRangesComplete: 265 - ScannerThreadsInvoluntaryContextSwitches: 11160 - ScannerThreadsTotalWallClockTime: 885627365010 - MaterializeTupleTime(*): 16494416461 - ScannerThreadsSysTime: 4980241000 - ScannerThreadsUserTime: 9864498000 - ScannerThreadsVoluntaryContextSwitches: 1761 - TotalRawHdfsReadTime(*): 695124554129 - TotalReadThroughput: 13033518 - TotalTime: 174109396854 Instance 9a46183118493373:ea67bd3b607007b7 (host=impala-sailesh-s3-9.vpc.cloudera.com:22000) Hdfs split stats (:<# splits>/): -1:264/19.77 GB - AverageThreadTokens: 5.983098591549296 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 82543168 - PerHostPeakMemUsage: 82543168 - PrepareTime: 171997644 - RowsProduced: 1 - TotalCpuTime: 883654879623 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 1999972 - TotalStorageWaitTime: 864936136459 - TotalTime: 177338567587 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: 999987 - CompileTime: 5999917 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294144 - NumFunctions: 7 - NumInstructions: 104 - OptimizationTime: 38999466 - PrepareTime: 169997670 - TotalTime: 214997053 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: 3481952269 - 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: 177333567655 HDFS_SCAN_NODE (id=0) ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 264 Hdfs split stats (:<# splits>/): -1:264/19.77 GB Hdfs Read Thread Concurrency Bucket: 0:0.2817% 1:0.5634% 2:7.887% 3:24.51% 4:66.76% File Formats: PARQUET/NONE:264 - AverageHdfsReadThreadConcurrency: 3.8647887323943664 - AverageScannerThreadConcurrency: 4.983098591549296 - BytesRead: 2318934382 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 1 - NumRowGroups: 264 - NumScannerThreadsStarted: 5 - PeakMemoryUsage: 82506304 - PerReadThreadRawHdfsThroughput: 3383183 - RemoteScanRanges: 0 - RowsRead: 301485665 - RowsReturned: 482 - RowsReturnedRate: 2 - ScanRangesComplete: 264 - ScannerThreadsInvoluntaryContextSwitches: 9449 - ScannerThreadsTotalWallClockTime: 883654879623 - MaterializeTupleTime(*): 16603772228 - ScannerThreadsSysTime: 4881256000 - ScannerThreadsUserTime: 9823504000 - ScannerThreadsVoluntaryContextSwitches: 1614 - TotalRawHdfsReadTime(*): 685429598700 - TotalReadThroughput: 13027654 - TotalTime: 173675617797 Instance 9a46183118493373:ea67bd3b607007b9 (host=impala-sailesh-s3-5.vpc.cloudera.com:22000) Hdfs split stats (:<# splits>/): -1:264/18.05 GB - AverageThreadTokens: 5.968926553672317 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 93987000 - PerHostPeakMemUsage: 93987000 - PrepareTime: 169996121 - RowsProduced: 1 - TotalCpuTime: 878881932210 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 0 - TotalStorageWaitTime: 861915319640 - TotalTime: 176951959584 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: 999978 - CompileTime: 5999864 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294144 - NumFunctions: 7 - NumInstructions: 104 - OptimizationTime: 39999088 - PrepareTime: 164996237 - TotalTime: 212995142 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: 3192927018 - 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: 176947959677 HDFS_SCAN_NODE (id=0) ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 264 Hdfs split stats (:<# splits>/): -1:264/18.05 GB Hdfs Read Thread Concurrency Bucket: 0:0.565% 1:0.8475% 2:4.237% 3:22.88% 4:71.47% File Formats: PARQUET/NONE:264 - AverageHdfsReadThreadConcurrency: 3.968926553672316 - AverageScannerThreadConcurrency: 4.968926553672317 - BytesRead: 2108944851 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 1 - NumRowGroups: 264 - NumScannerThreadsStarted: 5 - PeakMemoryUsage: 91418808 - PerReadThreadRawHdfsThroughput: 3043486 - RemoteScanRanges: 0 - RowsRead: 274353832 - RowsReturned: 990 - RowsReturnedRate: 5 - ScanRangesComplete: 264 - ScannerThreadsInvoluntaryContextSwitches: 10040 - ScannerThreadsTotalWallClockTime: 878881932210 - MaterializeTupleTime(*): 14877660294 - ScannerThreadsSysTime: 4669288000 - ScannerThreadsUserTime: 8890646000 - ScannerThreadsVoluntaryContextSwitches: 1571 - TotalRawHdfsReadTime(*): 692937178017 - TotalReadThroughput: 11914404 - TotalTime: 173579036674 Instance 9a46183118493373:ea67bd3b607007ba (host=impala-sailesh-s3-4.vpc.cloudera.com:22000) Hdfs split stats (:<# splits>/): -1:264/19.60 GB - AverageThreadTokens: 5.985754985754986 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 83641248 - PerHostPeakMemUsage: 83641248 - PrepareTime: 173997118 - RowsProduced: 1 - TotalCpuTime: 875544452485 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 1999965 - TotalStorageWaitTime: 857192757745 - TotalTime: 175844078097 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: 999984 - CompileTime: 5999900 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294144 - NumFunctions: 7 - NumInstructions: 104 - OptimizationTime: 40999322 - PrepareTime: 171997151 - TotalTime: 218996373 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: 3399943489 - 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: 175836078229 HDFS_SCAN_NODE (id=0) ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 264 Hdfs split stats (:<# splits>/): -1:264/19.60 GB Hdfs Read Thread Concurrency Bucket: 0:0.2849% 1:1.425% 2:6.268% 3:22.22% 4:69.8% File Formats: PARQUET/NONE:264 - AverageHdfsReadThreadConcurrency: 3.8774928774928776 - AverageScannerThreadConcurrency: 4.985754985754986 - BytesRead: 2295004278 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 1 - NumRowGroups: 264 - NumScannerThreadsStarted: 5 - PeakMemoryUsage: 82992112 - PerReadThreadRawHdfsThroughput: 3338996 - RemoteScanRanges: 0 - RowsRead: 298441331 - RowsReturned: 516 - RowsReturnedRate: 2 - ScanRangesComplete: 264 - ScannerThreadsInvoluntaryContextSwitches: 9245 - ScannerThreadsTotalWallClockTime: 875544452485 - MaterializeTupleTime(*): 16187730696 - ScannerThreadsSysTime: 4828264000 - ScannerThreadsUserTime: 9740517000 - ScannerThreadsVoluntaryContextSwitches: 1685 - TotalRawHdfsReadTime(*): 687333580142 - TotalReadThroughput: 12920579 - TotalTime: 172261137638 Instance 9a46183118493373:ea67bd3b607007c0 (host=impala-sailesh-s3-10.vpc.cloudera.com:22000) Hdfs split stats (:<# splits>/): -1:265/18.60 GB - AverageThreadTokens: 5.913793103448276 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 89932704 - PerHostPeakMemUsage: 89932704 - PrepareTime: 180003083 - RowsProduced: 1 - TotalCpuTime: 854756377575 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 0 - TotalStorageWaitTime: 838184098475 - TotalTime: 173983925368 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: 6000102 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294144 - NumFunctions: 7 - NumInstructions: 104 - OptimizationTime: 39000668 - PrepareTime: 177003032 - TotalTime: 223003819 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: 3058051539 - 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: 173980925317 HDFS_SCAN_NODE (id=0) ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 265 Hdfs split stats (:<# splits>/): -1:265/18.60 GB Hdfs Read Thread Concurrency Bucket: 0:0.5747% 1:3.448% 2:6.897% 3:22.7% 4:66.38% File Formats: PARQUET/NONE:265 - AverageHdfsReadThreadConcurrency: 3.781609195402299 - AverageScannerThreadConcurrency: 4.913793103448276 - BytesRead: 2174190451 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 1 - NumRowGroups: 265 - NumScannerThreadsStarted: 5 - PeakMemoryUsage: 89895840 - PerReadThreadRawHdfsThroughput: 3273317 - RemoteScanRanges: 0 - RowsRead: 282698477 - RowsReturned: 1086 - RowsReturnedRate: 6 - ScanRangesComplete: 265 - ScannerThreadsInvoluntaryContextSwitches: 10154 - ScannerThreadsTotalWallClockTime: 854756377575 - MaterializeTupleTime(*): 14704247685 - ScannerThreadsSysTime: 4135368000 - ScannerThreadsUserTime: 9216596000 - ScannerThreadsVoluntaryContextSwitches: 1510 - TotalRawHdfsReadTime(*): 664216171878 - TotalReadThroughput: 12458061 - TotalTime: 170739870646 Instance 9a46183118493373:ea67bd3b607007bb (host=impala-sailesh-s3-11.vpc.cloudera.com:22000) Hdfs split stats (:<# splits>/): -1:264/18.19 GB - AverageThreadTokens: 5.884057971014493 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 92079488 - PerHostPeakMemUsage: 92079488 - PrepareTime: 167994958 - RowsProduced: 1 - TotalCpuTime: 842637709866 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 999969 - TotalStorageWaitTime: 826502194194 - TotalTime: 172809813464 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: 2294144 - NumFunctions: 7 - NumInstructions: 104 - OptimizationTime: 36998888 - PrepareTime: 164995048 - TotalTime: 207993757 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: 2936911807 - 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: 172804813615 HDFS_SCAN_NODE (id=0) ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 264 Hdfs split stats (:<# splits>/): -1:264/18.19 GB Hdfs Read Thread Concurrency Bucket: 0:0.2899% 1:2.899% 2:7.246% 3:26.09% 4:63.48% File Formats: PARQUET/NONE:264 - AverageHdfsReadThreadConcurrency: 3.794202898550725 - AverageScannerThreadConcurrency: 4.884057971014493 - BytesRead: 2127250470 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 1 - NumRowGroups: 264 - NumScannerThreadsStarted: 5 - PeakMemoryUsage: 90076544 - PerReadThreadRawHdfsThroughput: 3245107 - RemoteScanRanges: 0 - RowsRead: 276641156 - RowsReturned: 1034 - RowsReturnedRate: 6 - ScanRangesComplete: 264 - ScannerThreadsInvoluntaryContextSwitches: 9177 - ScannerThreadsTotalWallClockTime: 842637709866 - MaterializeTupleTime(*): 14289571082 - ScannerThreadsSysTime: 4081377000 - ScannerThreadsUserTime: 8980633000 - ScannerThreadsVoluntaryContextSwitches: 1606 - TotalRawHdfsReadTime(*): 655525325772 - TotalReadThroughput: 12294863 - TotalTime: 169701906790 Instance 9a46183118493373:ea67bd3b607007bd (host=impala-sailesh-s3-3.vpc.cloudera.com:22000) Hdfs split stats (:<# splits>/): -1:264/18.28 GB - AverageThreadTokens: 5.906158357771261 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 88092632 - PerHostPeakMemUsage: 88092632 - PrepareTime: 167991909 - RowsProduced: 1 - TotalCpuTime: 836244721930 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 1999903 - TotalStorageWaitTime: 819758516015 - TotalTime: 170617782138 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: 999952 - CompileTime: 5999710 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294144 - NumFunctions: 7 - NumInstructions: 104 - OptimizationTime: 36998218 - PrepareTime: 165992005 - TotalTime: 208989933 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: 3029854080 - 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: 170611782429 HDFS_SCAN_NODE (id=0) ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 264 Hdfs split stats (:<# splits>/): -1:264/18.28 GB Hdfs Read Thread Concurrency Bucket: 0:0.2933% 1:1.76% 2:10.26% 3:23.17% 4:64.52% File Formats: PARQUET/NONE:264 - AverageHdfsReadThreadConcurrency: 3.780058651026393 - AverageScannerThreadConcurrency: 4.906158357771261 - BytesRead: 2135647360 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 1 - NumRowGroups: 264 - NumScannerThreadsStarted: 5 - PeakMemoryUsage: 87244760 - PerReadThreadRawHdfsThroughput: 3319934 - RemoteScanRanges: 0 - RowsRead: 277892436 - RowsReturned: 1073 - RowsReturnedRate: 6 - ScanRangesComplete: 264 - ScannerThreadsInvoluntaryContextSwitches: 7754 - ScannerThreadsTotalWallClockTime: 836244721930 - MaterializeTupleTime(*): 14579297765 - ScannerThreadsSysTime: 4050382000 - ScannerThreadsUserTime: 9139609000 - ScannerThreadsVoluntaryContextSwitches: 1466 - TotalRawHdfsReadTime(*): 643280016217 - TotalReadThroughput: 12440613 - TotalTime: 167407936726 Instance 9a46183118493373:ea67bd3b607007be (host=impala-sailesh-s3-8.vpc.cloudera.com:22000) Hdfs split stats (:<# splits>/): -1:264/18.07 GB - AverageThreadTokens: 5.887240356083086 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 89932704 - PerHostPeakMemUsage: 89932704 - PrepareTime: 170002304 - RowsProduced: 1 - TotalCpuTime: 824615139157 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 2000027 - TotalStorageWaitTime: 807722910961 - TotalTime: 168537276565 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: 5000071 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2294144 - NumFunctions: 7 - NumInstructions: 104 - OptimizationTime: 40000539 - PrepareTime: 168002276 - TotalTime: 214002900 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: 3236043664 - 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: 168530276473 HDFS_SCAN_NODE (id=0) ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 264 Hdfs split stats (:<# splits>/): -1:264/18.07 GB Hdfs Read Thread Concurrency Bucket: 0:0.2976% 1:3.274% 2:6.845% 3:24.11% 4:65.48% File Formats: PARQUET/NONE:264 - AverageHdfsReadThreadConcurrency: 3.800595238095238 - AverageScannerThreadConcurrency: 4.901785714285714 - BytesRead: 2111254495 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 1 - NumRowGroups: 264 - NumScannerThreadsStarted: 5 - PeakMemoryUsage: 89895840 - PerReadThreadRawHdfsThroughput: 3325315 - RemoteScanRanges: 0 - RowsRead: 274576331 - RowsReturned: 1021 - RowsReturnedRate: 6 - ScanRangesComplete: 264 - ScannerThreadsInvoluntaryContextSwitches: 10193 - ScannerThreadsTotalWallClockTime: 824615139157 - MaterializeTupleTime(*): 14900201324 - ScannerThreadsSysTime: 4631293000 - ScannerThreadsUserTime: 8902645000 - ScannerThreadsVoluntaryContextSwitches: 1588 - TotalRawHdfsReadTime(*): 634903576551 - TotalReadThroughput: 12491494 - TotalTime: 165123230492