4 ms·
Only logistic and linear regression for now. For use cases it covers, this will save a lot of plumbing.
by mooneater 8y ago
Only logistic and linear regression for now. For use cases it covers, this will save a lot of plumbing.
- Karrot_Kream 8y agoIndependent of DL, I'm curious why these two regression cases haven't been made available in a SQL-like interface until now. Kudos to Google for putting this in the hand of folks who otherwise just use SQL.
- mark_l_watson 8y agoGood point! I wouldn’t be surprised to see a Postgres plugin for this. Wouldn’t get the vast scalability but it would offer convenience.
- ximeng 8y agohttps://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-STATISTICS-TABLE https://www.postgresql.org/docs/current/static/functions-agg...
- YurtleTheTurtle 8y agoOracle has had linear regression for well over a decade now.
- cottonseed 8y agoLinear regression makes a lot of sense since it can be done streaming in a single pass. We have it as an aggregator in Hail: https://hail.is/docs/devel/aggregators.html#hail.expr.aggregators.linreg https://hail.is/docs/devel/aggregators.html#hail.expr.aggreg... I wonder how they're doing logistic regression. It doesn't have a closed form and normally solved with an iterative, multi-pass optimization. edit: Read more closely. They're using (non-stochastic) batch gradient descent.