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?
Here is how I use it in my update query:
ALTER TABLE table1 UPDATE column2 = func1(column1) WHERE 1;
And here is what I get:
Code: 46. DB::Exception: Received from localhost:9000. DB::Exception: Unknown function func1: While processing func1(column1). (UNKNOWN_FUNCTION)
New contributor
Ali Habibi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.