cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alain RODRIGUEZ <>
Subject Re: Help on temporal data modeling
Date Fri, 23 Sep 2016 10:24:28 GMT
Hi Denis,

You might want to have a look at

- Materialized views
- Secondary index

My 2 cents: make sure to understand the implications before moving forward,
what is happening under the hood or at least that your use case fits with
the recommendations. Indexes and views are not free. If you want to know
more, you might want to watch this: from DuyHai at the summit this
year :-).

Alain Rodriguez - @arodream -

The Last Pickle - Apache Cassandra Consulting

2016-09-23 10:42 GMT+02:00 Denis Mikhaylov <>:

> Hi!
> I have question regarding data modelling.
> Let’s say that I have `subscriptions` table with two columns
> `subscription_id text` and `next_billing_date timestamp`.
> How do I model a table to efficiently query all subscriptions due today
> (something like `where next_billing_date <= today`)

View raw message