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.
Example query suitable for a daily collection interval
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.
Example query suitable for an hourly collection interval
select a, b, timefield
from anodot.table
where timefield between '{{from_time(yyyy-MM-dd HH)}}' and '{{to_time(yyyy-MM-dd HH)}}'