[FLINK-13521] Allow setting configuration in SQL CLI

• Type: Improvement
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 1.9.0
• Component/s: Table SQL / Client
• Labels: pull-request-available
• Assignee: Caizhi Weng
• Reporter: Jark Wu
• Created: 01/Aug/19 03:15
• Updated: 27/Apr/21 18:05
• Resolved: 07/Aug/19 16:34

Description

Currently, we provide a set of configurations in blink planner to support optimization or enable some advanced feature. However, all the configurations can't be set in SQL CLI.

It would be great to allow set configurations in SQL CLI via SET command.
This maybe a new feature, but considering the implementation effort is rather low (pass configurations to TableConfig), I would like to add it to 1.9 too, but I won't set it as blocker.

For example:

SET table.exec.mini-batch.enabled = true;
SET table.exec.mini-batch.allow-latency = 5s;

Meanwhile, we may also need to add an entry in yaml file, we propose to add a config entry. However, this might be different with other entries. Because we don't need the config. prefix in SET command.

config:
  table.exec.mini-batch.enabled: true
  table.exec.mini-batch.allow-latency: 5s

Issue Links

• links to: GitHub Pull Request #9328