https://community.cloudera.com/t5/Support-Questions/how-to-achieve-hql-error-handling/m-p/189044#M151137 <P>I have multiple queries in a hql file (say 10, every query ending with <span class="lia-unicode-emoji" title=":winking_face:">😉</span> which I am running from a shell script.</P><P> When a query in between fails (say query #5), the queries after 5 do not execute, and the hive job is completed.</P><P>How can I do error handling to make sure that queries from 6 to 10 run even though query 5 fails?</P> Sun, 28 May 2017 19:45:28 GMT prabhat_ratnala 2017-05-28T19:45:28Z https://community.cloudera.com/t5/Support-Questions/how-to-achieve-hql-error-handling/m-p/189044#M151137 <P>I have multiple queries in a hql file (say 10, every query ending with <span class="lia-unicode-emoji" title=":winking_face:">😉</span> which I am running from a shell script.</P><P> When a query in between fails (say query #5), the queries after 5 do not execute, and the hive job is completed.</P><P>How can I do error handling to make sure that queries from 6 to 10 run even though query 5 fails?</P> Sun, 28 May 2017 19:45:28 GMT https://community.cloudera.com/t5/Support-Questions/how-to-achieve-hql-error-handling/m-p/189044#M151137 prabhat_ratnala 2017-05-28T19:45:28Z https://community.cloudera.com/t5/Support-Questions/how-to-achieve-hql-error-handling/m-p/189045#M151138 <P>If any one is interested, this can be achieved by setting hive.cli.errors.ignore=true</P><PRE>hive --hiveconf hive.cli.errors.ignore=true -f myscript.sql </PRE> Sun, 28 May 2017 23:48:49 GMT https://community.cloudera.com/t5/Support-Questions/how-to-achieve-hql-error-handling/m-p/189045#M151138 prabhat_ratnala 2017-05-28T23:48:49Z