Scalar SQL expressions which take zero or more inputs and for each input row generate one output
value. A subclass of these expressions are of type
Predicate
whose result type is
`boolean`. See
Predicate
for predicate type scalar expressions. Supported non-predicate
type scalar expressions are listed below.
- Name:
element_at
- Semantic:
element_at(map, key)
. Return the value of given key
from the map type input. Returns null if the given key is not in
the map Ex: `element_at(map(1, 'a', 2, 'b'), 2)` returns 'b'
- Since version: 3.0.0
- Name:
COALESCE
- Semantic:
COALESCE(expr1, ..., exprN)
Return the first non-null
argument. If all arguments are null returns null
- Since version: 3.1.0
- Name:
TIMEADD
- Semantic:
TIMEADD(colExpr, milliseconds)
. Add the specified number of
milliseconds to the timestamp represented by colExpr. The adjustment does not
alter the original value but returns a new timestamp increased by the given
milliseconds. Ex: `TIMEADD(timestampColumn, 1000)` returns a timestamp 1 second
later.
- Since version: 3.3.0