Cassandra CQL Shell stop displaying rows

Question

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.

@mamdouh alramadan that seems to be the only viable solution. — daiyue, Jun 16 '16 at 10:55
ctrl+c for some reason screws the next query: it will always return nothing. I need to run the query twice after a ctrl+c — Hilikus, Jun 14 '17 at 20:38

score 7 · Accepted Answer · answered Jun 21 '16 at 06:36

7

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

answered Jun 21 '16 at 06:36

Oded Peer

2,377
18
25

score 1 · Answer 2 · answered Oct 02 '18 at 16:03

1

Cassandra is technically running your program (the query) so to kill it just press

ctrl -c

like you would to terminate any other command

answered Oct 02 '18 at 16:03

primChareka

281
3
6

Cassandra CQL Shell stop displaying rows

2 Answers2