Database Server Room

Eon Mode Beta Overview in 9.0.1

Soniya Shah, Information Developer
January 16, 2018

This blog post was authored by Soniya Shah. What is Eon Mode Beta? In Vertica 9.0.1, Eon Mode Beta, the separation of compute and storage, continues on Amazon Web Services S3. Eon Mode Beta was introduced in Vertica 9.0 to capitalize on cloud economics, while still enjoying the fast query processing for which Vertica is...

Vertica Quick Tip: Generating a Random Date

Soniya Shah, Information Developer
January 16, 2018

This blog post was authored by Jim Knicely. I can easily generate a random integer value using the Vertica built-in RANDOMINT function. For example: But what if I need a random date? Luckily in Vertica I can create my own SQL function for that! Example