Vertica Blog

OpenText Vertica 23.3 – the Smarter Data Lakehouse

Posted July 31, 2023 by Paige Roberts, Vertica Open Source Relations Manager

Read More

Unveiling the Most Recent Version of the Vertica Grafana Data Source Plugin

Amrita Akshay, Information Developer
October 12, 2023

With over 380K downloads, the Vertica Grafana Data Source plugin just got an upgrade! The plugin was migrated from the deprecated older Grafana toolkit to align with Grafana's new Create-Plugin tool. This accelerates the plugin development with their modern build set up that requires no additional configuration. Additionally, the Vertica SQL Go driver received an...
Quick Tip on a blue enter key on a keyboard

Setting Session Authorization to Troubleshoot

Sruthi Anumula, Senior Database Support Engineer
September 29, 2023

There are possible scenarios in which a dbadmin would want to run queries as another user to troubleshoot or test. You can use SET SESSION AUTHORIZATION to impersonate another user and run queries. Let's understand this with an example. Here we create a user named test, resource pool named userpool, and make this a default...
Three 3D arrows, different colors pointing in different directions

What’s New in Vertica 9.0: Google Cloud Platform

Soniya Shah, Information Developer
November 1, 2017

This blog post was authored by Chris Daly. Announcing Vertica availability in Google Cloud Platform With the release of Vertica 9.0, the team at Micro Focus has brought you a ton of new updates and enhancements that are certainly worthy of getting excited about! If you haven’t had a chance, you should check out the...

What’s New in Management Console 9.0

Soniya Shah, Information Developer
October 31, 2017

This blog post was authored by Lisa Donaghue. In Vertica 9.0, Management Console (MC) provides tools to provision and manage clusters and databases on an AWS environment. You can get started easily with a guided Cluster Creation wizard on AWS. The new Fast Tasks page introduces new users to a few fundamental MC tasks to...
Modern Database Analytics

Machine Learning Mondays: Vertica 9.0 Cheat Sheet

Soniya Shah, Information Developer
October 30, 2017

This blog post was authored by Vincent Xu. Vertica 9.0 is out and here is the updated Vertica machine learning cheat sheet. Vertica 9.0 introduces a slew of new machine learning features including one-hot encoding, Lasso regression, cross validation, model import/export, and many more. See the cheat sheet for examples of how to use the...

Subscribe For Email Updates

Sign-up and select Vertica in your preferences to receive our monthly Vertica newsletter.

Sign-up

IoT Analytics with Open Source and Vertica – Tracking Commercial Aircraft in near Real Time — Part 1

Mark Whalley, Manager, Vertica Education
October 26, 2017

Project Overview This post presents an overview of an ongoing series that focuses on using Vertica, Raspberry Pi, and Apache Kafka to track commercial aircraft in near-real time. Often, people try to understand how to do IoT data analytics with their tool of choice, such as Vertica. Doing so can present some difficulty, especially if...

What’s New in Vertica 9.0: Machine Learning Enhancements

Soniya Shah, Information Developer
October 26, 2017

This blog post was authored by Soniya Shah. Vertica 9.0 introduces new functionality that continues to match our goals for fast-paced development of the existing machine learning functions. In this release, we introduce two new summary functions, support for cross validation, support for one hot encoding, and the ability to import and export your models...

Vertica Deep Dive Comes to Boston: #OwnTheNew

Soniya Shah, Information Developer
October 24, 2017

This blog post was authored by Sarah Lemaire. Two weeks after the successful Deep Dive in Los Angeles, Boston-area Vertica users had the unique opportunity to meet with Sumeet Keswani and Shrirang Kamat from the Vertica Customer Experience Team. These two Vertica experts offered attendees tips for managing their Vertica environment for maximum performance. These...

Explore Popular Topics

SQL
DBadmin
Advanced Analytics
machine learning
Best Practices
Cloud
VSQL
Eon Mode
Analytics
Partner Integrations
Vertica
Open Source
AWS
IoT
Time series
Database Server Room

What’s New in Vertica 9.0: Reading Parquet and ORC from S3

Soniya Shah, Information Developer
October 23, 2017

This blog post was authored by Monica Cellio. Parquet and ORC are widely-used Hadoop columnar file formats. Because these formats are columnar, they perform extremely well when queried as external tables in Vertica. Vertica queries implement column selection, predicate pushdown, and partition pruning. Vertica has supported reading Parquet and ORC data from HDFS or from...

Vertica 9

Soniya Shah, Information Developer
October 18, 2017

This blog post was authored by Steve Sarsfield. The Vertica development team has just released Version 9.0. With every major release it gives me time to not only look back and see what was developed this cycle, but a look at the entire timeline. I joined the Vertica team about 4 years ago in the...
Database Server Room

What’s New in Vertica 9.0: Eon Mode Beta

Soniya Shah, Information Developer
October 17, 2017

This blog post was authored by Soniya Shah. What is Eon Mode Beta? With Vertica 9.0, you can run Vertica in Eon Mode Beta, using Amazon Web Services to capitalize on cloud economics while still enjoying the fast query processing for which Vertica is known. Running Vertica in Eon Mode Beta separates the computational processes...

What’s New in Vertica 9.0?

Soniya Shah, Information Developer
October 16, 2017

This blog post was authored by Soniya Shah. In Vertica 9.0, we introduce new functionality including: • Eon Mode Beta • Supported Platform Updates • Machine Learning Enhancements • Apache Hadoop Integration Updates • Partition Grouping and Hierarchical Partitioning • Browsing S3 Data Using External Tables • Support for the UUID Data Type Eon Mode...

CPU and Memory Starvation in SPREAD

Soniya Shah, Information Developer
October 12, 2017

This blog post was authored by Sumeet Keswani. What is Spread? Vertica uses an open source toolkit, Spread, to provide a high-performance control message service. Spread daemons start automatically when your database starts up for the first time. The spread daemons run on control nodes in your cluster. The control nodes manage message communication. On...

Effective vsql in Vertica

Soniya Shah, Information Developer
October 10, 2017

This blog post was authored by Maurizio Felici. vsql is included in each Vertica installation and is lightweight, with a tight integration with Vertica. Vsql is installed on every Vertica server and can also be installed on non-server hosts using the client package. Executing SQL commands through vsql is often faster than navigating GUI's menu....