Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.3.0
    • Fix Version/s: 2.0.0
    • Component/s: PTF-Windowing
    • Labels:

      Description

      Currently date datatype is not supported in value based windowing function.

      For the following query with hiredate to be date type, an exception will be thrown.

      select deptno, ename, hiredate, sal, sum(sal) over (partition by deptno order by hiredate range 90 preceding) from emp;

      It's valuable to support such type with number of days as the value difference.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                aihuaxu Aihua Xu
                Reporter:
                aihuaxu Aihua Xu
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: