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
We have noticed that a cluster we upgraded to 1.1.6 (from 1.0.*) still has a
single large (~4GB) row in system.Migrations on each cluster node. We are also
seeing heap pressure / Full GC issues when we do schema updates to this
cluster. If the two are related, is it possible to somehow remove/
You might be running into CASSANDRA-6244. That ended up being our problem
anyway.
On Thu, Nov 21, 2013 at 9:37 PM, Robert Coli wrote:
> On Thu, Nov 21, 2013 at 6:17 PM, Alain RODRIGUEZ wrote:
>
>> Oh ! Thanks.
>>
>> Is there any workaround to avoid the problem while waiting for update ?
>>
>
> P
Thanks, it works; don't know why first times i upload the package the
Apache_Cassandra_2.0.2.jar miss. Now it's here.
Thanks again.
