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