You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Ashutosh Chauhan (JIRA)" <ji...@apache.org> on 2016/03/18 02:06:33 UTC

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

    [ https://issues.apache.org/jira/browse/HIVE-13299?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15200744#comment-15200744 ] 

Ashutosh Chauhan commented on HIVE-13299:
-----------------------------------------

+1 pending tests
 Can you also add {{describe formatted  space}} in test case.

> 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
>         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)