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 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 |