Search found 1825 matches

by JimKnicely
Fri Jan 27, 2012 9:45 pm
Forum: Cognos
Topic: Cognos Data Size vs. Vertica Table Column Data Type Size
Replies: 1
Views: 3926

Cognos Data Size vs. Vertica Table Column Data Type Size

Hi, We have a column defined in a Vertica table as numeric(12, 5). In this column we can store numbers as large as 9999999.99999. When we query the column in Cognos using the "auto sum" feature we get an error (see attachment). Cognos is apparently sizing the field to display the sum based the table...
by JimKnicely
Fri Jan 27, 2012 2:40 pm
Forum: New to Vertica
Topic: Hi, I'm a Vertica Fan!
Replies: 3
Views: 2073

Re: Hi, I'm a Vertica Fan!

I can't wait for this forum to get more traffic too!
by JimKnicely
Fri Jan 27, 2012 4:55 am
Forum: New to Vertica Database Development
Topic: ERROR: Insufficient resources to execute plan on pool...
Replies: 3
Views: 5125

Re: ERROR: Insufficient resources to execute plan on pool..

This error indicates that the user executing the query has a memory cap setting that is insufficient for this query. The query will need about 2.5GB and the user has a max memory cap of 1GB. You can check the user's memory cap (MEMORYCAP) setting by issuing the SHOW ALL command in vSQL. dbadmin=> sh...
by JimKnicely
Fri Jan 27, 2012 4:40 am
Forum: New to Vertica
Topic: How to drop columns from a table
Replies: 6
Views: 9216

Re: How to drop columns from a table

The ability to drop a column will be a feature in the next release of Vertica. Until then, there is a work around involving creating a new table without the column, copying the data from the old table to the new table, dropping the old table and then renaming the new table to the old table name. Exa...
by JimKnicely
Fri Jan 27, 2012 3:39 am
Forum: Vertica Premium Edition
Topic: When?
Replies: 1
Views: 2856

Re: When?

I heard Vertica 5.1.0 will be released in early spring. Although its labeled as a minor upgrade, it will include a new GUI. We've been using Toad for Data Analysts. The new GUI is supposed to be a graphical version of the dbadmin tools.

Go to advanced search