How to run Vertica CE in Windows 10 using Docker
Alexandr Skorobogatov
September 14, 2021
Sometimes we want to test a new version of Vertica. In the past, the best way to do that was to use a Vertica Community Edition (CE) virtual machine. But starting with Vertica version 10.1, there is an easier way to achieve this. There is an official Docker image for the latest Vertica CE version...
Quick Tip: Replacing non-UTF-8 Characters
James Knicely, Vertica Field Chief Technologist
July 16, 2021
Vertica database servers expect to receive all data in UTF-8 and Vertica outputs all data in UTF-8. However, you can load or insert data into Vertica that is non UTF-8, but you'll want to clean it up. I used to recommend the REGEXP_REPLACE function for that task, but now there is a better way! Vertica...
Quick Tip: MC Adds a New Feedback Button
James Knicely, Vertica Field Chief Technologist
July 15, 2021
Do you love Vertica and want to let us know, or want to provide some constructive criticism? Well, now you can easily do that. Starting in Vertica 10.1.x, Management Console added a new Feedback Button which lets you submit a star rating and free-text comments to Vertica. The button displays vertically at the bottom-right of...
Quick Tip: Determining Database “Cell” Count
James Knicely, Vertica Field Chief Technologist
July 14, 2021
The Vertica system tables LICENSE_AUDITS and USER_AUDITS include a mysterious column called CELL_COUNT. What exactly is the Cell Count? It's simply a calculation that looks like this: DATABASE CELL_COUNT = (Table_1 Column Count * Table_1 Row Count) + (Table_2 Column Count * Table_2 Row Count) + … + (Table_n Column Count * Table_n Row Count)...