This is an automated email from the ASF dual-hosted git repository.
techdocsmith pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/druid.git
The following commit(s) were added to refs/heads/master by this push:
new 5ed68622c3b [Docs] Update known issues for window functions (#17097)
5ed68622c3b is described below
commit 5ed68622c3bf33801182670b0cda293519d03263
Author: Charles Smith <[email protected]>
AuthorDate: Tue Oct 8 08:47:13 2024 -0700
[Docs] Update known issues for window functions (#17097)
* draft update to known issues
* Update known issues
Remove addressed known issues. Clarify the issue with SELECT * queries.
---
docs/querying/sql-window-functions.md | 6 +-----
1 file changed, 1 insertion(+), 5 deletions(-)
diff --git a/docs/querying/sql-window-functions.md
b/docs/querying/sql-window-functions.md
index 197b269418e..b7f6b17d868 100644
--- a/docs/querying/sql-window-functions.md
+++ b/docs/querying/sql-window-functions.md
@@ -420,8 +420,4 @@ The number of rows considered for the `moving5` window for
the `count5` column:
The following are known issues with window functions:
-- Aggregates with ORDER BY specified are processed in the window: ROWS
BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
- This behavior differs from other databases that use the default of RANGE
BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW.
- In cases where the order column is unique there is no difference between
RANGE / ROWS; windows with RANGE specifications are handled as ROWS.
-- LEAD/LAG ignores the default value
-- LAST_VALUE returns the last value of the window even when you include an
ORDER BY clause
+- SELECT * queries without a WHERE clause are not supported. If you want to
retrieve all columns in this case, specify the column names.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
