Skip to main content
Question

Linear Regression on queries

  • December 16, 2024
  • 0 replies
  • 3 views

joergschaber
Forum|alt.badge.img+2

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!