CQ subquery time

,
1

Hi.
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?
Thanks.

1 Like