[FLINK-17377] Support variable substitution in Flink SQL

• Type: New Feature
• Status: Open
• Priority: Not a Priority
• Resolution: Unresolved
• Affects Version/s: 1.10.0
• Component/s: Table SQL / API, Table SQL / Client
• Labels: auto-deprioritized-major auto-deprioritized-minor
• Assignee: Unassigned
• Reporter: Guangbin Zhu
• Created: 25/Apr/20 11:57
• Updated: 15/Nov/21 22:38

Description

FlinkSQL does not support variable substitution like hive. 

SET k1=v1;
Select * from table where key=${k1}

This is a common and great useful feature that Flink should support.