FROM
clause of a query:
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
.
sequence
table function might not be ordered.FROM
clause of a query. Table function
invocation syntax is similar to a scalar function call.
null
for a descriptor, use:
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: