Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
MIME-Version: 1.0
In-Reply-To: <38BAB08C-1213-454D-889B-993DC06AADCE@gmail.com>
References: <38BAB08C-1213-454D-889B-993DC06AADCE@gmail.com>
From: Alain RODRIGUEZ <arodrime@gmail.com>
Date: Fri, 23 Sep 2016 12:24:28 +0200
Message-ID: <CA+VSrLrTdLkgWcWshy6UZ-cp5PbedhstBUuCprgpODr9xcQRAA@mail.gmail.com>
Subject: Re: Help on temporal data modeling
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=001a113d0aca199b19053d2a307d
archived-at: Fri, 23 Sep 2016 10:24:56 -0000

--001a113d0aca199b19053d2a307d
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hi Denis,

You might want to have a look at

- Materialized views
http://www.datastax.com/dev/blog/new-in-cassandra-3-0-materialized-views
- Secondary index
https://docs.datastax.com/en/cql/3.3/cql/cql_using/useWhenIndex.html

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:
https://www.youtube.com/watch?v=3DdxiuQ2CkXfM from DuyHai at the summit thi=
s
year :-).

C*heers,
-----------------------
Alain Rodriguez - @arodream - alain@thelastpickle.com
France

The Last Pickle - Apache Cassandra Consulting
http://www.thelastpickle.com

2016-09-23 10:42 GMT+02:00 Denis Mikhaylov <notxcain@gmail.com>:

> Hi!
>
> I have question regarding data modelling.
>
> Let=E2=80=99s 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 <=3D today`)

--001a113d0aca199b19053d2a307d
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi Denis,<div><br></div><div>You might want to have a look=
 at=C2=A0</div><div><br></div><div>- Materialized views <a href=3D"http://w=
ww.datastax.com/dev/blog/new-in-cassandra-3-0-materialized-views">http://ww=
w.datastax.com/dev/blog/new-in-cassandra-3-0-materialized-views</a></div><d=
iv>- Secondary index=C2=A0<a href=3D"https://docs.datastax.com/en/cql/3.3/c=
ql/cql_using/useWhenIndex.html">https://docs.datastax.com/en/cql/3.3/cql/cq=
l_using/useWhenIndex.html</a></div><div><br></div><div>My 2 cents: make sur=
e to understand the implications before moving forward, what is happening u=
nder 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 t=
o watch this:=C2=A0<a href=3D"https://www.youtube.com/watch?v=3DdxiuQ2CkXfM=
">https://www.youtube.com/watch?v=3DdxiuQ2CkXfM</a> from DuyHai at the summ=
it this year :-).</div><div><div><br></div><div>C*heers,</div></div><div><d=
iv>-----------------------</div><div>Alain Rodriguez - @arodream - <a href=
=3D"mailto:alain@thelastpickle.com">alain@thelastpickle.com</a></div><div>F=
rance</div><div><br></div><div>The Last Pickle - Apache Cassandra Consultin=
g</div><div><a href=3D"http://www.thelastpickle.com">http://www.thelastpick=
le.com</a></div></div></div><div class=3D"gmail_extra"><br><div class=3D"gm=
ail_quote">2016-09-23 10:42 GMT+02:00 Denis Mikhaylov <span dir=3D"ltr">&lt=
;<a href=3D"mailto:notxcain@gmail.com" target=3D"_blank">notxcain@gmail.com=
</a>&gt;</span>:<br><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0=
 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi!<br>
<br>
I have question regarding data modelling.<br>
<br>
Let=E2=80=99s say that I have `subscriptions` table with two columns `subsc=
ription_id text` and `next_billing_date timestamp`.<br>
<br>
How do I model a table to efficiently query all subscriptions due today (so=
mething like `where next_billing_date &lt;=3D today`)</blockquote></div><br=
></div>

--001a113d0aca199b19053d2a307d--