[jira] Updated: (HIVE-1731) Improve miscellaneous error messages

["John Sichi (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-1731?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

John Sichi updated HIVE-1731:
-----------------------------

    Comment: was deleted

(was: 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.