Vertica Blog

Vertica Blog

machine learning

Exploring VerticaPyLab: A Quick Start to ML, Data Analytics, and Vertica

Umar Farooq Ghumman, Data Science Developer
September 5, 2023

Authored by Badr Ouali and Umar Farooq Ghumman Welcome to VerticaPyLab, a transformative solution that paves the way for effortless Machine Learning and Data Analytics. If the world of Python's ML libraries has intrigued you but appeared complex to navigate, VerticaPyLab is here to redefine your journey. It is designed to make ML accessible and...
Vertica by opentext logo along with the datahub logo on a blue background

Updated – Unlock the Potential of Data Discovery in Vertica with DataHub: Master Metadata and Accelerate Data Access

Amrita Akshay, Information Developer
August 21, 2023

Co-authored with Oussama Chakri. Update - The upgraded DataHub-Vertica Plugin is now available! It is updated with Datahub 0.10.5.4V. You’ll see improved performance while getting metadata into DataHub. Check out the updated plugin! Smoothen your data discovery and metadata management by integrating Vertica with DataHub using the new, certified DataHub-Vertica Plugin. This powerful combination will...
OpenText Vertica 23.3

OpenText Vertica 23.3 – the Smarter Data Lakehouse

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

The latest release of the Vertica analytical database, now OpenTextTM VerticaTM  includes a lot of features that Vertica customers have been eagerly awaiting like: Resharding the database as needed Rollback snapshots that capture a moment in time without a whole other data copy Workload routing so you can automate directing specific queries to just the right...
Vertica and Saagie logos on a blue background

Unlock the Potential of Machine Learning in Vertica with Saagie: Automating your ML Pipeline

Amrita Akshay, Information Developer
July 13, 2023

Accelerate your data project pipelines with Saagie using Vertica’s in-database machine learning capabilities. Another ML platform that you can now use with Vertica. A win-win situation! Saagie is a Dataops platform that offers various ready-to-use technologies and advanced pipelines that enable you to manage all your data projects through a single interface. Select the technology...
Vertica by opentext logo, a plus sign, and Qwak logo on a blue background

Unlock the Potential of Machine Learning in Vertica with Qwak: Optimizing Data and MLOPs

Amrita Akshay, Information Developer
June 26, 2023

Leverage the best of both worlds, with Vertica and Qwak integration! Vertica's high-performance analytics and in-database machine learning combined with Qwak's MLOps capabilities provide a comprehensive solution for organizations seeking to operationalize their machine learning models at scale. VerticaPy is a Python library that leverages Vertica's machine learning capabilities. Qwak, a powerful machine learning engineering...

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.

Shorten the Path to Production with In-Database Machine Learning

Shannon Montuori
January 26, 2023

Moving data, transforming data types, taking small samples so they’ll fit in your sandbox – these are all things every data scientist puts up with as routine. And when you’re finished, a data engineer has to build full production pipelines to reproduce all that work at scale. It can be months or a year or...

Israel AI & Data Summit 2023

Shannon Montuori
January 18, 2023

Vertica is sponsoring Israel AI & Data Summit 2023! This summit will provide the opportunity to hear about the most advanced technologies and solutions in the fields of DATA, AI & ML, alongside networking of the Israeli industry best human capital – Researchers, Developers, Data Scientists, and Business Decision Makers. Don’t miss Badr Ouali, VerticaPy...

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

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