doris 2.1.6 自动分区创建不了

Viewed 21

doris从2.1.0升级到2.1.6以后,有如下建表语句

create table test3(
id bigint,
create_time datetime not null,
name varchar(150),
age int,
high double,
amount decimal(10,2),
check_times smallint,
sex char,
handle_date date,
update_time datetime,
deleted tinyint
)ENGINE=OLAP
UNIQUE KEY(`id`,`create_time`) 
AUTO PARTITION BY RANGE (date_trunc(`create_time`, 'month'))
(
)
DISTRIBUTED BY HASH(`id`) BUCKETS AUTO
PROPERTIES (
"replication_num" = "1",
"enable_unique_key_merge_on_write" = "true"
);

但是在执行以下语句:
INSERT into test3 values(1,cast('2024-07-26 15:44:21' as datetime),'zhangsan',18,185.2,23.5,1,'M',cast('2024-07-01' as date),cast('2024-07-01 15:44:21' as datetime),0);
报错:
errCode = 2, detailMessage = (192.0.1.145)[RUNTIME_ERROR]TStatus: create partition failed. error:errCode = 2, detailMessage = Failed to find enough backend, please check the replication num,replication tag and storage medium and avail capacity of backends.
Create failed replications:
replication tag: {"location" : "default"}, replication num: 1, storage medium: HDD
backends 如下:
image.png
请问是什么原因导致的?

2、另外,请问下,如果添加3个be,其中2个be的可用内存有20G,而其中1个be的可用内存只有2.5G,这样子会影响查询速度吗?如果有一个查询被丢到了2.5G这个节点去执行,会不会有问题?

1 Answers
  1. 我这边2.1.6 测试是正常的,这个比较奇怪。你们be.conf中存储目录是否设置SSD的tag,看下be.conf中的storage_path
    image.png

  2. 会影响,会出现短板效应,导致查询无法进行