Skip to main content
Version: current [24.2.x]

Semi-Structured Data

Function NameDescription
ARRAY_AVGReturns the average of all non-null elements of a list.
ARRAY_CONTAINSReturns whether a list contains a given value.
ARRAY_MAXReturns the maximum value of a list.
ARRAY_MINReturns the minimum value of a list.
ARRAY_REMOVERemoves all elements that equal a given value from a list.
ARRAY_SUMReturns the sum of all non-null elements of a list.
CARDINALITYReturns the number of elements contained in the specified list or map.
FLATTENExplodes compound values into multiple rows. This function takes a LIST column and produces a lateral view (that is, an inline view that contains correlation referring to other tables that precede it in the FROM clause).
MAP_KEYSReturns all keys from a map expression.
MAP_VALUESReturns all values from a map expression.