[
https://issues.apache.org/jira/browse/FLINK-13561?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jark Wu resolved FLINK-13561.
-----------------------------
Resolution: Fixed
[table-planner-blink] Fix wrong result of TIMESTAMPADD(HOUR, interval, DATE)
- master: 499a0f49de47c61ad8ef6341402756468d25f680
- 1.9: d61e6069985e20912443406c0492a169443b4c06
[table-planner-blink] Fix NOW() should return TIMESTAMP instead of BIGINT.
- master: c365780e7527a917e9d127694cd80cf2cdabf247
- 1.9: 5ee3485e40248c74cca5325db0ab200be11bd7aa
[table-planner-blink] Fix UNIX_TIMESTAMP(string [,format]) should work in
session time zone
- master: bde51f9e46600154bd60321d3d345bb539b30ed1
- 1.9: 45d0aef20da019bd447ad7910629de7195ef9afa
[table-planner-blink] Fix FROM_UNIXTIME(bigint [,format]) should work in
session time zone
- master: 8dbc64105c13dfae467f2cfb75ec67d0d2d56c84
- 1.9: 2403448e58cde1d4c017d719d55d4a23edbdf0d9
[table-planner-blink] Drop TO_DATE(int) function support
- master: 80f17d5b16b139023ee63c1251491075000157f7
- 1.9: a58fb83352cddd65ce8559f3296851f2ff2133ec
[table-planner-blink] Drop TO_TIMESTAMP(bigint) function support
- master: b41b52a6d1a18eafa113de3abd14da519de8cf2f
- 1.9: 9ac2a9c1cfed9da381c6b850efbca8d1ccd2ea5a
[table-planner-blink] Drop CONVERT_TZ(timestamp, format, from_tz, to_tz)
function support
- master: d01cfb0cdedea79b2b946b7c3367b29a787d3e79
- 1.9: 18bd93b1f924be538addadc4c7953c454d099104
[table-planner-blink] Drop DATE_FORMAT(timestamp, from_format, to_format)
function support
- master: e8fd892220f6575ef99339d274b812202e687f93
- 1.9: 09d0f61866d54269a95207426da9b105b38ea1f9
[table-planner-blink] Remove some builtin datetime functions which can be
covered by existing functions
- master: 28260cdd70aee0a4169a068887feae71a81ec4c0
- 1.9: 1f905207f15bd9ceed8f9c3d2b3fcf0cc269e742
> Verify and correct time function's semantic for Blink planner
> -------------------------------------------------------------
>
> Key: FLINK-13561
> URL: https://issues.apache.org/jira/browse/FLINK-13561
> Project: Flink
> Issue Type: Sub-task
> Components: Table SQL / Planner
> Reporter: Jingsong Lee
> Assignee: Jark Wu
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.9.0
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> - Drop CONVERT_TZ(timestamp, format, from_tz, to_tz) function support
> - Drop CONVERT_TZ(timestamp, format, from_tz, to_tz) function support in
> blink planner to align with other databases. We only support
> CONVERT_TZ(timestamp, from_tz, to_tz) in this version.
> - Drop DATE_FORMAT(timestamp, from_format, to_format) function support
> - Drop DATE_FORMAT(timestamp, from_format, to_format) function support in
> blink planner to align with other databases. We only support
> DATE_FORMAT(timestamp, to_format) and DATE_FORMAT(string, to_format) in this
> version.
> - Drop TO_DATE(int) function support
> - Drop TO_DATE(int) function support in blink planner to align with other
> databases. We only support TO_DATE(string [,format]) in this version.
> - Drop TO_TIMESTAMP(bigint) function support
> - Drop TO_TIMESTAMP(bigint) function support in blink planner to align with
> other systems. We only support TO_TIMESTAMP(string [,format]) in this version.
> - Remove some builtin datetime functions which can be covered by existing
> functions
> - Removes DATE_FORMAT_TZ, DATE_ADD,DATE_SUB, DATEDIFF, FROM_TIMESTAMP,
> TO_TIMESTAMP_TZ
> - Fix FROM_UNIXTIME(bigint [,format]) should work in session time zone
> - This aligns the behavior to other systems (MySQL, Spark).
> - Fix UNIX_TIMESTAMP(string [,format]) should work in session time zone
> - This aligns the behavior to other systems (MySQL, Spark).
> UNIX_TIMESTAMP(string [,format]) is an inverse of FROM_UNIXTIME(bigint
> [,format]). We also remove the support of UNIX_TIMESTAMP(timestamp) in this
> commit.
> - Fix NOW() should return TIMESTAMP instead of BIGINT.
> - This aligns the behavior to other systems (MySQL, Spark). Because NOW()
> is Synonyms for CURRENT_TIMESTAMP.
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)
