hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Adam Kramer (JIRA)" <>
Subject [jira] Commented: (HIVE-1731) Improve miscellaneous error messages
Date Mon, 13 Dec 2010 19:14:02 GMT


Adam Kramer commented on HIVE-1731:

FAILED: Parse Error: line 0:-1 mismatched input '<EOF>' expecting ) in subquery source

No error that refers to lines 0:-1 is ever useful. Here is an example query:

SELECT TRANSFORM(b.user1, b.user2, b.cnt)
USING '{tr}'
AS c1,c2,c3,c4
SELECT b.user1, b.user2, b.cnt FROM (
    SELECT user1, user2, COUNT(1) AS cnt
    FROM sourcetable
    WHERE ds > '2010-12-01' AND ds <= '2010-12-07'
    GROUP BY user1, user2
    DISTRIBUTE BY user1 SORT BY user1, cnt
) b;

...the problem here is that the inner query is not indented and lacks a ). This error message
should report the error as being at the ;, which is to say 12:4. Since the message knows an
rparen is missing, it should also provide the index of the lparen. It should read like this:

FAILED: Parse Error: line 12:4 mismatched input '<EOF>' expecting ) in subquery source
to close ( at line 5:6.

> Improve miscellaneous error messages
> ------------------------------------
>                 Key: HIVE-1731
>                 URL:
>             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.

View raw message