Query Info
Query ID: 544bd8ebf4856e5e:8b86cae1eb3bcb9f
User: andor.toth
Database: btarget
Coordinator: bd000
Query Type: QUERY
Query State: CREATED
Start Time: Aug 13, 2014 1:08:31 PM
Duration: 28.2s
Rows Produced: 0
Bytes Streamed: 2.1 MiB
Client Fetch Wait Time: 0ms
Client Fetch Wait Time Percentage: 0
Estimated per Node Peak Memory: 488.0 MiB
File Formats: RC_FILE/DEFAULT
HDFS Average Scan Range: 1.5 MiB
HDFS Bytes Read: 83.1 MiB
HDFS Bytes Read From Cache: 3.1 MiB
HDFS Bytes Read From Cache Percentage: 4
HDFS Bytes Skipped: 0 B
HDFS Local Bytes Read: 3.1 MiB
HDFS Local Bytes Read Percentage: 4
HDFS Read Throughput: 666.7 MiB/s
HDFS Remote Bytes Read: 80.0 MiB
HDFS Remote Bytes Read Percentage: 96
HDFS Short Circuit Bytes Read: 3.1 MiB
HDFS Short Circuit Bytes Read Percentage: 4
Network Address: ::ffff:1.2.3.4:55729
Planning Wait Time: 34ms
Planning Wait Time Percentage: 0
Pool: root.andor.toth
Query Status: OK
Session ID: 42484ce44dacfee4:2a6f18e4b4a03488
Session Type: HIVESERVER2
Stats Missing: true
Threads: CPU Time: 4.38s
Threads: CPU Time Percentage: 34
Threads: Network Receive Wait Time: 8.45s
Threads: Network Receive Wait Time Percentage: 65
Threads: Network Send Wait Time: 32ms
Threads: Network Send Wait Time Percentage: 0
Threads: Storage Wait Time: 122ms
Threads: Storage Wait Time Percentage: 1
Threads: Total Time: 12.98s
Download Profile...   
Query Timeline
Start execution: 47.21us (47.21us)
Planning finished: 34ms (34ms)
Submit for admission: 48ms (13ms)
Completed admission: 48ms (95.82us)


QUERY PLAN
----------------
Estimated Per-Host Requirements: Memory=488.00MB VCores=2
WARNING: The following tables are missing relevant table and/or column statistics.
btarget.btarget

F02:PLAN FRAGMENT [UNPARTITIONED]
  04:EXCHANGE [UNPARTITIONED]
     hosts=1 per-host-mem=unavailable
     tuple-ids=1 row-size=38B cardinality=0

F01:PLAN FRAGMENT [HASH(sid,event_type)]
  DATASTREAM SINK [FRAGMENT=F02, EXCHANGE=04, UNPARTITIONED]
  03:AGGREGATE [MERGE FINALIZE]
  |  output: sum(count(event_type))
  |  group by: sid, event_type
  |  hosts=1 per-host-mem=128.00MB
  |  tuple-ids=1 row-size=38B cardinality=0
  |
  02:EXCHANGE [HASH(sid,event_type)]
     hosts=1 per-host-mem=0B
     tuple-ids=1 row-size=38B cardinality=0

F00:PLAN FRAGMENT [RANDOM]
  DATASTREAM SINK [FRAGMENT=F01, EXCHANGE=02, HASH(sid,event_type)]
  01:AGGREGATE
  |  output: count(event_type)
  |  group by: sid, event_type
  |  hosts=1 per-host-mem=128.00MB
  |  tuple-ids=1 row-size=38B cardinality=0
  |
  00:SCAN HDFS [btarget.btarget, RANDOM]
     partitions=1/127 size=226.17MB
     predicates: host = 'www.startlap.hu'
     table stats: 0 rows total
     columns missing stats: sid, event_type, host
     hosts=1 per-host-mem=360.00MB
     tuple-ids=0 row-size=45B cardinality=0
----------------