The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

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.

Comments

  • Hello 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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.