Vertica Blog


Vertica Joins: A Refresher

As a Vertica user, you know that using joins can improve query performance by combining records from one or more tables. But sometimes, you need to develop complex joins. Vertica supports many different kinds of joins that perform different functions based on your needs.

Unlimited Access to Vertica for SQL on Hadoop for Free!

Join the Early Adopter Program for Vertica for SQL on Hadoop to experience the full power of Vertica for SQL on Hadoop without any commitments.

What are Vertica Engineers Reading?

Ever wonder what Vertica engineers do when they aren’t busy building and perfecting an awesome product?

Using Big Data Analytical Tools for Predicting Potential Global Distribution of an Amphibian Pathogen

During the summer of 2015, I participated in an internship program with HP Vertica. Most interns assisted in software development, but my primary goal was to use HP Vertica, HP Vertica Place, and HP Distributed R to address an ecological problem

High Resolution Mapping of Biological Diversity with Vertica Place

A central goal in ecology and biogeography is to understand the distribution and diversity of biological organisms. In this blog, we use HP Vertica Place, along with R visualization techniques, to gain insight into biological data.

Vertica and Qlik Team Up to Hack for a Cause

On November 17 2014, Vertica took part in the annual Qlik Hackathon in Orlando, Florida. The hackathon, which took place the day before the Qlik World Conference, brought together engineers, developers, and Qlik experts from all over the world. The challenge was simple: leverage features from Qlik and its partners to create an application to aid the United Nations in their commitment to maintain international peace and security.

Cloning a Vertica Cluster to AWS

This enhancement to the HP Vertica AWS Auto Scaling open-source package makes it quite easy to create a working replica of your existing cloud-hosted or on-premise HP Vertica cluster in Amazon Web Services.

Why Do My License Audits Show A Significant Size Reduction?

When you run a database audit, you may notice that your HP Vertica audit size has reduced from the audit size calculated before you upgraded to version 7.1 SP2. Don’t worry, you haven’t lost any data. The size reduction is due to storage changes related to licensing.

The Benefits of Vertica for SQL on Hadoop

If you store large data sets in Hadoop, you undoubtedly face many challenges in managing and analyzing that data. Did you know that HP Vertica for SQL on Hadoop can help ? Check out the scenario that follows to learn how.

Using Geospatial Data to Perform a Spatial Analysis with Vertica Place – Boston Potholes

Today, more and more cities, companies, and citizen scientists are collecting geospatial data. From industry-leading businesses, to athletes tracking their runs as they train for a marathon, vast amounts of geospatial data are being collected each day. HP Vertica Place can help you analyze your geospatial data and gain insight into real-world challenges.