General Utility Functions | Teradata Vantage - General Utility Functions - Teradata Vantage

Database Unbounded Array Framework Time Series Functions

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-04-04
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743

Utility functions provide services that validate or return metadata about series or matrices stored in input tables, extract results from multi-layered analytic results table (ART) table, provide plotting support, and support conversion of a table to a form that is usable as a source for another function.

Function Description
TD_SINFO Returns metadata that describes a logical series.
TD_COPYART Creates a copy of an existing ART.
TD_EXTRACT_RESULTS Retrieves auxiliary result sets stored in an ART.
TD_FILTERFACTORY1D Creates finite impulse response (FIR) filter coefficients.
TD_IMAGE2MATRIX Converts JPEG or PNG images to matrixes with payload values being the pixel values.
TD_INPUTVALIDATOR Validates data and finds indiscreet data that was passed to a series or matrix.
TD_ISFINITE Evaluates a variable or expression to determine if it is a finite floating value.
TD_ISINF Evaluates a variable or expression to determine if it is an infinite floating value.
TD_ISNAN Evaluates a variable or expression to determine if it is a NaN (Not-a-Number) value.
TD_MINFO Returns metadata that describes a logical matrix.
TD_PLOT Provides the ability to generate on-demand plots. The generated plots can be either univariate, multivariate, or composite in nature.
TD_CONVERTTABLEFORUAF Converts an input table consisting of valid data types into a table whose data layout is compatible with UAF series or matrix specifications. This function is a SQL-MR table operator.
TD_TRACKINGOP Uses geospatial coordinates to track an object and compute such metrics as trip distance, speed, time, and so on.