Re: Creating secondary index CQL3 cassandra 1.1.1

2012-06-21 Thread Stephen Powis
Ah yes that's it exactly, including the time outs/errors. I wonder why this didn't come up when I googled the error from my system logs. Thanks! Stephen On Thu, Jun 21, 2012 at 2:47 AM, Sylvain Lebresne wrote: > On Thu, Jun 21, 2012 at 5:11 AM, Stephen Powis > wrote: > >

Creating secondary index CQL3 cassandra 1.1.1

2012-06-20 Thread Stephen Powis
I have the following schema: describe columnfamily visitor_audit; CREATE TABLE visitor_audit ( visitor_id text, audit_id uuid, account_id int, audit_type int, created_at text, PRIMARY KEY (visitor_id, audit_id) ) WITH comment='' AND caching='KEYS_ONLY' AND read_repair_chance=0.1

Re: Help deleting data using cql v3

2012-05-24 Thread Stephen Powis
ql-3-0) > > -Roland > > On Thu, May 24, 2012 at 6:24 PM, Stephen Powis > wrote: > >> I have the following schema setup in cassandra 1.1 with cql 3: >> >> CREATE TABLE testCol ( >> my_id varchar, >> time_id TimeUUIDType, >> my_value

Help deleting data using cql v3

2012-05-24 Thread Stephen Powis
I have the following schema setup in cassandra 1.1 with cql 3: CREATE TABLE testCol ( my_id varchar, time_id TimeUUIDType, my_value int, PRIMARY KEY (my_id, time_id) ); and the following data already inserted: my_id| time_id | my_valu