Search code examples
cassandradatastax

Cassandra PER PARTITION LIMIT not working throwing error in dev center

I am trying to run below CQL query in dev center (1.6) and seeing this error thus not allowing me to execute query. I verified DataStax documentation and I see syntax is correct. Any help please?

select * from some_table PER PARTITION LIMIT 1;

Error I see -> no viable alternative at input 'PER

Solution

  • If you're using DataStax Enterprise 6.x, then you need to use DataStax Studio instead of DevCenter. DSE 6 supports per partition limit without problems, it's a DevCenter that doesn't understand this syntax.