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
I'm looking for some guidance on how to model some stat tracking over time,
bucketed to some type of interval (15 min, hour, etc).
As an example, let's say I would like to track network traffic throughput and
bucket it to 15 minute intervals. In our old model, using thrift I would
create a col