Spark SQL Syntax Reference

Common Configuration Items of Batch SQL Jobs

SQL Syntax Overview for Batch Jobs

Spark Open Source Commands

Databases

Creating an OBS Table

Creating a DLI Table

Deleting a Table

Checking Tables

Modifying a Table

Syntax for Partitioning a Table

Importing Data to the Table

Inserting Data

Reusing Results of Subqueries

Clearing Data

Exporting Search Results

Table Lifecycle Management

Creating a Datasource Connection with an HBase Table

Creating a Datasource Connection with an OpenTSDB Table

Creating a Datasource Connection with a DWS table

Creating a Datasource Connection with an RDS Table

Creating a Datasource Connection with a CSS Table

Creating a Datasource Connection with a DCS Table

Creating a Datasource Connection with a DDS Table

Creating a Datasource Connection with an Oracle Table

Views

Checking the Execution Plan

Data Permissions Management

Data Types

User-Defined Functions

Built-in Functions

Basic SELECT Statements

Filtering

Sorting

Grouping

JOIN

Subquery

Alias

Set Operations

WITH...AS

CASE...WHEN

OVER Clause