Vertica Blog

Vertica Blog

Series

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.

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.

Time Series Analytics: The Hunt for “Missing Link” in Data

Sarah Lemaire, Manager, Vertica Documentation
May 12, 2015

Time series analytics is a little-known, but very powerful Vertica tool. In Vertica, the TIMESERIES clause and time series aggregate functions normalize data into time slices. Then they interpolate missing values that fill in the gaps.Using time series analytics is useful when you want to analyze discrete data collected over time, such as stock market...