The default output format used by vSQL isn't the best if need to cut and paste the result set of a query into another application. The \pset command can be used to change the formatting. For example, I can get rid of the vertical bars with \pset border 0 dbadmin=> select * from test_table; name | ag...

Thanks for the request!

A new forum named "Vertica and the Operating System" has been created under the "Using Vertica" forum category.

Great news! Veritca 5.1 has been released. Check it out at http://www.vertica.com/support/myvertica/!

Hi, I just received an email from Vertica supports that Vertica 5.1 is out! Some key features: 1. VERTICA MANAGEMENT CONSOLE 2. NEW CLIENT DRIVERS (ODBC and JDBC drivers have been completely rewritten) 3. New platforms include (HP-UX 11.33 on PA-RISC and Itanium, AIX 6.x on PowerPC, Linux on Itanium...

Vertica does not support MDX queries, however, it can be integrated with Mondrian (http://mondrian.pentaho.com/) or Microsoft SQL Server Analysis Services (SSAS) which do support MDX.

Vertica supports the auto-increment and identity column-constraints. auto_increment is pretty basic, it always starts with 1 and increments by 1. The identity constraint is more robust in that it takes a few extra parameters: seed, increment and cache, where seed = the starting value, increment is t...

Vertica does not have public synonyms like Oracle. However, you can set a variable called search_path that lists in order the schemas Vertica will try to resolve the full path to the object. Example: I am logged into Vertica via vsql as the vertica_user1 user. I want to get a table row count from a ...