hive-dev mailing list archives

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

    [ https://issues.apache.org/jira/browse/HIVE-1731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12970972#action_12970972
] 

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:

INSERT OVERWRITE TABLE my_table
SELECT TRANSFORM(b.user1, b.user2, b.cnt)
USING '{tr}'
AS c1,c2,c3,c4
FROM (
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: 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.


Mime
View raw message