Table Operators and Table Functions | CREATE FUNCTION | Teradata Vantage - Table Operator UDFs - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
lifecycle
latest
Product Category
Teradata Vantage™

A table operator is a form of a UDF that can only be specified in the FROM clause of a SELECT request. The database treats table operator UDFs as derived table subqueries.

Name overloading is allowed, but because table operators have no explicit input, the table operator UDFs must have a unique name.

A table operator can be defined to operate in all UDF modes, protected, not protected and secure mode.

The table operator cannot execute on a PE.

You define the table operator using the SQLTABLE parameter style. SQLTABLE refers to the ANSI UDF parameter style. The ANSI UDF parameter style table operator is passed an input row in the indicdata format and returns the output row in the same format.

Table functions and table operators cannot execute against fallback data when an AMP is down. After the AMP returns to service, the query can complete as normal.