[
https://issues.apache.org/jira/browse/ASTERIXDB-1635?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Preston Carman closed ASTERIXDB-1635.
-------------------------------------
Resolution: Fixed
Now in master.
> Overlap-bins does not start at the correct bin for dates
> --------------------------------------------------------
>
> Key: ASTERIXDB-1635
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1635
> Project: Apache AsterixDB
> Issue Type: Bug
> Reporter: Preston Carman
> Assignee: Preston Carman
> Priority: Minor
>
> Using the example on the documentation, I changed the date overlap-bins to
> use 10 years. The change now produces the wrong result. The result starts
> from 1970 instead of the correct year.
> The issue is because the days are not converted to ms when picking the
> starting bin.
> Sample query:
> {noformat}
> let $itv1 := interval(time("17:23:37"), time("18:30:21"))
> let $itv2 := interval(date("1984-03-17"), date("2013-08-22"))
> let $itv3 := interval(datetime("1800-01-01T23:59:48.938"),
> datetime("2015-07-26T13:28:30.218"))
> return { "timebins": overlap-bins($itv1, time("00:00:00"),
> day-time-duration("PT30M")),
> "datebins": overlap-bins($itv2, date("1990-01-01"),
> year-month-duration("P10Y")),
> "datetimebins": overlap-bins($itv3, datetime("1900-01-01T00:00:00.000"),
> year-month-duration("P100Y")) }
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
