Aggregate Min/Max

Calculates and returns the minimum and maximum values of a particular column in a table.

Input Parameter Description

Name	Type	Description
table_name	string	Name of the table on which the operation will be performed. Must be an existing table, in [schema_name.]table_name format, using standard name resolution rules.
column_name	string	Name of a column or an expression of one or more column on which the min-max will be calculated.
options	map of string to strings	Optional parameters. The default value is an empty map ( {} ).

Name

Type

Description

min

double

Minimum value of the input parameter column_name.

max

double

Maximum value of the input parameter column_name.

info

map of string to strings

Additional information. The default value is an empty map ( {} ).

Possible Parameters (keys)	Parameter Description
min_string	The minimum value of input parameter column_name when it is a char type
max_string	The maximum value of input parameter column_name when it is a char type