[jira] [Updated] (HIVE-3406) Yet better error message in CLI on invalid column name

["Navis (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-3406?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Navis updated HIVE-3406:
------------------------

    Fix Version/s: 0.10.0
    
> 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