Re: CQL and counters

2013-11-22 Thread Laing, Michael
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

Re: CQL and counters

2013-11-22 Thread Tyler Hobbs
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

CQL and counters

2013-11-22 Thread Bryce Godfrey
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