Vertica Blog

Vertica Blog

Under the Hood

How Do I Manage Delete Vectors?

Soniya Shah, Information Developer
June 14, 2018

If you want to remove delete vectors manually or troubleshoot why they are not being removed automatically, follow this checklist. Step Task Results 1 Check if you have too many delete vectors (more than 100) in a projection. If there are too many delete vectors as shown by the num_dv (usually more than 100), go...

What Should I do When the Database Process is not Starting?

Soniya Shah, Information Developer
June 14, 2018

If you want to troubleshoot why the database process is not starting, follow this checklist. Step Task Results 1 Ensure Vertica is not already running on any node. The Vertica process displays as follows: Prior to proceeding to any further checks, ensure the dbadmin is the owner of and has access to the catalog directory...

What Should I do When the Database Node is DOWN?

Soniya Shah, Information Developer
June 14, 2018

When database node is DOWN, troubleshoot using the following checklist. Step Task Results 1 Check whether your database is UP. If the database is UP, go to Step 2. If the database if not UP, restart your database. If the database starts, the checklist is complete. If the database does not start, see the Database...

What Version of Vertica am I Running?

Sarah Lemaire, Manager, Vertica Documentation
June 14, 2018

Jim Knicely authored this tip. The built-in VERSION function returns a VARCHAR that contains your Vertica node's version information. The Vertica version is formatted as X.Y.Z-R, where… • X.Y is the two-digit Vertica major release number, e.g., 8.1, 9.0 and 9.1 • Z is the service pack number, e.g., 7.2.3, 8.1.1 and 9.0.1 • R...

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

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

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

Can you tell us about your data lake?

Soniya Shah, Information Developer
June 5, 2018

It's the fourth round of Vertica product management surveys and we have really appreciated getting your feedback! In this survey, we want to know all about your data lake. We want to know what tools you use, how much data is in your lake, and the types of workloads you are running. We are hoping...

Make data analysis easier with dimensionality reduction

Soniya Shah, Information Developer
June 5, 2018

This blog post was authored by Anh Le. Introduction As the number of features in your data set grows, it becomes harder to work with. Visualizing 2D or 3D data is straightforward, but for higher dimensions you can only select a subset of two or three features to plot at a time, or turn to...

Reusing EBS Volumes

Soniya Shah, Information Developer
May 24, 2018

This blog post was authored by Mark Hayden. You can deploy a Vertica cluster running in Eon or Enterprise mode using EC2 instances that support EBS volumes. This document provides the steps you need to use EBS volumes that were preserved from a Vertica cluster that was terminated, and how to reattach them to revive...

Vertica in Eon Mode: Revive

Soniya Shah, Information Developer
May 23, 2018

This blog post was authored by Soniya Shah. Overview An Eon Mode database keeps an updated version of its data and metadata in a communal storage location. After you shut down the database, the data continues to reside in communal storage. When you are ready to use the storage again, you can revive the database...