XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.24.0
    • Component/s: None

      Description

      TUMBLE/HOP have an optional "OFFSET" parameter to indicate how many time off from 0 for windowing. The OFFSET parameter is of interval type.

      TUMBLE(table, size [, offset])
      HOP(table, size, shift, [, offset])
      

      One example:

      Say here is a TUMBLE call with the following output
      TUMBLE(table, INTERNVAL '5' MINUTE)

      rowtime window_start window_end
      2020-06-20 12:23:40 2020-06-20 12:20:00 2020-06-20 12:25:00
      2020-06-20 12:21:40 2020-06-20 12:20:00 2020-06-20 12:25:00

      if using the optional offset parameter
      TUMBLE(table, INTERNVAL '5' MINUTE, INTERNVAL '2' MINUTE)

      rowtime window_start window_end
      2020-06-20 12:23:40 2020-06-20 12:22:00 2020-06-20 12:27:00
      2020-06-20 12:21:40 2020-06-20 12:17:00 2020-06-20 12:22:00

      OFFSET is applied per window basis, so the example above will also apply for HOP.

        Attachments

          Activity

            People

            • Assignee:
              amaliujia Rui Wang
              Reporter:
              amaliujia Rui Wang
            • Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 6.5h
                6.5h