Help Center/ Data Lake Insight/ Spark SQL Syntax Reference/ Spark SQL Syntax
Updated on 2025-08-06 GMT+08:00
View PDF

Spark SQL Syntax

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

Checking a Specified Database

Checking 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 Checking a Table

Checking All Tables

Checking Table Creation Statements

Checking Table Properties

Checking All Columns in a Specified Table

Checking All Partitions in a Specified Table

Checking 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 GaussDB(DWS) Table

Creating a Table and Associating It with GaussDB(DWS)

Inserting Data to a GaussDB(DWS) Table

Querying a GaussDB(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 Checking the Execution Plan

Checking 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

Data Multi-Versioning-related Syntax (Deprecated, Not Recommended)

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

Checking Multiversion Backup Data

Restoring Multiversion Backup Data

Configuring the Trash Bin for Expired Multiversion Data

Deleting Multiversion Backup Data