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, 2018 at 6:42 PM, Akash Gangil <akashg1...@gmail.com> wrote: > Hi, > > I had a couple of questions: > > 1. Can I create a materialized view on a table with a TTL longer than the > base table? For ex: my materialized view TTL is 1 month while my base table > TTL is 1 week. > > 2. In the above scenario, since the data in my base table would be gone > after a week, would it impact data in the materialized view? > > My use case if I have some time series data, which is stored in the base > table by_minute and I want to downsample it to by_month. So my base table > stores by_minute data but my materialized view stores stores by_week data. > > thanks! > > -- > Akash >