Slide 66
Slide 66 text
©2018 Wantedly, Inc.
CREATE MODEL
`ml_models.push_open`
OPTIONS
(model_type='logistic_reg') AS
SELECT
IF(open IS NULL, 0, 1) AS label,
weekly_open_count,
timeline_show_count,
scan_count,
...
FROM
`people.ironna_data*`
WHERE
...
# ೖྗσʔλΛग़ྗ͢ΔΫΤϦهड़
# label ͱ͍͏໊લͷྻΛͯΔ
# (ΧϥϜ໊ΦϓγϣϯͰࢦఆՄೳ)
SELECT
IF(open IS NULL, 0, 1) AS label,
weekly_open_count,
timeline_show_count,
scan_count,
...
FROM
`people.ironna_data*`
WHERE
...
MODEL ͷ࡞
MODEL ͷ࡞