1.0 - 8.00 - Function Syntax Descriptions - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.0
8.00
Release Date
May 2019
Content Type
Programming Reference
Publication ID
B700-4003-098K
Language
English (United States)

SELECT Statement Clauses

The function syntax descriptions in this document are SQL SELECT statements. For simplicity, the descriptions do not show every possible SELECT statement clause. However, you can use any valid SELECT statement clauses. For information about SELECT statement options, see Teradata® Database SQL Data Manipulation Language , B035-1146 .

Many examples in this document use ORDER BY clauses that the function syntax descriptions do not show.

Function Argument Order

OUT TABLE function arguments must appear above the USING clause, but they need not appear in the order shown in the function syntax description. All other function arguments must appear after the USING clause, but they need not appear in the order shown in the function syntax description.

Many examples in this document do not specify their arguments in the order shown in the function syntax description.

Input Table Aliases

When function syntax specifies aliases for input tables, use them as specified; otherwise, an error occurs.

For example, in the following clauses of a graph function, vertices is the alias of the input table containing the vertices of the input graph and edges is the alias of the table containing the edges connecting the vertices:

...
  ON vertices_table AS vertices PARTITION BY ...
  ON edges_table AS edges PARTITION BY ...
...

Using different aliases causes an error:

beehive=> ...
beehive=>   ON cities AS vr PARTITION BY ...
beehive=>   ON freeways AS edges PARTITION BY ...
beehive=> ...
ERROR: SQL-MR function ALLPAIRSSHORTESTPATH requires input table or query with alias: vertices

Function Argument Values with Numeric SQL Types

For a function argument with any SQL numeric data type, surrounding single quotation marks are optional. For example, Seed (5) and Seed ('5') are equivalent. For information about SQL numeric data types, see Teradata® Database SQL Data Types and Literals, B035-1143.