Input
The input table is housing_test, as in GLMPredict Example 2: Gaussian Distribution Prediction.
The model table is housing_model, output of GLML1L2 Example 3: LASSO, Family ('GAUSSIAN').
SQL Call
SELECT * FROM GLML1L2Predict ( ON housing_test AS "input" PARTITION BY ANY ON housing_model AS model DIMENSION USING Accumulate ('sn') ) AS dt ORDER BY sn;
Output
sn | prediction |
---|---|
13 | 34523.2060421084 |
16 | 34385.6742030422 |
25 | 38079.4071964247 |
38 | 46635.4835636205 |
53 | 49798.1961497214 |
104 | 48789.6405757176 |
111 | 39102.9373259596 |
117 | 41776.2197819973 |
132 | 38997.3051608534 |
140 | 38789.2075274234 |
... | ... |