Page 1 of 1

R-Vertica in-database predictive analytics

Posted: Tue Apr 26, 2016 3:31 pm
by KalpeshJ
Hello ,

I have a readily available R Prediction script with me that predicts with the help of Machine Learning algorithm written by me.
Now, I want to test its applicability in Vertica.
I have installed R-Vertica Lang package in my linux machine and also made everything ready to run.

My Question:
Is it possible to run the R-script in vertica for in-database predictive analytics.
We should use those that are readily available only for use.

Note: I have tried many approaches but i am yet to get through it.
Also, I have successfully pulled data from Vertica into R and did prediction.
Now, I want to go reverse and run the R-script in vertica database.

Any help on this would be greatly appreciated.

Thank You.

Re: R-Vertica in-database predictive analytics

Posted: Thu Mar 02, 2017 5:05 pm
by JimKnicely

You can develop UDSFs and UDTFs in R in Vertica.

See: ... ionInR.htm

Also, check out vertica.dplyr.

See: ... a-p230857/ and ... a-p231415/

Also, Vertica has built-in predictive analytics that you may be able to leverage.

See: ... arning.htm