How to update or search Cassandra table with multiple fields that are not a Partition Key

Question

How to update or search Cassandra table with multiple fields that are not a Partition Key

sujit-baniya opened this issue 5 years ago · 5 comments

Hello,

I was trying to connect Phantom driver to scala. I'm able to insert data to the cassandra table. But when I tried to search or update table by name or some field other than ID(PartitionKey), I couldn't do that.

Please suggest one how can I achieve the solution?

Answer 1 · 2019-06-13T11:25:21.000Z

Here are some examples.

https://github.com/outworkers/phantom/blob/develop/phantom-dsl/src/test/scala/com/outworkers/phantom/builder/query/db/crud/UpdateQueryTest.scala#L44

Answer 2 · 2019-06-13T11:28:42.000Z

@alexflav23 Thank you for quick response. I checked the file but the query is using pKey which I believe is PartitionKey.

Answer 3 · 2019-06-13T11:29:37.000Z

@itsursujit That's how Cassandra works. Maybe spend some time reading about data modelling in Cassandra. https://medium.com/outworkers

Answer 4 · 2019-06-13T11:32:39.000Z

@itsursujit This specifically might help you: https://medium.com/outworkers/at-outworkers-cassandra-and-datastax-enterprise-are-core-technologies-in-our-area-of-competence-4a1df2eb718d.

Otherwise read the docs on how to use SASI indexes, secondary indexes etc.

Answer 5 · 2019-06-13T11:39:30.000Z

Great! Thank you