I’m trying to understand an interesting anomaly with the results of a query. I do

select sum(metric), key, min(date) as firstSeen, max(date) as lastSeen from table where date >= <lowDate> AND date <= <highDate> group by key order by firstSeen desc limit 1

. I get a single row as expected, but with a

firstSeen

and

lastSeen

both equal to

<highDate>

. I was expecting the

firstSeen

result to be equal to

<lowDate>

. If I then run the exact same query, but add in

AND key = '<key value from the previous result>'

, I get the a single row with the requested key value, but now the

firstSeen

result is equal to

<lowDate>

(as expected), and

sum(metric)

is larger (also as expected). Any ideas what is going on?

How about

select date from table where date >= <lowDate> AND date <= <highDate> AND key = '<key value from the previous result>'

?

It’s high cardinality, but

numGroupsLimitReached: false

in response. And the difference is for a specific key value, not a missing key value.