This Confluence has been LDAP enabled, if you are an ASF Committer, please use your LDAP Credentials to login. Any problems file an INFRA jira ticket please.

Page tree
Skip to end of metadata
Go to start of metadata

SQL Syntax

Examples can be found in the unit tests (query_optimizer/tests/execution_generator/Select.test)

SELECT sum(avg(int_col) OVER w) FROM test
WINDOW w AS
(PARTITION BY char_col
ORDER BY long_col
ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW);

Explanation

Each window query will have an OVER keyword which can immediately reference a WINDOW clause or immediately define the WINDOW clause.

Limitations

At the time of writing, the only supported aggregation is AVG. 

This is implemented in a single thread mode. There has not been an attempt to make it support multithreaded environments.

window-query-plan.svg

 

  • No labels