Skip to main content
aggregate_min_max(table_name=None, column_name=None, options=)[source]

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

Parameters

table_name (str) –

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 (str) –

Name of a column or an expression of one or more column on which the min-max will be calculated.

options (dict of str to str) –

Optional parameters. The default value is an empty dict ( ).

Returns

A dict with the following entries–

min (float) –

Minimum value of the input parameter column_name.

max (float) –

Maximum value of the input parameter column_name.

info (dict of str to str) –

Additional information. Allowed keys are:

  • min_string – The minimum value of input parameter column_name, stored as a byte vector.

  • max_string – The maximum value of input parameter column_name, stored as a byte vector.

The default value is an empty dict ( ).