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