[HIVE-13618] Trailing spaces in partition column will be treated differently

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.0
• Fix Version/s: 2.1.0
• Assignee: Pengcheng Xiong
• Reporter: Pengcheng Xiong
• Created: 26/Apr/16 22:43
• Updated: 21/Jun/16 15:10
• Resolved: 09/May/16 05:42

Description

We store the partition spec value in the metastore. In mysql (and derby i think), the trailing space is ignored. That is, if you have a partition column "col" (type varchar or string) with value "a " and then select from the table where col = "a", it will return. However, in postgres and Oracle, the trailing space is not ignored.

Issue Links

• is blocked by: HIVE-13608 We should provide better error message while constraints with duplicate names are created
• is related to: HIVE-13299 Column Names trimmed of leading and trailing spaces
• links to: RB

Sub-Tasks

• Allow more detailed metaException to be passed to the caller: Open