Vertica Blog

Vertica Blog

Time series

DX Radio Episode 3: Climate Corporation and Digital Agriculture

Paige Roberts, Vertica Open Source Relations Manager
October 29, 2020

I have the honor of hosting the latest episode of DX Radio. It features The Climate Corporation’s Daniel McCaffrey, Vice president of Data and Analytics, and Erich Hochmuth, Big Data Architect Engineer, as they explore the digital transformation of farming.

List the Missing Dates in a Date Series

Jim Knicely, Vertica Field Chief Technologist
October 22, 2020

The TIMESERIES clause in Vertica makes it easy to list all of the gap days (that is, those that are missing) from a series of dates. Say I have this simple date series: As you can see, there are several dates missing from the series (2020-10-30, 2020-11-02, 2020-11-03 and 2020-11-04). I can list these absent...

Constellation Research Report Finds Vertica 10 a Leading Choice

Mike Perrow, Senior Product Marketing Writer/Editor
September 14, 2020

A few pages into a 10, produced by Constellation Research, principle analyst Doug Henschen summarizes the top new capabilities of Vertica 10 like this: In short, the Vertica team has steadily evolved the product to keep pace with the demands of organizations that seek to do the following: Unify diverse data sources and data types,...

Take Nothing but Memories. Leave Nothing but Footprints

Mark Whalley, Corporate Systems Engineer
August 25, 2020

For those who have read my previous blog postings, attended one of our Big Data & Machine Learning Meetups, or have met me at one of the many trade shows or conferences over the years, you will be all too aware of my love for . For those who are not aware, a Raspberry Pi...
The Earth

“awk” sed Grep, “whoami?”. Time CC if bash makes head or tail and sort > plain.txt and make us API

Mark Whalley, Corporate Systems Engineer
July 13, 2020

Things to do whilst confined to barracks due to COVID-19 For those who know me well, having worked in IT for four decades, will know that I can be a bit of a Luddite when it comes to new-fangled technology. Give me a character-based, green-screen PuTTY application over any pointy-clicky interface.  Let me use vsql...
Analytics human interest stories

Making a Difference with Analytics – Inspiring Human Interest Stories

Joy King, VP, Vertica Product Management & Product Marketing
June 18, 2020

I wake up before the sun rises, head to my home office, parse through the emails that have flowed in overnight, and look at my calendar to prepare for my day. I fill daylight hours with meetings, research, more meetings, writing … and more meetings. Sometimes, it is exhausting and even a little overwhelming. So,...
goldfinch songbird in a field of thistle in Wales

COVID-19 Birdsong

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

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...
Planets in solar system

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

1 – Why Would You Do Machine Learning in a Database?

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 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 question is,...
Hand writing the text: Helpful Tips

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

Jim Knicely, Vertica Field Chief Technologist
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...