Vertica Blog

Vertica Blog

queries

Create Read Update Delete in red 3D letters surrounded by 3D ones and zeroes

Vertica 9.3 Supports UPDATE and DELETE Operations on Tables Having Live Aggregate Projections!

A live aggregate projection contains columns with values that are aggregated from columns in its anchor table. When you load data into the table, Vertica aggregates the data before loading it into the live aggregate projection. On subsequent loads (for example, through INSERT or COPY) Vertica recalculates aggregations with the new data and updates the...
View from above of a sailing ship in the ocean with the sail full and the crew leaning to one side to balance

Announcing Vertica Version 9.3 – Ride the Winds of Change

The have been blowing strong. This week, Vertica version 9.3 made its big splash. Vertica has a tendency to pack a lot of features even into minor releases, and this is not a minor release. Rather than dive deep, I’m going to skim the surface of the ocean of new features. Eon Mode Improvements Eon...
Focused young woman working at laptop in office

The Vertica Academy Is Open for Learning

One of the greatest impacts from digital transformation, both from a personal and professional point of view, is not just the democratization of data - a very popular topic here at Vertica! - but the democratization of knowledge. Today, we are excited to announce the new, a platform that offers self-paced, technical training and certifications...
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,...

Batch Exporting Directed Queries

An covered the first edition of directed queries, which appeared with the first release of Vertica 7.2. With each release since then, Vertica has offered various enhancements to directed queries functionality."
Three 3D arrows, different colors pointing in different directions

Looking Under the Hood at Vertica Queries

When you submit a query to Vertica, you want it to execute as quickly and efficiently as possible. The query optimizer creates a plan that is designed to do just that. The directives in the query plan determine your query's run-time performance and resource consumption, but the properties of your projections and the system parameters also impact...

Tell the Optimizer You Have a Better Plan

You're upgrading your database and some query appears to execute less efficiently than before. What can you do? Vertica addresses this concern in Vertica 7.2 with directed queries

The Benefits of Single Node Queries

If your organization deals with low latency, high concurrency applications and queries, you can benefit from having as few nodes as possible involved in each query.

Vertica Best Practices: Identifying Queries for DBD

The Vertica Database Designer is a tool that analyzes a logical schema definition, sample queries, and sample data, and creates a physical schema (projections) in the form of a SQL script that you deploy automatically or manually. The result is an optimized database with optimal query performance and data compression.

Live Aggregate Projections with Vertica

The Dragline release of Vertica offers an exciting new feature that is unique in the world of big data analytics platforms. We now offer Live Aggregate projections as part of the platform. The impact is that you can really fly through certain types of big data analytics that typically grind down any analytics system.