Vertica Blog

Announcing Vertica Version 11

Posted August 11, 2021 by Paige Roberts, Vertica Open Source Relations Manager

Read More

What we learned at HIMSS21

Vertica was a first-time sponsor at August’s HIMSS21 show in Las Vegas, the largest annual North American healthcare technology conference. While the show followed strict health and safety precautions to protect guests, attendance at the show was still quite light compared to what I’ve heard the show normally expects. Nevertheless, the conversations we had at...

How to run Vertica CE in Windows 10 using Docker

Sometimes we want to test a new version of Vertica. In the past, the best way to do that was to use a Vertica Community Edition (CE) virtual machine. But starting with Vertica version 10.1, there is an easier way to achieve this. There is an official Docker image for the latest Vertica CE version...

Vertica 11 announced at Unify 2021: Delivering on vision of Unified Analytics

Introduced by Joy King, Vertica’s VP of Product & GTM Strategy, Colin Mahony, SVP and General Manager of Vertica, kicked off today’s Vertica Unify 2021 by explaining Vertica’s founding philosophy and sharing “some of the advancements we’ve made most recently, as well as the direction we’re going in future.” That included the announcement of Vertica...

DaaS Labs Embeds Vertica for Machine Learning Analytics at Superior Speed and Scale

Uncovering hidden patterns, trends, correlations, and insights in data has become a common business pursuit as companies look for different ways and means to monetize their data. Most of this activity relies on advanced data techniques like artificial intelligence, natural language processing, machine learning, deep learning, computer vision, and more. These techniques are DaaS Labs’s...

Quick Tip: Replacing non-UTF-8 Characters

Vertica database servers expect to receive all data in UTF-8 and Vertica outputs all data in UTF-8. However, you can load or insert data into Vertica that is non UTF-8, but you'll want to clean it up. I used to recommend the REGEXP_REPLACE function for that task, but now there is a better way! Vertica...

Subscribe For Email Updates

Sign-up and select Vertica in your preferences to receive our monthly Vertica newsletter.

Sign-up

Quick Tip - blue button

Quick Tip: MC Adds a New Feedback Button

Do you love Vertica and want to let us know, or want to provide some constructive criticism? Well, now you can easily do that. Starting in Vertica 10.1.x, Management Console added a new Feedback Button which lets you submit a star rating and free-text comments to Vertica. The button displays vertically at the bottom-right of...
Helpful Tips in blue text with magnifying glass

Quick Tip: Determining Database “Cell” Count

The Vertica system tables LICENSE_AUDITS and USER_AUDITS include a mysterious column called CELL_COUNT. What exactly is the Cell Count? It's simply a calculation that looks like this: DATABASE CELL_COUNT = (Table_1 Column Count * Table_1 Row Count) + (Table_2 Column Count * Table_2 Row Count) + … + (Table_n Column Count * Table_n Row Count)...

The Climate Corporation awarded for outstanding AI/ML: We’re all winners with sustainable agriculture

The Climate Corporation, a subsidiary of Bayer, aims to help all the world’s farmers sustainably increase their productivity with digital tools. The Climate FieldView™ platform provides farmers with a comprehensive, connected suite of digital tools aimed at mitigating risk and optimizing farm productivity. As Vertica’s customer references manager, I gather stories around what our users...

Explore Popular Topics

Taking the pulse of cloud adoption trends: The Flexera “State of the Cloud” report

Before I joined Vertica, I worked in the cloud services world, first for a reseller and then for a Cloud Services Provider (CSP). During my time in this space I followed cloud adoption trends closely by necessity, and one of my favorite sources of data on the subject was RightScale’s (now Flexera’s)  “State of the...

Partners Showcase Solutions at Vertica Unify ’21

Registrations for Vertica Unify ’21 are rapidly climbing as we anticipate thousands of data experts to convene for the analytics event of the year. Vertica customers have long adopted a "best tool for the job" approach – and that goes beyond choosing Vertica to accelerate analytics and machine learning at scale. Success often requires our...

Vertica-as-a-Service: Advanced analytics just got a little easier

Anytime business software can provide greater ease-of-use, it leads to better business outcomes at a faster pace. What could be better than that? How about analytics-as-a-service, built on a cloud-native architecture running in your AWS account, and leveraging your own negotiated pricing and committed spend? Add the full suite of advanced analytics, in-database machine learning,...
SQL

Quick Tip: WITH Clause Recursion

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...
Vintage businessman concept wearing futuristic helmet at office

Quick Tip: Combine SQL and vsql Meta-commands on the vsql Command Line

When using vsql, the -c (--command) flag lets you pass a single statement to vsql as a string and then exits. Examples: While you can't combine a SQL statement with a vsql meta-command... ...You can use echo to combine and pipe SQL statements and vsql meta-functions to vsql! Have Fun!

EMA Awards Vertica as Top Vendor for Hyperperformance with Multi-Structured Data in Radar Report on Unified Analytics Warehouses

If you could describe in just one word what Vertica provides better than any other unified analytics platform on the market, what would that word be? Read any of our case studies, watch any of our Data Disruptor Webcasts, or attend Vertica Unify ’21, and, chances are, you’ll agree that that one word is performance....