Vertica Blog

Announcing Vertica Version 12

Posted June 6, 2022 by Steven Sarsfield, Vertica Senior Product Marketing Manager – Partner Ecosystem

Read More

Vertica plus Prometheus Logo image

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

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

Integrate your Data Faster Using DataSpider Servista with Vertica

DataSpider Servista easily integrates and connects data across a wide variety of systems and applications – including cloud and on-premises systems, IoT integrations, and business intelligence – all with a simple GUI. To make use of DataSpider features with Vertica data, you can connect using either a JDBC or an ODBC driver. To know more,...
Vertica plus Domino Data Lab logos

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

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

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...
Word Node.js in yellow square pixels on a black matrix background. 3D illustration picture

Announcing the Availability of Vertica JavaScript Driver (vertica-nodejs)

This post is authored by Bill Jones and Danny Mickens. What is Node.js? Wikipedia defines Node.js as an “open-source, cross-platform, back-end JavaScript runtime environment that runs on the V8 engine and executes JavaScript code outside a web browser, which was designed to build scalable network applications”. Consequently, Node.js represents a "JavaScript everywhere" paradigm, unifying web-application...

Subscribe For Email Updates

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

Sign-up

Break the bias – and predict brake bias

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

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’s Fungible Licensing vs. Cloud-only Solutions

A few years ago, I worked as an evangelist for a midsize software company, and sometimes had to ask my boss to fund a project that hadn’t been anticipated in the quarterly plan. As long as my reasons for the change were sound, he was usually accommodating, telling me, “Steve, money is fungible.” He simply...

Explore Popular Topics

Vertica Grafana Plugin just got an Upgrade!

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

dataGALS – Vertica’s history of supporting women in tech

When you look around your office, or when you look at the faces on your Zoom calls, do you see an even mix of men and women? If yours is like most organizations in the technology sector, women occupy only about 25% of the jobs, according to a recent CIO Magazine article. That stat is...
A key with Anomaly Description written on it

Detect Outliers Using Isolation Forest

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

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