Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

View file
namewindow-query-plan.svg
height250

 

Adaptavist ThemeBuilder EngineAtlassian Confluence