Complex types

ARRAY_FIND and CONTAINS can now search for elements that satisfy a predicate by using Lambda Functions.

ARRAY_FIND and CONTAINS can now search for elements that satisfy a predicate by using Lambda functions. The new FILTER function applies a predicate to an array and returns an array containing only elements that satisfy the predicate. See Searching and Filtering.

Parquet export

EXPORT TO PARQUET now supports the ARRAY and ROW types in any combination.