Error with enable new analyzer: "Not found column __table1.name in block" about clickhouse HOT 7 CLOSED

You must setup the same config in both servers or explicitly enable the setting (via config or query) in the initiator.

from clickhouse.

Please provide a reproducer, version used, etc. This works fine:

SELECT
    t.name AS name,
    t.database AS schema,
    multiIf(engine IN ('MaterializedView', 'View'), 'view', engine = 'Dictionary', 'dictionary', 'table') AS type,
    db.engine AS db_engine,
    (t.engine LIKE 'Replicated%') OR (t.engine = 'View') AS is_on_cluster
FROM clusterAllReplicas(test_cluster_two_shards, system.tables) AS t
INNER JOIN system.databases AS db ON t.database = db.name
WHERE schema = 'mm_automation'
GROUP BY
    name,
    schema,
    type,
    db_engine,
    t.engine

from clickhouse.

Please provide a reproducer, version used, etc. This works fine:

SELECT
    t.name AS name,
    t.database AS schema,
    multiIf(engine IN ('MaterializedView', 'View'), 'view', engine = 'Dictionary', 'dictionary', 'table') AS type,
    db.engine AS db_engine,
    (t.engine LIKE 'Replicated%') OR (t.engine = 'View') AS is_on_cluster
FROM clusterAllReplicas(test_cluster_two_shards, system.tables) AS t
INNER JOIN system.databases AS db ON t.database = db.name
WHERE schema = 'mm_automation'
GROUP BY
    name,
    schema,
    type,
    db_engine,
    t.engine

Strange behaviour:

• if settings allow_experimental_analyzer explicitly set in users.xml to 1 or via set query its work.

select * from system.settings where name = 'allow_experimental_analyzer';

name,value,changed
allow_experimental_analyzer,1,1

but if its not changed and default config, its throw error
select * from system.settings where name = 'allow_experimental_analyzer';

name,value,changed
allow_experimental_analyzer,1,0

from clickhouse.

Are you using a cluster where the replicas have different CH versions and different settings for allow_experimental_analyzer? If it's not set, then it must be the same in all replicas

from clickhouse.

Same ch version, and yes not work in this case:

from clickhouse.

with same default config in both servers its work.

Seems problem only when its not the same on all servers.

from clickhouse.

You must setup the same config in both servers or explicitly enable the setting (via config or query) in the initiator.

Its okey, but maybe should add more friendly error, for this case. Its not obvious at all, and its can be easy to forgot to change and sync it on all servers in first time.

from clickhouse.