Bringing together the Apache Cassandra experts from the community and DataStax.

Want to learn? Have a question? Want to share your expertise? You are in the right place!

Not sure where to begin? Getting Started

 

question

376752150_179413 avatar image
376752150_179413 asked ·

Why does the query "select ... WHERE TOKEN(uid)>-8474455431603971223 LIMIT 80;" time out?

SELECT TOKEN(uid),other columns,uid FROM uid2jtis WHERE TOKEN(uid)>-8474455431603971223 LIMIT 80;

returns timeout error below:

ReadTimeout: Error from server: code=1200 [Coordinator node timed out waiting for replica nodes' responses] message="Operation timed out - received only 0 responses." info={'received_responses': 0, 'required_responses': 1, 'consistency': 'ONE'}


However,

SELECT TOKEN(uid),other columns,uid FROM uid2jtis WHERE TOKEN(uid)>-8474455431603971223 LIMIT 79;

succeed.

Any insights would be much appreciated!

token
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

376752150_179413 avatar image
376752150_179413 answered ·

Thanks @Lewisr650's reply.

The reason is the data file is corrupted....

Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

Lewisr650 avatar image
Lewisr650 answered ·

This is a function of the fact that you are performing a range query across a large number of Tokens and it can't complete the scan in less than 10 seconds. What is the timing when you do this for 79?

Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.