Window Functions Order By Not working

Hey all,

I have ran across an issue with window functions and I would like to get some feedback on whether it’s a known issue with Dremio.

I am connecting to a Relational DB, running a RANK() function with ORDER BY DESC. Results returned seem to ignore the ordering. I’ve tried ROW_NUMBER() as well with no luck.

My query is:

SELECT IssueType, ActualImpact,

RANK() OVER (PARTITION BY IssueType ORDER BY ActualImpact DESC) issue_rank

FROM Issues

Results returned are not sorted in a descending order!

I have found a similar topic that was opened almost 2 years ago but hoping this is now fixed.

Appreciate any input