Use SET operations to configure and inspect system variables for the current MaxCompute session. Session-level variables apply only to the current session. To configure properties at the project level instead, see Configure project properties.
The following statements are available:
| Statement | Description | Required role |
|---|---|---|
| SET | Configures system variables for the current session | Users who have operation permissions on projects |
| SHOW FLAGS | Displays the properties that you configured by using the SET statement | — |
Run these statements on any of the following platforms:
SET
Sets a system variable for the current session.
Syntax
SET <KEY>=<VALUE>Parameters
| Parameter | Description |
|---|---|
KEY |
The name of the property. For available flag names and their accepted values, see Flag parameters. |
VALUE |
The value to assign to the property. |
Example
-- Set the size of data read by each Mapper to 256 MB.
SET odps.stage.mapper.split.size=256;
-- Disable Query Acceleration (MCQA) in SQL statements.
SET odps.mcqa.disable=true;
-- Set the upper limit of CU usage for a single MaxCompute job.
SET odps.task.max.concurrent.cu=<CU amount>;
-- Limit the maximum running duration of a job to 72 hours.
SET odps.sql.job.max.time.hours=72;
-- Turn off ODPS Service Mode (Online mode). Online mode is enabled by default. This is a job-level parameter and cannot be configured at the project level.
SET odps.service.mode=off;SHOW FLAGS
Displays the properties that you configured by using the SET statement.
Syntax
SHOW flags;