Execute Query on condition
I want to run Query B only if Query A fails. Is there any way to do this in vertica. In Teradata we have BTEQ where we ca use If, Else and Level to achieve this.
+2Hello Shibashis, Currently the If / Else constructs are not supported in Vertica. We can try to implement the above scenario Create temporary table with query A, Then modify query B with and clause to check if the count of temporary table is greater then one to be executed. Hope this helps
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
