Apache Druid

what's happening here is that SQL planner is thinking that only possible value of `tags` is tag1 and thus the query effectively becomes
```SELECT
'tags1',
 Id
FROM View
where __time BETWEEN '2022-08-21 22:15:16.0' AND '2022-08-21 23:20:16.0'
GROUP BY Id ORDER BY Id```

you should be using `MV_CONTAINS` operator instead of using `=` operator when filtering the relevant rows

also, when doing a group by a MV, it will expand each value in it's own row, so if you want to disable that, you need to use another function to keep the tags as array (I think it's MV_CONCAT or MV_TO_STRING)

or, maybe it's easier to use `groupByEnableMultiValueUnnesting: false` in the query context

btw there is some correction to be made in my query. The filter is not going to be removed. but the projection (tags --&gt; 'tags1') does get re-written.