xqinghu opened a new issue #5984:
URL: https://github.com/apache/incubator-doris/issues/5984
orthogonal_bitmap_union_count与bitmap_union_count结果不一致
doris version: 0.14.0
表结构：
`
CREATE TABLE report_test3 (
ad_channel_id int(11) NOT NULL COMMENT "",
aid bigint(20) NOT NULL COMMENT "",
hid int NOT NULL COMMENT "",
n bigint(20) SUM NULL DEFAULT "0" COMMENT ""
,pv bitmap BITMAP_UNION NOT NULL COMMENT ""
) ENGINE=OLAP
AGGREGATE KEY(ad_channel_id,aid,hid)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`hid`) BUCKETS 32;
`
查询结果：
`
SELECT hid,bitmap_union_count(pv) FROM report_test3 WHERE
ad_channel_id=100 GROUP BY hid;
"214211" "1042"
SELECT hid,orthogonal_bitmap_union_count(pv) FROM report_test3 WHERE
ad_channel_id=100 GROUP BY hid;
"214211" "-6098365376223328081"
`
--
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:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
