[IMPALA-7784] Partition pruning handles escaped strings incorrectly

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: Impala 3.0
• Fix Version/s: Impala 3.4.0
• Component/s: Frontend
• Labels: correctness planner
• Target Version: Impala 3.4.0
• Epic Color: ghx-label-2
• Assignee: Quanlong Huang
• Reporter: Csaba Ringhofer
• Created: 30/Oct/18 17:52
• Updated: 14/May/20 03:26
• Resolved: 09/Mar/20 07:39

Description

Repro:

create table tpart (i int) partitioned by (p string)
insert into tpart partition (p="\"") values (1);

select  * from tpart where p = "\"";
Result;
Fetched 0 row(s)

select  * from tpart where p = '"';
Result:
1,""""

Hive returns the row for both queries.

Issue Links

• relates to: IMPALA-7586 Incorrect results when querying primary = "\"" in Kudu and HBase
• links to: Code Review