Suppose we have a generic table:
And create an index on regular text column, the schema of the index table will be:
Then it's possible to execute queries like:
However, CQL3 would check if the secondary index is used WITH order by during prepare a select statement, and throw an exception at once for queries like above.
Could we support ORDER BY with 2ndary Indexes at least for above query pattern?