Re: Issue for discussion (slight change in behavior): HIVE-26683

2022-11-22 Thread Pau Tallada
Hi, I agree that for the windowing function, in the absence of any value the sum shall be NULL, not 0. Cheers, Pau. Missatge de Stamatis Zampetakis del dia dt., 22 de nov. 2022 a les 11:26: > Hello, > > Regarding the inconsistency you describe in the window function, indeed it > seems to be a

Re: Issue for discussion (slight change in behavior): HIVE-26683

2022-11-22 Thread Stamatis Zampetakis
Hello, Regarding the inconsistency you describe in the window function, indeed it seems to be a bug. However, I would double-check with the SQL standard to be sure there is no intentional deviation and/or test the query in different DBMS. As far as it concerns the behavior of the aggregate functi