Invalid example queries, because the UDF does not support any partitioning. Each example raises a SQL exception.
SELECT * FROM my_tpf( TABLE( SELECT T.x, T.y FROM T ) OVER( PARTITION BY T.x ))
This example results in a SQL error because the SQL writer requested partitioning on column T.x, and the UDF does not support any partitioning on any columns.
SELECT * FROM my_tpf( TABLE( SELECT T.x, T.y FROM T ) OVER( PARTITION BY T.y ))
This example results in a SQL error because the SQL writer requested partitioning on column T.y, and the UDF does not support any partitioning on any columns.
SELECT * FROM my_tpf( TABLE( SELECT T.x, T.y FROM T ) OVER( PARTITION BY T.y, T.x ))
This example results in a SQL error because the SQL writer requested partitioning on columns T.y and T.x, and the UDF does not support any partitioning on any columns.