Top "Vertica" questions

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

SQL left outer join on multiple columns

According to this SQL join cheat-sheet, a left outer join on one column is the following : SELECT * FROM a LEFT …

sql join vertica
Advantages of databases like Greenplum or Vertica compared to MongoDB or Cassandra

I am currently working in a few projects with MongoDB and Apache Cassandra respectively. I am also using Solr a …

mongodb cassandra data-warehouse vertica greenplum
unixODBC giving error while running isql [Vertica]

Hi I have configured the DSN settings for vertica in Ubuntu 10.10 32 bit version machine. The settings are all fine and …

unixodbc vertica
Export Vertica query result to csv file

I`m working with Vertica. I try to export data from SELECT query into csv. I tried making it with …

sql csv export vertica
PROJECTION in vertica database

Could someone explain me the concept of PROJECTION in vertica database with an example query?

database projection vertica
Redshift Divide By Zero Puzzler

I was getting a divide by 0 error with this code: CASE WHEN DENOMINATOR >= 0 THEN SUM(INT1 * INT2 / DENOMINATOR) ELSE 0 …

sql amazon-redshift vertica divide-by-zero
does anyone know the format of an odbc connection string for vertica?

I'm using the following: DRIVER={Vertica ODBC Driver 4.1}; SERVER=lnxtabdb01.xxxx.com; PORT=5433; DATABASE=vertica; USER=dbadmin; PASSWORD=vertica; OPTION=3; …

odbc vertica
To_date function in Vertica format?

How can I get Vertica function to_date('','format') do output like this: DDMonYYYY - 01/ABR/2012 and not like …

database date-formatting vertica to-date
How to see the metadata of objects in Vertica Database (desc like Oracle)

I would like to know how I can get the metadata of an object in a Vertica database; like metadata …

ddl vertica
Create a variable in Vertica

I am transitioning from SQL Server to Vertica. Is there any comparable way to create a variable? Usually I do …

sql ssms vertica