Vertica Blog

Vertica Blog

queries

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...
Tips in bright neon red letters on a dark background with touchscreens.

High Availability for a Vertica in Eon Mode Database with Read-Only Mode

Sruthi Anumula, Senior Database Support Engineer
January 9, 2023

When Vertica is deployed in Eon Mode, there are two major requirements for high availability: maintaining quorum and shard coverage. If either of them is lost, the whole cluster goes down. Before going into details, let us understand what quorum and shard coverage mean. Quorum: In Eon Mode, more than half of the primary nodes...
SQL Query Optimization

Improving COUNT DISTINCT Performance with Approximate Functions

Bryan Herger, Vertica Big Data Solution Architect at Micro Focus
November 16, 2022

A common analytic use case is to find the number of distinct items in a data set. Vertica performs well at solving COUNT DISTINCT in a few ways. Since Vertica stores all data in columns, it is possible to optimize for COUNT DISTINCT by building a projection that is tuned for this use case. Vertica...

No need to extract data from your database to do your analytics!

Mark Whalley, Manager, Vertica Education
June 16, 2022

While taking a long-awaited, and, IMHO some well-deserved R&R in the sun, I heard that ping notification coming from my backpack, and not being one who can ignore such things, reached for my iPad. With my OOTO email response already set, I should be able to ignore most incoming messages, texts and otherwise, safe in...

Vertica Stories from China: Top 3 contest winners showcase innovation

Elyzabeth Eng
February 1, 2022

This past December and January, the Vertica team for the Asia-Pacific region conducted a story contest for Chinese-speaking Vertica customers using creative solutions to data analytics requirements. In addition to reaching out and learning more about Vertica customers in the region, we wanted to gather use case details and share them with the worldwide Vertica...

Constellation Research Names Vertica to ShortList for Hybrid-Cloud and Multi-cloud Analytical Databases

Jeff Healey, Vice President of Marketing, Vertica Product Group in Micro Focus
February 24, 2021

What a week of industry recognition for Vertica. Today, Vertica announced that it was named to the Constellation ShortList™ for Hybrid-Cloud and Multicloud Analytical Relational Database Management Systems in Q1 2021. What is the Constellation ShortList? According to Constellation Research, the ShortList focuses on RDBMSs that can deliver the ultimate in analytical query performance even...
Electronic medical record on digital smart device

Vertica in Good Health: Ingesting, Securing, and Analyzing Healthcare Data

Bryan Herger, Vertica Big Data Solution Architect at Micro Focus
September 29, 2020

Electronic Medical Records and new personal healthcare technology, particularly medical devices, generate a huge amount of data. Organizations including Cerner and Philips Healthcare rely on Vertica for data analysis. How can Vertica help you analyze this data? Vertica excels at data ingest and provides hundreds of built-in SQL and analytic functions with broad integration with...
Heavy rocket blasting above the clouds

Vertica Version 10 Launches Today!

Paige Roberts, Vertica Open Source Relations Manager
March 31, 2020

There’s big news today, on the first day of the Virtual Vertica Big Data Conference 2020 – a major new version of Vertica blasts off! Vertica version 10 soars straight into the greatest deployment flexibility of any analytical data warehouse on the market. This fast and extremely scalable platform gives you more power than ever...
Flight Tracking

Pennard, We Have a Problem – Troubleshooting Flight Tracking with the Grafana Plugin for Vertica

Mark Whalley, Manager, Vertica Education
February 26, 2020

With Vertica’s Management Console, I have everything I need at my fingertips to manage and monitor my Vertica clusters and databases.  Whether that be investigating query performance issues, checking on the health of the cluster’s nodes, running the Database Designer or marveling at the volume of data being ingested by the Vertica Scheduler from a...
Cubes with binary ones and zeroes on them clustered together floating in blue space with light shining out

2 – What Are the Benefits of Using Complex Data Types in SQL?

Waqas Dhillon, Product Manager - Machine Learning, Vertica
December 19, 2019

Co-authored by James Clampffer, Deepak Majeti. In this second post in the Complex Data Types blog series, let’s look at some of the reasons complex types are used extensively in organized big data formats like ORC and Parquet. Be sure to read the first post in this series where we discussed the what complex data...
Create Read Update Delete in red 3D letters surrounded by 3D ones and zeroes

Vertica 9.3 Supports UPDATE and DELETE Operations on Tables Having Live Aggregate Projections!

James Knicely, Vertica Field Chief Technologist
October 17, 2019

A live aggregate projection contains columns with values that are aggregated from columns in its anchor table. When you load data into the table, Vertica aggregates the data before loading it into the live aggregate projection. On subsequent loads (for example, through INSERT or COPY) Vertica recalculates aggregations with the new data and updates the...
View from above of a sailing ship in the ocean with the sail full and the crew leaning to one side to balance

Announcing Vertica Version 9.3 – Ride the Winds of Change

Paige Roberts, Vertica Open Source Relations Manager
October 16, 2019

The winds of change have been blowing strong. This week, Vertica version 9.3 made its big splash. Vertica has a tendency to pack a lot of features even into minor releases, and this is not a minor release. Rather than dive deep, I’m going to skim the surface of the ocean of new features. Eon...