(The scenario was from katacoda>Apache Cassandra for Developers>Atomicity & Batches) Let's consider two different tables of different partitions....
CREATE TABLE ratings_by_user (
email TEXT,
title TEXT,
year INT,
rating INT,
PRIMARY KEY ((email), title, year)
)
CREATE TABLE ratings_by_movie (
title TEXT,
year INT,
email TEXT,
rating INT,
PRIMARY KEY ((title, year), email)
)
After doing some record insertions, I try to read from the tables using the below query:
select * from ratings_by_movie where title='Alice in Wonderland' and year=2018 and email='joe@datastax.com';
select * from ratings_by_user where title='Alice in Wonderland' and year=2018 and email='joe@datastax.com';
For both select statements, the result was same,
Title = 'Alice in Wonderland'
Year = 2018
Email = 'joe@datastax.com'
My question is how could the where clause conditions be same for the both different tables of different partitions and why error is not thrown here??? (I have also included a screenshot here for the scenario where I experienced the same)
