[
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: [email protected]
For additional commands, e-mail: [email protected]
