MaxCompute:What is MaxCompute Studio?

Basic user interfaces

MaxCompute Studio is a set of plug-ins based on the IntelliJ IDEA platform and uses the basic user interfaces of IntelliJ IDEA. For more information about the basic user interfaces of IntelliJ IDEA, see Guided Tour around the User Interface.

Connect to a MaxCompute project

To use most of the features of MaxCompute Studio, you must connect MaxCompute Studio to a MaxCompute project. After you establish the connection, you can use MaxCompute Studio to perform operations, such as editing SQL scripts, submitting jobs, viewing job information, and logging on to the MaxCompute console. MaxCompute Studio creates a local copy of the metadata for each project to increase the frequency of metadata access and reduce the access latency. For more information about how to connect MaxCompute Studio to a MaxCompute project, see Manage project connections.

Manage data

You can use Project Explorer of MaxCompute Studio to browse table schemas or views, UDFs, and resource files in projects. You can use the tree view hierarchy to display tables, columns, partition key columns, virtual views, UDFs, function signatures, resource files, and types of resource files for all project connections. You can also use the tree view hierarchy to locate an object.

You can double-click a table to go to Table Details View and view the metadata, schema, and sample data of the table. If you do not have the required permissions on the connected project, MaxCompute Studio displays an error message.

MaxCompute Studio is integrated with MaxCompute Tunnel to allow you to upload and download local data. For more information, see Tunnel commands and Import and export data by using Tunnel in MaxCompute Studio.

Write SQL scripts

You can write MaxCompute SQL scripts in SQL Editor that is provided by MaxCompute Studio.

• Create a project or module.
  1. In the main menu bar of IntelliJ IDEA, choose File > New.
  2. In the navigation pane that appears, click Project... or Module….
  3. In the New Project or New Module dialog box, select MaxCompute Studio and click Next.
  4. Enter a project name or module name and click Finish.
• Create a MaxCompute SQL script file.
  1. In the main menu bar of IntelliJ IDEA, choose File > New.
     Note You can also right-click the project or module that you created to create a MaxCompute SQL script.
  2. In the navigation pane that appears, select MaxCompute SQL Script.
  3. In the New MaxCompute SQL Script dialog box, enter a script name in the Script Name field and click OK.
  Note When you create a MaxCompute SQL script, MaxCompute Studio prompts you to select a MaxCompute project with which you want to associate the script. You can also use Project Selector on the right side of the toolbar of SQL Editor to change the associated project. SQL Editor automatically checks metadata such as table schemas in SQL statements based on the project that is associated with the SQL script and reports errors in the script. When you commit and execute an SQL statement, SQL Editor sends the SQL statement to the associated project for execution. For more information, see Write SQL scripts.

Check and complete code in SQL scripts

• Syntax verification
  SQL Editor of MaxCompute Studio checks the code that you write and reports syntax errors, type mismatch errors, or alerts of SQL statements in the code, and marks these code errors and alerts in real time.
• Intelligent code completion
  MaxCompute Studio provides the intelligent code completion feature. This feature allows MaxCompute Studio to display the project name, table, field, function, type, and code keywords based on context, and completes code based on your selections.

Manage jobs

• Display job status
  • Active jobs
    • waiting: Jobs are waiting to enter the queue after they are submitted.
    • pending: Jobs are in the queue and waiting for resource allocation.
    • running: Jobs are running.
  • Historical jobs
    • success: Jobs run successfully.
    • failed: Jobs fail to run.
    • cancelled: Jobs are canceled.
• Compile a job
  Click the icon in the toolbar of SQL Editor to compile an SQL script on your on-premises machine. If a syntax or semantic error occurs, SQL Editor reports the error.
• Submit a job

  Click the icon in the toolbar of the SQL Editor to submit a compiled SQL script to the specified MaxCompute project for execution.

• View jobs

  On the Job Explorer page, view the recent jobs that are run in a specific MaxCompute project.

• View job details

  Double-click a job in the job list to view the details of the job. You can also click the icon to view the job details in a web browser by using Logview. For more information about how to use Logview, see Use Logview to view job information.

Develop MapReduce programs and UDFs

MaxCompute Studio allows you to develop MapReduce programs, Java UDFs, and Python UDFs. For more information, see Develop a MapReduce program, Develop a UDF, and Develop a Python UDF.

Connect to the MaxCompute client

MaxCompute Studio is integrated with the latest version of the MaxCompute client. You can also specify the path of the MaxCompute client that is installed on your on-premises machine on the configuration page of MaxCompute Studio. For more information, see Configure MaxCompute Studio.

In the Project Explorer tool window, right-click a project and select Open in Console. The MaxCompute Console window appears.

What to do next

For more information about how to install MaxCompute Studio, see MaxCompute Studio installation and version information.