hive 当然是非常强大啦,先提取一个SKU的对应关系来分析销售员的情况。
select
item_sku_id ,
barndname_cn ,
sku_status_cd ,
item_first_cate_cd ,
item_first_cate_name ,
item_second_cate_cd ,
item_second_cate_name,
item_third_cate_cd ,
item_third_cate_name ,
saler_erp_acct ,
sale_staf_name ,
sku_name
from
gdm.gdm_m03_item_sku_da
where
dt = '2014-08-04'
and length(item_sku_id) <= 8
and item_first_cate_name <>'图书'
and item_first_cate_name <>'数字音乐'
and item_first_cate_name <>'电子书'
and item_first_cate_name <>'电脑、办公'
and item_first_cate_name <>'礼品箱包'
and item_first_cate_name <>'有声读物'
and item_first_cate_name <>'运动户外'
and item_first_cate_name <>'珠宝首饰'
and item_first_cate_name <>'汽车用品'
select
item_sku_id ,
barndname_cn ,
sku_status_cd ,
item_first_cate_cd ,
item_first_cate_name ,
item_second_cate_cd ,
item_second_cate_name,
item_third_cate_cd ,
item_third_cate_name ,
saler_erp_acct ,
sale_staf_name ,
sku_name
from
gdm.gdm_m03_item_sku_da
where
dt = '2014-08-05'
and ( item_first_cate_name = '手机'
or item_first_cate_name = '数码')
and length( item_sku_id)<=8
评论