FROM
clause of a query:
Built-in table functions
exclude_columns
table
all columns listed in descriptor
:
input
is a table or a query.
The argument columns
is a descriptor without types.
sequential_number
containing a sequence of
bigint:
start
is the first element in the sequence. The default value is 0
.
stop
is the end of the range, inclusive. The last element in the
sequence is equal to stop
, or it is the last value within range,
reachable by steps.
step
is the difference between subsequent values. The default value is
1
.
The result of the
sequence
table function might not be ordered.Table function invocation
You invoke a table function in theFROM
clause of a query. Table function
invocation syntax is similar to a scalar function call.
Function resolution
Every table function is provided by a catalog, and it belongs to a schema in the catalog. You can qualify the function name with a schema name, or with catalog and schema names:Arguments
There are three types of arguments.- Scalar arguments
- Descriptor arguments
null
for a descriptor, use:
- Table arguments
TABLE
:
PRUNE WHEN EMPTY
or KEEP WHEN EMPTY
. With PRUNE WHEN EMPTY
you
declare that you are not interested in the function result if the argument is
empty. This information is used by the Trino engine to optimize the query. The
KEEP WHEN EMPTY
option indicates that the function should be executed even
if the table argument is empty. By specifying KEEP WHEN EMPTY
or
PRUNE WHEN EMPTY
, you override the property set for the argument by the
function author.
The following example shows how the table argument properties should be ordered:
Argument passing conventions
There are two conventions of passing arguments to a table function:-
Arguments passed by name:
-
Arguments passed positionally: