You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@beam.apache.org by "Kyle Weaver (Jira)" <ji...@apache.org> on 2022/01/29 00:41:00 UTC

[jira] [Created] (BEAM-13770) Support RANGE BETWEEN INTERVAL.

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)