CLUSTER BY
clause (TABLE)mask
clauseROW FILTER
clauseUpdated Nov 01, 2024
array_compact
function Applies to: Databricks SQL Databricks Runtime 12.2 LTS and above
Removes NULL elements from array
.
The function returns an array of the same type as the input argument where all NULL values have been removed.