You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2020/01/08 05:48:05 UTC
[GitHub] [incubator-doris] jmk1011 opened a new issue #2699: insert select
into bitmap column with negative number may be filtered
jmk1011 opened a new issue #2699: insert select into bitmap column with negative number may be filtered
URL: https://github.com/apache/incubator-doris/issues/2699
**Describe the bug**
insert select into bitmap column with negative number may be filtered
filter reson:
Reason: The to_bitmap function argument: -2147483647 type isn't integer family or exceed unsigned integer max value 4294967295. src line: [bitmap_set];
this is different from https://github.com/apache/incubator-doris/issues/2678 .the column in baseall is more than baseall table in 2678
**To Reproduce**
1. CREATE TABLE `baseall` (
`k1` tinyint(4) NULL COMMENT "",
`k2` smallint(6) NULL COMMENT "",
`k3` int(11) NULL COMMENT "",
`k4` bigint(20) NULL COMMENT "",
`k5` decimal(9, 3) NULL COMMENT "",
`k6` char(5) NULL COMMENT "",
`k10` date NULL COMMENT "",
`k11` datetime NULL COMMENT "",
`k7` varchar(20) NULL COMMENT "",
`k8` double MAX NULL COMMENT "",
`k9` float SUM NULL COMMENT ""
) ENGINE=OLAP
AGGREGATE KEY(`k1`, `k2`, `k3`, `k4`, `k5`, `k6`, `k10`, `k11`, `k7`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`k1`) BUCKETS 5
PROPERTIES (
"storage_type" = "COLUMN"
);
2. insert into baseall values (12,32767,-2147483647,9223372036854775807,243.325,'false','1991-08-11','2013-04-02 15:16:52','liuyuantuo',-564.898,3.1415927);
insert into baseall values (3,1989,1002,11011905,24453.325,'false','2012-03-14','2000-01-01 00:00:00','yuanyuan06',78945,3654);
insert into baseall values (10,1991,5014,9223372036854775807,-258.369,'false','2015-04-02','2013-04-02 15:16:52','wangyu14',-123456.54,0.235);
insert into baseall values (8,255,2147483647,11011920,-0.123,'true','1989-03-21','9999-11-11 12:12:00','wangjing05',987456.123,12.14);
insert into baseall values (9,1991,-2147483647,11011902,-654.654,'true','1991-08-11','1989-03-21 13:11:00','wangjing04',0,69.123);
insert into baseall values (11,1989,25699,-9223372036854775807,0.666,'true','2015-04-02','1989-03-21 13:11:00','yuanyuan06',-987.001,4.336);
insert into baseall values (13,-32767,2147483647,-9223372036854775807,100.001,'false','2015-04-02','2015-04-02 00:00:00','weike01',123.456,3.1415927);
insert into baseall values (14,255,103,11011902,0,'false','2015-04-02','2015-04-02 00:00:00','',3.141592654,2.036);
insert into baseall values (7,-32767,1002,7210457,3.141,'false','1988-03-21','1901-01-01 00:00:00','jingyong',0,6058);
insert into baseall values (6,32767,3021,123456,604587,'true','2014-11-11','2015-03-13 12:36:38','yanhuiacng01',0.1,80699);
insert into baseall values (4,1991,3021,-11011907,243243.325,'false','3124-10-10','2015-03-13 10:30:00','yanhuicang01',2.06,-0.001);
insert into baseall values (5,1985,5014,-11011903,243.325,'true','2015-01-01','2015-03-13 12:36:38','duyunkai@123',-0,-365);
insert into baseall values (1,1989,1001,11011902,123.123,'true','1989-03-21','1989-03-21 13:00:00','wangjing04',0.1,6.333);
insert into baseall values (2,1986,1001,11011903,1243.5,'false','1901-12-31','1989-03-21 13:00:00','wangyu14',20.268,789.25);
insert into baseall values (15,1992,3021,11011920,0,'true','9999-12-12','2015-04-02 00:00:00','',3.141592653,20.456);
3. CREATE TABLE test_bitmap_tb ( id int COMMENT "", id1 tinyint COMMENT "", c_float float SUM COMMENT "", bitmap_set bitmap BITMAP_UNION COMMENT "" ) ENGINE=OLAP DISTRIBUTED BY HASH(id, id1) BUCKETS 5 PROPERTIES ( "storage_type" = "COLUMN" );
4. insert into test_bitmap_tb select k3, k1, k9, TO_BITMAP(k3) from baseall;
(This phenomenon does not recur stably, you can try step-4 a few more times)
**Screenshots**
If applicable, add screenshots to help explain your problem.
**Code Version**
https://github.com/apache/incubator-doris/commit/72fd74508607aab85be5f390579de4d7300383c8
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] kangkaisen commented on issue #2699: insert
select into bitmap column with negative number may be filtered
Posted by GitBox <gi...@apache.org>.
kangkaisen commented on issue #2699: insert select into bitmap column with negative number may be filtered
URL: https://github.com/apache/incubator-doris/issues/2699#issuecomment-571904022
`The to_bitmap function argument: -2147483647 type isn't integer family or exceed unsigned integer max value 4294967295. src line: [bitmap_set];`
This is reasonable and not a issue.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] jmk1011 commented on issue #2699: insert select
into bitmap column with negative number may be filtered
Posted by GitBox <gi...@apache.org>.
jmk1011 commented on issue #2699: insert select into bitmap column with negative number may be filtered
URL: https://github.com/apache/incubator-doris/issues/2699#issuecomment-571905194
but be will core. and in https://github.com/apache/incubator-doris/issues/2678, insert with the same value -2147483647 will return success.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] kangkaisen commented on issue #2699: insert
select into bitmap column with negative number may be filtered
Posted by GitBox <gi...@apache.org>.
kangkaisen commented on issue #2699: insert select into bitmap column with negative number may be filtered
URL: https://github.com/apache/incubator-doris/issues/2699#issuecomment-571945480
> #2678
Be core is bug, I will fix it.
to_bitmap only support int value from 0 to 4294967295 currently.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] imay closed issue #2699: insert select into
bitmap column with negative number may be filtered
Posted by GitBox <gi...@apache.org>.
imay closed issue #2699: insert select into bitmap column with negative number may be filtered
URL: https://github.com/apache/incubator-doris/issues/2699
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org