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: > > I have the following s

Re: Creating secondary index CQL3 cassandra 1.1.1

2012-06-20 Thread Sylvain Lebresne
On Thu, Jun 21, 2012 at 5:11 AM, Stephen Powis wrote: > 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)

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