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

Query Execution in Eon Mode

Soniya Shah, Information Developer
February 7, 2018

This blog post was authored by Ben Vandiver. How Vertica distributes query processing across the cluster in Eon mode is a complex topic that is best illustrated through a concrete example. As part of this post, we'll start with a simple data load and walk through metadata storage and query execution. To begin, we need...

Vertica Quick Tip: Superfast Table Copy

Soniya Shah, Information Developer
February 7, 2018

This blog post was authored by Jim Knicely. Very often we need to make a copy of a very large table in order to do some development or quality assurance type of duties. Typically we’ll use a CREATE TABLE AS SELECT (CTAS) statement to make that copy. But that took a very long time (~...

Vertica Quick Tip: Add a Time Zone

Soniya Shah, Information Developer
February 6, 2018

This blog post was authored by Jim Knicely. Vertica recognizes many time zones. However, there might come a time (zone) when you will need to reference one that is not available by default. Luckily it’s relatively easy to add a time zone to Vertica. But I would like to use the “Hawaii-Aleutian Daylight Time (HDT)”...

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.0.1: Security and Authentication

Soniya Shah, Information Developer
February 6, 2018

This blog post was authored by Soniya Shah. In this release, we introduce some security enhancements. We've added the ability to grant and revoke privileges on system tables, using the same syntax as you would for granting and revoking on tables. However, there are some limitations about the types of privileges you can use with...

Vertica Quick Tip: Default Size of the NUMBER Data Type

Soniya Shah, Information Developer
February 5, 2018

This blog post was authored by Jim Knicely. When creating a table where you do not define a precision for a NUMBER column data type, Vertica will use a default precision of 38 digits. Often this is larger than necessary. By specifying NUMBER(37) you will potentially get better query performance and save on storage. Why?...

Vertica Tip: Predicting the Resources a Statement Needs

Soniya Shah, Information Developer
February 5, 2018

This blog post was authored by Eugenia Moreno. You may find you want to set up resource pools before running queries to know how many resources a particular query needs. One way to do this is to create a small resource pool, profile the query, and note when the query is rejected. When the query...

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
Three 3D arrows, different colors pointing in different directions

Beware of Segmentation Islands

Soniya Shah, Information Developer
February 5, 2018

This blog post was authored by Curtis Bennett. Many clients who are new to Vertica are also new to big data. While Vertica’s reliance on industry-standard SQL can make the transition very easy, often the introduction of multiple nodes used in support of a database platform can take some getting used to. It is the...

Vertica Quick Tip: Dynamically Split Up a String

Soniya Shah, Information Developer
February 1, 2018

This blog post was authored by Jim Knicely. One of my favorite functions in Vertica is named SPLIT_PART. It splits up a string into parts by a given delimiter. But what if I don’t know how many parts there are in my text? As the following example shows, I can use the ROW NUMBER analytic...
Modern Database Analytics

What’s New in Vertica 9.0.1: Ranger Integration

Soniya Shah, Information Developer
January 31, 2018

This blog post was co-authored by Mitchell Tracy and Monica Cellio. Hadoop clusters can use authorization services to determine which users can access what data in Hive and, by extension, HDFS. In Vertica 9.0 we added support for one of the most common such services, Apache Sentry, and in 9.0.1 we now support Apache Ranger...
Programmer

Vertica Quick Tip: Proper Ordering of IP Addresses

Soniya Shah, Information Developer
January 31, 2018

This blog post was authored by Jim Knicely. Often times we store IP addresses in a VARCHAR column in a Vertica table. When querying the data and sorting by the IP address, we see that IP addresses are sorted by its VARCHAR value instead of its numeric value. Fortunately Vertica has the INET_ATON function which...

Vertica at the Aeronaut Brewery: Adventures in Data Architecture

Soniya Shah, Information Developer
January 30, 2018

This blog post was authored by Sarah Lemaire. Vertica hosted a Meetup at the Aeronaut Brewery in Somerville for customers and prospective customers, including data scientists from Nuance, J.Jill, and True Fit. After some cold beer to warm us up on a cold night, we were lucky enough to hear JB Huang, Head of Data...

Vertica Quick Tip: The <=> operator

Soniya Shah, Information Developer
January 30, 2018

This blog post was authored by Jim Knicely. The operator performs an equality comparison like the = operator, but it returns true, instead of NULL, if both operands are NULL, and false, instead of NULL, if one operand is NULL. Have fun!