Table name | Description | Purge interval (default) |
|---|---|---|
METRIC_RECORD | Data per metric per host at 10 seconds precision with 1 minute aggregates. | 1 day |
METRIC_RECORD_MINUTE | Data per metric per host at 5 minute precision | 1 week |
METRIC_RECORD_HOURLY | Data per metric per host at 1 hour precision | 30 days |
| METRIC_RECORD_DAILY | Data per metric per host at 1 day precision | 1 year |
METRIC_AGGREGATE | Cluster wide aggregates per metric at 30 seconds precision | 1 week |
| METRIC_AGGREGATE_MINUTE | Cluster wide aggregates per metric at 5 minute precision | 30 days |
METRIC_AGGREGATE_HOURLY | Cluster wide aggregates per metric at 1 hour precision | 1 year |
| METRIC_AGGREGATE_DAILY | Cluster wide aggregates per metric at 1 day precision | 2 years |
Connecting to Phoenix
- Unpack Phoenix (4.2.0+) tarball onto the Metric Collector host
- Change director to phonenix-4.*/bin
- Edit sqlline.py and search for "java", replace java with full path to the java executable, example: "/usr/jdk64/jdk1.8.0_40/bin/java"
Connect command:
Ambari versions 2.2.0 and below : ./sqlline.py localhost:61181:/hbase
Ambari versions > 2.2.0 : ./sqlline.py localhost:61181:/ams-hbase-unsecure (embedded mode) and <cluster-zookeeper-quorum-host>:<cluster_zookeeper_port>:/ams-hbase-unsecure (distributed mode)
