This blog post was authored by Vincent Xu.
Vertica 9.0 is out and here is the updated Vertica machine learning cheat sheet
Vertica 9.0 introduces a slew of new machine learning features including one-hot encoding, Lasso regression, cross validation, model import/export, and many more. See the cheat sheet for examples of how to use the new functions.
Vertica Machine Learning provides SQL functions that support the complete machine learning workflow—from cleaning your data to training a model to evaluating model performance. Vertica machine learning is fast and scalable along the sizes of data samples, features, and computing cluster. Best of all, no data movement is necessary. You can accomplish model training, testing, and scoring at one place, Vertica.
To learn the full capabilities of each function, please refer to the Vertica documentation