You can use tools such as the MaxCompute console, MaxCompute client, MaxCompute Studio, and DataWorks to process data. This topic describes how to use the MaxCompute console to run SQL queries on a public dataset provided by MaxCompute and download the query results to your computer.
Before you begin
-
You have permissions for a MaxCompute project.
-
To get started quickly, use an Alibaba Cloud account to skip the authorization steps.
-
If you are a RAM user and do not have permissions to operate the project, contact the project administrator to grant permissions.
-
-
This tutorial uses a public dataset provided by MaxCompute. This dataset is for testing purposes only. The data is not updated periodically, and its accuracy is not guaranteed. Do not use this dataset in a production environment.
Procedure
Running all queries in the sample file one time is expected to cost CNY 10. If you run the queries multiple times and exceed your free quota, you will be charged for any excess usage on a pay-as-you-go basis.
-
Log in to the MaxCompute console and select a region in the upper-left corner.
-
Create a MaxCompute project. You can skip this step if you already have a project.
-
In the left-side navigation pane, 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. The project where the SQL statement is run.
-
computing quota: Optional. You can use the default computing quota of the project or specify a different one.
-
-
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. The project where the SQL statement is run.
-
quota: Optional. You can use the project's default quota or specify a different one.
-
-
Click Run and wait for the query to complete. In the execution results, you can click the
icon to perform a simple visual analysis.
-
Next steps
For more information about using MaxCompute, see Next steps.