1.1 - 8.10 - Correlation Syntax Elements - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Teradata Vantage
Release Number
Release Date
October 2019
Content Type
Programming Reference
Publication ID
English (United States)
Specify pairs of columns for which to calculate correlations. For each column pair, 'col_name1:col_name2', the function calculates the correlation between col_name1 and col_name2. For each column range, '[col_index1:col_index2]', the function calculates the correlation between every pair of columns in the range. For example, if you specify '[1:3]', the function calculates the correlation between the pairs (1,2), (1,3), (2,3),(1,1),(3,3). The minimum value of col_index1 is 0, and col_index1 must be less than col_index2.
Specify the name for the CorrelationMap output table column that contains the correlations, and by which the CorrelationMap output table is partitioned.
[Optional] Specify the names of the input columns that define the group for correlation calculation. They must be the same as the columns in the input table PARTITION BY clause.
Default behavior: All input columns belong to a single group, for which the function calculates correlation.