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

Parent topic: Flink Opensource SQL 1.10 Syntax Reference

Previous topic: Data Manipulation Language (DML)

Next topic: Data Definition Language (DDL)

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.