[IMPALA-6167] Single quotes inside double quotes drop data

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Duplicate
• Affects Version/s: Impala 2.10.0
• Component/s: Frontend
• Epic Color: ghx-label-5
• Assignee: Unassigned
• Reporter: yyzzjj
• Created: 07/Nov/17 06:14
• Updated: 23/Oct/18 22:36
• Resolved: 23/Oct/18 22:36

Description

> create table IMPALA_6167 (f String);
> insert into IMPALA_6167 values ("a'b'c");
> insert into IMPALA_6167 values ('a\'b\'c');
> insert into IMPALA_6167 values ("a\'b\'c");
> select f, length(f) from IMPALA_6167;
+-------+-----------+
| f     | length(f) |
+-------+-----------+
| ac    | 2         |
| a'b'c | 5         |
| a'b'c | 5         |
+-------+-----------+

I expected the string "a'b'c" to have length 5, with two single-quote characters in it.

Issue Links

• duplicates: IMPALA-3942 After creating a view that uses regexp_replace we are getting the following error: ERROR: AnalysisException: Failed to load metadata for table: