Kyle Weaver created BEAM-13770:
----------------------------------

             Summary: Support RANGE BETWEEN INTERVAL.
                 Key: BEAM-13770
                 URL: https://issues.apache.org/jira/browse/BEAM-13770
             Project: Beam
          Issue Type: New Feature
          Components: dsl-sql
            Reporter: Kyle Weaver


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




--
This message was sent by Atlassian Jira
(v8.20.1#820001)

Reply via email to