Updated on 2023-12-21 GMT+08:00

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

Reference

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

Creating an OBS Table Using the Hive Syntax

Syntax for Creating a DLI Table

Creating a DLI Table Using the Datasource Syntax

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

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