UNBOUNDED representation in Window functions

Learn about the implementation change for the ROWS clause of the Window function. The boundary specification has now been updated to consider the UNBOUNDED representation.

Before upgrade to CDP 7.1.4

The implementation of the ROWS clause in Window functions previously considered a bounded representation with the limits set to Integer.MAX_VALUE (2147483647).

After upgrade to CDP 7.1.4

The bounded representation was changed to use UNBOUNDED to align with the RexWindowBound boundary class of the Apache Calcite SQL parser.

For more information, see HIVE-23275.