[
https://issues.apache.org/jira/browse/FLINK-34459?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jeyhun Karimov updated FLINK-34459:
-----------------------------------
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
{code:java}
+----+-------------+-------------+
| op | a | EXPR$1 |
+----+-------------+-------------+
| +I | 1 | 2 |
| +I | 1 | 2 |
| +I | 1 | 2 |
+----+-------------+-------------+
{code}
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).
was:
When printing {{SQL SELECT}} results, Flink will output generated expression
name when the expression type is not {{column reference or alias or over.}}
For example, select a, a + 1 from T would result in
{code:java}
+----+-------------+-------------+
| op | a | EXPR$1 |
+----+-------------+-------------+
| +I | 1 | 2 |
| +I | 1 | 2 |
| +I | 1 | 2 |
+----+-------------+-------------+
{code}
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).
> Results column names should match SELECT clause expression names
> ----------------------------------------------------------------
>
> Key: FLINK-34459
> URL: https://issues.apache.org/jira/browse/FLINK-34459
> Project: Flink
> Issue Type: Improvement
> Components: Table SQL / Client
> Affects Versions: 1.18.1
> Reporter: Jeyhun Karimov
> Priority: Minor
>
> 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
> {code:java}
> +----+-------------+-------------+
> | op | a | EXPR$1 |
> +----+-------------+-------------+
> | +I | 1 | 2 |
> | +I | 1 | 2 |
> | +I | 1 | 2 |
> +----+-------------+-------------+
> {code}
> 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).
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
