|
有一个report,需要根据日期和订单号查询一些SA_Task表里的东西,使用的时候,经常出现Disk Usage 100%的情况,读写率在10MB/s到100MB/s之间,这时其他人就无法做任何事,不能登录,登录的人也没法跑工作流,直到那个report 跑完为止。但是大多数时候又好好的,几秒钟就跑完这个report了,能否帮忙看下为什么会这样?很紧急,这周昨天今天都出问题了。现在还是有时会出现
KSQL如下:
select OL_OrderMain.fOrderID as fOrderID,SA_Task.sTypeName as sTypeName,SA_Task.sActivityName as sActivityName,SA_Task.sCreatorPersonName as sCreatorPersonName,SA_Task.sCreatorDeptName as sCreatorDeptName,SA_Task.sActualStartTime as sActualStartTime,SA_Task.sActualFinishTime as sActualFinishTime,SA_Task.sCreateTime as sCreateTime,SA_Task.sStatusName as sStatusName,OL_OrderMain.fExecutorID as fExecutorID,SA_Task.sData2 as sData2,SA_Task.sExecutorDeptName as sExecutorDeptName,OL_OrderMain.fCustomerName as fCustomerName
from OL_OrderMain OL_OrderMain
join SA_Task SA_Task on OL_OrderMain = SA_Task.sData1
where ( (OL_OrderMain.fOrderDate >= stringToDate(:p)) AND (OL_OrderMain.fOrderDate <= stringToDate(:q)) ) OR (OL_OrderMain.fOrderID = :r) AND (SA_Task.sExecutorDeptName is not null)
order by OL_OrderMain.fOrderID desc, SA_Task.sActualStartTime asc
|
|