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.
Classification |
Reference |
---|---|
Database-related Syntax |
|
Syntax for Creating an OBS Table |
|
Syntax for Creating a DLI Table |
|
Syntax for Deleting a Table |
|
Syntax for Viewing a Table |
|
Syntax for Modifying a Table |
|
Syntax for Partitioning a Table |
|
Altering the Partition Location of a Table (Only OBS Tables Supported) |
|
Syntax for Importing Data |
|
Syntax for Inserting Data |
|
Syntax for Clearing Data |
|
Syntax for Exporting Query Results |
|
Syntax for Datasource Connection to an HBase Table |
|
Syntax for Datasource Connection to an OpenTSDB Table |
|
Syntax for Datasource Connection to a DWS Table |
|
Syntax for Datasource Connection to an RDS Table |
|
Syntax for Datasource Connection to a CSS Table |
|
Syntax for Datasource Connection to a DCS Table |
|
Syntax for Datasource Connection to a DDS Table |
|
View-related Syntax |
|
Syntax for Viewing the Execution Plan |
|
Syntax Related to Data Permissions |
|
Displaying the Binding Relationship Between All Roles and Users |
|
UDF-related Syntax |
|
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 |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot