Query (id=63404965f5ac5a7a:3daed3e8ef91c5b0)
  Summary
    Session ID: 44e489849a2792b:baaa45c1330c4f91
    Session Type: BEESWAX
    Start Time: 2016-08-23 16:52:22.642338000
    End Time: 
    Query Type: QUERY
    Query State: CREATED
    Query Status: OK
    Impala Version: impalad version 2.6.0-cdh5.8.0 RELEASE (build 8d8652f69461f0dd8d5f474573fb5de7ceb0ee6b)
    User: oracle
    Connected User: oracle
    Delegated User: 
    Network Address: ::ffff:10.92.57.17:36050
    Default Db: mstr
    Sql Statement: select sum(asn_datavolumefbcuplink) from asn1_cisco_cellulars
    Coordinator: francia.claro.amx:22000
    Query Options (non default): NUM_NODES=1,NUM_SCANNER_THREADS=32
    Plan: 
----------------
Estimated Per-Host Requirements: Memory=0B VCores=0

01:AGGREGATE [FINALIZE]
|  output: sum(asn_datavolumefbcuplink)
|  hosts=3 per-host-mem=unavailable
|  tuple-ids=1 row-size=8B cardinality=1
|
00:SCAN HDFS [mstr.asn1_cisco_cellulars]
   partitions=4/4 files=469 size=109.87GB
   table stats: 2744862014 rows total
   column stats: all
   hosts=3 per-host-mem=unavailable
   tuple-ids=0 row-size=4B cardinality=2744862014
----------------
    Estimated Per-Host Mem: 0
    Estimated Per-Host VCores: 0
    Request Pool: default-pool
    Planner Timeline
      Analysis finished: 43239519
      Equivalence classes computed: 73388676
      Single node plan created: 90972952
      Runtime filters computed: 92352197
      Distributed plan created: 96051502
      Lineage info computed: 103752307
      Planning finished: 165510147
    Query Timeline
      Start execution: 25920
      Planning finished: 184648276
  ImpalaServer
    - ClientFetchWaitTimer: 0
    - InactiveTotalTime: 0
    - RowMaterializationTimer: 0
    - TotalTime: 0
  Execution Profile 63404965f5ac5a7a:3daed3e8ef91c5b0
    Number of filters: 0
    Filter routing table: 
 ID  Src. Node  Tgt. Node(s)  Targets  Target type  Partition filter  Pending (Expected)  First arrived   Completed
-------------------------------------------------------------------------------------------------------------------

    - FiltersReceived: 0
    - FinalizationTimer: 0
    - InactiveTotalTime: 0
    - TotalTime: 121378880
    Coordinator Fragment F00
      Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:469/109.87 GB 
      - AverageThreadTokens: 32.0
      - BloomFilterBytes: 0
      - InactiveTotalTime: 0
      - PeakMemoryUsage: 672994968
      - PerHostPeakMemUsage: 0
      - PrepareTime: 120943692
      - RowsProduced: 0
      - TotalCpuTime: 0
      - TotalNetworkReceiveTime: 0
      - TotalNetworkSendTime: 0
      - TotalStorageWaitTime: 5105705672
      - TotalTime: 121095100
      BlockMgr
        - BlockWritesOutstanding: 0
        - BlocksCreated: 0
        - BlocksRecycled: 0
        - BufferedPins: 0
        - BytesWritten: 0
        - InactiveTotalTime: 0
        - MaxBlockSize: 8388608
        - MemoryLimit: 138631823360
        - PeakMemoryUsage: 0
        - TotalBufferWaitTime: 0
        - TotalEncryptionTime: 0
        - TotalIntegrityCheckTime: 0
        - TotalReadBlockTime: 0
        - TotalTime: 0
      CodeGen
        - CodegenTime: 143844
        - CompileTime: 3228040
        - InactiveTotalTime: 0
        - LoadTime: 0
        - ModuleBitcodeSize: 2225280
        - NumFunctions: 11
        - NumInstructions: 162
        - OptimizationTime: 33147024
        - PrepareTime: 103690976
        - TotalTime: 140500156
      AGGREGATION_NODE (id=1)
        ExecOption: Codegen Enabled
        - BuildTime: 125525308
        - GetResultsTime: 0
        - HTResizeTime: 0
        - HashBuckets: 0
        - InactiveTotalTime: 0
        - LargestPartitionPercent: 0
        - MaxPartitionLevel: 0
        - NumRepartitions: 0
        - PartitionsCreated: 0
        - PeakMemoryUsage: 223680
        - RowsRepartitioned: 0
        - RowsReturned: 0
        - RowsReturnedRate: 0
        - SpilledPartitions: 0
        - TotalTime: 120942692
        HDFS_SCAN_NODE (id=0)
          ExecOption: Expr Evaluation Codegen Disabled
          Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:469/109.87 GB 
          - AverageHdfsReadThreadConcurrency: 0.0014204545454545455
          - AverageScannerThreadConcurrency: 31.0
          - BytesRead: 729500391
          - BytesReadDataNodeCache: 0
          - BytesReadLocal: 0
          - BytesReadRemoteUnexpected: 0
          - BytesReadShortCircuit: 0
          - DecompressionTime: 237106780
          - InactiveTotalTime: 0
          - MaxCompressedTextFileLength: 0
          - NumColumns: 1
          - NumDisksAccessed: 0
          - NumRowGroups: 33
          - NumScannerThreadsStarted: 31
          - PeakMemoryUsage: 672974488
          - PerReadThreadRawHdfsThroughput: 1819956749
          - RemoteScanRanges: 0
          - RowsRead: 49820756
          - RowsReturned: 49768532
          - RowsReturnedRate: 228257444
          - ScanRangesComplete: 2
          - ScannerThreadsInvoluntaryContextSwitches: 0
          - ScannerThreadsTotalWallClockTime: 0
            - MaterializeTupleTime(*): 89475564
            - ScannerThreadsSysTime: 0
            - ScannerThreadsUserTime: 0
          - ScannerThreadsVoluntaryContextSwitches: 0
          - TotalRawHdfsReadTime(*): 400833916
          - TotalReadThroughput: 2072444
          - TotalTime: 218036840