COUNTIF was not defined properly. See my response to the other thread (let's continue discussion there to avoid context fragmentation).
On Thu, Nov 12, 2020 at 10:16 AM Ahmet Altay <al...@google.com> wrote: > +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/> >> >