The matrix function takes a database table and builds a matrix of the default or specified type. By default, the function builds an extended sum-of-squares-and-cross-products (ESSCP) matrix. For other matrix types, see matrixtype in Syntax.
The function generates and runs SQL that calls the Teradata Vantage CALCMATRIX table operator and returns a result set or database table.
Matrix Building reduces numeric columns in potentially huge relational tables to a comparatively compact matrix—n column become an nxn. You can input the matrix to a linear regression or factor analysis algorithm.
The matrix function must operate on numeric data. DATE columns do not produce meaningful results.