16.20 - Overview - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1145-162K
Language
English (United States)

Teradata Vantage™ is our flagship analytic platform offering, which evolved from our industry-leading Teradata® Database. Until references in content are updated to reflect this change, the term Teradata Database is synonymous with Teradata Vantage.

This document describes common SQL functions, expressions, and predicates that SQL application programmers can use.

Additional functions that are documented in other books are listed in the following table.

ARRAY/VARRAY functions, operators, expressions, and methods

Teradata Vantage™ Data Types and Literals, B035-1143

BLOB and CLOB functions

Teradata Vantage™ Data Types and Literals, B035-1143

Calendar and business calendar functions

Teradata Vantage™ SQL Date and Time Functions and Expressions, B035-1211

The CAST expression and data type conversion functions

Teradata Vantage™ Data Types and Literals, B035-1143

Compression/decompression functions Teradata Vantage™ - SQL Operators and User-Defined Functions, B035-1210
DATASET functions and methods Teradata Vantage™ DATASET Data Type, B035-1198
DateTime and interval functions and expressions

Teradata Vantage™ SQL Date and Time Functions and Expressions, B035-1211

Export width procedures (manage the amount of data exported to client applications) Teradata Vantage™ - SQL Operators and User-Defined Functions, B035-1210
File system information macros and functions (gain information on specific data blocks) Teradata Vantage™ - SQL Operators and User-Defined Functions, B035-1210
Geospatial functions and methods Teradata Vantage™ Geospatial Data Types , B035-1181
JSON functions and methods Teradata Vantage™ - JSON Data Type, B035-1150
Map functions, macros, and procedures (optimize the placement of tables across AMPs) Teradata Vantage™ - SQL Operators and User-Defined Functions, B035-1210
Period functions and operators

Teradata Vantage™ SQL Date and Time Functions and Expressions, B035-1211

Script installation procedures Teradata Vantage™ - SQL Operators and User-Defined Functions, B035-1210
SET operators (INTERSECT, MINUS/EXCEPT, UNION) Teradata Vantage™ - SQL Data Manipulation Language , B035-1146
Table operators Teradata Vantage™ - SQL Operators and User-Defined Functions, B035-1210
User-defined type expressions and these UDFs supplied by Teradata:
  • Aggregate
  • Scalar
  • Window aggregate

Teradata Vantage™ - SQL Operators and User-Defined Functions, B035-1210

XML functions and methods Teradata Vantage™ XML Data Type, B035-1140