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.