Hi, Could you please explain the behaviour of SINGLE_VALUE aggregate with the equivalent SQL query?
SqlSingleValueAggFunction (Apache Calcite calcite API) <https://calcite.apache.org/javadocAggregate/org/apache/calcite/sql/fun/SqlSingleValueAggFunction.html> It's not clear whether the "value" in the description refers to an entire table or a cell. Also, there are no samples publicly available for this aggregate function. Regards, Chathura
