SELECT
    arrayJoin(cust_flags) AS custs, 
    sum(__sourcerows) AS total_events
FROM sync_local
WHERE ((__timestamp >= '2025-05-15 02:00:00') AND (__timestamp < '2025-05-22 02:00:00')) AND (arrayJoin(cust_flags) IN ('<>')) AND (dictGetOrDefault('tags', 'site_name', p_id, '') IN ('<>'))
GROUP BY 1
ORDER BY 1 DESC
LIMIT 5000

Received exception from server (version 24.12.6):
Code: 10. DB::Exception: Received from :9440. DB::Exception: Not found column cust_flags in block: while executing 'INPUT : 1 -> cust_flags Array(String) : 5'. (NOT_FOUND_COLUMN_IN_BLOCK)

CREATE TABLE default.sync_local
(
    `__partition` LowCardinality(String),
    `__sourcerows` UInt64,
    `__timestamp` DateTime,
    `p_id` LowCardinality(String),
    `cust_flags` Array(String),
    INDEX idx_set_p_id p_id TYPE set(100) GRANULARITY 1,
    INDEX idx_minmax_cust_flags cust_flags TYPE minmax GRANULARITY 2,
    PROJECTION sum_events__projection
    (
        SELECT __timestamp, p_id, sum(__sourcerows)
        GROUP BY 1, 2
    )
)
ENGINE = ReplicatedMergeTree('/clickhouse/tables/{uuid}/{shard}', '{replica}')
PARTITION BY __partition
ORDER BY (__timestamp, p_id)
SETTINGS index_granularity = 8192