MaxCompute:Configure MaxCompute Studio - MaxCompute

After installing MaxCompute Studio, open the Settings dialog box in IntelliJ IDEA by choosing File > Settings... from the main menu bar. Click MaxCompute Studio in the left-side navigation pane to access the configuration sections described below.

MaxCompute Studio settings

The following settings appear when you click MaxCompute Studio in the left-side navigation pane.

General settings

Setting	Description	Default
Local meta store location	Local path for storing MaxCompute project metadata.	`.odps.studio\meta`
Table preview rows	Maximum number of rows shown when previewing a table.	—
Local directory for jobs	Local path for storing MaxCompute Studio job data. If you keep the default, make sure the path `.odps.studio\job` exists and MaxCompute Studio has write permissions on it — otherwise an error occurs when you confirm the configuration.	`.odps.studio\job`
Python path to resolve UDF	Local installation path of Python, used for resolving user-defined functions (UDFs).	—

Updates checking

Setting	Description	Default
Automatically checks for new version	Enables MaxCompute Studio to check for updates on startup. Disable this only if you manage plugin versions manually.	Selected
Check new versions	Click this button to check for updates immediately. If a newer version is available, an Install latest version button appears. After installation, restart IntelliJ IDEA to apply the update.	—

SDK & Console settings

In the Settings dialog box, choose MaxCompute Studio > SDK & Console in the left-side navigation pane.

Setting	Description	Default
Installed Location	Local installation path of the MaxCompute client. MaxCompute Studio auto-detects the client version at this path. If no client is found, an error message is returned. Leave this blank if the version of MaxCompute Studio is later than V2.6.1 — the latest MaxCompute client is installed automatically. Specify a path only if you need a particular client version.	—

MaxCompute SQL settings

In the Settings dialog box, choose MaxCompute Studio > MaxCompute SQL in the left-side navigation pane.

Color and annotator

Setting	Description	Default
Enable syntax coloring	Enables syntax highlighting in the SQL editor.	—

Code completion

Setting	Description	Default
Enable code completion	Enables automatic code completion as you type.	—
Invoke code completion when you enter a space	When selected, pressing Space disables automatic code completion at that position.	—

Code formatting

Setting	Description	Default
Enable code formatting	Enables automatic code formatting.	—
Enable code folding	Enables code folding in the SQL editor.	—

Script submit

Setting	Description	Default
Show job detail when script submitted	Displays job details each time you submit a script.	—
Record sql history when script submitted	Records the execution history of SQL statements when you submit a script.	—
Show sql cost confirm dialog when script submitted	Prompts you to confirm the execution cost before the script runs.	—
Pin sql execution result tab by default	Keeps the SQL Execution Result tab locked by default.	—
Ignore local compile error when submit script	Skips local compilation errors when submitting a script. Optional.	—
Use tunnel to download query acceleration result	Uses Tunnel to download query acceleration results. Optional.	—

Job Name controls how jobs are named at submission time:

Option	Behavior
use script file name as default	Uses the script file name as the job name.
input job name when first submit	Prompts for a job name the first time you submit a job.
input job name for every submit	Prompts for a job name every time you submit a job.

Compile | Submit

These are global compiler defaults. Override them per file in the SQL compiler toolbar.

Compiler mode determines the unit of compilation and submission:

Mode	Behavior
Statement Mode	Compiles and submits each SQL statement individually.
Script Mode	Compiles and submits the entire SQL file as a single unit. Allows the compiler and optimizer to optimize the execution plan, improving overall execution efficiency.

Data type edition sets the type system used:

Edition	Description
Legacy TypeSystem	Uses the MaxCompute V1.0 data type edition.
MaxCompute TypeSystem	Uses the MaxCompute V2.0 data type edition.
Hive Compatible TypeSystem	Uses the Hive-compatible data type edition based on MaxCompute V2.0.

Compiler sets the query execution strategy:

Option	Behavior
Default	Uses the default MaxCompute Studio compiler.
UseShortQueryAcceleration	Uses the query acceleration compiler.
FallbackWhenFailed	Uses the compiler that reruns jobs if query acceleration fails.

MaxCompute Job settings

In the Settings dialog box, choose MaxCompute Studio > MaxCompute Job in the left-side navigation pane.

Setting	Description	Default
Maximum jobs shown in job explorer table list	Maximum number of jobs displayed on the Job Explorer page.	1,000
Reset filter when switch MaxCompute project	Resets job filters automatically when you switch between MaxCompute projects.	—
Cache history instance in local database	Caches historical instance information in the local database for faster access.	—

Accounts settings

In the Settings dialog box, choose MaxCompute Studio > Accounts in the left-side navigation pane.

MaxCompute Studio uses the accounts configured here to access MaxCompute projects and run jobs. Currently, the supported authentication method is Aliyun Account By AccessKey, which works for both Alibaba Cloud accounts and RAM users. For background on authentication, see User authentication.

Add an account

In the right-side navigation pane, choose + > Aliyun Account By AccessKey.

In the Add MaxCompute Account dialog box, configure the following:

Parameter	Description
Account Name	Display name for the account in MaxCompute Studio. For an Alibaba Cloud account such as `user_**@test.aliyun.com`, enter `user_test`. For a RAM user such as `user_ram@xxxxx.onaliyun.com` that belongs to `user_@test.aliyun.com`, enter `user_**:user_ram`.
Using properties file	Reads the AccessKey ID and AccessKey secret from the `odps_config.ini` configuration file (used when odpscmd or MaxCompute Studio is already configured). Make sure the `odps_config.ini` file is available before selecting this option.
Using properties	Manually enter the AccessKey ID and AccessKey secret. Select either this option or Using properties file.
Access Id	The AccessKey ID of the Alibaba Cloud account or RAM user.
Access Key	The AccessKey secret of the Alibaba Cloud account or RAM user.

Click OK. The account appears in the account list.

Remove an account

Removing an account from MaxCompute Studio does not affect the underlying Alibaba Cloud account or RAM user.

Select the account in the account list.
Click - in the right-side navigation pane.
Click OK to confirm.

Modify account credentials

Select the account in the account list.
Click the icon in the right-side navigation pane.
In the Edit MaxCompute Account dialog box, update the following:
Parameter Description
Access Id Enter the new AccessKey ID.
Access Key Enter the new AccessKey secret.
Click OK.

Parameter	Description
Access Id	Enter the new AccessKey ID.
Access Key	Enter the new AccessKey secret.