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

Understanding Vertica Query Budgets

Soniya Shah, Information Developer
June 13, 2018

This blog post was authored by Shrirang Kamat. The purpose of this document is to explain how the query budget of a resource pool used by the query can influence the initial memory acquisition for a query and how it impacts query performance. For more details about how we compute the query budget, see the...
Three 3D arrows, different colors pointing in different directions

Which One of these Nodes Doesn’t Belong? A Vertica Quick Tip

Sarah Lemaire, Manager, Vertica Documentation
June 13, 2018

Jim Knicely wrote this tip. We strongly recommend that you use a homogeneous hardware configuration for your Vertica cluster: Each node of the cluster should be similar in CPU, clock speed, number of cores, memory, and operating system version. We learned in the last Vertica Quick Tip that the V_CATALOG.HOST_RESOURCES system table provides a snapshot...

Getting your Node Hardware Specs: Quick Tip

Sarah Lemaire, Manager, Vertica Documentation
June 12, 2018

Jim Knicely wrote this tip. At some point in the future, you might not remember the number of CPU sockets/processor cores and the amount of memory on each node of your Vertica cluster. Instead of having to issue several Linux commands on each node, Vertica provides the V_CATALOG.HOST_RESOURCES system table, which provides a snapshot of...

Subscribe For Email Updates

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

Sign-up

Modern Database Analytics

How to Code Vertica UDx

Soniya Shah, Information Developer
June 12, 2018

This blog post was authored by Ding-Qiang Liu. In analytic businesses supported by Vertica, complex processing logic is sometimes unavoidable. Using ANSI SQL might cause query strings to be much longer, and will slow the query with a huge volume data to query. If using Vertica SDKs, you can encapsulate that general computing logic in...
Programmer

SQL Reserved Words: Quick Tip

Sarah Lemaire, Manager, Vertica Documentation
June 11, 2018

Jim Knicely authored this tip. Keywords are words that have a specific meaning in the SQL language. Every SQL statement contains one or more keywords. Many keywords are also reserved words. Vertica recommends that you not use reserved words as names for objects, or as identifiers. Including reserved words can make your SQL statements confusing....

How to Do Time Series Analysis in Vertica

Soniya Shah, Information Developer
June 11, 2018

This blog post was authored by Maurizio Felici. Time series analytics evaluate the values of a given set of variables over time and group those values into a window, based on a time interval for analysis and aggregation. There are a few types of functions that help perform time series analytics: Event based functions Time...

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’s Kathy Taylor is Honored by the Carroll Center for the Blind

Sarah Lemaire, Manager, Vertica Documentation
June 8, 2018

  Positive attitude   Education   Passion   Determination   Teamwork   According to Jay Blake, founder of Follow a Dream auto racing, those are the tools you need to overcome obstacles and be successful. More on that later. On June 7, The Carroll Center for the Blind inducted Micro Focus’s own Kathy Taylor into...

Important: gcc and Ubuntu 16.04 Incompatibility

Sarah Lemaire, Manager, Vertica Documentation
June 8, 2018

Vertica 9.0.1-9 and later 9.0 hotfixes now support Ubuntu 16.04. However, Ubuntu 16.04 ships with a compiler that is incompatible with the Vertica C++ SDK. To compile UDxs on this platform, you must install packages for 4.8 compatibility: $ sudo apt-get install gcc-4.8 $ sudo apt-get install g++-4.8 $ cd /usr/bin $ sudo ln -s...

Load Balancing Options

Soniya Shah, Information Developer
June 7, 2018

This blog post was authored by Soniya Shah. Connection load balancing automatically spreads the overhead of client connections across the cluster by redirecting connections. Each client connection a host in your Vertica cluster requires memory and processor time. If a lot of clients connect to a single host, this can affect database performance. The initiator...
Database Server Room

Loading Negative (BC) Dates: Quick Tip

Sarah Lemaire, Manager, Vertica Documentation
June 7, 2018

Jim Knicely authored this tip. I was asked recently how to load a negative date (one representing a BC date) into Vertica. Although negative dates are not valid in Vertica, the FILLER parameter of the COPY command can be used to load them. dbadmin=> \! cat /home/dbadmin/date.txt -4712-01-01 00:00:00 dbadmin=> COPY public.test FROM '/home/dbadmin/date.txt' REJECTED...

Superfast Table Copy (Revisited): Quick Tip

Sarah Lemaire, Manager, Vertica Documentation
June 6, 2018

Jim Knicely authored this tip. You learned from a Vertica Quick Tip back on 02/07/2018 that Vertica has the lightweight, in-memory COPY_TABLE function. This awesome function lets us copy huge tables in less than a second. I wanted to revisit this awesome feature to point out that when using the COPY_TABLE command, if the target...

What’s New in 9.1: Voltage SecureData Integration

Gary Gray, Principal Information Developer
June 6, 2018

Vertica Version 9.1 introduces a new integration with Voltage SecureData. This feature lets you use encryption to protect sensitive data within your Vertica database. It works within your existing database schema and clients. You can even automate data decryption. This automation makes decryption transparent and removes the need to change your existing SQL queries. What...