Query (id=3b4661939fe73366:604b2898d62ac191)
  Summary
    Session ID: f48a1d433a5a07d:35f271778d2a8199
    Session Type: BEESWAX
    Start Time: 2016-08-22 10:24:36.281528000
    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: cloudera-scm
    Connected User: cloudera-scm
    Delegated User: 
    Network Address: ::ffff:10.92.57.17:60914
    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
    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: 45558232
      Equivalence classes computed: 76827903
      Single node plan created: 94728877
      Runtime filters computed: 96166493
      Distributed plan created: 99880694
      Lineage info computed: 108155274
      Planning finished: 171903050
    Query Timeline
      Start execution: 27940
      Planning finished: 191742704
  ImpalaServer
    - ClientFetchWaitTimer: 0
    - InactiveTotalTime: 0
    - RowMaterializationTimer: 0
    - TotalTime: 0
  Execution Profile 3b4661939fe73366:604b2898d62ac191
    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: 122480568
    Coordinator Fragment F00
      Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:469/109.87 GB 
      - AverageThreadTokens: 96.0
      - BloomFilterBytes: 0
      - InactiveTotalTime: 0
      - PeakMemoryUsage: 1873079888
      - PerHostPeakMemUsage: 0
      - PrepareTime: 121974616
      - RowsProduced: 0
      - TotalCpuTime: 0
      - TotalNetworkReceiveTime: 0
      - TotalNetworkSendTime: 0
      - TotalStorageWaitTime: 2389688145108
      - TotalTime: 122180480
      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: 159936
        - CompileTime: 3301440
        - InactiveTotalTime: 0
        - LoadTime: 0
        - ModuleBitcodeSize: 2225280
        - NumFunctions: 11
        - NumInstructions: 162
        - OptimizationTime: 27967676
        - PrepareTime: 104431420
        - TotalTime: 136190768
      AGGREGATION_NODE (id=1)
        ExecOption: Codegen Enabled
        - BuildTime: 4554210440
        - GetResultsTime: 0
        - HTResizeTime: 0
        - HashBuckets: 0
        - InactiveTotalTime: 0
        - LargestPartitionPercent: 0
        - MaxPartitionLevel: 0
        - NumRepartitions: 0
        - PartitionsCreated: 0
        - PeakMemoryUsage: 258312
        - RowsRepartitioned: 0
        - RowsReturned: 0
        - RowsReturnedRate: 0
        - SpilledPartitions: 0
        - TotalTime: 121973972
        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.02444545043005885
          - AverageScannerThreadConcurrency: 95.0
          - BytesRead: 7685364056
          - BytesReadDataNodeCache: 0
          - BytesReadLocal: 0
          - BytesReadRemoteUnexpected: 0
          - BytesReadShortCircuit: 0
          - DecompressionTime: 8487254136
          - InactiveTotalTime: 0
          - MaxCompressedTextFileLength: 0
          - NumColumns: 1
          - NumDisksAccessed: 0
          - NumRowGroups: 395
          - NumScannerThreadsStarted: 95
          - PeakMemoryUsage: 1873059408
          - PerReadThreadRawHdfsThroughput: 288236161
          - RemoteScanRanges: 0
          - RowsRead: 1786600632
          - RowsReturned: 1786549432
          - RowsReturnedRate: 88064543
          - ScanRangesComplete: 300
          - ScannerThreadsInvoluntaryContextSwitches: 0
          - ScannerThreadsTotalWallClockTime: 0
            - MaterializeTupleTime(*): 15608513396
            - ScannerThreadsSysTime: 0
            - ScannerThreadsUserTime: 0
          - ScannerThreadsVoluntaryContextSwitches: 0
          - TotalRawHdfsReadTime(*): 26663427680
          - TotalReadThroughput: 6958153
          - TotalTime: 20286818824