You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by Yash Sharma <ya...@gmail.com> on 2014/09/25 21:00:46 UTC

How to specify the number of arguments in Aggregate functions

Hi Guys,
Can any one point out how to configure the Aggregate function to accept
multiple arguments.

Currently there is a bug injected in covar_pop/covar_samp as part of my
last patch where the covar function accepts only 1 argument. Created
OPTIQ-424 for the same.

Thanks

Re: How to specify the number of arguments in Aggregate functions

Posted by Julian Hyde <ju...@gmail.com>.

The "SqlOperandTypeChecker operandTypeChecker" argument to SqlAggFunction
determines the number and type of arguments that will be accepted. To date
all agg functions have accepted 1 argument (except 'COUNT(*)' which is
really 0 arguments) but it should work. OperandTypes.NUMERIC_NUMERIC might
be what you need.

On Thu, Sep 25, 2014 at 12:00 PM, Yash Sharma <ya...@gmail.com> wrote:

> Hi Guys,
> Can any one point out how to configure the Aggregate function to accept
> multiple arguments.
>
> Currently there is a bug injected in covar_pop/covar_samp as part of my
> last patch where the covar function accepts only 1 argument. Created
> OPTIQ-424 for the same.
>
> Thanks
>