17.10 - Introduction to SQL Functions, Expressions, and Predicates - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1145-171K
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.

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