You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Adam Kramer (JIRA)" <ji...@apache.org> on 2011/06/22 23:34:47 UTC
[jira] [Commented] (HIVE-1731) Improve miscellaneous error messages
[ https://issues.apache.org/jira/browse/HIVE-1731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13053480#comment-13053480 ]
Adam Kramer commented on HIVE-1731:
-----------------------------------
Syed, can you also link the other task to finish the other messages here? I'll start posting my new complaints about error messages there now since this one's done. :)
Here's one:
hive> select count(1), b.age from t1 a join t2 b ON a.key = b.key and a.ds='2011-06-10' AND b.ds='2011-06-10';
FAILED: Error in semantic analysis: Line 1:17 Expression not in GROUP BY key 'age'
...this should say, 'b.age' and not just 'age.' Why? Because it's different from this:
hive> select count(1), b.age from t1 a join t2 b ON a.key = b.key and a.ds='2011-06-10' AND b.ds='2011-06-10' GROUP BY age;
FAILED: Error in semantic analysis: Line 1:17 Expression not in GROUP BY key 'age'
...which is many times more maddening than the first error message.
> Improve miscellaneous error messages
> ------------------------------------
>
> Key: HIVE-1731
> URL: https://issues.apache.org/jira/browse/HIVE-1731
> Project: Hive
> Issue Type: Improvement
> Components: Diagnosability, Query Processor
> Reporter: John Sichi
> Assignee: Syed S. Albiz
> Fix For: 0.7.1, 0.8.0
>
> Attachments: 0001-Fixed-parse-error-line-number-issue.patch, 0001-Fixed-parse-error-line-number-issue.patch, 0002-update-test-cases-with-error-string-results.patch, HIVE-1731.1.patch, HIVE-1731.2.patch, HIVE-1731.3.patch, HIVE-1731.4.patch, HIVE-1731.5.patch, HIVE-1731.6.patch, HIVE-1731.7-0.7.patch, HIVE-1731.7.patch, HIVE-1731.8-0.7.patch
>
>
> 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.
For more information on JIRA, see: http://www.atlassian.com/software/jira