Clickhouse: [Question] Manually update clickhouse dictionary
Hi.
Does it possible to update clickhouse external dictionary manually (forcibly) instead of scheduled
Or is there some info about the last dictionary update (some exact time) ?
comp-dictionary
igor-sh8
👍1
All 3 comments
Since v1.1.54289 you can use SYSTEM RELOAD DICTIONARY <dict_name> query or SYSTEM RELOAD DICTIONARIES query.
Last dictionary update is stored in system.dictionaries table.
millin
on 14 Mar 2018
❤3
👍3
Great. It works for me. Thanks.
igor-sh8
on 15 Mar 2018
What to do if SYSTEM RELOAD DICTIONARIES query throws
Received from localhost:9000. DB::Exception: Poco::Exception. Code: 1000, e.code() = 0, e.displayText() = Exception: Connections to all replicas failed:
This error.
Naveen071110
on 28 Apr 2020
Was this page helpful?
0 / 5 - 0 ratings
Related issues
goranc
·
3Comments
greenx
·
3Comments
jangorecki
·
3Comments
SaltTan
·
3Comments
bseng
·
3Comments
Most helpful comment
Since v1.1.54289 you can use
SYSTEM RELOAD DICTIONARY <dict_name>query orSYSTEM RELOAD DICTIONARIESquery.Last dictionary update is stored in
system.dictionariestable.