Query (id=1647f149ee2fcf16:eef12236737c6e82)
  Summary
    Session ID: 1943e068c7ba76f3:82ba3e9fc1b6c082
    Session Type: HIVESERVER2
    HiveServer2 Protocol Version: V5
    Start Time: 2015-03-08 23:20:37.708686000
    End Time: 2015-03-08 23:20:48.988467000
    Query Type: QUERY
    Query State: FINISHED
    Query Status: OK
    Impala Version: impalad version 2.1.2-cdh5 RELEASE (build 92438b7fb62a875041ffd2ab324f408ecf8129e5)
    User: mreynolds-prod
    Connected User: mreynolds-prod
    Delegated User: 
    Network Address: ::ffff:10.16.3.36:56453
    Default Db: irdw_prod
    Sql Statement: select count(*), sum(adv_commission) from action_fact2 where p_action_date_ym in (select p_action_date_ym from action_partitions where p_action_date_ym >= '201401' and p_action_date_ym <= '201401')
    Coordinator: hadoop1.phx.impactradius.net:22000
    Plan: 
----------------
Estimated Per-Host Requirements: Memory=2.03GB VCores=2
WARNING: The following tables are missing relevant table and/or column statistics.
irdw_prod.action_partitions

F02:PLAN FRAGMENT [UNPARTITIONED]
  06:AGGREGATE [FINALIZE]
  |  output: count:merge(*), sum:merge(adv_commission)
  |  hosts=8 per-host-mem=unavailable
  |  tuple-ids=3 row-size=24B cardinality=1
  |
  05:EXCHANGE [UNPARTITIONED]
     hosts=8 per-host-mem=unavailable
     tuple-ids=3 row-size=24B cardinality=1

F00:PLAN FRAGMENT [RANDOM]
  DATASTREAM SINK [FRAGMENT=F02, EXCHANGE=05, UNPARTITIONED]
  03:AGGREGATE
  |  output: count(*), sum(adv_commission)
  |  hosts=8 per-host-mem=10.00MB
  |  tuple-ids=3 row-size=24B cardinality=1
  |
  02:HASH JOIN [LEFT SEMI JOIN, BROADCAST]
  |  hash predicates: p_action_date_ym = p_action_date_ym
  |  hosts=8 per-host-mem=2.00GB
  |  tuple-ids=0 row-size=23B cardinality=2037205
  |
  |--04:EXCHANGE [BROADCAST]
  |     hosts=4 per-host-mem=0B
  |     tuple-ids=1 row-size=15B cardinality=unavailable
  |
  00:SCAN HDFS [irdw_prod.action_fact2, RANDOM]
     partitions=10/531 files=40 size=453.05MB
     table stats: 48700856 rows total
     column stats: all
     hosts=8 per-host-mem=24.00MB
     tuple-ids=0 row-size=23B cardinality=2037205

F01:PLAN FRAGMENT [RANDOM]
  DATASTREAM SINK [FRAGMENT=F00, EXCHANGE=04, BROADCAST]
  01:SCAN HDFS [irdw_prod.action_partitions, RANDOM]
     partitions=1/1 files=4 size=378B
     predicates: p_action_date_ym >= '201401', p_action_date_ym <= '201401'
     table stats: unavailable
     column stats: unavailable
     hosts=4 per-host-mem=32.00MB
     tuple-ids=1 row-size=15B cardinality=unavailable
----------------
    Estimated Per-Host Mem: 2183135232
    Estimated Per-Host VCores: 2
    Tables Missing Stats: irdw_prod.action_partitions
    Request Pool: root.mreynolds-prod
    ExecSummary: 
Operator          #Hosts   Avg Time   Max Time  #Rows  Est. #Rows   Peak Mem  Est. Peak Mem  Detail                      
-------------------------------------------------------------------------------------------------------------------------
06:AGGREGATE           1  215.564ms  215.564ms      1           1   20.00 KB        -1.00 B  FINALIZE                    
05:EXCHANGE            1   72.801us   72.801us      4           1          0        -1.00 B  UNPARTITIONED               
03:AGGREGATE           4  193.594ms   210.89ms      4           1  312.84 KB       10.00 MB                              
02:HASH JOIN           4  171.496ms  207.207ms  2.04M       2.04M    4.02 MB        2.00 GB  LEFT SEMI JOIN, BROADCAST   
|--04:EXCHANGE         4   15.930us   17.309us      1          -1          0              0  BROADCAST                   
|  01:SCAN HDFS        4  213.580ms  235.842ms      1          -1   38.00 KB       32.00 MB  irdw_prod.action_partitions 
00:SCAN HDFS           4   20.446ms   48.887ms  2.04M       2.04M    8.15 MB       24.00 MB  irdw_prod.action_fact2      
    Query Timeline
      Start execution: 51845
      Planning finished: 8826088
      Ready to start remote fragments: 225701029
      Remote fragments started: 657285857
      Rows available: 962857863
      First row fetched: 1398316289
      Unregister query: 11279769617
  ImpalaServer
    - AsyncTotalTime: 0
    - ClientFetchWaitTimer: 10315293494
    - InactiveTotalTime: 0
    - RowMaterializationTimer: 63805
    - TotalTime: 0
  Execution Profile 1647f149ee2fcf16:eef12236737c6e82
    Fragment start latencies:  count: 8, last: 0.219999, min: 0.174701, max: 0.219999, mean: 0.198288, stddev: 0.0165613
    Per Node Peak Memory Usage: hadoop2.phx.impactradius.net:22000(8.06 MB) hadoop4.phx.impactradius.net:22000(8.05 MB) hadoop3.phx.impactradius.net:22000(7.82 MB) hadoop1.phx.impactradius.net:22000(8.40 MB) 
    - AsyncTotalTime: 0
    - FinalizationTimer: 0
    - InactiveTotalTime: 0
    - TotalTime: 954375513
    Coordinator Fragment F02
      - AsyncTotalTime: 0
      - AverageThreadTokens: 1.0
      - InactiveTotalTime: 0
      - PeakMemoryUsage: 36864
      - PerHostPeakMemUsage: 0
      - PrepareTime: 215296920
      - RowsProduced: 1
      - TotalCpuTime: 1291779117
      - TotalNetworkReceiveTime: 96889779
      - TotalNetworkSendTime: 0
      - TotalStorageWaitTime: 0
      - TotalTime: 312853360
      BlockMgr
        - AsyncTotalTime: 0
        - BlockWritesOutstanding: 0
        - BlocksCreated: 64
        - BlocksRecycled: 1
        - BufferedPins: 0
        - BytesWritten: 0
        - InactiveTotalTime: 0
        - MaxBlockSize: 8388608
        - MemoryLimit: 40623513600
        - PeakMemoryUsage: 16
        - TotalBufferWaitTime: 0
        - TotalEncryptionTime: 0
        - TotalIntegrityCheckTime: 0
        - TotalReadBlockTime: 0
        - TotalTime: 0
      CodeGen
        - AsyncTotalTime: 0
        - CodegenTime: 1238870
        - CompileTime: 9236083
        - InactiveTotalTime: 0
        - LoadTime: 143796
        - ModuleFileSize: 2055524
        - OptimizationTime: 198738873
        - PrepareTime: 212329060
        - TotalTime: 422276234
      AGGREGATION_NODE (id=6)
        ExecOption: Codegen Enabled
        - AsyncTotalTime: 0
        - BuildTime: 101601
        - GetResultsTime: 0
        - HashBuckets: 0
        - InactiveTotalTime: 0
        - LargestPartitionPercent: 0
        - MaxPartitionLevel: 0
        - NumRepartitions: 0
        - PartitionsCreated: 0
        - PeakMemoryUsage: 20480
        - RowsRepartitioned: 0
        - RowsReturned: 1
        - RowsReturnedRate: 3
        - SpilledPartitions: 0
        - TotalTime: 312490783
        EXCHANGE_NODE (id=5)
          - AsyncTotalTime: 0
          - BytesReceived: 144
          - ConvertRowBatchTime: 10609
          - DeserializeRowBatchTimer: 197603
          - FirstBatchArrivalWaitTime: 46880123
          - InactiveTotalTime: 96853781
          - PeakMemoryUsage: 0
          - RowsReturned: 4
          - RowsReturnedRate: 41
          - SendersBlockedTimer: 0
          - SendersBlockedTotalTimer(*): 0
          - TotalTime: 96926582
    Averaged Fragment F00
      split sizes:  min: 111.66 MB, max: 115.42 MB, avg: 113.26 MB, stddev: 1.40 MB
      completion times: min:487.55ms  max:563.538ms  mean: 513.71ms  stddev:29.778ms
      execution rates: min:198.15 MB/sec  max:232.97 MB/sec  mean:221.54 MB/sec  stddev:13.72 MB/sec
      num instances: 4
      - AsyncTotalTime: 0
      - AverageThreadTokens: 1.625
      - InactiveTotalTime: 0
      - PeakMemoryUsage: 8473756
      - PerHostPeakMemUsage: 8476828
      - PrepareTime: 191044958
      - RowsProduced: 1
      - TotalCpuTime: 1381991826
      - TotalNetworkReceiveTime: 136020971
      - TotalNetworkSendTime: 420978
      - TotalStorageWaitTime: 131018426
      - TotalTime: 385298233
      BlockMgr
        - AsyncTotalTime: 0
        - BlockWritesOutstanding: 0
        - BlocksCreated: 64
        - BlocksRecycled: 1
        - BufferedPins: 0
        - BytesWritten: 0
        - InactiveTotalTime: 0
        - MaxBlockSize: 8388608
        - MemoryLimit: 41231687680
        - PeakMemoryUsage: 16
        - TotalBufferWaitTime: 0
        - TotalEncryptionTime: 0
        - TotalIntegrityCheckTime: 0
        - TotalReadBlockTime: 0
        - TotalTime: 0
      CodeGen
        - AsyncTotalTime: 0
        - CodegenTime: 527999
        - CompileTime: 61464075
        - InactiveTotalTime: 0
        - LoadTime: 151480
        - ModuleFileSize: 2055524
        - OptimizationTime: 255654909
        - PrepareTime: 184808821
        - TotalTime: 503728603
      DataStreamSender (dst_id=5)
        - AsyncTotalTime: 0
        - BytesSent: 36
        - InactiveTotalTime: 0
        - NetworkThroughput(*): 122216
        - OverallThroughput: 908845
        - PeakMemoryUsage: 4096
        - SerializeBatchTime: 10098
        - ThriftTransmitTime(*): 329485
        - TotalTime: 41050
        - UncompressedRowBatchSize: 40
      AGGREGATION_NODE (id=3)
        - AsyncTotalTime: 0
        - BuildTime: 6092923
        - GetResultsTime: 0
        - HashBuckets: 0
        - InactiveTotalTime: 0
        - LargestPartitionPercent: 0
        - MaxPartitionLevel: 0
        - NumRepartitions: 0
        - PartitionsCreated: 0
        - PeakMemoryUsage: 275588
        - RowsRepartitioned: 0
        - RowsReturned: 1
        - RowsReturnedRate: 2
        - SpilledPartitions: 0
        - TotalTime: 384685125
        HASH_JOIN_NODE (id=2)
          - AsyncTotalTime: 0
          - BuildPartitionTime: 4923
          - BuildRows: 1
          - BuildRowsPartitioned: 1
          - BuildTime: 4942
          - GetNewBlockTime: 182865
          - HashBuckets: 2
          - InactiveTotalTime: 0
          - LargestPartitionPercent: 100
          - MaxPartitionLevel: 0
          - NumRepartitions: 0
          - PartitionsCreated: 32
          - PeakMemoryUsage: 4214784
          - PinTime: 0
          - ProbeRows: 509301
          - ProbeRowsPartitioned: 0
          - ProbeTime: 28087291
          - RowsReturned: 509301
          - RowsReturnedRate: 2746181
          - SpilledPartitions: 0
          - TotalTime: 191090553
          - UnpinTime: 3179
          EXCHANGE_NODE (id=4)
            - AsyncTotalTime: 0
            - BytesReceived: 27
            - ConvertRowBatchTime: 1670
            - DeserializeRowBatchTimer: 14480
            - FirstBatchArrivalWaitTime: 135592540
            - InactiveTotalTime: 0
            - PeakMemoryUsage: 0
            - RowsReturned: 1
            - RowsReturnedRate: 7
            - SendersBlockedTimer: 0
            - SendersBlockedTotalTimer(*): 0
            - TotalTime: 136029729
          HDFS_SCAN_NODE (id=0)
            - AsyncTotalTime: 0
            - AverageHdfsReadThreadConcurrency: 0.0
            - AverageScannerThreadConcurrency: 1.0
            - BytesRead: 1910783
            - BytesReadDataNodeCache: 0
            - BytesReadLocal: 1910783
            - BytesReadRemoteUnexpected: 33580059
            - BytesReadShortCircuit: 1910783
            - DecompressionTime: 1285235
            - InactiveTotalTime: 0
            - MaxCompressedTextFileLength: 0
            - NumColumns: 0
            - NumDisksAccessed: 6
            - NumScannerThreadsStarted: 10
            - PeakMemoryUsage: 8230028
            - PerReadThreadRawHdfsThroughput: 326657610
            - RemoteScanRanges: 123
            - RowsRead: 509301
            - RowsReturned: 509301
            - RowsReturnedRate: 43994078
            - ScanRangesComplete: 10
            - ScannerThreadsInvoluntaryContextSwitches: 86
            - ScannerThreadsTotalWallClockTime: 808900419
              - MaterializeTupleTime(*): 90480481
              - ScannerThreadsSysTime: 417182750
              - ScannerThreadsUserTime: 157720500
            - ScannerThreadsVoluntaryContextSwitches: 7328
            - TotalRawHdfsReadTime(*): 11672939
            - TotalReadThroughput: 965558
            - TotalTime: 20446723
    Averaged Fragment F01
      split sizes:  min: 91.00 B, max: 98.00 B, avg: 94.00 B, stddev: 3.00 B
      completion times: min:179.648ms  max:223.473ms  mean: 206.880ms  stddev:16.418ms
      execution rates: min:407.00 B/sec  max:506.00 B/sec  mean:459.00 B/sec  stddev:35.00 B/sec
      num instances: 4
      - AsyncTotalTime: 0
      - AverageThreadTokens: 0.75
      - InactiveTotalTime: 0
      - PeakMemoryUsage: 68928
      - PerHostPeakMemUsage: 1139520
      - PrepareTime: 201332182
      - RowsProduced: 0
      - TotalCpuTime: 408832171
      - TotalNetworkReceiveTime: 0
      - TotalNetworkSendTime: 158105
      - TotalStorageWaitTime: 11666778
      - TotalTime: 214883980
      CodeGen
        - AsyncTotalTime: 0
        - CodegenTime: 1598881
        - CompileTime: 9827748
        - InactiveTotalTime: 0
        - LoadTime: 504027
        - ModuleFileSize: 2055524
        - OptimizationTime: 182224842
        - PrepareTime: 197557831
        - TotalTime: 391724984
      DataStreamSender (dst_id=4)
        - AsyncTotalTime: 0
        - BytesSent: 43
        - InactiveTotalTime: 0
        - NetworkThroughput(*): 28472
        - OverallThroughput: 127531
        - PeakMemoryUsage: 21824
        - SerializeBatchTime: 8166
        - ThriftTransmitTime(*): 1183856
        - TotalTime: 278634
        - UncompressedRowBatchSize: 54
      HDFS_SCAN_NODE (id=1)
        - AsyncTotalTime: 0
        - AverageHdfsReadThreadConcurrency: 0.0
        - AverageScannerThreadConcurrency: 0.0
        - BytesRead: 94
        - BytesReadDataNodeCache: 0
        - BytesReadLocal: 94
        - BytesReadRemoteUnexpected: 81070
        - BytesReadShortCircuit: 94
        - DecompressionTime: 0
        - InactiveTotalTime: 0
        - MaxCompressedTextFileLength: 0
        - NumDisksAccessed: 1
        - NumScannerThreadsStarted: 1
        - PeakMemoryUsage: 38912
        - PerReadThreadRawHdfsThroughput: 6581553
        - RemoteScanRanges: 107
        - RowsRead: 13
        - RowsReturned: 0
        - RowsReturnedRate: 1
        - ScanRangesComplete: 1
        - ScannerThreadsInvoluntaryContextSwitches: 0
        - ScannerThreadsTotalWallClockTime: 11859592
          - DelimiterParseTime: 2799
          - MaterializeTupleTime(*): 4146
          - ScannerThreadsSysTime: 0
          - ScannerThreadsUserTime: 0
        - ScannerThreadsVoluntaryContextSwitches: 3
        - TotalRawHdfsReadTime(*): 15214
        - TotalReadThroughput: 0
        - TotalTime: 213580874
    Fragment F00
      Instance 1647f149ee2fcf16:eef12236737c6e86 (host=hadoop4.phx.impactradius.net:22000)
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 2:1/9.02 MB 7:2/18.19 MB 4:2/31.41 MB 3:1/19.51 MB 10:2/17.84 MB 1:1/13.83 MB 5:1/1.86 MB 
        - AsyncTotalTime: 0
        - AverageThreadTokens: 1.0
        - InactiveTotalTime: 0
        - PeakMemoryUsage: 8442888
        - PerHostPeakMemUsage: 8442888
        - PrepareTime: 172437214
        - RowsProduced: 1
        - TotalCpuTime: 2379404902
        - TotalNetworkReceiveTime: 146746094
        - TotalNetworkSendTime: 537434
        - TotalStorageWaitTime: 260672197
        - TotalTime: 408744908
        BlockMgr
          - AsyncTotalTime: 0
          - BlockWritesOutstanding: 0
          - BlocksCreated: 64
          - BlocksRecycled: 1
          - BufferedPins: 0
          - BytesWritten: 0
          - InactiveTotalTime: 0
          - MaxBlockSize: 8388608
          - MemoryLimit: 41231687680
          - PeakMemoryUsage: 16
          - TotalBufferWaitTime: 0
          - TotalEncryptionTime: 0
          - TotalIntegrityCheckTime: 0
          - TotalReadBlockTime: 0
          - TotalTime: 0
        CodeGen
          - AsyncTotalTime: 0
          - CodegenTime: 441563
          - CompileTime: 62964596
          - InactiveTotalTime: 0
          - LoadTime: 193576
          - ModuleFileSize: 2055524
          - OptimizationTime: 261922311
          - PrepareTime: 166956811
          - TotalTime: 493532456
        DataStreamSender (dst_id=5)
          - AsyncTotalTime: 0
          - BytesSent: 36
          - InactiveTotalTime: 0
          - NetworkThroughput(*): 90739
          - OverallThroughput: 655331
          - PeakMemoryUsage: 4096
          - SerializeBatchTime: 13725
          - ThriftTransmitTime(*): 396738
          - TotalTime: 54934
          - UncompressedRowBatchSize: 40
        AGGREGATION_NODE (id=3)
          ExecOption: Codegen Enabled
          - AsyncTotalTime: 0
          - BuildTime: 6650748
          - GetResultsTime: 0
          - HashBuckets: 0
          - InactiveTotalTime: 0
          - LargestPartitionPercent: 0
          - MaxPartitionLevel: 0
          - NumRepartitions: 0
          - PartitionsCreated: 0
          - PeakMemoryUsage: 248032
          - RowsRepartitioned: 0
          - RowsReturned: 1
          - RowsReturnedRate: 2
          - SpilledPartitions: 0
          - TotalTime: 408013714
          HASH_JOIN_NODE (id=2)
            ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Filter Pushed Down
            - AsyncTotalTime: 147415486
            - BuildPartitionTime: 5393
            - BuildRows: 1
            - BuildRowsPartitioned: 1
            - BuildTime: 5120
            - GetNewBlockTime: 151714
            - HashBuckets: 2
            - InactiveTotalTime: 0
            - LargestPartitionPercent: 100
            - MaxPartitionLevel: 0
            - NumRepartitions: 0
            - PartitionsCreated: 32
            - PeakMemoryUsage: 4214784
            - PinTime: 0
            - ProbeRows: 474668
            - ProbeRowsPartitioned: 0
            - ProbeTime: 30586451
            - RowsReturned: 474668
            - RowsReturnedRate: 2048121
            - SpilledPartitions: 0
            - TotalTime: 231757790
            - UnpinTime: 2708
            EXCHANGE_NODE (id=4)
              - AsyncTotalTime: 0
              - BytesReceived: 27
              - ConvertRowBatchTime: 1672
              - DeserializeRowBatchTimer: 11000
              - FirstBatchArrivalWaitTime: 146061174
              - InactiveTotalTime: 146737892
              - PeakMemoryUsage: 0
              - RowsReturned: 1
              - RowsReturnedRate: 6
              - SendersBlockedTimer: 0
              - SendersBlockedTotalTimer(*): 0
              - TotalTime: 146755201
            HDFS_SCAN_NODE (id=0)
              Hdfs split stats (<volume id>:<# splits>/<split lengths>): 2:1/9.02 MB 7:2/18.19 MB 4:2/31.41 MB 3:1/19.51 MB 10:2/17.84 MB 1:1/13.83 MB 5:1/1.86 MB 
              Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 
              File Formats: PARQUET/SNAPPY:10 
              ExecOption: Codegen enabled: 0 out of 10
              - AsyncTotalTime: 0
              - AverageHdfsReadThreadConcurrency: 0.0
              - AverageScannerThreadConcurrency: 0.0
              - BytesRead: 2003473
              - BytesReadDataNodeCache: 0
              - BytesReadLocal: 2003473
              - BytesReadRemoteUnexpected: 102508
              - BytesReadShortCircuit: 2003473
              - DecompressionTime: 1100196
              - InactiveTotalTime: 0
              - MaxCompressedTextFileLength: 0
              - NumColumns: 0
              - NumDisksAccessed: 7
              - NumScannerThreadsStarted: 10
              - PeakMemoryUsage: 8188920
              - PerReadThreadRawHdfsThroughput: 88376874
              - RemoteScanRanges: 87
              - RowsRead: 474668
              - RowsReturned: 474668
              - RowsReturnedRate: 9709421
              - ScanRangesComplete: 10
              - ScannerThreadsInvoluntaryContextSwitches: 218
              - ScannerThreadsTotalWallClockTime: 1904753112
                - MaterializeTupleTime(*): 77343049
                - ScannerThreadsSysTime: 1112827000
                - ScannerThreadsUserTime: 380937000
              - ScannerThreadsVoluntaryContextSwitches: 19822
              - TotalRawHdfsReadTime(*): 22669652
              - TotalReadThroughput: 0
              - TotalTime: 48887364
      Instance 1647f149ee2fcf16:eef12236737c6e84 (host=hadoop3.phx.impactradius.net:22000)
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 7:1/4.82 MB 3:1/10.48 MB 2:2/37.97 MB 4:2/30.03 MB 5:1/2.89 MB 0:1/29.23 MB 
        - AsyncTotalTime: 0
        - AverageThreadTokens: 1.0
        - InactiveTotalTime: 0
        - PeakMemoryUsage: 8202944
        - PerHostPeakMemUsage: 8202944
        - PrepareTime: 181540695
        - RowsProduced: 1
        - TotalCpuTime: 1289787309
        - TotalNetworkReceiveTime: 175406468
        - TotalNetworkSendTime: 239459
        - TotalStorageWaitTime: 47045007
        - TotalTime: 397475103
        BlockMgr
          - AsyncTotalTime: 0
          - BlockWritesOutstanding: 0
          - BlocksCreated: 64
          - BlocksRecycled: 1
          - BufferedPins: 0
          - BytesWritten: 0
          - InactiveTotalTime: 0
          - MaxBlockSize: 8388608
          - MemoryLimit: 41231687680
          - PeakMemoryUsage: 16
          - TotalBufferWaitTime: 0
          - TotalEncryptionTime: 0
          - TotalIntegrityCheckTime: 0
          - TotalReadBlockTime: 0
          - TotalTime: 0
        CodeGen
          - AsyncTotalTime: 0
          - CodegenTime: 501118
          - CompileTime: 55167124
          - InactiveTotalTime: 0
          - LoadTime: 120110
          - ModuleFileSize: 2055524
          - OptimizationTime: 232190937
          - PrepareTime: 175954462
          - TotalTime: 464809757
        DataStreamSender (dst_id=5)
          - AsyncTotalTime: 0
          - BytesSent: 36
          - InactiveTotalTime: 0
          - NetworkThroughput(*): 180316
          - OverallThroughput: 1083782
          - PeakMemoryUsage: 4096
          - SerializeBatchTime: 8212
          - ThriftTransmitTime(*): 199649
          - TotalTime: 33217
          - UncompressedRowBatchSize: 40
        AGGREGATION_NODE (id=3)
          ExecOption: Codegen Enabled
          - AsyncTotalTime: 0
          - BuildTime: 5394879
          - GetResultsTime: 0
          - HashBuckets: 0
          - InactiveTotalTime: 0
          - LargestPartitionPercent: 0
          - MaxPartitionLevel: 0
          - NumRepartitions: 0
          - PartitionsCreated: 0
          - PeakMemoryUsage: 309608
          - RowsRepartitioned: 0
          - RowsReturned: 1
          - RowsReturnedRate: 2
          - SpilledPartitions: 0
          - TotalTime: 396909573
          HASH_JOIN_NODE (id=2)
            ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Filter Pushed Down
            - AsyncTotalTime: 176335205
            - BuildPartitionTime: 4037
            - BuildRows: 1
            - BuildRowsPartitioned: 1
            - BuildTime: 4761
            - GetNewBlockTime: 174949
            - HashBuckets: 2
            - InactiveTotalTime: 0
            - LargestPartitionPercent: 100
            - MaxPartitionLevel: 0
            - NumRepartitions: 0
            - PartitionsCreated: 32
            - PeakMemoryUsage: 4214784
            - PinTime: 0
            - ProbeRows: 558650
            - ProbeRowsPartitioned: 0
            - ProbeTime: 25201183
            - RowsReturned: 558650
            - RowsReturnedRate: 2619238
            - SpilledPartitions: 0
            - TotalTime: 213287197
            - UnpinTime: 3260
            EXCHANGE_NODE (id=4)
              - AsyncTotalTime: 0
              - BytesReceived: 27
              - ConvertRowBatchTime: 1332
              - DeserializeRowBatchTimer: 18942
              - FirstBatchArrivalWaitTime: 175228626
              - InactiveTotalTime: 175401048
              - PeakMemoryUsage: 0
              - RowsReturned: 1
              - RowsReturnedRate: 5
              - SendersBlockedTimer: 0
              - SendersBlockedTotalTimer(*): 0
              - TotalTime: 175414597
            HDFS_SCAN_NODE (id=0)
              Hdfs split stats (<volume id>:<# splits>/<split lengths>): 7:1/4.82 MB 3:1/10.48 MB 2:2/37.97 MB 4:2/30.03 MB 5:1/2.89 MB 0:1/29.23 MB 
              Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 
              File Formats: PARQUET/SNAPPY:8 
              ExecOption: Codegen enabled: 0 out of 8
              - AsyncTotalTime: 0
              - AverageHdfsReadThreadConcurrency: 0.0
              - AverageScannerThreadConcurrency: 0.0
              - BytesRead: 1736493
              - BytesReadDataNodeCache: 0
              - BytesReadLocal: 1736493
              - BytesReadRemoteUnexpected: 0
              - BytesReadShortCircuit: 1736493
              - DecompressionTime: 1044960
              - InactiveTotalTime: 0
              - MaxCompressedTextFileLength: 0
              - NumColumns: 0
              - NumDisksAccessed: 6
              - NumScannerThreadsStarted: 8
              - PeakMemoryUsage: 7948976
              - PerReadThreadRawHdfsThroughput: 609948969
              - RemoteScanRanges: 140
              - RowsRead: 558650
              - RowsReturned: 558650
              - RowsReturnedRate: 79806652
              - ScanRangesComplete: 8
              - ScannerThreadsInvoluntaryContextSwitches: 67
              - ScannerThreadsTotalWallClockTime: 650580233
                - MaterializeTupleTime(*): 83909410
                - ScannerThreadsSysTime: 387938000
                - ScannerThreadsUserTime: 123977000
              - ScannerThreadsVoluntaryContextSwitches: 7449
              - TotalRawHdfsReadTime(*): 2846948
              - TotalReadThroughput: 0
              - TotalTime: 7000043
      Instance 1647f149ee2fcf16:eef12236737c6e85 (host=hadoop1.phx.impactradius.net:22000)
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 6:1/17.91 MB 1:2/28.57 MB 9:2/25.17 MB 7:2/11.15 MB 8:1/2.00 MB 3:2/26.17 MB 10:1/1.53 MB 
        - AsyncTotalTime: 0
        - AverageThreadTokens: 1.5
        - InactiveTotalTime: 0
        - PeakMemoryUsage: 8796472
        - PerHostPeakMemUsage: 8808760
        - PrepareTime: 202634280
        - RowsProduced: 1
        - TotalCpuTime: 1046884999
        - TotalNetworkReceiveTime: 116933369
        - TotalNetworkSendTime: 515358
        - TotalStorageWaitTime: 108187585
        - TotalTime: 372814400
        CodeGen
          - AsyncTotalTime: 0
          - CodegenTime: 585914
          - CompileTime: 64968898
          - InactiveTotalTime: 0
          - LoadTime: 160633
          - ModuleFileSize: 2055524
          - OptimizationTime: 260333344
          - PrepareTime: 195386239
          - TotalTime: 522798637
        DataStreamSender (dst_id=5)
          - AsyncTotalTime: 0
          - BytesSent: 36
          - InactiveTotalTime: 0
          - NetworkThroughput(*): 77389
          - OverallThroughput: 911669
          - PeakMemoryUsage: 4096
          - SerializeBatchTime: 8884
          - ThriftTransmitTime(*): 465182
          - TotalTime: 39488
          - UncompressedRowBatchSize: 40
        AGGREGATION_NODE (id=3)
          ExecOption: Codegen Enabled
          - AsyncTotalTime: 0
          - BuildTime: 6000491
          - GetResultsTime: 0
          - HashBuckets: 0
          - InactiveTotalTime: 0
          - LargestPartitionPercent: 0
          - MaxPartitionLevel: 0
          - NumRepartitions: 0
          - PartitionsCreated: 0
          - PeakMemoryUsage: 320352
          - RowsRepartitioned: 0
          - RowsReturned: 1
          - RowsReturnedRate: 2
          - SpilledPartitions: 0
          - TotalTime: 372242028
          HASH_JOIN_NODE (id=2)
            ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Filter Pushed Down
            - AsyncTotalTime: 117800416
            - BuildPartitionTime: 6144
            - BuildRows: 1
            - BuildRowsPartitioned: 1
            - BuildTime: 5188
            - GetNewBlockTime: 219266
            - HashBuckets: 2
            - InactiveTotalTime: 0
            - LargestPartitionPercent: 100
            - MaxPartitionLevel: 0
            - NumRepartitions: 0
            - PartitionsCreated: 32
            - PeakMemoryUsage: 4214784
            - PinTime: 0
            - ProbeRows: 481531
            - ProbeRowsPartitioned: 0
            - ProbeTime: 27345729
            - RowsReturned: 481531
            - RowsReturnedRate: 2869133
            - SpilledPartitions: 0
            - TotalTime: 167831499
            - UnpinTime: 3598
            EXCHANGE_NODE (id=4)
              - AsyncTotalTime: 0
              - BytesReceived: 27
              - ConvertRowBatchTime: 1538
              - DeserializeRowBatchTimer: 13051
              - FirstBatchArrivalWaitTime: 116090448
              - InactiveTotalTime: 116925451
              - PeakMemoryUsage: 0
              - RowsReturned: 1
              - RowsReturnedRate: 8
              - SendersBlockedTimer: 0
              - SendersBlockedTotalTimer(*): 0
              - TotalTime: 116941491
            HDFS_SCAN_NODE (id=0)
              Hdfs split stats (<volume id>:<# splits>/<split lengths>): 6:1/17.91 MB 1:2/28.57 MB 9:2/25.17 MB 7:2/11.15 MB 8:1/2.00 MB 3:2/26.17 MB 10:1/1.53 MB 
              Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 
              File Formats: PARQUET/NONE:1 PARQUET/SNAPPY:10 
              ExecOption: Codegen enabled: 0 out of 11
              - AsyncTotalTime: 0
              - AverageHdfsReadThreadConcurrency: 0.0
              - AverageScannerThreadConcurrency: 0.0
              - BytesRead: 1972051
              - BytesReadDataNodeCache: 0
              - BytesReadLocal: 1972051
              - BytesReadRemoteUnexpected: 0
              - BytesReadShortCircuit: 1972051
              - DecompressionTime: 1440019
              - InactiveTotalTime: 0
              - MaxCompressedTextFileLength: 0
              - NumColumns: 0
              - NumDisksAccessed: 7
              - NumScannerThreadsStarted: 11
              - PeakMemoryUsage: 8542504
              - PerReadThreadRawHdfsThroughput: 496026857
              - RemoteScanRanges: 138
              - RowsRead: 481531
              - RowsReturned: 481531
              - RowsReturnedRate: 28519883
              - ScanRangesComplete: 11
              - ScannerThreadsInvoluntaryContextSwitches: 51
              - ScannerThreadsTotalWallClockTime: 455033833
                - MaterializeTupleTime(*): 120547235
                - ScannerThreadsSysTime: 163969000
                - ScannerThreadsUserTime: 80982000
              - ScannerThreadsVoluntaryContextSwitches: 1651
              - TotalRawHdfsReadTime(*): 3975694
              - TotalReadThroughput: 0
              - TotalTime: 16884045
      Instance 1647f149ee2fcf16:eef12236737c6e87 (host=hadoop2.phx.impactradius.net:22000)
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:2/19.36 MB 2:1/31.45 MB 4:1/20.96 KB 10:1/23.34 MB 3:3/23.62 MB 1:3/15.68 MB 
        - AsyncTotalTime: 0
        - AverageThreadTokens: 3.0
        - InactiveTotalTime: 0
        - PeakMemoryUsage: 8452720
        - PerHostPeakMemUsage: 8452720
        - PrepareTime: 207567646
        - RowsProduced: 1
        - TotalCpuTime: 811890095
        - TotalNetworkReceiveTime: 104997955
        - TotalNetworkSendTime: 391661
        - TotalStorageWaitTime: 108168916
        - TotalTime: 362158521
        BlockMgr
          - AsyncTotalTime: 0
          - BlockWritesOutstanding: 0
          - BlocksCreated: 64
          - BlocksRecycled: 1
          - BufferedPins: 0
          - BytesWritten: 0
          - InactiveTotalTime: 0
          - MaxBlockSize: 8388608
          - MemoryLimit: 41231687680
          - PeakMemoryUsage: 16
          - TotalBufferWaitTime: 0
          - TotalEncryptionTime: 0
          - TotalIntegrityCheckTime: 0
          - TotalReadBlockTime: 0
          - TotalTime: 0
        CodeGen
          - AsyncTotalTime: 0
          - CodegenTime: 583401
          - CompileTime: 62755682
          - InactiveTotalTime: 0
          - LoadTime: 131603
          - ModuleFileSize: 2055524
          - OptimizationTime: 268173047
          - PrepareTime: 200937774
          - TotalTime: 533773564
        DataStreamSender (dst_id=5)
          - AsyncTotalTime: 0
          - BytesSent: 36
          - InactiveTotalTime: 0
          - NetworkThroughput(*): 140420
          - OverallThroughput: 984601
          - PeakMemoryUsage: 4096
          - SerializeBatchTime: 9574
          - ThriftTransmitTime(*): 256372
          - TotalTime: 36563
          - UncompressedRowBatchSize: 40
        AGGREGATION_NODE (id=3)
          ExecOption: Codegen Enabled
          - AsyncTotalTime: 0
          - BuildTime: 6325577
          - GetResultsTime: 0
          - HashBuckets: 0
          - InactiveTotalTime: 0
          - LargestPartitionPercent: 0
          - MaxPartitionLevel: 0
          - NumRepartitions: 0
          - PartitionsCreated: 0
          - PeakMemoryUsage: 224360
          - RowsRepartitioned: 0
          - RowsReturned: 1
          - RowsReturnedRate: 2
          - SpilledPartitions: 0
          - TotalTime: 361575187
          HASH_JOIN_NODE (id=2)
            ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Filter Pushed Down
            - AsyncTotalTime: 105979050
            - BuildPartitionTime: 4119
            - BuildRows: 1
            - BuildRowsPartitioned: 1
            - BuildTime: 4700
            - GetNewBlockTime: 185534
            - HashBuckets: 2
            - InactiveTotalTime: 0
            - LargestPartitionPercent: 100
            - MaxPartitionLevel: 0
            - NumRepartitions: 0
            - PartitionsCreated: 32
            - PeakMemoryUsage: 4214784
            - PinTime: 0
            - ProbeRows: 522358
            - ProbeRowsPartitioned: 0
            - ProbeTime: 29215801
            - RowsReturned: 522358
            - RowsReturnedRate: 3448232
            - SpilledPartitions: 0
            - TotalTime: 151485729
            - UnpinTime: 3153
            EXCHANGE_NODE (id=4)
              - AsyncTotalTime: 0
              - BytesReceived: 27
              - ConvertRowBatchTime: 2140
              - DeserializeRowBatchTimer: 14928
              - FirstBatchArrivalWaitTime: 104989912
              - InactiveTotalTime: 104990808
              - PeakMemoryUsage: 0
              - RowsReturned: 1
              - RowsReturnedRate: 9
              - SendersBlockedTimer: 0
              - SendersBlockedTotalTimer(*): 0
              - TotalTime: 105007630
            HDFS_SCAN_NODE (id=0)
              Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:2/19.36 MB 2:1/31.45 MB 4:1/20.96 KB 10:1/23.34 MB 3:3/23.62 MB 1:3/15.68 MB 
              Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 
              File Formats: PARQUET/SNAPPY:11 
              ExecOption: Codegen enabled: 0 out of 11
              - AsyncTotalTime: 0
              - AverageHdfsReadThreadConcurrency: 0.0
              - AverageScannerThreadConcurrency: 4.0
              - BytesRead: 1931117
              - BytesReadDataNodeCache: 0
              - BytesReadLocal: 1931117
              - BytesReadRemoteUnexpected: 134217728
              - BytesReadShortCircuit: 1931117
              - DecompressionTime: 1555767
              - InactiveTotalTime: 0
              - MaxCompressedTextFileLength: 0
              - NumColumns: 0
              - NumDisksAccessed: 6
              - NumScannerThreadsStarted: 11
              - PeakMemoryUsage: 8239712
              - PerReadThreadRawHdfsThroughput: 112277743
              - RemoteScanRanges: 129
              - RowsRead: 522358
              - RowsReturned: 522358
              - RowsReturnedRate: 57940358
              - ScanRangesComplete: 11
              - ScannerThreadsInvoluntaryContextSwitches: 10
              - ScannerThreadsTotalWallClockTime: 225234500
                - MaterializeTupleTime(*): 80122233
                - ScannerThreadsSysTime: 3997000
                - ScannerThreadsUserTime: 44986000
              - ScannerThreadsVoluntaryContextSwitches: 391
              - TotalRawHdfsReadTime(*): 17199464
              - TotalReadThroughput: 3862234
              - TotalTime: 9015443
    Fragment F01
      Instance 1647f149ee2fcf16:eef12236737c6e88 (host=hadoop2.phx.impactradius.net:22000)
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 6:1/91.00 B 
        - AsyncTotalTime: 0
        - AverageThreadTokens: 0.0
        - InactiveTotalTime: 0
        - PeakMemoryUsage: 68928
        - PerHostPeakMemUsage: 4265280
        - PrepareTime: 212252073
        - RowsProduced: 1
        - TotalCpuTime: 436283657
        - TotalNetworkReceiveTime: 0
        - TotalNetworkSendTime: 192595
        - TotalStorageWaitTime: 22685253
        - TotalTime: 237420859
        CodeGen
          - AsyncTotalTime: 0
          - CodegenTime: 1994133
          - CompileTime: 10233249
          - InactiveTotalTime: 0
          - LoadTime: 1610258
          - ModuleFileSize: 2055524
          - OptimizationTime: 186661035
          - PrepareTime: 207038661
          - TotalTime: 407165977
        DataStreamSender (dst_id=4)
          - AsyncTotalTime: 0
          - BytesSent: 124
          - InactiveTotalTime: 0
          - NetworkThroughput(*): 59309
          - OverallThroughput: 227305
          - PeakMemoryUsage: 21824
          - SerializeBatchTime: 24867
          - ThriftTransmitTime(*): 2090711
          - TotalTime: 545521
          - UncompressedRowBatchSize: 168
        HDFS_SCAN_NODE (id=1)
          Hdfs split stats (<volume id>:<# splits>/<split lengths>): 6:1/91.00 B 
          Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 
          File Formats: TEXT/NONE:1 
          ExecOption: Codegen enabled: 1 out of 1
          - AsyncTotalTime: 0
          - AverageHdfsReadThreadConcurrency: 0.0
          - AverageScannerThreadConcurrency: 0.0
          - BytesRead: 91
          - BytesReadDataNodeCache: 0
          - BytesReadLocal: 91
          - BytesReadRemoteUnexpected: 0
          - BytesReadShortCircuit: 91
          - DecompressionTime: 0
          - InactiveTotalTime: 0
          - MaxCompressedTextFileLength: 0
          - NumDisksAccessed: 1
          - NumScannerThreadsStarted: 1
          - PeakMemoryUsage: 38912
          - PerReadThreadRawHdfsThroughput: 4249556
          - RemoteScanRanges: 150
          - RowsRead: 13
          - RowsReturned: 1
          - RowsReturnedRate: 4
          - ScanRangesComplete: 1
          - ScannerThreadsInvoluntaryContextSwitches: 0
          - ScannerThreadsTotalWallClockTime: 22984656
            - DelimiterParseTime: 4134
            - MaterializeTupleTime(*): 7129
            - ScannerThreadsSysTime: 0
            - ScannerThreadsUserTime: 0
          - ScannerThreadsVoluntaryContextSwitches: 4
          - TotalRawHdfsReadTime(*): 21414
          - TotalReadThroughput: 0
          - TotalTime: 235842724
      Instance 1647f149ee2fcf16:eef12236737c6e8a (host=hadoop4.phx.impactradius.net:22000)
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 5:1/91.00 B 
        - AsyncTotalTime: 0
        - AverageThreadTokens: 1.0
        - InactiveTotalTime: 0
        - PeakMemoryUsage: 68928
        - PerHostPeakMemUsage: 93504
        - PrepareTime: 217634952
        - RowsProduced: 0
        - TotalCpuTime: 397736268
        - TotalNetworkReceiveTime: 0
        - TotalNetworkSendTime: 181069
        - TotalStorageWaitTime: 13784242
        - TotalTime: 232854472
        CodeGen
          - AsyncTotalTime: 0
          - CodegenTime: 1347329
          - CompileTime: 8096443
          - InactiveTotalTime: 0
          - LoadTime: 147753
          - ModuleFileSize: 2055524
          - OptimizationTime: 154971113
          - PrepareTime: 214633727
          - TotalTime: 379268915
        DataStreamSender (dst_id=4)
          - AsyncTotalTime: 0
          - BytesSent: 16
          - InactiveTotalTime: 0
          - NetworkThroughput(*): 19495
          - OverallThroughput: 142681
          - PeakMemoryUsage: 21824
          - SerializeBatchTime: 1649
          - ThriftTransmitTime(*): 820705
          - TotalTime: 112138
          - UncompressedRowBatchSize: 16
        HDFS_SCAN_NODE (id=1)
          Hdfs split stats (<volume id>:<# splits>/<split lengths>): 5:1/91.00 B 
          Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 
          File Formats: TEXT/NONE:1 
          ExecOption: Codegen enabled: 1 out of 1
          - AsyncTotalTime: 0
          - AverageHdfsReadThreadConcurrency: 0.0
          - AverageScannerThreadConcurrency: 0.0
          - BytesRead: 91
          - BytesReadDataNodeCache: 0
          - BytesReadLocal: 91
          - BytesReadRemoteUnexpected: 324282
          - BytesReadShortCircuit: 91
          - DecompressionTime: 0
          - InactiveTotalTime: 0
          - MaxCompressedTextFileLength: 0
          - NumDisksAccessed: 1
          - NumScannerThreadsStarted: 1
          - PeakMemoryUsage: 38912
          - PerReadThreadRawHdfsThroughput: 7663157
          - RemoteScanRanges: 229
          - RowsRead: 13
          - RowsReturned: 0
          - RowsReturnedRate: 0
          - ScanRangesComplete: 1
          - ScannerThreadsInvoluntaryContextSwitches: 0
          - ScannerThreadsTotalWallClockTime: 13902589
            - DelimiterParseTime: 1661
            - MaterializeTupleTime(*): 2052
            - ScannerThreadsSysTime: 0
            - ScannerThreadsUserTime: 0
          - ScannerThreadsVoluntaryContextSwitches: 3
          - TotalRawHdfsReadTime(*): 11875
          - TotalReadThroughput: 0
          - TotalTime: 231869609
      Instance 1647f149ee2fcf16:eef12236737c6e8b (host=hadoop1.phx.impactradius.net:22000)
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 10:1/98.00 B 
        - AsyncTotalTime: 0
        - AverageThreadTokens: 1.0
        - InactiveTotalTime: 0
        - PeakMemoryUsage: 68928
        - PerHostPeakMemUsage: 105792
        - PrepareTime: 201309955
        - RowsProduced: 0
        - TotalCpuTime: 415931085
        - TotalNetworkReceiveTime: 0
        - TotalNetworkSendTime: 125327
        - TotalStorageWaitTime: 5375220
        - TotalTime: 208586877
        CodeGen
          - AsyncTotalTime: 0
          - CodegenTime: 1712608
          - CompileTime: 10358193
          - InactiveTotalTime: 0
          - LoadTime: 120313
          - ModuleFileSize: 2055524
          - OptimizationTime: 195005390
          - PrepareTime: 197528335
          - TotalTime: 404899737
        DataStreamSender (dst_id=4)
          - AsyncTotalTime: 0
          - BytesSent: 16
          - InactiveTotalTime: 0
          - NetworkThroughput(*): 17566
          - OverallThroughput: 71515
          - PeakMemoryUsage: 21824
          - SerializeBatchTime: 3294
          - ThriftTransmitTime(*): 910834
          - TotalTime: 223727
          - UncompressedRowBatchSize: 16
        HDFS_SCAN_NODE (id=1)
          Hdfs split stats (<volume id>:<# splits>/<split lengths>): 10:1/98.00 B 
          Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 
          File Formats: TEXT/NONE:1 
          ExecOption: Codegen enabled: 1 out of 1
          - AsyncTotalTime: 0
          - AverageHdfsReadThreadConcurrency: 0.0
          - AverageScannerThreadConcurrency: 0.0
          - BytesRead: 98
          - BytesReadDataNodeCache: 0
          - BytesReadLocal: 98
          - BytesReadRemoteUnexpected: 0
          - BytesReadShortCircuit: 98
          - DecompressionTime: 0
          - InactiveTotalTime: 0
          - MaxCompressedTextFileLength: 0
          - NumDisksAccessed: 1
          - NumScannerThreadsStarted: 1
          - PeakMemoryUsage: 38912
          - PerReadThreadRawHdfsThroughput: 6368185
          - RemoteScanRanges: 12
          - RowsRead: 14
          - RowsReturned: 0
          - RowsReturnedRate: 0
          - ScanRangesComplete: 1
          - ScannerThreadsInvoluntaryContextSwitches: 0
          - ScannerThreadsTotalWallClockTime: 5560671
            - DelimiterParseTime: 2768
            - MaterializeTupleTime(*): 4191
            - ScannerThreadsSysTime: 0
            - ScannerThreadsUserTime: 0
          - ScannerThreadsVoluntaryContextSwitches: 4
          - TotalRawHdfsReadTime(*): 15389
          - TotalReadThroughput: 0
          - TotalTime: 207197931
      Instance 1647f149ee2fcf16:eef12236737c6e89 (host=hadoop3.phx.impactradius.net:22000)
        Hdfs split stats (<volume id>:<# splits>/<split lengths>): 5:1/98.00 B 
        - AsyncTotalTime: 0
        - AverageThreadTokens: 1.0
        - InactiveTotalTime: 0
        - PeakMemoryUsage: 68928
        - PerHostPeakMemUsage: 93504
        - PrepareTime: 174131750
        - RowsProduced: 0
        - TotalCpuTime: 385377674
        - TotalNetworkReceiveTime: 0
        - TotalNetworkSendTime: 133430
        - TotalStorageWaitTime: 4822399
        - TotalTime: 180673712
        CodeGen
          - AsyncTotalTime: 0
          - CodegenTime: 1341455
          - CompileTime: 10623108
          - InactiveTotalTime: 0
          - LoadTime: 137784
          - ModuleFileSize: 2055524
          - OptimizationTime: 192261832
          - PrepareTime: 171030601
          - TotalTime: 375565309
        DataStreamSender (dst_id=4)
          - AsyncTotalTime: 0
          - BytesSent: 16
          - InactiveTotalTime: 0
          - NetworkThroughput(*): 17521
          - OverallThroughput: 68625
          - PeakMemoryUsage: 21824
          - SerializeBatchTime: 2856
          - ThriftTransmitTime(*): 913174
          - TotalTime: 233151
          - UncompressedRowBatchSize: 16
        HDFS_SCAN_NODE (id=1)
          Hdfs split stats (<volume id>:<# splits>/<split lengths>): 5:1/98.00 B 
          Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 
          File Formats: TEXT/NONE:1 
          ExecOption: Codegen enabled: 1 out of 1
          - AsyncTotalTime: 0
          - AverageHdfsReadThreadConcurrency: 0.0
          - AverageScannerThreadConcurrency: 0.0
          - BytesRead: 98
          - BytesReadDataNodeCache: 0
          - BytesReadLocal: 98
          - BytesReadRemoteUnexpected: 0
          - BytesReadShortCircuit: 98
          - DecompressionTime: 0
          - InactiveTotalTime: 0
          - MaxCompressedTextFileLength: 0
          - NumDisksAccessed: 1
          - NumScannerThreadsStarted: 1
          - PeakMemoryUsage: 38912
          - PerReadThreadRawHdfsThroughput: 8045316
          - RemoteScanRanges: 39
          - RowsRead: 14
          - RowsReturned: 0
          - RowsReturnedRate: 0
          - ScanRangesComplete: 1
          - ScannerThreadsInvoluntaryContextSwitches: 0
          - ScannerThreadsTotalWallClockTime: 4990455
            - DelimiterParseTime: 2634
            - MaterializeTupleTime(*): 3214
            - ScannerThreadsSysTime: 0
            - ScannerThreadsUserTime: 0
          - ScannerThreadsVoluntaryContextSwitches: 4
          - TotalRawHdfsReadTime(*): 12181
          - TotalReadThroughput: 0
          - TotalTime: 179413235