Search code examples
cassandracqlcqlsh

Cassandra CQL Shell stop displaying rows

I am wondering is there a command to stop displaying MORE rows from the CQL Shell. I created a table and inserted with 100k rows, so every time select * from test_table will display 100k rows, with MORE rows shown by pressing the Enter key. So I have to close the window and start the shell again.

I am using Cassandra on Windows 10 X64.

Solution

  • You can disable paging in cqlsh using the PAGING OFF command https://docs.datastax.com/en/cql/3.1/cql/cql_reference/paging.html