MaxCompute allows you to set system variables for sessions. This topic describes how to set and view the system variables, which can affect MaxCompute operations.

The following table describes the statements that are used for SET operations.
Operation Description Role Operation platform
set Sets MaxCompute system variables for the current session. Users who have operation permissions on projects You can execute the statements that are described in this topic on the following platforms:
show flags Displays the properties that you configured by using the SET statement.

set

You can execute the SET statement to set MaxCompute system variables for the current session. MaxCompute also allows you to set properties for projects. For more information, see Set project properties.

  • Syntax
    set <KEY>=<VALUE>
  • Parameters
    • KEY: the name of the property.
    • VALUE: the value of the property.
  • Example
    -- Set the size of data read by each Mapper to 256 MB. 
    set odps.stage.mapper.split.size=256;

show flags

The SHOW FLAGS statement displays the properties that you configured by using the SET statement. Syntax:
show flags;