Here's another example that may help:
-- put this in AND run using 'cqlsh -f
DROP KEYSPACE bryce_test;
CREATE KEYSPACE bryce_test WITH replication = {
'class': 'SimpleStrategy',
'replication_factor' : 1
};
USE bryce_test;
CREATE TABLE samples (
name text,
bucket text,
cou
Something like this would work:
CREATE TABLE foo (
interface text,
property text,
bucket timestamp,
count counter,
PRIMARY KEY ((interface, property), bucket)
)
interface is 'NIC1' and property is 'Total' or 'Count'.
To query over a date range, you'd run a query like:
SELECT
