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 * FROM (
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.
testArrayUnestNL.json.zip (522 Bytes)
query profile
6092756e-88d9-43d7-811f-7cd751bf7490.zip (6.7 KB)