Syntax
COMPRESS(<list>)
Description
Removes all null values from a list.
Examples
Column1 | COMPRESS returns |
|---|---|
| [4, 18, 36, null, 95] | [4, 18, 36, 95] |
| [33.7, 82.5, 126.02, 133.4, null] | [33.7, 82.5, 126.02, 133.4] |
| [Tue Aug 02 15:55:03 CEST 2011, null, Fri Oct 15 04:34:34 CEST 2010] | [Tue Aug 02 15:55:03 CEST 2011, Fri Oct 15 04:34:34 CEST 2010] |
| [true, false, false, null, true] | [true, false, false, true] |
| [Mike, John, Charles, null, Rob] | [Mike, John, Charles, Rob] |
...