Dictionary with postgres source fails #23958
Description
Hi,
I created a dictionary with a postgres source and creation works fine. But when I try to query it, it says that the source table in postgres doesn't exist.
SQL Error [156]: ClickHouse exception, code: 156, host: my.clickhouse.server, port: 8123; Code: 156, e.displayText() = DB::Exception: Failed to load dictionary 'chdatabase.dictionary_table': std::exception. Code: 1001, type: pqxx::undefined_table, e.what() = ERROR: relation "pgschema.pgtable" does not exist
LINE 1: ...e", "iso3_code", "continent_id", "adjective" FROM "analytics...
^
, (version 21.3.9.83 (official build))
The dictionary is configured using a DDL statement:
CREATE DICTIONARY chdatabase.dictionary_table (
id Int32,
name String,
iso2_code String,
iso3_code String
)
PRIMARY KEY id
SOURCE(POSTGRESQL(
port 5432
host 'postgreshost'
user 'postgresuser'
password 'postgrespassword'
db 'pgdatabase'
table 'pgschema.pgtable'
)
)
LIFETIME(MIN 300 MAX 360)
LAYOUT(COMPLEX_KEY_HASHED());
I've confirmed that the user defined in in the postgresql source has access to the table and can query it.