Solution 1:
You can use filter function:
select filter(array['element1', 'element2', NULL], el -> el is not null) filtered
Output:
| filtered |
|---|
| [element1, element2] |
Athena How to Remove NULL from Array
Solution 1:
You can use filter function:
select filter(array['element1', 'element2', NULL], el -> el is not null) filtered
Output:
| filtered |
|---|
| [element1, element2] |