Hi all, we have faced the following issue where running ANALYZE TABLE on StarRocks 3.5.2:

insert statistic job failed due to too many failed tasks: 1/2, the last failure is com.starrocks.common.DdlException: Getting analyzing error. Detail message: Unknown column 'collection_size' in 'column_statistics'.

Has anyone faced the same issue and knows how to solve it?

Hello, did you recently do an upgrade on your cluster? The collection_size field under column_statistics was just added on 3.5.x. Can you please check the version on all of the running nodes (FEs and BEs)

@Robert Raharjo Yes, firstly we have upgraded the cluster to 3.5.2, and after that the cluster has been downgraded to 3.4.1. And a few days later we have upgraded the cluster to 3.5.2 again.

Can you try dropping the statistic for your table(s)

drop stats <table>;

and rerun your analyze table

@Robert Raharjo Unfortunately, we have the same issue after dropping the statistics:

insert statistic job failed due to too many failed tasks: 1/1, the last failure is com.starrocks.common.DdlException: Getting analyzing error. Detail message: Unknown column 'collection_size' in 'column_statistics'.

Can you try disable the analyze job

admin set frontend config("enable_collect_full_statistic" = "false")

and recreate the

_statistics_

database.

drop database _statistics_;
create analyze full all;