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.

Improving COUNT DISTINCT Performance with Live Aggregate Projections

Today?s organizations need to be able to measure the effectiveness of online ads and marketing campaigns. In your particular organization, you may want to measure how effectively your ads drive unique visitors to your website. Or you may want to see if your ads drive repeat visits from the same user over a specific period of time.

Jump Start your BI Dashboard Development

Do you develop BI dashboards for Vertica? Or would you like to give it a try?

Installing Vertica SQL on Hadoop

Interested in adding Vertica’s analytic capabilities to your Hadoop cluster? Watch this tutorial video to learn how you can install Vertica on Hadoop, giving it faster access to your data!

What are Vertica Engineers Reading?

Ever wonder what Vertica engineers do when they aren?t busy building and perfecting an awesome product?

Tell the Optimizer You Have a Better Plan

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

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 Looker Discourse, has published three articles that explain how to use Looker with these Vertica features: ORC reader, Flex tables, and Geospatial functions and data

Data-Centric Security: Vertica and SecureData

Take advantage of the recent integration of Vertica and SecureData. This integration allows you to keep your data protected when it flows across multiple systems spread across multiple data centers on premise or in the cloud.

Restoring Objects from a Full Backup

Before Vertica version 7.2, you had two options: perform full backups and restore full backups (remove everything from the storage unit) or perform object-level backups and restore those individually (maintain separate storage units). But as of Vertica 7.2, you can have the best of both worlds. You can perform full backups and restore individual objects from that backup! This means you don?t have to waste time and resources on restoring data that you do not need at the moment.