[
https://issues.apache.org/jira/browse/FLINK-16609?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Danny Chen updated FLINK-16609:
-------------------------------
Description:
The SQL-CLI now outputs the column name as the name that comes from the plan,
which is not that readable sometimes, i can think of 2 cases that can be
promoted:
1. Expression like "a + b" should output "a + b" (i.e. the MySQL CLI) instead
of "$Expr{index}"
2. We should always output the alias if it's there, now, the alias in the plan
may be dropped because of 2 reasons:
- Project remove rule would remove the project without considering the alias
- after CALCITE-3713, some CALC/PROJ would be reused while ignoring the
column alias
was:
The SQL-CLI now outputs the column name as the name that comes from the plan,
which is not that readable sometimes, i can think of 2 cases that can be
promoted:
1. Expression like "a + b" should output "a + b" instead of "$Expr{index}"
2. We should always output the alias if it's there, now, the alias in the plan
may be dropped because of 2 reasons:
- Project remove rule would remove the project without considering the alias
- after CALCITE-3713, some CALC/PROJ would be reused while ignoring the
column alias
> Promotes the column name representation of SQL-CLI
> --------------------------------------------------
>
> Key: FLINK-16609
> URL: https://issues.apache.org/jira/browse/FLINK-16609
> Project: Flink
> Issue Type: Improvement
> Components: Table SQL / Client
> Affects Versions: 1.10.0
> Reporter: Danny Chen
> Priority: Major
> Fix For: 1.11.0
>
>
> The SQL-CLI now outputs the column name as the name that comes from the plan,
> which is not that readable sometimes, i can think of 2 cases that can be
> promoted:
> 1. Expression like "a + b" should output "a + b" (i.e. the MySQL CLI) instead
> of "$Expr{index}"
> 2. We should always output the alias if it's there, now, the alias in the
> plan may be dropped because of 2 reasons:
> - Project remove rule would remove the project without considering the alias
> - after CALCITE-3713, some CALC/PROJ would be reused while ignoring the
> column alias
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
