git.net

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[jira] [Created] (FLINK-11017) Time interval for window aggregations in SQL is wrongly translated if specified with YEAR_MONTH resolution


Dawid Wysakowicz created FLINK-11017:
----------------------------------------

             Summary: Time interval for window aggregations in SQL is wrongly translated if specified with YEAR_MONTH resolution
                 Key: FLINK-11017
                 URL: https://issues.apache.org/jira/browse/FLINK-11017
             Project: Flink
          Issue Type: Bug
          Components: Table API & SQL
    Affects Versions: 1.6.2, 1.7.0
            Reporter: Dawid Wysakowicz
            Assignee: Dawid Wysakowicz
             Fix For: 1.6.3, 1.8.0, 1.7.1


If a time interval was specified with {{YEAR TO MONTH}} resolution like e.g.:
{code}
SELECT * 
FROM Mytable
GROUP BY 
    TUMBLE(rowtime, INTERVAL '1-2' YEAR TO MONTH)
{code}
it will be wrongly translated to 14 milliseconds window. We should allow for only DAY TO SECOND resolution.



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