You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Hudson (JIRA)" <ji...@apache.org> on 2013/01/09 11:27:38 UTC
[jira] [Commented] (HIVE-3406) Yet better error message in CLI on
invalid column name
[ https://issues.apache.org/jira/browse/HIVE-3406?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13548029#comment-13548029 ]
Hudson commented on HIVE-3406:
------------------------------
Integrated in Hive-trunk-hadoop2 #54 (See [https://builds.apache.org/job/Hive-trunk-hadoop2/54/])
HIVE-3406 Yet better error message in CLI on invalid column name
(Navis via namit) (Revision 1377314)
Result = ABORTED
namit : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1377314
Files :
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/RowResolver.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java
* /hive/trunk/ql/src/test/results/clientnegative/clustern4.q.out
* /hive/trunk/ql/src/test/results/clientnegative/semijoin1.q.out
* /hive/trunk/ql/src/test/results/clientnegative/semijoin2.q.out
* /hive/trunk/ql/src/test/results/clientnegative/semijoin3.q.out
* /hive/trunk/ql/src/test/results/clientnegative/semijoin4.q.out
> Yet better error message in CLI on invalid column name
> ------------------------------------------------------
>
> Key: HIVE-3406
> URL: https://issues.apache.org/jira/browse/HIVE-3406
> Project: Hive
> Issue Type: Improvement
> Components: Diagnosability
> Affects Versions: 0.10.0
> Reporter: Navis
> Assignee: Navis
> Priority: Trivial
> Fix For: 0.10.0
>
> Attachments: HIVE-3406.1.patch.txt
>
>
> HIVE-2256 appended column names to error message for invalid column reference, but it's not alias by which a column can be referenced. For example query in clustern4.q (negative)
> {code}
> SELECT x.key as k1, x.value FROM SRC x CLUSTER BY key;
> {code}
> makes exception with error message,
> {code}
> FAILED: SemanticException [Error 10004]: Line 2:50 Invalid table alias or column reference 'key': (possible column names are: _col0, _col1)
> {code}
> But replacing 'key' with '_col0' or '_col1' does not make this query work. The error message should be,
> {code}
> FAILED: SemanticException [Error 10004]: Line 2:50 Invalid table alias or column reference 'key': (possible column names are: k1, x.value)
> {code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira