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 如下:
请问是什么原因导致的?
2、另外,请问下,如果添加3个be,其中2个be的可用内存有20G,而其中1个be的可用内存只有2.5G,这样子会影响查询速度吗?如果有一个查询被丢到了2.5G这个节点去执行,会不会有问题?
3、请问只有2个be,然后副本数指定为2,会不会有什么脑裂问题?