RHQ's Cassandra schema for metrics data

gistfile1.sql

CREATE TABLE rhq.raw_metrics (
    schedule_id int,
    time timestamp,
    value double,
    PRIMARY KEY (schedule_id, time)
) WITH COMPACT STORAGE;

CREATE TABLE rhq.one_hour_metrics (
    schedule_id int,
    time timestamp,
    type int,
    value double,
    PRIMARY KEY (schedule_id, time, type)
) WITH COMPACT STORAGE;

CREATE TABLE rhq.six_hour_metrics (
    schedule_id int,
    time timestamp,
    type int,
    value double,
    PRIMARY KEY (schedule_id, time, type)
) WITH COMPACT STORAGE;

CREATE TABLE rhq.twenty_four_hour_metrics (
    schedule_id int,
    time timestamp,
    type int,
    value double,
    PRIMARY KEY (schedule_id, time, type)
) WITH COMPACT STORAGE;

CREATE TABLE rhq.metrics_index (
    bucket varchar,
    time timestamp,
    schedule_id int,
    PRIMARY KEY ((bucket, time), schedule_id)
) WITH COMPACT STORAGE;