Member since
11-17-2017
2
Posts
0
Kudos Received
0
Solutions
11-19-2017
04:32 AM
Thank you for your response, Ben. Could you point me to the source of data where chart builder fetches from? e.g. this query for Cluster CPU: SELECT cpu_percent_across_hosts WHERE entityName = "1" AND category = CLUSTER or this one for HDFS IO: SELECT total_bytes_written_rate_across_datanodes WHERE entityName = "hdfs:nameservice" AND category = SERVICE These don't seem to be standard SQL stmts as these don't include the table name and even the "FROM" clause. I am looking to access the raw data behind these metrics and potentially gather data for additional custom metrics that I could define on clients' requests. Thanks!
... View more
11-17-2017
02:00 PM
In Cloudera Mgmt Service, Activity Monitor is configured to write to Oracle database and retain data for 7 days. I can see the data in the dashboard for various metrics, but when I look in the database, the tables e.g. cdh_monitor.cmon_act_lmv_2017_11_17 are being created, but there is no data in the tables. Not sure why data is not being stored in these tables. And, what's the source of data for charts displayed on the dashboard? Appreciate any help! Thanks!
... View more
Labels:
- Labels:
-
Cloudera Manager