Product
- Product Overview
  
  Product Overview
  
  Vertica delivers unified analytics and machine learning at unprecedented speed, scale, and value.
  
  Learn More
- Product
  - Vertica Accelerator,
    Vertica-as-a-Service
    - Vertica SaaS offering
    - Built on and delivers all the functionality of the Vertica Unified Analytics Platform
    - Automated administration and runs in your own AWS account
- second column
  - Vertica Unified Analytics Platform,
    Customer-Managed Software
    - Bring Your Own License (BYOL) analytics software
    - Runs on-premises, hybrid, multi clouds, and containerized
    - Advanced analytics, in database ML, and data lake query engine
- Product Resource
  
  Vertica Announces Vertica 12 for Future-Proof Analytics
  
  Latest version of analytics database enables more deployment flexibility, advanced analytics, and enhanced machine learning
Industries
- Solutions Overview
  
  Featured Use Case:
  Customer Behavior Analytics
  
  Customer centricity is a mission critical initiative across industries. Unify customer data, deliver personalized, omni-channel experiences, and grow and retain your customer base.
  
  Learn More
- Industries
- Industries
- Industries Resource
  
  Harness the Internet of Things (IoT)
  
  IoT data is expected to grow exponentially across industries. Learn how to leverage sensor data at massive scale for business and customer value.
  
  Read On
Support & Services
- Support Resource
  
  Support & Services
  
  Access subscription-based pricing: New customers eligible for a 50% discount.
  
  Act now
- Support Links
- Documentation
- Downloads
Partners
- Partners Overview
  
  Partners
  
  Tight integration with and support from leading technology and solution providers.
  
  Learn More
- Partners
- col 2
  - 3rd Party Technology Partner Integration
  - Quickstarts
- Partners Resource
  
  Vertica Inside – Embedded Analytics at Scale
  
  Seize the huge growth opportunity for OEM software developers
Resources
- Resource Library
  
  Resources
  
  Explore our Thought Leadership library, including the most recent articles, webcasts and reports, with expert insights.
  
  Browse Resources
- Resource Library
  - Blog
  - Case Studies
  - Demos
  - eBooks
  - Infographics
  - Videos
- Webcasts
- What is…analytics and database technology topics
About
- About Vertica
  
  About Vertica
  
  Built for Fast. Built for Freedom.
  
  Learn More
- col 2
  - Careers
  - Contact us
- About Vertica
  - News & Recognition
  - Events
- About Resource
  
  Stay Informed
  
  Sign-up to receive our monthly newsletter.
  
  Subscribe
  
  Latest newsletter
Try Vertica
My Account

DataGals Year in Review

Three 3D arrows, different colors pointing in different directions

The DataGals had an amazing 2017! Everyone on our steering committee – Lisa Donaghue, Styliani Pantela, Soniya Shah, Diem Tran, and Sharada Vesta would like to wish you a very happy new year! Check out our year in review below. We look forward to a successful 2018. Happy holidays from the DataGals!

About the Author

Soniya Shah
Information Developer

Currently, a first year law student with a background in science and technology. Experienced technical writer, with specializations in software documentation, big data, blog development, and website development. I build user-centered content to communicate complex and technical information more easily.

I used to work for Vertica full time for about 3 years. I still work at Vertica part time while going to law school.

Update: Soniya is now doing her law internship, and no longer working at Vertica. Good luck, Soniya!

Read More Posts From Soniya
Connect With Soniya on

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