how to achieve hql error handling

[#1]

I have multiple queries in a hql file (say 10, every query ending with 😉 which I am running from a shell script.

When a query in between fails (say query #5), the queries after 5 do not execute, and the hive job is completed.

How can I do error handling to make sure that queries from 6 to 10 run even though query 5 fails?

[#2 · Accepted solution]

If any one is interested, this can be achieved by setting hive.cli.errors.ignore=true

hive --hiveconf hive.cli.errors.ignore=true -f myscript.sql