fantasy2100 commented on issue #5179: URL: https://github.com/apache/paimon/issues/5179#issuecomment-2699881774
> > > It is sum... should be 6... > > > > > > sum and last_non_null_value are both aggregate functions. The result of sum is 6, why is the result of last_non_null_value not 3? > > `sum` agg does not care about the order, but `last_non_null_value ` needs. One of the aggregate functions does not care about order, but the other one does. There is no mention in the documentation of which aggregate functions do not care about order. This inconsistency in the aggregate functions is confusing to the user. The ideal approach is to make the behavior of aggregate functions consistent. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
