4 ms·
You can tell the authors realized this was a bad idea when they had to add the 'OVER' keyword, which isn't documented and hardly mentioned in the paper.
by typedef_struct 2y ago
You can tell the authors realized this was a bad idea when they had to add the 'OVER' keyword, which isn't documented and hardly mentioned in the paper.
- roryokane 2y agoZetaSQL’s docs for the ‘OVER’ keyword you mention: https://github.com/google/zetasql/blob/master/docs/window-function-calls.md#def_over_clause https://github.com/google/zetasql/blob/master/docs/window-fu... I disagree that the paper not mentioning ‘OVER’ implies that the paper authors secretly think pipe syntax is a bad idea. They probably just wanted to keep the paper concise, or forgot about that one less-used bit of syntax. Do you think that ‘OVER’ keyword implies something fundamentally wrong about pipe syntax? If so, how?
- nhinck2 2y agohttps://en.m.wikipedia.org/wiki/Window_function_(SQL) https://en.m.wikipedia.org/wiki/Window_function_(SQL) They didn't add anything.