建表语句:
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用一块独立的磁盘。