Scylla University Live | Nov 9 (AMERICAS), Nov 10 (EMEA and APAC) Free Virtual Training Event
Learn More

CQL Query Does Not Display Entire Result Set

Audience: Scylla administrators

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 text result of this query as a single run, without the page delimiter, you can turn off paging.

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