为了更快的定位您的问题,请提供以下信息,谢谢
【详述】问题详细描述
CREATE TABLE test.`table_1` (
`id` bigint(20) NULL,
`date1` date NULL,
`col1` varchar(65533) NULL,
`time1` datetime NULL
) ENGINE=OLAP
DUPLICATE KEY(`id`, `date1`, `col1`)
COMMENT "日期测试4"
DISTRIBUTED BY HASH(`id`) BUCKETS 1
PROPERTIES (
"replication_num" = "1",
"in_memory" = "false",
"storage_format" = "DEFAULT",
"enable_persistent_index" = "false",
"compression" = "LZ4"
);
insert into test.table_1 values (1,'2024-05-16','c1',null);
insert into test.table_1 values (2,'2024-05-16','c2',null);
insert into test.table_1 values (3,'2024-05-16','c3',null);
insert into test.table_1 values (4,'2024-05-16','c4',null);
insert into test.table_1 values (5,'2024-05-16','c5',null);
insert into test.table_1 values (6,'2024-05-16','c6',null);
insert into test.table_1 values (7,'2024-05-17','b1',null);
insert into test.table_1 values (8,'2024-05-17','b2',null);
insert into test.table_1 values (9,'2024-05-17','b3',null);
select
date1,
count(col1) cn
from
(
select
date1,
col1,
time1,
row_number() over(partition by col1) as rn
from test.table_1) t1
where t1.rn=1
group by date1
期望结果是:
|date1|cn|
|2024-05-16|6|
|2024-05-16|3|
偶尔得到错误结果
|date1|cn|
|2024-05-16|2|
|2024-05-16|1|
|2024-05-16|2|
|2024-05-16|1|
|2024-05-17|1|
|2024-05-17|2|
【背景】做过哪些操作?
偶发错误,时而结果正确,时而结果错误
发现错误时,没有dict_decode。 正确是是有dict_decode的。
所以关闭了dict_decode,就必现了
curl -X POST 'http://xx.xx.xx.xx:8030/api/global_dict/table/enable?db_name=test&table_name=table_1&enable=true' \
-H 'Authorization: .....' \
-H 'Cookie: .....'
【业务影响】查询结果错误
【是否存算分离】否
【StarRocks版本】2.5.4
【集群规模】1fe+1be
【机器信息】CPU虚拟核/内存/网卡,例如:48C/64G/万兆
【联系方式】541166058@qq.com
【附件】