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.
Or
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.
Kalpesh
R-Vertica in-database predictive analytics
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: R-Vertica in-database predictive analytics
Hi,
You can develop UDSFs and UDTFs in R in Vertica.
See: https://my.vertica.com/docs/8.0.x/HTML/ ... ionInR.htm
Also, check out vertica.dplyr.
See: https://my.vertica.com/blog/announcing- ... a-p230857/ and https://my.vertica.com/blog/vertica-dpl ... a-p231415/
Also, Vertica has built-in predictive analytics that you may be able to leverage.
See: https://my.vertica.com/docs/8.0.x/HTML/ ... arning.htm
You can develop UDSFs and UDTFs in R in Vertica.
See: https://my.vertica.com/docs/8.0.x/HTML/ ... ionInR.htm
Also, check out vertica.dplyr.
See: https://my.vertica.com/blog/announcing- ... a-p230857/ and https://my.vertica.com/blog/vertica-dpl ... a-p231415/
Also, Vertica has built-in predictive analytics that you may be able to leverage.
See: https://my.vertica.com/docs/8.0.x/HTML/ ... arning.htm
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.