This article describes how to use the basic functions of the MaxCompute using client command line tool.
For more information about basic commands of the client, see Basic commands.
- Do not perform the analysis operation based on the output format of the client. The output format of the client is not ensured for forward compatibility. Clients of different versions are different in their command formats and behaviors.
- The client supports JDK 1.9 from the 0.28.0 version, and the previous version can only use JDK 1.8.
- The client supports MaxCompute 2.0 from the 0.27.0 version New data type.
After the client is installed and configured, you can use a command line to perform the following operations.
To view the help information of the console, the command format is as follows:
You can also input
help;(case-insensitive) in an interactive mode.
The console also provides the
help [keyword]; command to get the command prompts related to the keyword. For example, input
help table; to get command prompts related to the table operation as follows:
odps @ odps> help table; Usage: alter table merge smallfiles Usage: show tables [in] a list of tables | ls [-p,-project] Usage: describe deserves mention | [.] [partition ()] Usage: read [.] [partition ()] [line_num]
When start the console, you can specify a series of parameters as follows:
Usage: odpscmd [option]... where options include: --help (-h) for help --project= use project --endpoint= set endpoint -u-p user name and password -k will skip begining queries and start from specified position -r set retry times -f <"file_path;"> execute command in file -e <"command; [command;]..."> execute command, include sql command -C will display job counters
Take the -f parameter as an example, the operation is as follows:
Prepare the local script file script.txt. Suppose that the file is located in the disk D, and the content is shown as follows:
DROP TABLE IF EXISTS test_table_mj; CREATE TABLE test_table_mj (id string, name string); DROP TABLE test_table_mj;
Run the following command:
odpscmd\bin>odpscmd -f D:/script.txt;
Run the console to directly enter the interactive mode:
[admin: ~]$odpscmd Aliyun ODPS Command Line Tool Version 1.0 @Copyright 2012 Alibaba Cloud Computing Co., Ltd. All rights reserved. odps@ odps> INSERT OVERWRITE TABLE DUAL SELECT * FROM DUAL;
Enter the command at the cursor position (use a semicolon as a statement terminator), and press Enter to run.
- When using -e or -f option to run a command, if there are multiple statements, and you want to start running from a middle statement, you can specify the parameter -k, indicating to ignore the previous statements and to start running from the specified position. When the parameter <= 0 is specified, the execution starts from the first statement.
- Each statement separated by a semicolon is considered as a valid statement. The statements which run successfully or fail to run are printed out at runtime.
suppose there are three SQL statements in the file /tmp/dual.sql:
drop table dual; create table dual (dummy string); insert overwrite table dual select count(*) from dual;
To ignore the first two statements, and start running from the third statement, the command format is as follows:
odpscmd -k 3 -f dual.sql
Get current logon user
To get current logon user, the command format is as follows:
odps@ hiveut>whoami; Name: firstname.lastname@example.org End_Point: http://service.cn-shanghai.maxcompute.aliyun.com/api Project: lijunsecuritytest
Use the preceding command to get the current logon user Alibaba Cloud account, endpoint configuration, and project name.
To exit the console, the command format is as follows:
odps@ > quit;
You can also use the following command to exit the console:
odps@ > q;