v.22.9Improvement

CatBoost Model Evaluation Migration to clickhouse-library-bridge

Official CH changelog text
For security and stability reasons, CatBoost models are no longer evaluated within the ClickHouse server. Instead, the evaluation is now done in the clickhouse-library-bridge, a separate process that loads the catboost library and communicates with the server process via HTTP. Function modelEvaluate() was replaced by catboostEvaluate(). #40897 (Robert Schulze). #39629 (Robert Schulze).
CatBoost model evaluation in ClickHouse was moved out of the server process into a separate external process called clickhouse-library-bridge. The previous modelEvaluate() function is replaced by catboostEvaluate() to enhance security and stability.

Why it matters

Evaluating CatBoost models inside the ClickHouse server posed security and stability risks. By offloading the evaluation to the clickhouse-library-bridge, a separate process that loads the CatBoost library and communicates via HTTP, the system becomes more robust and secure, isolating the model evaluation from the main server process.

How to use it

Instead of using modelEvaluate(), users should now use the catboostEvaluate() function in their SQL queries. Ensure the clickhouse-library-bridge process is running and properly configured to handle CatBoost model evaluations via HTTP communication with the ClickHouse server.

Related resources

PreviousNext