[FLINK-14672] Make Executor stateful in sql client

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.10.0
• Component/s: Table SQL / Client
• Labels: pull-request-available
• Assignee: Zheng Hu
• Reporter: Kurt Young
• Created: 08/Nov/19 09:43
• Updated: 03/Dec/19 06:35
• Resolved: 03/Dec/19 01:31

Description

Currently sql client is stateless, it read config files into `Environment` and recorded all session changes into `SessionContext`. 

Each time sql client want to execute a new command, we have to first construct `ExecutionContext` by combining `Environment` and `SessionContext`, and then transfer all information into a new `EnvironmentInstance`. 

It works well before but kind of hard to extend now. One example is support creating table in sql client. We have to remember create statements and replay them every time we want to execute a new command. 

If we can make sql client stateful, and table environment be the state of sql client, things will be much more easier. 

This Jira should revisit all related classes, and define a clean relationship between old roles after making sql client stateful. 

 

Issue Links

• blocks: FLINK-13195 Add create table support for SqlClient
• duplicates: FLINK-12819 Reuse TableEnvironment between different SQL statements
• links to: GitHub Pull Request #10270