Re: ALLOW FILTERING usage

2014-03-17 Thread Laing, Michael
Your second query is invalid: *Bad Request: Partition KEY part key cannot be restricted by IN relation (only the last part of the partition key can)* ml On Mon, Mar 17, 2014 at 6:56 AM, Tupshin Harper wrote: > It's the difference between reading from only the partitions that you are > interes

Re: ALLOW FILTERING usage

2014-03-17 Thread Tupshin Harper
It's the difference between reading from only the partitions that you are interested, vs reading every single partition before filtering the results. At scale, and assuming you don't actually need to read every partition, there would be a huge difference. If the model requires you to read every p

ALLOW FILTERING usage

2014-03-17 Thread Kasper Middelboe Petersen
Hi, I have a table: CREATE TABLE json ( key text, group text, date timestamp, json text, PRIMARY KEY((key, group), date) ) WITH CLUSTERING ORDER BY (date DESC); This table will contain a small amount of data (only what an administrator creates by hand - a year