Help Center> Data Lake Insight> SQL Syntax Reference (To Be Offline)> Flink Opensource SQL 1.10 Syntax Reference> Flink OpenSource SQL 1.10 Syntax
Updated on 2023-06-19 GMT+08:00
View PDF

Flink OpenSource SQL 1.10 Syntax

This section describes the Flink OpenSource SQL syntax supported by DLI. For details about the parameters and examples, see the syntax description.

Creating Tables

Table 1 Syntax for creating tables

Classification

Function

Creating a Source Table

Kafka Source Table

DIS Source Table

JDBC Source Table

GaussDB(DWS) Source Table

Redis Source Table

HBase Source Table

userDefined Source Table

Creating a Result Table

ClickHouse Result Table

Kafka Result Table

Upsert Kafka Result Table

DIS Result Table

JDBC Result Table

GaussDB(DWS) Result Table

Redis Result Table

SMN Result Table

HBase Result Table

Elasticsearch Result Table

User-defined Result Table

Creating a Dimension Table

JDBC Dimension Table

GaussDB(DWS) Dimension Table

HBase Dimension Table