scikit-learn integration

Kaito

Does anyone have experience to integrate Vertica with scikit-learn? Any limitation?

Jim_Knicely

According to an article in Conflunce (Deploy Scikit-learn model to Vertica and run scoring/prediction), Vertica 9.1 will have this functionality:

• Python models can be imported into Vertica and replicated across the cluster.
• User is able to run the model to do scoring on data inside Vertica without any data movement.
• User can view all the models imported from Python just like she can view models built in-db.

Kaito

Thank you, Jim. I have checked JIRA. Looks like it includes in Version 10. Thanks always!

Lanene

Perhaps this question can be answered by experts who have experience with scikit-learn

SruthiA

@Lanene : one can use verticaPY and then use it to access scikit learn API

https://docs.vertica.com/23.4.x/en/data-analysis/ml-predictive-analytics/

https://www.vertica.com/python/about.php