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

Database Unbounded Array Framework Time Series Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-12-08
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_FILTERFACTORYID 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.