UDTF API methods

A user defined table function is used in the FROM clause of a SQL statement. This enables a UDTF to return multiple columns and/or multiple rows for each input row.

The SQL below invokes a table function named "tftest", passing the values foo.x and foo.y as the first and second arguments. The tftest table function in this example returns three columns-- "a", "b", and "c".

select foo.x, foo.y, tf.a, tf.b, tf.c
from foo, table(testtf(foo.x, foo.y)) tf
where foo.x > 1000;