[HIVE-13299] Column Names trimmed of leading and trailing spaces

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.0
• Fix Version/s: 2.0.1, 2.1.0
• Component/s: Parser
• Labels: TODOC2.0
• Assignee: Pengcheng Xiong
• Reporter: Pengcheng Xiong
• Created: 17/Mar/16 18:26
• Updated: 21/Jun/16 15:44
• Resolved: 19/Mar/16 16:21

Description

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

` left` resulted in `left`
` middle ` resulted in `middle`
`right ` resulted in `right`
`middle space` resulted in `middle space`
` middle space ` resulted in `middle space`

Issue Links

• relates to: HIVE-13618 Trailing spaces in partition column will be treated differently