SQL queries time pattern and the collection interval

When you create your own query, the "from_time, to_time" in the “WHERE” clause must specify a pattern that matches the stream's collection interval, otherwise the query will not progress.

select a, b, timefield
from anodot.table
where timefield between '{{from_time(yyyy-MM-dd)}}' and '{{to_time(yyyy-MM-dd)}}'

Note that even though the results preview will show an hour, the “WHERE” clause does not include an hour, and therefore the query will not progress as expected.

select a, b, timefield
from anodot.table
where timefield between '{{from_time(yyyy-MM-dd HH)}}' and '{{to_time(yyyy-MM-dd HH)}}'