Hi everyone, We have a shared-data cluster (3xFE + 3xCN) and found out, that adding columns to the table is extremely slow. For example, I created a simple table:

CREATE TABLE `test_table` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT "",
) ENGINE=OLAP 
PRIMARY KEY(`id`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`id`)
PROPERTIES (
"compression" = "LZ4",
"datacache.enable" = "true",
"enable_async_write_back" = "false",
"enable_persistent_index" = "true",
"persistent_index_type" = "LOCAL",
"replication_num" = "3",
"storage_volume" = "adls2"
);

Then try to add a column:

alter table test_table add column Doc_ID bigint;

And it may take up to 20 seconds. We found out, that it comes from the fact that Starrocks tries to list/check persistent index directories in ADLS2 for each tablet and gets a lot of 404 errors. We tried to experiment with settings (e.g. persistent_index_type), but it doesn't seem to work. Any suggestions? We use Starrocks 3.5.6-3ba6b8d