Overview

Teradata Vantage™ SQL Functions, Expressions, and Predicates

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

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