Vertica Blog

Vertica Blog

python

Constellation Research Names Vertica to ShortList for Hybrid-Cloud and Multi-cloud Analytical Databases

What a week of industry recognition for Vertica. Today, Vertica announced that it was named to the Constellation ShortList™ for Hybrid-Cloud and Multicloud Analytical Relational Database Management Systems in Q1 2021. What is the Constellation ShortList? According to Constellation Research, the ShortList focuses on RDBMSs that can deliver the ultimate in analytical query performance even...

Vertica named by InfoWorld as one of 8 databases supporting in-database machine learning

A Feb. 17 article in InfoWorld names Vertica as one of eight analytical platforms that offer in-database machine learning “right where your data resides.” Authored by contributing editor and reviewer Martin Heller, the article validates two of Vertica’s long-held principles: flexibility in ML modeling and training, and the ability to analyze data without transmitting it...
Vertica wishes you a Happy Holidays

New VerticaPy Features Added – Just in Time for the Holidays

The team behind VerticaPy wishes you happy holidays and a happy new year from Boston, and from Grenoble in the French Alps! Make 2021 your year to operationalize Machine Learning at Scale with Vertica and Python.    VerticaPy is a Python library that exposes scikit-like functionality for conducting data science projects in your Vertica database....
Taking data analytics to the next level

Vertica 10 SP1 Takes Data Analytics to the Next Level

The first service pack for Vertica 10 brings even more incredible new features to the most flexible and scalable data analytics warehouse on the market.

Constellation Research Report Finds Vertica 10 a Leading Choice

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...
A man and woman looking under the hood

Tune in for Monthly Vertica Tune-Ups

Our Under the Hood Webcast series builds on the engineering-led sessions that our product and R&D teams deliver at our annual Vertica Big Data Conference. You can tune in nearly every month and get a deep dive of Vertica features and releases through this popular series. Last month, Vertica R&D covered one of our most...
Heavy rocket blasting above the clouds

Vertica Version 10 Launches Today!

There’s big news today, on the first day of the Virtual Vertica Big Data Conference 2020 – a major new version of Vertica blasts off! Vertica version 10 soars straight into the greatest deployment flexibility of any analytical data warehouse on the market. This fast and extremely scalable platform gives you more power than ever...

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...
Red arrow points to silver ball with 4 red arrows pointing away representing dividing a single thing into multiple

Parallel Processing Using Partitions With Vertica UDx

You can add functionality to Vertica using UDx, but what if you need to process more data than can be efficiently processed in a single thread or a single node? Vertica can divide data into partitions defined with the OVER() clause and distribute computing across nodes. This partition processing is "shared-nothing" similar to the Map...
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...
Vertica and Python logos stacked

Extending Vertica with Python functions: Adding NumPy FFT as a UDx

User-Defined Transform Function (UDTF) support for Python UDx were added back in Vertica 9.1, allowing you to add a much greater range of existing libraries and functions to Vertica. In this example, I'll add Fast Fourier Transform (FFT) from the NumPy package. FFT is a way to transform time-domain data into frequency-domain data. My test...
Vertica and Python logos stacked

vertica-python Becomes Vertica’s First Officially Supported Open Source Database Client

Tom Wall authored this post. We are very excited to announce that vertica-python, the open source python database client for Vertica created by Uber Technologies Inc., will officially become a supported database client for Vertica! This is a great milestone for Vertica and our community of users and developers. Not only do we expect to...