Top "Vsql" questions

vsql is a Vertica front-end client utility for Unix-based systems that provides meta-commands and various shell-like features that facilitate writing scripts and automating a variety of tasks related to SQL.

Return Top N rows for each group (Vertica/vsql)

Familiar question, but with Vertica. I'd like to return the top 5 geo_country rows based on sum(imps) for each …

sql vertica vsql
How do I display the query time when a query completes in Vertica?

When using vsql, I would like to see how long a query took to run once it completes. For example …

sql vertica vsql
Dealing with overlapping conditions in CASE statement

SELECT (CASE WHEN ymd BETWEEN CURRENT_DATE -4 AND CURRENT_DATE -1 THEN '3day total' WHEN ymd BETWEEN CURRENT_…

sql vertica vsql