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 <[email protected]> wrote: > +Kenneth Knowles <[email protected]> +Andrew Pilloud <[email protected]> > +Robin > Qiu <[email protected]> > > On Thu, Nov 12, 2020 at 9:32 AM Sonam Ramchand < > [email protected]> 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/> >> >
