clickhouse sql优化,减少查询次数提升效率
业务场景:计算sales/count/sku的值、同比、环比
用开窗函数neighbor计算yoy同比和chain环比
//原本计算同比和环比需要使用三条sql聚合后相除
SELECT toStartOfYear(toDate('2020-05-01')) AS date, ROUND(SUM(sales), 2) AS sales, SUM(count) AS count, COUNT(DISTINCT product_id) AS sku
FROM mars_rc_roma_wide
.
原创
2020-07-02 11:27:16 ·
2532 阅读 ·
0 评论