(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)