Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

How to avoid remote clickhouse query error? #24

Open
AlexAdministrator opened this issue Dec 25, 2024 · 0 comments
Open

How to avoid remote clickhouse query error? #24

AlexAdministrator opened this issue Dec 25, 2024 · 0 comments

Comments

@AlexAdministrator
Copy link

I use remoteSecure function to query remote table from one clickhouse server to another. We have two enviroments PROD and DEV from where remote query are sended. PROD clickhouse has version 23.7.3.14 , DEV has version 24.5.3.5 , remote server has version 24.8.8.17. Remote tables has nested columns so I can access it using dot notation. Name of nested column is event_params.key. When I query remote table from PROD enviroment I get result with no issues but when I do the same on DEV I get error

DB::Exception: There's no column '__table1.event_params.key' in table '__table1': While processing __table1.event_params.key AS event_params.key. (UNKNOWN_IDENTIFIER)

I have no tables with nane "__table1" , looks like this is some system metadata name because of I use remoteSecure function. I can retrieve data using order number of element of list like following event_params[1] but this is not what I want , I need to get data using dot notation and nested column name. What can be a issue ? Maybe some settings should be turned on ? Pls help.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant