Major Description
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 0 row(s) in 0.16s
impala> select name,description from test1 where name in ("t1:a\"'x
bbx");
Fetched 0 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 1 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 1 row(s) in 0.36s
Attachments
Issue Links
- duplicates
-
IMPALA-7586 Incorrect results when querying primary = "\"" in Kudu and HBase
-
- Resolved
-