Vertica Blog

Constellation Research Report Finds Vertica 10 a Leading Choice

Posted September 14, 2020 by Mike Perrow, Senior Product Marketing Writer/Editor

Read More

Cloud analytics

Vertica now available as a managed service from Full 360

The Vertica partner ecosystem is steadily growing, with a who provide help with implementation, professional services, and value added reselling. This means that if you’re new to Vertica, or working to create your own data platform for the first time, you’ll find the right expertise within our ecosystem. Now, we’re happy to report that Full...

DX Radio Episode 3: Climate Corporation and Digital Agriculture

I have the honor of hosting the latest episode of DX Radio. It features The Climate Corporation’s Daniel McCaffrey, Vice president of Data and Analytics, and Erich Hochmuth, Big Data Architect Engineer, as they explore the digital transformation of farming.
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...
Community Edition

Join the Powerful Vertica Big Data Community Open House with Free Community Edition

What comes to mind when you hear the word “community”? A village, a neighborhood? Maybe sidewalks where people say hello, where they have a few things in common – perhaps an identity, sometimes a sense of pride, definitely a sense of belonging. We’re social creatures, so being part of a community means sharing experiences, too,...

Subscribe For Email Updates

Enter your email address to receive the monthly Vertica newsletter.

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

Vertica and Attunity Replicate Change Data Capture

Attunity Replicate is a software solution that loads data from multiple sources and accelerates data integration for analytics, replication, streaming, and synchronizing, on-premises and in the cloud. Attunity Replicate and Vertica integration exists for Vertica as a Target. This integration enables moving large volumes of data from multiple sources into the Vertica database. It leverages...

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 , Vertica has once again been named to this year’s , a special list that salutes today’s top companies in data management and analysis. Vertica Named to DBTA 100 Companies that Matter Most in...

Explore Popular Topics

A man and woman looking under the hood

Tune in for Monthly Vertica Tune-Ups

Our Under the Hood Webcast series builds on the engineering-led sessions that our product and R&D teams deliver at our annual . 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 popular topics these...

Perfect Vision 20/20 – Vertica’s 20 coolest features to see in 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...
Quick Tip - blue button

Copy a Table with an Identity to a Table with an Identity on the Same Database Keeping the Identities in Sync

An IDENTITY associates a table column with a sequence. This sequence automatically increments the column value as new rows are added. There are some noteable restrictions on IDENTITY columns: You cannot INSERT values manually into an IDENTITY column You cannot UPDATE the values of an IDENTITY column once they has been populated via the sequence...
Visual Storytelling

VSQL, Visual Storytelling through Query Language

This tip expands on my earlier post: “” 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?       hour_slice      |   node_name    |...

Tips and Techniques for Vertica Integration with Denodo

Denodo is a data federation tool that integrates data from various data sources including enterprise, big data, cloud, and real-time data services. It enables you to quickly and easily access data through reports, dashboards, mobile, and web applications for analytical and operational use cases. Denodo already has an integration with Vertica. It leverages Vertica’s query...

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.