Here is a great post by a even greater guy that discusses this topic a little more ...
http://proplabs.org/2012/05/04/vertica- ... le-column/
Search found 1825 matches
- Fri May 04, 2012 8:45 pm
- Forum: New to Vertica Database Administration
- Topic: Change table column's data type
- Replies: 10
- Views: 28514
- Wed May 02, 2012 9:39 pm
- Forum: New to Vertica Database Development
- Topic: ERROR: Insufficient resources to execute plan on pool...
- Replies: 3
- Views: 12965
Re: ERROR: Insufficient resources to execute plan on pool..
Update on my previous post... it seems that you have to use integer values when defining the MEMORYCAP . The 2.5G I specified won't work: dbadmin=> ALTER USER mark MEMORYCAP '2.5G'; ROLLBACK: '2.5G' is not a valid size description dbadmin=> ALTER USER mark MEMORYCAP '2.6G'; ROLLBACK: '2.6G' is not a...
- Wed May 02, 2012 4:59 pm
- Forum: New to Vertica
- Topic: How to drop columns from a table
- Replies: 6
- Views: 20895
Re: How to drop columns from a table
I wonder if it's plausible to generate a script for the table using the EXPORT_OBJECTS function and then use the generated create statements for any non-super projections to recreate them after we've created the new table without the column we want to drop? For example: dbadmin=> create table test (...
- Wed May 02, 2012 3:52 am
- Forum: Vertica Data Load
- Topic: COPY command has ETL capabilities
- Replies: 6
- Views: 16802
COPY command has ETL capabilities
The Vertica COPY command has ETL capabilities which can be very useful. Example: test_db=> CREATE TABLE IPTable (ip INTEGER); CREATE TABLE test_db=> COPY IPTable (anFiller FILLER VARCHAR(15), ip AS INET_ATON(anFiller)) FROM STDIN; Vertica is now waiting for data via the standard input to copy. Enter...
- Tue May 01, 2012 8:34 pm
- Forum: Vertica Data Load
- Topic: The COPY command supports wild cards!
- Replies: 3
- Views: 10400
The COPY command supports wild cards!
The documentation doesn't mention this, but the COPY command supports wild cards... Example: COPY some_table FROM '/path/to/data/ClickStreamData_201?/*' DIRECT... When would this be useful? For example, you have many tables storing history including folders for the years 2010, 2011, 2012, etc. Each ...
- Tue May 01, 2012 1:32 pm
- Forum: vSQL
- Topic: vsql + vim Tip
- Replies: 0
- Views: 4807
vsql + vim Tip
For people who use vsql and the editor VIM, you can enable syntax highlight by adding the following lines to ~/.vimrc :
PS. Thanks to vertica-forums user sKwa for this handy tip!
Code: Select all
if $_ == '/opt/vertica/bin/vsql'
set syntax=sql
endif
- Tue May 01, 2012 12:57 pm
- Forum: New to Vertica
- Topic: Why aren't Primary Keys Enforced?
- Replies: 5
- Views: 26621
Re: Why aren't Primary Keys Enforced?
FYI, according to the Vertica SQL Reference Manual: Checking Column Constraints When you create a projection, Vertica checks column constraints during the process. For instance, if a join predicate includes a column with a FOREIGN_KEY constraint but without a NOT_NULL constraint, the CREATE PROJECTI...