Query giving wrong results

can anyone tell me where I’m going wrong? I have attached the query and other files. the problem is the query gives the output for the year 2017 when there is no data for the year 2017.

Screen Shot 2018-07-06 at 11.56.31 AM.png

data1_test.json (13.7 KB)

query_aggr_2.json (240 Bytes)

You could try including some identifying dimensions in the query, that might help you narrow down what rows in your input data correspond to that 2017 data.

Hi dm.

How did you sure about there is no data on druid?

Did you check segment data loading information on coordinator console?