The ML.NORMALIZER function

This document describes the ML.NORMALIZER function, which lets you normalize an array of numerical expressions using a given p-norm.

Syntax

ML.NORMALIZER(array_expression [, p])

Arguments

ML.NORMALIZER takes the following arguments:

• array_expression: an array of numerical expressions to normalize.
• p: a FLOAT64 value that specifies the degree of p-norm. This can be 0.0, any value greater than or equal to 1.0, or CAST('+INF' AS FLOAT64). The default value is 2.

Output

ML.NORMALIZER returns an array of FLOAT64 values that represent the normalized numerical expressions.

Example

The following example normalizes a set of numerical expressions using a p-norm of 2:

SELECT ML.NORMALIZER([4.0, 1.0, 2.0, 2.0, 0.0]) AS output;

The output looks similar to the following:

+--------+
| output |
+--------+
| 0.8    |
| 0.2    |
| 0.4    |
| 0.4    |
| 0.0    |
+--------+

What's next

• For information about feature preprocessing, see Feature preprocessing overview.
• For information about the supported SQL statements and functions for each model type, see End-to-end user journey for each model.