Vertica Blog

Sarah Lemaire

Manager, Vertica Documentation

Do You Need to Put Your Query on a Budget?

Before we scare you away with the word "budget", rest assured that after reading this blog, you won?t have to give up your favorite activities or sell your car. What you will be able to do is understand how Vertica resource pool parameters affect query budget.

Analyze Mismatched Series with Event Series Joins

Event series occur in tables with a time column, most typically a TIMESTAMP data type. In Vertica, you perform an event series join to analyze two series in different tables when their measurement intervals don't align, such as with mismatched timestamps.

Which One of These is Not Like the Others?

With the new guaranteed uniqueness optimization feature in Vertica 7.2.2, Vertica automatically recognizes when a query is accessing columns with unique values and optimizes the query operations that would otherwise be bogged down due to duplicate values.

Classified: FAQs on Access Policies

In Vertica 7.2.2 we?ve added more security features, including a row-level access policy option. Combined with our previously existing column access policy, Vertica verifies that your data is more secure than ever.

Watch Machine Learning for Predictive Analytics in Action

Watch this video to learn more about the Vertica Machine Learning for Predictive Analytics features new in 7.2

Identifying Patterns in Your Data with Event Series Pattern Matching – Part 1

Vertica's event series pattern matching functionally lets you identify events that occur is specific patterns. In this blog, we'll introduce you to the pattern matching key features.

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.

Vertica Meetup: Sponsored by DataGals

Join us in Cambridge, MA to watch Code: Debugging the Gender Gap

It’s All About Timing

Every so often we hear about the seemingly confusing nature of SQL functions that return the “current” time. But what is “current”? Is it the start time of a transaction or statement? Is it the time returned by the system clock? The answer is: all of these, depending on which function you call.
Three 3D arrows, different colors pointing in different directions

Looking Under the Hood at Vertica Queries

When you submit a query to Vertica, you want it to execute as quickly and efficiently as possible. The query optimizer creates a plan that is designed to do just that. The directives in the query plan determine your query's run-time performance and resource consumption, but the properties of your projections and the system parameters also impact...

On the Trail of a Red-Tailed Hawk!

Read how we used User-Defined-Loads to track the habits of the red-tailed hawk!

Vertica Joins: A Refresher

As a Vertica user, you know that using joins can improve query performance by combining records from one or more tables. But sometimes, you need to develop complex joins. Vertica supports many different kinds of joins that perform different functions based on your needs.