Awesome as usual! Thanks!!!

SQL Server has a TOP n WITH TIES command that will return the greatest n values and includes ties (those that are equal). In Vertica we have the LIMIT command and I can get the TOP 3 values using a LIMIT 3 in combination with ordering the data descending... dbadmin=> select * from top; numbers -----...

Can someone explain to me what is the difference between the -a (Echo all input from script) and -e (Echo commands sent to server) command line options of vsql? They seem to do the same exact thing!

Thanks! I can add the delete command to my scripts. Good idea

Thanks for sharing this. Does anyone know how to do the same when executing a query from the command line?

Thanks, Jim. Sorry, I should have searched the site before posting

Good morning! From the vsql command line, I am running a query which does not produce a result set. The -o option creates a file having a size of zero. Example: [dbadmin@vertica-1]$ vsql -Atc "select * from dual where 1 = 2" -o /home/dbadmin/test.txt [dbadmin@vertica-1]$ ls -lrt /home/dbadmin/test.t...