Search found 1825 matches

by JimKnicely
Fri May 04, 2012 8:45 pm
Forum: New to Vertica Database Administration
Topic: Change table column's data type
Replies: 10
Views: 28514

Re: Change table column's data type

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/
by JimKnicely
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...
by JimKnicely
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 (...
by JimKnicely
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...
by JimKnicely
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 ...
by JimKnicely
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 :

Code: Select all

if $_ == '/opt/vertica/bin/vsql'
        set syntax=sql
endif
PS. Thanks to vertica-forums user sKwa for this handy tip!
by JimKnicely
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...

Go to advanced search