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

On the Trail of a Red-Tailed Hawk!

Sarah Lemaire, Manager, Vertica Documentation
February 25, 2016

Read how we used User-Defined-Loads to track the habits of the red-tailed hawk!
Modern Database Analytics

Vertica Joins: A Refresher

Sarah Lemaire, Manager, Vertica Documentation
February 23, 2016

As a Vertica user, you know that using joins can improve query performance by combining records from one or more tables. But sometimes, you need to develop complex joins. Vertica supports many different kinds of joins that perform different functions based on your needs.
Programmer

Improving COUNT DISTINCT Performance with Live Aggregate Projections

HPBigData_BP
February 17, 2016

Today?s organizations need to be able to measure the effectiveness of online ads and marketing campaigns. In your particular organization, you may want to measure how effectively your ads drive unique visitors to your website. Or you may want to see if your ads drive repeat visits from the same user over a specific period...

Subscribe For Email Updates

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

Sign-up

Jump Start your BI Dashboard Development

BD_Partner_Eng
February 11, 2016

Do you develop BI dashboards for Vertica? Or would you like to give it a try?

Installing Vertica SQL on Hadoop

Gary Gray, Principal Information Developer
January 27, 2016

Interested in adding Vertica's analytic capabilities to your Hadoop cluster? Watch this tutorial video to learn how you can install Vertica on Hadoop, giving it faster access to your data!

What are Vertica Engineers Reading?

Sarah Lemaire, Manager, Vertica Documentation
January 6, 2016

Ever wonder what Vertica engineers do when they aren?t busy building and perfecting an awesome product?

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

Tell the Optimizer You Have a Better Plan

Michael Kronenberg
December 17, 2015

You're upgrading your database and some query appears to execute less efficiently than before. What can you do? Vertica addresses this concern in Vertica 7.2 with directed queries

Using Looker to Leverage Vertica Capabilities: ORC Reader, Flex Tables, and Place

BD_Partner_Eng
December 8, 2015

Want some hints about how to use Looker to visualize data in your Vertica database? The Looker user community, known as

Data-Centric Security: Vertica and SecureData

BD_Partner_Eng
December 3, 2015

Take advantage of the recent integration of Vertica and SecureData. This integration allows you to keep your data protected when it flows across multiple systems spread across multiple data centers on premise or in the cloud.

Restoring Objects from a Full Backup

Sarah Lemaire, Manager, Vertica Documentation
November 24, 2015

Before Vertica version 7.2, you had two options: perform full backups and restore full backups (remove everything from the storage unit) or perform object-level backups and restore those individually (maintain separate storage units). But as of Vertica 7.2, you can have the best of both worlds. You can perform full backups and restore individual objects...

Using Inherited Privileges

Phil Molea, Sr. Information Developer, Vertica
November 16, 2015

New to Vertica 7.2.0, the inherited privileges feature provides a one-step method for enabling privileges at the schema level.
Three 3D arrows, different colors pointing in different directions

Using the Informatica PowerCenter Connector for Vertica

BD_Partner_Eng
November 5, 2015

Have you been using the plug-in (Java or Native) that Vertica developed to connect to your Vertica database using Informatica PowerCenter? Now there's a better option that provides additional functionality.