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.


Leave a Comment

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