Presto 337 Documentation

13.155. Release 0.110

13.155. Release 0.110#

General Changes#

  • Fix result truncation bug in window function row_number() when performing a partitioned top-N that chooses the maximum or minimum N rows. For example:

        SELECT row_number() OVER (PARTITION BY orderstatus ORDER BY orderdate) AS rn,
            custkey, orderdate, orderstatus
        FROM orders
    ) WHERE rn <= 5;