SQL-MapReduce Call - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1022
Product Category
Software

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;