Re: What does "PER PARTITION LIMIT" means in cql query in cassandra?

2020-05-07 Thread Pekka Enberg
Hi Chuck, On Thu, May 7, 2020 at 10:14 AM Check Peck wrote: > I have a scylla table as shown below: > (Please note that this is the Apache Cassandra users mailing list. Of course, the feature is the same, so let me answer it here.) > > cqlsh:sampleks> describe table test; > > > CREATE

Re: What does "PER PARTITION LIMIT" means in cql query in cassandra?

2020-05-07 Thread Dor Laor
In your schema case, for each client_id you will get a single 'when' row. Just one. Even when there are multiple rows (clustering keys) On Thu, May 7, 2020 at 12:14 AM Check Peck wrote: > > I have a scylla table as shown below: > > > cqlsh:sampleks> describe table test; > > > CREATE TABLE

What does "PER PARTITION LIMIT" means in cql query in cassandra?

2020-05-07 Thread Check Peck
I have a scylla table as shown below: cqlsh:sampleks> describe table test; CREATE TABLE test ( client_id int, when timestamp, process_ids list, md text, PRIMARY KEY (client_id, when) ) WITH CLUSTERING ORDER BY (when DESC) AND bloom_f