When CQLSh query returns partial results with followed by “More”

Topic: When results are missing from query

Audience: Scylla administrators

Synopsis

If you send a cqlsh query similar to:

SELECT * FROM 'keyspace.table' limit 100;

and the results show a single row with --More, the --More-- indicates that there are additional pages - if you click Enter, additional rows are displayed.

As the query is using paging (from cqlsh by default page size is 100) - Scylla uses this information internally and will fetch internally page size results. Some of these may be discarded and not returned to you or the output may reveal blank pages where you will see the more prompt causing you to page through empty pages. Neither of these outputs is desired.

If you need this in query as a single result you can turn off paging and include paging off in the query.

It is also recommended to turn tracing on (please keep the limit to 100 as well).