Skip to content

Recommend customers not use cache layouts on dictionaries in CHC #5993

@jackborthwickclickhouse

Description

@jackborthwickclickhouse

Since we use autoscaling in cloud, nodes can be replaced at any moment and if a node is replaced the dictionary is wiped clean.  This can result in ingestion issues if they are using a dictionary to denormalize data in an MV.  tl;dr only use complex key hashed or another dictionary lay out that prepopulates dictionaries, instead of populating them via caching mechanisms.  See https://clickhouse.com/docs/dictionary/best-practices for more info on choosing dicationary cache layouts.

Metadata

Metadata

Assignees

Type

No type
No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions