[
https://issues.apache.org/jira/browse/FLINK-13561?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jark Wu updated FLINK-13561:
----------------------------
Description:
- 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.
was:
Some time function should be corrected:
toTimestamp('2016-03-31') not support in blink.
unix_timestamp and from_unixtime should care about time zone.
> 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
> Fix For: 1.9.0
>
>
> - 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)
