CODEWITHSUNDEEP
databasecassandrapartitioning
user6023611
user6023611

Reputation:

partition key in cassandra, make field invisible

I consider partition key in cassandra. My choice is timestamp. I think that it is fairly Ok for performance. I am made to duplicate this column because I would like to be able to do comparison > and >=. Is it possible to make invisible some column in cassandra?
Maybe, other field is better chocie of key partitioning ?

Thanks in advance for your help.

Upvotes: 0

Views: 35

Answers (1)

Chris Lohfink
Chris Lohfink

Reputation: 16400

Timestamp is almost always the wrong partitioning key. See https://academy.datastax.com/demos/getting-started-time-series-data-modeling but basically you should have your partition key the object your looking up and use timestamp as the clustering key that you can then do the > and >= on.

Upvotes: 1

Related Questions