Error when trying to filter two column from unnested array

dremio reports
Node [rel#1875594:Subset#4.LOGICAL.ANY([]).[]] could not be implemented; when I tried to do filters on two columns from unested array.

the query:

SELECT index, flatten(tags) AS tags, flatten(categories) as categories
FROM tmp.“testArrayUnestNL.json”
) nested_0
WHERE tags = ‘magna’ AND categories = ‘ex’

how to reproduce:

import the testArrayUnestNL to dremio and run the query above. the error will show up. (522 Bytes)

query profile (6.7 KB)