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

Troubleshooting Vertica Query Performance with System Tables

Sarah Lemaire, Manager, Vertica Documentation
August 29, 2016

Do you want to learn how to troubleshoot your query performance issues?  We've got you covered. Just attend

How to Load New Data and Modify Existing Data Simultaneously

Chana Zolty
August 2, 2016

Originally posted 8/27/2012 Many Vertica customers tell us “we have an OLTP workload” which is not Vertica's architectural sweet spot. However, when we dig into what they are actually doing, it often turns out that they are simply bulk loading mostly new data with some small number of updates to existing rows. In Vertica 6,...
Programmer

The Right Tool for the Job: Using Apache Hadoop with Vertica for Big Data Analytics

Chana Zolty
July 26, 2016

I have an entrepreneur friend who used to carry a butter knife around.  He claimed this “almighty” tool was the only one he ever needed!  While the butter knife does serve a wide range of purposes (especially with a stretch of the imagination), in practice it doesn't’ always yield optimal results.  For example, as a...

Subscribe For Email Updates

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

Sign-up

Vertica Interns Develop Real-World Business Solutions

Nkritikos
July 19, 2016

It is a rare opportunity for interns at Vertica to be assigned to the same project. This summer, three interns have been working closely with the Partner Engineering team to build a data generator.

Intern Lunch with Vertica GM

Nkritikos
July 12, 2016

Last week, the interns had lunch with the General Manager, Colin Mahony. The lunch started with everyone introducing themselves, and we've come to know that Colin impressively remembers everyone's names. We shared lunch over a casual round-table discussion. We even got to enjoy a slice of cake afterwards.
Database Server Room

Do You Need to Put Your Query on a Budget?

Sarah Lemaire, Manager, Vertica Documentation
July 6, 2016

Before we scare you away with the word "budget", rest assured that after reading this blog, you won?t have to give up your favorite activities or sell your car. What you will be able to do is understand how Vertica resource pool parameters affect query budget.

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 with Vertica

BD_Partner_Eng
June 27, 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. You can download them for free from the

Analyze Mismatched Series with Event Series Joins

Sarah Lemaire, Manager, Vertica Documentation
June 20, 2016

Event series occur in tables with a time column, most typically a TIMESTAMP data type. In Vertica, you perform an event series join to analyze two series in different tables when their measurement intervals don't align, such as with mismatched timestamps.

Jump Start your ETL Application Development with Vertica

BD_Partner_Eng
June 15, 2016

Interested in exploring the Vertica Analytic Database in the context of data movement and transformation? To get a feel for it, try our new ETL QuickStart sample apps. You'll find them on the Big Data Marketplace. Our Partner Engineering team develops QuickStart apps using tools from our technology partners. Currently we have ETL QuickStarts for...

A Day in the Life of a Vertica Intern

Nkritikos
June 6, 2016

When I set out to find an internship for the summer, I was afraid that I would inevitably end up in a position where my primary responsibility was to fetch coffee. Fortunately for me, my first day on the job at Vertica proved that this would not be the case.

Which One of These is Not Like the Others?

Sarah Lemaire, Manager, Vertica Documentation
May 17, 2016

With the new guaranteed uniqueness optimization feature in Vertica 7.2.2, Vertica automatically recognizes when a query is accessing columns with unique values and optimizes the query operations that would otherwise be bogged down due to duplicate values.

Classified: FAQs on Access Policies

Sarah Lemaire, Manager, Vertica Documentation
May 2, 2016

In Vertica 7.2.2 we?ve added more security features, including a row-level access policy option. Combined with our previously existing column access policy, Vertica verifies that your data is more secure than ever.