MLINREG Function Syntax | Teradata Vantage - 17.10 - MLINREG Function Syntax - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1145-171K
Language
English (United States)
MLINREG ( value_expression, width, sort_expression [ ASC | DESC ] )

Syntax Elements

value_expression
The expression cannot contain any ordered analytical or aggregate functions.
width
The number of previous rows to be used in the computation.
The value is always a positive integer literal.
The maximum is 4096.
sort_expression
A column expression that defines the independent variable for calculating the linear regression.
For example, MLINREG(Sales, 6, Fiscal_Year_Month ASC), where Sales is the value_expression, 6 is the width, and Fiscal_Year_Month ASC is the sort_expression.
The data type of the column reference must be numeric or a data type that Vantage can successfully convert implicitly to numeric.
ASC
Ascending sort order.
DESC
Descending sort order.