Vertica Blog

Vertica Blog

Tables

Global Partitions

Optimizing Vertica Data With Partitions

Bryan Herger, Vertica Big Data Solution Architect at Micro Focus
February 20, 2020

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

Drea Brandford, Technical Consultant
November 21, 2019

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

Moshe Goldberg, Vertica System Engineer
May 22, 2017

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

Sarah Lemaire, Manager, Vertica Documentation
March 23, 2016

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

BD_Partner_Eng
December 8, 2015

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

Ben Vandiver
February 14, 2014

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

Steven Sarsfield, Vertica Senior Product Marketing Manager – Partner Ecosystem
January 30, 2014

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

Ben Vandiver
January 22, 2014

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

Ben Vandiver
January 15, 2014

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

Ben Vandiver
January 13, 2014

With our