Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-10140

Window boundary is not compared correctly

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 0.13.0, 0.14.0, 1.0.0, 1.2.0, 1.1.0
    • Fix Version/s: 1.3.0, 2.0.0
    • Component/s: PTF-Windowing
    • Labels:
      None

      Description

      “ROWS between 10 preceding and 2 preceding” is not handled correctly.

      Underlying error: Window range invalid, start boundary is greater than end boundary: window(start=range(10 PRECEDING), end=range(2 PRECEDING))

      If I change it to “2 preceding and 10 preceding”, the syntax works but the results are 0 of course.

      Reason for the function: during analysis, it is sometimes desired to design the window to filter the most recent events, in the case of the events' responses are not available yet. There is a workaround for this, but it is better/more proper to fix the bug.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: