Vertica Blog

Vertica Blog

time series data

How to Group Timeseries Data at Any Granularity

Marco Gessner, Field Chief Technologist
August 15, 2023

You might have come across this. You would have obtained a huge set of time stamped log data or sensor data that you would like to understand. Millions of rows are nothing for human consumption - and far too much for plotting on a monitor that just has a few thousand pixels across - why...

How To Filter a Behavioral Pattern in a Time Series

Marco Gessner, Field Chief Technologist
July 14, 2023

Behavioral patterns in time series are something that many analysts are keen to find in time series. A clickstream analyst wants to find the series of clicks that happened between coming to the website, browsing one or more articles in the web site, and finally filling the basket and checking out; a financial analyst wants...

When the typewriter is broken: Vertica’s Event-Based Windows to the rescue

Mark Whalley, Manager, Vertica Education
July 18, 2022

Those of you who read my blog post “Take nothing but memories. Leave nothing but footprints” may recall my passion for using Raspberry Pi computers to capture IoT data from aeroplane transponders and GPS satellites, then feeding that streaming data into Apache Kafka and to integrate it with Vertica and perform near real-time analytics and...