python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - cassandra-4.0

Cassandra paging on a primary key list does not work

I have a problem with the pagination in cassandra with python connector. I would like to paginate on a list of primary keys. Here is the schema of the table: client_data.store ( id text PRIMARY KE...
test-img

Pierre Chartier

python

database

cassandra

cassandra-driver

cassandra-4.0

Votes: 0

Answers: 1

Latest Answer

Simple reason is that token is hash function which calculates a hash value from the partition key. So saying give me key with formula gt>13 and saying give me tokens with formula gt>token(13) i...
test-img

Manish Khandelwal

How to add plus 1 day to a timestamp in Cassandra SQL?

I am trying to add 1 day to a timestamp field. Below is what I have tried but not working: select studentid, (course_date + 1) as nextday from students where studentid=123; select studentid,(course_da...
test-img

Divya Sam

cassandra

cql

cassandra-4.0

Votes: 0

Answers: 1

Latest Answer

Yes, you can specify a time component along with the date arithmetic. In this case, changing 1 to 1d (one day) solves this: > SELECT studentid,course_date + 1d as nextday FROM students WHERE stude...
test-img

Aaron

Posts

Questions

Blogs

Jobs