GLML1L2Predict Example: Ridge Regression, Family ('BINOMIAL') - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.10
1.1
Published
October 2019
Language
English (United States)
Last Update
2019-12-31
dita:mapPath
ima1540829771750.ditamap
dita:ditavalPath
jsj1481748799576.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

Input

The input table is admissions_test, as in GLMPredict_MLE GLMPredict_MLE Example: Logistic Distribution Prediction.

The model table is admissions_model, output of GLML1L2 Example: Ridge Regression, Family ('BINOMIAL').

SQL Call

SELECT * FROM GLML1L2Predict (
  ON admissions_test PARTITION BY ANY
  ON admissions_model AS Model DIMENSION
  USING
  OutputProb ('true')
  Accumulate ('id')
) AS dt ORDER BY id;

Output

 id prediction prob                
 -- ---------- ------------------- 
 50        0.0 0.42261164778201094
 51        0.0  0.4049408918235976
 52        1.0  0.6791731064692488
 53        1.0  0.6128348254047428
 54        1.0  0.6321200551583135
 55        1.0  0.8635298008802573
 56        1.0  0.8639684744611825
 57        1.0  0.8589345247253525
 58        1.0  0.8297786450140937
 59        1.0  0.8421968614075399
 60        1.0  0.8624268462528424
 61        1.0  0.6575556307139581
 62        1.0  0.8584692566063056
 63        1.0  0.8644185196041072
 64        1.0      0.640966603964
 65        1.0  0.6488695133874245
 66        1.0   0.693208669498573
 67        0.0 0.35267304201513183
 68        1.0  0.7347418494287773
 69        1.0  0.8701555291596779

Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.