Top "Vertica" questions

Vertica is an MPP column-store analytics database that runs on clusters of Linux servers or in the cloud.

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
Convert comma separated string to a list

I want to pass a list of int's (comma separated) which is a field in my table ie. 1234, 2345, 3456, 4567 to my …

sql vertica
How to search column_names in Vertica?

Anyone know of a handy function to search through column_names in Vertica? From the documentation, it seems like \d …

search vertica
Vertica, describe table

I have a vertica database and I need to describe some tables. In MySQL you use describe table_name. And …

python vertica
Delete Duplicate rows in Vertica database

Vertica allows duplicates to be inserted into the tables. I can view those using the 'analyze_constraints' function. How to …

vertica
how connect to vertica using pyodbc

I've read the iODBC documentation regarding the odbc.ini, and the Vertica documentation. I also saw a question with the …

python pyodbc unixodbc vertica
Concat GROUP BY in Vertica SQL

I need to get a comma separated list of ids as a field for a messy third party api :s …

sql vertica
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
Connect R and Vertica using RODBC

This is my first time connecting to Vertica. I have already connected to a MySQL database sucessfully by using RODBC …

r rodbc vertica
Can I create an index on a table in Vertica?

I've created a table on Vertica, and I want to create an index on that table. I can't see how …

vertica