Well then you better provide your schema and query, as I select ranges like
this all the time using CQL and I (at least) must not understand your
problem from the description so far.
On Wed, Jun 18, 2014 at 2:54 AM, DuyHai Doan wrote:
> Hello Jason
>
> If you want to check for presence / absenc
Hello Jason
If you want to check for presence / absence of data for a day, you can add
the date as a composite component to your partition key. Cassandra will
rely on the bloom filter and avoid hitting disk for maximum performance.
The only drawback of this modelling is that you need to provide t
That's how my schema is built. So far, I'm pulling the data out by a
range of 30 days. I want to see if I have data for every day, just
wondering if it's possible in the CQL, as opposed to how i'm doing it
now, in python.
On Tue, Jun 17, 2014 at 9:46 PM, Laing, Michael
wrote:
> If you can arrang
If you can arrange to index your rows by:
(, )
Then you can select ranges as you wish.
This works because is the "partition key", arrived at by
hash (really it's a hash key), whereas is the "clustering
key" (really it is a range key) which is kept in sorted order both in
memory and on disk.
I
I have data stored with the timestamp datatype. Is it possible to use
CQL to return results based on if a row falls in a range for a day?
Ex. If I have 20 rows that occur on 2014-06-10, no rows for 2014-06-11
and 15 rows that occured on 2014-06-12, I'd like to only return
results that data exists