0.20.0 not returning data for TIME_FORMAT query with join

[Guang Hui Wu]

Hello,

In 0.20.0, I ran a query like

select * from table_A a,  table_B b
where a.id = b.id
and TIME_FORMAT(a.__time, 'YYYY-MM') >= '2020-10'
and TIME_FORMAT(a.__time, 'YYYY-MM') <= '2020-11'

This query did not return any results but, in 0.18.1 it did. When I remove the 
TIME_FORMAT, it returns the expected data.

select * from table_A a,  table_B b
where a.id = b.id
and a.__time >= '2020-10'
and a.__time <= '2020-11'

Also, if I remove the join from the original query, it also returns data

select * from table_A a
where TIME_FORMAT(a.__time, 'YYYY-MM') >= '2020-10'
and TIME_FORMAT(a.__time, 'YYYY-MM') <= '2020-11'

Has anyone run into this?

Thanks,
Guang

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@druid.apache.org
For additional commands, e-mail: dev-h...@druid.apache.org