myVertica  

Vertica Blog

Optimization

Batch Exporting Directed Queries

An earlier blog 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.

Modernizing Your Data Warehouse with “Sparkitecture”: Vertica at Strata + Hadoop World Conference

In September, Jack Gudenkauf and Deepak Majeti of the HPE Big Data Platform spoke about building enterprise architecture for modern warehouses at the Strata + Hadoop World Conference. Read this post to learn more!

What’s New in Vertica 8.0: Machine Learning Enhancements

Overall, you will notice that Machine Learning for Predictive Analytics, introduced in Vertica 7.2.2, is more accessible and intuitive to use in Vertica 8.0. The API has been streamlined, and it’s easier to get up and running. Also, there are additional options for data preparation.

Disabling Numeric Overflow

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.

 

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 you can do to optimize your projections to improve query performance

Post-upgrade Tasks for Saving Catalog Space

When you upgrade to 7.2 and later, not only can you take advantage of the new features, you can perform tasks to save substantial space in your Vertica catalog.

Visual Guide to Data Loading with Vertica

This blog provides excerpts from our visual guide to loading data in HPE Vertica. For the full visual guide, see the attached PDF file.

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 the Query Performance Tuning and Troubleshooting Issues session at HPE Vertica’s Big Data Conference.

Do You Need to Put Your Query on a Budget?

Before we scare you away with the word “budget,” rest assured that after reading this blog, you won’t have to give up your favorite activities or sell your car. What you will be able to do is understand how Vertica resource pool parameters affect query budget.

Which One of These is Not Like the Others?

With the new guaranteed uniqueness optimization feature in Vertica 7.2.2, Vertica automatically recognizes when a query is accessing columns with unique values and optimizes the query operations that would otherwise be bogged down due to duplicate values.