Vertica Blog

Vertica Blog

integration

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...
AWS Cloud and Vertica Future Looks Bright

Get Ready for AWS Linux 2

The Vertica team is excited to share that we have achieved the Amazon Linux 2 Ready designation as part of the (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 services. Vertica made...
Heavy rocket blasting above the clouds

Vertica Version 10 Launches Today!

There’s , on the first day of the – 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 to get industry-changing analytics, including even more advanced...
Team Touchdown with Vertica

Fill the Gaps on Your Team with BDC Sponsors

Jeff Healey’s got me thinking about analytics in sports. When I was in graduate school, I attended a sports analytics conference sponsored by MIT. As you may know, Major League Baseball has compiled dozens of statistics over the years, and at that time was adding new ones that had never been tracked before. Analytics had...
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...
Planets in solar system

The Kafka Convergence

Apache Kafka seems to be everywhere these days. I’m feeling a bit surrounded by Kafka right now, in fact, like I’m at the center of a convergence of the planets, and data flowing through Kafka is the gravitational pull. Let me give you an idea of what I mean. So, Vertica just announced the release...
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...
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...
Vertica and Amazon logos

Vertica and Amazon – Better Together, for Years

The year was 2012. Marvel’s The Avengers hit the box office. Facebook went public. NASA's Curiosity rover landed on the surface of Mars. And, the Vertica AMI (Amazon Machine Image) made its debut on , enabling data-driven organizations to easily deploy Vertica on the Amazon cloud and start accelerating their analytics. Running Vertica on Amazon...
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...
Vertica text on blue background with purple jagged data line

Datadog Announces Integration with Vertica to Monitor Performance and Availability

Datadog helps customers ensure high performance and availability of their applications by providing visibility into the full application stack: infrastructure, middleware, and applications. They have achieved this by building a robust set of turn-key integrations that include SaaS and Cloud solutions, automation tools, databases and server components, and many more. Now, they have announced integration...