Input Table Schema
Column | Data Type | Description |
---|---|---|
target_column | SMALLINT, INT, BIGINT, NUMERIC, or DOUBLE PRECISION | [Column appears once for each specified target_column.] Contains numeric values. |
Invalid Input Data Handling
- If the input table has infinity or NaN values, the input is invalid. The Scale and ScaleByPartition functions do not process these values, but the ScaleMap function counts the values in each column, including invalid values. The count of input values is available in the output of the ScaleSummary function.
- If a column contains only invalid input values, the data in this column is not modified.
- If a sequence has only one unique value, the result of the USTD, STD, RANGE, and MIDRANGE operations are NaN values because the function cannot calculate the scale.