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

Watch Machine Learning for Predictive Analytics in Action

Sarah Lemaire, Manager, Vertica Documentation
April 27, 2016

Watch this video to learn more about the Vertica Machine Learning for Predictive Analytics features new in 7.2
Programmer

Vertica Champions Diversity

Sarah Lemaire
April 25, 2016

On Thursday, April 14, the Microfocus DataGals** hosted a free screening of the award winning documentary Code: Debugging the Gender Gap in Cambridge, MA.

Identifying Patterns in Your Data with Event Series Pattern Matching – Part 1

Sarah Lemaire, Manager, Vertica Documentation
April 20, 2016

Vertica's event series pattern matching functionally lets you identify events that occur is specific patterns. In this blog, we'll introduce you to the pattern matching key features.

Subscribe For Email Updates

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

Sign-up

Database Server Room

Learn More From Your Data with Machine Learning Algorithms

Chana Zolty
April 14, 2016

NOTE: This article refers to Vertica 7.x and is considered outdated.  This article is more relevant to later Vertica versions. New in Vertica 7.2.2 is the Machine Learning for Predictive Analytics package. This analytics package allows you to use built-in machine learning algorithms on data in your Vertica database. Machine learning algorithms are extremely valuable in...

Sidestepping Catastrophes with Vertica Backup and Recovery

Sanjay Baronia
April 5, 2016

Accidents do happen! Data can become corrupted. It can be unintentionally deleted and, in some rare cases, you can lose all your data.   Do you have a plan B to recover data in a timely manner?  
Database Server Room

Vertica and OpenStack

Chris Daly
March 30, 2016

Recently, several different customers have asked about deploying Vertica on an OpenStack cloud platform. This is an interesting situation, so to clear up any misconceptions, first we'll go through a brief description of OpenStack. Then, we'll suggest questions that you should ask yourself and your OpenStack administrator when deploying Vertica in an OpenStack environment.

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

Jump Start your BI Dashboard Development

BD_Partner_Eng
March 28, 2016

Do you develop BI dashboards for Vertica? Or would you like to give it a try? To help you get started, the Vertica Partner Engineering team has created a set of QuickStart BI sample apps.

Rebalance a Large Partitioned Table

Sarah Lemaire, Manager, Vertica Documentation
March 23, 2016

Your organization is collecting data as fast as your Vertica cluster can store it, so fast that you need to add a few nodes to your cluster. After you add those nodes, Vertica must distribute the data across all the existing and new nodes for best performance. We call this operation rebalancing.

Vertica Meetup: Sponsored by DataGals

Sarah Lemaire, Manager, Vertica Documentation
March 21, 2016

Join us in Cambridge, MA to watch Code: Debugging the Gender Gap

It’s All About Timing

Sarah Lemaire, Manager, Vertica Documentation
March 15, 2016

Every so often we hear about the seemingly confusing nature of SQL functions that return the “current” time. But what is “current”? Is it the start time of a transaction or statement? Is it the time returned by the system clock? The answer is: all of these, depending on which function you call.

User Security Auditing in Vertica

HPBigData_BP
March 9, 2016

Are you a database administer who manages users and roles in your Vertica database? Do you need to keep track of who has permission to access certain database objects? If so, here's a quick guide to queries that help you review the users, roles, privileges, and permissions that you have configured in your database. These...
Three 3D arrows, different colors pointing in different directions

Looking Under the Hood at Vertica Queries

Sarah Lemaire, Manager, Vertica Documentation
March 2, 2016

When you submit a query to Vertica, you want it to execute as quickly and efficiently as possible. The query optimizer creates a plan that is designed to do just that. The directives in the query plan determine your query's run-time performance and resource consumption, but the properties of your projections and the system parameters also impact...