Machine Learning in Google Bigquery

Re:Machine Learning in Google Bigquery by mooneater on Wednesday July 25, 2018 @02:17PM (#17611482)

Only logistic and linear regression for now. For use cases it covers, this will save a lot of plumbing.

[ Parent | on HN ]

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 ]