[HIVE-2943] Escaping quote in partition value encodes both backslash and quote in the partition name

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 0.9.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Alan Gates
• Created: 10/Apr/12 21:42
• Updated: 13/Mar/17 18:43

Description

create table foo (a string, c int) partitioned by (b string) stored as textfile;
alter table foo add partition (b = 'abc\'def') location '/bla';
show partitions foo;
OK
b=abc%5C%27def

The \ has been encoded in as %5C in addition to the single quote (%27). The parser should remove the backslash in this context, since it is here to escape the single quote.

Issue Links

• is related to: SPARK-19912 String literals are not escaped while performing Hive metastore level partition pruning
• is related to: HIVE-11723 Incorrect string literal escaping