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

UNNEST vs EXPLODE Functions

Sruthi Anumula, Senior Database Support Engineer
September 19, 2023

Vertica provides two functions, UNNEST and EXPLODE to expand arrays into one or more rows. These functions offer the same functionality with subtle differences in syntax and output. Let's understand with a simple example. We have 3 array columns in the table. Let us expand 1 array column for a particular order key. Explode provides...

Checklist for Inconsistent Execution Time of Same Query in Eon Mode

Sruthi Anumula, Senior Database Support Engineer
September 6, 2023

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

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

Subscribe For Email Updates

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

Sign-up

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

Amrita Akshay, Information Developer
August 25, 2023

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

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

How to Group Timeseries Data at Any Granularity

Marco Gessner, Field Chief Technologist
August 15, 2023

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

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

Maurizio Felici, Field Chief Technologist
August 8, 2023

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

Moshe Goldberg, Vertica System Engineer
July 28, 2023

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 Fallthrough Authentication

Sruthi Anumula, Senior Database Support Engineer
July 21, 2023

Prior to Vertica 12.0.x, if a user failed to log in with a some authentication method, they could not attempt to log in again with some other method. For example, if a user used failed to log in with hash authentication, they could not attempt to log in with LDAP in the same connection attempt....

How To Filter a Behavioral Pattern in a Time Series

Marco Gessner, Field Chief Technologist
July 14, 2023

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