Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

ignore errors in .hql in oozie workflow

Highlighted

ignore errors in .hql in oozie workflow

Explorer

Hi , 

 

I implmented below statements in .hql file and call this file in workflow.xml in oozie. I dont want oozie workflow to fail

in case table1 does not exist i.e to ignore error if alter statement fails. I tried to use "SET hive.cli.errors.ignore=true;"

but this didnt help. any suggestions ?

 

SET hive.cli.errors.ignore=true;

 

alter table table1 SET TBLPROPERTIES('EXTERNAL'='FALSE');