Query Execution in Eon Mode

Soniya Shah, Information Developer
February 7, 2018

This blog post was authored by Ben Vandiver. How Vertica distributes query processing across the cluster in Eon mode is a complex topic that is best illustrated through a concrete example. As part of this post, we'll start with a simple data load and walk through metadata storage and query execution. To begin, we need...

Vertica Quick Tip: Superfast Table Copy

Soniya Shah, Information Developer
February 7, 2018

This blog post was authored by Jim Knicely. Very often we need to make a copy of a very large table in order to do some development or quality assurance type of duties. Typically we’ll use a CREATE TABLE AS SELECT (CTAS) statement to make that copy. But that took a very long time (~...