Mans Singh created FLINK-25900:
----------------------------------
Summary: 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
Fix For: 1.15.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)
