R-Vertica in-database predictive analytics

Moderator: NorbertKrupa

Post Reply
Posts: 3
Joined: Tue Apr 26, 2016 3:00 pm

R-Vertica in-database predictive analytics

Post by KalpeshJ » Tue Apr 26, 2016 3:31 pm

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.

User avatar
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am

Re: R-Vertica in-database predictive analytics

Post by JimKnicely » Thu Mar 02, 2017 5:05 pm


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.

Post Reply

Return to “Vertica Analytics”