Vertica Blog

Vertica Blog

Time series

Vertica for Time Series Analytics and IoT

Steve Sarsfield, Vertica Senior Product Marketing Manager – Partner Ecosystem
May 3, 2022

When you want to make a prediction – stocking levels for items in your store, predicting energy usage so supply is ready, or being proactive about equipment failures – those predictions often rely on time-series data, a series of data points measuring the same signal or process through time. By analyzing that data, companies can...
data lakehouse example

Going Beyond a Data Lakehouse

David Sprogis, Director of Product Management
December 15, 2021

The way things get named in this industry can be pretty odd.  A lot of people have been hearing noise about how cool a “Data Lakehouse” is since it combines the power of a data lake with the power of a data warehouse. When I think of a lakehouse, I think of a great place...

Don’t take your foot off the electrons

Mark Whalley, Manager, Vertica Education
November 8, 2021

With blazingly fast query performance, and access to 700 in-database functions, Vertica has meant that Jaguar Race Engineers and Strategists have been able to glean important insights into the data and make critical performance adjustments to the powertrain, suspension, steering, braking and power management that were just not possible prior to the introduction of Vertica.

Announcing Vertica Version 11

Paige Roberts, Vertica Open Source Relations Manager
August 11, 2021

Vertica Unified Analytics Platform version 11 delivers GA support for Docker containers and Kubernetes, advanced machine learning and time series capabilities, and increased analytical performance.

Vertica 11 announced at Unify 2021: Delivering on vision of Unified Analytics

Mike Perrow, Senior Product Marketing Writer/Editor
July 20, 2021

Introduced by Joy King, Vertica’s VP of Product & GTM Strategy, Colin Mahony, SVP and General Manager of Vertica, kicked off today’s Vertica Unify 2021 by explaining Vertica’s founding philosophy and sharing “some of the advancements we’ve made most recently, as well as the direction we’re going in future.” That included the announcement of Vertica...

New Version 0.5 of VerticaPy

Badr Ouali, Head of Data Science
March 1, 2021

Last week, the VerticaPy team released a new version v0.5.0 focused on hyperparameter tuning, time series analysis and model explainability.

Technology Partnership with Jaguar Racing to Deliver Vertica Analytics at Jaguar Speed

Jeff Healey, Senior Director, Vertica Product Marketing at Micro Focus
February 18, 2021

Jaguar Racing announced that it has partnered with Micro Focus, ahead of season seven of the ABB FIA Formula E World Championship. Joining as the team’s official digital transformation, business resiliency, and analytics partner, Micro Focus will provide support to Jaguar Racing’s push for more points, podiums, and wins on the racetrack. Vertica plays a...

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

James 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 new, detailed overview of Vertica 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...

Take Nothing but Memories. Leave Nothing but Footprints

Mark Whalley, Manager, Vertica Education
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 tracking aircraft using a Raspberry Pi, Kafka and Vertica. For...
The Earth

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

Mark Whalley, Manager, Vertica Education
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...