06-05-2016 11:48 PM
I am trying to lag a value in Impala while the value is a null. So it must basically lag the value until it hits the next not null value...
from SQL, i found this to work:
ISNULL(Life, (SELECT TOP 1 Life FROM #TempTable WHERE [Row] < t.[Row] AND Life IS NOT NULL ORDER BY [Row] DESC))
Hope you can help with a solution.. i am under a bit of pressure to sort this out...