myVertica  

Vertica Blog

8.0

What’s New in Vertica 8.0.1: Geospatial Improvements

Vertica 8.0.1 is chockful of great new features, two of which expand our geospatial capabilities. First, Vertica has improved performance when building a spatial index of polygons. Prior to 8.0.1, Vertica checked the validity of all polygons before creating or refreshing a spatial index. By eliminating the validity check, the index builds faster. With this […]

What’s New in Vertica 8.0.1? Backup Enhancements

HPE Vertica 8.0.1 includes two enhancements to Vertica’s backup capability. Read on for the details.

 

Vertica 8.0 New Features: UDxs in Python

Vertica 8.0.0 adds the ability to create user-defined extensions using the Python programming language. If you know Python, you can now create your own custom functions that work in your Vertica queries!

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.

 

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.

What’s New in 8.0: Apportioned Load

We’ve expanded apportioned load functionality in Vertica 8.0. Read on to learn more. 

What’s New In Vertica 8.0.0: Tuple Mover Can Run During Recovery

 If a database node is in the RECOVERING state, Tuple Mover can perform moveout and mergeout operations as needed during the recovery.

What’s New in 8.0: FIPS Compliance

Data security is an important part of managing your big data. Learn more about FIPS compliance with Vertica 8.0. 

Introducing the Connector for Apache Spark

In Vertica version 8.0.0, we added integration for Apache Spark through our HPE Vertica Connector for Apache Spark. This is a fast parallel connector that allows you to transfer data between Apache Spark and Vertica.