yql/essentials/tests/sql/suites/window/win_func_into_udf.sql


1
2
3
4
5
6

/* postgres can not */
SELECT
   key, Math::Sqrt(CAST(row_number() over w as double)) as sq
FROM plato.Input
WINDOW w AS (partition by key order by subkey)
ORDER BY key, sq;