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

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

VerticaPy reaches a milestone at 100 stars

Mike Perrow, Senior Product Marketing Writer/Editor
December 14, 2022

The Vertica team is happy to share a milestone in our “VerticaPy journey”: We just reached 100 stars in our GitHub repo, and it’s growing every day. (Repo: That’s “repository” for those of you unfamiliar with GitHub.) Repos accumulate stars as an indication of user interest – think of them as bookmarks in a user’s...
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...

Subscribe For Email Updates

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

Sign-up

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

Integrate your Data Faster Using DataSpider Servista with Vertica

Amrita Akshay, Information Developer
October 11, 2022

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

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

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

Amrita Akshay, Information Developer
September 30, 2022

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

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

Steve Sarsfield, Vertica Senior Product Marketing Manager – Partner Ecosystem
August 29, 2022

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

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

dataGALS – Vertica’s history of supporting women in tech

Mike Perrow, Senior Product Marketing Writer/Editor
August 9, 2022

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