[
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
