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.