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

What’s New in Vertica 8.1.1?

Soniya Shah, Information Developer
July 11, 2017

This blog post was authored by Soniya Shah. In Vertica 8.1.1, we introduce new functionality including: • Supported platform updates • Machine learning updates • Management Console enhancements • Apache Hadoop, Apache Kafka, and Apache Spark integration updates • Database management improvements • Workload management • Table data management updates • SQL functions and statements...

Understanding Backup Space Utilization

Soniya Shah, Information Developer
July 10, 2017

This blog post was authored by Soniya Shah. Creating regular database backups is an important part of database maintenance. The vbr utility lets you back up, restore, and copy your database to another cluster. You can create full and incremental backups, and even back up objects, such as tables. Ideally, backups should match what is...

Concurrency and Workload Management

Soniya Shah, Information Developer
June 26, 2017

This blog post was authored by Soniya Shah. Vertica workloads range from simple primary key lookups to analytical queries that include several large tables and joins. Different types of load jobs must keep the data updated. Vertica has a mixed-workload management capability that is easy to use. Vertica can process queries both concurrently and in...

Subscribe For Email Updates

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

Sign-up

How to Set Vertica in Read-Only

Soniya Shah, Information Developer
June 19, 2017

This blog post was authored by Soniya Shah. You probably know that you can create READ ONLY users in Vertica. These users can view everything within a schema, but don’t have the proper permissions to change anything within the database. This is useful for sets of users that don’t need as many permissions or for...
Database Server Room

DataGals Hosts a Year Up Event

Soniya Shah, Information Developer
June 15, 2017

This blog post was authored by Soniya Shah. This week, the DataGals hosted an event to raise awareness for Year Up. Year Up provides young adults, aged 18-24 with the skills and experience they need to succeed in the professional workplace. Here at Vertica, we are proud supporters of the Year Up program. We have...

Understanding Users, Privileges, and Roles

Soniya Shah, Information Developer
June 12, 2017

This blog post was authored by Soniya Shah. Every Vertica database has one or more users. When users connect to the database, they log in with credentials that a superuser defines. Database users should only have access to the database resources they need to perform their tasks. To navigate these necessities, Vertica has designated users,...

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

In-Database Approximate Median and Percentile Functions

Soniya Shah, Information Developer
June 8, 2017

This blog post was authored by Ginger Ni. Median and percentile functions are commonly used data statistic functions. They are also used in other sophisticated data analysis algorithms, such as the robust z-Score normalization function. Vertica has exact MEDIAN and PERCENTILE_CONT functions, but these functions do not scale well for extremely large data sets, because...

Introducing the Vertica Test Drive for Clickstream Analytics

Soniya Shah, Information Developer
June 5, 2017

This blog post was authored by Soniya Shah. Recently, Vertica engineers introduced the new Vertica for Clickstream Analytics test drive on AWS. If you’re a Vertica user, you might be familiar with our test drives on AWS – both run on SQL on Hadoop. One uses MapR and the other uses Hortonworks. With this test...

Getting Rid of Range Joins

Soniya Shah, Information Developer
June 1, 2017

This blog post was authored by Soniya Shah. You can use range joins to categorize data into buckets. Vertica provides performance optimizations for =, and BETWEEN predicates. These optimizations are particularly useful when a column from one table is restricted to be in a range specified by two columns of another table. Range joins can...

New Uses for Directed Queries

Soniya Shah, Information Developer
May 30, 2017

Directed queries were introduced in Vertica 7.2. Directed queries were originally designed to achieve two goals: • Preserve current query plans before a scheduled upgrade. • Enable you to create query plans that improve optimizer performance. Since their introduction, users have found new and compelling ways to use directed queries—notably, using them to substitute one...

What’s New in Vertica 8.1: Flex Tables Enhancements

Soniya Shah, Information Developer
May 25, 2017

This blog post was authored by Soniya Shah. As of Vertica 8.1, you can execute CTAS statements to create flex tables. CREATE TABLE AS (CTAS) statement Previously, Vertica supported creating tables using the AS SELECT clause. Frequently called CTAS, this SQL statement lets you create a new table that contains the results from querying another...

Use MERGE to Update 1 Million Rows in 2 Seconds

Moshe Goldberg, Vertica System Engineer
May 22, 2017

This blog post was co-authored by Yassine Faihe, Michael Flower, and Moshe Goldberg. Updating One Million Records in Two Seconds To illustrate the true power of MERGE, this article describes how we used MERGE to demonstrate Vertica's performance at scale. SQL MERGE statements combine INSERT and UPDATE operations. They are a great way to update...