Vertica Blog

Vertica Blog

AWS

hands in surgical gloves hold vial with small amount of blood

Is Data Warehouse as a Service Out for Your Blood?

Last weekend, I finally had the chance to watch the popular, yet alarming HBO documentary – . If you haven’t seen it, it’s a true story that centers on Elizabeth Holmes, ex-Theranos CEO, who dropped out of Stanford to build a company that promised to revolutionize blood testing using a small amount of blood from...

How to Access Flexible, Cloud-Optimized Analytics on AWS

Vertica was designed from the very first line of code to be a software-only data warehouse with complete freedom from underlying infrastructure, giving you the choice to decide what hardware to use and where. This commitment to flexibility is evident in our product history, as we took the same core MPP analytics engine from commodity...
Passenger balloon floating in blue sky

Announcing Vertica Version 9.2.1 – Take Analytics Efficiency to the Next Level

This week, some very cool things have gone into the newest version of the that make your analytics fly and save on your AWS budget. The theme for this release is Improving Vertica in Eon Mode Integration with Amazon S3, and there are a whole bunch of new features designed to do exactly that. But,...

What’s New in Management Console 9.1

This blog post was authored by Lisa Donaghue. In Vertica 9.1, Management Console (MC) introduces improved monitoring for external tables and HCatalog data, and the ability to revive Eon Mode databases in a new cluster. MC also includes management and monitoring capabilities for databases running in Eon Mode, a database mode previously in beta. Eon...
Convenience in big letters in the center and lots of little images around it of conveniences like mobile phones, global searches, public transportation, etc.

Convenience But at What Cost?

Convenience is so important to me. Move quickly and get things done. That’s probably why I am so addicted to Amazon Prime despite the fact that I could save money if I would just do a little research and find better prices for the things I buy. My impatience and one click buyer behavior is...

Master Blog Series : Vertica in Eon Mode

This post was authored by Soniya Shah. In Vertica 9.0 we introduced Eon Mode. Since then, there have been many improvements in recent releases. Vertica in Eon Mode is a new architecture that separates compute and storage, allowing users to take advantage of cloud economics that enable rapid scaling and shrinking of clusters in response...

Vertica Quick Tip: Keepalive settings for AWS Network Load Balancer

Serge Bonte authored this post. Network Load Balancers are one of the three types of load balancers supported by Amazon’s Elastic Load Balancing. See: Since load balancers act as a proxy between clients (such as JDBC) and Vertica servers, it is important to understand how AWS’s NLB handle idle timeouts for connections. The idle timeout...
House diagram showing sensors for lights, weather, security, internal temp, etc.

The Internet of Things (IoT) and Smart Metering

Every month, my husband receives a driver’s report from Chevrolet, providing him with “feedback” on his driving behavior – everything from the intensity of his braking to the number of lane changes without a blinker to the distance and speed he drove in his Silverado truck. The report also provides specific details on the upcoming...

Announcing Vertica in Eon Mode for Amazon Linux 2, now available in AWS Marketplace

Vertica is a blazingly fast SQL analytics database, enabling enterprises to access and derive meaningful insight into big data in sub-seconds or minutes rather than hours or days. Vertica powers the world’s most data driven organizations, delivering unmatched speed and scale with the full suite of advanced analytics and in database machine learning. Vertica for...
Three 3D arrows, different colors pointing in different directions

IMPORTANT: Vertica and Amazon Linux 2.0 gcc Compatibility Problems

This blog post was authored by Monica Cellio, with Serge Bonte. The Vertica binaries are compiled using the default version of g++ installed on the supported Linux platforms. Vertica requires a minimum of gcc version 4.8.4. The default version of g++ on Amazon Linux 2.0 is not compatible with gcc 4.8.4. To be able to...

Reusing EBS Volumes

This blog post was authored by Mark Hayden. You can deploy a Vertica cluster running in Eon or Enterprise mode using EC2 instances that support EBS volumes. This document provides the steps you need to use EBS volumes that were preserved from a Vertica cluster that was terminated, and how to reattach them to revive...

Vertica in Eon Mode: Revive

This blog post was authored by Soniya Shah. Overview An Eon Mode database keeps an updated version of its data and metadata in a communal storage location. After you shut down the database, the data continues to reside in communal storage. When you are ready to use the storage again, you can revive the database...