Temporary stopping automatic dictionary updates about clickhouse HOT 3 CLOSED

As far as I know, there is no way to stop a dictionary reload.

Maybe you could avoid having partial data in the source table. For example, instead of truncating + insert, you could create a temporal table with the same schema, insert into that table, then EXCHANGE it with the old one and drop the temporal table (that now has the old data). Would that help in your situation?

from clickhouse.

what should be done

Awful hack, but you can add WHERE throwIf((SELECT * FROM status FINAL) = 'Updating' ) in dictionary source definition

So, you will have additional status table, which you can use as lock for your dictionary updates. (to explicitly trigger exception which prevent reload of dictionary)

But, it's not better than doing EXCHANGE TABLES and staging tables

from clickhouse.

Thanks to the both of you. I think I will go for the table exchange, but I like your style, @UnamedRus 😆

from clickhouse.