Vertica Blog

Vertica Blog

Vertica Concepts

Three 3D arrows, different colors pointing in different directions

Create and Assign Roles

Phil Molea, Sr. Information Developer, Vertica
March 30, 2017

A role is a collection of privileges that can be granted to one or more users or roles. Assigning roles prevents you from having to manually grant sets of privileges for each individual user. For the most part, creating and assigning roles is fairly straightforward. However, the user to which roles are assigned needs to...

Filtering Data While Loading into Vertica

Sarah Lemaire, Manager, Vertica Documentation
March 22, 2017

Suppose you have a CSV file and you want to copy some, but not all, of its contents into a Vertica table. There are two ways you can to do this: • Use the SKIP keyword with COPY. • Use the head or tail Linux command. Let's see how this works. The Data Here's a...

Dynamic Row and Column Access Policies

Phil Molea, Sr. Information Developer, Vertica
March 1, 2017

The content of this blog post is based on an article authored by Maurizio Felici. The Vertica Analytic Database access policies act on columns and rows to provide extra security on data in your tables. You can create flexible access policies that limit which users can access certain data by applying the access policy to...
Modern Database Analytics

LDAP and User Accounts

Soniya Shah, Information Developer
January 30, 2017

This blog post was authored by Soniya Shah. If you are a database administrator, you probably need to authenticate users in Vertica. There are many methods users can use to authenticate, including Ident, Kerberos, LDAP, and hash. This blog walks you through the steps to take if you want to authenticate some users using LDAP...

The Life of a Query, According to Henry Ford

Vertica Technical Team
January 10, 2017

Modern Database Analytics

Redesigning Projections for Query Optimization

Vertica Technical Team
November 9, 2016

When you submit a query to Vertica, the Vertica query optimizer automatically assembles a query plan, which consists of a set of operations to compute the requested result. Depending on the properties of the projections defined in your database, the query optimizer can choose faster and more efficient operations. Thus, it?s important to recognize what...

Troubleshooting Vertica Query Performance with System Tables

Sarah Lemaire, Manager, Vertica Documentation
August 29, 2016

Do you want to learn how to troubleshoot your query performance issues?  We've got you covered. Just attend
Modern Database Analytics

Vertica Joins: A Refresher

Sarah Lemaire, Manager, Vertica Documentation
February 23, 2016

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.

Tell the Optimizer You Have a Better Plan

Michael Kronenberg
December 17, 2015

You're upgrading your database and some query appears to execute less efficiently than before. What can you do? Vertica addresses this concern in Vertica 7.2 with directed queries