Vertica Tip: Predicting the Resources a Statement Needs

Soniya Shah, Information Developer
February 5, 2018

This blog post was authored by Eugenia Moreno. You may find you want to set up resource pools before running queries to know how many resources a particular query needs. One way to do this is to create a small resource pool, profile the query, and note when the query is rejected. When the query...
Three 3D arrows, different colors pointing in different directions

Beware of Segmentation Islands

Soniya Shah, Information Developer
February 5, 2018

This blog post was authored by Curtis Bennett. Many clients who are new to Vertica are also new to big data. While Vertica’s reliance on industry-standard SQL can make the transition very easy, often the introduction of multiple nodes used in support of a database platform can take some getting used to. It is the...

Vertica Quick Tip: Dynamically Split Up a String

Soniya Shah, Information Developer
February 1, 2018

This blog post was authored by Jim Knicely. One of my favorite functions in Vertica is named SPLIT_PART. It splits up a string into parts by a given delimiter. But what if I don’t know how many parts there are in my text? As the following example shows, I can use the ROW NUMBER analytic...

Subscribe For Email Updates

Sign-up and select Vertica in your preferences to receive our monthly Vertica newsletter.

Sign-up