= '订单类型2', gmv, 0)) AS bi_metric1
, SUM(if(order_type = '订单类型3', gmv, 0)) AS bi_metric2...) mid_dataset
可以看到原本sum(gmv)因为“订单类型”的多种不同取值的原因分割成了多个select if语句。...= '订单类型3', gmv, 0)) AS bi_metric6
, SUM(if(order_type = '订单类型4', gmv, 0)) AS bi_metric7
FROM...图3.4 带聚合运算的计算字段
当一个聚合类型的计算字段与订单类型列维度共存的时候,生成的SQL为:
SELECT try( sum(if(order_type = '订单类型3', gmv , 0))...= '订单类型2', gmv , 0)) ) AS bi_metric2, try( sum(if(order_type = '订单类型1', gmv , 0)) ) AS bi_metric3
FROM