myVertica  

Vertica Blog

Videos

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 New in Vertica 7.2.3: Restore Backup to an Alternate Cluster

With HPE Vertica 7.2.3, you can restore a full backup to an alternate cluster. Watch this video to learn how to restore backup data to an alternate cluster when your source cluster is unavailable for any reason. 

Watch Machine Learning for Predictive Analytics in Action

Watch this video to learn more about the Vertica Machine Learning for Predictive Analytics features new in 7.2

Installing Vertica SQL on Hadoop

Interested in adding Vertica’s analytic capabilities to your Hadoop cluster? Watch this tutorial video to learn how you can install Vertica on Hadoop, giving it faster access to your data!

Introducing the Developing Vertica UDxs in Java Tutorial Series

What is a Java UDx and why would you want to develop one? Check out our new tutorial series in the wiki to find out!

Vertica Best Practices: Identifying Queries for DBD

The Vertica Database Designer is a tool that analyzes a logical schema definition, sample queries, and sample data, and creates a physical schema (projections) in the form of a SQL script that you deploy automatically or manually. The result is an optimized database with optimal query performance and data compression.

Vertica Best Practices: Resource Management

In a perfect world, every query you ever run would receive full attention from all system resources. And in a single user environment, when you are only running one query, this is in fact the case; the system can devote all its resources (CPU, memory, disk I/O, etc.) to your one query. But chances are, you are running more than one query at a time, maybe even more than you can count.

Vertica Storage Location for HDFS

Do you find yourself running low on disk space on your Vertica database? You could delete older data, but that sacrifices your ability to perform historical queries. You could add new nodes to your cluster or add storage to your existing nodes. However, these options require additional expense.

The Vertica Storage Locations for HDFS feature introduced in Vertica Version 7.1 offers you a new solution: storing data on an Apache Hadoop cluster. You can use this feature to store data in a Hadoop Distributed File System (HDFS) while still being able to query it through Vertica.

Vertica Best Practices: Native Connection Load Balancing

You may be aware that each client connection to a host in your Vertica cluster requires a small overhead in memory and processor time. For a single connection, this impact is minimal, almost unnoticeable. Now imagine you have many clients all connecting to the same host at the same time. In this situation, the compounded overhead can potentially affect database performance.

New Configuration Parameter Storage and Setting Options

HP Vertica 7.1.x introduces a new way to store and set configuration parameters.

Previously, configuration parameter values were stored in individual vertica.conf files on each node. As of HP Vertica 7.1.0, these values are stored in the database catalog, allowing the values to stay consistent over all nodes.