[ https://issues.apache.org/jira/browse/BEAM-13770?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Beam JIRA Bot updated BEAM-13770: --------------------------------- Priority: P3 (was: P2) > 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 > Priority: P3 > Labels: stale-P2 > > 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)