spark 语法下，coalesce和grouping sets一起用会直接报错

[kyo21st]

解析如下spark sql会直接报错
INSERT OVERWRITE
TABLE vup.ads_vendor_summary PARTITION (dt = '${dt}')
--数据日期当天下单订单轻度汇总数据
SELECT
store_id,
COALESCE(department_id, 0) as department_id,
SUM(order_num) AS order_num
FROM
vup.ads_vendor_detail
WHERE
dt = '${dt}'
GROUP BY
store_id,
COALESCE(department_id, 0) GROUPING SETS (
(store_id, COALESCE(department_id, 0)),
(COALESCE(department_id, 0))
);

[melin]

spark 是否支持？