Hi!
I've created a unit test for DRILL-7722. From how things look from the outside, drill parses the VIEW query to some AST representation and generates the view file out of that. Somewhere there lies the issue, the UNNEST clause is generated wrongly with extraenous parentheses. Any hints on where to start digging? Cheers, Bozzo