Vertica Blog

Vertica Blog

Advanced Analytics

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...

Harness your Vertica Metadata in DataHub with the New Vertica Connector

Amrita Akshay, Information Developer
January 17, 2023

Vertica now supports a new and certified DataHub-Vertica Plugin to analyze Vertica metadata in DataHub and use DataHub features to make better business decisions. DataHub is a metadata platform for data discovery, governance, and end-to-end data lineage. Here are some of the key features of the plugin: Up to 10x better performance Visualize lineage between...
Vertica plus Domino Data Lab logos

Unleash the Power of Data Science with Vertica and Domino Data Lab

Amrita Akshay, Information Developer
November 30, 2022

Introducing an end-to-end machine learning solution with Vertica and Domino Data Lab that enables you to explore, analyze, and model your data in Vertica using VerticaPy. Domino Data Lab is a data science platform to build and deploy machine learning models, monitor performance, and collaborate with one another. VerticaPy is a Python library to perform...
SQL Query Optimization

Improving COUNT DISTINCT Performance with Approximate Functions

Bryan Herger, Vertica Big Data Solution Architect at Micro Focus
November 16, 2022

A common analytic use case is to find the number of distinct items in a data set. Vertica performs well at solving COUNT DISTINCT in a few ways. Since Vertica stores all data in columns, it is possible to optimize for COUNT DISTINCT by building a projection that is tuned for this use case. Vertica...
Vertica plus Prometheus Logo image

Monitor your Vertica Metrics in Prometheus Using the New Vertica Prometheus Exporter

Amrita Akshay, Information Developer
October 31, 2022

Looking to visualize Vertica metrics in your favorite monitoring tool that supports Prometheus? You can now do it with the Vertica Prometheus Exporter! We are happy to announce the Vertica Prometheus Exporter, an open-source project now available on Vertica’s GitHub. The exporter uses the vertica-sql-go driver to connect to Vertica. Prometheus is a monitoring system...

Break the bias – and predict brake bias

Mark Whalley, Manager, Vertica Education
September 20, 2022

The theme for this year’s International Women’s Day (IWD) was given the name #BreakTheBias to get us to imagine a gender equal world. A world free of bias, stereotypes, and discrimination, a world that is diverse, equitable, and inclusive, where difference is valued and celebrated. Together, we can protect women’s equality. At Micro Focus, as...
spark plus vertica hands touching

Unleash the Power of Vertica and Apache Spark Using the Upgraded Spark Connector

Arash Fard, Senior Software Engineer at Vertica
September 16, 2022

This post is authored by Alex Le What is Apache Spark? Apache Spark is a distributed compute engine that provides a robust API for data science, machine learning, or to work with big data. It is fast, scalable, simple, and supports multiple languages, including Python, SQL, Scala, Java, and R. Backed by the Apache 2.0...

Vertica Grafana Plugin just got an Upgrade!

Amrita Akshay, Information Developer
August 17, 2022

A new version of the Vertica Grafana Plugin is now available. You can download it from the Vertica GitHub page or the Grafana website. With many of our customers using the Vertica Grafana plugin, addition of the new Vertica Performance Dashboard makes it easy to visualize metrics. You can now create dashboards, quickly import it...
A key with Anomaly Description written on it

Detect Outliers Using Isolation Forest

George Larionov
August 2, 2022

The Isolation Forest (IForest) algorithm is a powerful and scalable algorithm for identifying outliers in your data. It uses a unique approach which focuses directly on characterizing outliers instead of normal data points. Specifically, IForest focuses on the two quantitative properties of outliers: they are few and different. A scalable implementation of the Isolation Forest algorithm is available...

Announcing our Integration with Chata

Amrita Akshay, Information Developer
July 28, 2022

We’re thrilled to announce our new integration with AutoQL, a natural language interface to database system (NLIDB) by Chata. You can now use this conversational AI solution to ask questions, get insights, and analyse your data in Vertica. This exploration covers the implementation process, deployment options, how to connect to Vertica, and use the AutoQL...

When the typewriter is broken: Vertica’s Event-Based Windows to the rescue

Mark Whalley, Manager, Vertica Education
July 18, 2022

Those of you who read my blog post “Take nothing but memories. Leave nothing but footprints” may recall my passion for using Raspberry Pi computers to capture IoT data from aeroplane transponders and GPS satellites, then feeding that streaming data into Apache Kafka and to integrate it with Vertica and perform near real-time analytics and...