3 ms·
Clickhouse for storage, What about deletes? And all that fussy transaction stuff? It seems strange to make that particular recommendation (for apparently all
by vanusa 5y ago
Clickhouse for storage,
What about deletes? And all that fussy transaction stuff?
It seems strange to make that particular recommendation (for apparently all their storage needs) on the basis of the information provided.
- edmundsauto 5y agoHmm, I have only ever worked in data warehouses that don't support updates - I think that is a core attribute of a DW. Warehouses are (IME) considered separate from production, with one major difference being that DWs don't need to support updates or transactions. Deletes are possible in Clickhouse[0] [0] - https://clickhouse.com/docs/en/sql-reference/statements/alter/delete/ https://clickhouse.com/docs/en/sql-reference/statements/alte...
- vanusa 5y agoYes, they're possible -- but it's high-expense operation, intended to be used "infrequently". Which may or may not impact their use case. Just something to be aware of.