https://www.slideshare.net/doanduyhai/datastax-day-2016-cassandra-data-modeling-basics
On Thu, Mar 1, 2018 at 3:48 PM, Valentina Crisan wrote:
> 1) I created another table for Query#2/3. The partition Key was StartTime
> and clustering key was name. When I execute my queries, I get an exception
1) I created another table for Query#2/3. The partition Key was StartTime
and clustering key was name. When I execute my queries, I get an exception
saying that I need to ALLOW FILTERING.
*Primary key(startTime,name) - the only queries that can be answered by
this model are: where startTime = , wh
Thank you for your response.
I have been through the document and I have tried these techniques but I
failed to model my queries correctly.
Forexample, I have already tried the following:
1) I created another table for Query#2/3. The partition Key was StartTime
and clustering key was name. When I
Hi!
Partition key (Id in your case) must be in WHERE cause if not using indexes
(but indexes should be used carefully, not like in case of relational DB's).
Also, only columns which belong to primary key ( = partition key + clustering
key) can be used in WHERE in such cases. That's why 2nd and
