京东JData算法大赛-高潜用户购买意向预测

1
2
3
4
5
6
7
SELECT
    c.sku_id, c.comment_num, c.bad_comment_rate
FROM
    jdata.action a,
    jdata.comment c
WHERE
    a.type = 4 AND a.sku_id = c.sku_id;

1
2
ALTER TABLE `jdata`.`action`
ADD INDEX `action_pid` (`sku_id` ASC);