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

Field filter unable to read column name when using MaterializedPostgreSQL with table_list #83

Open
ghost opened this issue Jan 28, 2022 · 0 comments
Labels
bug Something isn't working

Comments

@ghost
Copy link

ghost commented Jan 28, 2022

Field filter doesnt work when using MaterializedPostgreSQL Engine with materialized_postgresql_tables_list.
Example query for creating database:-
CREATE DATABASE db_name ENGINE = MaterializedPostgreSQL('host:5432', 'db_nm, 'user', 'pass') SETTINGS materialized_postgresql_tables_list = 'schema_name.table_name', materialized_postgresql_tables_list_with_schema = 1;

Basically this method is used to create replication of data(specified tables) from postgres to clickhouse. In this specific case table name also includes schema name. Table name in clickhouse is like:- "schema_name_in_postgres.table_name_in_postgres"

Example query for accessing data in table in clickhouse:- select * from db_name."schema_name.table_name"

Field filter is using wrong table name due to which its throwing error column name doesn't exist. It should use the syntax db_name."schema_name.table_name" to access column but its using db_name.schema_name.table_name. Quotes is missing in syntax due to which its throwing error column name db_name.schema_name.table_name doesn't exist.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant