Flink DDL

Flink SQL supports Data Definition Language (DDL) statements to create, modify and remove objects within a data structure.

The following table summarizes the supported DDL statements in SQL Stream Builder:
DDL Description Option
CREATE TABLE Creating table for the SQL query. You can create tables based on the supported connectors.
  • Adding WATERMARK and PRIMARY KEY information
  • Creating table with LIKE clause
CREATE VIEW Creating custom views using columns from tables. There is no physical data behind a view.
  • Adding queries, expressions and joins
CREATE FUNCTION Creating User Defined Function (UDF) for a query.
  • Using Javascript or Java language
  • Using Functions tab on Streaming SQL Console
DROP TABLE Deleting a table, view or function.
  • Using Streaming SQL Console functionality to delete table, view or function
DROP VIEW
DROP FUNCTIONS
ALTER TABLE Modifying table, view or function properties.
  • Using RENAME TO or SET for table
  • Using RENAME TO or AS for view and function
ALTER VIEW
ALTER FUNCTION