[
https://issues.apache.org/jira/browse/KUDU-2575?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16612600#comment-16612600
]
Adar Dembo commented on KUDU-2575:
----------------------------------
Do the original queries ({{select from where name="..."}} and {{select from
where name in "..."}}) return the row after it's also been returned from
{{select from where name like "..."}} and {{select from where name in (select
"...")}}? That is, do the failing queries succeed if given time? Or do they
always fail?
Likewise, do any of the query results change if initiated from a different
Impala daemon?
> kudu query return wrong results
> -------------------------------
>
> Key: KUDU-2575
> URL: https://issues.apache.org/jira/browse/KUDU-2575
> Project: Kudu
> Issue Type: Bug
> Components: impala
> Affects Versions: 1.6.0
> Reporter: jim zh
> Priority: Major
>
> impala> CREATE TABLE test1( name string, description string, xtype int,
> PRIMARY KEY(name) ) STORED AS kudu;
> impala> insert into `test1` (`name`,`description`,`xtype`) values
> ("t1:a\"'x\\bbx", 'aaa', 1),("t2:a\"'x\\bbx", 'bbb', 1),("t3:a\"'x\\bbx",
> 'ccc', 1);
> impala> select name,description from test1 where name="t1:a\"'x\\bbx";
> Fetched {color:#FF0000}0{color} row(s) in 0.16s
> impala> select name,description from test1 where name in ("t1:a\"'x\\bbx");
> Fetched {color:#FF0000}0{color} row(s) in 0.05s
> impala> select name,description from test1 where name like "t1:a\"'x\\bbx";
> +-------------+-------------+
> | name | description |
> +-------------+-------------+
> | t1:a"'x\bbx | aaa |
> +-------------+-------------+
> Fetched {color:#FF0000}1{color} row(s) in 0.16s
> impala> select name,description from test1 where name in (select
> "t1:a\"'x\\bbx");
> +-------------+-------------+
> | name | description |
> +-------------+-------------+
> | t1:a"'x\bbx | aaa |
> +-------------+-------------+
> Fetched {color:#FF0000}1{color} row(s) in 0.36s
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
