Vertica Blog

What’s New in Vertica 8.1.1: Catalog Memory Improvements

In Vertica 8.1.1, we introduce a performance improvement that reduces catalog memory usage for users with a large number of NULL values in tables. The improvement affects all string data types, including BINARY, VARBINARY, LONG VARBINARY, CHAR, VARCHAR and LONG VARCHAR. The improvement scales with the data type length and only affects columns with a […]

Configuring tcp Idle Settings for Long Running Idle Sessions

Important: For all recommendations to changing setting values, you must change the settings on all nodes in the cluster. It is not advisable to have different settings on different nodes. Have you ever encountered one of the following types of errors? ==> VSQL vsql => select sleep(3600); ERROR: could not receive data from server: Connection […]

How to Publish Data Collector Tables to Apache Kafka

You are probably familiar with the Vertica Data Collector (DC) and have used the granular information it collects to monitor and optimize Vertica deployments. A common challenge is that Data Collector keeps only a portion of that information—controlled by retention policies —in the internal DC tables before flushing it to log files. Apache Kafka is […]

View Privileges

This set of examples shows the privileges a user needs for various operations related to views, including creating and querying. A view is a virtual table based on the result set of a SQL statement, also called a SQL query. To select from a view, you need a combination of privileges on the underlying tables, […]

Geospatial Analysis on Shapefile of Longitude and Latitude Data Using Vertica: Hurricane Bonnie

This blog post was authored by Ginger Ni. Like any natural disaster, hurricanes can leave behind extensive damage to life and property. The question asked by NGOs, government agencies, and insurance companies is, “How can we predict the locations where a storm will inflict the most damage?” Modern spatial analysis enables us to predict the […]

What’s New in Vertica 8.1.1: Backup to Amazon S3

As more businesses move their infrastructure to cloud-based and hybrid environments, Vertica has kept pace. In version 8.1.1, Vertica introduced support for backup and restore to and from Amazon’s Simple Storage Service, commonly known as S3. Backup to S3 works the same as any other Vertica backup. As always, backups are incremental. That is, Vertica […]

Configure JDBC clients to Work with Your Kerberos-Enabled Vertica Cluster: DbVisualizer, DBeaver, and Others

This blog post was authored by Satish Sathiyavageswaran. Many customers use JDBC-based tools like DbVisualizer and DBeaver to connect to Vertica for SQL development purposes. It is easy to use these tools on a non-Kerberos enabled Vertica cluster, but connecting to a Kerberos-enabled Vertica cluster is not straightforward because there is no native support for […]

Machine Learning Mondays: Vertica 8.1.1 Cheat Sheet

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

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 […]

What’s New in Vertica 8.1.1: Cloudera Manager Support

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 […]