select 

 a.workflowname,

round(avg(a.flowtime)/60/60/24,1) as avg_time  

from dwd.t_dwd_workflow_request_flowtime a

where   a.WORKFLOWTYPE<>'1'

' ${if(len(receivemonth) == 0," and A.createmonth='${month}' "," and createmonth = '" + receivemonth+ "'")} 

group by  a.workflowname

order by  round(avg(a.flowtime)/60/60/24,1) desc

严重:11:16:36 http-nio-8075-exec-4 ERROR [standard] 错误代码:11300001 数据集 [t_hp_workflow_type_time] 配置错误出现不支持的 SQL92 标记: 169