MaxCompute:Frequently used commands

Category

Common commands

Project operations

• Enter a project (use)

• View project properties (setproject)

• Set project properties (setproject)

• View the account system of a project (list accountproviders)

• Add the RAM account system (add)

• Remove the RAM account system (remove)

set operations

• set

• show flags

Security Operations

• Enable data protection for a project (ProjectProtection)

• Add a trusted project (add trustedproject)

• Remove a trusted project (remove trustedproject)

• View trusted projects (list trustedprojects)

• View the secure configuration of a project (show SecurityConfiguration)

User and role operations

• Add a user (add user)

• Remove a user (remove user)

• View the user list (list users)

• Create a role (create role)

• View the role list (list roles)

• Grant a role to a user (grant)

• Remove a user from a role (revoke)

• Delete a role (drop role)

Authorization operations

• Grant permissions to a role or user (grant)

• Revoke permissions from a role or user (revoke)

Table operations

• Create a table (create table)

• Change the owner of a table (alter table)

• Delete a table (drop table)

• View information about a table or view (desc)

• View partition information (desc partition)

• List tables in a project (show tables)

• List all partitions (show partitions)

Instance operations

• View instance information (show)

• View instance status (status)

• View information about running instances (top instance)

• Stop an instance (kill)

• Obtain job information for an instance (desc)

• Obtain operational log information for the job of an instance (wait)

Resource operations

• Add a resource (add)

• View resource information

• View the resource list (list)

• Create an alias for a resource (alias)

• Download a resource (get)

• Delete a resource (drop)

External Volume operations

• Create an external volume

• View the external volume list and folder structure

• Delete an external volume

Function operations

• Register a function (create function)

• Unregister a function (drop function)

• View the list of user-defined functions

• View the list of built-in functions

Tunnel operations

• Upload data (Tunnel upload)

• Download data (Tunnel download)

Time zone configuration operations

Time zone configuration operations

Other operations

Estimate costs (cost sql)