Vertica Blog

Vertica Blog

Vertica

Creating Iceberg External Tables in Vertica

Sruthi Anumula, Senior Database Support Engineer
June 1, 2023

From Vertica 12.0.4 onwards, we support creating external tables with parquet files in Apache Iceberg Table format. Iceberg is a high-performance table format which uses advanced filtering techniques and provides better performance by avoiding file listing. The striking feature of the external Iceberg tables is that there is no need to specify columns when defining...
Tips in bright neon red letters on a dark background with touchscreens.

Default Custom User Resource Pool

Sruthi Anumula, Senior Database Support Engineer
May 9, 2023

In Vertica versions 12.0.4 and later, you can set a default user resource pool for all users instead of defaulting users to a general pool, using the DefaultResourcePoolForUsers configuration parameter. How to set it? As a dbadmin user, create a user resource pool. The pool name can be used to configure the DefaultResourcePoolForUsers option. In...

Load Balancing on Elastic Kubernetes Clusters

Sruthi Anumula, Senior Database Support Engineer
March 7, 2023

Your long-running sessions could fail after you deployed Vertica on Elastic Kubernetes Cluster (EKS) with Load Balancer as the service type. When the load balancer type is not specified in yaml, by default, EKS generates a classic load balancer with a default connection idle timeout of 60 seconds. The aws-load-balancer-connection-idle-timeout can be set up to...
Helpful Tips in blue text with magnifying glass

Restrict Modifying Table Rows (UPDATE/DELETE) Irrespective of User Privileges

Sruthi Anumula, Senior Database Support Engineer
February 14, 2023

Do you have a table with critical information such as SIEM events or credit card transactions? Do you want to be able to block user access to UPDATE/DELETE rows in those tables? From version 12.0.0, you can do this by setting the tables as IMMUTABLE. This means you can only insert data and not modify...

OpenText Welcomes Micro Focus Customers, Partners, and Employees

Jeff Healey, Vice President of Marketing, Vertica Product Group in Micro Focus
January 31, 2023

OpenText CEO and CTO Mark Barrenechea blogs on how the Micro Focus acquisition expands OpenText's mission to help enterprise professionals secure their operations, gain more insight into their information, and better manage an increasingly hybrid and complex digital fabric. Read his article here.

GigaOm Radar for Data Warehouses Recognizes Vertica as Leader

Jeff Healey, Vice President of Marketing, Vertica Product Group in Micro Focus
January 17, 2023

With the excitement in our industry regarding the emergence of data lakehouses, there’s a good chance that you are planning to modernize or even “replatform” your incumbent data warehouse to meet an ever-evolving variety of analytical use cases. Many vendors, like Vertica, have transformed the original concept of data warehouses with groundbreaking innovations like massively...
Tips in bright neon red letters on a dark background with touchscreens.

High Availability for a Vertica in Eon Mode Database with Read-Only Mode

Sruthi Anumula, Senior Database Support Engineer
January 9, 2023

When Vertica is deployed in Eon Mode, there are two major requirements for high availability: maintaining quorum and shard coverage. If either of them is lost, the whole cluster goes down. Before going into details, let us understand what quorum and shard coverage mean. Quorum: In Eon Mode, more than half of the primary nodes...

How to Quickly Install Vertica on Large Clusters

Sruthi Anumula, Senior Database Support Engineer
December 19, 2022

Vertica 12.0.2 introduces a new feature that allows you to install Vertica in parallel on all hosts rather than one at a time as in earlier releases. This reduces the installation time in large clusters. To use this feature, run the --parallel-no-prompts flag with the install_vertica command. This flag can be used only when passwordless...

New Vertica Accelerator course puts your SaaS-based data analytics to work, fast

Mark Whalley, Manager, Vertica Education
December 20, 2021

We’re happy to announce a new addition to Vertica Academy’s array of free, self-paced courses designed to put you in the driver’s seat with your data analytics initiatives. The all-new Vertica Accelerator Quick Start course has gone live today on Vertica Academy. If you’re looking for a fast track to highly performant data analytics, and...

Vertica is in the G2 Leaders’ Corner… once again

Mike Perrow, Senior Product Marketing Writer/Editor
October 13, 2021

When it comes to technology, the business world doesn’t have time for popularity contests. Technology that doesn’t cut it falls by the wayside, and gets replaced with whatever helps a business achieve its goals. The Vertica team is happy to be part of our customers’ successes, whether we’ve helped them replace outmoded or poor-performing data...

Vertica 10.1.1 Goes Beyond Analytics with Support for Azure Cloud, Kubernetes, and Containers

Jeff Healey, Vice President of Marketing, Vertica Product Group in Micro Focus
April 30, 2021

With each release of Vertica, you can always count on major enhancements and features to help you address each step of the predictive analytics process with even more analytical functions and end-to-end machine learning capabilities. While Vertica 10.1.1 includes support for the latest version of PMML, 4.4, some useful new analytical functions, and a new...

Leveraging Cloud Object Store Technologies for On-premises Analytics

Steven Sarsfield, Vertica Senior Product Marketing Manager – Partner Ecosystem
March 11, 2021

Today, we are pleased to announce that our team will now support Vertica in Eon Mode for Dell EMC ECS (Elastic Cloud Storage). Our developers have verified the combination. It addresses a new trend in analytics, namely the use of object store, both on-premises and in the clouds, as the primary storage medium. When you...