[FLINK-34459] Results column names should match SELECT clause expression names

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 1.18.1
• Component/s: Table SQL / Client
• Assignee: Unassigned
• Reporter: Jeyhun Karimov
• Created: 18/Feb/24 14:51
• Updated: 19/Feb/24 14:14

Description

When printing SQL SELECT results, Flink will output generated expression name when the expression is not column reference or used with alias/over.
For example, select a, a + 1 from T would result in

+----+-------------+-------------+
| op |           a |      EXPR$1 |
+----+-------------+-------------+
| +I |           1 |           2 |
| +I |           1 |           2 |
| +I |           1 |           2 |
+----+-------------+-------------+

Instead of the generated EXPR$1 it would be nice to have a + 1 (which is the case in some other data processing systems like Spark).