Vertica Blog

Vertica Blog

Vertica Blog

Intern Lunch with Vertica GM

Last week, the interns had lunch with the General Manager, Colin Mahony. The lunch started with everyone introducing themselves, and we've come to know that Colin impressively remembers everyone's names. We shared lunch over a casual round-table discussion. We even got to enjoy a slice of cake afterwards.
Database Server Room

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.

Jump Start your BI Dashboard Development with Vertica

Do you develop BI dashboards for Vertica? Or would you like to give it a try? To help you get started, the Vertica Partner Engineering team has created a set of QuickStart BI sample apps. You can download them for free from the

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.

Jump Start your ETL Application Development with Vertica

Interested in exploring the Vertica Analytic Database in the context of data movement and transformation? To get a feel for it, try our new ETL QuickStart sample apps. You'll find them on the Big Data Marketplace. Our Partner Engineering team develops QuickStart apps using tools from our technology partners. Currently we have ETL QuickStarts for...

A Day in the Life of a Vertica Intern

When I set out to find an internship for the summer, I was afraid that I would inevitably end up in a position where my primary responsibility was to fetch coffee. Fortunately for me, my first day on the job at Vertica proved that this would not be the case.

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.
Modern Database Analytics

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
Programmer

Vertica Champions Diversity

On Thursday, April 14, the Microfocus DataGals** hosted a free screening of the award winning documentary Code: Debugging the Gender Gap in Cambridge, MA.

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.
Database Server Room

Learn More From Your Data with Machine Learning Algorithms

NOTE: This article refers to Vertica 7.x and is considered outdated.  This article is more relevant to later Vertica versions. New in Vertica 7.2.2 is the Machine Learning for Predictive Analytics package. This analytics package allows you to use built-in machine learning algorithms on data in your Vertica database. Machine learning algorithms are extremely valuable in...