I’m storing items that are tied to a time of day associated with an “impact”.

I’m storing items that are tied to a time of day associated with an “impact”.

i have a table tb(b Object(json)). and i will insert dynamic json into a. such a {“c”: 0}, {“d”: 1}, so i want to query: select payload.d from tb. i got:

I have a WindowFunnel query to analyze event sequence:

I have a WindowFunnel query to analyze event sequence:

I have 2 CTE’s with the 2 columns each. There are NO null values in either CTE.

We have a ClickHouse server (version 24.4.1.2088) running inside a Docker container alongside a Django web server on an 8GB machine.

I have a Materialized View that joins with tables replicated from PostgreSQL:

I created external tables in clickhouse that pull up from postgres, but 1 of the tables gives an error type: pqxx::undefined_column, e.what()= ERROR: column “date” does not exist

I created a user defined function in ClickHouse and I can use it in my queries, it works fine, but I cannot use it in updating a column.
Is there a config I am missing? Shouldn’t it work for update too?