Hi i have a keyspace with more than 1 million records spanning in 3 nodes. I want to use pagination to fetch 1000 records at a time. I went through java driver to see how to implememt and here is the simplest example i could see
Statement stmt = new SimpleStatement("SELECT * FROM images"); stmt.setFetchSize(1000); ResultSet rs = session.execute(stmt)
What i need to understand is how it is handled internally, i mean a simple statement of 'SELECT * FROM images ' would be hard and it might time out. But paging with 1000 rows at a time solves this. But how are they fetching the first 1000 rows with this paging. We are not exlplicitely providing partition key in the above pagination query. Is it doing the same read path in cassandra?
It would be great if someone could explain the internal path or flow in which pagination occur
thanks