Turn Off Row Counts in VSQL: Quick Tip

Posted December 19, 2018 by James Knicely, Vertica Field Chief Technologist

Modern Database Analytics
he SET NOCOUNT command in SQL Server will stop the message indicating the number of rows affected by a Transact-SQL statement from being returned as part of the results.

You can accomplish the same thing in Vertica by shutting off the footer.

Example: [dbadmin@s18384357 ~]$ vsql -c "SELECT * FROM dual;" dummy ------- X (1 row) [dbadmin@s18384357 ~]$ vsql -P footer=off -c "SELECT * FROM dual;" dummy ------- X Helpful Links:



Have fun!