Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
23.02.18
-
None
-
2026-4
Description
Customer claims a new behavior of stuck query, need to investigate
SELECT
|
case when (NVL(TAUOK,0) + TAUFAILURES + NVL(TAUUNKNOWN_COUNT,0)) > 0 then |
case when (NVL(TAUOK,0) + TAUFAILURES + NVL(TAUUNKNOWN_COUNT,0)) > TAUFAILURES then ( TAUFAILURES / (NVL(TAUOK,0) + TAUFAILURES + NVL(TAUUNKNOWN_COUNT,0)))*100 |
else 100 end else 0 end exp1, |
exp2 exp2
|
FROM
|
(
|
SELECT Sum( LTECTCellStats.TAUOK ) TAUOK,
|
Sum( LTECTCellStats.TAUFAILURES ) TAUFAILURES,
|
Sum( LTECTCellStats.TAUUNKNOWN_COUNT ) TAUUNKNOWN_COUNT,
|
Sum( LTECTCellStats.TAUFAILURES ) exp2
|
FROM (SELECT TAUFAILURES, TAUOK, TAUUNKNOWN_COUNT
|
FROM LTE_SPOT_CELLSTATS_HOURLY s
|
WHERE (s.date >= DATE('2026-03-04') AND s.hour >= 2) |
AND (s.date <= DATE('2026-03-04') AND s.hour <= 23) |
AND ServingSectorHandle IN (376238616) AND DeviceID IN (4, 7) ) LTECTCellStats) subquery |
WHERE nvl(TAUFAILURES,0) > 0 |