Hi guys, Can some one help me settle an argument I'm having at work? A consultant at my company claims SSIS can load data into SQL Server faster than the COPY command can load the same data into Vertica. When I tested I consistently saw a Vertica solution as being much faster than a SQL Server solut...

Ok... The drop column feature works if I segment the table :D dbadmin=> create table test (col1 int, col2 varchar(100)) segmented by hash(col1) all nodes; CREATE TABLE dbadmin=> insert into test values (1, 'Finally'); OUTPUT -------- 1 (1 row) dbadmin=> \d test; List of Fields by Tables Schema | Tab...

Hello, Has anyone else tried to test the DROP COLUMN feature in Vertica 6.0? It seems to work when the table has no data, but as soon as it has data, it no longer works: dbadmin=> SELECT version(); version ------------------------------------ Vertica Analytic Database v6.0.0-0 (1 row) dbadmin=> CREA...

Hey, I have a bunch of vsql commands running scripts in batch mode and I would prefer that there be no out put from the vsql statements. For instance, for this simple example: v1_server$ vsql -c "select count(*) from sessions" count ------- 1 (1 row) I don't want to see the results: count ------- 1 ...

Hi Navin,

I'm trying to get this add on working too. I'll keep you updated on our progress. It aint easy.

Bill

Oops. I should have done the search! Thanks! That was a great example.

Hi all,

I'm new to Vertica and am trying to figure out how to use the INTERPOLATE predicate. Does anyone have any example use cases? Or maybe someone can explain how to use it a little better. I'd appreciate it!

Thank you.