Hi, Vertica provides several validation utilities that can be used prior to deploying Vertica to help determine if your hosts and network can properly handle the processing and network traffic required by Vertica. These utilities can also be used if you are encountering performance issues and need t...

Cool new Vertica blog post! In Vertica, when you create a new database, there are no configured authentication methods. In this case, Vertica assumes that all users, including the dbadmin, have an implicit password authentication. Users can use this authentication method both for authenticating over...

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

What’s New in Vertica 9.0.1?

Find out here:

https://my.vertica.com/blog/whats-new-vertica-9-0-1/

Hi, Dropping a partition is permanent action and there is no way to roll it back. Do you have a recent backup? You can restore the table from it. See: https://my.vertica.com/docs/9.0.x/HTML/index.htm#Authoring/AdministratorsGuide/BackupRestore/RestoringIndividualObjectsfromaFullorPartialBackup.htm I...

Vertica already provides Text Search. Text Search allows you to quickly search the contents of a single CHAR, VARCHAR, LONG VARCHAR, VARBINARY, or LONG VARBINARY field within a table to locate a specific token. Vertica implements that capability using a dedicated Text Index to store all the individ...

Awesome 3 Part Blog post by Soniya : Project Overview This post presents an overview of an ongoing series that focuses on using Vertica, Raspberry Pi, and Apache Kafka to track commercial aircraft in near-real time. Part 1: https://my.vertica.com/blog/blog-post-series-using-vertica-track-commercial-...