Search found 1825 matches
- Wed Feb 01, 2012 7:02 pm
- Forum: vSQL
- Topic: Change Result Set Format
- Replies: 5
- Views: 14222
Change Result Set Format
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...
- Wed Feb 01, 2012 4:41 pm
- Forum: Request for New Forums Categories
- Topic: New operating system forum...
- Replies: 1
- Views: 17407
Re: New operating system forum...
Thanks for the request!
A new forum named "Vertica and the Operating System" has been created under the "Using Vertica" forum category.
A new forum named "Vertica and the Operating System" has been created under the "Using Vertica" forum category.
- Tue Jan 31, 2012 7:29 pm
- Forum: Announcements, Events and Activities
- Topic: Vertica 5.1 is available for DL!!!
- Replies: 0
- Views: 5378
Vertica 5.1 is available for DL!!!
Great news! Veritca 5.1 has been released. Check it out at http://www.vertica.com/support/myvertica/!
- Tue Jan 31, 2012 7:20 pm
- Forum: Vertica Premium Edition
- Topic: Vertica 5.1 is out!
- Replies: 0
- Views: 17409
Vertica 5.1 is out!
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...
- Tue Jan 31, 2012 3:54 pm
- Forum: New to Vertica
- Topic: OLAP in Vertica: MDX vs. SQL OLAP extensions
- Replies: 3
- Views: 11628
Re: OLAP in Vertica: MDX vs. SQL OLAP extensions
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.
- Mon Jan 30, 2012 2:32 pm
- Forum: Vertica Database Development
- Topic: Auto Increment Column
- Replies: 5
- Views: 26464
Re: Auto Increment Column
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...
- Mon Jan 30, 2012 2:09 pm
- Forum: New to Vertica
- Topic: Public Synonyms?!?!
- Replies: 1
- Views: 10045
Re: Public Synonyms?!?!
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 ...