CODEWITHSUNDEEP
cassandranodetool
user10651098
user10651098

Reputation: 105

Cassandra Table Count Timeout

I try to get number of rows in a table. But cassandra turns timeout for this query select count(*) from events ;

I think that my tables is too big so if ı give a timeout value for my query, it turns always timeout cqlsh --request-timeout=200000

Table size 1.3TB. Is there any way to learn How many rows in this table ?

Upvotes: 2

Views: 1120

Answers (2)

Hitesh Shahani
Hitesh Shahani

Reputation: 69

Do not use count(*) to get no of rows.You can use the following link and download the jar file to get the count.
https://github.com/brianmhess/cassandra-count

Upvotes: 1

Mehul Gupta
Mehul Gupta

Reputation: 458

One solution that can help you find the total rows in Pagination of result.

Please refer to the below doc :

https://docs.datastax.com/en/developer/java-driver/3.2/manual/paging/

Note : You can also try ALLOW FILTERING for development! But the use of it should avoided as it is very expensive query, might impact the performance of the cassandra.

Upvotes: 0

Related Questions