Support for 0 ROWS PRECEDING or FOLLOWING

Learn about the change that provides support for 0 ROWS PRECEDING or ROWS FOLLOWING in Window function specifications.

Before upgrade to CDP 7.1.4

The support for '0' as a Window frame boundary in ROWS PRECEDING or ROWS FOLLOWING was removed as part HIVE-12574.

After upgrade to CDP 7.1.4

The Window function specification is enhanced to support a Window frame boundary value of '0' for ROWS PRECEDING and ROWS FOLLOWING, and replaces it with CURRENT ROW in the query plan. The behavior is the same as using 0 ROWS PRECEDING/FOLLOWING.

For more information, see HIVE-23868.