Vertica Blog

Vertica Blog

8.1

New Uses for Directed Queries

Soniya Shah, Information Developer
May 30, 2017

Directed queries were introduced in Vertica 7.2. Directed queries were originally designed to achieve two goals: • Preserve current query plans before a scheduled upgrade. • Enable you to create query plans that improve optimizer performance. Since their introduction, users have found new and compelling ways to use directed queries—notably, using them to substitute one...

What’s New in Vertica 8.1: Connecting to Vertica Updates

Phil Molea, Sr. Information Developer, Vertica
May 1, 2017

Vertica 8.1 includes the following product enhancements to Connecting to Vertica. Functional Updates to \timing The \timing metafunction has been enhanced so you can use the following commands to toggle \timing on or off based on its current setting: •\timing – turns timing on or off depending on its current state. For example if timing...

What’s New in Vertica 8.1: Security Updates

Phil Molea, Sr. Information Developer, Vertica
April 27, 2017

Vertica 8.1 includes the following enhancements to Vertica security. Function to Verify Kerberos Configuration The function KERBEROS_CONFIG_CHECK allows you to test your Kerberos configuration of the Vertica cluster. Running this function checks: • Whether or not Kerberos services are available. • If a keytab file exists • If the Kerberos configuration parameters are set in...
Database Server Room

What’s New in Vertica 8.1: Machine Learning

Soniya Shah, Information Developer
April 25, 2017

This blog post was authored by Soniya Shah. Overall, you will notice that Machine Learning for Predictive Analytics, introduced in Vertica 7.2.2, is more accessible to use in Vertica 8.1, with the addition of several important functions. There are improvements to model management with access control ability to save and re-apply normalization parameters, missing value...

What’s New in Management Console 8.1

Lisa Donaghue
April 24, 2017

Vertica 8.1 introduced new monitoring and usability enhancements to Management Console (MC). MC now provides the ability to easily monitor catalog memory and configure Workload Analyzer. You’ll also find usability improvements to cluster creation and setup for Extended Monitoring. Watch our short video about What's New In MC in Vertica 8.1: https://www.youtube.com/watch?v=2yqzCAZGyeA&feature=youtu.be Read on to...

What’s New in Vertica 8.1: the Connector for Apache Spark

Gary Gray, Principal Information Developer
April 20, 2017

The Vertica 8.1 release includes updates for the Vertica Connector for Apache Spark. The biggest new feature is Apache Spark 2.0 compatibility. This makes the connector compatible with the version of Spark included with most recent Hadoop distributions. In addition, the connector supports multiple versions of the Scala programming language. Most Hadoop distributions that support...

What’s New in Vertica 8.1: Supported Platforms

nunziato
April 18, 2017

With Vertica Release 8.1, we continue to enhance and broaden our platform support. New Operating Systems for Vertica Server Vertica continues to perform extensive testing as we qualify major Linux distributions for use with the Vertica Analytic Database. Our testing ensures both stability and performance when you use Vertica with a supported operating system. For...

What’s New in Vertica 8.1?

Chana Zolty
April 17, 2017

Watch this video to learn what’s new in Vertica version 8.1. New features include: - flattened tables - supported platforms update - Management Console features - Kafka connectivity update - machine learning functions - rack locality - Geohash conversions - security upgrades - wide column data query improvement