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

Vertica Quick Tip: When Modifying a SEARCH_PATH, Don’t Forget to Include PUBLIC

Soniya Shah, Information Developer
May 15, 2018

This blog post was authored by Jim Knicely. Each user session has a search path of schemas. Vertica uses this search path to find tables and user-defined functions (UDFs) that are unqualified by their schema name. You can change a session's search path at any time by calling SET SEARCH_PATH. When you modify a search...

Sizing Your Vertica Cluster for an Eon Mode Database

Soniya Shah, Information Developer
May 15, 2018

This blog post was authored by Shrirang Kamat. Vertica in Eon Mode is a new architecture that separates compute and storage, allowing users to take advantage of cloud economics that enable rapid scaling and shrinking of clusters in response to a variable workload. Eon Mode decouples the cluster size from the data volume and lets...

Vertica Quick Tip: Use the Overlay Function to Easily Insert a String Into Another String

Soniya Shah, Information Developer
May 14, 2018

This blog post was authored by Jim Knicely. The OVERLAY function returns a VARCHAR value representing a string having had a substring replaced by another string. Have Fun!

Subscribe For Email Updates

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

Sign-up

What’s New in Vertica 9.1: Precision-Recall Curve and F1-Score Machine Learning Evaluation Functions

Soniya Shah, Information Developer
May 14, 2018

This blog post was authored by Ginger Ni. The precision-recall curve is a measure for evaluating binary classifiers. It is a basic measure derived from the confusion matrix. In Vertica 9.1, we provide a new machine learning evaluation function PRC() for calculating precision and recall values from the results of binary classifiers. Along with the...
Database Server Room

Unlock Data Analytics for Dynamic Workloads with Vertica 9.1

Soniya Shah, Information Developer
May 10, 2018

This blog post was authored by Sanjay Baronia. Today, cloud infrastructure has made it easier for organizations to consume services and deploy business applications with a pay-as-you-go, OPEX model. This provides a number of incentives to move data to the cloud, especially for variable workloads and use cases that require heavy compute for finite periods...

Vertica Quick Tip: Who am I?

Soniya Shah, Information Developer
May 10, 2018

This blog post was authored by Jim Knicely. There are several ways to figure out who is the session user. This comes in handy for logging. Type: \h or \? for help with vsql commands \g or terminate with semicolon to execute query \q to quit jim=> select user; current_user -------------- jim (1 row) jim=>...

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

Vertica Quick Tip: Eon Mode

Soniya Shah, Information Developer
May 9, 2018

This blog post was authored by Jim Knicely. You can now deploy a Vertica cluster with an Eon Mode database instead of an Enterprise mode database. In Enterprise Mode, the original Vertica "share nothing" configuration, each database node stores a portion of the data and performs a portion of the computation. In Eon Mode, computational...

Vertica Quick Tip: Using vsql Almost Anywhere

Soniya Shah, Information Developer
May 8, 2018

This blog post was authored by Jim Knicely. I’m an old school kind of guy so I love our vsql command line interface (CLI) tool. What’s cool is if I am on a remote Linux host, I can copy the vsql binary from the database host and run then run it locally. [dbadmin@s18384357 ~]$ scp...

Vertica Quick Tip: User Defined Functions to the Rescue

Soniya Shah, Information Developer
May 7, 2018

This blog post was authored by Jim Knicely. A friend recently asked me why we don’t have certain functions available in Vertica that are offered in databases like MySQL. I shrugged it off as we have bigger fish to fry. But he kept pushing so I showed him how easy it is to implement a...

How do you use Vertica analytics and machine learning today?

Soniya Shah, Information Developer
May 4, 2018

One of the coolest aspects of Vertica is its in-database machine learning functionality. As part of our third round of product management surveys, we're asking you to take the time to answer how you use Vertica analytics today. We're hoping to get answers we can use to expand upon our growing analytics and machine learning...

Vertica in Eon Mode Paper Accepted for ACM SIGMOD/PODS Conference

Soniya Shah, Information Developer
May 4, 2018

Every year, the ACM SIGMOD/PODS conference is held as a forum for database researchers, developers, and users to explore innovations in the field and exchange ideas. The conference is an opportunity for thought leaders to talk with each other and hear from one another through presentations, workshops, and tutorials. This year, Ben Vandiver, Shreya Prasad,...

Vertica in Eon Mode: Tables, Parameters, Functions, and Useful Queries

Soniya Shah, Information Developer
May 3, 2018

This blog post was authored by Rakesh Bankula. The purpose of this document is to list new system tables, configuration parameters and meta-functions that were added for Vertica Eon mode. This document also has sample queries you can run on the new system tables to get up to speed with Eon mode. This document assumes...