In the SQL API I see the query below. I want to know how I can make tumbling tables based on amount of rows. So I want to make a window for row 1-10, 11-20 etc. It is also good if the windowing takes place on a Integer ID column. How can I do this?
Tableresult1=tableEnv.sqlQuery("SELECT user, "+" TUMBLE_START(rowtime, INTERVAL '1' DAY) as wStart, "+" SUM(amount) FROM Orders "+"GROUP BY TUMBLE(rowtime, INTERVAL '1' DAY), user");