I have table like
CREATE TABLE calculated ( forecast_id int, month int, year int, day_of_the_month int, management_area_cd text, tc text, count int, value double, date text, resicount int, resiforecast double, xhcount int, xhforecastvalue double, PRIMARY KEY (forecast_id, month, year, day_of_the_month, management_area_cd, tc) )
i have to query using forecast_id and list of month and year.
so i am creating query using
select * from calculated where where id=1 and month in (1,3,5,6,8) and year =2021 allowing filtering.
I am calling this query for couple of years in a loop.
Please let me know is it the perfect query first we are using IN statement but for same partition also we are using allow filtering.