myVertica  

Vertica Blog

Optimization

What’s New in Vertica 8.0.1?

Learn what’s new in Vertica version 8.0.1!

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.

Introducing Vertica Troubleshooting Checklists

HPE Vertica is excited to announce the launch of our newest customer resource: Vertica Troubleshooting Checklists.