MaxCompute Studio is a big data integrated development environment (IDE) tool that is provided by the Alibaba Cloud MaxCompute platform and installed on the developer’s client. It is a development plug-in based on the popular integrated development platform IntelliJ IDEA, helping users develop data conveniently. This article describes functional interfaces and common application scenarios of MaxCompute Studio.
Basic user interface
MaxCompute Studio is a plug-in on the IntelliJ IDEA platform, which shares basic development interfaces with IntelliJ IDEA. For more information about the IntelliJ IDEA interfaces, see the Interface operation guide.
- SQL Editor: Provides features such as SQL syntax highlighting, code complementing, real-time error prompting, local compilation, and job submission.
Compiler View: Displays locally compiled prompts and error messages, and locates the code in the editor.
- Project Explorer: Connects to a MaxCompute project, and browses table structures, custom functions, and resource files in the project.
Table Details View: Displays details and sample data of tables, views, and other resources.
- Job Explorer: Browses and searches for historical jobs of MaxCompute.
- Job Details View: Displays running details of a job, including the execution plan and details of each execution task.
- Job Output View: Displays output information of a running job.
- Job Result View: Displays the output result of the SELECT job.
- MaxCompute Console: Integrates the MaxCompute client, on which MaxCompute client commands can be input and executed.
Connect to MaxCompute project
Before using most features of MaxCompute Studio, you must Create a project connection. After the project connection is created, you can view related data structures and resource information in the Project Explorer. MaxCompute Studio automatically creates a local metadata backup task for each project to increase the access frequency to MaxCompute metadata and reduce the latency.
You can use the Project Explorer of MaxCompute Studio to quickly browse table structures, custom functions, and resource files in the project. The tree control can be used to list data tables, columns, partition columns, virtual views, custom functions, function signatures, and resource files and types of all project connections. It also supports fast locating.
You can double-click a data table to open the Table Details View and view metadata, structure, and sample data of the data table. If you do not have the permission for a project, an error message is prompted.
Write SQL scripts
You can easily compile a MaxCompute SQL script on MaxCompute Studio.
- Open MaxCompute Studio and select or .
- Create a MaxCompute Studio project or module.
Note When a MaxCompute SQL script is created, MaxCompute Studio prompts you to select an associated MaxCompute project. You can also modify the associated project using the project selector on the right of the toolbar on the SQL editor. The editor automatically checks metadata (such as the table structure) and reports errors of an SQL statement based on the project associated with the SQL script. The editor also sends the SQL statement to the associated project for execution when it submits the SQL statement for running. For more information, see Compile an SQL script.
or right-click the menu and select , to create a maxcompute SQL script file.
SQL code intelligent prompt
Compile and submit a job
- Compile a job
Click the icon on the toolbar of the SQL editor to locally compile an SQL script. If syntax or semantic errors occur, the editor reports it.
- Submit a job
Click the icon on the toolbar of the SQL editor to submit an SQL script to the queue of the project specified by MaxCompute.
View history jobs
Open Job Explorer to view recently executed jobs in the specified project.
| List only displays jobs submitted by the user ID of the current connection.
If you have the Log view URL of a job, you can selectfrom the menu to go to the details page of the job.
Develop a MapReduce program and UDF program
Connect to a MaxCompute client
MaxCompute Studio is integrated with the MaxCompute Client of the latest version. Alternatively, you can specify the path of the locally installed MaxCompute client on the Configuration page of MaxCompute Studio.
Now, you know the functional interfaces and common application scenarios of MaxCompute Studio. Continue to the next tutorial. In this tutorial, you will learn how to install MaxCompute Studio. For more information, see Install IntelliJ IDEA.