Time series Archives

goldfinch songbird in a field of thistle in Wales

Mark Whalley, Corporate Systems Engineer
March 27, 2020

For a number of years, when presenting one of my favourite Vertica demos, in which I talk about , I would typically start with a short, 30-second video clip to get the audience’s attention. The inspiration for this clip came about when I was staring aimlessly into the blue sky above my home in Pennard...

Pennard, We Have a Problem – Troubleshooting Flight Tracking with the Grafana Plugin for Vertica

Mark Whalley, Corporate Systems Engineer
February 26, 2020

With Vertica’s Management Console, I have everything I need at my fingertips to manage and monitor my Vertica clusters and databases. Whether that be investigating query performance issues, checking on the health of the cluster’s nodes, running the Database Designer or marveling at the volume of data being ingested by the Vertica Scheduler from a...

The Kafka Convergence

Paige Roberts, Vertica Open Source Relations Manager
January 20, 2020

Apache Kafka seems to be everywhere these days. I’m feeling a bit surrounded by Kafka right now, in fact, like I’m at the center of a convergence of the planets, and data flowing through Kafka is the gravitational pull. Let me give you an idea of what I mean. So, Vertica just announced the release...

Vertica on the Road! Using Vertica to Prepare and Analyze Vehicle Telematics Data

Bryan Herger, Vertica Big Data Solution Architect at Micro Focus
December 17, 2019

Vehicles generate a lot of data from onboard electronics and there is increasing interest in monitoring vehicle handling to help assess insurance risk and premiums. At Vertica, we're working with a few auto manufacturers, so I built this demo to show a relatively simple example of data collection, aggregation and preparation, and analysis of the...

Machine learning robot studying equations and graphs

In-Database Machine Learning 1 – Why Would You Do That?

Waqas Dhillon, Product Manager - Machine Learning, Vertica
April 22, 2019

Co-authored with Paige Roberts. A lot of modern like Vertica allow you to do machine learning from end to end, right in the database, rather than moving and transforming the data first into something like a Spark dataframe or a Python data structure. Whenever people hear about this capability, they have two questions. The first...

Use Time Series Analytics to Generate a List of Dates at a Specific Start Date

Jim Knicely, Vertica Principal Solution Architect
April 8, 2019

Time series analytics evaluate the values of a given set of variables over time and group those values into a window (based on a time interval) for analysis and aggregation. This feature comes in handy if I need to generate a list of dates using some interval, for example 1 MONTH. Example: But why did...

Commercial passenger plane with Vertica painted on the tail

Blog Post Series: Using Vertica to Track Commercial Aircraft in near Real-Time — Part 7

Mark Whalley, Corporate Systems Engineer
April 4, 2019

Preparing Vertica to consume messages from Kafka How time has flown (no pun intended!). At long last getting back to continuing this project on tracking commercial aircraft… Having covered ADS-B, the Raspberry Pi, DUMP1090, Zookeeper and Kafka and then in the how to develop an Extract, Transform and Load (ETL) application to present a continuous...

Vertica One on One with Davin Potts, CEO Appliomics, Founder KNIME, Core Python Committer

One on One with Davin Potts: 6. Advantages of In-Database Machine Learning

Paige Roberts, Vertica Open Source Relations Manager
March 13, 2019

At the recent Data Day Texas event, I sat down with Davin Potts and had a long conversation about a wide variety of subjects. This is the final installment of the discussion. It was a lot of fun catching up and talking shop. In this final interview post, we talked about some of the advantages of doing...

winding road into the distance with clocks on tall stands along the way

It’s Time for Time Series

Joy King, VP, Vertica Product Management & Product Marketing
February 19, 2019

Recently, as I always do, I was reading about some emerging trends in our industry and a headline popped out at me -- did you know that time series databases are one of the fastest growing specialty database platforms? That was a surprise to me, so I did a little more research. Time After Time,...

What You Never Knew About Vertica Could Surprise You

Paige Roberts, Vertica Open Source Relations Manager
December 17, 2018

I just started working on the Vertica team. As the “new guy,” my first few weeks of work have been largely about cramming as much Vertica information into my brain as possible in the shortest time possible. That’s my favorite part of working in the big data analysis world. You always have to keep learning....

House diagram showing sensors for lights, weather, security, internal temp, etc.

The Internet of Things (IoT) and Smart Metering

Joy King, VP, Vertica Product Management & Product Marketing
July 17, 2018

Every month, my husband receives a driver’s report from Chevrolet, providing him with “feedback” on his driving behavior – everything from the intensity of his braking to the number of lane changes without a blinker to the distance and speed he drove in his Silverado truck. The report also provides specific details on the upcoming...

Counting Days, Week Days and Weekend Days Across the Years: Quick Tip

Sarah Lemaire, Manager, Vertica Documentation
July 17, 2018

Jim Knicely authored this post. By combing Vertica’s built-in date formatting functions and the TIMESERIES clause, it’s easy to find the total number of days, total number of week days (Monday - Friday), and the total number of weekend days (Saturday - Sunday) that occur within a multi-year range (i.e., 2016 - 2018), including Leap...

Vertica Blog

Time series