7.00.02 - SQL-MapReduce Call - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)

This query uses the PCAPlot function to compute the first three score variables, which correspond to the first three principal components, accumulating the response variable from the original input data table patient_pca_input:

CREATE DIMENSION TABLE pcr1 AS
SELECT * FROM PCAPlot (
  ON pca_scaled AS inputtable PARTITION BY ANY
  ON pca_health_ev2 AS pca_table DIMENSION
  Accumulate ('pid', 'strokes')
  Components ('3')
) ORDER BY 1;