GitHub user jianlirong added a comment to the discussion: Support Parallel Processing of Window Functions.
In my personal opinion, we should modify the corresponding SQL statement and add ORDER BY. Although we're discussing window functions here, the issue reflected in this example is essentially no different from the following statement: ``` SELECT unique1 FROM tenk1 WHERE unique1 < 10; ``` Under a MPP-style database, the results of the above query will not be the same if we run it multiple times. That totally depends on the order when tuples are arriving at the master node. The only way to make the result stable is just to add ORDER BY. That's why I think we should do the same for the window function query under discussion. GitHub link: https://github.com/apache/cloudberry/discussions/1216#discussioncomment-13775166 ---- This is an automatically sent email for dev@cloudberry.apache.org. To unsubscribe, please send an email to: dev-unsubscr...@cloudberry.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@cloudberry.apache.org For additional commands, e-mail: dev-h...@cloudberry.apache.org
