Skip to content

Instantly share code, notes, and snippets.

@taojy123
Created February 24, 2020 05:25
Show Gist options
  • Save taojy123/80d689a3262ff29278727e822d4c0981 to your computer and use it in GitHub Desktop.
Save taojy123/80d689a3262ff29278727e822d4c0981 to your computer and use it in GitHub Desktop.
Python Cassandra Paging
from cassandra.cluster import Cluster
from cassandra.query import SimpleStatement
cluster = Cluster(['taojy123.com'])
session = cluster.connect('taiqiyun')
query = "SELECT * FROM best"
statement = SimpleStatement(query, fetch_size=2)
ps = None
print('------1')
page1 = session.execute(statement, paging_state=ps)
ps = page1.paging_state
for row in page1.current_rows:
print(row)
print('------2')
page2 = session.execute(statement, paging_state=ps)
ps = page2.paging_state
for row in page2.current_rows:
print(row)
print('------3')
page3 = session.execute(statement, paging_state=ps)
ps = page3.paging_state
for row in page3.current_rows:
print(row)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment