1.1 - 8.10 - GLML1L2Predict Example: LASSO, Family ('GAUSSIAN') - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)

Input

SQL Call

SELECT * FROM GLML1L2Predict (
  ON housing_test PARTITION BY ANY
  ON housing_model AS Model DIMENSION
  USING
  Accumulate ('sn')
) AS dt ORDER BY sn;

Output

 sn  prediction         
 --- ------------------ 
  13 37345.831973269815
  16  43687.09059862308
  25  40902.03654672491
  38  72487.79993489318
  53  79238.81946777017
 104 111527.51245186775
 111  39102.91738815808
 117  66936.75897612597
 132  41819.94760124324
 140  41611.84919994215
 142  44394.19887061475
 157  66571.23189229079
 161  64900.96267762861
 162 107758.84817140205
 176   73438.6189187027
 177  62378.41894444322
 195 37197.885003565505
 198  47307.96151089168
 224  67232.91218470069
 234  35237.08241678744
 237   46593.6202622758
 239  43377.85857200969
 249 37863.799887728994
 251  45096.43470435488
 254  74665.80555260641
 255 60214.195570911885
 260  43066.25992025624
 274  67232.40606270777
 294  38987.53125475488
 301 55621.583411818116
 306  67339.67883609686
 317  65655.23197768882
 329 123611.91388294056
 339 126281.82379649683
 340  58474.80959843659
 353  67485.79160065402
 355  68425.99104737997
 364  77422.31599327197
 367 128556.01523545264
 377 127201.67378365475
 401  84040.85339019273
 403  79857.24053097825
 408   76218.4796684783
 411  78179.19706290774
 440   80549.3290271716
 441  64670.20979822652
 443 61703.972586623415
 459   42818.2957274824
 463  49293.44779989387
 469  61779.16835629488
 472  63766.92478426945
 527 119762.09345887038
 530  116119.0226758564
 540  73146.29611369228

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