You can apply k-means clustering to partition data points into k different groups. Along with the data, the number of clusters "k" is an input to the algorithm. Common examples like the Iri… (View Post)

Vertica 9.1 adds User-Defined Transform Function (UDTF) support for Python UDx, allowing you to add a much greater range of existing libraries and functions to Vertica. In this example, I'll add Fast… (View Post)

This tip expands on the earlier post on encoding and compression at https://www.vertica.com/blog/checking-and-improving-column-compression-and-encoding/ When you have millions to billions of rows, da… (View Post)

Issue is that Vertica requires certain TCP and UDP ports, but the installation script lacks the logic to check all possible iptables rules to make sure they are valid. Please review the network requi… (View Post)

Since there are no databases defined in admintools.conf, the following should work (tested on AWS): sudo /opt/vertica/sbin/install_vertica -s '172.16.133.46' --clean --rpm 'vertica-10.0.0-0.x86_64.RH… (View Post)