Input
The input table is admissions_test, as in GLMPredict GLMPredict Example 1: Logistic Distribution Prediction.
The model table is admissions_model, output of GLML1L2 Example 1: Ridge Regression, Family ('BINOMIAL').
SQL Call
SELECT * FROM GLML1L2Predict ( ON admissions_test AS "input" PARTITION BY ANY ON admissions_model AS model DIMENSION USING Accumulate('id') ) AS dt ORDER BY id;
Output
id | prediction |
---|---|
50 | 0 |
51 | 0 |
52 | 1 |
53 | 1 |
54 | 1 |
55 | 1 |
56 | 1 |
57 | 1 |
58 | 1 |
59 | 1 |
60 | 1 |
61 | 1 |
62 | 1 |
63 | 1 |
64 | 1 |
65 | 1 |
66 | 1 |
67 | 0 |
68 | 1 |
69 | 1 |