clickhouse 条件语句内decimal除0报错处理
clickhouse decimal类型除0异常最近使用clickhouse做一个报表页面出现一个问题。SELECT sum( impressions) impressions, sum( clicks ) clicks, if(impressions>0,clicks/impressions,0) clickRate, sum( cost ) cost, if(clicks>0, cost/clicks,0) clickCostFROM a
原创
2021-03-03 17:38:25 ·
3858 阅读 ·
1 评论