5 . 二、数据发展史
2.2 例子
select a.brand_id ,a.brand_spu_id , Cube 数:27
COALESCE(SUM(total_sale_money_kpi),0) as total_sale_money_kpi , 数据量：1TB
COALESCE(SUM(total_sale_count_kpi),0) as total_sale_count_kpi , 最大 Cube：120G
COALESCE(SUM(total_sale_money_suggest_kpi),0) as total_sale_money_suggest_kpi ,
COALESCE(SUM(short_sale_count),0) as short_sale_count , 最大 Cube 源数据行数：20亿
COALESCE(SUM(total_sale_money_refund),0) as total_sale_money_refund ,
COALESCE(SUM(total_sale_money),0) as total_sale_money , 例子：查询品牌某款商品
COALESCE(SUM(total_sale_count_kpi_offline),0) as total_sale_count_kpi_offline ,
COALESCE(SUM(total_sale_count),0) as total_sale_count ,
一段时间内有销售或者库存
COALESCE(SUM(product_entry_stock_count),0) as product_entry_stock_count , 不为0的各种指标
COALESCE(SUM(distribution_entry_stock_count),0) as distribution_entry_stock_count ,
(CASE WHEN SUM(total_sale_money_suggest_kpi) = 0
THEN 0 ELSE (sum(total_sale_money_kpi)*1.0/SUM(total_sale_money_suggest_kpi)) END)
平均响应时长
as discount_rate MySQL --
from view_dm_storage_sku_sale_stock_dm_v0 a inner join dim_date d on
a.start_day=d.date_id Phoenix 30-50s
WHERE 1=1 and a.brand_id = 10170 and a.start_day >= '2018-10-20' and a.start_day <=
'2018-10-21' Kylin 1s
group by a.brand_id ,a.brand_spu_id
having ( sum(total_sale_count_kpi) !=0 or sum(total_sale_money_kpi) !=0 or
Kyligence 1s
sum(TERMINAL_STOCK_COUNT)!=0 ) Enterprise
order by total_sale_money_kpi DESC ,a.brand_spu_id desc LIMIT 10 offset 110
https://www.dianjia.io/
热门城市
