[ https://issues.apache.org/jira/browse/BEAM-13770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17514833#comment-17514833 ]
Beam JIRA Bot commented on BEAM-13770: -------------------------------------- This issue is P2 but has been unassigned without any comment for 60 days so it has been labeled "stale-P2". If this issue is still affecting you, we care! Please comment and remove the label. Otherwise, in 14 days the issue will be moved to P3. Please see https://beam.apache.org/contribute/jira-priorities/ for a detailed explanation of what these priorities mean. > 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: P2 > 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)