You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Danny Chen (Jira)" <ji...@apache.org> on 2020/03/16 04:32:00 UTC
[jira] [Updated] (FLINK-16609) Promotes the column name
representation of SQL-CLI
[ 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:
+ Expression like "a + b" should output "a + b" (i.e. the MySQL CLI) instead of "$Expr{index}"
+ 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" (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
> 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:
> + Expression like "a + b" should output "a + b" (i.e. the MySQL CLI) instead of "$Expr{index}"
> + 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)