This is an automated email from the ASF dual-hosted git repository. twalthr pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/flink.git
The following commit(s) were added to refs/heads/master by this push: new b1afaaa [hotfix][docs] Update Window TopN SQL example b1afaaa is described below commit b1afaaaa1a4a9fac2db909eb3e548cd5472bca11 Author: martijnvisser <mart...@2symbols.com> AuthorDate: Tue Sep 7 12:11:23 2021 +0200 [hotfix][docs] Update Window TopN SQL example --- docs/content/docs/dev/table/sql/queries/window-topn.md | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/docs/content/docs/dev/table/sql/queries/window-topn.md b/docs/content/docs/dev/table/sql/queries/window-topn.md index a1881cc..560b819 100644 --- a/docs/content/docs/dev/table/sql/queries/window-topn.md +++ b/docs/content/docs/dev/table/sql/queries/window-topn.md @@ -111,7 +111,7 @@ The following example shows how to calculate Top 3 items which have the highest ```sql Flink SQL> SELECT * FROM ( - SELECT *, ROW_NUMBER() OVER (PARTITION BY window_start, window_end ORDER BY price DESC) as rownum + SELECT bidtime, price, item, supplier_id, window_start, window_end, ROW_NUMBER() OVER (PARTITION BY window_start, window_end ORDER BY price DESC) as rownum FROM TABLE( TUMBLE(TABLE Bid, DESCRIPTOR(bidtime), INTERVAL '10' MINUTES)) ) WHERE rownum <= 3;