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: 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...