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

Tech Support Series: Optimizing Projections

Sarah Lemaire, Manager, Vertica Documentation
December 10, 2014

Welcome to another installment of our Top Tech Support Questions Answered blog series. In our first

New Configuration Parameter Storage and Setting Options

Sarah Lemaire, Manager, Vertica Documentation
December 3, 2014

Vertica 7.1.x introduces a new way to store and set configuration parameters.Previously, configuration parameter values were stored in individual vertica.conf files on each node. As of Vertica 7.1.0, these values are stored in the database catalog, allowing the values to stay consistent over all nodes.

Optimizing for Merge Join

NorbertK
October 22, 2014

In an earlier post,

Subscribe For Email Updates

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

Sign-up

How to Backup Vertica Database

Backing Up and Restoring Your Vertica Database

Sarah Lemaire, Manager, Vertica Documentation
September 24, 2014

Backing up and restoring your database is an important part of basic database maintenance. Vertica lets you create both comprehensive and object-level backups. This article highlights the Vertica 7.x features that enhance the backup and restore process.
Modern Database Analytics

Is Big Data Giving You Grief? Part 5: Acceptance

Walt_Maguire
August 18, 2014

Over the last month or so, this series has discussed how organizations often deal with a missed big data opportunity in ways that closely resemble the grieving process, and how that process maps to the commonly understood five stages of grief: denial, anger, bargaining, depression, and acceptance. This is the last entry in the series;...
Programmer

Is Big Data Giving You Grief? Part 4: Depression

Walt_Maguire
August 4, 2014

Continuing the five part series which explores how organizations coping with big data often go through a process that closely resembles grief, this segment addresses the point at which the organization finally grasps the reality of big data and realizes the magnitude of the opportunity and challenge?and gets depressed about the reality of it.

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

Is Big Data Giving You Grief? Part 3: Bargaining

Walt_Maguire
July 30, 2014

Continuing the five part series about the stages of big-data grief that organizations experience, this segment focuses on the first time organizations explore the reality of the challenges and opportunities presented by big data and start to work their way forward?with bargaining.

Is Big Data Giving You Grief? Part 2: Anger

Walt_Maguire
July 23, 2014

Continuing this five part series focused on how organizations frequently go through the five stages of grief when confronting big data challenges, this post will focus on the second stage: anger.
Database Server Room

Physical Design Automation in the Vertica Analytic Database

ramakrishna
July 21, 2014

Automatic physical database design is a challenging task. Different customers have different requirements and expectations, bounded by their resource constraints. To deal with these challenges in Vertica, we adopt a customizable approach by allowing users to tailor their designs for specific scenarios and applications. To meet different customer requirements, any physical database design tool should...

Workload Management Metrics ? A Golden Triangle

Po Hong
July 17, 2014

Modern databases are often required to process many different kinds of workloads, ranging from short/tactical queries, to medium complexity ad-hoc queries, to long-running batch ETL jobs to extremely complex data mining jobs (See my previous blog on workload classification for more information.) DBAs must ensure that all concurrent workload, along with their respective Service Level...
Database Server Room

Is Big Data Giving You Grief? Part 1: Denial

Walt_Maguire
July 14, 2014

My father passed away recently, and so I?ve found myself in the midst of a cycle of grief. And, in thinking about good blog topics, I realized that many of the organizations I?ve worked with over the years have gone through something very much like grief as they?ve come to confront big data challenges?and the...

The Automagic Pixie

Walt_Maguire
July 7, 2014

In previous installments of this series, I de-bunked some of the more common myths around big data analytics. In this final installment, I?ll address one of the most pervasive and costly myths: that there exists an easy button that organizations can press to automagically solve their big data problems. I?ll provide some insights as to...