REGR_AVGX Support for UDTs
UDTs are only supported on the Block File System on the primary cluster. They are not available for the Object File System.
By default, Vantage performs implicit type conversion on UDT arguments that have implicit casts that cast between the UDTs and any of the following predefined types:
- Numeric
- Character
- DATE
- Interval
Implicit type conversion of UDTs for system operators and functions, including REGR_AVGX, is a Teradata extension to the ANSI SQL standard.
Defining Axes in REGR_AVGX for Plotting
If you export the data for plotting, define the y-axis (ordinate) as the dependent variable and the x-axis (abscissa) as the independent variable.
REGR_AVGX with Other Functions
REGR_AVGX can be combined with ordered analytical functions in a SELECT list, QUALIFY clause, or ORDER BY clause. See Window Aggregate Functions.
REGR_AVGX cannot be combined with aggregate functions within the same SELECT list, QUALIFY clause, or ORDER BY clause.