Vertica Blog

What’s New in Vertica 8.1: Machine Learning

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 imputation, and support for SVM (support vector machine). […]

What’s New in Management Console 8.1

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: Read on to learn […]

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

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

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?

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

What’s up with rejected data?

This blog post was authored by Kanti Mann. In a perfect world, any and all data you attempt to load into your database would seamlessly and accurately move from point A to point B. Unfortunately, this doesn’t always happen. Occasionally, data fails to load into its destination table, and you’ll probably want to know what […]

Why auto-scaling analytical databases aren’t so magical

This blog post was authored by Steve Sarsfield. There is a new feature in analytical databases that seems to be all the rage, particular in cloud data warehouse – Autoscaling. Autoscaling’s promise is that if you have a particularly hard analytical workload, autoscaling will spin up new storage and compute to get the job done. […]

Understanding AT TIME ZONE

TIMESTAMPTZ AT TIME ZONE and TIMESTAMP AT TIME ZONE return date input in another time zone. How Vertica executes AT TIME ZONE varies, depending on whether the input is a TIMESTAMPTZ or TIMESTAMP. At first glance, this might be confusing. More about that later. First, let’s review AT TIME ZONE syntax: { TIMESTAMPTZ | TIMESTAMP […]

Create and Assign Roles

A role is a collection of privileges that can be granted to one or more users or roles. Assigning roles prevents you from having to manually grant sets of privileges for each individual user. For the most part, creating and assigning roles is fairly straightforward. However, the user to which roles are assigned needs to […]

Filtering Data While Loading into Vertica

Suppose you have a CSV file and you want to copy some, but not all, of its contents into a Vertica table. There are two ways you can to do this: • Use the SKIP keyword with COPY. • Use the head or tail Linux command. Let’s see how this works. The Data Here’s a […]