Hi, I'm wondering if this is the expected behavior when using last or last_value in a window function? I've written a query like this:select
col1,
col2,
last_value(col2) over (partition by col1 order by col2) as column2_last
from values
...
Agreed. Interesting find that `max` behaves funny when `desc` isn't specified. I'd also note that `first_value` yields the correct result.@Kaniz Fatma Is there a process for filing bugs in Databricks? It'd be great to get this fixed.