Query (id=1c4b863302be8e1d:4c0db2421c645cad)
  Summary
    Session ID: 1746b7cd4514ba05:3ca7192fa9e2a8b8
    Session Type: BEESWAX
    Start Time: 2016-05-05 23:13:09.102926000
    End Time: 2016-05-05 23:17:38.321747000
    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:38703
    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=50.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=40.00MB
   tuple-ids=0 row-size=8B cardinality=unavailable
----------------
    Estimated Per-Host Mem: 52428800
    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  299.993ms  299.993ms      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    3s587ms    4s865ms     10           1    8.01 MB       10.00 MB                                 
00:SCAN HDFS       10       3m3s      4m24s  7.69K          -1  100.76 MB       40.00 MB  tpcds_1000_parquet.store_sales 
    Planner Timeline
      Analysis finished: 13168475
      Equivalence classes computed: 13434498
      Single node plan created: 132918547
      Runtime filters computed: 132974087
      Distributed plan created: 137988084
      Lineage info computed: 138896193
      Planning finished: 212096398
    Query Timeline
      Start execution: 0
      Planning finished: 351992313
      Submit for admission: 385991571
      Completed admission: 386991549
      Ready to start 10 remote fragments: 698984734
      All 10 remote fragments started: 825981961
      Rows available: 268508138777
      First row fetched: 269217123306
      Unregister query: 269219123264
  ImpalaServer
    - ClientFetchWaitTimer: 709984508
    - InactiveTotalTime: 0
    - RowMaterializationTimer: 0
    - TotalTime: 0
  Execution Profile 1c4b863302be8e1d:4c0db2421c645cad
    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: 25ms, 50th %-ile: 32ms, 75th %-ile: 38ms, 90th %-ile: 51ms, 95th %-ile: 56ms, 99.9th %-ile: 56ms
    Per Node Peak Memory Usage: impala-sailesh-s3-11.vpc.cloudera.com:22000(76.79 MB) impala-sailesh-s3-4.vpc.cloudera.com:22000(100.80 MB) impala-sailesh-s3-5.vpc.cloudera.com:22000(80.32 MB) impala-sailesh-s3-7.vpc.cloudera.com:22000(91.28 MB) impala-sailesh-s3-6.vpc.cloudera.com:22000(95.38 MB) impala-sailesh-s3-8.vpc.cloudera.com:22000(80.64 MB) impala-sailesh-s3-3.vpc.cloudera.com:22000(76.25 MB) impala-sailesh-s3-10.vpc.cloudera.com:22000(100.80 MB) impala-sailesh-s3-9.vpc.cloudera.com:22000(67.65 MB) impala-sailesh-s3-2.vpc.cloudera.com:22000(44.54 MB) 
    - FiltersReceived: 0
    - FinalizationTimer: 0
    - InactiveTotalTime: 0
    - TotalTime: 268110147468
    Coordinator Fragment F01
      - AverageThreadTokens: 1.0
      - BloomFilterBytes: 0
      - InactiveTotalTime: 0
      - PeakMemoryUsage: 61456
      - PerHostPeakMemUsage: 0
      - PrepareTime: 299993446
      - RowsProduced: 1
      - TotalCpuTime: 1205973676
      - TotalNetworkReceiveTime: 267616158256
      - TotalNetworkSendTime: 0
      - TotalStorageWaitTime: 0
      - TotalTime: 267919151637
      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: 1999954
        - CompileTime: 6999849
        - InactiveTotalTime: 0
        - LoadTime: 0
        - ModuleBitcodeSize: 2294144
        - NumFunctions: 4
        - NumInstructions: 56
        - OptimizationTime: 54998797
        - PrepareTime: 297993491
        - TotalTime: 360992115
      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: 267916151702
        EXCHANGE_NODE (id=2)
          - BytesReceived: 160
          - ConvertRowBatchTime: 0
          - DeserializeRowBatchTimer: 0
          - FirstBatchArrivalWaitTime: 156548582116
          - InactiveTotalTime: 267616158256
          - PeakMemoryUsage: 0
          - RowsReturned: 10
          - RowsReturnedRate: 0
          - SendersBlockedTimer: 0
          - SendersBlockedTotalTimer(*): 0
          - TotalTime: 267616158256
    Averaged Fragment F00
      split sizes:  min: 18.23 GB, max: 19.65 GB, avg: 18.92 GB, stddev: 465.04 MB
      completion times: min:2m36s  max:4m27s  mean: 3m7s  stddev:28s014ms
      execution rates: min:72.08 MB/sec  max:122.33 MB/sec  mean:105.27 MB/sec  stddev:12.26 MB/sec
      num instances: 10
      - AverageThreadTokens: 5.663321728034803
      - BloomFilterBytes: 0
      - InactiveTotalTime: 0
      - PeakMemoryUsage: 85398992
      - PerHostPeakMemUsage: 85400221
      - PrepareTime: 172497851
      - RowsProduced: 1
      - TotalCpuTime: 850030141337
      - TotalNetworkReceiveTime: 0
      - TotalNetworkSendTime: 1099976
      - TotalStorageWaitTime: 832184827214
      - TotalTime: 187204227013
      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: 199995
        - CompileTime: 5399941
        - InactiveTotalTime: 0
        - LoadTime: 0
        - ModuleBitcodeSize: 2294144
        - NumFunctions: 7
        - NumInstructions: 104
        - OptimizationTime: 39999515
        - PrepareTime: 168397894
        - TotalTime: 214797342
      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: 3410764241
        - 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: 187197627115
        HDFS_SCAN_NODE (id=0)
          - AverageHdfsReadThreadConcurrency: 3.3117263982711753
          - AverageScannerThreadConcurrency: 4.671759081263505
          - BytesRead: 2256588755
          - BytesReadDataNodeCache: 0
          - BytesReadLocal: 0
          - BytesReadRemoteUnexpected: 0
          - BytesReadShortCircuit: 0
          - DecompressionTime: 0
          - InactiveTotalTime: 0
          - MaxCompressedTextFileLength: 0
          - NumColumns: 1
          - NumDisksAccessed: 1
          - NumRowGroups: 264
          - NumScannerThreadsStarted: 4
          - PeakMemoryUsage: 84480669
          - PerReadThreadRawHdfsThroughput: 3856039
          - RemoteScanRanges: 0
          - RowsRead: 287998799
          - RowsReturned: 769
          - RowsReturnedRate: 3
          - ScanRangesComplete: 675
          - ScannerThreadsInvoluntaryContextSwitches: 8634
          - ScannerThreadsTotalWallClockTime: 850030141337
            - MaterializeTupleTime(*): 15712036272
            - ScannerThreadsSysTime: 4757074000
            - ScannerThreadsUserTime: 9532848100
          - ScannerThreadsVoluntaryContextSwitches: 2378
          - TotalRawHdfsReadTime(*): 599589640997
          - TotalReadThroughput: 12213544
          - TotalTime: 183610465085
    Fragment F00
      Instance 1c4b863302be8e1d:4c0db2421c645cb4 (host=impala-sailesh-s3-2.vpc.cloudera.com:22000)
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): -1:676/18.84 GB 
        - AverageThreadTokens: 3.0
        - BloomFilterBytes: 0
        - InactiveTotalTime: 0
        - PeakMemoryUsage: 46687496
        - PerHostPeakMemUsage: 46699784
        - PrepareTime: 186995916
        - RowsProduced: 1
        - TotalCpuTime: 534777326450
        - TotalNetworkReceiveTime: 0
        - TotalNetworkSendTime: 0
        - TotalStorageWaitTime: 519833652535
        - TotalTime: 267648157559
        CodeGen
          - CodegenTime: 0
          - CompileTime: 2999934
          - InactiveTotalTime: 0
          - LoadTime: 0
          - ModuleBitcodeSize: 2294144
          - NumFunctions: 7
          - NumInstructions: 104
          - OptimizationTime: 38999148
          - PrepareTime: 183995982
          - TotalTime: 225995064
        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: 2950935592
          - 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: 267635157842
          HDFS_SCAN_NODE (id=0)
            ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 676
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): -1:676/18.84 GB 
            Hdfs Read Thread Concurrency Bucket: 0:13.83% 1:48.22% 2:37.94% 3:0% 4:0% 
            File Formats: PARQUET/NONE:676 
            - AverageHdfsReadThreadConcurrency: 1.2411214953271028
            - AverageScannerThreadConcurrency: 2.0
            - BytesRead: 1952702154
            - BytesReadDataNodeCache: 0
            - BytesReadLocal: 0
            - BytesReadRemoteUnexpected: 0
            - BytesReadShortCircuit: 0
            - DecompressionTime: 0
            - InactiveTotalTime: 0
            - MaxCompressedTextFileLength: 0
            - NumColumns: 1
            - NumDisksAccessed: 1
            - NumRowGroups: 246
            - NumScannerThreadsStarted: 2
            - PeakMemoryUsage: 44610824
            - PerReadThreadRawHdfsThroughput: 5958667
            - RemoteScanRanges: 0
            - RowsRead: 248929680
            - RowsReturned: 628
            - RowsReturnedRate: 2
            - ScanRangesComplete: 676
            - ScannerThreadsInvoluntaryContextSwitches: 4211
            - ScannerThreadsTotalWallClockTime: 534777326450
              - MaterializeTupleTime(*): 13008716051
              - ScannerThreadsSysTime: 4323341000
              - ScannerThreadsUserTime: 8388723000
            - ScannerThreadsVoluntaryContextSwitches: 2423
            - TotalRawHdfsReadTime(*): 327707846181
            - TotalReadThroughput: 7275934
            - TotalTime: 264495226378
      Instance 1c4b863302be8e1d:4c0db2421c645cb3 (host=impala-sailesh-s3-6.vpc.cloudera.com:22000)
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): -1:676/19.65 GB 
        - AverageThreadTokens: 5.975871313672922
        - BloomFilterBytes: 0
        - InactiveTotalTime: 0
        - PeakMemoryUsage: 100009472
        - PerHostPeakMemUsage: 100009472
        - PrepareTime: 175004108
        - RowsProduced: 1
        - TotalCpuTime: 928953795897
        - TotalNetworkReceiveTime: 0
        - TotalNetworkSendTime: 0
        - TotalStorageWaitTime: 904524222734
        - TotalTime: 186283370736
        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: 6000142
          - InactiveTotalTime: 0
          - LoadTime: 0
          - ModuleBitcodeSize: 2294144
          - NumFunctions: 7
          - NumInstructions: 104
          - OptimizationTime: 42000986
          - PrepareTime: 169003968
          - TotalTime: 219005143
        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: 4683109865
          - 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: 186279370643
          HDFS_SCAN_NODE (id=0)
            ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 676
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): -1:676/19.65 GB 
            Hdfs Read Thread Concurrency Bucket: 0:0.5376% 1:2.957% 2:8.065% 3:30.38% 4:58.06% 
            File Formats: PARQUET/NONE:676 
            - AverageHdfsReadThreadConcurrency: 3.6129032258064515
            - AverageScannerThreadConcurrency: 4.989247311827957
            - BytesRead: 2766712959
            - BytesReadDataNodeCache: 0
            - BytesReadLocal: 0
            - BytesReadRemoteUnexpected: 0
            - BytesReadShortCircuit: 0
            - DecompressionTime: 0
            - InactiveTotalTime: 0
            - MaxCompressedTextFileLength: 0
            - NumColumns: 1
            - NumDisksAccessed: 1
            - NumRowGroups: 271
            - NumScannerThreadsStarted: 5
            - PeakMemoryUsage: 97760768
            - PerReadThreadRawHdfsThroughput: 4131452
            - RemoteScanRanges: 0
            - RowsRead: 353904855
            - RowsReturned: 532
            - RowsReturnedRate: 2
            - ScanRangesComplete: 676
            - ScannerThreadsInvoluntaryContextSwitches: 11468
            - ScannerThreadsTotalWallClockTime: 928953795897
              - MaterializeTupleTime(*): 21511504744
              - ScannerThreadsSysTime: 6448018000
              - ScannerThreadsUserTime: 11993174000
            - ScannerThreadsVoluntaryContextSwitches: 2681
            - TotalRawHdfsReadTime(*): 669670712507
            - TotalReadThroughput: 14794747
            - TotalTime: 181414256506
      Instance 1c4b863302be8e1d:4c0db2421c645cb7 (host=impala-sailesh-s3-4.vpc.cloudera.com:22000)
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): -1:676/19.21 GB 
        - AverageThreadTokens: 5.97289972899729
        - BloomFilterBytes: 0
        - InactiveTotalTime: 0
        - PeakMemoryUsage: 105693600
        - PerHostPeakMemUsage: 105693600
        - PrepareTime: 171997090
        - RowsProduced: 1
        - TotalCpuTime: 918265437183
        - TotalNetworkReceiveTime: 0
        - TotalNetworkSendTime: 999983
        - TotalStorageWaitTime: 898253776393
        - TotalTime: 184308876330
        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: 4999916
          - InactiveTotalTime: 0
          - LoadTime: 0
          - ModuleBitcodeSize: 2294144
          - NumFunctions: 7
          - NumInstructions: 104
          - OptimizationTime: 38999341
          - PrepareTime: 167997158
          - TotalTime: 212996398
        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: 3846934816
          - 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: 184303876413
          HDFS_SCAN_NODE (id=0)
            ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 676
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): -1:676/19.21 GB 
            Hdfs Read Thread Concurrency Bucket: 0:0% 1:1.902% 2:11.14% 3:31.52% 4:55.43% 
            File Formats: PARQUET/NONE:676 
            - AverageHdfsReadThreadConcurrency: 3.6168478260869565
            - AverageScannerThreadConcurrency: 4.986413043478261
            - BytesRead: 2513341814
            - BytesReadDataNodeCache: 0
            - BytesReadLocal: 0
            - BytesReadRemoteUnexpected: 0
            - BytesReadShortCircuit: 0
            - DecompressionTime: 0
            - InactiveTotalTime: 0
            - MaxCompressedTextFileLength: 0
            - NumColumns: 1
            - NumDisksAccessed: 1
            - NumRowGroups: 272
            - NumScannerThreadsStarted: 5
            - PeakMemoryUsage: 105656736
            - PerReadThreadRawHdfsThroughput: 3815720
            - RemoteScanRanges: 0
            - RowsRead: 320994836
            - RowsReturned: 1066
            - RowsReturnedRate: 5
            - ScanRangesComplete: 676
            - ScannerThreadsInvoluntaryContextSwitches: 8849
            - ScannerThreadsTotalWallClockTime: 918265437183
              - MaterializeTupleTime(*): 17636701063
              - ScannerThreadsSysTime: 5583148000
              - ScannerThreadsUserTime: 10405415000
            - ScannerThreadsVoluntaryContextSwitches: 2540
            - TotalRawHdfsReadTime(*): 658680836423
            - TotalReadThroughput: 13549043
            - TotalTime: 180270944746
      Instance 1c4b863302be8e1d:4c0db2421c645cb0 (host=impala-sailesh-s3-10.vpc.cloudera.com:22000)
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): -1:676/18.31 GB 
        - AverageThreadTokens: 5.983651226158038
        - BloomFilterBytes: 0
        - InactiveTotalTime: 0
        - PeakMemoryUsage: 105693600
        - PerHostPeakMemUsage: 105693600
        - PrepareTime: 170002894
        - RowsProduced: 1
        - TotalCpuTime: 915047582735
        - TotalNetworkReceiveTime: 0
        - TotalNetworkSendTime: 0
        - TotalStorageWaitTime: 895729253840
        - TotalTime: 183319121819
        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: 41000698
          - PrepareTime: 166002826
          - TotalTime: 214003643
        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: 3459058905
          - 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: 183315121751
          HDFS_SCAN_NODE (id=0)
            ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 676
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): -1:676/18.31 GB 
            Hdfs Read Thread Concurrency Bucket: 0:0.5464% 1:2.186% 2:12.84% 3:31.15% 4:53.28% 
            File Formats: PARQUET/NONE:676 
            - AverageHdfsReadThreadConcurrency: 3.510928961748634
            - AverageScannerThreadConcurrency: 4.997267759562842
            - BytesRead: 2423236593
            - BytesReadDataNodeCache: 0
            - BytesReadLocal: 0
            - BytesReadRemoteUnexpected: 0
            - BytesReadShortCircuit: 0
            - DecompressionTime: 0
            - InactiveTotalTime: 0
            - MaxCompressedTextFileLength: 0
            - NumColumns: 1
            - NumDisksAccessed: 1
            - NumRowGroups: 301
            - NumScannerThreadsStarted: 5
            - PeakMemoryUsage: 105656736
            - PerReadThreadRawHdfsThroughput: 3790518
            - RemoteScanRanges: 0
            - RowsRead: 309178119
            - RowsReturned: 916
            - RowsReturnedRate: 5
            - ScanRangesComplete: 676
            - ScannerThreadsInvoluntaryContextSwitches: 11690
            - ScannerThreadsTotalWallClockTime: 915047582735
              - MaterializeTupleTime(*): 17110291319
              - ScannerThreadsSysTime: 4778271000
              - ScannerThreadsUserTime: 10303431000
            - ScannerThreadsVoluntaryContextSwitches: 2396
            - TotalRawHdfsReadTime(*): 639288886765
            - TotalReadThroughput: 13136231
            - TotalTime: 179685059935
      Instance 1c4b863302be8e1d:4c0db2421c645cb6 (host=impala-sailesh-s3-5.vpc.cloudera.com:22000)
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): -1:676/18.23 GB 
        - AverageThreadTokens: 5.972527472527473
        - BloomFilterBytes: 0
        - InactiveTotalTime: 0
        - PeakMemoryUsage: 84220856
        - PerHostPeakMemUsage: 84220856
        - PrepareTime: 170996010
        - RowsProduced: 1
        - TotalCpuTime: 906578244648
        - TotalNetworkReceiveTime: 0
        - TotalNetworkSendTime: 4999888
        - TotalStorageWaitTime: 889745629573
        - TotalTime: 181896835798
        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: 1999952
          - CompileTime: 5999860
          - InactiveTotalTime: 0
          - LoadTime: 0
          - ModuleBitcodeSize: 2294144
          - NumFunctions: 7
          - NumInstructions: 104
          - OptimizationTime: 39999068
          - PrepareTime: 166996105
          - TotalTime: 213995009
        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: 3172927473
          - 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: 181886836025
          HDFS_SCAN_NODE (id=0)
            ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 676
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): -1:676/18.23 GB 
            Hdfs Read Thread Concurrency Bucket: 0:0.2755% 1:3.03% 2:12.67% 3:27.27% 4:56.75% 
            File Formats: PARQUET/NONE:676 
            - AverageHdfsReadThreadConcurrency: 3.5454545454545454
            - AverageScannerThreadConcurrency: 4.986225895316805
            - BytesRead: 2188530510
            - BytesReadDataNodeCache: 0
            - BytesReadLocal: 0
            - BytesReadRemoteUnexpected: 0
            - BytesReadShortCircuit: 0
            - DecompressionTime: 0
            - InactiveTotalTime: 0
            - MaxCompressedTextFileLength: 0
            - NumColumns: 1
            - NumDisksAccessed: 1
            - NumRowGroups: 287
            - NumScannerThreadsStarted: 5
            - PeakMemoryUsage: 82725816
            - PerReadThreadRawHdfsThroughput: 3383862
            - RemoteScanRanges: 0
            - RowsRead: 279502457
            - RowsReturned: 935
            - RowsReturnedRate: 5
            - ScanRangesComplete: 676
            - ScannerThreadsInvoluntaryContextSwitches: 9296
            - ScannerThreadsTotalWallClockTime: 906578244648
              - MaterializeTupleTime(*): 14773662246
              - ScannerThreadsSysTime: 4529308000
              - ScannerThreadsUserTime: 9162605000
            - ScannerThreadsVoluntaryContextSwitches: 2280
            - TotalRawHdfsReadTime(*): 646755203511
            - TotalReadThroughput: 12011862
            - TotalTime: 178537912655
      Instance 1c4b863302be8e1d:4c0db2421c645cb8 (host=impala-sailesh-s3-11.vpc.cloudera.com:22000)
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): -1:676/19.58 GB 
        - AverageThreadTokens: 5.955678670360111
        - BloomFilterBytes: 0
        - InactiveTotalTime: 0
        - PeakMemoryUsage: 80520368
        - PerHostPeakMemUsage: 80520368
        - PrepareTime: 164995088
        - RowsProduced: 1
        - TotalCpuTime: 895044552758
        - TotalNetworkReceiveTime: 0
        - TotalNetworkSendTime: 999970
        - TotalStorageWaitTime: 875395133313
        - TotalTime: 180866655626
        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: 4999852
          - InactiveTotalTime: 0
          - LoadTime: 0
          - ModuleBitcodeSize: 2294144
          - NumFunctions: 7
          - NumInstructions: 104
          - OptimizationTime: 36998898
          - PrepareTime: 160995206
          - TotalTime: 203993926
        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: 3681891232
          - 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: 180860655805
          HDFS_SCAN_NODE (id=0)
            ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 676
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): -1:676/19.58 GB 
            Hdfs Read Thread Concurrency Bucket: 0:0.554% 1:3.878% 2:10.8% 3:25.76% 4:59% 
            File Formats: PARQUET/NONE:676 
            - AverageHdfsReadThreadConcurrency: 3.6204986149584486
            - AverageScannerThreadConcurrency: 4.955678670360111
            - BytesRead: 2518209471
            - BytesReadDataNodeCache: 0
            - BytesReadLocal: 0
            - BytesReadRemoteUnexpected: 0
            - BytesReadShortCircuit: 0
            - DecompressionTime: 0
            - InactiveTotalTime: 0
            - MaxCompressedTextFileLength: 0
            - NumColumns: 1
            - NumDisksAccessed: 1
            - NumRowGroups: 252
            - NumScannerThreadsStarted: 5
            - PeakMemoryUsage: 79852720
            - PerReadThreadRawHdfsThroughput: 3900125
            - RemoteScanRanges: 0
            - RowsRead: 322219663
            - RowsReturned: 559
            - RowsReturnedRate: 3
            - ScanRangesComplete: 676
            - ScannerThreadsInvoluntaryContextSwitches: 10084
            - ScannerThreadsTotalWallClockTime: 895044552758
              - MaterializeTupleTime(*): 17447484482
              - ScannerThreadsSysTime: 5062227000
              - ScannerThreadsUserTime: 10692371000
            - ScannerThreadsVoluntaryContextSwitches: 2556
            - TotalRawHdfsReadTime(*): 645673921994
            - TotalReadThroughput: 13915903
            - TotalTime: 177008769637
      Instance 1c4b863302be8e1d:4c0db2421c645cb2 (host=impala-sailesh-s3-8.vpc.cloudera.com:22000)
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): -1:676/19.15 GB 
        - AverageThreadTokens: 5.905292479108635
        - BloomFilterBytes: 0
        - InactiveTotalTime: 0
        - PeakMemoryUsage: 84554760
        - PerHostPeakMemUsage: 84554760
        - PrepareTime: 172002410
        - RowsProduced: 1
        - TotalCpuTime: 881254316473
        - TotalNetworkReceiveTime: 0
        - TotalNetworkSendTime: 1000014
        - TotalStorageWaitTime: 862810058744
        - TotalTime: 179943514766
        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: 41000575
          - PrepareTime: 168002354
          - TotalTime: 216003027
        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: 3595050215
          - 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: 179936514668
          HDFS_SCAN_NODE (id=0)
            ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 676
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): -1:676/19.15 GB 
            Hdfs Read Thread Concurrency Bucket: 0:0% 1:4.457% 2:12.53% 3:29.25% 4:53.76% 
            File Formats: PARQUET/NONE:676 
            - AverageHdfsReadThreadConcurrency: 3.5153203342618387
            - AverageScannerThreadConcurrency: 4.905292479108635
            - BytesRead: 2293697850
            - BytesReadDataNodeCache: 0
            - BytesReadLocal: 0
            - BytesReadRemoteUnexpected: 0
            - BytesReadShortCircuit: 0
            - DecompressionTime: 0
            - InactiveTotalTime: 0
            - MaxCompressedTextFileLength: 0
            - NumColumns: 1
            - NumDisksAccessed: 1
            - NumRowGroups: 257
            - NumScannerThreadsStarted: 5
            - PeakMemoryUsage: 83108872
            - PerReadThreadRawHdfsThroughput: 3631240
            - RemoteScanRanges: 0
            - RowsRead: 293198284
            - RowsReturned: 1029
            - RowsReturnedRate: 5
            - ScanRangesComplete: 676
            - ScannerThreadsInvoluntaryContextSwitches: 9957
            - ScannerThreadsTotalWallClockTime: 881254316473
              - MaterializeTupleTime(*): 16236226814
              - ScannerThreadsSysTime: 5063228000
              - ScannerThreadsUserTime: 9770512000
            - ScannerThreadsVoluntaryContextSwitches: 2369
            - TotalRawHdfsReadTime(*): 631656827608
            - TotalReadThroughput: 12742940
            - TotalTime: 176169462042
      Instance 1c4b863302be8e1d:4c0db2421c645cb1 (host=impala-sailesh-s3-3.vpc.cloudera.com:22000)
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): -1:675/18.86 GB 
        - AverageThreadTokens: 5.977653631284916
        - BloomFilterBytes: 0
        - InactiveTotalTime: 0
        - PeakMemoryUsage: 79955968
        - PerHostPeakMemUsage: 79955968
        - PrepareTime: 168991913
        - RowsProduced: 1
        - TotalCpuTime: 890634372904
        - TotalNetworkReceiveTime: 0
        - TotalNetworkSendTime: 999952
        - TotalStorageWaitTime: 873530191581
        - TotalTime: 179014432098
        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: 4999761
          - InactiveTotalTime: 0
          - LoadTime: 0
          - ModuleBitcodeSize: 2294144
          - NumFunctions: 7
          - NumInstructions: 104
          - OptimizationTime: 39998086
          - PrepareTime: 164992105
          - TotalTime: 210989904
        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: 3170848299
          - 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: 179008432388
          HDFS_SCAN_NODE (id=0)
            ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 675
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): -1:675/18.86 GB 
            Hdfs Read Thread Concurrency Bucket: 0:0.838% 1:1.676% 2:11.45% 3:31.28% 4:54.75% 
            File Formats: PARQUET/NONE:675 
            - AverageHdfsReadThreadConcurrency: 3.553072625698324
            - AverageScannerThreadConcurrency: 4.977653631284916
            - BytesRead: 2250400506
            - BytesReadDataNodeCache: 0
            - BytesReadLocal: 0
            - BytesReadRemoteUnexpected: 0
            - BytesReadShortCircuit: 0
            - DecompressionTime: 0
            - InactiveTotalTime: 0
            - MaxCompressedTextFileLength: 0
            - NumColumns: 1
            - NumDisksAccessed: 1
            - NumRowGroups: 267
            - NumScannerThreadsStarted: 5
            - PeakMemoryUsage: 79919104
            - PerReadThreadRawHdfsThroughput: 3524139
            - RemoteScanRanges: 0
            - RowsRead: 286902766
            - RowsReturned: 605
            - RowsReturnedRate: 3
            - ScanRangesComplete: 675
            - ScannerThreadsInvoluntaryContextSwitches: 8323
            - ScannerThreadsTotalWallClockTime: 890634372904
              - MaterializeTupleTime(*): 15168273968
              - ScannerThreadsSysTime: 4347336000
              - ScannerThreadsUserTime: 9370573000
            - ScannerThreadsVoluntaryContextSwitches: 2211
            - TotalRawHdfsReadTime(*): 638567437143
            - TotalReadThroughput: 12500198
            - TotalTime: 175663592415
      Instance 1c4b863302be8e1d:4c0db2421c645cb5 (host=impala-sailesh-s3-7.vpc.cloudera.com:22000)
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): -1:676/18.69 GB 
        - AverageThreadTokens: 5.956521739130435
        - BloomFilterBytes: 0
        - InactiveTotalTime: 0
        - PeakMemoryUsage: 95716864
        - PerHostPeakMemUsage: 95716864
        - PrepareTime: 173995400
        - RowsProduced: 1
        - TotalCpuTime: 855490377244
        - TotalNetworkReceiveTime: 0
        - TotalNetworkSendTime: 999974
        - TotalStorageWaitTime: 840615770640
        - TotalTime: 172157448003
        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: 5999841
          - InactiveTotalTime: 0
          - LoadTime: 0
          - ModuleBitcodeSize: 2294144
          - NumFunctions: 7
          - NumInstructions: 104
          - OptimizationTime: 41998889
          - PrepareTime: 169995505
          - TotalTime: 218994208
        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: 2983921033
          - 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: 172152448135
          HDFS_SCAN_NODE (id=0)
            ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 676
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): -1:676/18.69 GB 
            Hdfs Read Thread Concurrency Bucket: 0:0.8721% 1:4.36% 2:11.92% 3:27.33% 4:55.52% 
            File Formats: PARQUET/NONE:676 
            - AverageHdfsReadThreadConcurrency: 3.51453488372093
            - AverageScannerThreadConcurrency: 4.97093023255814
            - BytesRead: 1969523709
            - BytesReadDataNodeCache: 0
            - BytesReadLocal: 0
            - BytesReadRemoteUnexpected: 0
            - BytesReadShortCircuit: 0
            - DecompressionTime: 0
            - InactiveTotalTime: 0
            - MaxCompressedTextFileLength: 0
            - NumColumns: 1
            - NumDisksAccessed: 1
            - NumRowGroups: 255
            - NumScannerThreadsStarted: 5
            - PeakMemoryUsage: 95680000
            - PerReadThreadRawHdfsThroughput: 3268039
            - RemoteScanRanges: 0
            - RowsRead: 250422204
            - RowsReturned: 714
            - RowsReturnedRate: 4
            - ScanRangesComplete: 676
            - ScannerThreadsInvoluntaryContextSwitches: 6690
            - ScannerThreadsTotalWallClockTime: 855490377244
              - MaterializeTupleTime(*): 13037655159
              - ScannerThreadsSysTime: 3960395000
              - ScannerThreadsUserTime: 8160756000
            - ScannerThreadsVoluntaryContextSwitches: 2298
            - TotalRawHdfsReadTime(*): 602662060388
            - TotalReadThroughput: 11413135
            - TotalTime: 168993531729
      Instance 1c4b863302be8e1d:4c0db2421c645caf (host=impala-sailesh-s3-9.vpc.cloudera.com:22000)
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): -1:676/18.71 GB 
        - AverageThreadTokens: 5.93312101910828
        - BloomFilterBytes: 0
        - InactiveTotalTime: 0
        - PeakMemoryUsage: 70936944
        - PerHostPeakMemUsage: 70936944
        - PrepareTime: 169997681
        - RowsProduced: 1
        - TotalCpuTime: 774255407084
        - TotalNetworkReceiveTime: 0
        - TotalNetworkSendTime: 999985
        - TotalStorageWaitTime: 761410582787
        - TotalTime: 156603857397
        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: 5999918
          - InactiveTotalTime: 0
          - LoadTime: 0
          - ModuleBitcodeSize: 2294144
          - NumFunctions: 7
          - NumInstructions: 104
          - OptimizationTime: 38999466
          - PrepareTime: 165997734
          - TotalTime: 211997104
        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: 2562964981
          - 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: 156597857482
          HDFS_SCAN_NODE (id=0)
            ExecOption: Expr Evaluation Codegen Enabled, Codegen enabled: 0 out of 676
            Hdfs split stats (<volume id>:<# splits>/<split lengths>): -1:676/18.71 GB 
            Hdfs Read Thread Concurrency Bucket: 0:0.9585% 1:4.792% 2:15.97% 3:25.88% 4:52.4% 
            File Formats: PARQUET/NONE:676 
            - AverageHdfsReadThreadConcurrency: 3.3865814696485623
            - AverageScannerThreadConcurrency: 4.94888178913738
            - BytesRead: 1689531984
            - BytesReadDataNodeCache: 0
            - BytesReadLocal: 0
            - BytesReadRemoteUnexpected: 0
            - BytesReadShortCircuit: 0
            - DecompressionTime: 0
            - InactiveTotalTime: 0
            - MaxCompressedTextFileLength: 0
            - NumColumns: 1
            - NumDisksAccessed: 1
            - NumRowGroups: 234
            - NumScannerThreadsStarted: 5
            - PeakMemoryUsage: 69835120
            - PerReadThreadRawHdfsThroughput: 3156630
            - RemoteScanRanges: 0
            - RowsRead: 214735135
            - RowsReturned: 710
            - RowsReturnedRate: 4
            - ScanRangesComplete: 676
            - ScannerThreadsInvoluntaryContextSwitches: 5778
            - ScannerThreadsTotalWallClockTime: 774255407084
              - MaterializeTupleTime(*): 11189846875
              - ScannerThreadsSysTime: 3475468000
              - ScannerThreadsUserTime: 7080921000
            - ScannerThreadsVoluntaryContextSwitches: 2028
            - TotalRawHdfsReadTime(*): 535232677458
            - TotalReadThroughput: 10795455
            - TotalTime: 153865894812