TD_CONVERTTABLEFORUAF Function | Teradata Vantage - TD_CONVERTTABLEFORUAF - 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
ft:locale
en-US
ft:lastEdition
2025-04-04
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743

TD_CONVERTTABLEFORUAF converts an input table consisting of valid data types to an Unbounded Array Framework (UAF) table. This function is a SQL-MR table operator. Table operators reference input tables using ON-clauses, and pass in parameters using a USING-clause, also called a custom-clause. This function supports up to three USING parameters CONTENT, TABLETYPE and ID.

UAF functions require input data in specific formats. For example, some functions require input data as a matrix where each row represents a fixed-length window of historical data, and each column represents different variables or features. Other functions require input data as a series where each element represents a single observation at a specific point in time. TD_CONVERTTABLEFORUAF converts table data into a format that can be used by other UAF functions.

The following output formats are available:
  • REAL: Real numbers, but positive and negative
  • COMPLEX: Complex numbers with real and imaginary components
  • AMPLPHASE: Complex number in polar coordinates, where the amplitude (magnitude) and phase are stored separately
  • MULTIVARREAL: Vector or array of real numbers
  • MULTIVARCOMPLEX: Vector or array of complex numbers
  • MULTIVARAMPLPHASE: vector or array of complex numbers in polar coordinates.
  • ADHOC: Data that is generated dynamically or data that does not conform to a pre-defined schema