News for hackers. Stuff that matters.

A comment on Machine Learning in Google Bigquery. Parent comment

Re:Machine Learning in Google Bigquery by Karrot_Kream on Wednesday July 25, 2018 @04:24PM (#17612467)
Independent 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.
[ Parent | on HN ]
Re:Machine Learning in Google Bigquery by YurtleTheTurtle on Wednesday July 25, 2018 @05:57PM (#17613273)
Oracle has had linear regression for well over a decade now.
[ Parent | on HN ]
Re:Machine Learning in Google Bigquery by cottonseed on Wednesday July 25, 2018 @08:43PM (#17614250)
Linear 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.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.

[ Parent | on HN ]
Re:Machine Learning in Google Bigquery by mark_l_watson on Wednesday July 25, 2018 @05:31PM (#17613043)
Good point! I wouldn’t be surprised to see a Postgres plugin for this. Wouldn’t get the vast scalability but it would offer convenience.
[ Parent | on HN ]
Re:Machine Learning in Google Bigquery by ximeng on Wednesday July 25, 2018 @09:31PM (#17614442)
https://www.postgresql.org/docs/current/static/functions-agg...
[ Parent | on HN ]