You can SELECT DISTINCT in CQL, however I would recommend against such a pattern as it is very unlikely to be efficient, and prone to errors. A distinct query will search every partition for the first live cell, which could be buried behind a lot of tombstones. It's safe to say at some point you will run into serious issues. Selecting all the keys in a table purely to see what exists is not going to be cheap, and sounds awfully like an anti-pattern. Why do you need this behaviour?
- Getting all unique keys Avi Levi
- Re: Getting all unique keys Sruti S
- Re: Getting all unique keys kurt greaves
- Re: Getting all unique keys Avi Levi
- Re: Getting all unique keys Eric Stevens
- Re: Getting all unique keys Avi Levi
- Re: Getting all unique keys Christophe Schmitz
- Re: Getting all unique keys Avi Levi
- Re: Getting all unique keys Christophe Schmitz
- Re: Getting all unique ke... Avi Levi
- RE: Getting all unique ke... Durity, Sean R