How to solve row count in a table time out

When I perform a row count on my Table I get a timeout error:

select count (*) from <Tablename>;

Is giving an error OperationTimedOut: errors={‘x.x.x.x’: ‘Client request timeout. See Session.execute_async’}, last_host=x.x.x.x

How can I solve this?

If you’re using cqlsh, try increasing the “request timeout” when starting cqlsh.
I think it should work by providing it in the cqlsh command:

cqlsh --request-timeout=6000

1 Like