Search found 53 matches

by Timbo
Mon Jun 25, 2012 9:19 am
Forum: Vertica Performance Tuning
Topic: Collecting statistics
Replies: 1
Views: 5950

Collecting statistics

Hi, A couple of questions around running the analyze_statistics command. 1. Can mulitiple analyze_statistics commands be run in parallel? 2. How much of an impact does this cause, is the table still usable for queries? I know this is very dependant on the hardware, but just an idea of "best practice...
by Timbo
Thu Jun 21, 2012 5:22 pm
Forum: New to Vertica Database Administration
Topic: Error checking / capture
Replies: 5
Views: 13563

Re: Error checking / capture

Thanks, just what I need, does this also apply to version 5.0.7?
by Timbo
Thu Jun 21, 2012 4:54 pm
Forum: New to Vertica Database Administration
Topic: Error checking / capture
Replies: 5
Views: 13563

Re: Error checking / capture

Hi Jim, Thanks for the reply, is there nothing that can be done internally with in vsql? How would I check the return code after each step within vsql and exit if there is an error? The SQL that I have creates about 50 new projections and drops the old ones, spliting this out would make a horrible s...
by Timbo
Thu Jun 21, 2012 12:58 pm
Forum: New to Vertica Database Administration
Topic: Error checking / capture
Replies: 5
Views: 13563

Error checking / capture

Hi, I'm very new to Vertica. I want to run a batch of SQL statements, but if there is a failure it should exit, is this easy to do? For example in Oracle you would use "WHENEVER SQLERROR {EXIT [SUCCESS | FAILURE | WARNING ..... is there something similar in Vertica? Running the following type of pro...

Go to advanced search