Vertica Blog

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

Posted June 15, 2021 by Joy King, VP Product & GTM Strategy, Vertica

Read More

First annual “Data Disruptors Awards” caps Vertica Unify 2021

Mike Perrow, Senior Product Marketing Writer/Editor
July 27, 2021

“Vertica has been powering the world’s data disruptors for a decade, including companies that have created new industries, and have had an impact on the environment, and on the health of humans and animals.” Those were the opening comments by Joy King, Vertica’s VP of Product and Go-to-Market Strategy, at Thursday morning’s opening session for...

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

Mike Perrow, Senior Product Marketing Writer/Editor
July 20, 2021

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

DataGals Panel reveals common workplace biases, but also opportunities

Mike Perrow, Senior Product Marketing Writer/Editor
July 23, 2021

  Representing five different time zones, and committed to sharing their thoughts and guidance based on the success they’ve achieved in their careers, five women gathered live and online Thursday, July 22 to discuss their experiences in high tech. Here's how they appeared in this virtual panel discussion: Far left: Joy King, VP of Product...

Vertica Unify 2021 – Day 2 keynote spotlights a noble cause

Mike Perrow, Senior Product Marketing Writer/Editor
July 21, 2021

At Vertica Unify 2021, the focus this week has been on the techniques and best practices around data analytics. Naturally. There’s a lot of technology to cover in this space, and we’re delighted to have so many of the best and brightest minds in virtual attendance, helping us deliver, explain, and demonstrate these things. And,...

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

Hemendhira Muralidharan, Senior Product Marketing Manager
July 19, 2021

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

Subscribe For Email Updates

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

Sign-up

Quick Tip: Replacing non-UTF-8 Characters

Jim Knicely, Vertica Field Chief Technologist
July 16, 2021

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...
Quick Tip - blue button

Quick Tip: MC Adds a New Feedback Button

Jim Knicely, Vertica Field Chief Technologist
July 15, 2021

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

Jim Knicely, Vertica Field Chief Technologist
July 14, 2021

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

Explore Popular Topics

DBadmin
SQL
Advanced Analytics
machine learning
Best Practices
VSQL
Cloud
Eon Mode
Vertica
Analytics
Partner Integrations
AWS
IoT
Time series
Security

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

Cheryl Bradstreet
June 28, 2021

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

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

Jeremiah Morrow, Senior Industry Product Marketing Manager
June 23, 2021

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

Jeff Healey, Sr Director, Vertica Product Marketing at Micro Focus
June 21, 2021

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