Search found 1825 matches
- Thu Jun 21, 2012 5:16 pm
- Forum: New to Vertica Database Administration
- Topic: Error checking / capture
- Replies: 5
- Views: 13554
Re: Error checking / capture
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...
- Thu Jun 21, 2012 4:12 pm
- Forum: New to Vertica Database Administration
- Topic: Error checking / capture
- Replies: 5
- Views: 13554
Re: Error checking / capture
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 ...
- Sat Jun 16, 2012 1:40 am
- Forum: Vertica Links
- Topic: An Informatica White Paper (Oracle into HP)
- Replies: 0
- Views: 5898
An Informatica White Paper (Oracle into HP)
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...
- Fri Jun 15, 2012 4:52 pm
- Forum: Vertica Data Load
- Topic: SQL Server vs. Vertica Bulk Load
- Replies: 6
- Views: 17840
Re: SQL Server vs. Vertica Bulk Load
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.
- Fri Jun 15, 2012 4:46 pm
- Forum: Vertica Database Administration
- Topic: Reset Password
- Replies: 6
- Views: 19708
Re: Reset Password
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:
If your superuser account is dbadmin, just use the ALTER USER statement:
Code: Select all
ALTER USER dbadmin IDENTIFIED BY 'newpassword';
- Fri Jun 15, 2012 3:23 pm
- Forum: Vertica Database Administration
- Topic: Reset Password
- Replies: 6
- Views: 19708
Re: Reset Password
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 ...
- Fri Jun 15, 2012 2:45 am
- Forum: New to Vertica
- Topic: Move Data From Oracle to Vertica
- Replies: 6
- Views: 35725
Re: Move Data From Oracle to Vertica
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...