THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
Phoenix Tables
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 | 1 month |
METRIC_AGGREGATE | Cluster wide aggregates per metric at 15 seconds precision | 1 week |
METRIC_AGGREGATE_HOURLY | Cluster wide aggregates per metric at 1 hour precision | 1 year |
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: ./sqlline.py localhost:61181:/hbase