Vertica Blog

Vertica Blog

complex data types

SQL

Quick Tip: WITH Clause Recursion

Jim Knicely, Vertica Field Chief Technologist
June 11, 2021

Starting with version 10.1.x, Vertica supports recursive queries. These are incredibly useful in modeling and working with self-referential hierarchical data. Let's take a look at a natural instance of this form of data: the manager-subordinate relationship. The following table contains employees (EMP_NAME), their IDs (EMP_ID), and the IDs of their managers (EMP_MGR_ID). For example, the...
Rocket to Moon with Vertica version 10.1

Vertica 10.1 Rockets Data Analytics to the Next Level

Paige Roberts, Vertica Open Source Relations Manager
February 1, 2021

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...
Taking data analytics to the next level

Vertica 10 SP1 Takes Data Analytics to the Next Level

Kevin Xu, Information Developer
September 21, 2020

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

Tune in for Monthly Vertica Tune-Ups

Jeff Healey, Sr Director, Vertica Product Marketing at Micro Focus
June 9, 2020

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