Filter on union queries are failing for jdbc

Query has the time range spanning daily and hourly tables and filters are applied.

sample query:
cube select product_id from sales where time_range_in(delivery_time,'2016-01-01-00','2016-01-02-02') and product_id in ('45')