Three 3D arrows, different colors pointing in different directions

IMPORTANT: Vertica and Amazon Linux 2.0 gcc Compatibility Problems

Sarah Lemaire, Manager, Vertica Documentation
May 31, 2018

This blog post was authored by Monica Cellio, with Serge Bonte. The Vertica binaries are compiled using the default version of g++ installed on the supported Linux platforms. Vertica requires a minimum of gcc version 4.8.4. The default version of g++ on Amazon Linux 2.0 is not compatible with gcc 4.8.4. To be able to...
Modern Database Analytics

Vertica Quick Tip: Replacing an Empty String

Soniya Shah, Information Developer
May 31, 2018

This blog post was authored by Jim Knicely. In Vertica an empty string is not treated as a NULL value, so an empty string does equal an empty string. The function REPLACE replaces all occurrences of characters in a string with another set of characters. The REPLACE function appears to work well with an empty...
Programmer

What’s New in Vertica 9.1: Python SDK Expands

Soniya Shah, Information Developer
May 30, 2018

This blog post was authored by Monica Cellio. Using the Vertica SDK, you can write several types of user-defined extensions (UDxs) to add your own customizations. In a previous release the SDK added Python support for one type, scalar functions (UDSFs). In 9.1 we added Python support for transform functions (UDTFs). User-Defined Transform Functions (UDTFs)...

Subscribe For Email Updates

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

Sign-up

Programmer

Vertica Quick Tip: Empty String Vs. NULL

James Knicely, Vertica Field Chief Technologist
May 30, 2018

An empty string ('') is treated as a NULL value in Oracle, while in Vertica an empty string is not treated as a NULL value. So when using Vertica, if you want to indicate that a column value is unknown, be sure to use NULL and not an empty string! In Oracle: Are they the...

Vertica Quick Tip: Which Column in my Flattened Table caused the “Subquery used as an expression returned more than one row” Error?

Soniya Shah, Information Developer
May 29, 2018

This blog post was authored by Jim Knicely. A flattened table contains columns that are derived from query-expressions that must return only one row and column value, or none. If a column’s query-expression does return more than one row you will get a “Subquery used as an expression returned more than one row” error. If...

Announcing Vertica 9.x Query Performance Tuning Training

Soniya Shah, Information Developer
May 29, 2018

This blog post was authored by Drea Brandford. You have had Vertica up and running in production for a while now; but you’re noticing that, while your analytic queries are executing far faster than they would in a traditional row-store database, they are still not performing quite as fast as you need them to. Chances...

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

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...
Database Server Room

Vertica Quick Tip: Tuple Mover (TM) Assigned More Resources in Vertica 9.1

Soniya Shah, Information Developer
May 24, 2018

This blog post was authored by Jim Knicely. In version 9.1 and later, Vertica increases the default amount of memory assigned to the Tuple Mover (TM) resource pool from 200MB to 5% of available memory to improve performance merging out wide tables. If your General resource pool is defined by a percentage, the Tuple Mover...

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

Vertica Quick Tip: Monitoring the Ancient History Mark

Soniya Shah, Information Developer
May 23, 2018

This blog post was authored by Jim Knicely. Also known as AHM, the ancient history mark is the oldest epoch whose data is accessible to historical queries. Any data that precedes the AHM is eligible to be purged. If a cluster nodes is down or if a database contains projections that need to be refreshed,...

Vertica Quick Tip: Determining Table Columns that Contain NULL Values

Soniya Shah, Information Developer
May 22, 2018

This blog post was authored by Jim Knicely. A client recently asked if we had a Vertica function that could return a list of columns from a table which contain NULL values. There aren’t any built-in functions for that, but there is always a fast solution available in Vertica! Here’s one! dbadmin=> CREATE OR REPLACE...

Why All Column Stores Are Not the Same

Soniya Shah, Information Developer
May 22, 2018

This blog post was authored by Steve Sarsfield. Critical Capabilities for Big Data Databases Imitation is the sincerest form of flattery, but when imitators try to match brilliant engineering against uninspiring execution in order to meet the needs of a bullet on a PowerPoint slide, the imitation tends to be more of a parody, or...