This topic describes how to configure MaxCompute Studio and the configuration items.

After MaxCompute Studio is installed, choose File > Settings... in the top navigation bar to go to the MaxCompute Studio configuration page.

MaxCompute Studio configuration page

On the Settings page, click MaxCompute Studio in the left-side navigation pane to go to the MaxCompute Studio configuration page. The MaxCompute Studio configuration page provides the following configuration items:
  • General Settings
    • Local meta store location: specifies the path for storing the local metadatabase. This parameter specifies the path for locally storing metadata of a MaxCompute project. On MaxCompute Studio, the metadata is stored in the hidden directory .odps.studio\meta of the local user directory by default.
    • Table preview rows: specifies the maximum number of preview rows in a table.
    • Local directory for jobs: specifies the local path for saving MaxCompute Studio jobs.
    • Python path to resolve UDF: specifies the local installation path for Python.
  • Updates Checking
    • Automatically checks for new version: You can select this parameter to automatically check for an available new version. By default, this parameter is selected, and automatic update is supported.
    • Check new versions: You can click this button to manually check for an available new version. After you click this button, the Install new version button is displayed if a new version is available. You can click the Install new version button to install the new version. You must restart IntelliJ IDEA after the new version is installed.

SDK & Console configuration page

On the Settings page, choose MaxCompute Studio > SDK & Console in the left-side navigation pane to go to the SDK & Console configuration page.

The SDK & Console configuration page provides the Installed Location configuration item that specifies the path for locally installing the MaxCompute client. MaxCompute Studio detects the version of the MaxCompute client installed in the path. If the detection fails, an error message is returned.
Note MaxCompute Studio later than version 2.6.1 provides the latest MaxCompute client. If you need to use the MaxCompute client of a specific version, you can specify the path.

MaxCompute SQL configuration page

On the Settings page, choose MaxCompute Studio > MaxCompute SQL in the left-side navigation pane to go to the MaxCompute SQL configuration page.

The MaxCompute SQL configuration page provides the following configuration items:
  • Color and Annotator

    Select Enable syntax coloring to enable the syntax highlighting feature.

  • Code Completion
    • Select Enable code completion to enable the automatic code completion feature.
    • Select Invoke code completion when you enter a space to disable the automatic code completion feature when you enter a space.
  • Code Formatting

    Select Enable code formatting to enable the code formatting feature.

  • Script Submit
    • If you select Show job detail when script submitted, the job details are displayed when you submit a script.
    • If you select Record sql history when script submitted, the execution history of SQL statements is recorded when you submit a script.
    • If you select Show sql cost confirm dialog when script submitted, a message for confirming the execution cost of SQL statements appears when you submit a script.
    • If you select Pin sql execution result tab by default, the SQL Execution Result tab is locked by default.
    • Job Name:
      • use script file name as default: If you select this parameter, the name of the script file is used as the job name by default.
      • input job name when first submit: If you select this parameter, you must enter a job name when you submit a job for the first time.
      • input job name for every submit: If you select this parameter, you must enter a job name each time when you submit a job.
  • Compile | Submit
    These are global default compiler parameters. You can separately set the following parameters for each file in the toolbar of the SQL compiler:
    • Compiler Mode
      • Statement Mode: In this mode, the compiler compiles and submits a single statement of an SQL file as a unit.
      • Script Mode: In this mode, the compiler compiles and submits an entire SQL file as a unit. This mode enables the compiler and optimizer to optimize the execution plan and improve the overall execution efficiency.
    • Type System
      • Legacy TypeSystem: indicates the legacy type system of MaxCompute.
      • MaxCompute Typesystem: indicates the new type system introduced by MaxCompute V2.0.
      • Hive Compatible TypeSystem: indicates the type system in the Hive compatibility mode introduced by MaxCompute V2.0.
    • Compiler Version
      • Default Version: indicates the default version of the compiler.
      • Flighting Version: indicates the experimental version of the compiler, which includes new features of the compiler being tested.

Accounts configuration page

On the Settings page, choose MaxCompute Studio > Accounts in the left-side navigation pane to go to the Accounts configuration page.

You can add or manage accounts used to access MaxCompute on the Accounts configuration page. For more information, see User authentication.
Note You must specify an account on MaxCompute Studio to access a MaxCompute project and run or submit jobs. MaxCompute Studio allows you to use the AccessKey pair of your Alibaba Cloud account.
  • Add an account
    1. In the right-side navigation pane, click +. Then, select the account type Aliyun Account By AccessKey.
    2. In the Add MaxCompute Account window, set the following parameters:
      • Account Name: specifies the name of the account on MaxCompute Studio.
      • Using properties file: Read the AccessKey ID and AccessKey secret from the configuration file. If you select this parameter, you must upload the conf/odps_config.ini file that you use during user authentication.
      • Using properties: Enter the AccessKey ID and AccessKey secret. Select between this parameter and Using properties file.
        • Access Id: Enter the AccessKey ID of your Alibaba Cloud account.
        • Access Key: Enter the AccessKey secret of your Alibaba Cloud account.
    3. Click OK. Then, the added account is displayed in the account list on the Accounts configuration page.
  • Delete an account
    This operation only deletes the account configuration on MaxCompute Studio, but does not affect your account. To delete an account, perform the following steps:
    1. Select the account that you want to delete from the account list.
    2. In the right-side navigation pane, click -.
    3. In the dialog box that appears, click OK.
  • Modify the AccessKey pair of an account
    1. Select the account that you want to modify from the account list.
    2. In the left-side navigation pane, click the Edit icon.
    3. In the Edit MaxCompute Account window, edit the following account information:
      • Access Id: Enter the AccessKey ID of your Alibaba Cloud account.
      • Access Key: Enter the AccessKey secret of your Alibaba Cloud account.
    4. Click OK.