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