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;

Reply via email to