Uploaded image for project: 'Beam'
  1. Beam
  2. BEAM-13770

Support RANGE BETWEEN INTERVAL.

Details

    • New Feature
    • Status: Open
    • P3
    • Resolution: Unresolved
    • None
    • None
    • dsl-sql
    • None

    Description

      Support RANGE BETWEEN INTERVAL syntax with analytic (over) functions.

      SELECT order_id, order_time, amount,
      SUM(amount) OVER (
      PARTITION BY product
      ORDER BY order_time
      RANGE BETWEEN INTERVAL '1' HOUR PRECEDING AND CURRENT ROW
      ) AS one_hour_prod_amount_sum
      FROM Orders

      Attachments

        Activity

          People

            Unassigned Unassigned
            ibzib Kyle Weaver
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated: