argMin

Calculates the arg value for a minimum val value. If there are several different values of arg for minimum values of val, returns the first of these values encountered.

Tuple version of this function will return the tuple with the minimum val value. It is convenient for use with SimpleAggregateFunction.

Syntax

  1. argMin(arg, val)

or

  1. argMin(tuple(arg, val))

Arguments

  • arg — Argument.
  • val — Value.

Returned value

  • arg value that corresponds to minimum val value.

Type: matches arg type.

For tuple in the input:

  • Tuple (arg, val), where val is the minimum value and arg is a corresponding value.

Type: Tuple.

Example

Input table:

  1. ┌─user─────┬─salary─┐
  2. │ director │   5000 │
  3. │ manager  │   3000 │
  4. │ worker   │   1000 │
  5. └──────────┴────────┘

Query:

  1. SELECT argMin(user, salary), argMin(tuple(user, salary)) FROM salary;

Result:

  1. ┌─argMin(user, salary)─┬─argMin(tuple(user, salary))─┐
  2. │ worker               │ ('worker',1000)             │
  3. └──────────────────────┴─────────────────────────────┘

Original article