这是我在遇到上述错误时尝试提交的自定义sql查询。

SELECT
  comp_type, 
  wm_wk_desc,
  wm_wk_beg_dt, 
  metric_id, 
  metric_nm,
  CAST(SUM(num) AS FLOAT) AS num,
  SUM(denom) AS denom,
  dim
FROM GE004_WM_AD_HOC.bs_scorecard_weekly
GROUP BY 1,2,3,4,5,8