Machine Learning Mondays: Vertica 8.1.1 Cheat Sheet

Soniya Shah, Information Developer
July 31, 2017

This blog post was authored by Vincent Xu. Vertica 8.1.1 provides SQL functions that support the complete machine learning workflow—from cleaning your data to training a model to evaluating model performance. Vertica machine learning is fast and scalable along the sizes of data samples, features, and computing cluster. Best of all, no data movement is...

What’s New in Vertica 8.1.1: Introducing Export to Parquet Format

Soniya Shah, Information Developer
July 25, 2017

This blog post was authored by Deepak Majeti. Vertica customers often ask the following questions: 1. "We want to keep hot/warm data in Vertica and move warm/cold data to an open file format on cheap external storage. How do we do this? " 2."How can we store the results from Vertica in an open file...
Three 3D arrows, different colors pointing in different directions

What’s New in Vertica 8.1.1: Cloudera Manager Support

Soniya Shah, Information Developer
July 24, 2017

This blog post was authored by Mitchell Tracy. In Vertica 8.1.1, we introduce support for Cloudera Manager. Cloudera Manager is a platform that Hadoop administrators can use to manage their Hadoop cluster. It allows them to see the hosts associated with their cluster, and the different Hadoop services running on the cluster. Cloudera Manager also...

Subscribe For Email Updates

Sign-up and select Vertica in your preferences to receive our monthly Vertica newsletter.

Sign-up

What’s New in Management Console 8.1.1

Lisa Donaghue
July 20, 2017

Vertica 8.1.1 introduces the ability to run SQL queries on your database through a browser. Management Console (MC) now also highlights new features and Vertica resources when you upgrade, and improves the resources and look and feel of the contextual help. Query the Database Using MC You can now use the Query Runner tool in...
Modern Database Analytics

Vertica In-Database Approximate Count Distinct Functions Using LogLogBeta

Soniya Shah, Information Developer
July 19, 2017

This blog post was authored by Ginger Ni. Counting Distinct Values Data cardinality is a commonly used statistic in data analysis. Vertica has the exact COUNT(DISTINCT) function to count distinct values in a data set, but the function does not scale well for extremely large data sets. When exploring large data sets, speed is critical....
Programmer

What’s New in Vertica 8.1.1: Machine Learning

Soniya Shah, Information Developer
July 17, 2017

This blog post was authored by Soniya Shah. Vertica 8.1.1 continues with the fast-paced development for machine learning. In this release, we introduce the highly-requested random forest algorithm. We added support for SVM to include SVM for regression, in addition to the existing SVM for classification algorithm. L2 regularization was added to both the linear...

Explore Popular Topics

SQL
DBadmin
Advanced Analytics
machine learning
Best Practices
Cloud
VSQL
Eon Mode
Analytics
Partner Integrations
Vertica
Open Source
AWS
IoT
Time series

What’s New in Vertica 8.1.1?

Soniya Shah, Information Developer
July 11, 2017

This blog post was authored by Soniya Shah. In Vertica 8.1.1, we introduce new functionality including: • Supported platform updates • Machine learning updates • Management Console enhancements • Apache Hadoop, Apache Kafka, and Apache Spark integration updates • Database management improvements • Workload management • Table data management updates • SQL functions and statements...

Understanding Backup Space Utilization

Soniya Shah, Information Developer
July 10, 2017

This blog post was authored by Soniya Shah. Creating regular database backups is an important part of database maintenance. The vbr utility lets you back up, restore, and copy your database to another cluster. You can create full and incremental backups, and even back up objects, such as tables. Ideally, backups should match what is...