[jira] [Created] (HIVE-5662) Projecting annonymous column from a table produces unclear error message

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

Xuefu Zhang created HIVE-5662:
---------------------------------

             Summary: Projecting annonymous column from a table produces unclear error message
                 Key: HIVE-5662
                 URL: https://issues.apache.org/jira/browse/HIVE-5662
             Project: Hive
          Issue Type: Bug
          Components: Query Processor
    Affects Versions: 0.12.0
            Reporter: Xuefu Zhang
            Assignee: Xuefu Zhang


I have a table created with CTAS with anonymous column. Trying to project the column gives unhelpful error message:

{code}
hive> desc tmpz;
OK
_c0                 	int                 	None                
Time taken: 0.062 seconds, Fetched: 1 row(s)
hive> select _c0 from tmpz;
FAILED: ParseException line 1:11 missing \' at 'from' near '<EOF>'
{code}

I know I need to use `_c0` for that, but the error message gives no help for new users.



--
This message was sent by Atlassian JIRA
(v6.1#6144)