Search found 1823 matches

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: 4322

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: 7899

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: 2123

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