-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 1.6.2, 1.7.0
-
Component/s: Table SQL / API
-
Labels:
If a time interval was specified with YEAR TO MONTH resolution like e.g.:
SELECT *
FROM Mytable
GROUP BY
TUMBLE(rowtime, INTERVAL '1-2' YEAR TO MONTH)
it will be wrongly translated to 14 milliseconds window. We should allow for only DAY TO SECOND resolution.
- links to