On Thu, Jan 7, 2016 at 6:45 AM, anuja jain <anujaja...@gmail.com> wrote:
> My question is, what is the alternative if we need to order by col3 or > col4 in my above example without including col2 in order by clause. > The server-side alternative is to create a second table (or a materialized view, if you're using 3.0+) that uses a different clustering order. Cassandra purposefully only supports simple and efficient queries that can be handled quickly (with a few exceptions), and arbitrary ordering is not part of that, especially if you consider complications like paging. -- Tyler Hobbs DataStax <http://datastax.com/>