I have a subquery in the CQ. Checked logs and here is how it’s executed:
SELECT mean(quality) AS uptime INTO dnsperf.three_months_uptime_provider.uptime FROM ( SELECT sum(status) / sum(status) AS quality FROM dnsperf.one_week_provider.provider GROUP BY node, server, countryId, continentId, time(1m) FILL(none) ) WHERE time >= '2017-04-18T11:00:00Z' AND time < '2017-04-18T13:00:00Z' GROUP BY node, server, countryId, continentId, time(1h) FILL(none) service=query
As you can see, internal query is not filtered by time. Does it mean it’s looking at entire db data and then filters it out when inserting data into outer query? Can we somehow fix it if that’s the case?