Vertica Blog

Welcome to the New Vertica Blog!

Posted March 28, 2019 by Ben Smith, Senior Product Marketing Manager

Read More

Machine learning robot studying equations and graphs

Doing In-Database Machine Learning 1 – Why Would You Do That?

Co-authored with Paige Roberts. A lot of modern like Vertica allow you to do machine learning from end to end, right in the database, rather than moving and transforming the data first into something like a Spark dataframe or a Python data structure. Whenever people hear about this capability, they have two questions. The first...

5 companies that are using data analytics to transform customer experience

Analyzing customer behavior is becoming a mandate for every business in every industry to understand, engage, and retain customers – with the ultimate goal of increasing lifetime value. By understanding how your customers behave and interact with your organization, you can better serve, and profit, from the interactions. Data is central to this equation in...
Vertica One on One with Davin Potts, CEO Appliomics, Founder KNIME, Core Python Committer

One on One with Davin Potts: 3. Exciting News for Upcoming Python Release 3.8

At the recent Data Day Texas event, I sat down with Davin Potts and had a long conversation about a wide variety of subjects. I divided the conversation into multiple chunks by subject, and have been posting them one chunk at a time. In the , we discussed the wide variety of programming languages and...
Woman's hand with ring and henna tattoos in man's hand in embroidered sleeve

A Perfect Match – Matrimony.com and Vertica

If you have ever sought a romantic match in India, chances are you have visited . According to the Times of India,. Matrimony.com’s flagship brand, BharatMatrimony, alone has more than 4,000 associates serving more than three million active members. But, how does Matrimony.com connect singles so accurately and effectively through its online profile matching? Data...
Cute cartoon puppy with Free Puppy sign

Open Source Software is Free, Like a Puppy

Open source software has a long and inspiring history. In the very early days of software itself, academic collaboration was the norm. But in the late 70’s and early 80’s, manufacturers increasingly copyrighted their technologies, protected their source code, and required licensed use of software. The era of commercial software was born. Freedom! Richard Stallman...

Subscribe For Email Updates

Enter your email address to receive the monthly Vertica newsletter.

Revoke Access to Multiple System Tables from Multiple Users with a New Role

Vertica provides an API (application programming interface) for monitoring various features and functions within a database in the form of system tables. These tables provide a robust, stable set of views that let you monitor information about your system's resources, background processes, workload, and performance, allowing you to more efficiently profile, diagnose, and view historical...
Three 3D arrows, different colors pointing in different directions

Revoke Access From Just One System Table

Vertica provides an API (application programming interface) for monitoring various features and functions within a database in the form of system tables. These tables provide a robust, stable set of views that let you monitor information about your system's resources, background processes, workload, and performance, allowing you to more efficiently profile, diagnose, and view historical...

Create a SQL Function to Calculate the nth Root of a Number

Vertica has a built-in function to calculate the arithmetic square root a number called SQRT and another built-in function to calculate the arithmetic cube root of a number called CBRT. But what if I need a function to calculate the arithmetic nth root of a number? No problem. I can create my own! Helpful Links:

Explore Popular Topics

Single Sign-On for Support: New Login for Passport Users

As part of the Micro Focus ongoing IT transformation, we have consolidated single sign-on systems to improve your experience of interacting with Micro Focus. All Passport users need to create a new account. To maintain your current access rights, you need to register with the same e-mail address you used with passport. If you use...
Vertica One on One with Davin Potts, CEO Appliomics, Founder KNIME, Core Python Committer

One on One with Davin Potts: 2. Advantages of KNIME and Letting Databases Do What Databases Do Best

At the recent Data Day Texas event, I sat down with Davin Potts and had a long conversation about a wide variety of subjects. I divided the conversation into multiple chunks by subject, and will post them up one subject at a time. In this second post, we discuss the advantages of KNIME for a...

Generate a Murmur Hash

Murmur (Murmerhash) is a modern non-cryptographic hash function that has a low collision rate and high performance. It is suitable for general hash-based lookups, but not suitable for cryptographic use cases. Vertica has a built-in function called HASH. Helpful Links:

Assign All Users’ Granted Roles as Default Roles

By default, no roles (other than the default PUBLIC Role) are enabled at the start of a user session. You have to assign one or more of a user’s granted roles as default roles so that they are enabled when a user logs on. You do this with the ALTER USER … DEFAULT ROLE command....

View Tuple Mover Operation Run-time Intervals

Vertica’s Tuple Mover manages WOS and ROS data storage. To do that, the Tuple Mover performs two operations: Moveout: Moves data from WOS to ROS. Mergeout: Combines small ROS containers into larger ones and purges deleted data. The Tuple Mover operations are controlled by a set of configurable parameters. To quickly view the relevant parameter’s...
Vertica One on One with Davin Potts, CEO Appliomics, Founder KNIME, Core Python Committer

One on One with Davin Potts: 1. On Becoming a Core Python Committer and the Tools Used to Build Data Science

At the recent Data Day Texas event, I sat down with Davin Potts and had a long conversation about a wide variety of subjects. I divided the conversation into multiple chunks by subject, and will post them up one subject at a time. In this first post, we discussed the wide variety of programming languages...