flink-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hequn Cheng (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (FLINK-12105) TUMBLE INTERVAL value errors out for 100 or more value
Date Thu, 04 Apr 2019 06:27:00 GMT

    [ https://issues.apache.org/jira/browse/FLINK-12105?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16809550#comment-16809550
] 

Hequn Cheng commented on FLINK-12105:
-------------------------------------

[~vmehra] Hi, thanks for bringing up the discussion. As the default interval precision is
2, you need to specify the precision, e.g., {{INTERVAL '100' HOUR(3)}}. For MONTH and YEAR,
there is already a discussion for it which may be helpful for you, see FLINK-9740.

Best, Hequn

> TUMBLE INTERVAL value errors out for 100 or more value
> ------------------------------------------------------
>
>                 Key: FLINK-12105
>                 URL: https://issues.apache.org/jira/browse/FLINK-12105
>             Project: Flink
>          Issue Type: Bug
>          Components: Table SQL / Client
>    Affects Versions: 1.7.2
>         Environment: [https://github.com/ververica/sql-training]
>            Reporter: Vinod Mehra
>            Priority: Major
>
> I ran into this while experimenting with different values at Lyft eng. However it is
reproducible with [https://github.com/ververica/sql-training] as well. I showed this issue
to the training instructors during flink-forward-19 and they asked me to file this bug.
> The INTERVAL values work fine until 99. Errors after that:
> *TUMBLE(rideTime, INTERVAL '100' SECOND)*
> _org.apache.calcite.sql.validate.SqlValidatorException: Interval field value 100 exceeds
precision of SECOND(2) field_
> *TUMBLE(rideTime, INTERVAL '100' MINUTE)*
> _org.apache.calcite.sql.validate.SqlValidatorException: Interval field value 100 exceeds
precision of MINUTE(2) field_
> *TUMBLE(rideTime, INTERVAL '100' HOUR)*
> _org.apache.calcite.sql.validate.SqlValidatorException: Interval field value 100 exceeds
precision of HOUR(2) field_
> *TUMBLE(rideTime, INTERVAL '100' DAY)*
> _org.apache.calcite.sql.validate.SqlValidatorException:_ Interval field value 100 exceeds
precision of DAY(2) field
> (Note: MONTH AND YEAR also error out but for different reasons ("_Only constant window
intervals with millisecond resolution are supported_"). MONTH and YEAR intervals are not supported
at all currently. I was told that it is hard to implement because of timezone differences.
I will file that separately.)_
>  _



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message