This message was deleted.

does

ARRAY_CONTAINS

work in this case?

Thanks Gian, It is not, same error

SELECT ARRAY_AGG (ids, 3000)
FROM view
where __time BETWEEN '2022-08-21 22:15:16.0' AND '2022-08-21 23:20:16.0'
GROUP BY traceId
HAVING 
ARRAY_CONTAINS(ARRAY_AGG (ids, 3000), ARRAY['test'])

hmm, not sure if this is supposed to work or not. trying to figure out if it's a bug report or feature request 🙂 what version is this? & @Clint Wylie do you know if this case is meant to work?

I think its a bit of missing functionality, it looks like filtering stuff is not well wired up to arrays other than stuff that uses expression filter

build 2022.04 iap.

or .. something, i can look closer at the code involved in a bit

Thanks @Clint Wylie

maybe we can start with adding an

@Ignore

test for this case?

or one that expects the current failure and so breaks when we add support 🤷

i like the

@Ignore("github issue url goes here")

but either one works