Vertica Quick Tip: Remove Duplicate Values from a String

This blog post was authored by Jim Knicely. Ever wonder how to get rid of those pesky duplicate values from a string? One way of doing that is via the REGEXP_REPLACE function. Have Fun!
Diagram of Vertica compute and storage together in Enterprise Mode and storage centralized, and compute separate in Eon Mode

Introducing the Eon Mode Concept

Vertica was born at a tipping point in the world of Enterprise Data Warehouses. It was designed from the first line of code to address new levels of data volumes and analytical performance. But it was also designed to break the tightly integrated hardware and software appliances offered by industry leaders at the time including...