Vertica Blog

Vertica Blog

Open Source

Flight Tracking

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

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

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...
Cubes with binary ones and zeroes on them clustered together floating in blue space with light shining out

2 – What Are the Benefits of Using Complex Data Types in SQL?

Co-authored by James Clampffer, Deepak Majeti. In this second post in the Complex Data Types blog series, let’s look at some of the reasons complex types are used extensively in organized big data formats like ORC and Parquet. Be sure to read the first post in this series where we discussed the what complex data...

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

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...
TOP 5 - with stars on white background - 3D

Top 5 Reasons Why You Win Big with Data at the Vertica Big Data Conference 2020

A few years ago, we held a user conference for our growing Vertica community. However, we underestimated its success – selling out the inaugural event because we had booked a venue that couldn’t accommodate the interest of hundreds of customers, prospects, and partners for what turned out to be Boston’s biggest and best Big Data...
Cubes with binary ones and zeroes on them clustered together floating in blue space with light shining out

1 – What are Complex Data Types?

Co-authored by James Clampffer, Deepak Majeti. - First in a series A lot of projects require querying ORC or Parquet files, or other data that may have internal types that are a bit more complex than usual. It’s a little hard to explain what we mean when we say, “complex.” So, this is the first in...
Happy dog running in grass

Vertica Big Data Conference 2020 – Are You Excited Yet?

The Vertica Big Data Conference (BDC) clock is ticking and my excitement is growing by the minute! I want to make sure that our Vertica community is up to date on the latest news, especially some of the General Session speakers and Breakout tracks. And let’s not forget one of the most special components of...
View from above of a sailing ship in the ocean with the sail full and the crew leaning to one side to balance

Announcing Vertica Version 9.3 – Ride the Winds of Change

The winds of change have been blowing strong. This week, Vertica version 9.3 made its big splash. Vertica has a tendency to pack a lot of features even into minor releases, and this is not a minor release. Rather than dive deep, I’m going to skim the surface of the ocean of new features. Eon...
Go programming language logo and little blue beaver mascot

The Vertica SQL Driver for Go

We are happy to announce the alpha release of the Vertica SQL Driver for Go. Go, also called GoLang, is a statically-typed, high performance language, syntactically similar to C. Originating at Google, it has grown rapidly in popularity over the past decade and has become a language of choice for highspeed components. The Vertica SQL...
Machine learning robot studying equations and graphs

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

Co-authored with Paige Roberts. A lot of modern scalable analytical databases like Vertica allow you to do machine learning data analytics 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...
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

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...
Vertica One on One with Davin Potts, CEO Appliomics, Founder KNIME, Core Python Committer

One on One with Davin Potts: 5. Vertica, KNIME, Python and the New Uber Created Vertica-Python Interface

At the recent Data Day Texas event, I sat down with Davin Potts and had a long conversation about a wide variety of subjects. I divided the conversation into multiple chunks by subject, and have been posting them one chunk at a time. In this post, we discuss how open source and Vertica interact, with focus on...