You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Pengcheng Xiong (JIRA)" <ji...@apache.org> on 2016/03/17 19:27:33 UTC

[jira] [Created] (HIVE-13299) Column Names trimmed of leading and trailing spaces

Pengcheng Xiong created HIVE-13299:
--------------------------------------

             Summary: Column Names trimmed of leading and trailing spaces
                 Key: HIVE-13299
                 URL: https://issues.apache.org/jira/browse/HIVE-13299
             Project: Hive
          Issue Type: Bug
            Reporter: Pengcheng Xiong
            Assignee: Pengcheng Xiong


PROBLEM:
As per the Hive Language DDL: 
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL
In Hive 0.12 and earlier, only alphanumeric and underscore characters are allowed in table and column names.
In Hive 0.13 and later, column names can contain any Unicode character (see HIVE-6013). Any column name that is specified within backticks (`) is treated literally.
However column names
{code}
` left` resulted in `left`
` middle ` resulted in `middle`
`right ` resulted in `right`
`middle space` resulted in `middle space`
` middle space ` resulted in `middle space`
{code}



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