Jonathan Meyer
05/11/2021, 3:14 PMHello
What is the recommended approach to getting the "last non-null value" ?
Use a UDF ?
Kishore G
Jonathan Meyer
05/11/2021, 3:26 PMKishore G
Jonathan Meyer
05/11/2021, 3:28 PMlast
value ?
Not sure that'd be more efficient that wayKishore G
Jonathan Meyer
05/11/2021, 3:31 PMKishore G
Jonathan Meyer
05/11/2021, 3:37 PMnullHandlingEnabled
)
And query like
SELECT value FROM table WHERE value IS NOT NULL ORDER BY date LIMIT 1
Kishore G
Jonathan Meyer
05/11/2021, 3:46 PM