+Kenneth Knowles <k...@google.com> +Andrew Pilloud <apill...@google.com> +Robin Qiu <robi...@google.com>
On Thu, Nov 12, 2020 at 9:32 AM Sonam Ramchand < sonam.ramch...@venturedive.com> wrote: > Hi Devs, > > I am trying to implement the COUNTIF function for Beam SQL ZetaSQL > dialect, as CombineFn. > > Where I try to run the Test query (SELECT COUNTIF(f_long > 0) AS > countif_no FROM PCOLLECTION GROUP BY f_int2), I am getting Exception > Caused by: > org.apache.beam.vendor.calcite.v1_20_0.org.apache.calcite.sql.validate.SqlValidatorException: > No match found for function signature COUNTIF(<BOOLEAN>). > > Can anybody help me in knowing the reason behind this? > > Thank you > > -- > > Regards, > *Sonam* > Software Engineer > Mobile: +92 3088337296 <+92%20308%208337296> > > <http://venturedive.com/> >