为了更快的定位您的问题，请提供以下信息，谢谢
【详述】针对bloom_filter字段进行 in 查询未生效
【背景】建表语句
CREATE TABLE mos_trade_manage__order_index (
id bigint(20) NOT NULL COMMENT “”,
gmt_create datetime NOT NULL COMMENT “”,
trade_no varchar(128) NOT NULL COMMENT “”,
gmt_modified datetime NULL COMMENT “”,
buyer_id bigint(20) NOT NULL COMMENT “”,
out_trade_no varchar(128) NULL COMMENT “”,
master_trade_no varchar(128) NULL COMMENT “”,
ticket_no varchar(128) NULL COMMENT “”,
trade_status tinyint(4) NULL COMMENT “”,
trade_type tinyint(4) NULL COMMENT “”,
refund_flag tinyint(4) NULL COMMENT “”,
logistics_status tinyint(4) NULL COMMENT “”,
item_title varchar(128) NULL COMMENT “”,
mall_id bigint(20) NULL COMMENT “”,
belong_mall_id bigint(20) NULL COMMENT “”,
goods_code varchar(32) NULL COMMENT “”,
logistics_no varchar(64) NULL COMMENT “”,
receipt_phone varchar(16) NULL COMMENT “”,
out_payment_nos varchar(15000) NULL COMMENT “”,
create_time datetime NULL COMMENT “”,
deliver_time datetime NULL COMMENT “”,
receipt_time datetime NULL COMMENT “”,
sale_channel tinyint(4) NULL COMMENT “”,
index_type varchar(32) NULL COMMENT “”,
pay_time datetime NULL COMMENT “”,
payments varchar(768) NULL COMMENT “”,
terminal_no varchar(32) NULL COMMENT “”,
item_line_no int(11) NULL COMMENT “”,
master_detail tinyint(4) NULL COMMENT “”,
tenant varchar(32) NULL COMMENT “”,
mall_no varchar(16) NULL COMMENT “”,
belong_mall_no varchar(32) NULL COMMENT “”,
counter_no varchar(32) NULL COMMENT “”,
goods_id varchar(32) NULL COMMENT “”,
source_id bigint(20) NULL COMMENT “”,
operate_type varchar(32) NULL COMMENT “”,
tags varchar(128) NULL COMMENT “”,
tc_order_id bigint(20) NULL COMMENT “”,
success_time datetime NULL COMMENT “”,
counter_id varchar(32) NULL COMMENT “”,
item_id varchar(32) NULL COMMENT “”,
sku_id varchar(32) NULL COMMENT “”,
logistics_way varchar(16) NULL COMMENT “”,
guide_user_id varchar(32) NULL COMMENT “”,
refund_status tinyint(4) NULL COMMENT “”,
attributes varchar(1048576) NULL COMMENT “”,
store_counter_no varchar(500) NULL COMMENT “”,
ext_attributes varchar(1048576) NULL COMMENT “”,
channel_tenant varchar(32) NULL COMMENT “”
) ENGINE=OLAP
PRIMARY KEY(id, gmt_create, trade_no)
PARTITION BY date_trunc(‘month’, gmt_create)
DISTRIBUTED BY HASH(trade_no)
ORDER BY(gmt_create, trade_no, source_id)
PROPERTIES (
“replication_num” = “3”,
“bloom_filter_columns” = “out_trade_no, logistics_no, ticket_no, buyer_id”,
“in_memory” = “false”,
“enable_persistent_index” = “true”,
“replicated_storage” = “true”,
“fast_schema_evolution” = “true”,
“compression” = “LZ4”
);
查询语句
SELECT
COUNT(DISTINCT (trade_no))
FROM
moscloud_public.mos_trade_manage__order_index
where
1 = 1
AND buyer_id IN (3417704150)
【是否存算分离】否
【StarRocks版本】3.2.11
【附件】
