spaces-X opened a new issue #6283:
URL: https://github.com/apache/incubator-doris/issues/6283
**Describe the bug**
The hash values of bucket in fe and be are inconsistent when boolean column
in the distribute keys.
**To Reproduce**
1. **create table** with boolean distribute key `benefit` and with a large
bucket num:
`CREATE TABLE `bucket_wx` ( `partition_date` int(11) NULL COMMENT "日期",
`cid` int(11) NULL, `benefit` boolean NULL, `price` int(11) SUM NULL )
ENGINE=OLAP AGGREGATE KEY(`partition_date`,`cid`,`benefit`) COMMENT "OLAP"
PARTITION BY RANGE(`partition_date`) (PARTITION p20200617 VALUES [('19000101'),
('25001231')) ) DISTRIBUTED BY HASH(`cid`,`benefit`) BUCKETS 100 PROPERTIES (
"replication_num" = "1", "in_memory" = "false", "storage_format" = "DEFAULT" );`
2. **insert data**:
`insert into bucket_wx values(20210721, 1, false, 500);`
3. **execute query sql**:
`select * from bucket_wx where cid =1 and benefit = false;`
**Expected behavior**
return the result of the inserted data.
**Screenshots**
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
