Linear Regression on queries

joergschaber

Hi,

is there a simple way to make a linear regression on SELECT - statements, like, e.g.

WITH train AS (SELECT response, predictor FROM ....)
SELECT LINEAR_REG('linear_reg', 'train', 'response', 'predictor ' USING PARAMETERS optimizer='BFGS', fit_intercept=true);

This way I could make many regressions without having to create extra Views or Tables for each statement.

Thanks!