question Re: In CDP 7.1.9 , UNBOUNDED FOLLOWING behaves like CURRENT ROW in Support Questions

In CDP 7.1.9 , UNBOUNDED FOLLOWING behaves like CURRENT ROW

ecournarie — Tue, 21 Apr 2026 06:42:26 GMT

Hi everybody,

Testing CDP 7.1.9, looks like we hit a bug in Hive . The "UNBOUNDED FOLLOWING" actually behaves as "CURENT ROW". But only when the other side of the window is "UNBOUNDED PRECEEDING". Did someone hit this one ?

If we change the PRECEEDING, it's ok

Thanks in advance

Re: In CDP 7.1.9 , UNBOUNDED FOLLOWING behaves like CURRENT ROW

VidyaSargur — Mon, 26 Feb 2024 09:10:39 GMT

@ecournarie, Welcome to our community! To help you get the best possible answer, I have tagged in our CDP experts @vaishaakb @rki_ who may be able to assist you further.

Please feel free to provide any additional information or details about your query, and we hope that you will find a satisfactory solution to your question.

Re: In CDP 7.1.9 , UNBOUNDED FOLLOWING behaves like CURRENT ROW

vaishaakb — Fri, 08 Mar 2024 15:46:01 GMT

@ecournarie @VidyaSargur Tagging our Hive expertise @Teens Please help here

Re: In CDP 7.1.9 , UNBOUNDED FOLLOWING behaves like CURRENT ROW

ecournarie — Fri, 08 Mar 2024 15:53:23 GMT

Omit to say, but it was working for 7.1.7 , so that's may be a regression...

Re: In CDP 7.1.9 , UNBOUNDED FOLLOWING behaves like CURRENT ROW

Teens — Tue, 12 Mar 2024 15:37:09 GMT

Thanks @vaishaakb for giving me the opportunity to help @ecournarie

Hello @ecournarie , I did review the fore-mentioned situation, upon checking this seems to be a known issue as per https://issues.apache.org/jira/browse/HIVE-24905 and we have the below workaround,

Can you try disabling vectorization at session level via Beeline and test?
set hive.vectorized.execution.reduce.enabled=false

Thanks,
Tee

Re: In CDP 7.1.9 , UNBOUNDED FOLLOWING behaves like CURRENT ROW

ecournarie — Wed, 13 Mar 2024 12:39:41 GMT

Hi Tee,,

Thanks for taking care. Indeed, the workaround is working, results are correct when disabling vectorization.

This bug looks pretty old, guess not a lot of hope to see it fixed somedays....

Thanks again for your help

Eric