Skip to content

orthogonal_bitmap_expr_calculate_count方法在对1位数字做过滤的时候存在问题 #1840

Open
@lalalaerhuo

Description

Path:/zh-CN/docs/2.0/sql-manual/sql-functions/bitmap-functions/orthogonal-bitmap-expr-calculate-count

我有一张订单表
用户ID字段 paid,渠道字段 area_channel 在使用这个函数的时候每次的结果都不同
select orthogonal_bitmap_expr_calculate_count(to_bitmap(paid) , area_channel, '4&5') as tCount
from dwd_trade_order_base dtob where ct_year =2023

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions