集群整体可用内存：

SELECT allocated_memory_mb_cumulative, available_memory_mb where category=YARN_POOL and serviceName="yarn" and queueName=root

集群CPU核数使用情况

SELECT allocated_vcores_cumulative, available_vcores where category=YARN_POOL and serviceName="yarn" and queueName=root

Namenode CPU Usage:

SELECT cpu_user_rate / getHostFact(numCores,1)*100 , cpu_system_rate / getHostFact(numCores,1)100 WHERE entityName RLIKE "hdfs-NAMENODE-."

NN Transactions Sinc Last Log Checkpoint:

SELECT transactions_since_last_checkpoint WHERE entityName RLIKE "hdfs-NAMENODE-.*"

Namenode JVM heap Memory Usage:

SELECT jvm_max_memory_mb,jvm_heap_used_mb WHERE entityName RLIKE "hdfs-NAMENODE-.*"

nodemanager的GC时间：

SELECT integral(jvm_gc_time_ms_rate) WHERE entityName RLIKE "yarn-NODEMANAGER-.*"

Zookeeper连接数：

SELECT open_connections WHERE entityName RLIKE "zookeeper-SERVER-.*"

未处理请求：

SELECT outstanding_requests WHERE entityName RLIKE "zookeeper-SERVER-.*"

ZK GC时间：

SELECT integral(jvm_gc_time_ms_rate) WHERE entityName RLIKE "zookeeper-SERVER-.*"

整个Servers中的打开连接：

SELECT open_connections_across_servers WHERE entityName = "zookeeper" AND category = SERVICE

整个Servers中的数据大小： SELECT data_size_across_servers WHERE entityName = "zookeeper" AND category = SERVICE