Turn Off Row Counts in VSQL: Quick Tip

Posted December 19, 2018 by Jim Knicely, Big Data Solutions Architect, Vertica

City in Blur Motion
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:

https://www.vertica.com/docs/latest/HTML/Content/Authoring/ConnectingToVertica/vsql/CommandLineOptions/PAssignment–psetAssignment.htm

https://www.vertica.com/docs/latest/HTML/Content/Authoring/ConnectingToVertica/vsql/Meta-Commands/psetNAMEVALUE.htm

Have fun!