Vertica Blog

Vertica Blog

Under the Hood

WOS ROS differences

Write Optimized Store (WOS) Deprecation – What You Need to Know

In Vertica 10.0, WOS (Write Optimized Store) will be deprecated. In this blog, we introduce the historical justification for WOS and its purpose, why we believe that it's no longer needed, and our justification for deprecating it. We'll go over the data and the testing we performed that gives us the confidence to ensure that...
Focused young woman working at laptop in office

New hands-on training at Vertica Academy takes users deep into Vertica Essentials

Since was launched in September 2019, this versatile online training portal has acquired more than 1,500 registered users (as of beginning of March), and that number is growing daily. Users are finding answers to tough questions that arise as they explore the complex world of big data analytics. They’re finding self-paced courses, webinars and certifications,...
Flight Tracking

Pennard, We Have a Problem – Troubleshooting Flight Tracking with the Grafana Plugin for Vertica

With Vertica’s Management Console, I have everything I need at my fingertips to manage and monitor my Vertica clusters and databases.  Whether that be investigating query performance issues, checking on the health of the cluster’s nodes, running the Database Designer or marveling at the volume of data being ingested by the Vertica Scheduler from a...
Global Partitions

Optimizing Vertica Data With Partitions

How do partitions affect overall Vertica operations? Let’s look at a snapshot of the Flight Data Tracker dataset and compare performance ...
Map with pins

Loading ZIP Code Boundaries from a Shapefile in Three Easy Steps!

Are you working on a project where you'd like to classify position data into a geographic region? The US Census Bureau provides shapefiles for ZIP code tracts that you can ingest into Vertica and use to identify the ZIP code for given coordinates. In this exercise, we'll load the shapefile into Vertica, examine the contents,...
Business man showing profitable stock market graph hologram over a tablet.

Finding Patterns in Stock Prices With Vertica

Vertica can ingest data from many sources and enable SQL-based preparation and analytics. Here is another real-world example: Let's use Vertica to find patterns in a public data set of stock and (Exchange-Traded Fund) ETF prices from Kaggle. I’ll use the following data source in this post: This data source provides several thousand files for...
Cubes with binary ones and zeroes on them clustered together floating in blue space with light shining out

Complex Data Types in SQL 2 – Benefits of SQL Support

Co-authored by James Clampffer, Deepak Majeti. In this second post in the blog series, let’s look at some of the reasons complex types are used extensively in organized big data formats like ORC and Parquet. Be sure to read the in this series where we discussed the , and explored the various complex types in...

Vertica on the Road! Using Vertica to Prepare and Analyze Vehicle Telematics Data

Vehicles generate a lot of data from onboard electronics and there is increasing interest in monitoring vehicle handling to help assess insurance risk and premiums. At Vertica, we're working with a few auto manufacturers, so I built this demo to show a relatively simple example of data collection, aggregation and preparation, and analysis of the...

Announcing Vertica 9.3 Instructor-Led Training Courses

Just in time for the release of version 9.3, Vertica is pleased to announce the release of two updated instructor-led training courses: Vertica 9.3 Essentials and Vertica 9.3 Descriptive Analytics. A description of each course follows: Vertica 9.3 Essentials This 4-day course explores the capabilities of the Vertica platform solution in Enterprise mode, and prepares...

Checking and Improving Column Compression and Encoding

When working with terabytes of data, storage and transfer become major time and cost sinks. Vertica can help minimize storage cost and transfer time with column compression and encoding. How can we identify Vertica tables that might benefit from compression? Information about column size and current compression is stored across column_storage and projection_columns table. The...
Cubes with binary ones and zeroes on them clustered together floating in blue space with light shining out

Complex Data Types in SQL 1 – What Are They?

Co-authored by James Clampffer, Deepak Majeti. A lot of projects require querying ORC or Parquet files, or other data that may have internal types that are a bit more complex than usual. We support some of those complex types now, and are dedicated to adding full support for all complex types in Vertica. It’s a...
View from above of a sailing ship in the ocean with the sail full and the crew leaning to one side to balance

Announcing Vertica Version 9.3 – Ride the Winds of Change

The have been blowing strong. This week, Vertica version 9.3 made its big splash. Vertica has a tendency to pack a lot of features even into minor releases, and this is not a minor release. Rather than dive deep, I’m going to skim the surface of the ocean of new features. Eon Mode Improvements Eon...