Vertica Blog

Vertica Technical Team

Three 3D arrows, different colors pointing in different directions

North East Database Day Conference

Vertica Technical Team
February 15, 2018

This blog post was authored by Eden Zik. On January 19th, Vertica engineers joined the North East database community for the North East Database Day conference organized annually at MIT, sponsored by Facebook and Microsoft and featuring Turing award winner Michael Stonebraker. The full conference program can be found here: http://mitdbg.github.io/nedbday/2018/ This year Styliani Pantela...

Vertica Hears From UMass Computer Science Professor

Vertica Technical Team
January 12, 2017

On December 7, Vertica employees were lucky enough to hear a talk from UMass Boston Computer Science Professor Dr. Duc A. Tran. Dr. Tran spoke to us about a distributed storage project he is working on with his students.

The Life of a Query, According to Henry Ford

Vertica Technical Team
January 10, 2017

Batch Exporting Directed Queries

Vertica Technical Team
December 16, 2016

An

Lady Problems Hackathon Series

Vertica Technical Team
November 30, 2016

The Lady Problems Hackathon series aims to address problems preventing female entrepreneurship.
Three 3D arrows, different colors pointing in different directions

Disabling Numeric Overflow

Vertica Technical Team
November 17, 2016

Prior to version 8.0, using a column that has a numeric data type with the functions SUM, SUM_FLOAT, or AVG could result in numeric overflow. Now, you have the ability to turn-off numeric overflow and add implicit precision to your numeric data types.
Modern Database Analytics

Redesigning Projections for Query Optimization

Vertica Technical Team
November 9, 2016

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