Vertica Blog

Vertica Blog

Advanced Analytics

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

What’s needed for a happy software dev team in data analytics?

Mike Perrow, Senior Product Marketing Writer/Editor
July 6, 2022

For an organization to excel at data analytics, the IT team needs to coordinate a number of different disciplines and personnel with experience in those disciplines. This usually includes data analysts, data engineers, and, increasingly, data scientists. The data engineering discipline is sometimes thought of as the plumbing that, like pipes in a house, delivers...

VerticaPy Unify 2022 Sessions

Badr Ouali, Head of Data Science
June 21, 2022

Vertica Unify 2022 is a great time to learn about Vertica, its new features, and best practices. To complement the many great presentations at Vertica Unify 2022 both in Boston and Paris, I’m very excited to present two sessions: one on VerticaPy best practices, and another general session on VerticaPy and its features. VerticaPy is...

No need to extract data from your database to do your analytics!

Mark Whalley, Manager, Vertica Education
June 16, 2022

While taking a long-awaited, and, IMHO some well-deserved R&R in the sun, I heard that ping notification coming from my backpack, and not being one who can ignore such things, reached for my iPad. With my OOTO email response already set, I should be able to ignore most incoming messages, texts and otherwise, safe in...
Vertica Version 12

Announcing Vertica Version 12

Steve Sarsfield, Vertica Senior Product Marketing Manager – Partner Ecosystem
June 6, 2022

Vertica is pleased to announce version 12 of our unified analytics platform. Since the introduction of Vertica version 11 around June last year, several releases have gone out. Our release cycle has become more continuous, and the Vertica engineering team packs a lot of capabilities into every release. What this means is that a LOT...