Vertica Blog

Vertica Presentation at the db tech showcase Tokyo 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 […]

Check out the New Look of the Vertica Forum

This blog post was authored by Sarah Lemaire. Have you visited the Vertica Forum lately? Since the spin-merge with HPE Software and Micro Focus, we’ve inherited some new colors and applied them to the forum. You may also notice that we have real Vertica employees in the accompanying photo. No more corporate stock photos. Thanks […]

What’s New in Vertica 8.1.1: Flex Parser Updates

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

Compute Engine or Analytical Data Mart for Distributed Machine Learning? Vertica Explains How to Choose

This blog post was authored by Sarah Lemaire. On Tuesday, August 22, The Boston Vertica User Group hosted a late-summer Meetup to talk to attendees about compute engines and data mart applications, and the advantages and disadvantages of both solutions. In the cozy rustic-industrial atmosphere of Commonwealth Market and Restaurant, decorated with recycled wood pallets, […]

MERGE Statement with Filters

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?

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

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

Configuring tcp Idle Settings for Long Running Idle Sessions

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? ==> VSQL vsql => select sleep(3600); […]

How to Publish Data Collector Tables to Apache Kafka

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

View Privileges

This blog post was authored by Soniya Shah. 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 […]