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

30 days

METRIC_RECORD_DAILYData per metric per host at 1 day precision1 year

METRIC_AGGREGATE

Cluster wide aggregates per metric at 30 seconds precision

1 week

METRIC_AGGREGATE_MINUTECluster wide aggregates per metric at 5 minute precision30 days

METRIC_AGGREGATE_HOURLY

Cluster wide aggregates per metric at 1 hour precision

1 year

METRIC_AGGREGATE_DAILYCluster wide aggregates per metric at 1 day precision2 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)


  • No labels