Max / Array Layer
Find the maximum value in each fixed-length numeric array. Similar to numpy.max() or R's max().
Example transformation (arrays of length 3):
| arrays | max |
|---|---|
| [1, 5, 3] | 5 |
| [-2, 0, 8] | 8 |
| [4, null, 2] | 4 |
| [null, null, null] | null |
Common applications:
- Finding peak values
- Maximum score detection
- Highest reading identification
- Range analysis
Note: All arrays must have the same fixed length. Only works with numeric arrays. Arrays containing all null values return null.
Table
0
0
Table
Select
columnThe fixed-length numeric array column to analyze. All arrays must have same length:
- Integer arrays: [1, 2, 3]
- Float arrays: [1.5, 2.7, 3.2]
- Mixed numeric arrays: [1, 2.5, 3]
AsColumn
nameName for the new column. If not provided, the system generates a unique name. If AsColumn matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.