Vertica Blog

Vertica Blog

Under the Hood

Focused young woman working at laptop in office

The Vertica Academy Is Open for Learning

One of the greatest impacts from digital transformation, both from a personal and professional point of view, is not just the democratization of data - a very popular topic here at Vertica! - but the democratization of knowledge. Today, we are excited to announce the new, a platform that offers self-paced, technical training and certifications...
Machine learning robot studying equations and graphs

In-Database Machine Learning 2: Calculate a Correlation Matrix – A Data Exploration Post

In the , we discussed some of the reasons why it makes sense to do your machine learning inside the database. This will be the first post where we discuss some of the steps involved in the in-database machine learning workflow. Generally, the first thing you need to do is explore your data. This can...
Analyze, Design, Develop, Implement, Evaluate cycle illustration

Evaluating Classifier Models in Vertica

Co-authored by Elizabeth Michaud Vertica provides an out-of-the box machine learning toolset that covers a complete data science workflow. The toolset includes several distributed functions for evaluating both classifier and regressor machine learning models. The goal of this blog post is to demonstrate how you can use the built-in functions for evaluating the prediction performance...
Cyber security theme with abstract high speed technology POV motion blur

Vertica Test Results for MDS Security Patches

Several customers have asked us how Intel's recent MDS vulnerability patches will impact the performance of their Vertica databases. Vertica is known for its performance. So, anything that may impact its speed is a major concern for both us and our customers. Vertica engineers have finished a round of testing the OS and microcode fixes...
Digital image of a trash can made of data points on blue background

Watch those Delete Vectors!

Vertica is very good at ingesting data, compressing it, and querying at high speed. The trade-off here is that the data is stored in large block files called ROS containers. These containers can grow to large sizes, sometimes over 10 GB, and this makes it impractical to decompress and edit the files during updates and...
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...
Connecting grip

JetBrains DataGrip Offers New Vertica Connector

We are pleased to announce that JetBrains has released a Vertica connector for DataGrip! The connector, , allows SQL developers to use DataGrip to interact with Vertica. DataGrip uses Vertica’s JDBC driver to connect to Vertica. For details about connecting DataGrip to Vertica, see . is a database IDE that offers efficient schema navigation, an...
young girl choosing recommended video playback button.

Content Analytics and Video Recommendation Systems with Vertica

Analyzing digital content and the behavior of viewing customers in real-time is essential to a lot of companies. Communication operators and content providers are offering many services that enable customers to consume video content using different fixed and mobile technologies through different devices, either in their homes or mobile. For these operators and providers, it...
Drawing of 4 blue pillars: Separation, Automation, Prediction, Protection

Vertica’s Architectural Direction – Separation of Compute and Storage

For over a decade, Vertica has delivered industry-leading performance on analytic query workloads in on-premise “shared-nothing” environments. Due to several good (and several lucky) historical architectural decisions, Vertica in Eon Mode is also leading the market for elastic, on-demand databases in public clouds. This post will review the key features of the Vertica architecture, and describe Vertica’s...
Passenger balloon floating in blue sky

Announcing Vertica Version 9.2.1 – Take Analytics Efficiency to the Next Level

This week, some very cool things have gone into the newest version of the that make your analytics fly and save on your AWS budget. The theme for this release is Improving Vertica in Eon Mode Integration with Amazon S3, and there are a whole bunch of new features designed to do exactly that. But,...
Business card that says Expert Tips,

Create a Python UDx to Order a List of Values

User-Defined Extensions (UDxs) are functions contained in external shared libraries that are developed in C++, Python, Java, or R using the Vertica SDK. The external libraries are defined in the Vertica catalog using the CREATE LIBRARY statement. They are best suited for analytic operations that are difficult to perform in SQL, or need to be...
Machine learning robot studying equations and graphs

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

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