Reply
Highlighted
Explorer
Posts: 12
Registered: ‎02-21-2019

ignore errors in .hql in oozie workflow

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');

Announcements