Vertica Blog

Vertica Blog

Analytics

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

Award Winning – Vertica Proves It

June has been quite a month of industry recognition for Vertica and its customers. Fresh off earning top leadership position in GigaOm’s Radar Report for Evaluating Data Warehouse Platforms, Vertica has once again been named to this year’s DBTA 100 Companies that Matter Most in Data, a special list that salutes today’s top companies in...
Visual Storytelling

VSQL, Visual Storytelling through Query Language

This tip expands on my earlier post: “Pure Vertica SQL Graph Flavors” Visual story telling has not just the ability to capture attention, it make things simple to understand. Consider the following to boost your query result set readability. What is the visual correlation between CPU utilization and Canary Queries elapsed time?      ...

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...
Focused young woman working at laptop in office

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

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

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...
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: https://www.kaggle.com/borismarjanovic/price-volume-data-for-all-us-stocks-etfs This data source provides several thousand files...

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