Navis created HIVE-3406:
---------------------------
Summary: 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
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:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
