建表语句:
create table asset_data(
asset_code varchar(20),
data_time datetime not null,
data_type tinyint not null,
device_code varchar(20) not null,
raw_time datetime not null,
system_time datetime not null default current_timestamp,
content variant not null
) unique key(asset_code, data_time)
auto partition by range date_trunc(data_time, 'month')()
distributed by hash(asset_code) buckets 8
properties(
"replication_allocation" = "tag.location.default: 1"
);
插入80多万数据后,查询报错,同时3个be挂了。doris集群总共1个fe,8个be,部署在一台48核,512GB的服务器上,每个be用一块独立的磁盘。

