20190715工作进展

motivation：增量式业务，从看视频这一行为中引起用户的购买欲望

1. 视频推荐的想法：
   （1）内容不够吸引人
   （2）商品的展示视频怎么才能吸引人，这里边技术可以做什么？
   小红书的视频内容吸引人，但是商品卖的不好，阿里的视频非常无聊，但是卖的好。。。

2. 去重并得到每一条的出现次数：
   select user_id,count(*) as np from user group by user_id order by np desc limit 10;

select query,count(*) as np from hs_tmp_30 group by query order by np desc limit 10;

hs_tmp_19

create table hs_tmp_21 as
select b.query, a.* from
(select item_id, cate_id, cate_name from tbcdm.dim_tb_itm where ds=max_pt('tbcdm.dim_tb_itm'))a join (select query, item_id from hs_tmp_19)b on a.item_id == b.item_id;

create table hs_tmp_31 as select query, cate_id, cate_name, count(*) as freq from hs_tmp_21 group by query, cate_id, cate_name order by freq desc;

create table hs_leaf_class_for_query_2 as
select distinct a.id as id, a.query_origin as query, b.cate_id, b.cate_name, b.freq from
((select id, query_origin, query from hs_jingyan_query_related_top_query_3)a join (select query, cate_id, cate_name, freq from hs_tmp_31)b on a.query_origin == b.query);