SQL Syntax Overview of Batch Jobs

This section describes the Spark SQL syntax list provided by DLI. For details about the parameters and examples, see the syntax description.

**Table 1** SQL syntax of batch jobs
Classification	Function
Database-related Syntax	Creating a Database
	Deleting a Database
	Viewing a Specified Database
	Viewing All Databases
Syntax for Creating an OBS Table	Creating an OBS Table Using the Datasource Syntax
Syntax for Creating an OBS Table	Creating an OBS Table Using the Hive Syntax
Syntax for Creating a DLI Table	Creating a DLI Table Using the Datasource Syntax
Syntax for Creating a DLI Table	Creating a DLI Table Using the Hive Syntax
Syntax for Deleting a Table	Deleting a Table
Syntax for Viewing a Table	Viewing All Tables
	Viewing Table Creation Statements
	Viewing Table Properties
	Viewing All Columns in a Specified Table
	Viewing All Partitions in a Specified Table
	Viewing Table Statistics
Syntax for Modifying a Table	Adding a Column
Syntax for Partitioning a Table	Adding a Partition (Only OBS Tables Supported)
	Renaming a Partition
	Deleting a Partition
	Altering the Partition Location of a Table (Only OBS Tables Supported)
	Updating Partitioned Table Data (Only OBS Tables Supported)
Syntax for Importing Data	Importing Data
Syntax for Inserting Data	Inserting Data
Syntax for Clearing Data	Clearing Data
Syntax for Exporting Query Results	Exporting Query Result
Syntax for Datasource Connection to an HBase Table	Creating a Table and Associating It with HBase
	Inserting Data to an HBase Table
	Querying an HBase Table
Syntax for Datasource Connection to an OpenTSDB Table	Creating a Table and Associating It with OpenTSDB
	Inserting Data to an OpenTSDB Table
	Querying an OpenTSDB Table
Syntax for Datasource Connection to a DWS Table	Creating a Table and Associating It with DWS
	Inserting Data to a DWS Table
	Querying a DWS Table
Syntax for Datasource Connection to an RDS Table	Creating a Table and Associating It with RDS
	Inserting Data to an RDS Table
	Querying an RDS Table
Syntax for Datasource Connection to a CSS Table	Creating a Table and Associating It with CSS
	Inserting Data to a CSS Table
	Querying a CSS Table
Syntax for Datasource Connection to a DCS Table	Creating a Table and Associating It with DCS
	Inserting Data to a DCS Table
	Querying a DCS Table
Syntax for Datasource Connection to a DDS Table	Creating a Table and Associating It with DDS
	Inserting Data to a DDS Table
	Querying a DDS Table
View-related Syntax	Creating a View
View-related Syntax	Deleting a View
Syntax for Viewing the Execution Plan	Viewing the Execution Plan
Syntax Related to Data Permissions	Creating a Role
	Deleting a Role
	Binding a Role
	Unbinding a Role
	Displaying a Role
	Granting a Permission
	Revoking a Permission
	Displaying the Granted Permissions
	Displaying the Binding Relationship Between All Roles and Users
UDF-related Syntax	Creating a Function
	Deleting a Function
	Displaying Function Details
	Displaying All Functions
Multiversion-related Syntax	Enabling Multiversion Backup When Creating an OBS Table Enabling or Disabling Multiversion Backup When Modifying a Table Setting the Retention Period for Multiversion Backup Data Viewing Multiversion Backup Data Restoring Multiversion Backup Data Configuring the Trash Bin for Expired Multiversion Data Deleting Multiversion Backup Data