Vertica Blog

Vertica Blog

Analytics

Investigating Public Data: Road Safety in the U.K.

BD_Partner_Eng
October 11, 2016

When learning new database applications, a good place to start is with some compelling, real-world data. It's not necessarily so easy to find.

Analyze Mismatched Series with Event Series Joins

Sarah Lemaire, Manager, Vertica Documentation
June 20, 2016

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

Watch Machine Learning for Predictive Analytics in Action

Sarah Lemaire, Manager, Vertica Documentation
April 27, 2016

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

Sarah Lemaire, Manager, Vertica Documentation
April 20, 2016

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

Chana Zolty
April 14, 2016

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...

It’s All About Timing

Sarah Lemaire, Manager, Vertica Documentation
March 15, 2016

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

Sarah Lemaire, Manager, Vertica Documentation
March 2, 2016

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!

Sarah Lemaire, Manager, Vertica Documentation
February 25, 2016

Read how we used User-Defined-Loads to track the habits of the red-tailed hawk!
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.
Programmer

Improving COUNT DISTINCT Performance with Live Aggregate Projections

HPBigData_BP
February 17, 2016

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

Using Big Data Analytical Tools for Predicting Potential Global Distribution of an Amphibian Pathogen

Sarah Lemaire, Manager, Vertica Documentation
September 9, 2015

During the summer of 2015, I participated in an internship program with Vertica. Most interns assisted in software development, but my primary goal was to use Vertica, Vertica Place, and HP Distributed R to address an ecological problem

The Benefits of Single Node Queries

Sumeet Keswani
August 19, 2015

If your organization deals with low latency, high concurrency applications and queries, you can benefit from having as few nodes as possible involved in each query.