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

[20.3] Dictionary DDL clickhouse table with dot doesn't work as dict source #15469

Closed
UnamedRus opened this issue Sep 30, 2020 · 1 comment
Closed
Assignees
Labels
bug Confirmed user-visible misbehaviour in official release st-fixed

Comments

@UnamedRus
Copy link
Contributor

How to reproduce
Clickhouse version 20.3.19.4

CREATE TABLE `test.txt`
(
    `key1` UInt32,
    `key2` UInt32,
    `value` String
)
ENGINE = Memory()

CREATE DICTIONARY test_dict
(
    `key1` UInt32,
    `key2` UInt32,
    `value` String
)
PRIMARY KEY key1, key2
SOURCE(CLICKHOUSE(HOST 'localhost' PORT 9000 USER 'default' TABLE `test.txt` PASSWORD '' DB 'default'))
LIFETIME(MIN 1 MAX 3600)
LAYOUT(COMPLEX_KEY_HASHED())

SYSTEM RELOAD DICTIONARY default.test_dict
Received exception from server (version 20.3.19):
Code: 49. DB::Exception: Received from localhost:9003. DB::Exception: Logical error: more than two components in table expression.

Additional context
It works in 20.4 and later versions.
Probably related pull?

@UnamedRus UnamedRus added the bug Confirmed user-visible misbehaviour in official release label Sep 30, 2020
@alexey-milovidov
Copy link
Member

Yes, it works perfectly in all recent releases.

@alexey-milovidov alexey-milovidov self-assigned this Mar 3, 2021
alexey-milovidov added a commit that referenced this issue Mar 3, 2021
alexey-milovidov added a commit that referenced this issue Mar 5, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Confirmed user-visible misbehaviour in official release st-fixed
Projects
None yet
Development

No branches or pull requests

3 participants