Query (id=7141f7bc14834176:dcbe11ec83e78cb9)
  Summary
    Session ID: 5345cf2ac93e5da3:95e0e3ad448bd3a6
    Session Type: HIVESERVER2
    HiveServer2 Protocol Version: V6
    Start Time: 2016-11-15 10:29:01.518857000
    End Time: 2016-11-15 10:30:31.378601000
    Query Type: DML
    Query State: EXCEPTION
    Query Status: Session expired due to inactivity

    Impala Version: impalad version 2.6.0-cdh5.8.3 RELEASE (build c644f476b774db9db87a619628f7a6ecc5f843e0)
    User: cloudera@HADOOP.COM
    Connected User: cloudera@HADOOP.COM
    Delegated User: 
    Network Address: xxx.xxx.xxx.xxx:59346
    Default Db: default
    Sql Statement: insert overwrite table weblogs_count select count(*) as col1 from web_logs a, web_logs b, web_logs c, web_logs d
    Coordinator: impalad-host-1.cloudera.com:22000
    Query Options (non default): 
    Plan: 
----------------
Estimated Per-Host Requirements: Memory=6.20GB VCores=4
WARNING: The following tables are missing relevant table and/or column statistics.
default.web_logs

WRITE TO HDFS [default.weblogs_count, OVERWRITE=true]
|  partitions=1
|  hosts=1 per-host-mem=unavailable
|
12:AGGREGATE [FINALIZE]
|  output: count:merge(*)
|  hosts=2 per-host-mem=unavailable
|  tuple-ids=4 row-size=8B cardinality=1
|
11:EXCHANGE [UNPARTITIONED]
|  hosts=2 per-host-mem=unavailable
|  tuple-ids=4 row-size=8B cardinality=1
|
07:AGGREGATE
|  output: count(*)
|  hosts=2 per-host-mem=10.00MB
|  tuple-ids=4 row-size=8B cardinality=1
|
06:NESTED LOOP JOIN [CROSS JOIN, BROADCAST]
|  hosts=2 per-host-mem=2.00GB
|  tuple-ids=0,1,2,3 row-size=0B cardinality=unavailable
|
|--10:EXCHANGE [BROADCAST]
|  |  hosts=2 per-host-mem=0B
|  |  tuple-ids=3 row-size=0B cardinality=unavailable
|  |
|  03:SCAN HDFS [default.web_logs d, RANDOM]
|     partitions=4/4 files=4 size=404.45KB
|     table stats: unavailable
|     column stats: all
|     hosts=2 per-host-mem=48.00MB
|     tuple-ids=3 row-size=0B cardinality=unavailable
|
05:NESTED LOOP JOIN [CROSS JOIN, BROADCAST]
|  hosts=2 per-host-mem=2.00GB
|  tuple-ids=0,1,2 row-size=0B cardinality=unavailable
|
|--09:EXCHANGE [BROADCAST]
|  |  hosts=2 per-host-mem=0B
|  |  tuple-ids=2 row-size=0B cardinality=unavailable
|  |
|  02:SCAN HDFS [default.web_logs c, RANDOM]
|     partitions=4/4 files=4 size=404.45KB
|     table stats: unavailable
|     column stats: all
|     hosts=2 per-host-mem=48.00MB
|     tuple-ids=2 row-size=0B cardinality=unavailable
|
04:NESTED LOOP JOIN [CROSS JOIN, BROADCAST]
|  hosts=2 per-host-mem=2.00GB
|  tuple-ids=0,1 row-size=0B cardinality=unavailable
|
|--08:EXCHANGE [BROADCAST]
|  |  hosts=2 per-host-mem=0B
|  |  tuple-ids=1 row-size=0B cardinality=unavailable
|  |
|  01:SCAN HDFS [default.web_logs b, RANDOM]
|     partitions=4/4 files=4 size=404.45KB
|     table stats: unavailable
|     column stats: all
|     hosts=2 per-host-mem=48.00MB
|     tuple-ids=1 row-size=0B cardinality=unavailable
|
00:SCAN HDFS [default.web_logs a, RANDOM]
   partitions=4/4 files=4 size=404.45KB
   table stats: unavailable
   column stats: all
   hosts=2 per-host-mem=48.00MB
   tuple-ids=0 row-size=0B cardinality=unavailable
----------------
    Estimated Per-Host Mem: 6654263296
    Estimated Per-Host VCores: 4
    Tables Missing Stats: default.web_logs
    Request Pool: root.cloudera
    Admission result: Admitted immediately
    ExecSummary: 
Operator              #Hosts   Avg Time   Max Time   #Rows  Est. #Rows   Peak Mem  Est. Peak Mem  Detail                
------------------------------------------------------------------------------------------------------------------------
12:AGGREGATE               1  256.999ms  256.999ms       0           1    4.00 KB        -1.00 B  FINALIZE              
11:EXCHANGE                1      1m29s      1m29s       0           1          0        -1.00 B  UNPARTITIONED         
07:AGGREGATE               2    0.000ns    0.000ns       0           1   36.00 KB       10.00 MB                        
06:NESTED LOOP JOIN        2      1m23s      1m24s  10.07B          -1   32.00 KB        2.00 GB  CROSS JOIN, BROADCAST 
|--10:EXCHANGE             2    0.000ns    0.000ns   1.00K          -1          0              0  BROADCAST             
|  03:SCAN HDFS            2  370.499ms  407.999ms   1.00K          -1  272.00 KB       48.00 MB  default.web_logs d    
05:NESTED LOOP JOIN        2   94.999ms   99.999ms  10.08M          -1   24.00 KB        2.00 GB  CROSS JOIN, BROADCAST 
|--09:EXCHANGE             2    0.000ns    0.000ns   1.00K          -1          0              0  BROADCAST             
|  02:SCAN HDFS            2  385.999ms  419.999ms   1.00K          -1  272.00 KB       48.00 MB  default.web_logs c    
04:NESTED LOOP JOIN        2    0.000ns    0.000ns  15.88K          -1   16.00 KB        2.00 GB  CROSS JOIN, BROADCAST 
|--08:EXCHANGE             2    0.000ns    0.000ns   1.00K          -1          0              0  BROADCAST             
|  01:SCAN HDFS            2  354.999ms  403.999ms   1.00K          -1  272.00 KB       48.00 MB  default.web_logs b    
00:SCAN HDFS               2    9.999ms   13.999ms     500          -1  272.00 KB       48.00 MB  default.web_logs a    
    Planner Timeline
      Analysis finished: 6339323
      Equivalence classes computed: 6593108
      Single node plan created: 13163109
      Runtime filters computed: 13219481
      Distributed plan created: 14858524
      Lineage info computed: 16114234
      Planning finished: 24860377
    Query Timeline
      Start execution: 0
      Planning finished: 26999972
      Submit for admission: 28999969
      Completed admission: 28999969
      Ready to start 8 remote fragments: 285999700
      All 8 remote fragments started: 288999697
      Cancelled: 89829905907
      Request finished: 89858905877
      Unregister query: 89858905877
  ImpalaServer
    - ClientFetchWaitTimer: 0
    - InactiveTotalTime: 0
    - RowMaterializationTimer: 0
    - TotalTime: 0
  Execution Profile 7141f7bc14834176:dcbe11ec83e78cb9
    Number of filters: 0
    Filter routing table: 
 ID  Src. Node  Tgt. Node(s)  Targets  Target type  Partition filter  Pending (Expected)  First arrived   Completed
-------------------------------------------------------------------------------------------------------------------

    Fragment start latencies: Count: 8, 25th %-ile: 1ms, 50th %-ile: 1ms, 75th %-ile: 1ms, 90th %-ile: 1ms, 95th %-ile: 1ms, 99.9th %-ile: 1ms
    Per Node Peak Memory Usage: impalad-host-2.cloudera.com:22000(1.16 MB) impalad-host-1.cloudera.com:22000(1.14 MB) 
    - FiltersReceived: 0
    - FinalizationTimer: 25999973
    - InactiveTotalTime: 0
    - TotalTime: 89819905919
    Coordinator Fragment F04
      - AverageThreadTokens: 1.0
      - BloomFilterBytes: 0
      - InactiveTotalTime: 0
      - PeakMemoryUsage: 12288
      - PerHostPeakMemUsage: 0
      - PrepareTime: 256999731
      - RowsProduced: 0
      - TotalCpuTime: 0
      - TotalNetworkReceiveTime: 89459906295
      - TotalNetworkSendTime: 0
      - TotalStorageWaitTime: 0
      - TotalTime: 89716906026
      BlockMgr
        - BlockWritesOutstanding: 0
        - BlocksCreated: 0
        - BlocksRecycled: 0
        - BufferedPins: 0
        - BytesWritten: 0
        - InactiveTotalTime: 0
        - MaxBlockSize: 8388608
        - MemoryLimit: 1105618560
        - PeakMemoryUsage: 0
        - TotalBufferWaitTime: 0
        - TotalEncryptionTime: 0
        - TotalIntegrityCheckTime: 0
        - TotalReadBlockTime: 0
        - TotalTime: 0
      CodeGen
        - CodegenTime: 1999998
        - CompileTime: 3999996
        - InactiveTotalTime: 0
        - LoadTime: 0
        - ModuleBitcodeSize: 2254648
        - NumFunctions: 7
        - NumInstructions: 96
        - OptimizationTime: 66999930
        - PrepareTime: 255999732
        - TotalTime: 326999658
      HdfsTableSink
        - BytesWritten: 0
        - CompressTimer: 0
        - EncodeTimer: 0
        - FilesCreated: 0
        - HdfsWriteTimer: 0
        - InactiveTotalTime: 0
        - PartitionsCreated: 0
        - PeakMemoryUsage: 0
        - RowsInserted: 0
        - TotalTime: 0
      AGGREGATION_NODE (id=12)
        ExecOption: Codegen Enabled
        - BuildTime: 0
        - GetResultsTime: 0
        - HTResizeTime: 0
        - HashBuckets: 0
        - InactiveTotalTime: 0
        - LargestPartitionPercent: 0
        - MaxPartitionLevel: 0
        - NumRepartitions: 0
        - PartitionsCreated: 0
        - PeakMemoryUsage: 4096
        - RowsRepartitioned: 0
        - RowsReturned: 0
        - RowsReturnedRate: 0
        - SpilledPartitions: 0
        - TotalTime: 89716906026
        EXCHANGE_NODE (id=11)
          - BytesReceived: 0
          - ConvertRowBatchTime: 0
          - DeserializeRowBatchTimer: 0
          - FirstBatchArrivalWaitTime: 0
          - InactiveTotalTime: 0
          - PeakMemoryUsage: 0
          - RowsReturned: 0
          - RowsReturnedRate: 0
          - SendersBlockedTimer: 0
          - SendersBlockedTotalTimer(*): 0
          - TotalTime: 89459906295
    Averaged Fragment F00
      split sizes:  min: 185.86 KB, max: 218.59 KB, avg: 202.23 KB, stddev: 16.37 KB
      completion times: min:1m29s  max:1m29s  mean: 1m29s  stddev:499.999us
      execution rates: min:2.08 KB/sec  max:2.44 KB/sec  mean:2.26 KB/sec  stddev:187.75 B/sec
      num instances: 2
      - AverageThreadTokens: 1.008604269293924
      - BloomFilterBytes: 0
      - InactiveTotalTime: 0
      - PeakMemoryUsage: 381928
      - PerHostPeakMemUsage: 1206176
      - PrepareTime: 322999729
      - RowsProduced: 0
      - TotalCpuTime: 209999806
      - TotalNetworkReceiveTime: 284999732
      - TotalNetworkSendTime: 0
      - TotalStorageWaitTime: 16499986
      - TotalTime: 323499728
      CodeGen
        - CodegenTime: 500000
        - CompileTime: 8999992
        - InactiveTotalTime: 0
        - LoadTime: 0
        - ModuleBitcodeSize: 2254648
        - NumFunctions: 9
        - NumInstructions: 144
        - OptimizationTime: 121499898
        - PrepareTime: 319999732
        - TotalTime: 451999621
      DataStreamSender (dst_id=11)
        - BytesSent: 0
        - InactiveTotalTime: 0
        - NetworkThroughput(*): 0
        - OverallThroughput: 0
        - PeakMemoryUsage: 16384
        - RowsReturned: 0
        - SerializeBatchTime: 0
        - TotalTime: 0
        - TransmitDataRPCTime: 0
        - UncompressedRowBatchSize: 0
      AGGREGATION_NODE (id=7)
        - BuildTime: 2370497873
        - GetResultsTime: 0
        - HTResizeTime: 0
        - HashBuckets: 0
        - InactiveTotalTime: 0
        - LargestPartitionPercent: 0
        - MaxPartitionLevel: 0
        - NumRepartitions: 0
        - PartitionsCreated: 0
        - PeakMemoryUsage: 36864
        - RowsRepartitioned: 0
        - RowsReturned: 0
        - RowsReturnedRate: 0
        - SpilledPartitions: 0
        - TotalTime: 322999729
        NESTED_LOOP_JOIN_NODE (id=6)
          - BuildRows: 1000
          - BuildTime: 0
          - InactiveTotalTime: 0
          - LocalTime: 83690427961
          - PeakMemoryUsage: 32768
          - ProbeRows: 1024
          - ProbeTime: 0
          - RowsReturned: 5034003056
          - RowsReturnedRate: 59960694
          - TotalTime: 83893427770
          EXCHANGE_NODE (id=10)
            - BytesReceived: 4016
            - ConvertRowBatchTime: 0
            - DeserializeRowBatchTimer: 0
            - FirstBatchArrivalWaitTime: 1499998
            - InactiveTotalTime: 0
            - PeakMemoryUsage: 0
            - RowsReturned: 1000
            - RowsReturnedRate: 11072
            - SendersBlockedTimer: 0
            - SendersBlockedTotalTimer(*): 0
            - TotalTime: 104499903
          NESTED_LOOP_JOIN_NODE (id=5)
            - BuildRows: 1000
            - BuildTime: 0
            - InactiveTotalTime: 0
            - LocalTime: 94999909
            - PeakMemoryUsage: 24576
            - ProbeRows: 1024
            - ProbeTime: 0
            - RowsReturned: 5038316
            - RowsReturnedRate: 26981552
            - TotalTime: 202999809
            EXCHANGE_NODE (id=9)
              - BytesReceived: 4016
              - ConvertRowBatchTime: 0
              - DeserializeRowBatchTimer: 0
              - FirstBatchArrivalWaitTime: 26999972
              - InactiveTotalTime: 0
              - PeakMemoryUsage: 0
              - RowsReturned: 1000
              - RowsReturnedRate: 15495
              - SendersBlockedTimer: 0
              - SendersBlockedTotalTimer(*): 0
              - TotalTime: 82499921
            NESTED_LOOP_JOIN_NODE (id=4)
              - BuildRows: 1000
              - BuildTime: 0
              - InactiveTotalTime: 0
              - LocalTime: 0
              - PeakMemoryUsage: 16384
              - ProbeRows: 250
              - ProbeTime: 0
              - RowsReturned: 7940
              - RowsReturnedRate: 88650
              - TotalTime: 107999899
              EXCHANGE_NODE (id=8)
                - BytesReceived: 4016
                - ConvertRowBatchTime: 0
                - DeserializeRowBatchTimer: 0
                - FirstBatchArrivalWaitTime: 6499993
                - InactiveTotalTime: 0
                - PeakMemoryUsage: 0
                - RowsReturned: 1000
                - RowsReturnedRate: 12124
                - SendersBlockedTimer: 0
                - SendersBlockedTotalTimer(*): 0
                - TotalTime: 97999908
              HDFS_SCAN_NODE (id=0)
                - AverageHdfsReadThreadConcurrency: 0.0
                - AverageScannerThreadConcurrency: 0.0
                - BytesRead: 207078
                - BytesReadDataNodeCache: 0
                - BytesReadLocal: 0
                - BytesReadRemoteUnexpected: 0
                - BytesReadShortCircuit: 0
                - DecompressionTime: 0
                - InactiveTotalTime: 0
                - MaxCompressedTextFileLength: 0
                - NumDisksAccessed: 0
                - NumScannerThreadsStarted: 2
                - PeakMemoryUsage: 278528
                - PerReadThreadRawHdfsThroughput: 0
                - RemoteScanRanges: 0
                - RowsRead: 498
                - RowsReturned: 250
                - RowsReturnedRate: 29761
                - ScanRangesComplete: 2
                - ScannerThreadsInvoluntaryContextSwitches: 0
                - ScannerThreadsTotalWallClockTime: 22999981
                  - DelimiterParseTime: 499999
                  - MaterializeTupleTime(*): 0
                  - ScannerThreadsSysTime: 0
                  - ScannerThreadsUserTime: 0
                - ScannerThreadsVoluntaryContextSwitches: 8
                - TotalRawHdfsReadTime(*): 0
                - TotalReadThroughput: 2379
                - TotalTime: 9999991
      BlockMgr
        - BlockWritesOutstanding: 0
        - BlocksCreated: 0
        - BlocksRecycled: 0
        - BufferedPins: 0
        - BytesWritten: 0
        - InactiveTotalTime: 0
        - MaxBlockSize: 8388608
        - MemoryLimit: 1105618560
        - PeakMemoryUsage: 0
        - TotalBufferWaitTime: 0
        - TotalEncryptionTime: 0
        - TotalIntegrityCheckTime: 0
        - TotalReadBlockTime: 0
        - TotalTime: 0
    Averaged Fragment F03
      split sizes:  min: 185.86 KB, max: 218.59 KB, avg: 202.23 KB, stddev: 16.37 KB
      completion times: min:427.999ms  max:562.999ms  mean: 495.499ms  stddev:67.499ms
      execution rates: min:388.26 KB/sec  max:434.25 KB/sec  mean:411.26 KB/sec  stddev:22.99 KB/sec
      num instances: 2
      - AverageThreadTokens: 0.75
      - BloomFilterBytes: 0
      - InactiveTotalTime: 0
      - PeakMemoryUsage: 483328
      - PerHostPeakMemUsage: 1206176
      - PrepareTime: 316499736
      - RowsProduced: 500
      - TotalCpuTime: 534999560
      - TotalNetworkReceiveTime: 0
      - TotalNetworkSendTime: 1500000
      - TotalStorageWaitTime: 57999941
      - TotalTime: 372999688
      CodeGen
        - CodegenTime: 499999
        - CompileTime: 7499992
        - InactiveTotalTime: 0
        - LoadTime: 0
        - ModuleBitcodeSize: 2254648
        - NumFunctions: 6
        - NumInstructions: 71
        - OptimizationTime: 108499912
        - PrepareTime: 314499737
        - TotalTime: 430999641
      DataStreamSender (dst_id=10)
        - BytesSent: 4016
        - InactiveTotalTime: 0
        - NetworkThroughput(*): 0
        - OverallThroughput: 0
        - PeakMemoryUsage: 262144
        - RowsReturned: 500
        - SerializeBatchTime: 0
        - TotalTime: 0
        - TransmitDataRPCTime: 0
        - UncompressedRowBatchSize: 4016
      HDFS_SCAN_NODE (id=3)
        - AverageHdfsReadThreadConcurrency: 0.0
        - AverageScannerThreadConcurrency: 0.5
        - BytesRead: 207078
        - BytesReadDataNodeCache: 0
        - BytesReadLocal: 207078
        - BytesReadRemoteUnexpected: 0
        - BytesReadShortCircuit: 207078
        - DecompressionTime: 0
        - InactiveTotalTime: 0
        - MaxCompressedTextFileLength: 0
        - NumDisksAccessed: 1
        - NumScannerThreadsStarted: 2
        - PeakMemoryUsage: 212992
        - PerReadThreadRawHdfsThroughput: 95160095
        - RemoteScanRanges: 0
        - RowsRead: 498
        - RowsReturned: 500
        - RowsReturnedRate: 1363
        - ScanRangesComplete: 2
        - ScannerThreadsInvoluntaryContextSwitches: 1
        - ScannerThreadsTotalWallClockTime: 99999912
          - DelimiterParseTime: 0
          - MaterializeTupleTime(*): 0
          - ScannerThreadsSysTime: 0
          - ScannerThreadsUserTime: 0
        - ScannerThreadsVoluntaryContextSwitches: 10
        - TotalRawHdfsReadTime(*): 499999
        - TotalReadThroughput: 54061
        - TotalTime: 370499689
    Averaged Fragment F02
      split sizes:  min: 185.86 KB, max: 218.59 KB, avg: 202.23 KB, stddev: 16.37 KB
      completion times: min:477.999ms  max:538.999ms  mean: 508.499ms  stddev:30.499ms
      execution rates: min:388.83 KB/sec  max:405.55 KB/sec  mean:397.19 KB/sec  stddev:8.36 KB/sec
      num instances: 2
      - AverageThreadTokens: 0.5
      - BloomFilterBytes: 0
      - InactiveTotalTime: 0
      - PeakMemoryUsage: 548864
      - PerHostPeakMemUsage: 1206176
      - PrepareTime: 341999707
      - RowsProduced: 500
      - TotalCpuTime: 513499565
      - TotalNetworkReceiveTime: 0
      - TotalNetworkSendTime: 0
      - TotalStorageWaitTime: 72499946
      - TotalTime: 389499670
      CodeGen
        - CodegenTime: 0
        - CompileTime: 6999995
        - InactiveTotalTime: 0
        - LoadTime: 0
        - ModuleBitcodeSize: 2254648
        - NumFunctions: 6
        - NumInstructions: 71
        - OptimizationTime: 110499904
        - PrepareTime: 340499708
        - TotalTime: 458999607
      DataStreamSender (dst_id=9)
        - BytesSent: 4016
        - InactiveTotalTime: 0
        - NetworkThroughput(*): 0
        - OverallThroughput: 0
        - PeakMemoryUsage: 262144
        - RowsReturned: 500
        - SerializeBatchTime: 0
        - TotalTime: 0
        - TransmitDataRPCTime: 0
        - UncompressedRowBatchSize: 4016
      HDFS_SCAN_NODE (id=2)
        - AverageHdfsReadThreadConcurrency: 0.0
        - AverageScannerThreadConcurrency: 0.0
        - BytesRead: 207078
        - BytesReadDataNodeCache: 0
        - BytesReadLocal: 207078
        - BytesReadRemoteUnexpected: 0
        - BytesReadShortCircuit: 207078
        - DecompressionTime: 0
        - InactiveTotalTime: 0
        - MaxCompressedTextFileLength: 0
        - NumDisksAccessed: 1
        - NumScannerThreadsStarted: 2
        - PeakMemoryUsage: 278528
        - PerReadThreadRawHdfsThroughput: 207078690
        - RemoteScanRanges: 0
        - RowsRead: 498
        - RowsReturned: 500
        - RowsReturnedRate: 1305
        - ScanRangesComplete: 2
        - ScannerThreadsInvoluntaryContextSwitches: 2
        - ScannerThreadsTotalWallClockTime: 78499942
          - DelimiterParseTime: 0
          - MaterializeTupleTime(*): 0
          - ScannerThreadsSysTime: 0
          - ScannerThreadsUserTime: 0
        - ScannerThreadsVoluntaryContextSwitches: 7
        - TotalRawHdfsReadTime(*): 999999
        - TotalReadThroughput: 0
        - TotalTime: 385999673
    Averaged Fragment F01
      split sizes:  min: 185.86 KB, max: 218.59 KB, avg: 202.23 KB, stddev: 16.37 KB
      completion times: min:435.999ms  max:554.999ms  mean: 495.499ms  stddev:59.499ms
      execution rates: min:393.86 KB/sec  max:426.28 KB/sec  mean:410.07 KB/sec  stddev:16.21 KB/sec
      num instances: 2
      - AverageThreadTokens: 0.75
      - BloomFilterBytes: 0
      - InactiveTotalTime: 0
      - PeakMemoryUsage: 483328
      - PerHostPeakMemUsage: 1206176
      - PrepareTime: 308499740
      - RowsProduced: 500
      - TotalCpuTime: 561499531
      - TotalNetworkReceiveTime: 0
      - TotalNetworkSendTime: 999999
      - TotalStorageWaitTime: 16999988
      - TotalTime: 367499694
      CodeGen
        - CodegenTime: 999999
        - CompileTime: 9999991
        - InactiveTotalTime: 0
        - LoadTime: 0
        - ModuleBitcodeSize: 2254648
        - NumFunctions: 6
        - NumInstructions: 71
        - OptimizationTime: 116499902
        - PrepareTime: 306999741
        - TotalTime: 433999634
      DataStreamSender (dst_id=8)
        - BytesSent: 4016
        - InactiveTotalTime: 0
        - NetworkThroughput(*): 2008002
        - OverallThroughput: 2008002
        - PeakMemoryUsage: 262144
        - RowsReturned: 500
        - SerializeBatchTime: 0
        - TotalTime: 499999
        - TransmitDataRPCTime: 499999
        - UncompressedRowBatchSize: 4016
      HDFS_SCAN_NODE (id=1)
        - AverageHdfsReadThreadConcurrency: 0.0
        - AverageScannerThreadConcurrency: 0.5
        - BytesRead: 207078
        - BytesReadDataNodeCache: 0
        - BytesReadLocal: 207078
        - BytesReadRemoteUnexpected: 0
        - BytesReadShortCircuit: 207078
        - DecompressionTime: 0
        - InactiveTotalTime: 0
        - MaxCompressedTextFileLength: 0
        - NumDisksAccessed: 1
        - NumScannerThreadsStarted: 2
        - PeakMemoryUsage: 212992
        - PerReadThreadRawHdfsThroughput: 0
        - RemoteScanRanges: 0
        - RowsRead: 498
        - RowsReturned: 500
        - RowsReturnedRate: 1435
        - ScanRangesComplete: 2
        - ScannerThreadsInvoluntaryContextSwitches: 0
        - ScannerThreadsTotalWallClockTime: 84999932
          - DelimiterParseTime: 0
          - MaterializeTupleTime(*): 0
          - ScannerThreadsSysTime: 0
          - ScannerThreadsUserTime: 0
        - ScannerThreadsVoluntaryContextSwitches: 9
        - TotalRawHdfsReadTime(*): 0
        - TotalReadThroughput: 54061
        - TotalTime: 354999703
    Fragment F00
      Instance 7141f7bc14834176:dcbe11ec83e78cbc (host=impalad-host-2.cloudera.com:22000)
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:2/218.59 KB 
        - AverageThreadTokens: 1.0057142857142858
        - BloomFilterBytes: 0
        - InactiveTotalTime: 0
        - PeakMemoryUsage: 380928
        - PerHostPeakMemUsage: 1214320
        - PrepareTime: 350999768
        - RowsProduced: 0
        - TotalCpuTime: 140999901
        - TotalNetworkReceiveTime: 168999886
        - TotalNetworkSendTime: 0
        - TotalStorageWaitTime: 19999985
        - TotalTime: 350999768
        BlockMgr
          - BlockWritesOutstanding: 0
          - BlocksCreated: 0
          - BlocksRecycled: 0
          - BufferedPins: 0
          - BytesWritten: 0
          - InactiveTotalTime: 0
          - MaxBlockSize: 8388608
          - MemoryLimit: 1105618560
          - PeakMemoryUsage: 0
          - TotalBufferWaitTime: 0
          - TotalEncryptionTime: 0
          - TotalIntegrityCheckTime: 0
          - TotalReadBlockTime: 0
          - TotalTime: 0
        CodeGen
          - CodegenTime: 1000000
          - CompileTime: 9999993
          - InactiveTotalTime: 0
          - LoadTime: 0
          - ModuleBitcodeSize: 2254648
          - NumFunctions: 9
          - NumInstructions: 144
          - OptimizationTime: 132999911
          - PrepareTime: 346999772
          - TotalTime: 491999673
        DataStreamSender (dst_id=11)
          - BytesSent: 0
          - InactiveTotalTime: 0
          - NetworkThroughput(*): 0
          - OverallThroughput: 0
          - PeakMemoryUsage: 16384
          - RowsReturned: 0
          - SerializeBatchTime: 0
          - TotalTime: 0
          - TransmitDataRPCTime: 0
          - UncompressedRowBatchSize: 0
        AGGREGATION_NODE (id=7)
          ExecOption: Codegen Enabled
          - BuildTime: 2095998507
          - GetResultsTime: 0
          - HTResizeTime: 0
          - HashBuckets: 0
          - InactiveTotalTime: 0
          - LargestPartitionPercent: 0
          - MaxPartitionLevel: 0
          - NumRepartitions: 0
          - PartitionsCreated: 0
          - PeakMemoryUsage: 36864
          - RowsRepartitioned: 0
          - RowsReturned: 0
          - RowsReturnedRate: 0
          - SpilledPartitions: 0
          - TotalTime: 350999768
          NESTED_LOOP_JOIN_NODE (id=6)
            ExecOption: Join Build-Side Prepared Asynchronously
            - BuildRows: 1000
            - BuildTime: 0
            - InactiveTotalTime: 0
            - LocalTime: 84003943275
            - PeakMemoryUsage: 32768
            - ProbeRows: 1024
            - ProbeTime: 0
            - RowsReturned: 6183697216
            - RowsReturnedRate: 73469428
            - TotalTime: 84166943157
            EXCHANGE_NODE (id=10)
              - BytesReceived: 4016
              - ConvertRowBatchTime: 0
              - DeserializeRowBatchTimer: 0
              - FirstBatchArrivalWaitTime: 0
              - InactiveTotalTime: 65999956
              - PeakMemoryUsage: 0
              - RowsReturned: 1000
              - RowsReturnedRate: 15151
              - SendersBlockedTimer: 0
              - SendersBlockedTotalTimer(*): 0
              - TotalTime: 65999956
            NESTED_LOOP_JOIN_NODE (id=5)
              ExecOption: Join Build-Side Prepared Asynchronously
              - BuildRows: 1000
              - BuildTime: 0
              - InactiveTotalTime: 0
              - LocalTime: 89999934
              - PeakMemoryUsage: 24576
              - ProbeRows: 1024
              - ProbeTime: 0
              - RowsReturned: 6186648
              - RowsReturnedRate: 37954923
              - TotalTime: 162999882
              EXCHANGE_NODE (id=9)
                - BytesReceived: 4016
                - ConvertRowBatchTime: 0
                - DeserializeRowBatchTimer: 0
                - FirstBatchArrivalWaitTime: 0
                - InactiveTotalTime: 43999969
                - PeakMemoryUsage: 0
                - RowsReturned: 1000
                - RowsReturnedRate: 22727
                - SendersBlockedTimer: 0
                - SendersBlockedTotalTimer(*): 0
                - TotalTime: 43999969
              NESTED_LOOP_JOIN_NODE (id=4)
                - BuildRows: 1000
                - BuildTime: 0
                - InactiveTotalTime: 0
                - LocalTime: 0
                - PeakMemoryUsage: 16384
                - ProbeRows: 250
                - ProbeTime: 0
                - RowsReturned: 9880
                - RowsReturnedRate: 135342
                - TotalTime: 72999948
                EXCHANGE_NODE (id=8)
                  - BytesReceived: 4016
                  - ConvertRowBatchTime: 0
                  - DeserializeRowBatchTimer: 0
                  - FirstBatchArrivalWaitTime: 0
                  - InactiveTotalTime: 58999961
                  - PeakMemoryUsage: 0
                  - RowsReturned: 1000
                  - RowsReturnedRate: 16949
                  - SendersBlockedTimer: 0
                  - SendersBlockedTotalTimer(*): 0
                  - TotalTime: 58999961
                HDFS_SCAN_NODE (id=0)
                  ExecOption: Expr Evaluation Codegen Disabled
                  Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:2/218.59 KB 
                  - AverageHdfsReadThreadConcurrency: 0.0
                  - AverageScannerThreadConcurrency: 0.0
                  - BytesRead: 223837
                  - BytesReadDataNodeCache: 0
                  - BytesReadLocal: 0
                  - BytesReadRemoteUnexpected: 0
                  - BytesReadShortCircuit: 0
                  - DecompressionTime: 0
                  - InactiveTotalTime: 0
                  - MaxCompressedTextFileLength: 0
                  - NumDisksAccessed: 0
                  - NumScannerThreadsStarted: 2
                  - PeakMemoryUsage: 278528
                  - PerReadThreadRawHdfsThroughput: 0
                  - RemoteScanRanges: 0
                  - RowsRead: 498
                  - RowsReturned: 250
                  - RowsReturnedRate: 17857
                  - ScanRangesComplete: 2
                  - ScannerThreadsInvoluntaryContextSwitches: 0
                  - ScannerThreadsTotalWallClockTime: 30999976
                    - DelimiterParseTime: 999999
                    - MaterializeTupleTime(*): 0
                    - ScannerThreadsSysTime: 0
                    - ScannerThreadsUserTime: 0
                  - ScannerThreadsVoluntaryContextSwitches: 10
                  - TotalRawHdfsReadTime(*): 0
                  - TotalReadThroughput: 2572
                  - TotalTime: 13999987
      Instance 7141f7bc14834176:dcbe11ec83e78cbb (host=impalad-host-1.cloudera.com:22000)
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:2/185.86 KB 
        - AverageThreadTokens: 1.0114942528735633
        - BloomFilterBytes: 0
        - InactiveTotalTime: 0
        - PeakMemoryUsage: 382928
        - PerHostPeakMemUsage: 1198032
        - PrepareTime: 294999690
        - RowsProduced: 0
        - TotalCpuTime: 278999711
        - TotalNetworkReceiveTime: 400999579
        - TotalNetworkSendTime: 0
        - TotalStorageWaitTime: 12999988
        - TotalTime: 295999689
        CodeGen
          - CodegenTime: 0
          - CompileTime: 7999992
          - InactiveTotalTime: 0
          - LoadTime: 0
          - ModuleBitcodeSize: 2254648
          - NumFunctions: 9
          - NumInstructions: 144
          - OptimizationTime: 109999885
          - PrepareTime: 292999693
          - TotalTime: 411999569
        DataStreamSender (dst_id=11)
          - BytesSent: 0
          - InactiveTotalTime: 0
          - NetworkThroughput(*): 0
          - OverallThroughput: 0
          - PeakMemoryUsage: 16384
          - RowsReturned: 0
          - SerializeBatchTime: 0
          - TotalTime: 0
          - TransmitDataRPCTime: 0
          - UncompressedRowBatchSize: 0
        AGGREGATION_NODE (id=7)
          ExecOption: Codegen Enabled
          - BuildTime: 2644997240
          - GetResultsTime: 0
          - HTResizeTime: 0
          - HashBuckets: 0
          - InactiveTotalTime: 0
          - LargestPartitionPercent: 0
          - MaxPartitionLevel: 0
          - NumRepartitions: 0
          - PartitionsCreated: 0
          - PeakMemoryUsage: 36864
          - RowsRepartitioned: 0
          - RowsReturned: 0
          - RowsReturnedRate: 0
          - SpilledPartitions: 0
          - TotalTime: 294999690
          NESTED_LOOP_JOIN_NODE (id=6)
            ExecOption: Join Build-Side Prepared Asynchronously
            - BuildRows: 1000
            - BuildTime: 0
            - InactiveTotalTime: 0
            - LocalTime: 83376912647
            - PeakMemoryUsage: 32768
            - ProbeRows: 1024
            - ProbeTime: 0
            - RowsReturned: 3884308896
            - RowsReturnedRate: 46451960
            - TotalTime: 83619912383
            EXCHANGE_NODE (id=10)
              - BytesReceived: 4016
              - ConvertRowBatchTime: 0
              - DeserializeRowBatchTimer: 0
              - FirstBatchArrivalWaitTime: 2999997
              - InactiveTotalTime: 142999851
              - PeakMemoryUsage: 0
              - RowsReturned: 1000
              - RowsReturnedRate: 6993
              - SendersBlockedTimer: 0
              - SendersBlockedTotalTimer(*): 0
              - TotalTime: 142999851
            NESTED_LOOP_JOIN_NODE (id=5)
              ExecOption: Join Build-Side Prepared Asynchronously
              - BuildRows: 1000
              - BuildTime: 0
              - InactiveTotalTime: 0
              - LocalTime: 99999885
              - PeakMemoryUsage: 24576
              - ProbeRows: 1024
              - ProbeTime: 0
              - RowsReturned: 3889984
              - RowsReturnedRate: 16008182
              - TotalTime: 242999736
              EXCHANGE_NODE (id=9)
                - BytesReceived: 4016
                - ConvertRowBatchTime: 0
                - DeserializeRowBatchTimer: 0
                - FirstBatchArrivalWaitTime: 53999945
                - InactiveTotalTime: 120999873
                - PeakMemoryUsage: 0
                - RowsReturned: 1000
                - RowsReturnedRate: 8264
                - SendersBlockedTimer: 0
                - SendersBlockedTotalTimer(*): 0
                - TotalTime: 120999873
              NESTED_LOOP_JOIN_NODE (id=4)
                - BuildRows: 1000
                - BuildTime: 0
                - InactiveTotalTime: 0
                - LocalTime: 0
                - PeakMemoryUsage: 16384
                - ProbeRows: 250
                - ProbeTime: 0
                - RowsReturned: 6000
                - RowsReturnedRate: 41958
                - TotalTime: 142999851
                EXCHANGE_NODE (id=8)
                  - BytesReceived: 4016
                  - ConvertRowBatchTime: 0
                  - DeserializeRowBatchTimer: 0
                  - FirstBatchArrivalWaitTime: 12999987
                  - InactiveTotalTime: 136999855
                  - PeakMemoryUsage: 0
                  - RowsReturned: 1000
                  - RowsReturnedRate: 7299
                  - SendersBlockedTimer: 0
                  - SendersBlockedTotalTimer(*): 0
                  - TotalTime: 136999855
                HDFS_SCAN_NODE (id=0)
                  ExecOption: Expr Evaluation Codegen Disabled
                  Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:2/185.86 KB 
                  - AverageHdfsReadThreadConcurrency: 0.0
                  - AverageScannerThreadConcurrency: 0.0
                  - BytesRead: 190320
                  - BytesReadDataNodeCache: 0
                  - BytesReadLocal: 0
                  - BytesReadRemoteUnexpected: 0
                  - BytesReadShortCircuit: 0
                  - DecompressionTime: 0
                  - InactiveTotalTime: 0
                  - MaxCompressedTextFileLength: 0
                  - NumDisksAccessed: 0
                  - NumScannerThreadsStarted: 2
                  - PeakMemoryUsage: 278528
                  - PerReadThreadRawHdfsThroughput: 0
                  - RemoteScanRanges: 0
                  - RowsRead: 498
                  - RowsReturned: 250
                  - RowsReturnedRate: 41666
                  - ScanRangesComplete: 2
                  - ScannerThreadsInvoluntaryContextSwitches: 0
                  - ScannerThreadsTotalWallClockTime: 14999987
                    - DelimiterParseTime: 0
                    - MaterializeTupleTime(*): 0
                    - ScannerThreadsSysTime: 0
                    - ScannerThreadsUserTime: 0
                  - ScannerThreadsVoluntaryContextSwitches: 7
                  - TotalRawHdfsReadTime(*): 0
                  - TotalReadThroughput: 2187
                  - TotalTime: 5999996
    Fragment F03
      Instance 7141f7bc14834176:dcbe11ec83e78cbe (host=impalad-host-2.cloudera.com:22000)
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:2/218.59 KB 
        - AverageThreadTokens: 1.5
        - BloomFilterBytes: 0
        - InactiveTotalTime: 0
        - PeakMemoryUsage: 417792
        - PerHostPeakMemUsage: 1214320
        - PrepareTime: 351999767
        - RowsProduced: 500
        - TotalCpuTime: 636999575
        - TotalNetworkReceiveTime: 0
        - TotalNetworkSendTime: 2000001
        - TotalStorageWaitTime: 24999979
        - TotalTime: 410999729
        CodeGen
          - CodegenTime: 999999
          - CompileTime: 5999994
          - InactiveTotalTime: 0
          - LoadTime: 0
          - ModuleBitcodeSize: 2254648
          - NumFunctions: 6
          - NumInstructions: 71
          - OptimizationTime: 133999911
          - PrepareTime: 348999768
          - TotalTime: 489999673
        DataStreamSender (dst_id=10)
          - BytesSent: 4016
          - InactiveTotalTime: 0
          - NetworkThroughput(*): 0
          - OverallThroughput: 0
          - PeakMemoryUsage: 262144
          - RowsReturned: 500
          - SerializeBatchTime: 0
          - TotalTime: 0
          - TransmitDataRPCTime: 0
          - UncompressedRowBatchSize: 4016
        HDFS_SCAN_NODE (id=3)
          ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 2 out of 2
          Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:2/218.59 KB 
          Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 
          File Formats: TEXT/NONE:2 
          - AverageHdfsReadThreadConcurrency: 0.0
          - AverageScannerThreadConcurrency: 1.0
          - BytesRead: 223837
          - BytesReadDataNodeCache: 0
          - BytesReadLocal: 223837
          - BytesReadRemoteUnexpected: 0
          - BytesReadShortCircuit: 223837
          - DecompressionTime: 0
          - InactiveTotalTime: 0
          - MaxCompressedTextFileLength: 0
          - NumDisksAccessed: 1
          - NumScannerThreadsStarted: 2
          - PeakMemoryUsage: 147456
          - PerReadThreadRawHdfsThroughput: 0
          - RemoteScanRanges: 0
          - RowsRead: 498
          - RowsReturned: 500
          - RowsReturnedRate: 1225
          - ScanRangesComplete: 2
          - ScannerThreadsInvoluntaryContextSwitches: 1
          - ScannerThreadsTotalWallClockTime: 101999928
            - DelimiterParseTime: 0
            - MaterializeTupleTime(*): 0
            - ScannerThreadsSysTime: 0
            - ScannerThreadsUserTime: 0
          - ScannerThreadsVoluntaryContextSwitches: 11
          - TotalRawHdfsReadTime(*): 0
          - TotalReadThroughput: 108123
          - TotalTime: 407999728
      Instance 7141f7bc14834176:dcbe11ec83e78cbd (host=impalad-host-1.cloudera.com:22000)
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:2/185.86 KB 
        - AverageThreadTokens: 0.0
        - BloomFilterBytes: 0
        - InactiveTotalTime: 0
        - PeakMemoryUsage: 548864
        - PerHostPeakMemUsage: 1198032
        - PrepareTime: 280999705
        - RowsProduced: 500
        - TotalCpuTime: 432999545
        - TotalNetworkReceiveTime: 0
        - TotalNetworkSendTime: 999999
        - TotalStorageWaitTime: 90999904
        - TotalTime: 334999648
        CodeGen
          - CodegenTime: 0
          - CompileTime: 8999991
          - InactiveTotalTime: 0
          - LoadTime: 0
          - ModuleBitcodeSize: 2254648
          - NumFunctions: 6
          - NumInstructions: 71
          - OptimizationTime: 82999913
          - PrepareTime: 279999706
          - TotalTime: 371999610
        DataStreamSender (dst_id=10)
          - BytesSent: 4016
          - InactiveTotalTime: 0
          - NetworkThroughput(*): 0
          - OverallThroughput: 0
          - PeakMemoryUsage: 262144
          - RowsReturned: 500
          - SerializeBatchTime: 0
          - TotalTime: 0
          - TransmitDataRPCTime: 0
          - UncompressedRowBatchSize: 4016
        HDFS_SCAN_NODE (id=3)
          ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 2 out of 2
          Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:2/185.86 KB 
          Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 
          File Formats: TEXT/NONE:2 
          - AverageHdfsReadThreadConcurrency: 0.0
          - AverageScannerThreadConcurrency: 0.0
          - BytesRead: 190320
          - BytesReadDataNodeCache: 0
          - BytesReadLocal: 190320
          - BytesReadRemoteUnexpected: 0
          - BytesReadShortCircuit: 190320
          - DecompressionTime: 0
          - InactiveTotalTime: 0
          - MaxCompressedTextFileLength: 0
          - NumDisksAccessed: 1
          - NumScannerThreadsStarted: 2
          - PeakMemoryUsage: 278528
          - PerReadThreadRawHdfsThroughput: 190320190
          - RemoteScanRanges: 0
          - RowsRead: 498
          - RowsReturned: 500
          - RowsReturnedRate: 1501
          - ScanRangesComplete: 2
          - ScannerThreadsInvoluntaryContextSwitches: 1
          - ScannerThreadsTotalWallClockTime: 97999896
            - DelimiterParseTime: 0
            - MaterializeTupleTime(*): 0
            - ScannerThreadsSysTime: 0
            - ScannerThreadsUserTime: 0
          - ScannerThreadsVoluntaryContextSwitches: 9
          - TotalRawHdfsReadTime(*): 999999
          - TotalReadThroughput: 0
          - TotalTime: 332999650
    Fragment F02
      Instance 7141f7bc14834176:dcbe11ec83e78cc0 (host=impalad-host-2.cloudera.com:22000)
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:2/218.59 KB 
        - AverageThreadTokens: 1.0
        - BloomFilterBytes: 0
        - InactiveTotalTime: 0
        - PeakMemoryUsage: 548864
        - PerHostPeakMemUsage: 1214320
        - PrepareTime: 343999771
        - RowsProduced: 500
        - TotalCpuTime: 549999632
        - TotalNetworkReceiveTime: 0
        - TotalNetworkSendTime: 0
        - TotalStorageWaitTime: 127999913
        - TotalTime: 421999718
        CodeGen
          - CodegenTime: 0
          - CompileTime: 8999994
          - InactiveTotalTime: 0
          - LoadTime: 0
          - ModuleBitcodeSize: 2254648
          - NumFunctions: 6
          - NumInstructions: 71
          - OptimizationTime: 106999928
          - PrepareTime: 342999771
          - TotalTime: 459999693
        DataStreamSender (dst_id=9)
          - BytesSent: 4016
          - InactiveTotalTime: 0
          - NetworkThroughput(*): 0
          - OverallThroughput: 0
          - PeakMemoryUsage: 262144
          - RowsReturned: 500
          - SerializeBatchTime: 0
          - TotalTime: 0
          - TransmitDataRPCTime: 0
          - UncompressedRowBatchSize: 4016
        HDFS_SCAN_NODE (id=2)
          ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 2 out of 2
          Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:2/218.59 KB 
          Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 
          File Formats: TEXT/NONE:2 
          - AverageHdfsReadThreadConcurrency: 0.0
          - AverageScannerThreadConcurrency: 0.0
          - BytesRead: 223837
          - BytesReadDataNodeCache: 0
          - BytesReadLocal: 223837
          - BytesReadRemoteUnexpected: 0
          - BytesReadShortCircuit: 223837
          - DecompressionTime: 0
          - InactiveTotalTime: 0
          - MaxCompressedTextFileLength: 0
          - NumDisksAccessed: 1
          - NumScannerThreadsStarted: 2
          - PeakMemoryUsage: 278528
          - PerReadThreadRawHdfsThroughput: 223837000
          - RemoteScanRanges: 0
          - RowsRead: 498
          - RowsReturned: 500
          - RowsReturnedRate: 1190
          - ScanRangesComplete: 2
          - ScannerThreadsInvoluntaryContextSwitches: 4
          - ScannerThreadsTotalWallClockTime: 139999905
            - DelimiterParseTime: 0
            - MaterializeTupleTime(*): 0
            - ScannerThreadsSysTime: 0
            - ScannerThreadsUserTime: 0
          - ScannerThreadsVoluntaryContextSwitches: 7
          - TotalRawHdfsReadTime(*): 1000000
          - TotalReadThroughput: 0
          - TotalTime: 419999719
      Instance 7141f7bc14834176:dcbe11ec83e78cbf (host=impalad-host-1.cloudera.com:22000)
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:2/185.86 KB 
        - AverageThreadTokens: 0.0
        - BloomFilterBytes: 0
        - InactiveTotalTime: 0
        - PeakMemoryUsage: 548864
        - PerHostPeakMemUsage: 1198032
        - PrepareTime: 339999643
        - RowsProduced: 500
        - TotalCpuTime: 476999499
        - TotalNetworkReceiveTime: 0
        - TotalNetworkSendTime: 0
        - TotalStorageWaitTime: 16999979
        - TotalTime: 356999623
        CodeGen
          - CodegenTime: 0
          - CompileTime: 4999997
          - InactiveTotalTime: 0
          - LoadTime: 0
          - ModuleBitcodeSize: 2254648
          - NumFunctions: 6
          - NumInstructions: 71
          - OptimizationTime: 113999880
          - PrepareTime: 337999645
          - TotalTime: 457999521
        DataStreamSender (dst_id=9)
          - BytesSent: 4016
          - InactiveTotalTime: 0
          - NetworkThroughput(*): 0
          - OverallThroughput: 0
          - PeakMemoryUsage: 262144
          - RowsReturned: 500
          - SerializeBatchTime: 0
          - TotalTime: 0
          - TransmitDataRPCTime: 0
          - UncompressedRowBatchSize: 4016
        HDFS_SCAN_NODE (id=2)
          ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 2 out of 2
          Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:2/185.86 KB 
          Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 
          File Formats: TEXT/NONE:2 
          - AverageHdfsReadThreadConcurrency: 0.0
          - AverageScannerThreadConcurrency: 0.0
          - BytesRead: 190320
          - BytesReadDataNodeCache: 0
          - BytesReadLocal: 190320
          - BytesReadRemoteUnexpected: 0
          - BytesReadShortCircuit: 190320
          - DecompressionTime: 0
          - InactiveTotalTime: 0
          - MaxCompressedTextFileLength: 0
          - NumDisksAccessed: 1
          - NumScannerThreadsStarted: 2
          - PeakMemoryUsage: 278528
          - PerReadThreadRawHdfsThroughput: 190320380
          - RemoteScanRanges: 0
          - RowsRead: 498
          - RowsReturned: 500
          - RowsReturnedRate: 1420
          - ScanRangesComplete: 2
          - ScannerThreadsInvoluntaryContextSwitches: 0
          - ScannerThreadsTotalWallClockTime: 16999979
            - DelimiterParseTime: 0
            - MaterializeTupleTime(*): 0
            - ScannerThreadsSysTime: 0
            - ScannerThreadsUserTime: 0
          - ScannerThreadsVoluntaryContextSwitches: 8
          - TotalRawHdfsReadTime(*): 999998
          - TotalReadThroughput: 0
          - TotalTime: 351999628
    Fragment F01
      Instance 7141f7bc14834176:dcbe11ec83e78cc2 (host=impalad-host-2.cloudera.com:22000)
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:2/218.59 KB 
        - AverageThreadTokens: 1.5
        - BloomFilterBytes: 0
        - InactiveTotalTime: 0
        - PeakMemoryUsage: 417792
        - PerHostPeakMemUsage: 1214320
        - PrepareTime: 340999770
        - RowsProduced: 500
        - TotalCpuTime: 644999564
        - TotalNetworkReceiveTime: 0
        - TotalNetworkSendTime: 999999
        - TotalStorageWaitTime: 21999989
        - TotalTime: 413999724
        CodeGen
          - CodegenTime: 999999
          - CompileTime: 7999995
          - InactiveTotalTime: 0
          - LoadTime: 0
          - ModuleBitcodeSize: 2254648
          - NumFunctions: 6
          - NumInstructions: 71
          - OptimizationTime: 130999912
          - PrepareTime: 338999771
          - TotalTime: 478999678
        DataStreamSender (dst_id=8)
          - BytesSent: 4016
          - InactiveTotalTime: 0
          - NetworkThroughput(*): 4016004
          - OverallThroughput: 4016004
          - PeakMemoryUsage: 262144
          - RowsReturned: 500
          - SerializeBatchTime: 0
          - TotalTime: 999999
          - TransmitDataRPCTime: 999999
          - UncompressedRowBatchSize: 4016
        HDFS_SCAN_NODE (id=1)
          ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 2 out of 2
          Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:2/218.59 KB 
          Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 
          File Formats: TEXT/NONE:2 
          - AverageHdfsReadThreadConcurrency: 0.0
          - AverageScannerThreadConcurrency: 1.0
          - BytesRead: 223837
          - BytesReadDataNodeCache: 0
          - BytesReadLocal: 223837
          - BytesReadRemoteUnexpected: 0
          - BytesReadShortCircuit: 223837
          - DecompressionTime: 0
          - InactiveTotalTime: 0
          - MaxCompressedTextFileLength: 0
          - NumDisksAccessed: 1
          - NumScannerThreadsStarted: 2
          - PeakMemoryUsage: 147456
          - PerReadThreadRawHdfsThroughput: 0
          - RemoteScanRanges: 0
          - RowsRead: 498
          - RowsReturned: 500
          - RowsReturnedRate: 1237
          - ScanRangesComplete: 2
          - ScannerThreadsInvoluntaryContextSwitches: 0
          - ScannerThreadsTotalWallClockTime: 113999923
            - DelimiterParseTime: 0
            - MaterializeTupleTime(*): 0
            - ScannerThreadsSysTime: 0
            - ScannerThreadsUserTime: 0
          - ScannerThreadsVoluntaryContextSwitches: 10
          - TotalRawHdfsReadTime(*): 0
          - TotalReadThroughput: 108123
          - TotalTime: 403999728
      Instance 7141f7bc14834176:dcbe11ec83e78cc1 (host=impalad-host-1.cloudera.com:22000)
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:2/185.86 KB 
        - AverageThreadTokens: 0.0
        - BloomFilterBytes: 0
        - InactiveTotalTime: 0
        - PeakMemoryUsage: 548864
        - PerHostPeakMemUsage: 1198032
        - PrepareTime: 275999710
        - RowsProduced: 500
        - TotalCpuTime: 477999499
        - TotalNetworkReceiveTime: 0
        - TotalNetworkSendTime: 999999
        - TotalStorageWaitTime: 11999988
        - TotalTime: 320999664
        CodeGen
          - CodegenTime: 999999
          - CompileTime: 11999987
          - InactiveTotalTime: 0
          - LoadTime: 0
          - ModuleBitcodeSize: 2254648
          - NumFunctions: 6
          - NumInstructions: 71
          - OptimizationTime: 101999893
          - PrepareTime: 274999711
          - TotalTime: 388999591
        DataStreamSender (dst_id=8)
          - BytesSent: 4016
          - InactiveTotalTime: 0
          - NetworkThroughput(*): 0
          - OverallThroughput: 0
          - PeakMemoryUsage: 262144
          - RowsReturned: 500
          - SerializeBatchTime: 0
          - TotalTime: 0
          - TransmitDataRPCTime: 0
          - UncompressedRowBatchSize: 4016
        HDFS_SCAN_NODE (id=1)
          ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 2 out of 2
          Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:2/185.86 KB 
          Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 
          File Formats: TEXT/NONE:2 
          - AverageHdfsReadThreadConcurrency: 0.0
          - AverageScannerThreadConcurrency: 0.0
          - BytesRead: 190320
          - BytesReadDataNodeCache: 0
          - BytesReadLocal: 190320
          - BytesReadRemoteUnexpected: 0
          - BytesReadShortCircuit: 190320
          - DecompressionTime: 0
          - InactiveTotalTime: 0
          - MaxCompressedTextFileLength: 0
          - NumDisksAccessed: 1
          - NumScannerThreadsStarted: 2
          - PeakMemoryUsage: 278528
          - PerReadThreadRawHdfsThroughput: 0
          - RemoteScanRanges: 0
          - RowsRead: 498
          - RowsReturned: 500
          - RowsReturnedRate: 1633
          - ScanRangesComplete: 2
          - ScannerThreadsInvoluntaryContextSwitches: 0
          - ScannerThreadsTotalWallClockTime: 55999942
            - DelimiterParseTime: 0
            - MaterializeTupleTime(*): 0
            - ScannerThreadsSysTime: 0
            - ScannerThreadsUserTime: 0
          - ScannerThreadsVoluntaryContextSwitches: 9
          - TotalRawHdfsReadTime(*): 0
          - TotalReadThroughput: 0
          - TotalTime: 305999679