All Products
Search

This Product

    MaxCompute:TRANSFORM_VALUES

    Document Center

    MaxCompute:TRANSFORM_VALUES

    Last Updated:Sep 06, 2023

    Transforms the values in Map input by using func. The keys in the map are not changed.

    Syntax

    map<K, V2> transform_values(map<K, V1> <input>, function<K, V1, V2> <func>)

    Parameters

    • input: required. This parameter specifies a map. K and V1 in map<K, V1> specify the keys and values of the map.

    • func: required. This parameter specifies the built-in function, user-defined function, or expression that is used to transform the values. The function or expression consists of two input parameters that correspond to the keys and values in input. V2 specifies the data type of values in the returned map.

    Return value

    Data of the MAP type is returned.

    Examples

    -- The return value is {-30:71, 10:-10, 20:null}. 
select transform_values(map(10, -20, 20, null, -30, 101), (k, v) -> k + v);
    Note

    In this example, the combination of a hyphen and a closing angle bracket (->) is used. For more information about how to use the combination of a hyphen and a closing angle bracket(->) in Lambda functions, see Lambda functions.

    Related functions

    TRANSFORM_VALUES is a complex type function. For more information about the functions that are used to process data of complex data types, such as ARRAY, MAP, STRUCT, and JSON, see Complex type functions.