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 WHERE ActualImpact IS NOT NULL
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