Input
- Input table: housing_test, as in GLMPredict_MLE Example: Gaussian Distribution Prediction
- Model: housing_model, output of GLML1L2 Example: LASSO, Family ('GAUSSIAN')
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.