How to do a join queries with 2 or more tables in cassandra cql

by

Cassandra = No Joins. Your model is 100% relational. You need to rethink it for Cassandra. I would advice you take a look at these slides. They dig deep into how to model data for cassandra. Also here is a webinar covering the topic. But stop thinking foreign keys and joining tables, because if you need relations cassandra isn’t the tool for the job.

But Why?
Because then you need to check consistency and do many other things that relational databases do and so you loose the performance and scalability that cassandra offers.

What can I do?
DENORMALIZE! Lots of data in one table? But the table will have too many columns!
So? Cassandra can handle a very large number of columns in a table.

The other thing you can do is to simulate the join in your client application. Match the two datasets in your code, but this will be very slow because you’ll have to iterate over all your information.

Another way is to carry out multiple queries. Select the event you want, then the matching tower.

More Related Contents:

  1. cassandra get all records in time range
  2. Cassandra cqlsh – how to show microseconds/milliseconds for timestamp columns?
  3. How do secondary indexes work in Cassandra?
  4. Difference between partition key, composite key and clustering key in Cassandra?
  5. Is the IN relation in Cassandra bad for queries?
  6. MAX(), DISTINCT and group by in Cassandra
  7. Inner Join in cassandra CQL
  8. How to create auto increment IDs in Cassandra
  9. Understand cassandra replication factor versus consistency level
  10. Cassandra cqlsh – connection refused
  11. cassandra – Saved cluster name Test Cluster != configured name
  12. Cassandra has a limit of 2 billion cells per partition, but what’s a partition?
  13. What version of Cassandra does Fluent Cassandra v0.7.0.3 support? [closed]
  14. MySQL and NoSQL: Help me to choose the right one
  15. How to run shell script file using nodejs?
  16. cqlsh connection error: ‘ref() does not take keyword arguments’
  17. MongoDB vs. Cassandra [closed]
  18. Cassandra port usage – how are the ports used?
  19. TaskSchedulerImpl: Initial job has not accepted any resources;
  20. Is there a reason not to use SparkContext.getOrCreate when writing a spark job?
  21. java.lang.NoClassDefFoundError: org/apache/spark/Logging
  22. Elasticsearch vs Cassandra vs Elasticsearch with Cassandra
  23. Is there any query for Cassandra as same as SQL:LIKE Condition?
  24. com.datastax.driver.core.exceptions.InvalidQueryException: unconfigured table schema_keyspaces
  25. How to fix the “Found Netty’s native epoll transport in the classpath, but epoll is not available. Using NIO instead” warning?

Leave a Comment