TD_CONVERTTABLEFORUAF Function | Teradata Vantage - TD_CONVERTTABLEFORUAF - Analytics Database - Teradata Vantage

SQL Operators and User-Defined Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-05
dita:mapPath
xub1628111590556.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
drp1544241916620
lifecycle
latest
Product Category
Teradata Vantage™

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