You can process data in MaxCompute using the MaxCompute console, MaxCompute client, MaxCompute Studio, and DataWorks. This topic describes how to use the MaxCompute console to run SQL statements on a public dataset provided by MaxCompute and download the query results to your local machine.
Scope
You have the required permissions for a MaxCompute project.
For a quick start, you can use an Alibaba Cloud account to skip the authorization step.
If a Resource Access Management (RAM) user does not have project permissions, you must contact the MaxCompute project administrator to grant permissions.
This example uses a public dataset provided by MaxCompute. The data in the public dataset is for product testing only. The data is not periodically updated, and its accuracy is not guaranteed. Do not use this data in a production environment.
Procedure
Running all queries in the sample file once costs about CNY 10. If you run the queries multiple times and exceed your free quota, you are charged for the excess usage on a pay-as-you-go basis.
Log on to the MaxCompute console and select a region in the top-left corner.
Create a MaxCompute project. If you already have a project, you can skip this step.
In the navigation pane on the left, choose .
Use the classic SQL Analysis
On the left side of the page, click the EXPLORER icon
and select a sample file from the COMMONDATASET DEMO.On the right, click Run Configurations. Configure Project and Computing Quota.
Project: Required. Specifies the project in which the SQL statement is executed.
Computing Quota: Optional. You can use the default computing quota that is configured for the project or specify an execution quota as needed.
Click Run and wait for the query to complete. In the execution results, you can click the
icon to perform a simple visual analysis.
Use the new SQL Analysis
Click the EXPLORER icon
in the left navigation pane, and select a sample file from COMMONDATASET DEMO.Click Run Configurations on the right and configure Project and Quota.
Project: Required. Specify the project in which to execute the SQL statement.
Computing Quota: Optional. You can use the default computing quota configured for the project or specify an execution quota as needed.
Click Run and wait for the query to complete. In the execution results, you can click the
icon to perform a simple visual analysis.
What to do next
For more information about how to use MaxCompute, see Next steps.