Vertica Blog

Vertica Blog

Vertica Blog

Adding Nodes to Fault Groups

Soniya Shah, Information Developer
October 9, 2017

This blog post was authored by Sarah Lemaire. Suppose you are adding new cluster nodes to your Vertica database. You want to add those nodes to particular fault groups without having to restart your Vertica database. The following steps use the example of a database with five racks and fault groups, with 9 Vertica nodes...

Analytic Queries in Vertica

Soniya Shah, Information Developer
October 2, 2017

This blog post was authored by Soniya Shah. Analytic functions handle complex analysis and reporting tasks. Here are some example use cases for Vertica analytic functions: • Rank the longest standing customers in a particular state • Calculate the moving average of retail volume over a specific time • Find the highest score among all...

Working with Joins

Soniya Shah, Information Developer
September 26, 2017

This blog post was authored by Soniya Shah. Vertica supports a variety of join types. This post discusses the following joins: • Inner joins • Left, right, and full outer joins • Natural joins • Cross joins In Vertica, we refer to the tables participating in the join as left or right. The left table...
Three 3D arrows, different colors pointing in different directions

Time Series Analytics

Soniya Shah, Information Developer
September 18, 2017

This blog post was authored by Soniya Shah. Time series analytics is a powerful Vertica tool that evaluates the values of a given set of variables over time and groups those values into a window based on a time interval for analysis and aggregation. Time series analytics is useful when you want to analyze discrete...

Building a Secure Vertica Environment

Soniya Shah, Information Developer
September 14, 2017

This blog post was authored by Soniya Shah. Vertica has a client-server architecture system, where applications that reside on the client access the Vertica cluster through drivers including ODBC, JDBC, OLEDB and ADO.NET. This post discusses secure client to server communications, authenticating access to Vertica, and administrator access. Method Vertica Options Authentication: Validate user credentials...
Modern Database Analytics

Vertica Presentation at the db tech showcase Tokyo 2017

Soniya Shah, Information Developer
September 12, 2017

On September 5th, Kanako Obayashi from the Vertica Best Practices team presented at the db tech showcase Tokyo 2017, one of the largest database events in Japan. Kanako's presentation was about Vertica advanced analytics, including machine learning and geospatial analysis. More than 50 people attended her session. Kanako began her session by noting that more...
Programmer

What’s New in Vertica 8.1.1: Flex Parser Updates

Soniya Shah, Information Developer
September 6, 2017

This blog post was authored by Soniya Shah. Vertica 8.1.1 introduces an optional parameter to the FCSVPARSER function. The FCSVPARSER specifies how to load data into Vertica from a CSV data source. The new parameter allows you to define or override column names in the target file for data loaded from a CSV data source....

MERGE Statement with Filters

Soniya Shah, Information Developer
August 23, 2017

This blog post was authored by Soniya Shah. Vertica 8.1 introduced new functionality for the MERGE statement. In this post, we discuss new functionality for MERGE that allows users to filter conditions on INSERT and UPDATE clauses in a MERGE statement. The MERGE operation allows users to join the target table on another table, a...

Do you need a database or a query engine?

Soniya Shah, Information Developer
August 21, 2017

This blog post was authored by Steve Sarsfield. As we travel through life, we are constantly assessing our choices. Should you eat that salad, or opt for the burger? Should you marry your partner or seek greener pastures elsewhere? All of us do these assessments in both our personal and business lives. However, it may...

What’s New in Vertica 8.1.1: Catalog Memory Improvements

Soniya Shah, Information Developer
August 17, 2017

This blog post was authored by Soniya Shah. 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...
Database Server Room

Configuring tcp Idle Settings for Long Running Idle Sessions

Soniya Shah, Information Developer
August 14, 2017

This blog post was authored by Soniya Shah. 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? With each of these errors, the...

How to Publish Data Collector Tables to Apache Kafka

Soniya Shah, Information Developer
August 10, 2017

This blog post was authored by Serge Bonte. 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...