[jira] [Created] (HIVE-10120) Disallow create table with dot/colon in column name

[Pengcheng Xiong (JIRA)]

Pengcheng Xiong created HIVE-10120:
--------------------------------------

             Summary: Disallow create table with dot/colon in column name
                 Key: HIVE-10120
                 URL: https://issues.apache.org/jira/browse/HIVE-10120
             Project: Hive
          Issue Type: Improvement
            Reporter: Pengcheng Xiong
            Assignee: Pengcheng Xiong


Since we don't allow users to query column names with dot in the middle such as 
emp.no, don't allow users to create tables with such columns that cannot be 
queried. Fix the documentation to reflect this fix.

Here is an example. Consider this table:
{code}
CREATE TABLE a (`emp.no` string);
{code}
select `emp.no` from a; fails with this message:
FAILED: RuntimeException java.lang.RuntimeException: cannot find field emp from 
[0:emp.no]
{code}

The hive documentation needs to be fixed:
{code}
 (https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL) seems to 
 indicate that any Unicode character can go between the backticks in the select 
statement, but it doesn’t like the dot/colon or even select * when there is a 
column that has a dot/colon. 
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)