In Vertica 8.0.1, we’ve added a function called DETECT_OUTLIERS, which lets you identify data points outside a specified threshold. In general, before you analyze your data, you should remove any outliers from the data set. Outliers are data points that greatly differ from other similar data points. Leaving the outlying points in the data set could skew your results.
Check it out here:
https://my.vertica.com/blog/whats-new-i ... detection/
