Are client joins recommended in Cassandra Since query joins are not supported ?
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
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!
6 People are following this question.