Lightweight UPDATE support #84162
Description
👋
Company or project name
Elixir ClickHouse client https://github.com/plausible/ecto_ch
Question
I'm trying to add Lightweight UPDATEs support in an Elixir client (plausible/ecto_ch#234) and can't seem to figure out how to enable them. Maybe the released Docker images don't yet have lightweight updates?
I get errors like this:
Code: 78. DB::Exception: Unknown type of query: UpdateQuery__users. (UNKNOWN_TYPE_OF_QUERY) (version 25.6.4.12 (official build))
And inside that container:
:) create table hits (title String, date Date) engine MergeTree order by tuple();
-- Ok.
:) set allow_experimental_lightweight_update = 1;
-- Ok.
:) update hits set title = 'updated' where date = today();
-- Received exception from server (version 25.6.4):
-- Code: 78. DB::Exception: Received from localhost:9000. DB::Exception: Unknown type of query: UpdateQuery__hits. (UNKNOWN_TYPE_OF_QUERY)