Pain Sun created KUDU-3518:
------------------------------
Summary: node error when impala query
Key: KUDU-3518
URL: https://issues.apache.org/jira/browse/KUDU-3518
Project: Kudu
Issue Type: Bug
Components: tserver
Affects Versions: 1.17.0
Environment: centos7.9
Reporter: Pain Sun
Scan kudu with impala-4.3.0 ,there is a bug when reading a table with an empty
string in primary key field.
sql:
select
count(distinct thirdnick)
from
member.qyexternaluserdetailinfo_new
where
(
mainshopnick = "xxx"
and ownercorpid in ("xxx", "")
and shoptype not in ("35", "56")
and isDelete = 0
and thirdnick != ""
and thirdnick is not null
);
error:ERROR: Unable to open scanner for node with id '1' for Kudu table
'impala::member.qyexternaluserdetailinfo_new': Invalid argument: No such
column: shopnick
If update sql like this:
select
count(distinct thirdnick)
from
member.qyexternaluserdetailinfo_new
where
(
mainshopnick = "xxx"
and ownercorpid in ("xxx", "")
and shopnick not in ('')
and shoptype not in ("35", "56")
and isDelete = 0
and thirdnick != ""
and thirdnick is not null
);
no error.
this error appears in kudu-1.17.0 ,but kudu-1.16.0 is good.
There is 1000000 items in this table ,280000 items where empty string.
table schema like this:
+----------------+-----------+---------+-------------+------------+----------+---------------+---------------+---------------------+------------+
| name | type | comment | primary_key | key_unique | nullable |
default_value | encoding | compression | block_size |
+----------------+-----------+---------+-------------+------------+----------+---------------+---------------+---------------------+------------+
| mainshopnick | string | | true | true | false |
| AUTO_ENCODING | DEFAULT_COMPRESSION | 0 |
| shopnick | string | | true | true | false |
| AUTO_ENCODING | DEFAULT_COMPRESSION | 0 |
| ownercorpid | string | | true | true | false |
| AUTO_ENCODING | DEFAULT_COMPRESSION | 0 |
| shoptype | string | | true | true | false |
| AUTO_ENCODING | DEFAULT_COMPRESSION | 0 |
| clientid | string | | true | true | false |
| AUTO_ENCODING | DEFAULT_COMPRESSION | 0 |
| thirdnick | string | | true | true | false |
| AUTO_ENCODING | DEFAULT_COMPRESSION | 0 |
| id | bigint | | true | true | false |
| AUTO_ENCODING | DEFAULT_COMPRESSION | 0 |
| receivermobile | string | | false | | true |
| AUTO_ENCODING | DEFAULT_COMPRESSION | 0 |
| thirdrealname | string | | false | | true |
| AUTO_ENCODING | DEFAULT_COMPRESSION | 0 |
| remark | string | | false | | true |
| AUTO_ENCODING | DEFAULT_COMPRESSION | 0 |
| createtime | timestamp | | false | | true |
| AUTO_ENCODING | DEFAULT_COMPRESSION | 0 |
| updatetime | timestamp | | false | | true |
| AUTO_ENCODING | DEFAULT_COMPRESSION | 0 |
| isdelete | int | | false | | true |
0 | AUTO_ENCODING | DEFAULT_COMPRESSION | 0 |
| buyernick | string | | false | | true |
| AUTO_ENCODING | DEFAULT_COMPRESSION | 0 |
+----------------+-----------+---------+-------------+------------+----------+---------------+---------------+---------------------+------------+
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
