1.0 - 8.00 - LARPredict Example 2: Model ('diabetes_lasso') - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.0
8.00
Release Date
May 2019
Content Type
Programming Reference
Publication ID
B700-4003-098K
Language
English (United States)

Input

SQL Call

SELECT * FROM LARPredict (
  ON diabetes_test AS data PARTITION BY ANY
  ON diabetes_lasso AS model DIMENSION
  USING
  CoefMode ('step')
  CoefPositions (1.6)
  ResponseColumn ('y')
) AS dt ORDER BY id;

Output

id age sex bmi map tc ldl hdl tch ltg glu y prediction_1.6
3 0.0852989 0.0506801 0.0444512 -0.00567061 -0.0455994 -0.0341945 -0.0323559 -0.00259226 0.00286377 -0.0259303 141 153.737
6 -0.0926955 -0.0446416 -0.0406959 -0.0194421 -0.0689906 -0.0792878 0.0412768 -0.0763945 -0.0411804 -0.0963462 97 150.666
8 0.0635037 0.0506801 -0.00189471 0.0666297 0.0906199 0.108914 0.0228686 0.0177034 -0.0358167 0.00306441 63 152.065
13 0.0162807 -0.0446416 -0.02884 -0.00911348 -0.00432087 -0.00976889 0.0449585 -0.0394934 -0.0307512 -0.0424988 179 151.093
... ... ... ... ... ... ... ... ... ... ... ... ...
440 0.0417084 0.0506801 -0.0159063 0.0172819 -0.0373437 -0.0138398 -0.0249927 -0.0110795 -0.0468795 0.0154907 132 151.56
442 -0.0454725 -0.0446416 -0.0730303 -0.0814138 0.0837401 0.0278089 0.173816 -0.0394934 -0.00421986 0.00306441 57 149.499