Vertica Blog

Vertica Blog

Under the Hood

A man and woman looking under the hood

Tune in for Monthly Vertica Tune-Ups

Jeff Healey, Vice President of Marketing, Vertica Product Group in Micro Focus
June 9, 2020

Our Under the Hood Webcast series builds on the engineering-led sessions that our product and R&D teams deliver at our annual Vertica Big Data Conference. You can tune in nearly every month and get a deep dive of Vertica features and releases through this popular series. Last month, Vertica R&D covered one of our most...

Perfect Vision 20/20 – Vertica’s 20 coolest features to see in 2020

Mark Whalley, Manager, Vertica Education
June 4, 2020

I was asked some time ago whether Vertica was just another SQL database.  I could have just said “Yes” and left it at that. However, my passion for Vertica would never have allowed me to leave it at that.  Rewording a famous UK High Street retailer’s tag-line, “This is not just any SQL database, this...
AWS Cloud and Vertica Future Looks Bright

Get Ready for AWS Linux 2

Jeremiah Morrow, Senior Industry Product Marketing Manager
April 21, 2020

The Vertica team is excited to share that we have achieved the Amazon Linux 2 Ready designation as part of the Amazon Web Services (AWS) Service Ready Program. The AWS Service Ready Program is designed to help customers identify products that integrate with AWS services in order to quickly evaluate tools that run on AWS...
WOS ROS differences

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

Sumeet Keswani, Vertica Product Technology Engineer
March 23, 2020

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

Mike Perrow, Senior Product Marketing Writer/Editor
March 12, 2020

Since Vertica Academy 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...
Flight Tracking

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

Mark Whalley, Manager, Vertica Education
February 26, 2020

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

Bryan Herger, Vertica Big Data Solution Architect at Micro Focus
February 20, 2020

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!

Bryan Herger, Vertica Big Data Solution Architect at Micro Focus
February 4, 2020

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

Bryan Herger, Vertica Big Data Solution Architect at Micro Focus
January 21, 2020

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: https://www.kaggle.com/borismarjanovic/price-volume-data-for-all-us-stocks-etfs This data source provides several thousand files...
Cubes with binary ones and zeroes on them clustered together floating in blue space with light shining out

2 – What Are the Benefits of Using Complex Data Types in SQL?

Waqas Dhillon, Product Manager - Machine Learning, Vertica
December 19, 2019

Co-authored by James Clampffer, Deepak Majeti. In this second post in the Complex Data Types 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 first post in this series where we discussed the what complex data...

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

Bryan Herger, Vertica Big Data Solution Architect at Micro Focus
December 17, 2019

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

Drea Brandford, Technical Consultant
November 21, 2019

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