Search found 1823 matches
- 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
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...
- Fri Jan 27, 2012 4:40 am
- Forum: New to Vertica
- Topic: How to drop columns from a table
- Replies: 6
- Views: 7899
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...
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.