myVertica  

Vertica Blog

aggregate

What’s New in 7.2.3: Automatic Live Aggregate Projection Usage in DISTINCT Queries

HPE Vertica 7.2.3 extends the functionality of using appropriate live aggregate projections with queries to include queries with SELECT DISTINCT and DISTINCT-qualified aggregate functions.

Improving COUNT DISTINCT Performance with Live Aggregate Projections

Today’s organizations need to be able to measure the effectiveness of online ads and marketing campaigns. In your particular organization, you may want to measure how effectively your ads drive unique visitors to your website. Or you may want to see if your ads drive repeat visits from the same user over a specific period of time.

Live Aggregate Projections with Vertica

The Dragline release of HP Vertica offers an exciting new feature that is unique in the world of big data analytics platforms. We now offer Live Aggregate projections as part of the platform. The impact is that you can really fly through certain types of big data analytics that typically grind down any analytics system.