Skip to main content

SQL

SQL

Flink SQL is an ANSI standard compliant SQL engine that can process both real-time and historical data.

This page describes the SQL language supported in Flink, including Data Definition Language (DDL), Data Manipulation Language (DML) and Query Language. Flink’s SQL support is based on Apache Calcite which implements the SQL standard.

This page lists all the supported statements supported in Flink SQL for now:

  • SELECT (Queries)
  • CREATE TABLE, CATALOG, DATABASE, VIEW, FUNCTION
  • DROP TABLE, DATABASE, VIEW, FUNCTION
  • ALTER TABLE, DATABASE, FUNCTION
  • ANALYZE TABLE
  • INSERT
  • UPDATE
  • DELETE
  • DESCRIBE
  • EXPLAIN
  • USE
  • SHOW
  • LOAD
  • UNLOAD