schema.txt

CREATE KEYSPACE balboa WITH replication = {'class': 'SimpleStrategy', 'replication_factor' : 1};
USE balboa;

CREATE TABLE observations_by_rdata (
    rrname text,
    rdata text,
    rrtype text,
    sensor_id text,
    last_seen timestamp,
    PRIMARY KEY (sensor_id, rdata, rrname, rrtype)
);

CREATE CUSTOM INDEX observations_by_rdata_idx ON balboa.observations_by_rdata(rdata) 
USING 'org.apache.cassandra.index.sasi.SASIIndex'
WITH OPTIONS = {
     'mode': 'CONTAINS', 
     'analyzer_class': 'org.apache.cassandra.index.sasi.analyzer.NonTokenizingAnalyzer',
     'case_sensitive': 'false'
};

CREATE TABLE observations_by_rrname (
    rrname text,
    rdata text,
    rrtype text,
    sensor_id text,
    last_seen timestamp,
    PRIMARY KEY (sensor_id, rrname, rdata, rrtype)
);

CREATE CUSTOM INDEX observations_by_rrname_idx ON balboa.observations_by_rrname(rrname) 
USING 'org.apache.cassandra.index.sasi.SASIIndex'
WITH OPTIONS = {
     'mode': 'CONTAINS', 
     'analyzer_class': 'org.apache.cassandra.index.sasi.analyzer.NonTokenizingAnalyzer',
     'case_sensitive': 'false'
};

CREATE TABLE observations_firstseen (
    rrname text,
    rdata text,
    rrtype text,
    sensor_id text,
    first_seen timestamp,
    PRIMARY KEY (sensor_id, rrname, rdata, rrtype)
);

CREATE TABLE observations_counts (
    rrname text,
    rdata text,
    rrtype text,
    sensor_id text,
    count counter,
    PRIMARY KEY (sensor_id, rrname, rdata, rrtype)
);