[
https://issues.apache.org/jira/browse/HIVE-13299?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15203132#comment-15203132
]
Lefty Leverenz commented on HIVE-13299:
---------------------------------------
Doc note: This bug fix should be documented for release 2.0.1 in these
wikidocs:
* [Create Table |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-CreateTable]
* [Alter Column -- Rules for Column Names |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-AlterColumn]
* [Select Syntax |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Select#LanguageManualSelect-SelectSyntax]
> 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
> Components: Parser
> Affects Versions: 2.0.0
> Reporter: Pengcheng Xiong
> Assignee: Pengcheng Xiong
> Labels: TODOC2.0
> Fix For: 2.1.0, 2.0.1
>
> Attachments: HIVE-13299.01.patch
>
>
> 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)
