Vertica Blog

OpenText Vertica 23.3 – the Smarter Data Lakehouse

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

Read More

Checklist for Inconsistent Execution Time of Same Query in Eon Mode

In Eon Mode, when a query is executed and if the ROS containers associated to the tables in the query are not present in depot, it will fetch results from the communal storage bucket. In the next immediate run, the query should provide results to the user from the files present in the depot. However,...

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

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, a plus sign, and dbt logo on a blue background

Updated – Unlock the Potential of Your Data in Vertica with dbt: Experience ETL-Free Data Transformation

Co-authored with Oussama Chakri. Update - The upgraded dbt-vertica adapter is now available! It supports dbt-core version 1.5.0 with Vertica 23.3. We added new features, and the adapter works well with the latest Vertica version. Check it out! Discover the all-new open-source dbt-Vertica adapter, offering cutting-edge features that will transform your data analytics journey. By...
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

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

How to Group Timeseries Data at Any Granularity

You might have come across this. You would have obtained a huge set of time stamped log data or sensor data that you would like to understand. Millions of rows are nothing for human consumption - and far too much for plotting on a monitor that just has a few thousand pixels across - why...

Subscribe For Email Updates

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

Sign-up

A key with a key hole and Unlock Vertica Potential in text at the bottom

How to Use UDx to Extend Vertica Live Aggregate Projections

Thanks to its sophisticated optimizer and extremely efficient query engine Vertica can process data aggregations order of magnitudes faster than traditional Database Management Systems. To further boost data aggregation performance, we can use Vertica’s Live Aggregate Projections (LAP from now on). The concept is very simple: pre-aggregate data once during load operations rather than doing...

Vertica’s Server-Based Replication

Empowering Seamless Data Copying in Vertica Eon Mode Overview In our latest installment of exploring the untapped potential of Vertica, we delve into the exciting new feature introduced in version 23.3 - Server-Based Replication. This cutting-edge functionality allows users to efficiently copy data from one Eon Mode database to another, revolutionizing the way data replication...
Quick Tip on a blue enter key on a keyboard

Using Fall Through Authentication

If a user tries to login using their credentials and the authentication fails, the user cannot login using other authentication methods. A simple example could be a user who was configured with hash authentication. Later, TLS authentication was introduced and granted to all users or in other words granted to the PUBLIC with higher priority....

Explore Popular Topics

How To Filter a Behavioral Pattern in a Time Series

Behavioral patterns in time series are something that many analysts are keen to find in time series. A clickstream analyst wants to find the series of clicks that happened between coming to the website, browsing one or more articles in the web site, and finally filling the basket and checking out; a financial analyst wants...
Vertica and Saagie logos on a blue background

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

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

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...
A key with a key hole and Unlock Vertica Potential in text at the bottom

How to Use Database Designer to Optimize Vertica Physical Data Model in Six Steps

Vertica provides out-of-the-box a powerful tool to tune its Physical Data Model: Database Designer (DBD from now on). You can run DBD using the Management Console GUI but in this article we will focus on what they call “programmatic interface” (read... plain SQL) and – as practical examples are often more enlightening than “theoretical” documentation...