Common SQL statements

This topic describes common SQL statements in MaxCompute.

MaxCompute allows you to perform operations on objects, such as projects, tables, resources, and instances. You can use tools or the MaxCompute SDK to perform operations on these objects.

Note

For more information about the MaxCompute SDK, see MaxCompute SDK.

Precautions

This topic describes common SQL statements in MaxCompute and lists the SQL statements by operation category. For more information about the SQL statements that are not provided in this topic, see the topics in the All statements (in alphabetical order) or Function Reference directory.

The following table describes common SQL statements in MaxCompute.

Operation category	Common statement
Project operations	Go to a project (use) View the properties of a project (setproject) Configure project properties (setproject) View the account systems 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 project data protection (ProjectProtection) Add a trusted project (add trustedproject) Remove a trusted project (remove trustedproject) View trusted projects (list trustedprojects) View the security configurations of a project (show SecurityConfiguration)
User and role operations	Add a user (add user) Remove a user (remove user) View users (list users) Create a role (create role) View roles (list roles) Grant a role to a user (grant) Revoke a user from a role (revoke) Delete a role (drop role)
Authorization operations	Grant a role or user (grant) Revoke role or user permissions (revoke)
Table operations	Create a table (create table) Change the owner of a table (alter table) Drop a table (drop table) View the information about tables or views (desc) View partition information (desc partition) Display tables and views in a project (show tables) Display partitions (show partitions)
Partition and column operations	Add partitions (alter table add) Drop partitions (alter table drop) Add columns or column comments (alter table add columns) Change the name and comment of a column (alter table change column)
Instance operations	View instance information (show) Query the instance status (status) View information about the running instances (top instance) Stop an instance (kill) Obtain job information about an instance (desc) Obtain the operational log of jobs in an instance (wait)
Resource operations	Add resources (add) View resource information View a resource list Create an alias for a resource (alias) Download resources (get) Delete resources (drop)
External volume operations	Create an external volume View the list of external volumes and the directory structure of an external volume Delete an external volume
Function operations	Create a UDF (create function) Delete a UDF (drop function) View the UDF list View all built-in functions
Tunnel operations	Upload data (Tunnel upload) Download data (Tunnel download)
Time zone configuration operations	Time zone configuration operations
Other operations	Cost estimation (cost sql)

Usage notes

Keywords, project names, table names, and column names in MaxCompute SQL statements are not case sensitive.