Regarding the issue of ClickHouse encountering an out-of-memory problem when querying array fields. about clickhouse HOT 3 OPEN

How big are arrays?

What if set max_block_size = 1000

from clickhouse.

Yes it's hard to figure out what consumed memory without at least knowing the schema of the table and the sizes of arrays in individual rows, because if one (or several) rows have huge array they will have to be fully read and uncompressed into memory when processing the query.
Also you can notice that progress says: 359.48 thousand rows, 17.11 GB

from clickhouse.

I increased the memory and then performed a length-based sorting query, which I think is because the array length is too long. Is there an appropriate range for the length of this array? Does this mean

record{
   id               Int64 comment 'ID',
   org_log_ids      Array(String) default [],
   datasource       String
  }

When my statement is: "SELECT id, org_log_ids, datasource FROM record LIMIT 10;", does the array field (org_log_ids) undergo aggregation, leading to excessive memory usage?

from clickhouse.