Vertica Blog

Vertica Blog

Open Source

New Version 0.5 of VerticaPy

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

Do you really want to outsource your data and analytics?

As a nine year veteran of the Big Data business, I’ve seen the shift from transactional data stores like Postgres, SQL Server and Oracle to OLAP offerings from the likes of Greenplum, Aster, Vertica, and ParAccel, to the rise and fall of Hadoop Data Lakes, and now the shift to cloud, object storage, and serverless...
Rocket to Moon with Vertica version 10.1

Vertica 10.1 Rockets Data Analytics to the Next Level

As of February 1, 2021, the new version of Vertica rockets analytical database technology to the next level. Vertica 10.1 continues to show our commitment to broad, powerful in-database machine learning by including our most requested algorithm – XGBoost. Management Console makes administering Vertica in the cloud even easier. Support for complex data types in...
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....

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

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

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