MAP functions - MaxCompute - Alibaba Cloud Documentation Center

MaxCompute supports four complex data types: ARRAY, MAP, STRUCT, and JSON. This topic describes MAP functions and their features.

Function	Feature
EXPLODE	A user-defined table-valued function (UDTF) that converts a single row of data into multiple rows.
INDEX	Returns values that meet specified conditions in a MAP parameter.
MAP	Creates a MAP using specified Key-Value pairs.
MAP_CONCAT	Returns the union of multiple MAPs.
MAP_ENTRIES	Transforms Key-Value mappings in a MAP into a struct array.
MAP_FILTER	Filters elements in a MAP.
MAP_FROM_ARRAYS	Constructs a MAP from a given array.
MAP_FROM_ENTRIES	Constructs a MAP from a given struct array.
MAP_KEYS	Returns all keys in the parameter MAP as an array.
MAP_VALUES	Returns all values in the parameter MAP as an array.
MAP_ZIP_WITH	Merges two input MAPs to create a new MAP.
MULTIMAP_ FROM_ENTRIES	Returns a MAP from a struct array.
SIZE	Returns the number of key-value pairs in the specified MAP.
TRANSFORM_KEYS	Transforms a MAP by keeping values unchanged while calculating new keys using a specified function.
TRANSFORM_VALUES	Transforms a MAP by keeping keys unchanged while calculating new values using a specified function.