7.00.02 - SQL-MapReduce Call - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
Last Update
2018-04-17
SELECT * FROM CoxPredict (
  ON lungcancer_coef AS cox_coef_model DIMENSION
  ON (SELECT id, name, karno * (1.1) as karno,
             diagtime * (1) AS diagtime,
             age * (0.9) AS age
        FROM lc_new_predictors) AS predicts
      ) PARTITION BY 1
  Predict_Feature_Names ('karno', 'diagtime', 'age')
  Predict_Feature_Units_Columns ('karno', 'diagtime', 'age')
  ACCUMULATE('id', 'name')
) ORDER BY 1, 2, 3, 4, 5, 6;