StarRocks / starrocks

The world's fastest open query engine for sub-second analytics both on and off the data lakehouse. With the flexibility to support nearly any scenario, StarRocks provides best-in-class performance for multi-dimensional analytics, real-time analytics, and ad-hoc queries. A Linux Foundation project.
https://starrocks.io
Apache License 2.0
9.01k stars 1.81k forks source link

bitmap_agg error ERROR 1064 (HY000): No matching function with signature: bitmap_agg(bigint(20)). #27760

Closed peter4431 closed 1 year ago

peter4431 commented 1 year ago

Steps to reproduce the behavior (Required)

  1. CREATE TABLE
    CREATE TABLE IF NOT EXISTS event (
    `user_id` bigint not null
    ) ENGINE=OLAP 
    DUPLICATE KEY(`user_id`) 
    DISTRIBUTED BY HASH (`user_id`) 
    PROPERTIES ("storage_type" = "column", "replication_num" = "1");
  2. INSERT
    insert into event values (1);
  3. SELECT
    select bitmap_agg(`user_id`) from event;

Expected behavior (Required)

Expect bitmap data

Real behavior (Required)

ERROR 1064 (HY000): No matching function with signature: bitmap_agg(bigint(20)).

StarRocks version (Required)

2.5.4

Docker Compose And SQL

docker-compose.yaml

version: '3.7'
services:
  starrocks:
    image: starrocks/allin1-ubuntu:2.5.4
    restart: always

sql

CREATE TABLE IF NOT EXISTS event (`user_id` bigint not null) ENGINE=OLAP DUPLICATE KEY(`user_id`) DISTRIBUTED BY HASH (`user_id`) PROPERTIES ("storage_type" = "column", "replication_num" = "1");
insert into event values (1);

select bitmap_agg(`user_id`) from event;
imay commented 1 year ago

Could you upgrade the all-in-1 to the latest version?

peter4431 commented 1 year ago

The latest version is correct.

ltylty commented 1 year ago

I use starrocks 2.5.6 version, and trigger the same issue. is bug in the version? which version fix this bug?