[FLINK-7594] Add a SQL client

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Component/s: Table SQL / Client
• Assignee: Timo Walther
• Reporter: Timo Walther
• Created: 06/Sep/17 12:13
• Updated: 29/Apr/21 10:15
• Resolved: 29/Apr/21 10:15

Description

At the moment a user can only specify queries within a Java/Scala program which is nice for integrating table programs or parts of it with DataSet or DataStream API. With more connectors coming up, it is time to also provide a programming-free SQL client. The SQL client should consist of a CLI interface and maybe also a REST API. The concrete design is still up for discussion.

Issue Links

• is a parent of: FLINK-13734 Support DDL in SQL CLI
• mentioned in: Page Loading...

Sub-Tasks

• Add a basic embedded SQL CLI client: Resolved
• Improve basic embedded SQL client: Closed
• SQL Client does not support Event-time: Resolved
• SQL Client does not work with new FLIP-6 mode: Resolved
• SQL Client cannot emit query results that contain a rowtime attribute: Closed
• Add support for batch queries in SQL Client: Resolved
• Add user-defined function support in SQL Client: Resolved
• Add CLI query history in SQL Client: Closed
• Add CLI query code completion in SQL Client: Resolved
• Add support for INSERT INTO in SQL Client: Resolved
• Validate configurations for SQL Client: Resolved
• Escape control characters when outputting on SQL Client CLI: Closed
• Add SQL Client documentation page: Resolved
• Changing refresh interval in changelog mode leads to exception: Resolved
• Add a REST-based SQL Client Gateway: Closed
• Add documentation for UDF in SQL Client: Resolved
• Allow passing multi-line input to SQL Client CLI: Closed
• Document usage of INSERT INTO in SQL Client: Resolved
• Support a traditional and scrolling view of result (non-interactive): Closed
• Reuse TableEnvironment between different SQL statements: Closed
• Execute multiple statements in command line or sql script file: Closed
• Support -q option with a sql query statement as input: Closed
• Refactor the SQL CLI parser to reuse flink-sql-parser: Closed
• Support database DDLs in SQL CLI: Closed
• Support alter table DDLs in SQL CLI: Closed
• Add create table support for SqlClient: Closed
• Add doc to introduce ddls or dmls supported by sql cli: Closed