- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
how to achieve hql error handling
- Labels:
-
Apache Hadoop
-
Apache Hive
Created ‎05-28-2017 12:45 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
Created ‎05-28-2017 04:48 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Created ‎05-28-2017 04:48 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
