cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alain RODRIGUEZ <arodr...@gmail.com>
Subject Re: How I can ignore clustering key order and read latests writes first?
Date Mon, 11 Jul 2016 20:47:09 GMT
Hi Reza,

I want to ignore the clustering keys orders in my query? Can I do that?
>

I am not sure, I think you can't:

>From https://cassandra.apache.org/doc/cql3/CQL.html:

Another option is CLUSTERING ORDER. It allows to define the ordering of
> rows on disk. It takes the list of the clustering column names with, for
> each of them, the on-disk order (Ascending or descending). Note that this
> option affects what ORDER BY are allowed during SELECT
> <https://cassandra.apache.org/doc/cql3/CQL.html#selectOrderBy>.


I would say (I read quickly) that the answer your received is not that bad
excepted that updating a row do not generate a tombstone contrary to what I
read there. In some specific cases, like when using collections and
replacing the whole collection for example.

You really need to think about your queries at the schema creation time
when using Cassandra. Also do not use "Allow Filtering". Build your model
without having to use it. This do not scale, and you probably choose
Cassandra because it scales, among other things.

I have asked a question in SO and I've not got response (Of curse someone
> tried to help me, but his/her answer wan't satisfied me)!:


Why aren't you satisfied with it? Providing detailed informations is the
best way to receive detailed answers.

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

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

2016-07-09 10:08 GMT+02:00 Reza Samee <reza.samee@gmail.com>:

> Hello everyone!
>
> I have asked a question in SO and I've not got response (Of curse someone
> tried to help me, but his/her answer wan't satisfied me)!:
> http://stackoverflow.com/questions/38247368/as-i-know-in-range-queries-cassandra-reterives-result-ordered-by-culstring-key
>
> I want to ignore the clustering keys orders in my query? Can I do that?
>
> --
> رضا سامعی / http://samee.blog.ir
>

Mime
View raw message