23 -> 24 __table1.<column> query issue

JakeCooper commented 3 months ago

Company or project name Railway

Describe the issue When upgrading from Clickhouse 23 to Clickhouse 24, we've found that our queries, which worked on 23, now result in the following error:

Error: Not found column project_id in block. There are only columns: __table1.timestamp, __table1.project_id, __table1.environment_id, __table1.service_id, __table1.deployment_id, __table1.deployment_instance_id, __table1.snapshot_id, __table1.severity, __table1.message

Or sometimes the "opposite"

Error: Not found column __table1.timestamp in block. There are only columns: deployment_id, environment_id, snapshot_id, project_id, service_id, deployment_instance_id, message, severity, timestamp

How to reproduce

Which ClickHouse server versions are incompatible: 24
Which interface to use, if matters: clickhouse js client
Non-default settings, if any
CREATE TABLE statements for all tables involved
Sample data for all these tables, use clickhouse-obfuscator if necessary
Queries to run that lead to unexpected result

Error message and/or stacktrace See above

Additional context Add any other context about the problem here.

JakeCooper commented 3 months ago

It appears this might actually happen going from 24.2 -> 24.3. Will circle back

den-crane commented 3 months ago

try

cat /etc/clickhouse-server/users.d/allow_experimental_analyzer.xml
<?xml version="1.0" ?>
<clickhouse>
    <profiles>
        <default>
            <allow_experimental_analyzer>0</allow_experimental_analyzer>
        </default>
    </profiles>
</clickhouse>

https://github.com/ClickHouse/ClickHouse/issues?q=is%3Aissue+is%3Aopen+%22Not+found+column+%22+label%3Aanalyzer

Algunenano commented 3 months ago

Please provide a minimal reproducer, with the create statements and the query that reproduces it (obfuscated ones are ok too).

KochetovNicolai commented 2 months ago

Probably it is connected with different versions. https://github.com/ClickHouse/ClickHouse/pull/65777 should address this

Tiaonmmn commented 2 months ago

We got this error too. Probably you are using different ClickHouse versions in a cluster.

ClickHouse / ClickHouse

23 -> 24 __table1.<column> query issue #65796