[
https://issues.apache.org/jira/browse/HIVE-1731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12969991#action_12969991
]
Thomas Lento commented on HIVE-1731:
------------------------------------
hive> select actiontype, sourcetype, destinationtype,
get_json_object(payloaddata, '$.product'), regexp_extract(fullurl, '^.*?php')
from nectar_contentaction_merged_partitioned where ds = '2010-11-30' and
payloadtype = 'comment' and get_json_object(payloaddata, '$.product') =
'groups' limit 50;
Total MapReduce jobs = 1
Launching Job 1 out of 1
...
Ended Job = job_201012012222_220674 with errors
FAILED: Execution Error, return code 2 from
org.apache.hadoop.hive.ql.exec.MapRedTask
The actual error was something to do with my regexp_extract syntax:
index out of bounds error, no group 1
I didn't specify a group in the regexp, and when I made the adjustment
everything worked as expected. It seems like this should be caught earlier, or
at least the error trace for the task with the most failures (or a random task
with max_failures if there's more than one) should be dumped to the CLI.
This one might belong in a different task, since it's a much harder problem to
deal with the error traces for badly specified functions (or, worse, custom
scripts). However, in general "return code 2" is not useful. It only tells me I
need to do a bunch of work to find out what's broken, and the only reason I
know that is because I've been using Hive for a long time.
> Improve miscellaneous error messages
> ------------------------------------
>
> Key: HIVE-1731
> URL: https://issues.apache.org/jira/browse/HIVE-1731
> Project: Hive
> Issue Type: Improvement
> Components: Query Processor
> Reporter: John Sichi
> Fix For: 0.7.0
>
>
> This is a place for accumulating error message improvements so that we can
> update a bunch in batch.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
