You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Yun Gao (Jira)" <ji...@apache.org> on 2022/04/13 06:28:05 UTC
[jira] [Updated] (FLINK-25900) Create view example does not assign alias to functions resulting in generated names like EXPR$5
[ https://issues.apache.org/jira/browse/FLINK-25900?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Yun Gao updated FLINK-25900:
----------------------------
Fix Version/s: 1.16.0
> Create view example does not assign alias to functions resulting in generated names like EXPR$5
> -----------------------------------------------------------------------------------------------
>
> Key: FLINK-25900
> URL: https://issues.apache.org/jira/browse/FLINK-25900
> Project: Flink
> Issue Type: Improvement
> Components: Documentation, Table SQL / API
> Affects Versions: 1.14.3
> Reporter: Mans Singh
> Assignee: Mans Singh
> Priority: Minor
> Labels: pull-request-available
> Fix For: 1.15.0, 1.16.0
>
>
> The create view example query:
> {noformat}
> Flink SQL> CREATE VIEW MyView1 AS SELECT LOCALTIME, LOCALTIMESTAMP, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, CURRENT_ROW_TIMESTAMP(), NOW(), PROCTIME();
> {noformat}
> produces generated column names for CURRENT_ROW_TIMESTAMP() (EXPR$5), NOW() (EXPR$6), and PROCTIME() (EXPR$7) since it does not assign aliases, as shown below:
> {code:java}
> Flink SQL> CREATE VIEW MyView1 AS SELECT LOCALTIME, LOCALTIMESTAMP, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, CURRENT_ROW_TIMESTAMP(), NOW(), PROCTIME();
> >
> Flink SQL> describe MyView1;
> +-------------------+-----------------------------+-------+-----+--------+-----------+
> | name | type | null | key | extras | watermark |
> +-------------------+-----------------------------+-------+-----+--------+-----------+
> | LOCALTIME | TIME(0) | FALSE | | | |
> | LOCALTIMESTAMP | TIMESTAMP(3) | FALSE | | | |
> | CURRENT_DATE | DATE | FALSE | | | |
> | CURRENT_TIME | TIME(0) | FALSE | | | |
> | CURRENT_TIMESTAMP | TIMESTAMP_LTZ(3) | FALSE | | | |
> | EXPR$5 | TIMESTAMP_LTZ(3) | FALSE | | | |
> | EXPR$6 | TIMESTAMP_LTZ(3) | FALSE | | | |
> | EXPR$7 | TIMESTAMP_LTZ(3) *PROCTIME* | FALSE | | | |
> +-------------------+-----------------------------+-------+-----+--------+-----------+
> 8 rows in set
>
> {code}
>
> The documentation shows aliased names [Timezone|https://nightlies.apache.org/flink/flink-docs-master/docs/dev/table/timezone/#decide-time-functions-return-value]
> {code:java}
> +------------------------+-----------------------------+-------+-----+--------+-----------+
> | name | type | null | key | extras | watermark |
> +------------------------+-----------------------------+-------+-----+--------+-----------+
> | LOCALTIME | TIME(0) | false | | | |
> | LOCALTIMESTAMP | TIMESTAMP(3) | false | | | |
> | CURRENT_DATE | DATE | false | | | |
> | CURRENT_TIME | TIME(0) | false | | | |
> | CURRENT_TIMESTAMP | TIMESTAMP_LTZ(3) | false | | | |
> |CURRENT_ROW_TIMESTAMP() | TIMESTAMP_LTZ(3) | false | | | |
> | NOW() | TIMESTAMP_LTZ(3) | false | | | |
> | PROCTIME() | TIMESTAMP_LTZ(3) *PROCTIME* | false | | | |
> +------------------------+-----------------------------+-------+-----+--------+-----------+
> {code}
>
>
--
This message was sent by Atlassian Jira
(v8.20.1#820001)