Re: Using materialized view or AllowFiltering which one is better ?

2017-10-09 Thread Valentina Crisan
Allow filtering is almost never the answer, especially when you want to do a full table scan ( there might be some cases where the query is limited to a partition and allow filtering could be used). And you would like to run this query every minute - thus extremely good performance is required. All

Re: Using materialized view or AllowFiltering which one is better ?

2017-10-09 Thread Valentina Crisan
last entry > . So the proposed solution is actually keeping much more data then needed . > > On Oct 9, 2017 8:40 PM, "Valentina Crisan" > wrote: > > Allow filtering is almost never the answer, especially when you want to do > a full table scan ( there might be some

Re: Materialized Views and TTLs

2018-02-23 Thread Valentina Crisan
Hello, as far as I know it is not intended for MV's to have a different TTL than the base tables. There was patch released at some point to not allow TTL setting on MV (https://issues.apache.org/jira/browse/CASSANDRA-12868). MV's should inherit the TTL of the base table. Valentina On Fri, Feb 23

Re: Materialized Views and TTLs

2018-02-23 Thread Valentina Crisan
: > Hi Valentina, > > In that case, are there any well defined ways on how to do downsampling of > data in C*? > > thanks! > > > On Fri, Feb 23, 2018 at 11:36 AM, Valentina Crisan < > valentina.cri...@gmail.com> wrote: > >> Hello, >> >&g

Re: Cassandra filter with ordering query modeling

2018-03-01 Thread Valentina Crisan
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