1. Machine Learning with ClickHousebin') 57 / 62 Apply CatBoost model in ClickHouse SELECT -- specify cat features at the end modelEvaluate('trip_price', trip_distance, toYear(pickup_datetime) - 2006, cab_type) AS prediction, total_amount / 62 Apply CatBoost model in ClickHouse SELECT sqrt(avg(diff * diff)) AS MSE FROM ( SELECT modelEvaluate('trip_price', ...) - total_amount AS diff FROM trips WHERE <...> ) ┌────────────────MSE─┐ │0 码力 | 64 页 | 1.38 MB | 1 年前3- 0. Machine Learning with ClickHouse bin') 57 / 62 Apply CatBoost model in ClickHouse SELECT -- specify cat features at the end modelEvaluate('trip_price', trip_distance, toYear(pickup_datetime) - 2006, cab_type) AS prediction, total_amount / 62 Apply CatBoost model in ClickHouse SELECT sqrt(avg(diff * diff)) AS MSE FROM ( SELECT modelEvaluate('trip_price', ...) - total_amount AS diff FROM trips WHERE <...> ) ┌────────────────MSE─┐ │0 码力 | 64 页 | 1.38 MB | 1 年前3
共 2 条
- 1