[
https://issues.apache.org/jira/browse/KUDU-2487?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Adar Dembo resolved KUDU-2487.
------------------------------
Resolution: Duplicate
Fix Version/s: n/a
Yeah, this is an Impala issue that's already tracked (and fixed) in IMPALA-7586.
> kudu quote escape issues in select query
> ----------------------------------------
>
> Key: KUDU-2487
> URL: https://issues.apache.org/jira/browse/KUDU-2487
> Project: Kudu
> Issue Type: Bug
> Components: impala
> Affects Versions: 1.7.0
> Environment: kudu-1.7.0
> cdh5.15.0
> impala-2.12.0
> Reporter: fangwan
> Priority: Critical
> Fix For: n/a
>
>
> From impala shell, I am getting wrong results by using escape single quote
> for query, details explained below:
> 1. create a kudu table like:
> {code:java}
> CREATE TABLE test_cf_escape(
> x INT NOT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
> y STRING NOT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
> z INT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
> PRIMARY KEY(x, y)
> )
> STORED AS KUDU
> TBLPROPERTIES ('kudu.master_addresses'='hadoop-nn.xxx.com'){code}
> 2. insert data to the table:
> {code:java}
> insert into test_cf_escape (x,y,z) values (1, "chili\\\'s", 0);
> insert into test_cf_escape (x,y,z) values (1, "chili\'s", 2);
> select * from test_cf_escape;
> =>
> +---+----------+---+
> | x | y | z |
> +---+----------+---+
> | 1 | chili's | 2 |
> | 1 | chili\'s | 0 |
> +---+----------+---+
> {code}
> 3. we should get the same row by using below two select query, but failed:
> {code:java}
> select * from test_cf_escape where y = 'chili\'s'; => (1, 'chili\'s', 0)
> (supposed to read data as (1, "chili's", 2))
> select * from test_cf_escape where y = "chili's"; => (1, "chili's", 2)
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
