Vertica Blog

Vertica Blog

System tables

Helpful Tips in blue text with magnifying glass

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)...
Helpful Tips in blue text with magnifying glass

Viewing Parquet Export Events More Easily

James Knicely, Vertica Field Chief Technologist
January 27, 2020

The EXPORT TO PARQUET command exports a table, columns from a table, or query results to files in the Parquet format. When you run EXPORT TO PARQUET information about the files created during the export is stored in the Vertica log. It's no fun combing through a Vertica log looking for those particular records. Good...