Wrong results while querying

The results from the query are giving results which are not present in the dataset. In my case, I have set the interval from 2010 to 2019 and the dataset did not have any data for 2017. but I am getting results for 2017 too.
please check the attachments.

is there anything wrong with my query.

query_where.json (375 Bytes)

Hi Dilip,

I can’t think of any reason why Druid would invent data for a time where data doesn’t exist. I would suggest checking Druid’s coordinator console to really confirm that you don’t have any data for 2017.

yes, I did, even there I can see the data for 2017. but my csv file doesn’t have any data for 2017.