I have a Cassandra table containing over 450,000 rows. When attempting to fetch all the rows, I consistently receive slightly fewer results, for example, 448,546. For certain use cases, I need to retrieve the entire dataset in one go. What strategies or configurations can ensure that I can accurately fetch all rows from this large dataset? Any advice on handling large-scale data retrieval in Cassandra would be appreciated.

I’m trying to install Cassandra DB from https://cassandra.apache.org/_/download.html
The latest and the second latest version do not contain in the bin folder the file “cassandra.bat” but there is a file named “cassandra” without extensions.
Sorry for the dummy question but how can I open the bins? If I run cassandra on my terminal windows opens a popup to select a program to open cassandra

I am planning to upgrade my 6 node Apache Cassandra from 3.0 (RHEL 7.9) to 4.1 version (RHEL 8) without downtime. We are moving to new RHEL 8 server. We are upgrading with 4.1 version on the new RHEL 8 server. Please help us how can I do it without a downtime.