See More Vertica Blog Posts
View All Vertica Blog Posts
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...
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...
Vertica and GitLab Integration
Amrita Akshay, Information Developer
April 29, 2022
Good news for GitLab users! You can now integrate GitLab with Vertica to run your SQL scripts in GitLab CI/CD itself with GitLab runner. Alternatively, you can integrate using only Linux or a Git supported database IDE. These integrations are explained in detail in the Vertica and GitLab: Technical Exploration in our Knowledge Base.
Vertica and Alteryx Designer
Amrita Akshay, Information Developer
October 29, 2021
We are very excited to announce our end-to-end analytics of Vertica with Alteryx Designer. You can now process and analyze your entire dataset easily and quickly. Vertica enables you to run your analytics in the database from the models that you create in Alteryx Designer. You can create a predictive model in Alteryx Designer and...