I am doing full scan of Cassandra table which has 75 million records. I am using cassandra python driver to connect to cassandra database and below is my code. While iterating ResultSet, the loop is fetching 100 records per page which is fine but it is fetching same 100 records again and again in repeating way. I am new to Cassandra and appreciate if someone can help me.
statement = SimpleStatement("SELECT * FROM keyspace.tablename", fetch_size=500) rows = session.execute(statement) for row in rows: print row.sid, row.sname