Created
February 24, 2020 05:25
-
-
Save taojy123/80d689a3262ff29278727e822d4c0981 to your computer and use it in GitHub Desktop.
Python Cassandra Paging
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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