The Vertica 6.0 Programmer's Guide mentions the ON_ERROR_STOP vsql variable: ON_ERROR_STOP By default, if non-interactive scripts encounter an error, such as a malformed SQL command or internal meta-command, processing continues. This has been the traditional behavior of vsql but it is sometimes not...

Hi, Welcome to the forums! One solution may be to create a shell script and then check for errors after each call to Vertica. You would exit the script if an error occurs when running a command against Vertica. For instance, something like this: /opt/vertica/bin/vsql -c "Create Projection......" if ...

Here's a link to a pretty good white paper from Informatica. You have to sign up, but its worth the read... Titled "Change Data Capture and Replication from Oracle into HP Vertica using Informatica Data Replication" http://vip.informatica.com/?elqPURLPage=9448&mkwid=snc1oEbxk&pcrid=9189250093&kw=ver...

That's an awesome time! Out of curiosity, how many columns were in the table you loaded? And what was the file size was the data file you loaded? I remember a Vertica rep. told me that when files are bigger than 1 GB they should be broken up into smaller pieces. I wonder if that's true or not.

I believe that the "database password" is simply the database superuser's password.

If your superuser account is dbadmin, just use the ALTER USER statement:

Hi, You can change a user's password in the Vertica database using the ALTER USER statement: Example: Logged in as the admin, I'll create a user jim and then log in as the user jim : dbadmin=> create user jim identified by 'pluto'; CREATE USER dbadmin=> \q bash-3.2$ vsql -U jim -w pluto SET Welcome ...

Hi! Welcome to Vertica forums! Check out this link for the best free tools for querying Vertica: http://vertica-forums.com/viewtopic.php?f=7&t=212 There is also a version of Toad you can use: http://vertica-forums.com/viewforum.php?f=19 How many tables and how much data do you have to move into Vert...