Vertica – Schema Design

Working with IDENTITY columns in HP Vertica

Posted onJuly 10, 2016Leave a comment

HP Vertica has 2 different types of columns that incremented automatically by the database. They are AUTO_INCREMENT and IDENTITY. The key difference is in the level of control the user has. The AUTO_INCREMENT column always starts with 1 and increments by 1. Those values are hardcoded and can not be changed. IDENTITY provides more control. Read More …

Building Projections with Optimal Segmentation in HP Vertica

Posted onJune 21, 2016July 8, 2016Leave a comment

The performance level of your queries in Vertica depend on the design of your projections. In the projection definitions you specify how your data will be segmented and how your data will be sorted. If you are going to make the right choices your queries will perform really well. In this post we will look Read More …