We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


R integration with Vertica for Machine Learning — Vertica Forum

R integration with Vertica for Machine Learning

Hi Folks, Greetings.

I have a doubt regarding R integration with Vertica.

Brief Description: I have large datasets on vertica and I need to build predictive models using ML. I am well versed with R and would love if could run R queries on Vertica DB. There are three ways to do this:

1) Get the datasets from Vertica to local ad build the models -- Not feasible for my case.

2) Connect to vertica through R. Run SQL queries through R IDE on vertica DBs.

3) Connect to Vertica, run R based queries and develop the model on Vertica itself. Deploy the model to test population thereafter.

I am looking for some help in executing option3. Can anyone shed some light into this. Also, would request to pardon me if my understanding about the subject so far is incorrect.

Thanks
Suryakant

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file