Vertica Blog

Vertica Blog

Vertica Blog

Vertica Goes to UMass Amherst

Read this blog about Vertica's visit to the UMass Amherst Engineering and Technology Career Fair!
Modern Database Analytics

Redesigning Projections for Query Optimization

When you submit a query to Vertica, the Vertica query optimizer automatically assembles a query plan, which consists of a set of operations to compute the requested result. Depending on the properties of the projections defined in your database, the query optimizer can choose faster and more efficient operations. Thus, it?s important to recognize what...
Programmer

Customize Your Security Authentication in Vertica

Learn more about authentication methods in Vertica.

Best Practices for Using LDAP Link with Vertica

There are a few best practices that you should follow to make sure that you don't accidentally lose any users or data. This blog explains how to keep your LDAP Link service working smoothly.

Post-upgrade Tasks for Saving Catalog Space

When you upgrade to 7.2 and later, not only can you take advantage of the

Investigating Public Data: Road Safety in the U.K.

When learning new database applications, a good place to start is with some compelling, real-world data. It's not necessarily so easy to find.

Meet our 2016 Summer Interns!

Our interns had an exciting summer at Vertica. Watch the video to learn more!

Introducing the Connector for Apache Spark

In Vertica version 8.0.0, we added integration for Apache Spark through our Vertica Connector for Apache Spark. This is a fast parallel connector that allows you to transfer data between Apache Spark and Vertica.

Troubleshooting Vertica Query Performance with System Tables

Do you want to learn how to troubleshoot your query performance issues?  We've got you covered. Just attend

How to Load New Data and Modify Existing Data Simultaneously

Originally posted 8/27/2012 Many Vertica customers tell us “we have an OLTP workload” which is not Vertica's architectural sweet spot. However, when we dig into what they are actually doing, it often turns out that they are simply bulk loading mostly new data with some small number of updates to existing rows. In Vertica 6,...
Programmer

The Right Tool for the Job: Using Apache Hadoop with Vertica for Big Data Analytics

I have an entrepreneur friend who used to carry a butter knife around.  He claimed this “almighty” tool was the only one he ever needed!  While the butter knife does serve a wide range of purposes (especially with a stretch of the imagination), in practice it doesn't’ always yield optimal results.  For example, as a...

Vertica Interns Develop Real-World Business Solutions

It is a rare opportunity for interns at Vertica to be assigned to the same project. This summer, three interns have been working closely with the Partner Engineering team to build a data generator.