There are a lot of cool command line options available to VSQL. One of my favorites is the –b option which causes Vertica to “beep” when a command completes. This is very useful if you are running a … (View Post)

Aggregate functions summarize data over groups of rows from a query result set. When using an aggregate function like COUNT with an "*" or "1" parameter value, you may get a diffe… (View Post)

A live aggregate projection contains columns with values that are aggregated from columns in its anchor table. When you load data into the table, Vertica aggregates the data before loading it into th… (View Post)

Be careful with this feature as Vertica will refresh that LAP after a COMMIT. Depending on the anchor table size, that could take a long time. Make sure to apply all DML in bulk prior to a COMMIT. Ve… (View Post)

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 exp… (View Post)