Vertica Blog

Vertica Blog

Artificial Intelligene

SQL Query Optimization

Improving COUNT DISTINCT Performance with Approximate Functions

A common analytic use case is to find the number of distinct items in a data set. Vertica performs well at solving COUNT DISTINCT in a few ways. Since Vertica stores all data in columns, it is possible to optimize for COUNT DISTINCT by building a projection that is tuned for this use case. Vertica...

IoT Data and AI Summit

Previously known as IoT Data Analytics & Visualization, the IoT Data & AI Summit is the first dedicated event to bringing the value of Artificial Intelligence and IoT together. During the event, join technical sessions exploring IoT Data and AI technologies and network with a targeted audience to make high quality, relevant connections. This focused...