Familiar question, but with Vertica. I'd like to return the top 5 geo_country rows based on sum(imps) for each tag_id. This is the query I started: SELECT tag_id, geo_country, SUM(imps) AS imps,...

I am look for a command in vsql which is equivalent of \g in mysql console, because I need display the result set vertically, looking like this:

When using vsql, I would like to see how long a query took to run once it completes. For example when i run: select count(distinct key) from schema.table; I would like to see an output like: 56...