I want to ignore the clustering keys orders in my query? Can I do that?
I am not sure, I think you can't:
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
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.
The Last Pickle - Apache Cassandra Consulting