You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Matt Pestritto <ma...@pestritto.com> on 2009/05/26 21:47:24 UTC
Optional Exception for 0 Rows Loaded
Hi.
I have a process that is written in hive that is a lot of queries, it moves
quite a bit of data around. I've been working on stabilizing/automating the
process and would like to stop the process if during an "insert overwrite
table... " no rows are inserted.
Recommendations?
Some thoughts I've had so far are:
* I can parse std out but would rather not. The output messages could
change in the future.
* Could hive -e return a non-zero return code or throw an exception when 0
rows are inserted after an insert overwrite ?
As a default rule, this maybe too strict - only do this based on a
supplied parameter? e.g. set hive.exec.error_zero_row_dml = true
Thanks
-Matt