MaxCompute console is also called odpscmd MaxCompute CLI tool.
- We recommend that you use the MaxCompute Studio tool. This tool integrates with the Java environment and allows MaxCompute SQL script development and execution, data management, visual log analysis, and Java (UDF, MR) development. For more information. see What is Studio.
- You can also use MaxCompute through DataWorks. After creating a project in the console, you can click on Enter Workspace of the specified project in the project list to operate projects with MaxCompute. For more information, see DataWorks.
Install the console
Note Make sure you have JRE 1.7 or a later version installed to properly use the MaxCompute console.
Configure the Console
A file called odps_config.ini is in the conf folder. Edit it by filling in corresponding information to configure the console:
access_id=******************* access_key=********************* #Your AccessKeyId and AccessKeySecret. You can apply for an AccessKey through the official Alibaba Cloud console. project_name=my_project # Specify the project you want to use. end_point=https://service.odps.aliyun.com/api # Access URL of the MaxCompute service. tunnel_endpoint=https://dt.odps.aliyun.com # Access URL of the MaxCompute Tunnel service. log_view_host=http://logview.odps.aliyun.com # After a user executes a task, the console returns the LogView address of this task. You can view the detailed execution information of this task at this address. https_check=true # Determine whether to enable HTTPS access.
- We recommend that you configure the console according to the region you designated the MaxCompute service.
- # is used as a comment symbol in the dps_config.ini file. However, the MaxCompute console uses two minus signs -- as a comment symbol.
- Creating a project in advance is needed so that you can specify in the configuration file. For more information, see Project.
- MaxCompute provides two service addresses separately on the Internet and the intranet. Different addresses correspond to different download prices.For more information. see Access Domains and Data Centers.
Run the console
After the configuration file has been modified, run MaxCompute in bin directory(For Linux, run ./bin/odpscmd, for Windows, run ./bin/odpscmd.bat). For example:
create table tbl1(id bigint); insert overwrite table tbl1 select count(*) from tbl1; select 'welcome to MaxCompute!' from tbl1;
For more information about SQL statements, see SQL Summary.