alamb commented on issue #13399: URL: https://github.com/apache/datafusion/issues/13399#issuecomment-2475531224
Thanks @jonathanc-n -- here are some notes to help anyone who wants to help with this: What I normaly do is fire up `datafusion-cli` and copy/paste the result of the query into the code So for example, to test `cume_dist` https://datafusion.apache.org/user-guide/sql/window_functions.html#cume-dist I would do ```shell > SELECT x, cume_dist() OVER (ORDER BY y) as cume_dist FROM VALUES (1,20), (2, 10), (3,30) t(x,y); +---+--------------------+ | x | cume_dist | +---+--------------------+ | 2 | 0.3333333333333333 | | 1 | 0.6666666666666666 | | 3 | 1.0 | +---+--------------------+ 3 row(s) fetched. Elapsed 0.002 seconds. ``` BTW the syntax ```sql VALUES (1,20), (2, 10), (3,30) t(x,y); ``` Basically creates a temporary table named `t` with columns `x` and `y` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
