The normal approach is denormalization to a materialized view (the
traditional thinking of it not the new 3.0 feature coming out), which is
also true of using an RBMS at scale (joins across all data sets get
expensive once you start having to shard across different servers).
The simplistic idea is
Denormalize your data to support the query, e.g.:
CREATE TABLE name_by_cust_id (cust_id int, name text, PRIMARY KEY
> (cust_id));
> SELECT name WHERE cust_id = 3;
For additional queries, similarly denormalize.
Refer to https://academy.datastax.com/courses for free online courses
covering this t
Sent from Samsung Mobile.
Hi All,
I am trying to model RDBMS joins into cassandra. As I am new to cassandra, I
need your help/suggestion on this. Below is the information regarding the
query:
I have a query in RDBMS as follows:
select t3.name from Table1 t1, Table2 t2, Table3 t3, Ta
1. Hi All,
1. I am trying to model RDBMS joins into cassandra. As I am new to
cassandra, I need your help/suggestion on this. Below is the information
regarding the query:
2.
3. I have a query in RDBMS as follows:
4.
5. select t3.name from Table1 t1, Table2 t2, Table3
