Cassandra CQL query giving error with ORDER BY ASC and LIMIT

Question

I have created a Cassandra table with below configuration :

CREATE TABLE "ABC" (
    subsector text,
    marketcapital decimal,
    id text,
    PRIMARY KEY (subsector, marketcapital, id)
) WITH CLUSTERING ORDER BY ( marketcapital DESC, id ASC )

CQL query giving error on running in Datastax dev center :

select * from "ABC" where subsector='10010' and marketcapital > 50717820.457485 ORDER BY marketcapital ASC  LIMIT 3

On executing above query i get below error:

Seems error with ORDER BY ASC with LIMIT keyword.

Answer 1

This seems to be an issue with Datastax Dev Center, as when I run the same query with cqlsh works fine.

Most probable reason is Dev center is using some old version of CQL spec, due to this error occurred.