For DS201, Clustering column exercise, i am trying to work on "8) Change your query to retrieve videos made in 2013 or later."
I have following table structure:
CREATE TABLE killrvideo.videos_by_tag ( tag text, added_date timestamp, title text, video_id uuid, PRIMARY KEY (tag, added_date) ) WITH CLUSTERING ORDER BY (added_date DESC)
Now when i am trying to fetch record with following query, its not showing anything if i use following query:
select * from videos_by_tag where tag='cassandra' and added_date >2012 and added_date<2014;
However its giving all 3 rows when doing this:
select * from videos_by_tag where tag='cassandra' and added_date >2012;