Bringing together the Apache Cassandra experts from the community and DataStax.

Want to learn? Have a question? Want to share your expertise? You are in the right place!

Not sure where to begin? Getting Started

 

question

ashok.dcosta_187920 avatar image
ashok.dcosta_187920 asked ·

Are client-side joins recommended in Cassandra?

Are client joins recommended in Cassandra Since query joins are not supported ?

cassandrajoin
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered ·

Queries which require joins are not recommended in Cassandra because they don't perform or scale well. If you have to do a JOIN to satisfy an application request, it implies that you didn't get your data model right.

You need to design your data model such that each app query maps to one table. If you have to do a client-side JOIN it means that you had to query the database multiple times to get the data. It may work for you but it will never perform as well as making a single read request to one table. Cheers!

Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.