Vertica Blog

OpenText Vertica 23.3 – the Smarter Data Lakehouse

Posted July 31, 2023 by Paige Roberts, Vertica Open Source Relations Manager

Read More

Unveiling the Most Recent Version of the Vertica Grafana Data Source Plugin

Amrita Akshay, Information Developer
October 12, 2023

With over 380K downloads, the Vertica Grafana Data Source plugin just got an upgrade! The plugin was migrated from the deprecated older Grafana toolkit to align with Grafana's new Create-Plugin tool. This accelerates the plugin development with their modern build set up that requires no additional configuration. Additionally, the Vertica SQL Go driver received an...
Quick Tip on a blue enter key on a keyboard

Setting Session Authorization to Troubleshoot

Sruthi Anumula, Senior Database Support Engineer
September 29, 2023

There are possible scenarios in which a dbadmin would want to run queries as another user to troubleshoot or test. You can use SET SESSION AUTHORIZATION to impersonate another user and run queries. Let's understand this with an example. Here we create a user named test, resource pool named userpool, and make this a default...
Cute cartoon puppy with Free Puppy sign

Open Source Software is Free, Like a Puppy

Joy King, VP Product & GTM Strategy, Vertica
March 4, 2019

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

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

James Knicely, Vertica Field Chief Technologist
March 1, 2019

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

James Knicely, Vertica Field Chief Technologist
February 28, 2019

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

Subscribe For Email Updates

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

Sign-up

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

James Knicely, Vertica Field Chief Technologist
February 27, 2019

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:...
Modern Database Analytics

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

Sarah Lemaire, Manager, Vertica Documentation
February 27, 2019

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

Paige Roberts, Vertica Open Source Relations Manager
February 27, 2019

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

Explore Popular Topics

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

Generate a Murmur Hash

James Knicely, Vertica Field Chief Technologist
February 26, 2019

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: HASH Murmurhash: What is it?
Database Server Room

Assign All Users’ Granted Roles as Default Roles

James Knicely, Vertica Field Chief Technologist
February 26, 2019

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

James Knicely, Vertica Field Chief Technologist
February 26, 2019

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

Paige Roberts, Vertica Open Source Relations Manager
February 26, 2019

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...
Drawing of three types of disk holding hands

Only the Strongest and Boldest Data-Driven Companies Will Survive

Joy King, VP Product & GTM Strategy, Vertica
February 25, 2019

One of my favorite analyst quotes comes from Ray Wang at Constellation Research. It’s simple, it’s direct, and it’s scary - “Digital Darwinism is unkind to those who wait.” I have quoted it many times as a proof point for why traditional companies must evolve and adapt if they are to survive. The fundamentals of...

Auditing Flex Tables Quick Tip

James Knicely, Vertica Field Chief Technologist
February 20, 2019

The AUDIT_FLEX function returns the estimated ROS size of __raw__ column in a Flex table, equivalent to the export size of the flex data in the audited objects. Note that the AUDIT function returns 0 for a Flex table if no columns in the Flex table have been materialized.