[ https://issues.apache.org/jira/browse/IMPALA-6167?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tim Armstrong resolved IMPALA-6167. ----------------------------------- Resolution: Duplicate This produces the expected result on master. Pretty sure this was a special case of IMPALA-3942 {noformat} [localhost:21000] default> create table IMPALA_6167 (f String); Query: create table IMPALA_6167 (f String) +-------------------------+ | summary | +-------------------------+ | Table has been created. | +-------------------------+ Fetched 1 row(s) in 0.03s [localhost:21000] default> insert into IMPALA_6167 values ("a'b'c"); Query: insert into IMPALA_6167 values ("a'b'c") Query submitted at: 2018-10-23 15:34:17 (Coordinator: http://tarmstrong-box:25000) Query progress can be monitored at: http://tarmstrong-box:25000/query_plan?query_id=494ec4d555162ded:99226a6d00000000 Modified 1 row(s) in 0.19s [localhost:21000] default> select f, length(f) from IMPALA_6167; Query: select f, length(f) from IMPALA_6167 Query submitted at: 2018-10-23 15:34:22 (Coordinator: http://tarmstrong-box:25000) Query progress can be monitored at: http://tarmstrong-box:25000/query_plan?query_id=b9405471f15baa8f:667646c300000000 +-------+-----------+ | f | length(f) | +-------+-----------+ | a'b'c | 5 | +-------+-----------+ Fetched 1 row(s) in 0.11s {noformat} > Single quotes inside double quotes drop data > -------------------------------------------- > > Key: IMPALA-6167 > URL: https://issues.apache.org/jira/browse/IMPALA-6167 > Project: IMPALA > Issue Type: Bug > Components: Frontend > Affects Versions: Impala 2.10.0 > Reporter: yyzzjj > Priority: Critical > > {noformat} > > 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 | > +-------+-----------+ > {noformat} > I expected the string "a'b'c" to have length 5, with two single-quote > characters in it. -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org