1. Machine Learning with ClickHouseLinear regression in ClickHouse Is implemented as Aggregate Function Means you can train multiple models in single SQL query SELECT cab_type, simpleLinearRegression(trip_distance, total_amount) FROM ─┘ 18 / 62 Linear regression result 19 / 62 The influence of time 20 / 62 Let’s train more models! SELECT toYear(pickup_datetime) AS y, simpleLinearRegression(trip_distance, total_amount) FROM 99253781758988) │ └──────┴─────────────────────────────────────────────────────┘ 21 / 62 Let’s train more models! 22 / 62 Linear regression in ClickHouse simpleLinearRegression supports only single factor ›0 码力 | 64 页 | 1.38 MB | 1 年前3- 0. Machine Learning with ClickHouse Linear regression in ClickHouse Is implemented as Aggregate Function Means you can train multiple models in single SQL query SELECT cab_type, simpleLinearRegression(trip_distance, total_amount) FROM ─┘ 18 / 62 Linear regression result 19 / 62 The influence of time 20 / 62 Let’s train more models! SELECT toYear(pickup_datetime) AS y, simpleLinearRegression(trip_distance, total_amount) FROM 99253781758988) │ └──────┴─────────────────────────────────────────────────────┘ 21 / 62 Let’s train more models! 22 / 62 Linear regression in ClickHouse simpleLinearRegression supports only single factor ›0 码力 | 64 页 | 1.38 MB | 1 年前3
共 2 条
- 1