[ https://issues.apache.org/jira/browse/HIVE-3406?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Navis updated HIVE-3406: ------------------------ Status: Patch Available (was: Open) https://reviews.facebook.net/D4869 > 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