You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "leesf (JIRA)" <ji...@apache.org> on 2019/04/04 01:55:00 UTC
[jira] [Comment Edited] (FLINK-12105) TUMBLE INTERVAL value errors
out for 100 or more value
[ https://issues.apache.org/jira/browse/FLINK-12105?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16809428#comment-16809428 ]
leesf edited comment on FLINK-12105 at 4/4/19 1:54 AM:
-------------------------------------------------------
[~vmehra]，hi. I think the issue could be more appropriate to be filed in the calcite community, since the exception is thrown when calcite validates query SQL.
was (Author: xleesf):
[~vmehra]，hi. The issue could be more appropriate to be filed in the calcite community, since the exception is thrown when calcite validate query SQL than Flink.
> 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)