Vertica Blog

Vertica Blog


Global Partitions

Optimizing Vertica Data With Partitions

How do partitions affect overall Vertica operations? Let’s look at a snapshot of the Flight Data Tracker dataset and compare performance ...

Announcing Vertica 9.3 Instructor-Led Training Courses

Just in time for the release of version 9.3, Vertica is pleased to announce the release of two updated instructor-led training courses: Vertica 9.3 Essentials and Vertica 9.3 Descriptive Analytics. A description of each course follows: Vertica 9.3 Essentials This 4-day course explores the capabilities of the Vertica platform solution in Enterprise mode, and prepares...

Use MERGE to Update 1 Million Rows in 2 Seconds

This blog post was co-authored by Yassine Faihe, Michael Flower, and Moshe Goldberg. Updating One Million Records in Two Seconds To illustrate the true power of MERGE, this article describes how we used MERGE to demonstrate Vertica's performance at scale. SQL MERGE statements combine INSERT and UPDATE operations. They are a great way to update...

Rebalance a Large Partitioned Table

Your organization is collecting data as fast as your Vertica cluster can store it, so fast that you need to add a few nodes to your cluster. After you add those nodes, Vertica must distribute the data across all the existing and new nodes for best performance. We call this operation rebalancing.

Using Looker to Leverage Vertica Capabilities: ORC Reader, Flex Tables, and Place

Want some hints about how to use Looker to visualize data in your Vertica database? The Looker user community, known as

Enter the Flex Zone – Under the Hood

With Vertica's latest release (Vertica 7 Crane"), we introduced Vertica Flex Zone, based on the patent-pending flex tables technology, which dynamically adapt to whatever schema is present in the data. Flex tables offer dramatic usability improvements over regular tables. In this post, we take a look under the hood and show how flex tables are...

Enter the FlexZone – Let’s talk ETL

In December, HP released version 7 of the Vertica analytics platform which includes, among others, a great new feature called Vertica Flex Zone (Flex Zone). Flex Zone enables you to quickly and easily load, explore and analyze some forms of semi-structured data. It eliminates the need for coding-intensive schemas to be defined or applied before...

Enter the Flex Zone – Exploring Delimited Data

Here at Vertica, we had to solve a technical challenge that many of you might be facing: data analysis from legacy products.

Welcome to the Flex Zone – Dynamic Schemas

Much of the data analytics we perform occurs with data whose schema changes over time. Many organizations have developers who define the record types that are collected and analysts who comb through these records looking for important patterns. In today's fast-changing business landscape, agility is the key to success: developers need to continually define new...

Enter the Flex Zone –– An Exploration in Processing Twitter Data

With our