Client

Get Help

To view the help information of the console, the command format is as follows:

odps @>./bin/odpscmd-h;

You can also input h; or 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]

Start parameters

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:

1. 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;

2. Run the following command:

   odpscmd\bin>odpscmd -f ./script.sql;

Interactive mode

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.

Continuous running

• 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.

For example, 

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:

whoami;

Use example:

odps@ hiveut>whoami;
Name: odpstest@aliyun.com
End_Point: http://service.odps.aliyun.com/api
Project: lijunsecuritytest

Use the preceding command to get the current logon user Alibaba Cloud account, endpoint configuration, and project name.

Exit

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;