Vertica Blog

Vertica Blog

Vertica Blog

Try out the new Vertica Community Edition Virtual Machine!

Soniya Shah, Information Developer
November 6, 2017

This blog post was authored by Kathy Taylor. New to Vertica? Wondering where to start? Why not start with our new 8.1.1 Community Edition VM? It's free! Just download the VM and start it up in a VM player on your PC. Open the User Guide, start the exercises, and off you go! You'll be...

What’s New in Vertica 9.0: Security and Authentication

Soniya Shah, Information Developer
November 2, 2017

This blog post was authored by Phil Molea. Multi-realm Support Vertica 9.0 introduces multi-realm support for Kerberos authentication. This allows you to assign a different realm so that users from another realm can authenticate to Vertica. At times, customers may store users in a protected directory server (AD or Linux KDC) for their trusted realm....
Three 3D arrows, different colors pointing in different directions

What’s New in Vertica 9.0: Google Cloud Platform

Soniya Shah, Information Developer
November 1, 2017

This blog post was authored by Chris Daly. Announcing Vertica availability in Google Cloud Platform With the release of Vertica 9.0, the team at Micro Focus has brought you a ton of new updates and enhancements that are certainly worthy of getting excited about! If you haven’t had a chance, you should check out the...
Modern Database Analytics

Machine Learning Mondays: Vertica 9.0 Cheat Sheet

Soniya Shah, Information Developer
October 30, 2017

This blog post was authored by Vincent Xu. Vertica 9.0 is out and here is the updated Vertica machine learning cheat sheet. Vertica 9.0 introduces a slew of new machine learning features including one-hot encoding, Lasso regression, cross validation, model import/export, and many more. See the cheat sheet for examples of how to use the...

What’s New in Vertica 9.0: Machine Learning Enhancements

Soniya Shah, Information Developer
October 26, 2017

This blog post was authored by Soniya Shah. Vertica 9.0 introduces new functionality that continues to match our goals for fast-paced development of the existing machine learning functions. In this release, we introduce two new summary functions, support for cross validation, support for one hot encoding, and the ability to import and export your models...

Vertica Deep Dive Comes to Boston: #OwnTheNew

Soniya Shah, Information Developer
October 24, 2017

This blog post was authored by Sarah Lemaire. Two weeks after the successful Deep Dive in Los Angeles, Boston-area Vertica users had the unique opportunity to meet with Sumeet Keswani and Shrirang Kamat from the Vertica Customer Experience Team. These two Vertica experts offered attendees tips for managing their Vertica environment for maximum performance. These...
Database Server Room

What’s New in Vertica 9.0: Reading Parquet and ORC from S3

Soniya Shah, Information Developer
October 23, 2017

This blog post was authored by Monica Cellio. Parquet and ORC are widely-used Hadoop columnar file formats. Because these formats are columnar, they perform extremely well when queried as external tables in Vertica. Vertica queries implement column selection, predicate pushdown, and partition pruning. Vertica has supported reading Parquet and ORC data from HDFS or from...

Vertica 9

Soniya Shah, Information Developer
October 18, 2017

This blog post was authored by Steve Sarsfield. The Vertica development team has just released Version 9.0. With every major release it gives me time to not only look back and see what was developed this cycle, but a look at the entire timeline. I joined the Vertica team about 4 years ago in the...
Database Server Room

What’s New in Vertica 9.0: Eon Mode Beta

Soniya Shah, Information Developer
October 17, 2017

This blog post was authored by Soniya Shah. What is Eon Mode Beta? With Vertica 9.0, you can run Vertica in Eon Mode Beta, using Amazon Web Services to capitalize on cloud economics while still enjoying the fast query processing for which Vertica is known. Running Vertica in Eon Mode Beta separates the computational processes...

What’s New in Vertica 9.0?

Soniya Shah, Information Developer
October 16, 2017

This blog post was authored by Soniya Shah. In Vertica 9.0, we introduce new functionality including: • Eon Mode Beta • Supported Platform Updates • Machine Learning Enhancements • Apache Hadoop Integration Updates • Partition Grouping and Hierarchical Partitioning • Browsing S3 Data Using External Tables • Support for the UUID Data Type Eon Mode...

CPU and Memory Starvation in SPREAD

Soniya Shah, Information Developer
October 12, 2017

This blog post was authored by Sumeet Keswani. What is Spread? Vertica uses an open source toolkit, Spread, to provide a high-performance control message service. Spread daemons start automatically when your database starts up for the first time. The spread daemons run on control nodes in your cluster. The control nodes manage message communication. On...

Effective vsql in Vertica

Soniya Shah, Information Developer
October 10, 2017

This blog post was authored by Maurizio Felici. vsql is included in each Vertica installation and is lightweight, with a tight integration with Vertica. Vsql is installed on every Vertica server and can also be installed on non-server hosts using the client package. Executing SQL commands through vsql is often faster than navigating GUI's menu....