Vertica Blog

Vertica Blog

Advanced Analytics

The Unified Analytics Warehouse Reaches your Data, Wherever it Lives

You may have noticed something interesting about the next generation enterprise data warehouse (EDW) vendors. They’re all pushing to ensure all data moves to the same place for analytics purposes, which of course means their particular data store. This is very worrisome to me because it involves two levels of lock in: 1) underlying infrastructure...
The Earth

“awk” sed Grep, “whoami?”. Time CC if bash makes head or tail and sort > plain.txt and make us API

Things to do whilst confined to barracks due to COVID-19 For those who know me well, having worked in IT for four decades, will know that I can be a bit of a Luddite when it comes to new-fangled technology. Give me a character-based, green-screen PuTTY application over any pointy-clicky interface.  Let me use vsql...
Unified Data Analytics Warehouse

How can you get the value out of Hadoop that you were promised?

Since Hadoop’s initial release 14 years ago, untold volumes of data have been stored in HDFS (Hadoop Distributed File System). Spread across a virtual landscape of data-inspired organizations, those data lakes are wide, and deep. Companies have made tremendous investments in Hadoop over the years, and data continues to pour into their data lakes. You...
Analytics human interest stories

Making a Difference with Analytics – Inspiring Human Interest Stories

I wake up before the sun rises, head to my home office, parse through the emails that have flowed in overnight, and look at my calendar to prepare for my day. I fill daylight hours with meetings, research, more meetings, writing … and more meetings. Sometimes, it is exhausting and even a little overwhelming. So,...

Let Business Intelligence and Data Science Coexist!

Business intelligence and data science frequently compete for resources, and BI got there first. Vertica in Eon Mode subclusters can help them coexist.
King of the Data Warehouse Mountain

Vertica Achieves Top Spot in GigaOm Radar Report for Evaluating Data Warehouse Platforms

Vertica secured the top spot, scoring consistently high rankings across the key criteria and evaluation metrics compared to 12 top competitors in the GigaOm Radar...
Heavy rocket blasting above the clouds

Vertica Version 10 Launches Today!

There’s big news today, on the first day of the Virtual Vertica Big Data Conference 2020 – a major new version of Vertica blasts off! Vertica version 10 soars straight into the greatest deployment flexibility of any analytical data warehouse on the market. This fast and extremely scalable platform gives you more power than ever...
goldfinch songbird in a field of thistle in Wales

COVID-19 Birdsong

For a number of years, when presenting one of my favourite Vertica demos, in which I talk about tracking commercial aircraft in real time, I would typically start with a short, 30-second video clip to get the audience’s attention. The inspiration for this clip came about when I was staring aimlessly into the blue sky...
Scale to the Moon - 7 petabytes

How Vertica uses limitless big data analytics to blow past small-scale vendors

As time moves on, so does data.  What was once big is now small, and what was once considered fast is now not even good enough. Ten years ago, Vertica found its place in the market with New Economy companies who were not just disrupting traditional industries but creating new ones.  Social media exploded, wearables...
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...
Larry Bird Monument - Photo by Eric Kilby WC

Practice Makes Perfect at BDC 2020

Larry Bird, Boston Celtics legend and NBA Hall of Famer, shot 500 free throws every morning before his first class in high school. But, he didn’t stop there. Larry was known to shoot 100 free throws after every NBA game. The result? The sharp-shooting forward from French Lick, Indiana led the NBA in free throw...
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,...