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)